Hi all,
I'm having a weird behaviour when mixing auth_db and uri_db.
With the following openser.cfg, the xlog("L_INFO", "TEST\n") is never executed... seems that openser just hangs up...
If I remove the uri_db it works... If I remove the auth_db it works too... The problem seems to happen when I mix both...
Any idea of what may be wrong? I'm using the latest version (openser 1.0.1).
Thanks
debug=3 # debug level (cmd line: -dddddddddd) fork=yes log_stderror=yes
reply_to_via=no check_via=no # (cmd. line: -v) dns=no # (cmd. line: -r) rev_dns=no # (cmd. line: -R) port=5060 children=4 fifo="/tmp/ser_fifo"
loadmodule "/usr/lib/openser/modules/mysql.so" loadmodule "/usr/lib/openser/modules/sl.so" loadmodule "/usr/lib/openser/modules/auth.so" loadmodule "/usr/lib/openser/modules/auth_db.so" loadmodule "/usr/lib/openser/modules/uri_db.so" loadmodule "/usr/lib/openser/modules/xlog.so"
modparam("uri_db", "db_url", "mysql://root@192.168.1.104/openser") modparam("auth_db", "db_url", "mysql://root@192.168.1.104/openser")
route {
xlog("L_INFO", "TEST\n");
}
Hi,
run openser in full debug (set debug=9) and see where it hangs.
regards, bogdan
Edgar Barbosa wrote:
Hi all,
I'm having a weird behaviour when mixing auth_db and uri_db.
With the following openser.cfg, the xlog("L_INFO", "TEST\n") is never executed... seems that openser just hangs up...
If I remove the uri_db it works... If I remove the auth_db it works too... The problem seems to happen when I mix both...
Any idea of what may be wrong? I'm using the latest version (openser 1.0.1).
Thanks
debug=3 # debug level (cmd line: -dddddddddd) fork=yes log_stderror=yes
reply_to_via=no check_via=no # (cmd. line: -v) dns=no # (cmd. line: -r) rev_dns=no # (cmd. line: -R) port=5060 children=4 fifo="/tmp/ser_fifo"
loadmodule "/usr/lib/openser/modules/mysql.so" loadmodule "/usr/lib/openser/modules/sl.so" loadmodule "/usr/lib/openser/modules/auth.so" loadmodule "/usr/lib/openser/modules/auth_db.so" loadmodule "/usr/lib/openser/modules/uri_db.so" loadmodule "/usr/lib/openser/modules/xlog.so"
modparam("uri_db", "db_url", "mysql://root@192.168.1.104/openser") modparam("auth_db", "db_url", "mysql://root@192.168.1.104/openser")
route {
xlog("L_INFO", "TEST\n");
}
Users mailing list Users@openser.org http://openser.org/cgi-bin/mailman/listinfo/users
Hi Bogdan,
Running with debug=9 it seems to hang here:
8(16807) new_connection: Connection type is Localhost via UNIX socket 8(16807) new_connection: Protocol version is 10 8(16807) new_connection: Server version is 5.0.21-Debian_2.dotdeb.1-log 8(16807) DEBUG:init_mod_child: CHILD , rank=6, module=uri_db 9(16808) new_connection: Connection type is Localhost via UNIX socket 9(16808) new_connection: Protocol version is 10 9(16808) new_connection: Server version is 5.0.21-Debian_2.dotdeb.1-log 9(16808) DEBUG:init_mod_child: CHILD , rank=7, module=uri_db 10(16809) new_connection: Connection type is Localhost via UNIX socket 10(16809) new_connection: Protocol version is 10 10(16809) new_connection: Server version is 5.0.21-Debian_2.dotdeb.1-log 10(16809) DEBUG:init_mod_child: CHILD , rank=8, module=uri_db 0(16789) new_connection: Connection type is Localhost via UNIX socket 0(16789) new_connection: Protocol version is 10 0(16789) new_connection: Server version is 5.0.21-Debian_2.dotdeb.1-log 0(16789) DEBUG:init_mod_child: PROC_MAIN , rank=0, module=uri_db 11(16810) new_connection: Connection type is Localhost via UNIX socket 11(16810) new_connection: Protocol version is 10 11(16810) new_connection: Server version is 5.0.21-Debian_2.dotdeb.1-log 11(16810) DEBUG:init_mod_child: PROC_TCP_MAIN , rank=-4, module=uri_db
Any idea of what may be wrong?
Thanks, Edgar
-----Original Message----- From: Bogdan-Andrei Iancu [mailto:bogdan@voice-system.ro] Sent: terça-feira, 30 de Maio de 2006 8:45 To: Edgar Barbosa Cc: Users@openser.org Subject: Re: [Users] Mixing uri_db and auth_db
Hi,
run openser in full debug (set debug=9) and see where it hangs.
regards, bogdan
Edgar Barbosa wrote:
Hi all,
I'm having a weird behaviour when mixing auth_db and uri_db.
With the following openser.cfg, the xlog("L_INFO", "TEST\n") is never executed... seems that openser just hangs up...
If I remove the uri_db it works... If I remove the auth_db it works too... The problem seems to happen when I mix both...
Any idea of what may be wrong? I'm using the latest version (openser 1.0.1).
Thanks
debug=3 # debug level (cmd line: -dddddddddd) fork=yes log_stderror=yes
reply_to_via=no check_via=no # (cmd. line: -v) dns=no # (cmd. line: -r) rev_dns=no # (cmd. line: -R) port=5060 children=4 fifo="/tmp/ser_fifo"
loadmodule "/usr/lib/openser/modules/mysql.so" loadmodule "/usr/lib/openser/modules/sl.so" loadmodule "/usr/lib/openser/modules/auth.so" loadmodule "/usr/lib/openser/modules/auth_db.so" loadmodule "/usr/lib/openser/modules/uri_db.so" loadmodule "/usr/lib/openser/modules/xlog.so"
modparam("uri_db", "db_url", "mysql://root@192.168.1.104/openser") modparam("auth_db", "db_url", "mysql://root@192.168.1.104/openser")
route {
xlog("L_INFO", "TEST\n");
}
Users mailing list Users@openser.org http://openser.org/cgi-bin/mailman/listinfo/users
Edgar,
my first guess is that the mysql server does not accept more connections. Is that the entire log with debug 9? I got more info, like:
15(30460) DEBUG:init_mod_child: PROC_TCP_MAIN , rank=-4, module=auth_db 15(30460) db_init: Connection 'mysql://openser:openserrw@localhost/openser' not found in pool 15(30460) new_connection: Opening MySQL connection: mysql://openser:openserrw@localhost/openser 15(30460) new_connection: Connection type is Localhost via UNIX socket 15(30460) new_connection: Protocol version is 10 15(30460) new_connection: Server version is 5.0.18-Debian_7-log
what version are you running?
regards, bogdan
Edgar Barbosa wrote:
Hi Bogdan,
Running with debug=9 it seems to hang here:
8(16807) new_connection: Connection type is Localhost via UNIX socket 8(16807) new_connection: Protocol version is 10 8(16807) new_connection: Server version is 5.0.21-Debian_2.dotdeb.1-log 8(16807) DEBUG:init_mod_child: CHILD , rank=6, module=uri_db 9(16808) new_connection: Connection type is Localhost via UNIX socket 9(16808) new_connection: Protocol version is 10 9(16808) new_connection: Server version is 5.0.21-Debian_2.dotdeb.1-log 9(16808) DEBUG:init_mod_child: CHILD , rank=7, module=uri_db 10(16809) new_connection: Connection type is Localhost via UNIX socket 10(16809) new_connection: Protocol version is 10 10(16809) new_connection: Server version is 5.0.21-Debian_2.dotdeb.1-log 10(16809) DEBUG:init_mod_child: CHILD , rank=8, module=uri_db 0(16789) new_connection: Connection type is Localhost via UNIX socket 0(16789) new_connection: Protocol version is 10 0(16789) new_connection: Server version is 5.0.21-Debian_2.dotdeb.1-log 0(16789) DEBUG:init_mod_child: PROC_MAIN , rank=0, module=uri_db 11(16810) new_connection: Connection type is Localhost via UNIX socket 11(16810) new_connection: Protocol version is 10 11(16810) new_connection: Server version is 5.0.21-Debian_2.dotdeb.1-log 11(16810) DEBUG:init_mod_child: PROC_TCP_MAIN , rank=-4, module=uri_db
Any idea of what may be wrong?
Thanks, Edgar
-----Original Message----- From: Bogdan-Andrei Iancu [mailto:bogdan@voice-system.ro] Sent: terça-feira, 30 de Maio de 2006 8:45 To: Edgar Barbosa Cc: Users@openser.org Subject: Re: [Users] Mixing uri_db and auth_db
Hi,
run openser in full debug (set debug=9) and see where it hangs.
regards, bogdan
Edgar Barbosa wrote:
Hi all,
I'm having a weird behaviour when mixing auth_db and uri_db.
With the following openser.cfg, the xlog("L_INFO", "TEST\n") is never executed... seems that openser just hangs up...
If I remove the uri_db it works... If I remove the auth_db it works too... The problem seems to happen when I mix both...
Any idea of what may be wrong? I'm using the latest version (openser 1.0.1).
Thanks
debug=3 # debug level (cmd line: -dddddddddd) fork=yes log_stderror=yes
reply_to_via=no check_via=no # (cmd. line: -v) dns=no # (cmd. line: -r) rev_dns=no # (cmd. line: -R) port=5060 children=4 fifo="/tmp/ser_fifo"
loadmodule "/usr/lib/openser/modules/mysql.so" loadmodule "/usr/lib/openser/modules/sl.so" loadmodule "/usr/lib/openser/modules/auth.so" loadmodule "/usr/lib/openser/modules/auth_db.so" loadmodule "/usr/lib/openser/modules/uri_db.so" loadmodule "/usr/lib/openser/modules/xlog.so"
modparam("uri_db", "db_url", "mysql://root@192.168.1.104/openser") modparam("auth_db", "db_url", "mysql://root@192.168.1.104/openser")
route {
xlog("L_INFO", "TEST\n");
}
Users mailing list Users@openser.org http://openser.org/cgi-bin/mailman/listinfo/users
Bogdan,
I think you're right about the max number of connections, since if I change the module load order it hangs in another module doing the same action (requesting a new connection).
But I can't find where that limit may be... I already set the my.cnf max_connections from 100 to 500, but without success... I guess this restriction should be elsewhere... any ideas?
Thanks, Edgar
-----Original Message----- From: Bogdan-Andrei Iancu [mailto:bogdan@voice-system.ro] Sent: segunda-feira, 5 de Junho de 2006 16:37 To: Edgar Barbosa Cc: Users@openser.org Subject: Re: [Users] Mixing uri_db and auth_db
Edgar,
my first guess is that the mysql server does not accept more connections. Is that the entire log with debug 9? I got more info, like:
15(30460) DEBUG:init_mod_child: PROC_TCP_MAIN , rank=-4, module=auth_db 15(30460) db_init: Connection 'mysql://openser:openserrw@localhost/openser' not found in pool 15(30460) new_connection: Opening MySQL connection: mysql://openser:openserrw@localhost/openser 15(30460) new_connection: Connection type is Localhost via UNIX socket 15(30460) new_connection: Protocol version is 10 15(30460) new_connection: Server version is 5.0.18-Debian_7-log
what version are you running?
regards, bogdan
Edgar Barbosa wrote:
Hi Bogdan,
Running with debug=9 it seems to hang here:
8(16807) new_connection: Connection type is Localhost via UNIX socket 8(16807) new_connection: Protocol version is 10 8(16807) new_connection: Server version is 5.0.21-Debian_2.dotdeb.1-log 8(16807) DEBUG:init_mod_child: CHILD , rank=6, module=uri_db 9(16808) new_connection: Connection type is Localhost via UNIX socket 9(16808) new_connection: Protocol version is 10 9(16808) new_connection: Server version is 5.0.21-Debian_2.dotdeb.1-log 9(16808) DEBUG:init_mod_child: CHILD , rank=7, module=uri_db 10(16809) new_connection: Connection type is Localhost via UNIX socket 10(16809) new_connection: Protocol version is 10 10(16809) new_connection: Server version is 5.0.21-Debian_2.dotdeb.1-log 10(16809) DEBUG:init_mod_child: CHILD , rank=8, module=uri_db 0(16789) new_connection: Connection type is Localhost via UNIX socket 0(16789) new_connection: Protocol version is 10 0(16789) new_connection: Server version is 5.0.21-Debian_2.dotdeb.1-log 0(16789) DEBUG:init_mod_child: PROC_MAIN , rank=0, module=uri_db 11(16810) new_connection: Connection type is Localhost via UNIX socket 11(16810) new_connection: Protocol version is 10 11(16810) new_connection: Server version is 5.0.21-Debian_2.dotdeb.1-log 11(16810) DEBUG:init_mod_child: PROC_TCP_MAIN , rank=-4, module=uri_db
Any idea of what may be wrong?
Thanks, Edgar
-----Original Message----- From: Bogdan-Andrei Iancu [mailto:bogdan@voice-system.ro] Sent: terça-feira, 30 de Maio de 2006 8:45 To: Edgar Barbosa Cc: Users@openser.org Subject: Re: [Users] Mixing uri_db and auth_db
Hi,
run openser in full debug (set debug=9) and see where it hangs.
regards, bogdan
Edgar Barbosa wrote:
Hi all,
I'm having a weird behaviour when mixing auth_db and uri_db.
With the following openser.cfg, the xlog("L_INFO", "TEST\n") is never executed... seems that openser just hangs up...
If I remove the uri_db it works... If I remove the auth_db it works too... The problem seems to happen when I mix both...
Any idea of what may be wrong? I'm using the latest version (openser 1.0.1).
Thanks
debug=3 # debug level (cmd line: -dddddddddd) fork=yes log_stderror=yes
reply_to_via=no check_via=no # (cmd. line: -v) dns=no # (cmd. line: -r) rev_dns=no # (cmd. line: -R) port=5060 children=4 fifo="/tmp/ser_fifo"
loadmodule "/usr/lib/openser/modules/mysql.so" loadmodule "/usr/lib/openser/modules/sl.so" loadmodule "/usr/lib/openser/modules/auth.so" loadmodule "/usr/lib/openser/modules/auth_db.so" loadmodule "/usr/lib/openser/modules/uri_db.so" loadmodule "/usr/lib/openser/modules/xlog.so"
modparam("uri_db", "db_url", "mysql://root@192.168.1.104/openser") modparam("auth_db", "db_url", "mysql://root@192.168.1.104/openser")
route {
xlog("L_INFO", "TEST\n");
}
Users mailing list Users@openser.org http://openser.org/cgi-bin/mailman/listinfo/users
Another info that may (or not) be helpful...
If I set fork=no and restart openser, it crashes at that point:
0(17790) db_init: Connection 'mysql://root@localhost/astbill' not found in pool 0(17790) new_connection: Opening MySQL connection: mysql://root:@localhost/astbill 0(17790) new_connection: Connection type is Localhost via UNIX socket 0(17790) new_connection: Protocol version is 10 0(17790) new_connection: Server version is 5.0.21-Debian_2.dotdeb.1-log 0(17790) DEBUG:init_mod_child: CHILD , rank=1, module=uri_db /etc/init.d/openser: line 118: 17790 Segmentation fault start-stop-daemon --start --quiet --pidfile $PIDFILE --exec $DAEMON -- $OPTIONS
Regards, Edgar
-----Original Message----- From: users-bounces@openser.org [mailto:users-bounces@openser.org] On Behalf Of Edgar Barbosa Sent: segunda-feira, 5 de Junho de 2006 17:17 To: 'Bogdan-Andrei Iancu' Cc: Users@openser.org Subject: RE: [Users] Mixing uri_db and auth_db
Bogdan,
I think you're right about the max number of connections, since if I change the module load order it hangs in another module doing the same action (requesting a new connection).
But I can't find where that limit may be... I already set the my.cnf max_connections from 100 to 500, but without success... I guess this restriction should be elsewhere... any ideas?
Thanks, Edgar
-----Original Message----- From: Bogdan-Andrei Iancu [mailto:bogdan@voice-system.ro] Sent: segunda-feira, 5 de Junho de 2006 16:37 To: Edgar Barbosa Cc: Users@openser.org Subject: Re: [Users] Mixing uri_db and auth_db
Edgar,
my first guess is that the mysql server does not accept more connections. Is that the entire log with debug 9? I got more info, like:
15(30460) DEBUG:init_mod_child: PROC_TCP_MAIN , rank=-4, module=auth_db 15(30460) db_init: Connection 'mysql://openser:openserrw@localhost/openser' not found in pool 15(30460) new_connection: Opening MySQL connection: mysql://openser:openserrw@localhost/openser 15(30460) new_connection: Connection type is Localhost via UNIX socket 15(30460) new_connection: Protocol version is 10 15(30460) new_connection: Server version is 5.0.18-Debian_7-log
what version are you running?
regards, bogdan
Edgar Barbosa wrote:
Hi Bogdan,
Running with debug=9 it seems to hang here:
8(16807) new_connection: Connection type is Localhost via UNIX socket 8(16807) new_connection: Protocol version is 10 8(16807) new_connection: Server version is 5.0.21-Debian_2.dotdeb.1-log 8(16807) DEBUG:init_mod_child: CHILD , rank=6, module=uri_db 9(16808) new_connection: Connection type is Localhost via UNIX socket 9(16808) new_connection: Protocol version is 10 9(16808) new_connection: Server version is 5.0.21-Debian_2.dotdeb.1-log 9(16808) DEBUG:init_mod_child: CHILD , rank=7, module=uri_db 10(16809) new_connection: Connection type is Localhost via UNIX socket 10(16809) new_connection: Protocol version is 10 10(16809) new_connection: Server version is 5.0.21-Debian_2.dotdeb.1-log 10(16809) DEBUG:init_mod_child: CHILD , rank=8, module=uri_db 0(16789) new_connection: Connection type is Localhost via UNIX socket 0(16789) new_connection: Protocol version is 10 0(16789) new_connection: Server version is 5.0.21-Debian_2.dotdeb.1-log 0(16789) DEBUG:init_mod_child: PROC_MAIN , rank=0, module=uri_db 11(16810) new_connection: Connection type is Localhost via UNIX socket 11(16810) new_connection: Protocol version is 10 11(16810) new_connection: Server version is 5.0.21-Debian_2.dotdeb.1-log 11(16810) DEBUG:init_mod_child: PROC_TCP_MAIN , rank=-4, module=uri_db
Any idea of what may be wrong?
Thanks, Edgar
-----Original Message----- From: Bogdan-Andrei Iancu [mailto:bogdan@voice-system.ro] Sent: terça-feira, 30 de Maio de 2006 8:45 To: Edgar Barbosa Cc: Users@openser.org Subject: Re: [Users] Mixing uri_db and auth_db
Hi,
run openser in full debug (set debug=9) and see where it hangs.
regards, bogdan
Edgar Barbosa wrote:
Hi all,
I'm having a weird behaviour when mixing auth_db and uri_db.
With the following openser.cfg, the xlog("L_INFO", "TEST\n") is never executed... seems that openser just hangs up...
If I remove the uri_db it works... If I remove the auth_db it works too... The problem seems to happen when I mix both...
Any idea of what may be wrong? I'm using the latest version (openser 1.0.1).
Thanks
debug=3 # debug level (cmd line: -dddddddddd) fork=yes log_stderror=yes
reply_to_via=no check_via=no # (cmd. line: -v) dns=no # (cmd. line: -r) rev_dns=no # (cmd. line: -R) port=5060 children=4 fifo="/tmp/ser_fifo"
loadmodule "/usr/lib/openser/modules/mysql.so" loadmodule "/usr/lib/openser/modules/sl.so" loadmodule "/usr/lib/openser/modules/auth.so" loadmodule "/usr/lib/openser/modules/auth_db.so" loadmodule "/usr/lib/openser/modules/uri_db.so" loadmodule "/usr/lib/openser/modules/xlog.so"
modparam("uri_db", "db_url", "mysql://root@192.168.1.104/openser") modparam("auth_db", "db_url", "mysql://root@192.168.1.104/openser")
route {
xlog("L_INFO", "TEST\n");
}
Users mailing list Users@openser.org http://openser.org/cgi-bin/mailman/listinfo/users
_______________________________________________ Users mailing list Users@openser.org http://openser.org/cgi-bin/mailman/listinfo/users
Edgar,
can you get a backtrace of the core? Can you reproduce this crash or it occurs randomly?
regards, bogdan
Edgar Barbosa wrote:
Another info that may (or not) be helpful...
If I set fork=no and restart openser, it crashes at that point:
0(17790) db_init: Connection 'mysql://root@localhost/astbill' not found in pool 0(17790) new_connection: Opening MySQL connection: mysql://root:@localhost/astbill 0(17790) new_connection: Connection type is Localhost via UNIX socket 0(17790) new_connection: Protocol version is 10 0(17790) new_connection: Server version is 5.0.21-Debian_2.dotdeb.1-log 0(17790) DEBUG:init_mod_child: CHILD , rank=1, module=uri_db /etc/init.d/openser: line 118: 17790 Segmentation fault start-stop-daemon --start --quiet --pidfile $PIDFILE --exec $DAEMON -- $OPTIONS
Regards, Edgar
-----Original Message----- From: users-bounces@openser.org [mailto:users-bounces@openser.org] On Behalf Of Edgar Barbosa Sent: segunda-feira, 5 de Junho de 2006 17:17 To: 'Bogdan-Andrei Iancu' Cc: Users@openser.org Subject: RE: [Users] Mixing uri_db and auth_db
Bogdan,
I think you're right about the max number of connections, since if I change the module load order it hangs in another module doing the same action (requesting a new connection).
But I can't find where that limit may be... I already set the my.cnf max_connections from 100 to 500, but without success... I guess this restriction should be elsewhere... any ideas?
Thanks, Edgar
-----Original Message----- From: Bogdan-Andrei Iancu [mailto:bogdan@voice-system.ro] Sent: segunda-feira, 5 de Junho de 2006 16:37 To: Edgar Barbosa Cc: Users@openser.org Subject: Re: [Users] Mixing uri_db and auth_db
Edgar,
my first guess is that the mysql server does not accept more connections. Is that the entire log with debug 9? I got more info, like:
15(30460) DEBUG:init_mod_child: PROC_TCP_MAIN , rank=-4, module=auth_db 15(30460) db_init: Connection 'mysql://openser:openserrw@localhost/openser' not found in pool 15(30460) new_connection: Opening MySQL connection: mysql://openser:openserrw@localhost/openser 15(30460) new_connection: Connection type is Localhost via UNIX socket 15(30460) new_connection: Protocol version is 10 15(30460) new_connection: Server version is 5.0.18-Debian_7-log
what version are you running?
regards, bogdan
Edgar Barbosa wrote:
Hi Bogdan,
Running with debug=9 it seems to hang here:
8(16807) new_connection: Connection type is Localhost via UNIX socket 8(16807) new_connection: Protocol version is 10 8(16807) new_connection: Server version is 5.0.21-Debian_2.dotdeb.1-log 8(16807) DEBUG:init_mod_child: CHILD , rank=6, module=uri_db 9(16808) new_connection: Connection type is Localhost via UNIX socket 9(16808) new_connection: Protocol version is 10 9(16808) new_connection: Server version is 5.0.21-Debian_2.dotdeb.1-log 9(16808) DEBUG:init_mod_child: CHILD , rank=7, module=uri_db 10(16809) new_connection: Connection type is Localhost via UNIX socket 10(16809) new_connection: Protocol version is 10 10(16809) new_connection: Server version is 5.0.21-Debian_2.dotdeb.1-log 10(16809) DEBUG:init_mod_child: CHILD , rank=8, module=uri_db 0(16789) new_connection: Connection type is Localhost via UNIX socket 0(16789) new_connection: Protocol version is 10 0(16789) new_connection: Server version is 5.0.21-Debian_2.dotdeb.1-log 0(16789) DEBUG:init_mod_child: PROC_MAIN , rank=0, module=uri_db 11(16810) new_connection: Connection type is Localhost via UNIX socket 11(16810) new_connection: Protocol version is 10 11(16810) new_connection: Server version is 5.0.21-Debian_2.dotdeb.1-log 11(16810) DEBUG:init_mod_child: PROC_TCP_MAIN , rank=-4, module=uri_db
Any idea of what may be wrong?
Thanks, Edgar
-----Original Message----- From: Bogdan-Andrei Iancu [mailto:bogdan@voice-system.ro] Sent: terça-feira, 30 de Maio de 2006 8:45 To: Edgar Barbosa Cc: Users@openser.org Subject: Re: [Users] Mixing uri_db and auth_db
Hi,
run openser in full debug (set debug=9) and see where it hangs.
regards, bogdan
Edgar Barbosa wrote:
Hi all,
I'm having a weird behaviour when mixing auth_db and uri_db.
With the following openser.cfg, the xlog("L_INFO", "TEST\n") is never executed... seems that openser just hangs up...
If I remove the uri_db it works... If I remove the auth_db it works too... The problem seems to happen when I mix both...
Any idea of what may be wrong? I'm using the latest version (openser 1.0.1).
Thanks
debug=3 # debug level (cmd line: -dddddddddd) fork=yes log_stderror=yes
reply_to_via=no check_via=no # (cmd. line: -v) dns=no # (cmd. line: -r) rev_dns=no # (cmd. line: -R) port=5060 children=4 fifo="/tmp/ser_fifo"
loadmodule "/usr/lib/openser/modules/mysql.so" loadmodule "/usr/lib/openser/modules/sl.so" loadmodule "/usr/lib/openser/modules/auth.so" loadmodule "/usr/lib/openser/modules/auth_db.so" loadmodule "/usr/lib/openser/modules/uri_db.so" loadmodule "/usr/lib/openser/modules/xlog.so"
modparam("uri_db", "db_url", "mysql://root@192.168.1.104/openser") modparam("auth_db", "db_url", "mysql://root@192.168.1.104/openser")
route {
xlog("L_INFO", "TEST\n");
}
Users mailing list Users@openser.org http://openser.org/cgi-bin/mailman/listinfo/users
Users mailing list Users@openser.org http://openser.org/cgi-bin/mailman/listinfo/users
Bogdan,
It occurs everytime I restart openser...
A backtrace... how can I get one?
Regards, Edgar
-----Original Message----- From: Bogdan-Andrei Iancu [mailto:bogdan@voice-system.ro] Sent: segunda-feira, 5 de Junho de 2006 17:59 To: Edgar Barbosa Cc: Users@openser.org Subject: Re: [Users] Mixing uri_db and auth_db
Edgar,
can you get a backtrace of the core? Can you reproduce this crash or it occurs randomly?
regards, bogdan
Edgar Barbosa wrote:
Another info that may (or not) be helpful...
If I set fork=no and restart openser, it crashes at that point:
0(17790) db_init: Connection 'mysql://root@localhost/astbill' not found in pool 0(17790) new_connection: Opening MySQL connection: mysql://root:@localhost/astbill 0(17790) new_connection: Connection type is Localhost via UNIX socket 0(17790) new_connection: Protocol version is 10 0(17790) new_connection: Server version is 5.0.21-Debian_2.dotdeb.1-log 0(17790) DEBUG:init_mod_child: CHILD , rank=1, module=uri_db /etc/init.d/openser: line 118: 17790 Segmentation fault start-stop-daemon --start --quiet --pidfile $PIDFILE --exec $DAEMON -- $OPTIONS
Regards, Edgar
-----Original Message----- From: users-bounces@openser.org [mailto:users-bounces@openser.org] On
Behalf
Of Edgar Barbosa Sent: segunda-feira, 5 de Junho de 2006 17:17 To: 'Bogdan-Andrei Iancu' Cc: Users@openser.org Subject: RE: [Users] Mixing uri_db and auth_db
Bogdan,
I think you're right about the max number of connections, since if I change the module load order it hangs in another module doing the same action (requesting a new connection).
But I can't find where that limit may be... I already set the my.cnf max_connections from 100 to 500, but without success... I guess this restriction should be elsewhere... any ideas?
Thanks, Edgar
-----Original Message----- From: Bogdan-Andrei Iancu [mailto:bogdan@voice-system.ro] Sent: segunda-feira, 5 de Junho de 2006 16:37 To: Edgar Barbosa Cc: Users@openser.org Subject: Re: [Users] Mixing uri_db and auth_db
Edgar,
my first guess is that the mysql server does not accept more connections. Is that the entire log with debug 9? I got more info, like:
15(30460) DEBUG:init_mod_child: PROC_TCP_MAIN , rank=-4, module=auth_db 15(30460) db_init: Connection 'mysql://openser:openserrw@localhost/openser' not found in pool 15(30460) new_connection: Opening MySQL connection: mysql://openser:openserrw@localhost/openser 15(30460) new_connection: Connection type is Localhost via UNIX socket 15(30460) new_connection: Protocol version is 10 15(30460) new_connection: Server version is 5.0.18-Debian_7-log
what version are you running?
regards, bogdan
Edgar Barbosa wrote:
Hi Bogdan,
Running with debug=9 it seems to hang here:
8(16807) new_connection: Connection type is Localhost via UNIX socket 8(16807) new_connection: Protocol version is 10 8(16807) new_connection: Server version is 5.0.21-Debian_2.dotdeb.1-log 8(16807) DEBUG:init_mod_child: CHILD , rank=6, module=uri_db 9(16808) new_connection: Connection type is Localhost via UNIX socket 9(16808) new_connection: Protocol version is 10 9(16808) new_connection: Server version is 5.0.21-Debian_2.dotdeb.1-log 9(16808) DEBUG:init_mod_child: CHILD , rank=7, module=uri_db 10(16809) new_connection: Connection type is Localhost via UNIX socket 10(16809) new_connection: Protocol version is 10 10(16809) new_connection: Server version is 5.0.21-Debian_2.dotdeb.1-log 10(16809) DEBUG:init_mod_child: CHILD , rank=8, module=uri_db 0(16789) new_connection: Connection type is Localhost via UNIX socket 0(16789) new_connection: Protocol version is 10 0(16789) new_connection: Server version is 5.0.21-Debian_2.dotdeb.1-log 0(16789) DEBUG:init_mod_child: PROC_MAIN , rank=0, module=uri_db 11(16810) new_connection: Connection type is Localhost via UNIX socket 11(16810) new_connection: Protocol version is 10 11(16810) new_connection: Server version is 5.0.21-Debian_2.dotdeb.1-log 11(16810) DEBUG:init_mod_child: PROC_TCP_MAIN , rank=-4, module=uri_db
Any idea of what may be wrong?
Thanks, Edgar
-----Original Message----- From: Bogdan-Andrei Iancu [mailto:bogdan@voice-system.ro] Sent: terça-feira, 30 de Maio de 2006 8:45 To: Edgar Barbosa Cc: Users@openser.org Subject: Re: [Users] Mixing uri_db and auth_db
Hi,
run openser in full debug (set debug=9) and see where it hangs.
regards, bogdan
Edgar Barbosa wrote:
Hi all,
I'm having a weird behaviour when mixing auth_db and uri_db.
With the following openser.cfg, the xlog("L_INFO", "TEST\n") is never executed... seems that openser just hangs up...
If I remove the uri_db it works... If I remove the auth_db it works too... The problem seems to happen when I mix both...
Any idea of what may be wrong? I'm using the latest version (openser 1.0.1).
Thanks
debug=3 # debug level (cmd line: -dddddddddd) fork=yes log_stderror=yes
reply_to_via=no check_via=no # (cmd. line: -v) dns=no # (cmd. line: -r) rev_dns=no # (cmd. line: -R) port=5060 children=4 fifo="/tmp/ser_fifo"
loadmodule "/usr/lib/openser/modules/mysql.so" loadmodule "/usr/lib/openser/modules/sl.so" loadmodule "/usr/lib/openser/modules/auth.so" loadmodule "/usr/lib/openser/modules/auth_db.so" loadmodule "/usr/lib/openser/modules/uri_db.so" loadmodule "/usr/lib/openser/modules/xlog.so"
modparam("uri_db", "db_url", "mysql://root@192.168.1.104/openser") modparam("auth_db", "db_url", "mysql://root@192.168.1.104/openser")
route {
xlog("L_INFO", "TEST\n");
}
Users mailing list Users@openser.org http://openser.org/cgi-bin/mailman/listinfo/users
Users mailing list Users@openser.org http://openser.org/cgi-bin/mailman/listinfo/users
-
Bogdan-Andrei Iancu -
Edgar Barbosa