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

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@kamailio.org mailto:hw@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@lists.kamailio.org https://lists.kamailio.org/cgi-bin/mailman/listinfo/sr-users