[Freeswitch-users] Freeswitch HA feature

[shuchi]

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.



--
View this message in context: http://freeswitch-users.2379917.n2.nabble.com/Freeswitch-HA-feature-tp7595209.html
Sent from the freeswitch-users mailing list archive at Nabble.com.