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