[Freeswitch-users] Freeswitch HA feature

[Michael Jerris]

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 at 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 at 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 at 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.
>