Bogdan, It occurs everytime I restart openser...
A backtrace... how can I get one? Regards, Edgar -----Original Message----- From: Bogdan-Andrei Iancu [mailto:[EMAIL PROTECTED] Sent: segunda-feira, 5 de Junho de 2006 17:59 To: Edgar Barbosa Cc: [email protected] 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://[EMAIL PROTECTED]/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: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf >Of Edgar Barbosa >Sent: segunda-feira, 5 de Junho de 2006 17:17 >To: 'Bogdan-Andrei Iancu' >Cc: [email protected] >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:[EMAIL PROTECTED] >Sent: segunda-feira, 5 de Junho de 2006 16:37 >To: Edgar Barbosa >Cc: [email protected] >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:[EMAIL PROTECTED]/openser' not found in pool >15(30460) new_connection: Opening MySQL connection: >mysql://openser:[EMAIL PROTECTED]/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:[EMAIL PROTECTED] >>Sent: terça-feira, 30 de Maio de 2006 8:45 >>To: Edgar Barbosa >>Cc: [email protected] >>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://[EMAIL PROTECTED]/openser") >>>modparam("auth_db", "db_url", "mysql://[EMAIL PROTECTED]/openser") >>> >>>route { >>> >>> xlog("L_INFO", "TEST\n"); >>> >>>} >>> >>> >>>_______________________________________________ >>>Users mailing list >>>[email protected] >>>http://openser.org/cgi-bin/mailman/listinfo/users >>> >>> >>> >>> >>> >>> >>> >> >> >> >> > > >_______________________________________________ >Users mailing list >[email protected] >http://openser.org/cgi-bin/mailman/listinfo/users > > > _______________________________________________ Users mailing list [email protected] http://openser.org/cgi-bin/mailman/listinfo/users
