[SR-Users] Kamailio initial log - Mysql error

[Daniel-Constantin Mierla]

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 at 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
> sr-users at lists.kamailio.org
> 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

-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.kamailio.org/pipermail/sr-users/attachments/20190322/4f8f64a1/attachment.html>