[sr-dev] different mysql errors

[Juha Heinanen]

jan,

i'm starting to get desperate.  i removed most of functionality from my
config.  i start proxy and then twinkle that has two accounts:
test at test.fi and jh at test.fi.  twinkle manages to register test, but does
not anymore get any response when it tries to register jh.

with this test, no error messages comes to syslog, but proxy becomes totally
unresponsive after handling the first register.  proxy processes seem to
be alive.

below is all that sip proxy prints to syslog.

- juha

Jun  4 18:21:49 localhost sip-router: WARNING: <core> [cfg.y:2898]: warning in config file, line 1834, column 12: constant value in while(...)
Jun  4 18:21:49 localhost sip-router: INFO: <core> [tcp_main.c:4088]: init_tcp: using epoll_lt as the io watch method (auto detected)
Jun  4 18:21:49 localhost /usr/sbin/sip-router[6360]: INFO: db_mysql [km_dbase.c:98]: submit_query(): select table_version from version where table_name='gw'
Jun  4 18:21:49 localhost /usr/sbin/sip-router[6360]: INFO: db_mysql [km_dbase.c:98]: submit_query(): select table_version from version where table_name='lcr'
Jun  4 18:21:49 localhost /usr/sbin/sip-router[6360]: INFO: db_mysql [km_dbase.c:98]: submit_query(): select ip_addr,port,uri_scheme,transport,strip,tag,grp_id,flags,weight,hostname,ping from gw 
Jun  4 18:21:49 localhost /usr/sbin/sip-router[6360]: INFO: db_mysql [km_dbase.c:98]: submit_query(): select prefix,from_uri,grp_id,priority from lcr 
Jun  4 18:21:49 localhost /usr/sbin/sip-router[6360]: INFO: db_mysql [km_dbase.c:98]: submit_query(): select table_version from version where table_name='dialplan'
Jun  4 18:21:49 localhost /usr/sbin/sip-router[6360]: INFO: db_mysql [km_dbase.c:98]: submit_query(): select dpid,pr,match_op,match_exp,match_len,subst_exp,repl_exp,attrs from dialplan  order by pr
Jun  4 18:21:49 localhost /usr/sbin/sip-router[6360]: NOTICE: mediaproxy [mediaproxy.c:1734]: engage_media_proxy() will not work because the dialog module is not loaded
Jun  4 18:21:49 localhost /usr/sbin/sip-router[6360]: INFO: misc_radius [misc_radius.c:162]: initializing...
Jun  4 18:21:49 localhost /usr/sbin/sip-router[6360]: WARNING: tls [tls_mod.c:308]: WARNING: tls: mod_init: tls support is disabled (set enable_tls=1 in the config to enable it)
Jun  4 18:21:49 localhost /usr/sbin/sip-router[6360]: INFO: utils [utils.c:263]: forward functionality disabled
Jun  4 18:21:49 localhost /usr/sbin/sip-router[6360]: INFO: utils [utils.c:176]: xcap_auth_status function is disabled
Jun  4 18:21:49 localhost /usr/sbin/sip-router[6360]: INFO: cfgutils [cfgutils.c:703]: no hash_file given, disable hash functionality
Jun  4 18:21:49 localhost /usr/sbin/sip-router[6360]: INFO: pv [pv_shv.c:57]: locks array size 16
Jun  4 18:21:49 localhost /usr/sbin/sip-router[6360]: INFO: usrloc [hslot.c:53]: locks array size 512
Jun  4 18:21:49 localhost /usr/sbin/sip-router[6360]: INFO: db_mysql [km_dbase.c:98]: submit_query(): select table_version from version where table_name='domain'
Jun  4 18:21:49 localhost /usr/sbin/sip-router[6360]: INFO: db_mysql [km_dbase.c:98]: submit_query(): select domain from domain 
Jun  4 18:21:49 localhost /usr/sbin/sip-router[6360]: WARNING: permissions [parse_config.c:251]: file not found: /etc/sip-router/permissions.allow
Jun  4 18:21:49 localhost /usr/sbin/sip-router[6360]: WARNING: permissions [permissions.c:604]: default allow file (/etc/sip-router/permissions.allow) not found => empty rule set
Jun  4 18:21:49 localhost /usr/sbin/sip-router[6360]: INFO: db_mysql [km_dbase.c:98]: submit_query(): select table_version from version where table_name='trusted'
Jun  4 18:21:49 localhost /usr/sbin/sip-router[6360]: INFO: db_mysql [km_dbase.c:98]: submit_query(): select src_ip,proto,from_pattern,tag from trusted 
Jun  4 18:21:49 localhost /usr/sbin/sip-router[6360]: INFO: db_mysql [km_dbase.c:98]: submit_query(): select table_version from version where table_name='address'
Jun  4 18:21:49 localhost /usr/sbin/sip-router[6360]: INFO: db_mysql [km_dbase.c:98]: submit_query(): select grp,ip_addr,mask,port from address 
Jun  4 18:21:49 localhost /usr/sbin/sip-router[6360]: INFO: pike [ip_tree.c:88]: probing 256 set size
Jun  4 18:21:49 localhost /usr/sbin/sip-router[6360]: INFO: local [local.c:290]: initializing
Jun  4 18:21:49 localhost /usr/sbin/sip-router[6360]: INFO: db_mysql [km_dbase.c:98]: submit_query(): select table_version from version where table_name='location'
Jun  4 18:21:49 localhost /usr/sbin/sip-router[6360]: INFO: db_mysql [km_dbase.c:98]: submit_query(): select username from location where username='dummy_user'
Jun  4 18:21:49 localhost /usr/sbin/sip-router[6360]: INFO: utils [utils.c:317]: leaving fixup_http_query
Jun  4 18:21:49 localhost /usr/sbin/sip-router[6360]: INFO: <core> [udp_server.c:166]: INFO: udp_init: SO_RCVBUF is initially 111616
Jun  4 18:21:49 localhost /usr/sbin/sip-router[6360]: INFO: <core> [udp_server.c:217]: INFO: udp_init: SO_RCVBUF is finally 262142
Jun  4 18:21:49 localhost /usr/sbin/sip-router[6360]: INFO: <core> [udp_server.c:166]: INFO: udp_init: SO_RCVBUF is initially 111616
Jun  4 18:21:49 localhost /usr/sbin/sip-router[6360]: INFO: <core> [udp_server.c:217]: INFO: udp_init: SO_RCVBUF is finally 262142
Jun  4 18:21:49 localhost /usr/sbin/sip-router[6360]: INFO: <core> [udp_server.c:166]: INFO: udp_init: SO_RCVBUF is initially 111616
Jun  4 18:21:49 localhost /usr/sbin/sip-router[6360]: INFO: <core> [udp_server.c:217]: INFO: udp_init: SO_RCVBUF is finally 262142
Jun  4 18:21:49 localhost /usr/sbin/sip-router[6360]: INFO: <core> [sctp_server.c:426]: sctp: socket 8 initialized (0x8226ff8)
Jun  4 18:21:49 localhost /usr/sbin/sip-router[6361]: INFO: db_mysql [km_dbase.c:98]: submit_query(): select username,contact,expires,q,callid,cseq,flags,cflags,user_agent,received,path,socket,methods,last_modified,domain from location 
Jun  4 18:21:49 localhost /usr/sbin/sip-router[6381]: INFO: mi_xmlrpc [mi_xmlrpc.c:252]: starting xmlrpc server
Jun  4 18:22:05 localhost /usr/sbin/sip-router[6382]: INFO: xlog [xlog.c:186]: INFO: REGISTER <sip:test at test.fi> by <test at test.fi> from <192.98.101.10> is authorized
Jun  4 18:22:05 localhost /usr/sbin/sip-router[6382]: INFO: db_mysql [km_dbase.c:98]: submit_query(): insert into location (username,contact,expires,q,callid,cseq,flags,cflags,user_agent,received,path,socket,methods,last_modified,domain ) values ('test','sip:test at 192.98.101.10:5074;transport=tcp','2009-06-04 19:22:05',0.50      ,'rhmhnveyfyqyaue at localhost',950,0,0,'Twinkle/1.4.2',NULL,NULL,'',6111,'2009-06-04 18:22:05','test.fi')