Re: [sr-dev] different mysql errors

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(a)test.fi and jh(a)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@test.fi> by &lt;test(a)test.fi&gt; 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@192.98.101.10:5074;transport=tcp','2009-06-04 19:22:05',0.50 ,&#39;rhmhnveyfyqyaue(a)localhost&#39;,950,0,0,&#39;Twinkle/1.4.2&#39;,NULL,NULL,&#39;&#39;,6111,&#39;2009-06-04 18:22:05','test.fi')