[Users] Mixing uri_db and auth_db

[Bogdan-Andrei Iancu]

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 at openser.org [mailto:users-bounces at openser.org] On Behalf
>Of Edgar Barbosa
>Sent: segunda-feira, 5 de Junho de 2006 17:17
>To: 'Bogdan-Andrei Iancu'
>Cc: Users at 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 at voice-system.ro] 
>Sent: segunda-feira, 5 de Junho de 2006 16:37
>To: Edgar Barbosa
>Cc: Users at 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 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
>>>
>>>
>>>   
>>>
>>>
>>>      
>>>
>> 
>>
>>    
>>
>
>
>_______________________________________________
>Users mailing list
>Users at openser.org
>http://openser.org/cgi-bin/mailman/listinfo/users
>
>  
>