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

Reply via email to