Can't compile asterisk-addons with mysql - help?

Asterisk Asterisk Support
1

Hi there everybody,

I’m having a hard time getting asterisk-addons to compile with mysql CDR support which I need to enable Realtime I believe. I’ve spent the whole day trying to fault find this one (including thinking I had ruined my box and creating a new CentOS build!) and am pretty worn out. Anyhelp would be gratefully appreciated!

When I attempt to install asterisk-addons (I’ve tried 1.6.0.1, 1.6.0.1-patch and 1.6.1.0-rc3), I get the following line in a ./configure:

checking for mysql_config… /usr/bin/mysql_config
checking for mysql_init in -lmysqlclient… no

Then when I do a make menuselect, MySQL is not selectable and XXX"d out:
XXX app_addon_sql_mysql (etc)

and at the bottom
Depends on: mysqlclient(E)

My circumstances: A linode-hosted xen-based VPS box.
Centos 5.2 running the 2.6.28.3-x86_64-linode5 kernel
Currently have Asterisk 1.6.0.6, DAHDI 2.1.0.4 installed and working fine.

Per voip-info.org/wiki/view/Cent … stallation I have gone and installed mysql-devel, mysql and a couple of other packages that have resulted in the following installed packages:

Installed Packages
mysql.x86_64 5.0.45-7.el5 installed
mysql.i386 5.0.45-7.el5 installed
mysql-connector-odbc.x86_64 3.51.12-2.2 installed
mysql-devel.x86_64 5.0.45-7.el5 installed
mysql-devel.i386 5.0.45-7.el5 installed
mysql-server.x86_64 5.0.45-7.el5 installed

#rpm -qa | grep mysql
mysql-devel-5.0.45-7.el5
mysql-connector-odbc-3.51.12-2.2
mysql-5.0.45-7.el5
mysql-server-5.0.45-7.el5
php-mysql-5.1.6-20.el5_2.1
mysql-devel-5.0.45-7.el5
perl-DBD-mysql-4.010-1.el5.rf
mysql-5.0.45-7.el5

OK, so we can assume MySQL is running and looks happy:

#ps aux | grep mysql
root 18569 0.0 0.2 65932 992 ? S Mar28 0:00 /bin/sh /usr/bin/mysqld_safe --datadir=/var/lib/mysql --socket=/var/lib/mysql/mysql.sock --log-error=/var/log/mysqld.log --pid-file=/var/run/mysqld/mysqld.pid
mysql 18632 0.0 5.2 163644 18524 ? Sl Mar28 0:06 /usr/libexec/mysqld --basedir=/usr --datadir=/var/lib/mysql --user=mysql --pid-file=/var/run/mysqld/mysqld.pid --skip-external-locking --socket=/var/lib/mysql/mysql.sock

And I can log in (no password set yet)
#mysql -u root
Welcome to the MySQL monitor. Commands end with ; or \g.
Your MySQL connection id is 5
Server version: 5.0.45 Source distribution
Type ‘help;’ or ‘\h’ for help. Type ‘\c’ to clear the buffer.
mysql>

I’ve also tried throwing various things at the --with-mysqlclient= configure parameter but with no joy. These include /usr/lib64/mysql/, /usr/lib/mysql/, /usr, /usr/bin, and even the first two but with a symbolic link called ‘bin’ within each pointing to /usr/bin. Nothing works.

So yeah, I’m really, really frustrated and kinda wish I could get my day back …does anybody have any ideas?

Thanks!

2

[quote=“boxdog”]Hi there everybody,

I’m having a hard time getting asterisk-addons to compile with mysql CDR support which I need to enable Realtime I believe. I’ve spent the whole day trying to fault find this one (including thinking I had ruined my box and creating a new CentOS build!) and am pretty worn out. Anyhelp would be gratefully appreciated!

When I attempt to install asterisk-addons (I’ve tried 1.6.0.1, 1.6.0.1-patch and 1.6.1.0-rc3), I get the following line in a ./configure:

checking for mysql_config… /usr/bin/mysql_config
checking for mysql_init in -lmysqlclient… no

Then when I do a make menuselect, MySQL is not selectable and XXX"d out:
XXX app_addon_sql_mysql (etc)

and at the bottom
Depends on: mysqlclient(E)

Installed Packages
mysql.x86_64 5.0.45-7.el5 installed
mysql.i386 5.0.45-7.el5 installed
mysql-connector-odbc.x86_64 3.51.12-2.2 installed
mysql-devel.x86_64 5.0.45-7.el5 installed
mysql-devel.i386 5.0.45-7.el5 installed
mysql-server.x86_64 5.0.45-7.el5 installed

#rpm -qa | grep mysql
mysql-devel-5.0.45-7.el5
mysql-connector-odbc-3.51.12-2.2
mysql-5.0.45-7.el5
mysql-server-5.0.45-7.el5
php-mysql-5.1.6-20.el5_2.1
mysql-devel-5.0.45-7.el5
perl-DBD-mysql-4.010-1.el5.rf
mysql-5.0.45-7.el5

So yeah, I’m really, really frustrated and kinda wish I could get my day back …does anybody have any ideas?

Thanks![/quote]

I had the same trouble 2 week ago, but on a Ubuntu 8.10.
It’s solved by installing: libmysqlclient-dev
When I run “apt-get install libmysqlclient-dev” it’s turn out that this package not availeable anymore.
But there is this package: “libmysqlclient15-dev” instead, and when I ran this:
“apt-get install libmysqlclient15-dev” everything works fine.
I could then run make menuselect and mark Mysql

3

Thanks for the reply. According to centos.org/modules/newbb/vie … c_id=11861, libmysqlclient15-dev comes as part of mysql-dev which is definitly installed. Maybe I have an out of date version? Should I update to a newer version using the c5-testing or remi repos? Or even better is there a seperate RPM that installs whatever asterisk-addons is looking for?

4

Just fired up the CentOS 5.2 box I use here at home in the garage and had a look at its config. Turns out it had the remi repo installed…along with a mysterious package that doesnt appear on the normal CentOS libs:

Installed Packages
mysql.i386 5.1.31-1.el5.remi installed
mysql-connector-odbc.i386 3.51.12-2.2 installed
mysql-devel.i386 5.1.31-1.el5.remi installed
—> mysql-libs.i386 5.1.31-1.el5.remi installed
mysql-server.i386 5.1.31-1.el5.remi installed
mysqlclient15.i386 5.0.67-1.el5.remi installed

And, of course, a configure shows…
checking for mysql_config… /usr/bin/mysql_config
checking for mysql_init in -lmysqlclient… yes

along with a menuselect allowing mysql to be selected!

Maybe I should throw mysql on the linode box with remi …

5

Worked out the problem, or at least a workaround, by simply creating a fresh install of the i386 (non x64) version of Centos. Obviously something isnt right in the land of MySQL and 64 bit processing!