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. -- View this message in context: http://freeswitch-users.2379917.n2.nabble.com/Freeswitch-HA-feature-tp759520... Sent from the freeswitch-users mailing list archive at Nabble.com.