Hello guys,
i've got this in my config:
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)
I can't figure out where the problem might be.
Can anyone help?
Regards,
David Villasmil email: david.villasmil.work@gmail.com phone: +34669448337 ᐧ
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
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 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/
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
Hello Guys,
My mistake, it was enclosed on an #!ifdef
Regards,
David Villasmil email: david.villasmil.work@gmail.com phone: +34669448337
ᐧ
On Tue, Sep 18, 2018 at 7:28 AM Daniel-Constantin Mierla miconda@gmail.com wrote:
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 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 Listsr-users@lists.kamailio.orghttps://lists.kamailio.org/cgi-bin/mailman/listinfo/sr-users
-- Daniel-Constantin Mierla -- www.asipto.comwww.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
-
Daniel-Constantin Mierla -
David Villasmil -
Henning Westerholt