Hi List ,

Am trying to use ser with mysql.
When I start ser , the debug log shows a whole host of "get_connection(): Connection not found in the pool" messages

So what is going on ..? What am I doing wrong ?

I've pasted a segment of the debug log below ...

Any pointers in the right direction gratefully received..

thanks
Hemant

Listening on
             udp: 127.0.0.1 [127.0.0.1]:5060
             udp: 10.10.10.3 [10.10.10.3]:5060
             tcp: 127.0.0.1 [127.0.0.1]:5060
             tcp: 10.10.10.3 [10.10.10.3]:5060
Aliases:
             tcp: Hermes:5060
             tcp: localhost:5060
             udp: Hermes:5060
             udp: localhost:5060

 0(10317) qm_malloc_init: QM_OPTIMIZE=16384, /ROUNDTO=1024
 0(10317) qm_malloc_init: QM_HASH_SIZE=1043, qm_block size=20884
 0(10317) qm_malloc_init(0x402bc000, 33554432), start=0x402bc000
 0(10317) qm_malloc_init: size= 33554432, init_overhead=20912
 0(10317) shm_mem_init: success
Hermes:/usr/local/sbin #  0(0) core dump limits set to 4294967295
 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: b27e1a1d33761e85846fc98f5f3a7e58
 0(0) DEBUG: init_mod: tm
 0(0) TM - (size of cell=2776, sip_msg=760) initializing...
 0(0) Call-ID initialization: '77fdbfd7'
 0(0) DEBUG: register_fifo_cmd: new command (t_uac_dlg) registered
 0(0) DEBUG: register_fifo_cmd: new command (t_uac_cancel) registered
 0(0) DEBUG: register_fifo_cmd: new command (t_hash) registered
 0(0) DEBUG: register_fifo_cmd: new command (t_reply) registered
 0(0) unixsock_register_cmd: New command (t_uac_dlg) registered
 0(0) unixsock_register_cmd: New command (t_uac_cancel) registered
 0(0) unixsock_register_cmd: New command (t_hash) registered
 0(0) unixsock_register_cmd: New command (t_reply) registered
 0(0) DEBUG: lock_initialize: lock initialization started
 0(0) DEBUG: register_fifo_cmd: new command (t_stats) registered
 0(0) unixsock_register_cmd: New command (t_stats) registered
 0(0) DEBUG: MD5 calculated: 533cb9e91f4b999cf76861cbb9ed54ed
 0(0) DEBUG: MD5 calculated: a6a1c5f60faecf035a1ae5b6e96e979a
 0(0) DEBUG: init_mod: rr
 0(0) rr - initializing
 0(0) DEBUG: init_mod: maxfwd
 0(0) Maxfwd module- initializing
 0(0) DEBUG: init_mod: usrloc
 0(0) usrloc - initializing
 0(0) DEBUG: register_fifo_cmd: new command (ul_stats) registered
 0(0) DEBUG: register_fifo_cmd: new command (ul_rm) registered
 0(0) DEBUG: register_fifo_cmd: new command (ul_rm_contact) registered
 0(0) DEBUG: register_fifo_cmd: new command (ul_dump) registered
 0(0) DEBUG: register_fifo_cmd: new command (ul_flush) registered
 0(0) DEBUG: register_fifo_cmd: new command (ul_add) registered
 0(0) DEBUG: register_fifo_cmd: new command (ul_show_contact) registered
 0(0) unixsock_register_cmd: New command (ul_stats) registered
 0(0) unixsock_register_cmd: New command (ul_rm) registered
 0(0) unixsock_register_cmd: New command (ul_rm_contact) registered
 0(0) unixsock_register_cmd: New command (ul_dump) registered
 0(0) unixsock_register_cmd: New command (ul_flush) registered
 0(0) unixsock_register_cmd: New command (ul_add) registered
 0(0) unixsock_register_cmd: New command (ul_show_contact) registered
 0(0) find_mod_export: found <db_use_table> in module mysql
[/usr/local/lib/ser/modules/mysql.so]
 0(0) find_mod_export: found <db_init> in module mysql
[/usr/local/lib/ser/modules/mysql.so]
 0(0) find_mod_export: found <db_close> in module mysql
[/usr/local/lib/ser/modules/mysql.so]
 0(0) find_mod_export: found <db_query> in module mysql
[/usr/local/lib/ser/modules/mysql.so]
 0(0) find_mod_export: found <db_raw_query> in module mysql
[/usr/local/lib/ser/modules/mysql.so]
 0(0) find_mod_export: found <db_free_result> in module mysql
[/usr/local/lib/ser/modules/mysql.so]
 0(0) find_mod_export: found <db_insert> in module mysql
[/usr/local/lib/ser/modules/mysql.so]
 0(0) find_mod_export: found <db_delete> in module mysql
[/usr/local/lib/ser/modules/mysql.so]
 0(0) find_mod_export: found <db_update> in module mysql
[/usr/local/lib/ser/modules/mysql.so]
 0(0) DEBUG: init_mod: registrar
 0(0) registrar - initializing
 0(0) find_export: found <sl_send_reply> in module sl_module
[/usr/local/lib/ser/modules/sl.so]
 0(0) find_export: found <ul_bind_usrloc> in module usrloc
[/usr/local/lib/ser/modules/usrloc.so]
 0(0) find_export: found <ul_register_udomain> in module usrloc
[/usr/local/lib/ser/modules/usrloc.so]
 0(0) find_export: found <ul_get_all_ucontacts> in module usrloc
[/usr/local/lib/ser/modules/usrloc.so]
 0(0) find_export: found <ul_insert_urecord> in module usrloc
[/usr/local/lib/ser/modules/usrloc.so]
 0(0) find_export: found <ul_delete_urecord> in module usrloc
[/usr/local/lib/ser/modules/usrloc.so]
 0(0) find_export: found <ul_get_urecord> in module usrloc
[/usr/local/lib/ser/modules/usrloc.so]
 0(0) find_export: found <ul_lock_udomain> in module usrloc
[/usr/local/lib/ser/modules/usrloc.so]
 0(0) find_export: found <ul_unlock_udomain> in module usrloc
[/usr/local/lib/ser/modules/usrloc.so]
 0(0) find_export: found <ul_release_urecord> in module usrloc
[/usr/local/lib/ser/modules/usrloc.so]
 0(0) find_export: found <ul_insert_ucontact> in module usrloc
[/usr/local/lib/ser/modules/usrloc.so]
 0(0) find_export: found <ul_delete_ucontact> in module usrloc
[/usr/local/lib/ser/modules/usrloc.so]
 0(0) find_export: found <ul_get_ucontact> in module usrloc
[/usr/local/lib/ser/modules/usrloc.so]
 0(0) find_export: found <ul_update_ucontact> in module usrloc
[/usr/local/lib/ser/modules/usrloc.so]
 0(0) find_export: found <ul_register_watcher> in module usrloc
[/usr/local/lib/ser/modules/usrloc.so]
 0(0) find_export: found <ul_unregister_watcher> in module usrloc
[/usr/local/lib/ser/modules/usrloc.so]
 0(0) find_export: found <ul_register_ulcb> in module usrloc
[/usr/local/lib/ser/modules/usrloc.so]
 0(0) DEBUG: init_mod: textops
textops - 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/local/lib/ser/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/local/lib/ser/modules/mysql.so]
 0(0) find_mod_export: found <db_init> in module mysql
[/usr/local/lib/ser/modules/mysql.so]
 0(0) find_mod_export: found <db_close> in module mysql
[/usr/local/lib/ser/modules/mysql.so]
 0(0) find_mod_export: found <db_query> in module mysql
[/usr/local/lib/ser/modules/mysql.so]
 0(0) find_mod_export: found <db_raw_query> in module mysql
[/usr/local/lib/ser/modules/mysql.so]
 0(0) find_mod_export: found <db_free_result> in module mysql
[/usr/local/lib/ser/modules/mysql.so]
 0(0) find_mod_export: found <db_insert> in module mysql
[/usr/local/lib/ser/modules/mysql.so]
 0(0) find_mod_export: found <db_delete> in module mysql
[/usr/local/lib/ser/modules/mysql.so]
 0(0) find_mod_export: found <db_update> in module mysql
[/usr/local/lib/ser/modules/mysql.so]
 0(0) find_export: found <pre_auth> in module auth
[/usr/local/lib/ser/modules/auth.so]
 0(0) find_export: found <post_auth> in module auth
[/usr/local/lib/ser/modules/auth.so]
 0(0) find_export: found <sl_send_reply> in module sl_module
[/usr/local/lib/ser/modules/sl.so]
 0(0) fixing /usr/local/lib/ser/modules/maxfwd.so mf_process_maxfwd_header
 0(0) fixing /usr/local/lib/ser/modules/sl.so sl_send_reply
 0(0) fixing /usr/local/lib/ser/modules/sl.so sl_send_reply
 0(0) fixing /usr/local/lib/ser/modules/rr.so record_route
 0(0) fixing /usr/local/lib/ser/modules/rr.so loose_route
 0(0) fixing /usr/local/lib/ser/modules/textops.so append_hf
 0(0) fixing /usr/local/lib/ser/modules/textops.so append_hf
 0(0) fixing /usr/local/lib/ser/modules/auth_db.so www_authorize
 0(0) get_connection(): Connection not found in the pool
 0(0) release_connection(): Removing connection from the pool
 0(0) fixing /usr/local/lib/ser/modules/auth.so www_challenge
 0(0) fixing /usr/local/lib/ser/modules/registrar.so save
 0(0) get_connection(): Connection not found in the pool
 0(0) preload_udomain(): Table is empty
 0(0) release_connection(): Removing connection from the pool
 0(0) fixing /usr/local/lib/ser/modules/registrar.so lookup
 0(0) get_connection(): Connection not found in the pool
 0(0) preload_udomain(): Table is empty
 0(0) release_connection(): Removing connection from the pool
 0(0) fixing /usr/local/lib/ser/modules/textops.so append_hf
 0(0) fixing /usr/local/lib/ser/modules/registrar.so lookup
 0(0) fixing /usr/local/lib/ser/modules/sl.so sl_send_reply
 0(0) fixing /usr/local/lib/ser/modules/textops.so append_hf
 0(0) fixing /usr/local/lib/ser/modules/tm.so t_relay
 0(0) fixing /usr/local/lib/ser/modules/sl.so sl_reply_error
 0(0) INFO: udp_init: SO_RCVBUF is initially 111616
 0(0) DEBUG: udp_init: trying SO_RCVBUF: 223232
 0(0) DEBUG: setting SO_RCVBUF; set=223232,verify=223232
 0(0) DEBUG: udp_init: trying SO_RCVBUF: 225280
 0(0) DEBUG: setting SO_RCVBUF; set=225280,verify=223232
 0(0) DEBUG: setting SO_RCVBUF has no effect
 0(0) INFO: udp_init: SO_RCVBUF is finally 223232
 0(0) INFO: udp_init: SO_RCVBUF is initially 111616
 0(0) DEBUG: udp_init: trying SO_RCVBUF: 223232
 0(0) DEBUG: setting SO_RCVBUF; set=223232,verify=223232
 0(0) DEBUG: udp_init: trying SO_RCVBUF: 225280
 0(0) DEBUG: setting SO_RCVBUF; set=225280,verify=223232
 0(0) DEBUG: setting SO_RCVBUF has no effect
 0(0) INFO: udp_init: SO_RCVBUF is finally 223232
 0(0) DBG: open_uac_fifo: opening fifo...
 0(0) DEBUG: FIFO created @ /tmp/ser_fifo
 0(0) DEBUG: fifo /tmp/ser_fifo opened, mode=432
 0(0) init_unixsock_socket: No unix domain socket will be opened
 1(10323) INFO: fifo process starting: 10323
 1(10323) DEBUG: init_mod_child (-2): tm
 1(10323) DEBUG: callid: '77fdbfd7-10323@127.0.0.1'
 1(10323) DEBUG: init_mod_child (-2): usrloc
 1(10323) get_connection(): Connection not found in the pool
 1(10323) DEBUG: init_mod_child (-2): auth_db
 1(10323) get_connection(): Connection not found in the pool
 1(10323) SER: open_uac_fifo: fifo server up at /tmp/ser_fifo...
 1(10323) DEBUG: register_fifo_cmd: new command (print) registered
 1(10323) DEBUG: register_fifo_cmd: new command (uptime) registered
 1(10323) DEBUG: register_fifo_cmd: new command (version) registered
 1(10323) DEBUG: register_fifo_cmd: new command (pwd) registered
 1(10323) DEBUG: register_fifo_cmd: new command (arg) registered
 1(10323) DEBUG: register_fifo_cmd: new command (which) registered
 1(10323) DEBUG: register_fifo_cmd: new command (ps) registered
 1(10323) DEBUG: register_fifo_cmd: new command (kill) registered
 1(10323) WARNING: no fifo_db_url given - fifo DB commands disabled!
 2(10324) DEBUG: init_mod_child (1): tm
 2(10324) DEBUG: callid: '77fdbfd7-10324@127.0.0.1'
 2(10324) DEBUG: init_mod_child (1): usrloc
 2(10324) get_connection(): Connection not found in the pool
 2(10324) DEBUG: init_mod_child (1): auth_db
 2(10324) get_connection(): Connection not found in the pool
 3(10325) DEBUG: init_mod_child (2): tm
 3(10325) DEBUG: callid: '77fdbfd7-10325@127.0.0.1'
 3(10325) DEBUG: init_mod_child (2): usrloc
 3(10325) get_connection(): Connection not found in the pool
 3(10325) DEBUG: init_mod_child (2): auth_db
 3(10325) get_connection(): Connection not found in the pool
 4(10326) DEBUG: init_mod_child (3): tm
 4(10326) DEBUG: callid: '77fdbfd7-10326@127.0.0.1'
 4(10326) DEBUG: init_mod_child (3): usrloc
 4(10326) get_connection(): Connection not found in the pool
 4(10326) DEBUG: init_mod_child (3): auth_db
 4(10326) get_connection(): Connection not found in the pool
 5(10327) DEBUG: init_mod_child (4): tm
 5(10327) DEBUG: callid: '77fdbfd7-10327@127.0.0.1'
 5(10327) DEBUG: init_mod_child (4): usrloc
 5(10327) get_connection(): Connection not found in the pool
 6(10328) DEBUG: init_mod_child (5): tm
 6(10328) DEBUG: callid: '77fdbfd7-10328@127.0.0.1'
 6(10328) DEBUG: init_mod_child (5): usrloc
 6(10328) get_connection(): Connection not found in the pool
 7(0) DEBUG: init_mod_child (6): tm
 7(0) DEBUG: callid: '77fdbfd7-0@127.0.0.1'
 7(0) DEBUG: init_mod_child (6): usrloc
 7(0) get_connection(): Connection not found in the pool
 8(10341) DEBUG: init_mod_child (7): tm
 8(10341) DEBUG: callid: '77fdbfd7-10341@127.0.0.1'
 8(10341) DEBUG: init_mod_child (7): usrloc
 8(10341) get_connection(): Connection not found in the pool
 8(10341) DEBUG: init_mod_child (7): auth_db
 8(10341) get_connection(): Connection not found in the pool
 9(10342) DEBUG: init_mod_child (8): tm
 9(10342) DEBUG: callid: '77fdbfd7-10342@127.0.0.1'
 9(10342) DEBUG: init_mod_child (8): usrloc
 9(10342) get_connection(): Connection not found in the pool
 9(10342) DEBUG: init_mod_child (8): auth_db
 9(10342) get_connection(): Connection not found in the pool
10(10343) DEBUG: init_mod_child (1): tm
10(10343) DEBUG: callid: '77fdbfd7-10343@10.10.10.3'
10(10343) DEBUG: init_mod_child (1): usrloc
10(10343) get_connection(): Connection not found in the pool
10(10343) DEBUG: init_mod_child (1): auth_db
10(10343) get_connection(): Connection not found in the pool
11(10344) DEBUG: init_mod_child (2): tm
11(10344) DEBUG: callid: '77fdbfd7-10344@10.10.10.3'
11(10344) DEBUG: init_mod_child (2): usrloc
11(10344) get_connection(): Connection not found in the pool
12(10345) DEBUG: init_mod_child (3): tm
12(10345) DEBUG: callid: '77fdbfd7-10345@10.10.10.3'
12(10345) DEBUG: init_mod_child (3): usrloc
12(10345) get_connection(): Connection not found in the pool
13(10346) DEBUG: init_mod_child (4): tm
13(10346) DEBUG: callid: '77fdbfd7-10346@10.10.10.3'
13(10346) DEBUG: init_mod_child (4): usrloc
13(10346) get_connection(): Connection not found in the pool
14(10347) DEBUG: init_mod_child (5): tm
14(10347) DEBUG: callid: '77fdbfd7-10347@10.10.10.3'
14(10347) DEBUG: init_mod_child (5): usrloc
14(10347) get_connection(): Connection not found in the pool
15(0) DEBUG: init_mod_child (6): tm
15(0) DEBUG: callid: '77fdbfd7-0@10.10.10.3'
15(0) DEBUG: init_mod_child (6): usrloc
15(0) get_connection(): Connection not found in the pool
 5(10327) DEBUG: init_mod_child (4): auth_db
 5(10327) get_connection(): Connection not found in the pool
16(10361) DEBUG: init_mod_child (7): tm
16(10361) DEBUG: callid: '77fdbfd7-10361@10.10.10.3'
16(10361) DEBUG: init_mod_child (7): usrloc
16(10361) get_connection(): Connection not found in the pool
17(10362) DEBUG: init_mod_child (8): tm
17(10362) DEBUG: callid: '77fdbfd7-10362@10.10.10.3'
17(10362) DEBUG: init_mod_child (8): usrloc
17(10362) get_connection(): Connection not found in the pool
18(10363) DEBUG: init_mod_child (-1): tm
18(10363) DEBUG: callid: '77fdbfd7-10363@127.0.0.1'
18(10363) DEBUG: init_mod_child (-1): usrloc
18(10363) get_connection(): Connection not found in the pool
19(10364) DEBUG: init_mod_child (9): tm
19(10364) DEBUG: callid: '77fdbfd7-10364@127.0.0.1'
19(10364) DEBUG: init_mod_child (9): usrloc
19(10364) get_connection(): Connection not found in the pool
20(10365) DEBUG: init_mod_child (10): tm
20(10365) DEBUG: callid: '77fdbfd7-10365@127.0.0.1'
20(10365) DEBUG: init_mod_child (10): usrloc
20(10365) get_connection(): Connection not found in the pool
21(10366) DEBUG: init_mod_child (11): tm
21(10366) DEBUG: callid: '77fdbfd7-10366@127.0.0.1'
21(10366) DEBUG: init_mod_child (11): usrloc
21(10366) get_connection(): Connection not found in the pool
22(10367) DEBUG: init_mod_child (12): tm
22(10367) DEBUG: callid: '77fdbfd7-10367@127.0.0.1'
22(10367) DEBUG: init_mod_child (12): usrloc
22(10367) get_connection(): Connection not found in the pool
23(0) DEBUG: init_mod_child (13): tm
23(0) DEBUG: callid: '77fdbfd7-0@127.0.0.1'
23(0) DEBUG: init_mod_child (13): usrloc
23(0) get_connection(): Connection not found in the pool
 6(10328) DEBUG: init_mod_child (5): auth_db
 6(10328) get_connection(): Connection not found in the pool
 7(10329) DEBUG: init_mod_child (6): auth_db
 7(10329) get_connection(): Connection not found in the pool
11(10344) DEBUG: init_mod_child (2): auth_db
11(10344) get_connection(): Connection not found in the pool
12(10345) DEBUG: init_mod_child (3): auth_db
12(10345) get_connection(): Connection not found in the pool
 0(10319) DEBUG: init_mod_child (0): tm
 0(10319) DEBUG: callid: '77fdbfd7-10319@127.0.0.1'
 0(10319) DEBUG: init_mod_child (0): usrloc
 0(10319) get_connection(): Connection not found in the pool
24(10371) DEBUG: init_mod_child (14): tm
24(10371) DEBUG: callid: '77fdbfd7-10371@127.0.0.1'
24(10371) DEBUG: init_mod_child (14): usrloc
24(10371) get_connection(): Connection not found in the pool
25(10372) DEBUG: init_mod_child (15): tm
25(10372) DEBUG: callid: '77fdbfd7-10372@127.0.0.1'
25(10372) DEBUG: init_mod_child (15): usrloc
25(10372) get_connection(): Connection not found in the pool
26(10373) DEBUG: init_mod_child (16): tm
26(10373) DEBUG: callid: '77fdbfd7-10373@127.0.0.1'
26(10373) DEBUG: init_mod_child (16): usrloc
26(10373) get_connection(): Connection not found in the pool
27(10374) DEBUG: init_mod_child (-4): tm
27(10374) DEBUG: callid: '77fdbfd7-10374@127.0.0.1'
27(10374) DEBUG: init_mod_child (-4): usrloc
27(10374) get_connection(): Connection not found in the pool
15(10348) DEBUG: init_mod_child (6): auth_db
15(10348) get_connection(): Connection not found in the pool
13(10346)  0(10319) 24(10371) 25(10372) 26(10373) 27(10374) 16(10361)
DEBUG: init_mod_child (4): auth_db
13(10346) get_connection(): Connection not found in the pool
DEBUG: init_mod_child (0): auth_db
 0(10319) get_connection(): Connection not found in the pool
DEBUG: init_mod_child (14): auth_db
24(10371) get_connection(): Connection not found in the pool
DEBUG: init_mod_child (15): auth_db
25(10372) get_connection(): Connection not found in the pool
DEBUG: init_mod_child (16): auth_db
26(10373) get_connection(): Connection not found in the pool
DEBUG: init_mod_child (-4): auth_db
27(10374) get_connection(): Connection not found in the pool
DEBUG: init_mod_child (7): auth_db
16(10361) get_connection(): Connection not found in the pool
14(10347) DEBUG: init_mod_child (5): auth_db
14(10347) get_connection(): Connection not found in the pool
18(10363) 19(10364) DEBUG: init_mod_child (-1): auth_db
18(10363) get_connection(): Connection not found in the pool
20(10365) DEBUG: init_mod_child (9): auth_db
19(10364) get_connection(): Connection not found in the pool
21(10366) DEBUG: init_mod_child (10): auth_db
20(10365) get_connection(): Connection not found in the pool
DEBUG: init_mod_child (11): auth_db
21(10366) get_connection(): Connection not found in the pool
23(10368) DEBUG: init_mod_child (13): auth_db
23(10368) get_connection(): Connection not found in the pool
17(10362) DEBUG: init_mod_child (8): auth_db
17(10362) get_connection(): Connection not found in the pool
22(10367) DEBUG: init_mod_child (12): auth_db
22(10367) get_connection(): Connection not found in the pool


--
Hemant Patel
ipwise Ltd
http://www.ipwise.com

hpatel@ipwise.com
(+44) 0208 2409433