<html>
<head>
<meta http-equiv="Content-Type" content="text/html; charset=utf-8">
</head>
<body text="#000000" bgcolor="#FFFFFF">
<p>Hello,</p>
<p>run with debug=3 in kamailio.cfg and see in the logs if you get
more hints about happens.<br>
</p>
Cheers,<br>
Daniel<br>
<br>
<div class="moz-cite-prefix">On 18.09.18 00:37, David Villasmil
wrote:<br>
</div>
<blockquote type="cite"
cite="mid:CAFGRPVregF-bcc8bXZzokAauD-JgH0ZHtFa-ixkOfmqRhh8Ucg@mail.gmail.com">
<meta http-equiv="content-type" content="text/html; charset=utf-8">
<p dir="ltr">Hello,</p>
<p dir="ltr">During startup, i only get that one.<br>
I really appreciate your help</p>
<p dir="ltr">David</p>
<br>
<div class="gmail_quote">
<div dir="ltr">On Mon, Sep 17, 2018, 21:04 Henning Westerholt
<<a href="mailto:hw@kamailio.org" moz-do-not-send="true">hw@kamailio.org</a>>
wrote:<br>
</div>
<blockquote class="gmail_quote" style="margin:0 0 0
.8ex;border-left:1px #ccc solid;padding-left:1ex">Am Montag,
17. September 2018, 14:40:43 CEST schrieb David Villasmil:<br>
> Module config:<br>
>
modparam("sqlops","sqlcon","asg=>mysql://DB_USER:DB_PASS@DB_HOST/kamailio")<br>
> Route:<br>
> sql_query("asg", "insert ignore dispatcher (id,
setid, destination,<br>
> flags, priority, attrs, description) values (NULL,
$var(dispatcher_id),<br>
> '<a class="moz-txt-link-freetext" href="sip:$si:5080">sip:$si:5080</a>', 0, 0,
'weight=$var(new_weight);maxload=50', '$fU')");<br>
> xlog("L_ERR", "[ASG_ADD_TO_DISPATCHER] Affected
rows:<br>
> $sqlrows(asg)\n");<br>
> if ($sqlrows(asg)>0) {<br>
> ds_reload();<br>
> } else {<br>
> xlog("L_ERR", "[ASG_ADD_TO_DISPATCHER] COULD
NOT ADD THE NEW<br>
> GATEWAY WITH IP $si AND USERNAME $fU\n");<br>
> }<br>
> <br>
> and i'm getting:<br>
> <br>
> 0(3929) CRITICAL: <core> [core/cfg.y:3447]:
yyerror_at(): parse error in<br>
> config file /etc/kamailio/kamailio.cfg, line 1261, column
20-32: Can't get<br>
> from cache: $sqlrows(asg)<br>
<br>
Hi David,<br>
<br>
do you get this error during startup or during run-time? Is
this the only <br>
error that you get?<br>
<br>
Best regards,<br>
<br>
Henning<br>
<br>
-- <br>
Henning Westerholt<br>
<a href="https://skalatan.de/blog/" rel="noreferrer"
target="_blank" moz-do-not-send="true">https://skalatan.de/blog/</a><br>
</blockquote>
</div>
<br>
<fieldset class="mimeAttachmentHeader"></fieldset>
<br>
<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>
<br>
<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 -- <a class="moz-txt-link-abbreviated" href="http://www.kamailioworld.com">www.kamailioworld.com</a>
Kamailio Advanced Training, Nov 12-14, 2018, in Berlin -- <a class="moz-txt-link-abbreviated" href="http://www.asipto.com">www.asipto.com</a></pre>
</body>
</html>