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