Asterisk 1.8.9 mysql database connection problem

[ilvista]

hi
i’ve a problem connecting asterisk to mysql database .
here is my logs

*CLI> realtime mysql status
general configured for asterisk on socket file /var/lib/mysql/mysql.sock with username asterisk.
*CLI> [Aug 11 10:49:29] ERROR[25236]: res_config_mysql.c:1599 mysql_reconnect: MySQL RealTime: Failed to connect database server asterisk on /var/lib/mysql/mysql.sock (err 1045). Check debug for more info.

*CLI> module load res_config_mysql.so
[Aug 11 10:33:15] WARNING[25236]: res_config_mysql.c:1484 load_mysql_config: MySQL RealTime: No database user found, using ‘asterisk’ as default.
[Aug 11 10:33:15] WARNING[25236]: res_config_mysql.c:1490 load_mysql_config: MySQL RealTime: No database password found, using ‘asterisk’ as default.
[Aug 11 10:33:15] WARNING[25236]: res_config_mysql.c:1496 load_mysql_config: MySQL RealTime: No database host found, using localhost via socket.
[Aug 11 10:33:15] WARNING[25236]: res_config_mysql.c:1502 load_mysql_config: MySQL RealTime: No database name found, using ‘asterisk’ as default.
[Aug 11 10:33:15] WARNING[25236]: res_config_mysql.c:1508 load_mysql_config: MySQL RealTime: No database port found, using 3306 as default.
[Aug 11 10:33:15] WARNING[25236]: res_config_mysql.c:1520 load_mysql_config: MySQL RealTime: No database socket found, using ‘/var/lib/mysql/mysql.sock’ as default.
Loaded res_config_mysql.so
[Aug 11 10:33:15] WARNING[25236]: res_config_mysql.c:1525 load_mysql_config: MySQL RealTime: No database socket found (and unable to detect a suitable path).
*CLI> [Aug 11 10:33:15] NOTICE[25236]: config.c:2199 ast_config_engine_register: Registered Config Engine mysql

any ideas guys ???

my config files
res_mysql.conf

[general]
dbhost = 127.0.0.1
dbname = asterisk
dbuser = asterisk
dbpass = joco15
dbport = 3306
dbsock = /var/lib/mysql/mysql.sock

extconfig.conf

[settings]
sipusers => mysql,asterisk,sip_buddies
sippeers => mysql,asterisk,sip_buddies

mysqld is up and runing and i can access my database tables without any problem using mysql client.
the exact same configuration used to work for asterisk 1.4 .

[ilvista]

I figured it out
mysql-devel was not not installed ,now it’s working perfectly