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 220.127.116.11, 18.104.22.168-patch and 22.214.171.124-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 126.96.36.199-x86_64-linode5 kernel
Currently have Asterisk 188.8.131.52, DAHDI 184.108.40.206 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:
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
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.
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?