<html>
<head>
<meta http-equiv="Content-Type" content="text/html;
charset=windows-1252">
</head>
<body text="#000000" bgcolor="#FFFFFF">
<p>Hello,</p>
<p>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.</p>
<p>Cheers,<br>
Daniel<br>
</p>
<div class="moz-cite-prefix">On 18.03.19 03:48, Jorge Cornejo wrote:<br>
</div>
<blockquote type="cite"
cite="mid:001801d4dd35$018bc790$04a356b0$@gevolution.com.br">
<meta http-equiv="Content-Type" content="text/html;
charset=windows-1252">
<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]-->
<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>
<br>
<fieldset class="mimeAttachmentHeader"></fieldset>
<pre class="moz-quote-pre" wrap="">_______________________________________________
Kamailio (SER) - Users Mailing List
<a class="moz-txt-link-abbreviated" href="mailto:sr-users@lists.kamailio.org">sr-users@lists.kamailio.org</a>
<a class="moz-txt-link-freetext" href="https://lists.kamailio.org/cgi-bin/mailman/listinfo/sr-users">https://lists.kamailio.org/cgi-bin/mailman/listinfo/sr-users</a>
</pre>
</blockquote>
<pre class="moz-signature" cols="72">--
Daniel-Constantin Mierla -- <a class="moz-txt-link-abbreviated" href="http://www.asipto.com">www.asipto.com</a>
<a class="moz-txt-link-abbreviated" href="http://www.twitter.com/miconda">www.twitter.com/miconda</a> -- <a class="moz-txt-link-abbreviated" href="http://www.linkedin.com/in/miconda">www.linkedin.com/in/miconda</a>
Kamailio World Conference - May 6-8, 2019 -- <a class="moz-txt-link-abbreviated" href="http://www.kamailioworld.com">www.kamailioworld.com</a>
Kamailio Advanced Training - Mar 25-27, 2019, in Washington, DC, USA -- <a class="moz-txt-link-abbreviated" href="http://www.asipto.com">www.asipto.com</a></pre>
</body>
</html>