Kamailio initial log - Mysql error - sr-users

17 Mar 2019

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