[Serusers] <db_use_table> in module sql not found

Jesus Bernardo Ruiz Flores jesus.ruiz at aes.com.bo
Fri Jul 9 17:27:59 CEST 2004


I'm testing this version:

version: ser 0.8.13-dev-33-usrloc (i386/linux)
flags: STATS:Off, USE_IPV6, USE_TCP, DISABLE_NAGLE, USE_MCAST, DNS_IP_HACK, SHM_MEM, SHM_MMAP, PKG_MALLOC, F_MALLOC, FAST_LOCK-ADAPTIVE_WAIT
ADAPTIVE_WAIT_LOOPS=1024, MAX_RECV_BUFFER_SIZE 262144, MAX_LISTEN 16, MAX_URI_SIZE 1024, BUF_SIZE 65535
@(#) $Id: main.c,v 1.188 2004/05/03 12:18:10 andrei Exp $
main.c compiled on 10:49:13 Jul  9 2004 with gcc 3.3

I'm running a Fedora core 2 Box.

when i try to start the ser server i receive the following messages:

Jul  9 11:14:40 gateway ser: ser shutdown failed
Jul  9 11:14:41 gateway ser:  0(11006) loading module /usr/local/lib/ser/modules/mysql.so
Jul  9 11:14:41 gateway ser:  0(11006) loading module /usr/local/lib/ser/modules/sl.so
Jul  9 11:14:41 gateway ser:  0(11006) loading module /usr/local/lib/ser/modules/tm.so
Jul  9 11:14:41 gateway ser:  0(11006) loading module /usr/local/lib/ser/modules/rr.so
Jul  9 11:14:41 gateway ser:  0(11006) loading module /usr/local/lib/ser/modules/maxfwd.so
Jul  9 11:14:41 gateway ser:  0(11006) loading module /usr/local/lib/ser/modules/usrloc.so
Jul  9 11:14:41 gateway ser:  0(11006) loading module /usr/local/lib/ser/modules/registrar.so
Jul  9 11:14:41 gateway ser:  0(11006) loading module /usr/local/lib/ser/modules/nathelper.so
Jul  9 11:14:41 gateway ser:  0(11006) loading module /usr/local/lib/ser/modules/auth.so
Jul  9 11:14:41 gateway ser:  0(11006) loading module /usr/local/lib/ser/modules/auth_db.so
Jul  9 11:14:41 gateway ser:  0(11006) loading module /usr/local/lib/ser/modules/enum.so
Jul  9 11:14:41 gateway ser:  0(11006) loading module /usr/local/lib/ser/modules/acc.so
Jul  9 11:14:41 gateway ser:  0(11006) set_mod_param_regex: enum matches module enum
Jul  9 11:14:41 gateway ser:  0(11006) set_mod_param_regex: found <domain_suffix> in module enum [/usr/local/lib/ser/modules/enum.so]
Jul  9 11:14:41 gateway ser:  0(11006) set_mod_param_regex: usrloc matches module usrloc
Jul  9 11:14:41 gateway ser:  0(11006) set_mod_param_regex: found <db_mode> in module usrloc [/usr/local/lib/ser/modules/usrloc.so]
Jul  9 11:14:41 gateway ser:  0(11006) set_mod_param_regex: auth_db matches module auth_db
Jul  9 11:14:41 gateway ser:  0(11006) set_mod_param_regex: found <db_url> in module auth_db [/usr/local/lib/ser/modules/auth_db.so]
Jul  9 11:14:41 gateway ser:  0(11006) set_mod_param_regex: usrloc matches module usrloc
Jul  9 11:14:41 gateway ser:  0(11006) set_mod_param_regex: found <db_url> in module usrloc [/usr/local/lib/ser/modules/usrloc.so]
Jul  9 11:14:41 gateway ser:  0(11006) set_mod_param_regex: acc matches module acc
Jul  9 11:14:41 gateway ser:  0(11006) set_mod_param_regex: found <db_url> in module acc [/usr/local/lib/ser/modules/acc.so]
Jul  9 11:14:41 gateway ser:  0(11006) set_mod_param_regex: auth_db matches module auth_db
Jul  9 11:14:41 gateway ser:  0(11006) set_mod_param_regex: found <calculate_ha1> in module auth_db [/usr/local/lib/ser/modules/auth_db.so]
Jul  9 11:14:41 gateway ser:  0(11006) set_mod_param_regex: auth_db matches module auth_db
Jul  9 11:14:41 gateway ser:  0(11006) set_mod_param_regex: found <password_column> in module auth_db [/usr/local/lib/ser/modules/auth_db.so]
Jul  9 11:14:41 gateway ser:  0(11006) set_mod_param_regex: rr matches module rr
Jul  9 11:14:41 gateway ser:  0(11006) set_mod_param_regex: found <enable_full_lr> in module rr [/usr/local/lib/ser/modules/rr.so]
Jul  9 11:14:41 gateway ser:  0(11006) find_export: found <mf_process_maxfwd_header> in module maxfwd_module [/usr/local/lib/ser/modules/maxfwd.so]
Jul  9 11:14:41 gateway ser:  0(11006) find_export: found <sl_send_reply> in module sl_module [/usr/local/lib/ser/modules/sl.so]
Jul  9 11:14:41 gateway ser:  0(11006) find_export: found <sl_send_reply> in module sl_module [/usr/local/lib/ser/modules/sl.so]
Jul  9 11:14:41 gateway ser:  0(11006) find_export: found <record_route> in module rr [/usr/local/lib/ser/modules/rr.so]
Jul  9 11:14:41 gateway ser:  0(11006) find_export: found <loose_route> in module rr [/usr/local/lib/ser/modules/rr.so]
Jul  9 11:14:41 gateway ser:  0(11006) find_export: found <t_relay> in module tm [/usr/local/lib/ser/modules/tm.so]
Jul  9 11:14:41 gateway ser:  0(11006) find_export: found <www_authorize> in module auth_db [/usr/local/lib/ser/modules/auth_db.so]
Jul  9 11:14:41 gateway ser:  0(11006) find_export: found <www_challenge> in module auth [/usr/local/lib/ser/modules/auth.so]
Jul  9 11:14:41 gateway ser:  0(11006) find_export: found <save> in module registrar [/usr/local/lib/ser/modules/registrar.so]
Jul  9 11:14:42 gateway ser:  0(11006) find_export: found <lookup> in module registrar [/usr/local/lib/ser/modules/registrar.so]
Jul  9 11:14:42 gateway ser:  0(11006) find_export: found <sl_send_reply> in module sl_module [/usr/local/lib/ser/modules/sl.so]
Jul  9 11:14:42 gateway ser:  0(11006) find_export: found <t_relay> in module tm [/usr/local/lib/ser/modules/tm.so]
Jul  9 11:14:42 gateway ser:  0(11006) find_export: found <sl_reply_error> in module sl_module [/usr/local/lib/ser/modules/sl.so]
Jul  9 11:14:42 gateway ser:  0(11006) find_export: found <t_relay> in module tm [/usr/local/lib/ser/modules/tm.so]
Jul  9 11:14:42 gateway ser:  0(11006) find_export: found <sl_reply_error> in module sl_module [/usr/local/lib/ser/modules/sl.so]
Jul  9 11:14:42 gateway ser:  0(11006) find_export: found <record_route> in module rr [/usr/local/lib/ser/modules/rr.so]
Jul  9 11:14:42 gateway ser:  0(11006) find_export: found <t_relay> in module tm [/usr/local/lib/ser/modules/tm.so]
Jul  9 11:14:42 gateway ser:  0(11006) find_export: found <sl_reply_error> in module sl_module [/usr/local/lib/ser/modules/sl.so]
Jul  9 11:14:42 gateway ser:  0(11006) find_export: found <record_route> in module rr [/usr/local/lib/ser/modules/rr.so]
Jul  9 11:14:42 gateway ser:  0(11006) find_export: found <t_relay> in module tm [/usr/local/lib/ser/modules/tm.so]
Jul  9 11:14:42 gateway ser:  0(11006) find_export: found <sl_reply_error> in module sl_module [/usr/local/lib/ser/modules/sl.so]
Jul  9 11:14:42 gateway ser:  0(11006) routing table 0:
Jul  9 11:14:43 gateway ser:  0(11006) if ( 0(11006) NOT(  0(11006)  external_module_call( 0(11006) f_ptr<0xe11ad0> 0(11006) , "10" 0(11006) );  0(11006)  external_module_call( 0(11006) f_ptr<0xe11ad0> 0(11006) , "10" 0(11006) );  0(11006)  ) 0(11006) ) { 0(11006)  external_module_call( 0(11006) f_ptr<0x330880> 0(11006) , "483" 0(11006) , "Too Many Hops" 0(11006) );  0(11006) drop( 0(11006) type<0> 0(11006) );  0(11006) } else { 0(11006) };  0(11006) if ( 0(11006) UNKNOWN 0(11006) <UNKNOWN> 0(11006) 65535 0(11006) ) { 0(11006)  external_module_call( 0(11006) f_ptr<0x330880> 0(11006) , "513" 0(11006) , "Message too big" 0(11006) );  0(11006) drop( 0(11006) type<0> 0(11006) );  0(11006) } else { 0(11006) };  0(11006)  external_module_call( 0(11006) f_ptr<0x364a40> 0(11006) );  0(11006) if ( 0(11006)  external_module_call( 0(11006) f_ptr<0x362d40> 0(11006) );  0(11006)  external_module_call( 0(11006) f_ptr<0x362d40> 0(11006) );  0(11006) ) { 0(11006)  external_module_call( 0(11006) f_ptr<0xf6c4e0> 0(11006) );  0(
Jul  9 11:14:45 gateway ser: 1006) f_ptr<0xf473f0> 0(11006) , "acelerate.com" 0(11006) , "subscriber" 0(11006) );  0(11006)  external_module_call( 0(11006) f_ptr<0xf473f0> 0(11006) , "acelerate.com" 0(11006) , "subscriber" 0(11006) );  0(11006)  ) 0(11006) ) { 0(11006)  external_module_call( 0(11006) f_ptr<0x1555c0> 0(11006) , "acelerate.com" 0(11006) , "0" 0(11006) );  0(11006) drop( 0(11006) type<0> 0(11006) );  0(11006) } else { 0(11006) };  0(11006)  external_module_call( 0(11006) f_ptr<0x210070> 0(11006) , "location" 0(11006) );  0(11006) drop( 0(11006) type<0> 0(11006) );  0(11006) } else { 0(11006) };  0(11006) if ( 0(11006) uri 0(11006) =~ 0(11006) "^sip:011(.+@)?(200\.105\.128\.37|(gateway\.)?acelerate\.com)([:;\?].*)?$" 0(11006) ) { 0(11006) route( 0(11006) 2 0(11006) );  0(11006) drop( 0(11006) type<0> 0(11006) );  0(11006) } else { 0(11006) };  0(11006) if ( 0(11006) uri 0(11006) =~ 0(11006) "^sip:7(.+@)?(200\.105\.128\.37|(gateway\.)?acelerate\.com)([:;\?].*)?$" 0(11006) ) { 0(11006) route( 0(1100
Jul  9 11:14:45 gateway ser: f_ptr<0x20eac0> 0(11006) , "location" 0(11006) );  0(11006)  external_module_call( 0(11006) f_ptr<0x20eac0> 0(11006) , "location" 0(11006) );  0(11006)  ) 0(11006) ) { 0(11006)  external_module_call( 0(11006) f_ptr<0x330880> 0(11006) , "404" 0(11006) , "Not Found" 0(11006) );  0(11006) drop( 0(11006) type<0> 0(11006) );  0(11006) } else { 0(11006) };  0(11006) } else { 0(11006) };  0(11006) if ( 0(11006) NOT(  0(11006)  external_module_call( 0(11006) f_ptr<0xf6c4e0> 0(11006) );  0(11006)  external_module_call( 0(11006) f_ptr<0xf6c4e0> 0(11006) );  0(11006)  ) 0(11006) ) { 0(11006)  external_module_call( 0(11006) f_ptr<0x3308c0> 0(11006) );  0(11006) } else { 0(11006) };  0(11006) if ( 0(11006) NOT(  0(11006)  external_module_call( 0(11006) f_ptr<0xf6c4e0> 0(11006) );  0(11006)  external_module_call( 0(11006) f_ptr<0xf6c4e0> 0(11006) );  0(11006)  ) 0(11006) ) { 0(11006)  external_module_call( 0(11006) f_ptr<0x3308c0> 0(11006) );  0(11006) } else { 0(11006) };  0(11006) 
Jul  9 11:14:45 gateway ser:  0(11006) routing table 1:
Jul  9 11:14:45 gateway ser:  0(11006) sethostport( 0(11006) "200.105.128.6:5060" 0(11006) );  0(11006) if ( 0(11006) NOT(  0(11006)  external_module_call( 0(11006) f_ptr<0xf6c4e0> 0(11006) );  0(11006)  external_module_call( 0(11006) f_ptr<0xf6c4e0> 0(11006) );  0(11006)  ) 0(11006) ) { 0(11006)  external_module_call( 0(11006) f_ptr<0x3308c0> 0(11006) );  0(11006) } else { 0(11006) };  0(11006) if ( 0(11006) NOT(  0(11006)  external_module_call( 0(11006) f_ptr<0xf6c4e0> 0(11006) );  0(11006)  external_module_call( 0(11006) f_ptr<0xf6c4e0> 0(11006) );  0(11006)  ) 0(11006) ) { 0(11006)  external_module_call( 0(11006) f_ptr<0x3308c0> 0(11006) );  0(11006) } else { 0(11006) };  0(11006) 
Jul  9 11:14:45 gateway ser:  0(11006) routing table 2:
Jul  9 11:14:46 gateway ser:  0(11006) setflag( 0(11006) 1 0(11006) );  0(11006) if ( 0(11006) method 0(11006) == 0(11006) "INVITE" 0(11006) ) { 0(11006)  external_module_call( 0(11006) f_ptr<0x364a40> 0(11006) );  0(11006) strip( 0(11006) 3 0(11006) );  0(11006) sethostport( 0(11006) "200.105.128.6:5060" 0(11006) );  0(11006) prefix( 0(11006) "8888#" 0(11006) );  0(11006) if ( 0(11006) NOT(  0(11006)  external_module_call( 0(11006) f_ptr<0xf6c4e0> 0(11006) );  0(11006)  external_module_call( 0(11006) f_ptr<0xf6c4e0> 0(11006) );  0(11006)  ) 0(11006) ) { 0(11006)  external_module_call( 0(11006) f_ptr<0x3308c0> 0(11006) );  0(11006) } else { 0(11006) };  0(11006) } else { 0(11006) };  0(11006) if ( 0(11006) OR(  0(11006) method 0(11006) == 0(11006) "CANCEL" 0(11006) ,  0(11006) method 0(11006) == 0(11006) "BYE" 0(11006)  ) 0(11006) ) { 0(11006) route( 0(11006) 1 0(11006) );  0(11006) } else { 0(11006) };  0(11006) if ( 0(11006) method 0(11006) == 0(11006) "INVITE" 0(11006) ) { 0(11006)  external_module_call( 0(
Jul  9 11:14:46 gateway ser:  0(11006) routing table 3:
Jul  9 11:14:46 gateway ser:  0(11006) setflag( 0(11006) 1 0(11006) );  0(11006) if ( 0(11006) method 0(11006) == 0(11006) "INVITE" 0(11006) ) { 0(11006)  external_module_call( 0(11006) f_ptr<0x364a40> 0(11006) );  0(11006) sethostport( 0(11006) "200.105.128.6:5060" 0(11006) );  0(11006) prefix( 0(11006) "8888#591" 0(11006) );  0(11006) if ( 0(11006) NOT(  0(11006)  external_module_call( 0(11006) f_ptr<0xf6c4e0> 0(11006) );  0(11006)  external_module_call( 0(11006) f_ptr<0xf6c4e0> 0(11006) );  0(11006)  ) 0(11006) ) { 0(11006)  external_module_call( 0(11006) f_ptr<0x3308c0> 0(11006) );  0(11006) } else { 0(11006) };  0(11006) } else { 0(11006) };  0(11006) if ( 0(11006) OR(  0(11006) method 0(11006) == 0(11006) "CANCEL" 0(11006) ,  0(11006) method 0(11006) == 0(11006) "BYE" 0(11006)  ) 0(11006) ) { 0(11006) route( 0(11006) 1 0(11006) );  0(11006) } else { 0(11006) };  0(11006) if ( 0(11006) method 0(11006) == 0(11006) "INVITE" 0(11006) ) { 0(11006)  external_module_call( 0(11006) f_ptr<0x364a40> 0(11006) );  0
Jul  9 11:14:55 gateway ser: Listening on 
Jul  9 11:14:55 gateway ser:              udp: 127.0.0.1 [127.0.0.1]:5060
Jul  9 11:14:55 gateway ser:              udp: 200.105.128.37 [200.105.128.37]:5060
Jul  9 11:14:55 gateway ser:              tcp: 127.0.0.1 [127.0.0.1]:5060
Jul  9 11:14:55 gateway ser:              tcp: 200.105.128.37 [200.105.128.37]:5060
Jul  9 11:14:55 gateway ser: Aliases: 
Jul  9 11:14:55 gateway ser:              tcp: localhost:5060
Jul  9 11:14:55 gateway ser:              tcp: localhost.localdomain:5060
Jul  9 11:14:55 gateway ser:              tcp: gateway:5060
Jul  9 11:14:55 gateway ser:              tcp: acelerate.com:5060
Jul  9 11:14:55 gateway ser:              udp: localhost:5060
Jul  9 11:14:55 gateway ser:              udp: localhost.localdomain:5060
Jul  9 11:14:55 gateway ser:              udp: gateway:5060
Jul  9 11:14:55 gateway ser:              udp: acelerate.com:5060
Jul  9 11:14:55 gateway ser:              *: gateway.acelerate.com:*
Jul  9 11:14:55 gateway ser: 
Jul  9 11:14:55 gateway ser:  0(0) core dump limits set to 4294967295
Jul  9 11:14:55 gateway ser:  0(0) DEBUG: init_mod: sl_module
Jul  9 11:14:55 gateway ser: stateless - initializing
Jul  9 11:14:55 gateway ser:  0(0) DEBUG: register_fifo_cmd: new command (sl_stats) registered
Jul  9 11:14:55 gateway ser:  0(0) unixsock_register_cmd: New command (sl_stats) registered
Jul  9 11:14:55 gateway ser:  0(0) DEBUG: MD5 calculated: b27e1a1d33761e85846fc98f5f3a7e58
Jul  9 11:14:56 gateway ser:  0(0) DEBUG: init_mod: tm
Jul  9 11:14:56 gateway ser:  0(0) TM - (size of cell=2772) initializing...
Jul  9 11:14:56 gateway ser:  0(0) Call-ID initialization: '7f3abbf7'
Jul  9 11:14:56 gateway ser:  0(0) DEBUG: register_fifo_cmd: new command (t_uac_dlg) registered
Jul  9 11:14:56 gateway ser:  0(0) DEBUG: register_fifo_cmd: new command (t_uac_cancel) registered
Jul  9 11:14:56 gateway ser:  0(0) DEBUG: register_fifo_cmd: new command (t_hash) registered
Jul  9 11:14:56 gateway ser:  0(0) DEBUG: register_fifo_cmd: new command (t_reply) registered
Jul  9 11:14:56 gateway ser:  0(0) unixsock_register_cmd: New command (t_uac_dlg) registered
Jul  9 11:14:56 gateway ser:  0(0) unixsock_register_cmd: New command (t_uac_cancel) registered
Jul  9 11:14:56 gateway ser:  0(0) unixsock_register_cmd: New command (t_hash) registered
Jul  9 11:14:56 gateway ser:  0(0) unixsock_register_cmd: New command (t_reply) registered
Jul  9 11:14:56 gateway ser:  0(0) DEBUG: lock_initialize: lock initialization started
Jul  9 11:14:56 gateway ser:  0(0) DEBUG: register_fifo_cmd: new command (t_stats) registered
Jul  9 11:14:56 gateway ser:  0(0) unixsock_register_cmd: New command (t_stats) registered
Jul  9 11:14:56 gateway ser:  0(0) DEBUG: MD5 calculated: 533cb9e91f4b999cf76861cbb9ed54ed
Jul  9 11:14:56 gateway ser:  0(0) DEBUG: MD5 calculated: a6a1c5f60faecf035a1ae5b6e96e979a
Jul  9 11:14:56 gateway ser:  0(0) DEBUG: init_mod: rr
Jul  9 11:14:56 gateway ser:  0(0) rr - initializing
Jul  9 11:14:56 gateway ser:  0(0) DEBUG: init_mod: maxfwd_module
Jul  9 11:14:56 gateway ser: Maxfwd module- initializing
Jul  9 11:14:56 gateway ser:  0(0) DEBUG: init_mod: usrloc
Jul  9 11:14:56 gateway ser:  0(0) usrloc - initializing
Jul  9 11:14:56 gateway ser:  0(0) DEBUG: register_fifo_cmd: new command (ul_stats) registered
Jul  9 11:14:56 gateway ser:  0(0) DEBUG: register_fifo_cmd: new command (ul_rm) registered
Jul  9 11:14:56 gateway ser:  0(0) DEBUG: register_fifo_cmd: new command (ul_rm_contact) registered
Jul  9 11:14:57 gateway ser:  0(0) DEBUG: register_fifo_cmd: new command (ul_dump) registered
Jul  9 11:14:57 gateway ser:  0(0) DEBUG: register_fifo_cmd: new command (ul_flush) registered
Jul  9 11:14:57 gateway ser:  0(0) DEBUG: register_fifo_cmd: new command (ul_add) registered
Jul  9 11:14:57 gateway ser:  0(0) DEBUG: register_fifo_cmd: new command (ul_show_contact) registered
Jul  9 11:14:57 gateway ser:  0(0) unixsock_register_cmd: New command (ul_stats) registered
Jul  9 11:14:57 gateway ser:  0(0) unixsock_register_cmd: New command (ul_rm) registered
Jul  9 11:14:57 gateway ser:  0(0) unixsock_register_cmd: New command (ul_rm_contact) registered
Jul  9 11:14:57 gateway ser:  0(0) unixsock_register_cmd: New command (ul_dump) registered
Jul  9 11:14:57 gateway ser:  0(0) unixsock_register_cmd: New command (ul_flush) registered
Jul  9 11:14:57 gateway ser:  0(0) unixsock_register_cmd: New command (ul_add) registered
Jul  9 11:14:57 gateway ser:  0(0) unixsock_register_cmd: New command (ul_show_contact) registered
Jul  9 11:14:57 gateway ser:  0(0) find_mod_export: <db_use_table> in module sql not found
Jul  9 11:14:57 gateway ser:  0(0) ERROR: mod_init(): Can't bind database module
Jul  9 11:14:57 gateway ser:  0(0) init_mod(): Error while initializing module usrloc
Jul  9 11:14:57 gateway ser: ERROR: error while initializing modules
Jul  9 11:14:57 gateway ser:  0(0) DEBUG: tm_shutdown : start
Jul  9 11:14:57 gateway ser:  0(0) DEBUG: unlink_timer_lists : empting DELETE list
Jul  9 11:14:57 gateway ser:  0(0) DEBUG: tm_shutdown : empting hash table
Jul  9 11:14:57 gateway ser:  0(0) DEBUG: tm_shutdown : releasing timers
Jul  9 11:14:57 gateway ser:  0(0) DEBUG: tm_shutdown : removing semaphores
Jul  9 11:14:57 gateway ser:  0(0) DEBUG: tm_shutdown : destroing tmcb lists
Jul  9 11:14:57 gateway ser:  0(0) DEBUG: tm_shutdown : done
Jul  9 11:14:57 gateway ser:  0(11008) shm_mem_destroy
Jul  9 11:14:57 gateway ser:  0(11008) destroying the shared memory lock
Jul  9 11:14:57 gateway ser: ser startup succeeded

I have attached my config file.

What could the problem be?
-------------- next part --------------
A non-text attachment was scrubbed...
Name: ser.cfg
Type: application/octet-stream
Size: 5066 bytes
Desc: not available
URL: <http://lists.sip-router.org/pipermail/sr-users/attachments/20040709/57b25226/attachment.obj>


More information about the sr-users mailing list