Fixing asterisk addons in Ubuntu Part 2

In an older post i have shown a way to fix the following error

Module 'app_addon_sql_mysql.so' was not compiled with the same compile-time options as this version of Asterisk.

which shows up if you try to load the mysql app in asterisk so you can store the cdr in a mysql db or access mysql from within your diaplan.

There seems to be a 'nicer' way to do it, using the debian package system itself and not having to copy files around.

Here is what you need to do

First cd to a temporary directory as this procedure will download some files and generate several deb files
As root (or use sudo) issue the following commands

aptitude purge asterisk-mysql
apt-get build-dep asterisk-mysql
apt-get -b source asterisk-mysql

Once the last command finishes you will have ended up with a number of deb files.
Then issue

dpkg -i asterisk-mysql_1.6.2.0-1_i386.deb 

The version number and architecture might be different so check yours

And that's all. No copying files around