<html xmlns:v="urn:schemas-microsoft-com:vml" xmlns:o="urn:schemas-microsoft-com:office:office" xmlns:w="urn:schemas-microsoft-com:office:word" xmlns:m="http://schemas.microsoft.com/office/2004/12/omml" xmlns="http://www.w3.org/TR/REC-html40"><head><meta http-equiv=Content-Type content="text/html; charset=us-ascii"><meta name=Generator content="Microsoft Word 15 (filtered medium)"><style><!--
/* Font Definitions */
@font-face
{font-family:"Cambria Math";
panose-1:2 4 5 3 5 4 6 3 2 4;}
@font-face
{font-family:Calibri;
panose-1:2 15 5 2 2 2 4 3 2 4;}
/* Style Definitions */
p.MsoNormal, li.MsoNormal, div.MsoNormal
{margin:0cm;
margin-bottom:.0001pt;
font-size:11.0pt;
font-family:"Calibri",sans-serif;
mso-fareast-language:EN-US;}
a:link, span.MsoHyperlink
{mso-style-priority:99;
color:#0563C1;
text-decoration:underline;}
a:visited, span.MsoHyperlinkFollowed
{mso-style-priority:99;
color:#954F72;
text-decoration:underline;}
span.EmailStyle17
{mso-style-type:personal-compose;
font-family:"Calibri",sans-serif;
color:windowtext;}
.MsoChpDefault
{mso-style-type:export-only;
font-family:"Calibri",sans-serif;
mso-fareast-language:EN-US;}
@page WordSection1
{size:612.0pt 792.0pt;
margin:70.85pt 3.0cm 70.85pt 3.0cm;}
div.WordSection1
{page:WordSection1;}
--></style><!--[if gte mso 9]><xml>
<o:shapedefaults v:ext="edit" spidmax="1026" />
</xml><![endif]--><!--[if gte mso 9]><xml>
<o:shapelayout v:ext="edit">
<o:idmap v:ext="edit" data="1" />
</o:shapelayout></xml><![endif]--></head><body lang=PT-BR link="#0563C1" vlink="#954F72"><div class=WordSection1><p class=MsoNormal><span lang=EN-US>Hi,<o:p></o:p></span></p><p class=MsoNormal><span lang=EN-US>I am new at Kamailio, I have installed a vicidial goautodial box and having some headaches.<o:p></o:p></span></p><p class=MsoNormal><span lang=EN-US>I can see at starup logs the following message:<o:p></o:p></span></p><p class=MsoNormal><span lang=EN-US><o:p> </o:p></span></p><p class=MsoNormal><span lang=EN-US>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")<o:p></o:p></span></p><p class=MsoNormal><span lang=EN-US>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<o:p></o:p></span></p><p class=MsoNormal><span lang=EN-US>Mar 18 02:12:34 edialer1 /usr/sbin/kamailio[4028]: ERROR: usrloc [dlist.c:654]: register_udomain(): failed to open database connection<o:p></o:p></span></p><p class=MsoNormal><span lang=EN-US><o:p> </o:p></span></p><p class=MsoNormal><span lang=EN-US><o:p> </o:p></span></p><p class=MsoNormal><span lang=EN-US>However if I execute the following command:<o:p></o:p></span></p><p class=MsoNormal><span lang=EN-US>[root@edialer1 kamailio]# kamctl db show subscriber<o:p></o:p></span></p><p class=MsoNormal><span lang=EN-US>database engine 'MYSQL' loaded<o:p></o:p></span></p><p class=MsoNormal><span lang=EN-US>Control engine 'RPCFIFO' loaded<o:p></o:p></span></p><p class=MsoNormal><span lang=EN-US>+----+------------+----------------------------+----------+---------------+----------------------------------+----------------------------------+------+<o:p></o:p></span></p><p class=MsoNormal><span lang=EN-US>| id | username | domain | password | email_address | ha1 | ha1b | rpid |<o:p></o:p></span></p><p class=MsoNormal><span lang=EN-US>+----+------------+----------------------------+----------+---------------+----------------------------------+----------------------------------+------+<o:p></o:p></span></p><p class=MsoNormal><span lang=EN-US>| 18 | 5474470533 | vaglxc01.goautodial.com | | NULL | 10685ad93a251bb460e7dd544a174288 | 1680d2aebe5f750c4eedb45ad6b5ba4f | NULL |<o:p></o:p></span></p><p class=MsoNormal><span lang=EN-US>| 20 | 5505791853 | edialer1.gevolution.com.br | | NULL | 04e377e3923716fb5038b0caa79b8ed3 | d65362c7ccd934f00efa21c45e479ec5 | NULL |<o:p></o:p></span></p><p class=MsoNormal><span lang=EN-US>| 21 | 2347600834 | edialer1.gevolution.com.br | | NULL | 065fc461faa06cec682213cf17352630 | 4d79bc7db16f74d13d1785dafb30391c | NULL |<o:p></o:p></span></p><p class=MsoNormal><span lang=EN-US>+----+------------+----------------------------+----------+---------------+----------------------------------+----------------------------------+------+<o:p></o:p></span></p><p class=MsoNormal><span lang=EN-US><o:p> </o:p></span></p><p class=MsoNormal><span lang=EN-US><o:p> </o:p></span></p><p class=MsoNormal><span lang=EN-US>I get a DB response…so is Kamailio actually connected to the db or not?<o:p></o:p></span></p><p class=MsoNormal><span lang=EN-US>Also at logs I get <o:p></o:p></span></p><p class=MsoNormal><span lang=EN-US><o:p> </o:p></span></p><p class=MsoNormal><span lang=EN-US>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<o:p></o:p></span></p><p class=MsoNormal><span lang=EN-US><o:p> </o:p></span></p><p class=MsoNormal><span lang=EN-US>So I assume it read from the DB something…This is quite confusing as can’t say properly if it is working or not.<o:p></o:p></span></p><p class=MsoNormal><span lang=EN-US>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.<o:p></o:p></span></p><p class=MsoNormal><span lang=EN-US><o:p> </o:p></span></p><p class=MsoNormal><span lang=EN-US>Can you please help me to figure this out?<o:p></o:p></span></p><p class=MsoNormal><span lang=EN-US>Thanks in advance<o:p></o:p></span></p></div></body></html>