[Users] Mixing uri_db and auth_db

Bogdan-Andrei Iancu bogdan at voice-system.ro
Mon Jun 5 17:37:09 CEST 2006


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 at voice-system.ro] 
>Sent: terça-feira, 30 de Maio de 2006 8:45
>To: Edgar Barbosa
>Cc: Users at 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 at openser.org
>>http://openser.org/cgi-bin/mailman/listinfo/users
>>
>> 
>>    
>>
>>
>
>  
>





More information about the Users mailing list