17 Sep
2018
17 Sep
'18
8:40 a.m.
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(a)gmail.com
phone: +34669448337
ᐧ
17 Sep
17 Sep
4:04 p.m.
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/
6:37 p.m.
Hello,
During startup, i only get that one.
I really appreciate your help
David
On Mon, Sep 17, 2018, 21:04 Henning Westerholt <hw(a)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/
18 Sep
18 Sep
2:28 a.m.
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(a)kamailio.org
<mailto:hw@kamailio.org>> wrote:
Am Montag, 17. September 2018, 14:40:43 CEST schrieb David Villasmil:
--
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
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(a)lists.kamailio.org
https://lists.kamailio.org/cgi-bin/mailman/listinfo/sr-users
5:27 p.m.
Hello Guys,
My mistake, it was enclosed on an #!ifdef
Regards,
David Villasmil
email: david.villasmil.work(a)gmail.com
phone: +34669448337
ᐧ
On Tue, Sep 18, 2018 at 7:28 AM Daniel-Constantin Mierla <miconda(a)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(a)kamailio.org> wrote:
Am Montag, 17. September 2018, 14:40:43 CEST
schrieb David Villasmil:
_______________________________________________
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
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/
2345
days inactive
2346
days old
4 comments
3 participants
participants (3)
-
Daniel-Constantin Mierla -
David Villasmil -
Henning Westerholt