Hello,
what version of openser do you run?
Could you get a backtrace? Set "ulimit -c unlimited" in the console you
start openser and you should get a core file. The do:
gdb /usr/lib/openser/sbin/openser core
# bt
Send the output to us. If it is openser 1.1.x, please use
devel(a)openser.org mailing list.
I see in the log that the mysql client library is v4.x and the mysql
server is v5.x. Should not be any problem as far as I know, just a
remark which should be paid attention.
Cheers,
Daniel
On 06/06/06 20:12, Edgar Barbosa wrote:
Hi,
I'm having problems when defining both the auth_db:db_url and the
uri_db:db_url parameters.
Openser crashes when restarting (everything goes ok if I set just one).
I've restricted my openser.cfg to the minimum, to filter other sources of
problems.
With the following cfg, openser crashes on my machine (logs in attachment)
with a segmentation fault error.
==============================
debug=9
fork=no
log_stderror=yes
loadmodule "/usr/lib/openser/modules/mysql.so"
loadmodule "/usr/lib/openser/modules/sl.so"
loadmodule "/usr/lib/openser/modules/xlog.so"
loadmodule "/usr/lib/openser/modules/auth.so"
loadmodule "/usr/lib/openser/modules/auth_db.so"
loadmodule "/usr/lib/openser/modules/uri_db.so"
modparam("auth_db", "db_url",
"mysql://root@localhost/openser")
modparam("uri_db", "db_url",
"mysql://root@localhost/openser")
route {
xlog("L_WARN", "TEST");
}
==============================
I'm using the latest version, and tried the debian package and compiling
from the source... same result...
Seems the problem may be related to the number of database connections...
but I've expanded it on mysql, with no success...
Anyone could reproduce this problem?
Any suggestions of how can I solve it?
Thanks,
Edgar
------------------------------------------------------------------------
Restarting openser: openser 0(3036) loading module /usr/lib/openser/modules/mysql.so
0(3036) loading module /usr/lib/openser/modules/sl.so
0(3036) loading module /usr/lib/openser/modules/xlog.so
0(3036) loading module /usr/lib/openser/modules/auth.so
0(3036) loading module /usr/lib/openser/modules/auth_db.so
0(3036) loading module /usr/lib/openser/modules/uri_db.so
0(3036) set_mod_param_regex: auth_db matches module auth_db
0(3036) set_mod_param_regex: found <db_url> in module auth_db
[/usr/lib/openser/modules/auth_db.so]
0(3036) set_mod_param_regex: uri_db matches module uri_db
0(3036) set_mod_param_regex: found <db_url> in module uri_db
[/usr/lib/openser/modules/uri_db.so]
0(3036) find_export: found <xlog> in module xlog
[/usr/lib/openser/modules/xlog.so]
0(3036) routing table 0:
0(3036) external_module_call( 0(3036) f_ptr<0x4023be00> 0(3036) ,
"L_WARN" 0(3036) , "TEST" 0(3036) ); 0(3036)
0(3036) WARNING: fix_socket_list: could not rev. resolve 192.168.1.52
0(3036) WARNING: fix_socket_list: could not rev. resolve 192.168.1.52
Listening on
udp: 127.0.0.1 [127.0.0.1]:5060
udp: 192.168.1.52 [192.168.1.52]:5060
tcp: 127.0.0.1 [127.0.0.1]:5060
tcp: 192.168.1.52 [192.168.1.52]:5060
Aliases:
tcp: voip:5060
tcp: localhost:5060
tcp: localhost.localdomain:5060
udp: voip:5060
udp: localhost:5060
udp: localhost.localdomain:5060
WARNING: no fork mode and more than one listen address found(will use only the the first
one)
0(3036) fm_malloc_init: F_OPTIMIZE=16384, /ROUNDTO=2048
0(3036) fm_malloc_init: F_HASH_SIZE=2067, fm_block size=16548
0(3036) fm_malloc_init(0x40271000, 67108864), start=0x40271000
0(3036) shm_mem_init: success
0(0) core dump limits set to 4294967295
0(0) DEBUG: init_mod: mysql
0(0) mysql: MySQL client version is 4.0.24
0(0) DEBUG: init_mod: sl_module
stateless - initializing
0(0) DEBUG: register_fifo_cmd: new command (sl_stats) registered
0(0) unixsock_register_cmd: New command (sl_stats) registered
0(0) DEBUG: MD5 calculated: 329cfeaa6ded039da25ff8cbb8668bd2
0(0) DEBUG: init_mod: xlog
0(0) XLOG: initializing ...
0(0) DEBUG: init_mod: auth
0(0) AUTH module - initializing
0(0) find_export: found <sl_send_reply> in module sl_module
[/usr/lib/openser/modules/sl.so]
0(0) DEBUG: init_mod: auth_db
0(0) AUTH_DB module - initializing
0(0) find_mod_export: found <db_use_table> in module mysql
[/usr/lib/openser/modules/mysql.so]
0(0) find_mod_export: found <db_init> in module mysql
[/usr/lib/openser/modules/mysql.so]
0(0) find_mod_export: found <db_close> in module mysql
[/usr/lib/openser/modules/mysql.so]
0(0) find_mod_export: found <db_query> in module mysql
[/usr/lib/openser/modules/mysql.so]
0(0) find_mod_export: found <db_raw_query> in module mysql
[/usr/lib/openser/modules/mysql.so]
0(0) find_mod_export: found <db_free_result> in module mysql
[/usr/lib/openser/modules/mysql.so]
0(0) find_mod_export: found <db_insert> in module mysql
[/usr/lib/openser/modules/mysql.so]
0(0) find_mod_export: found <db_delete> in module mysql
[/usr/lib/openser/modules/mysql.so]
0(0) find_mod_export: found <db_update> in module mysql
[/usr/lib/openser/modules/mysql.so]
0(0) find_mod_export: found <db_replace> in module mysql
[/usr/lib/openser/modules/mysql.so]
0(0) find_export: found <bind_auth> in module auth
[/usr/lib/openser/modules/auth.so]
0(0) find_export: found <sl_send_reply> in module sl_module
[/usr/lib/openser/modules/sl.so]
0(0) DEBUG: init_mod: uri_db
0(0) uri_db - initializing
0(0) find_mod_export: found <db_use_table> in module mysql
[/usr/lib/openser/modules/mysql.so]
0(0) find_mod_export: found <db_init> in module mysql
[/usr/lib/openser/modules/mysql.so]
0(0) find_mod_export: found <db_close> in module mysql
[/usr/lib/openser/modules/mysql.so]
0(0) find_mod_export: found <db_query> in module mysql
[/usr/lib/openser/modules/mysql.so]
0(0) find_mod_export: found <db_raw_query> in module mysql
[/usr/lib/openser/modules/mysql.so]
0(0) find_mod_export: found <db_free_result> in module mysql
[/usr/lib/openser/modules/mysql.so]
0(0) find_mod_export: found <db_insert> in module mysql
[/usr/lib/openser/modules/mysql.so]
0(0) find_mod_export: found <db_delete> in module mysql
[/usr/lib/openser/modules/mysql.so]
0(0) find_mod_export: found <db_update> in module mysql
[/usr/lib/openser/modules/mysql.so]
0(0) find_mod_export: found <db_replace> in module mysql
[/usr/lib/openser/modules/mysql.so]
0(0) db_init: Connection 'mysql://root@localhost/openser' not found in pool
0(0) new_connection: Opening MySQL connection: mysql://root:@localhost/openser
0(0) new_connection: Connection type is Localhost via UNIX socket
0(0) new_connection: Protocol version is 10
0(0) new_connection: Server version is 5.0.21-Debian_2.dotdeb.1-log
0(0) pool_remove: Removing connection from the pool
0(0) db_init: Connection 'mysql://root@localhost/openser' not found in pool
0(0) new_connection: Opening MySQL connection: mysql://root:@localhost/openser
0(0) new_connection: Connection type is Localhost via UNIX socket
0(0) new_connection: Protocol version is 10
0(0) new_connection: Server version is 5.0.21-Debian_2.dotdeb.1-log
0(0) pool_remove: Removing connection from the pool
0(0) fixing /usr/lib/openser/modules/xlog.so xlog
0(0) xl_parse_format: parsing [TEST]
0(0) xl_parse_format: format parsed OK: [1] items
0(0) INFO: udp_init: SO_RCVBUF is initially 110592
0(0) DEBUG: udp_init: trying SO_RCVBUF: 221184
0(0) DEBUG: setting SO_RCVBUF; set=221184,verify=221184
0(0) DEBUG: udp_init: trying SO_RCVBUF: 223232
0(0) DEBUG: setting SO_RCVBUF; set=223232,verify=221184
0(0) DEBUG: setting SO_RCVBUF has no effect
0(0) INFO: udp_init: SO_RCVBUF is finally 221184
0(0) WARNING: using only the first listen address (no fork)
0(0) DBG: open_fifo_server: no fifo will be opened
0(0) init_unixsock_socket: No unix domain socket will be opened
1(0) DEBUG:init_mod_child: PROC_TIMER , rank=-1, module=xlog
1(0) XLOG: init_child [-1] pid [3039]
1(0) DEBUG:init_mod_child: PROC_TIMER , rank=-1, module=auth_db
1(0) db_init: Connection 'mysql://root@localhost/openser' not found in pool
1(0) new_connection: Opening MySQL connection: mysql://root:@localhost/openser
0(3036) DEBUG:init_mod_child: CHILD , rank=1, module=xlog
0(3036) XLOG: init_child [1] pid [3036]
0(3036) DEBUG:init_mod_child: CHILD , rank=1, module=auth_db
0(3036) db_init: Connection 'mysql://root@localhost/openser' not found in pool
0(3036) new_connection: Opening MySQL connection: mysql://root:@localhost/openser
1(3039) new_connection: Connection type is Localhost via UNIX socket
1(3039) new_connection: Protocol version is 10
1(3039) new_connection: Server version is 5.0.21-Debian_2.dotdeb.1-log
1(3039) DEBUG:init_mod_child: PROC_TIMER , rank=-1, module=uri_db
0(3036) SIGCHLD received: we do not worry about grand-children
0(3036) new_connection: Connection type is Localhost via UNIX socket
0(3036) new_connection: Protocol version is 10
0(3036) new_connection: Server version is 5.0.21-Debian_2.dotdeb.1-log
0(3036) DEBUG:init_mod_child: CHILD , rank=1, module=uri_db
/etc/init.d/openser: line 118: 3036 Segmentation fault start-stop-daemon --start
--quiet --pidfile $PIDFILE --exec $DAEMON -- $OPTIONS
voip:/etc/openser#
------------------------------------------------------------------------
_______________________________________________
Users mailing list
Users(a)openser.org
http://openser.org/cgi-bin/mailman/listinfo/users