26 Sep
2017
26 Sep
'17
2:40 p.m.
Hello all,
I've been trying to utilise event_route[htable:mod-init] in order to load
information from the database into an htable on startup. However, Kamailio
exits with an error for no obvious (to me) reason. Here's the log output:
DEBUG: htable [htable.c:226]: child_init(): rank is (-127)
DEBUG: htable [htable.c:259]: child_init(): executing
event_route[htable:mod-init] (2)
DEBUG: <core> [core/parser/msg_parser.c:600]: parse_msg(): SIP Request:
DEBUG: <core> [core/parser/msg_parser.c:602]: parse_msg(): method:
<OPTIONS>
DEBUG: <core> [core/parser/msg_parser.c:604]: parse_msg(): uri: <
sip:you@kamailio.org>
DEBUG: <core> [core/parser/msg_parser.c:606]: parse_msg(): version:
<SIP/2.0>
DEBUG: <core> [core/parser/parse_via.c:2639]: parse_via(): end of header
reached, state=2
DEBUG: <core> [core/parser/msg_parser.c:491]: parse_headers(): Via found,
flags=2
DEBUG: <core> [core/parser/msg_parser.c:493]: parse_headers(): this is the
first via
ERROR: <core> [core/daemonize.c:303]: daemonize(): Main process exited
before writing to pipe
And here's the routing block in kamailio.cfg. What I need to do is get the
username for all non-expired contacts in the "location" table, perform a
query on another database for each one of them and store the result in an
htable:
event_route[htable:mod-init] {
sql_pvquery("ck", "select username from location where now() <=
expires", "$avp(registered_ng)");
$var(i) = 0;
while ( $(avp(registered_ng)[$var(i)]) != $null ) {
sql_pvquery("ca", "select property from tablename where username =
$(avp(registered_ng)[$var(i)])", "$var(ng_property)");
$sht(isnguser=>$var(ng_property)) = 1;
$var(i) = $var(i) + 1;
pv_unset("$var(ng_property)");
}
pv_unset("$var(i)");
}
Any hints as to what I might be doing wrong? Thanks!
Best regards,
George
26 Sep
26 Sep
3:37 p.m.
New subject: Kamailio htable mod-init route: Main process exited before writing to pipe
I forgot to mention, I'm using Kamailio 5.0.3 on debian "stretch".
On 26 September 2017 at 14:40, George Diamantopoulos <georgediam(a)gmail.com>
wrote:
Hello all,
I've been trying to utilise event_route[htable:mod-init] in order to load
information from the database into an htable on startup. However, Kamailio
exits with an error for no obvious (to me) reason. Here's the log output:
DEBUG: htable [htable.c:226]: child_init(): rank is (-127)
DEBUG: htable [htable.c:259]: child_init(): executing
event_route[htable:mod-init] (2)
DEBUG: <core> [core/parser/msg_parser.c:600]: parse_msg(): SIP Request:
DEBUG: <core> [core/parser/msg_parser.c:602]: parse_msg(): method:
<OPTIONS>
DEBUG: <core> [core/parser/msg_parser.c:604]: parse_msg(): uri: <
sip:you@kamailio.org>
DEBUG: <core> [core/parser/msg_parser.c:606]: parse_msg(): version:
<SIP/2.0>
DEBUG: <core> [core/parser/parse_via.c:2639]: parse_via(): end of header
reached, state=2
DEBUG: <core> [core/parser/msg_parser.c:491]: parse_headers(): Via found,
flags=2
DEBUG: <core> [core/parser/msg_parser.c:493]: parse_headers(): this is
the first via
ERROR: <core> [core/daemonize.c:303]: daemonize(): Main process exited
before writing to pipe
And here's the routing block in kamailio.cfg. What I need to do is get the
username for all non-expired contacts in the "location" table, perform a
query on another database for each one of them and store the result in an
htable:
event_route[htable:mod-init] {
sql_pvquery("ck", "select username from location where now() <=
expires", "$avp(registered_ng)");
$var(i) = 0;
while ( $(avp(registered_ng)[$var(i)]) != $null ) {
sql_pvquery("ca", "select property from tablename where username
=
$(avp(registered_ng)[$var(i)])", "$var(ng_property)");
$sht(isnguser=>$var(ng_property)) = 1;
$var(i) = $var(i) + 1;
pv_unset("$var(ng_property)");
}
pv_unset("$var(i)");
}
Any hints as to what I might be doing wrong? Thanks!
Best regards,
George
28 Sep
28 Sep
8:18 p.m.
New subject: Kamailio htable mod-init route: Main process exited before writing to pipe
Hello,
I've tested again, this time including a single sql_pvquery function in the
event-route. Kamailio will also exit with "daemonize(): Main process exited
before writing to pipe" in this simpler case.
In the documentation, it is stated that: The event route is executed only
once, after core and module initialization, <emphasis>but before Kamailio
forks any child processes</emphasis>.
Does this mean that I don't have (perhaps) access to pseudovariables
during execution of this route? Is this the reason why kamailio exits
prematurely?
Thanks,
George
On 26 September 2017 at 15:37, George Diamantopoulos <georgediam(a)gmail.com>
wrote:
I forgot to mention, I'm using Kamailio 5.0.3 on
debian "stretch".
On 26 September 2017 at 14:40, George Diamantopoulos <georgediam(a)gmail.com
wrote:
Hello all,
I've been trying to utilise event_route[htable:mod-init] in order to load
information from the database into an htable on startup. However, Kamailio
exits with an error for no obvious (to me) reason. Here's the log output:
DEBUG: htable [htable.c:226]: child_init(): rank is (-127)
DEBUG: htable [htable.c:259]: child_init(): executing
event_route[htable:mod-init] (2)
DEBUG: <core> [core/parser/msg_parser.c:600]: parse_msg(): SIP Request:
DEBUG: <core> [core/parser/msg_parser.c:602]: parse_msg(): method:
<OPTIONS>
DEBUG: <core> [core/parser/msg_parser.c:604]: parse_msg(): uri: <
sip:you@kamailio.org>
DEBUG: <core> [core/parser/msg_parser.c:606]: parse_msg(): version:
<SIP/2.0>
DEBUG: <core> [core/parser/parse_via.c:2639]: parse_via(): end of header
reached, state=2
DEBUG: <core> [core/parser/msg_parser.c:491]: parse_headers(): Via
found, flags=2
DEBUG: <core> [core/parser/msg_parser.c:493]: parse_headers(): this is
the first via
ERROR: <core> [core/daemonize.c:303]: daemonize(): Main process exited
before writing to pipe
And here's the routing block in kamailio.cfg. What I need to do is get
the username for all non-expired contacts in the "location" table, perform
a query on another database for each one of them and store the result in an
htable:
event_route[htable:mod-init] {
sql_pvquery("ck", "select username from location where now() <=
expires", "$avp(registered_ng)");
$var(i) = 0;
while ( $(avp(registered_ng)[$var(i)]) != $null ) {
sql_pvquery("ca", "select property from tablename where username
= $(avp(registered_ng)[$var(i)])", "$var(ng_property)");
$sht(isnguser=>$var(ng_property)) = 1;
$var(i) = $var(i) + 1;
pv_unset("$var(ng_property)");
}
pv_unset("$var(i)");
}
Any hints as to what I might be doing wrong? Thanks!
Best regards,
George
10:18 p.m.
New subject: Kamailio htable mod-init route: Main process exited before writing to pipe
Also, I' found this post by Daniel in 2014:
https://lists.kamailio.org/pipermail/sr-users/2014-May/083155.html
To quote:
Indeed, the db connection is not initialized at the
time of executing
event_route[htable:mod-init]. This is executed after all modules are
initialized, but the sqlops connections are initialized in child init.
So maybe this is the case for 5.0.3 as well? sqlops functions can't be used
in event_route[htable:mod-init] yet?
On 28 September 2017 at 20:18, George Diamantopoulos <georgediam(a)gmail.com>
wrote:
Hello,
I've tested again, this time including a single sql_pvquery function in
the event-route. Kamailio will also exit with "daemonize(): Main process
exited before writing to pipe" in this simpler case.
In the documentation, it is stated that: The event route is executed only
once, after core and module initialization, <emphasis>but before Kamailio
forks any child processes</emphasis>.
Does this mean that I don't have (perhaps) access to pseudovariables during execution
of this route? Is this the reason why kamailio exits prematurely?
Thanks,
George
On 26 September 2017 at 15:37, George Diamantopoulos <georgediam(a)gmail.com
wrote:
I forgot to mention, I'm using Kamailio 5.0.3
on debian "stretch".
On 26 September 2017 at 14:40, George Diamantopoulos <
georgediam(a)gmail.com> wrote:
Hello all,
I've been trying to utilise event_route[htable:mod-init] in order to
load information from the database into an htable on startup. However,
Kamailio exits with an error for no obvious (to me) reason. Here's the log
output:
DEBUG: htable [htable.c:226]: child_init(): rank is (-127)
DEBUG: htable [htable.c:259]: child_init(): executing
event_route[htable:mod-init] (2)
DEBUG: <core> [core/parser/msg_parser.c:600]: parse_msg(): SIP Request:
DEBUG: <core> [core/parser/msg_parser.c:602]: parse_msg(): method:
<OPTIONS>
DEBUG: <core> [core/parser/msg_parser.c:604]: parse_msg(): uri: <
sip:you@kamailio.org>
DEBUG: <core> [core/parser/msg_parser.c:606]: parse_msg(): version:
<SIP/2.0>
DEBUG: <core> [core/parser/parse_via.c:2639]: parse_via(): end of
header reached, state=2
DEBUG: <core> [core/parser/msg_parser.c:491]: parse_headers(): Via
found, flags=2
DEBUG: <core> [core/parser/msg_parser.c:493]: parse_headers(): this is
the first via
ERROR: <core> [core/daemonize.c:303]: daemonize(): Main process exited
before writing to pipe
And here's the routing block in kamailio.cfg. What I need to do is get
the username for all non-expired contacts in the "location" table, perform
a query on another database for each one of them and store the result in an
htable:
event_route[htable:mod-init] {
sql_pvquery("ck", "select username from location where now() <=
expires", "$avp(registered_ng)");
$var(i) = 0;
while ( $(avp(registered_ng)[$var(i)]) != $null ) {
sql_pvquery("ca", "select property from tablename where username
= $(avp(registered_ng)[$var(i)])", "$var(ng_property)");
$sht(isnguser=>$var(ng_property)) = 1;
$var(i) = $var(i) + 1;
pv_unset("$var(ng_property)");
}
pv_unset("$var(i)");
}
Any hints as to what I might be doing wrong? Thanks!
Best regards,
George
11:14 p.m.
New subject: Kamailio htable mod-init route: Main process exited before writing to pipe
Never mind, I'm certain by now:
http://sip-router.1086192.n5.nabble.com/DB-select-htable-mod-init-doesn-t-w…
https://lists.kamailio.org/pipermail/sr-dev/2013-February/018484.html
On 28 September 2017 at 22:18, George Diamantopoulos <georgediam(a)gmail.com>
wrote:
Also, I' found this post by Daniel in 2014:
https://lists.kamailio.org/pipermail/sr-users/2014-May/083155.html
To quote:
Indeed, the db connection is not initialized at
the time of executing
event_route[htable:mod-init]. This is executed after all modules are
initialized, but the sqlops connections are initialized in child init.
So maybe this is the case for 5.0.3 as well? sqlops functions can't be
used in event_route[htable:mod-init] yet?
On 28 September 2017 at 20:18, George Diamantopoulos <georgediam(a)gmail.com
wrote:
Hello,
I've tested again, this time including a single sql_pvquery function in
the event-route. Kamailio will also exit with "daemonize(): Main process
exited before writing to pipe" in this simpler case.
In the documentation, it is stated that: The event route is executed only
once, after core and module initialization, <emphasis>but before Kamailio
forks any child processes</emphasis>.
Does this mean that I don't have (perhaps) access to pseudovariables during execution
of this route? Is this the reason why kamailio exits prematurely?
Thanks,
George
On 26 September 2017 at 15:37, George Diamantopoulos <
georgediam(a)gmail.com> wrote:
I forgot to mention, I'm using Kamailio 5.0.3
on debian "stretch".
On 26 September 2017 at 14:40, George Diamantopoulos <
georgediam(a)gmail.com> wrote:
Hello all,
I've been trying to utilise event_route[htable:mod-init] in order to
load information from the database into an htable on startup. However,
Kamailio exits with an error for no obvious (to me) reason. Here's the log
output:
DEBUG: htable [htable.c:226]: child_init(): rank is (-127)
DEBUG: htable [htable.c:259]: child_init(): executing
event_route[htable:mod-init] (2)
DEBUG: <core> [core/parser/msg_parser.c:600]: parse_msg(): SIP Request:
DEBUG: <core> [core/parser/msg_parser.c:602]: parse_msg(): method:
<OPTIONS>
DEBUG: <core> [core/parser/msg_parser.c:604]: parse_msg(): uri: <
sip:you@kamailio.org>
DEBUG: <core> [core/parser/msg_parser.c:606]: parse_msg(): version:
<SIP/2.0>
DEBUG: <core> [core/parser/parse_via.c:2639]: parse_via(): end of
header reached, state=2
DEBUG: <core> [core/parser/msg_parser.c:491]: parse_headers(): Via
found, flags=2
DEBUG: <core> [core/parser/msg_parser.c:493]: parse_headers(): this is
the first via
ERROR: <core> [core/daemonize.c:303]: daemonize(): Main process exited
before writing to pipe
And here's the routing block in kamailio.cfg. What I need to do is get
the username for all non-expired contacts in the "location" table, perform
a query on another database for each one of them and store the result in an
htable:
event_route[htable:mod-init] {
sql_pvquery("ck", "select username from location where now() <=
expires", "$avp(registered_ng)");
$var(i) = 0;
while ( $(avp(registered_ng)[$var(i)]) != $null ) {
sql_pvquery("ca", "select property from tablename where
username = $(avp(registered_ng)[$var(i)])", "$var(ng_property)");
$sht(isnguser=>$var(ng_property)) = 1;
$var(i) = $var(i) + 1;
pv_unset("$var(ng_property)");
}
pv_unset("$var(i)");
}
Any hints as to what I might be doing wrong? Thanks!
Best regards,
George
2 Oct
2 Oct
11:17 a.m.
New subject: Kamailio htable mod-init route: Main process exited before writing to pipe
Hello,
this should be looked at and enhanced somehow to be supported.
An workaround would be to use a lua script via app_lua to do it. Or use
rtimer or timer module to do an execution with a condition on a $var(...)
to be executed only once.
Cheers,
Daniel
On Thu, Sep 28, 2017 at 10:14 PM, George Diamantopoulos <
georgediam(a)gmail.com> wrote:
Never mind, I'm certain by now:
http://sip-router.1086192.n5.nabble.com/DB-select-htable-
mod-init-doesn-t-work-td127717.html
https://lists.kamailio.org/pipermail/sr-dev/2013-February/018484.html
On 28 September 2017 at 22:18, George Diamantopoulos <georgediam(a)gmail.com
--
Daniel-Constantin Mierla - http://www.asipto.com
http://twitter.com/#!/miconda - http://www.linkedin.com/in/miconda
wrote:
Also, I' found this post by Daniel in 2014:
https://lists.kamailio.org/pipermail/sr-users/2014-May/083155.html
To quote:
_______________________________________________
Kamailio (SER) - Users Mailing List
sr-users(a)lists.kamailio.org
https://lists.kamailio.org/cgi-bin/mailman/listinfo/sr-users
Indeed, the db connection is not initialized at
the time of executing
event_route[htable:mod-init]. This is executed after all modules are
initialized, but the sqlops connections are initialized in child init.
So maybe this is the case for 5.0.3 as well? sqlops functions can't be
used in event_route[htable:mod-init] yet?
On 28 September 2017 at 20:18, George Diamantopoulos <
georgediam(a)gmail.com> wrote:
Hello,
I've tested again, this time including a single sql_pvquery function in
the event-route. Kamailio will also exit with "daemonize(): Main process
exited before writing to pipe" in this simpler case.
In the documentation, it is stated that: The event route is executed
only once, after core and module initialization, <emphasis>but before
Kamailio forks any child processes</emphasis>.
Does this mean that I don't have (perhaps) access to pseudovariables during execution
of this route? Is this the reason why kamailio exits prematurely?
Thanks,
George
On 26 September 2017 at 15:37, George Diamantopoulos <
georgediam(a)gmail.com> wrote:
I forgot to mention, I'm using Kamailio 5.0.3
on debian "stretch".
On 26 September 2017 at 14:40, George Diamantopoulos <
georgediam(a)gmail.com> wrote:
> Hello all,
>
> I've been trying to utilise event_route[htable:mod-init] in order to
> load information from the database into an htable on startup. However,
> Kamailio exits with an error for no obvious (to me) reason. Here's the log
> output:
>
> DEBUG: htable [htable.c:226]: child_init(): rank is (-127)
> DEBUG: htable [htable.c:259]: child_init(): executing
> event_route[htable:mod-init] (2)
> DEBUG: <core> [core/parser/msg_parser.c:600]: parse_msg(): SIP
> Request:
> DEBUG: <core> [core/parser/msg_parser.c:602]: parse_msg(): method:
> <OPTIONS>
> DEBUG: <core> [core/parser/msg_parser.c:604]: parse_msg(): uri: <
> sip:you@kamailio.org>
> DEBUG: <core> [core/parser/msg_parser.c:606]: parse_msg(): version:
> <SIP/2.0>
> DEBUG: <core> [core/parser/parse_via.c:2639]: parse_via(): end of
> header reached, state=2
> DEBUG: <core> [core/parser/msg_parser.c:491]: parse_headers(): Via
> found, flags=2
> DEBUG: <core> [core/parser/msg_parser.c:493]: parse_headers(): this
> is the first via
> ERROR: <core> [core/daemonize.c:303]: daemonize(): Main process exited
> before writing to pipe
>
> And here's the routing block in kamailio.cfg. What I need to do is get
> the username for all non-expired contacts in the "location" table, perform
> a query on another database for each one of them and store the result in an
> htable:
>
> event_route[htable:mod-init] {
>
> sql_pvquery("ck", "select username from location where now()
<=
> expires", "$avp(registered_ng)");
>
> $var(i) = 0;
> while ( $(avp(registered_ng)[$var(i)]) != $null ) {
> sql_pvquery("ca", "select property from tablename where
> username = $(avp(registered_ng)[$var(i)])", "$var(ng_property)");
> $sht(isnguser=>$var(ng_property)) = 1;
> $var(i) = $var(i) + 1;
> pv_unset("$var(ng_property)");
> }
>
> pv_unset("$var(i)");
> }
>
> Any hints as to what I might be doing wrong? Thanks!
>
> Best regards,
> George
>
2614
days inactive
2620
days old
5 comments
2 participants
participants (2)
-
Daniel-Constantin Mierla -
George Diamantopoulos