The syntax of those queries look right… did you see: If you are using mysql, make sure you are using MYODBC 3.51.18 or higher and enable FLAG_MULTI_STATEMENTS Mike On Sep 26, 2013, at 6:35 AM, shuchi <pragya@tatapowersed.com> wrote:
I am trying to implement freeswitch HA feature. But when I try to run sofia internal profile it gives following error
freeswitch@freeswitch01> sofia profile internal start 2013-09-26 15:44:35.623878 [ERR] sofia.c:4485 Not adding acl nat.auto because it's the local network 2013-09-26 15:44:35.623878 [INFO] mod_enum.c:876 ENUM Reloaded 2013-09-26 15:44:35.623878 [NOTICE] sofia.c:4919 Connecting ODBC Profile internal [sofia_reg_internal] 2013-09-26 15:44:35.623878 [INFO] switch_time.c:1191 Timezone reloaded 530 definitions 2013-09-26 15:44:35.623878 [ERR] switch_odbc.c:514 ERR: [delete from sip_registrations where (sub_host is null or contact like '%TCP%' or status like '%TCP%' or status like '%TLS%') and hostname='freeswitch01' and network_ip like '%' and network_port like '%' and sip_username like '%' and mwi_user like '%' and mwi_host like '%' and orig_server_host like '%' and orig_hostname like '%';delete from sip_registrations where (sub_host is null or contact like '%TCP%' or status like '%TCP%' or status like '%TLS%') and hostname='freeswitch01' and network_ip like '%' and network_port like '%' and sip_username like '%' and mwi_user like '%' and mwi_host like '%' and orig_server_host like '%' and orig_hostname like '%'] [STATE: 42000 CODE 1064 ERROR: [MySQL][ODBC 3.51 Driver][mysqld-5.1.66-0ubuntu0.10.04.3]You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'delete from sip_registrations where (sub_host is null or contact like '%TCP%' or' at line 1 ] 2013-09-26 15:44:35.623878 [ERR] switch_core_sqldb.c:585 ODBC SQL ERR [STATE: 42000 CODE 1064 ERROR: [MySQL][ODBC 3.51 Driver][mysqld-5.1.66-0ubuntu0.10.04.3]You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'delete from sip_registrations where (sub_host is null or contact like '%TCP%' or' at line 1 ] delete from sip_registrations where (sub_host is null or contact like '%TCP%' or status like '%TCP%' or status like '%TLS%') and hostname='freeswitch01' and network_ip like '%' and network_port like '%' and sip_username like '%' and mwi_user like '%' and mwi_host like '%' and orig_server_host like '%' and orig_hostname like '%';delete from sip_registrations where (sub_host is null or contact like '%TCP%' or status like '%TCP%' or status like '%TLS%') and hostname='freeswitch01' and network_ip like '%' and network_port like '%' and sip_username like '%' and mwi_user like '%' and mwi_host like '%' and orig_server_host like '%' and orig_hostname like '%' 2013-09-26 15:44:35.623878 [CRIT] sofia_glue.c:2190 GREAT SCOTT!!! Cannot execute batched statements! [STATE: 42000 CODE 1064 ERROR: [MySQL][ODBC 3.51 Driver][mysqld-5.1.66-0ubuntu0.10.04.3]You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'delete from sip_registrations where (sub_host is null or contact like '%TCP%' or' at line 1 ] If you are using mysql, make sure you are using MYODBC 3.51.18 or higher and enable FLAG_MULTI_STATEMENTS 2013-09-26 15:44:35.623878 [CRIT] sofia.c:2426 Cannot Open SQL Database [internal]!
Reload XML [Success] internal started successfully
freeswitch@freeswitch01> Error in my_thread_global_end(): 2 threads didn't exit
I have updated the dsn at every place under /freeswitch/conf/ directory. Can anyone please update me about the solution?
Thank you.