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