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(a)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(a)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:

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(a)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(a)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(a)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: _______________________________________________ Users mailing list Users(a)openser.org http://openser.org/cgi-bin/mailman/listinfo/users