Re: [SR-Users] Kamailio initial log - Mysql error

Hi, I am new at Kamailio, I have installed a vicidial goautodial box and having some headaches. I can see at starup logs the following message:   Mar 18 02:12:34 edialer1 /usr/sbin/kamailio[4028]: ERROR: db_mysql [km_my_con.c:129]: db_mysql_new_connection(): driver error: Can't connect to local MySQL server through socket '/var/lib/mysql/mysql.sock' (2 "No such file or directory") Mar 18 02:12:34 edialer1 /usr/sbin/kamailio[4028]: ERROR: <core> [db.c:318]: db_do_init2(): could not add connection to the pool Mar 18 02:12:34 edialer1 /usr/sbin/kamailio[4028]: ERROR: usrloc [dlist.c:654]: register_udomain(): failed to open database connection     However if I execute the following command: [root@edialer1 kamailio]# kamctl db show subscriber database engine 'MYSQL' loaded Control engine 'RPCFIFO' loaded +----+------------+----------------------------+----------+---------------+----------------------------------+----------------------------------+------+ | id | username   | domain                     | password | email_address | ha1                              | ha1b                             | rpid | +----+------------+----------------------------+----------+---------------+----------------------------------+----------------------------------+------+ | 18 | 5474470533 | vaglxc01.goautodial.com    |          | NULL          | 10685ad93a251bb460e7dd544a174288 | 1680d2aebe5f750c4eedb45ad6b5ba4f | NULL | | 20 | 5505791853 | edialer1.gevolution.com.br |          | NULL          | 04e377e3923716fb5038b0caa79b8ed3 | d65362c7ccd934f00efa21c45e479ec5 | NULL | | 21 | 2347600834 | edialer1.gevolution.com.br |          | NULL          | 065fc461faa06cec682213cf17352630 | 4d79bc7db16f74d13d1785dafb30391c | NULL | +----+------------+----------------------------+----------+---------------+----------------------------------+----------------------------------+------+     I get a DB response…so is Kamailio actually connected to the db or not? Also at logs I get   Mar 18 02:13:35 edialer1 /usr/sbin/kamailio[4513]: DEBUG: db_mysql [km_res.c:66]: db_mysql_get_columns(): 1 columns returned from the query   So I assume it read from the DB something…This is quite confusing as can’t say properly if it is working or not. Why I am not sure? Because can’t see any information on it sending information to asterisk listening on port 5070, logs won’t show such action. As I can’t find the asterisk information at the kamailio.cfg file, I assume it is stored at the DB, and if DB connection is broken, would explain why it doesn’t work.   Can you please help me to figure this out? Thanks in advance _______________________________________________ Kamailio (SER) - Users Mailing List sr-users(a)lists.kamailio.org https://lists.kamailio.org/cgi-bin/mailman/listinfo/sr-users