[SR-Users] Can't get from cache: $sqlrows(asg)

Daniel-Constantin Mierla miconda at gmail.com
Tue Sep 18 08:28:28 CEST 2018


Hello,

run with debug=3 in kamailio.cfg and see in the logs if you get more
hints about happens.

Cheers,
Daniel

On 18.09.18 00:37, David Villasmil wrote:
>
> Hello,
>
> During startup, i only get that one.
> I really appreciate your help
>
> David
>
>
> On Mon, Sep 17, 2018, 21:04 Henning Westerholt <hw at kamailio.org
> <mailto:hw at kamailio.org>> wrote:
>
>     Am Montag, 17. September 2018, 14:40:43 CEST schrieb David Villasmil:
>     > Module config:
>     >
>     modparam("sqlops","sqlcon","asg=>mysql://DB_USER:DB_PASS@DB_HOST/kamailio")
>     > Route:
>     >         sql_query("asg", "insert ignore dispatcher (id, setid,
>     destination,
>     > flags, priority, attrs, description) values (NULL,
>     $var(dispatcher_id),
>     > 'sip:$si:5080', 0, 0, 'weight=$var(new_weight);maxload=50',
>     '$fU')");
>     >         xlog("L_ERR", "[ASG_ADD_TO_DISPATCHER] Affected rows:
>     > $sqlrows(asg)\n");
>     >         if ($sqlrows(asg)>0) {
>     >             ds_reload();
>     >         } else {
>     >             xlog("L_ERR", "[ASG_ADD_TO_DISPATCHER] COULD NOT ADD
>     THE NEW
>     > GATEWAY WITH IP $si AND USERNAME $fU\n");
>     >         }
>     >
>     > and i'm getting:
>     >
>     >  0(3929) CRITICAL: <core> [core/cfg.y:3447]: yyerror_at(): parse
>     error in
>     > config file /etc/kamailio/kamailio.cfg, line 1261, column 20-32:
>     Can't get
>     > from cache: $sqlrows(asg)
>
>     Hi David,
>
>     do you get this error during startup or during run-time? Is this
>     the only
>     error that you get?
>
>     Best regards,
>
>     Henning
>
>     -- 
>     Henning Westerholt
>     https://skalatan.de/blog/
>
>
>
> _______________________________________________
> 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 -- www.kamailioworld.com
Kamailio Advanced Training, Nov 12-14, 2018, in Berlin -- www.asipto.com

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


More information about the sr-users mailing list