5 Jun
2006
5 Jun
'06
6:17 p.m.
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:
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:
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