Hello, kamclt is not using kamailio to go to the database. Based on the log message, kamailio is not connected to database. There is some misconfiguration there, trying to use a unix socket file for mysql server which does not exist.
Cheers, Daniel On 18.03.19 03:48, Jorge Cornejo wrote: > > 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 > [email protected] > https://lists.kamailio.org/cgi-bin/mailman/listinfo/sr-users -- Daniel-Constantin Mierla -- www.asipto.com www.twitter.com/miconda -- www.linkedin.com/in/miconda Kamailio World Conference - May 6-8, 2019 -- www.kamailioworld.com Kamailio Advanced Training - Mar 25-27, 2019, in Washington, DC, USA -- www.asipto.com
_______________________________________________ Kamailio (SER) - Users Mailing List [email protected] https://lists.kamailio.org/cgi-bin/mailman/listinfo/sr-users
