<div dir="ltr"><div><div><div><div><div><div><div><div><div>Hi list,<br></div>I have an issue with HA configuration (Mysql Backend).<br><br></div>When I crash master Freeswitch, I try to recover my call (2 legs) in the slave server (same behavior if I recover in the same server "master to master").<br>
<br></div><u>TEST 1:</u><br></div>Master (crash) --> Slave (recovery)<br><br></div><u>TEST 2:</u><br></div>Master (crash) --> restart freeswitch in master --> Master (recovery)<br><br></div>I can recover only one leg, but I can see two legs in recovery table's Mysql.<br>
</div></div><div><br></div><div><b>Before crash:</b><br></div><div><br></div><u>Recovery table with one call:</u><br><div><div><div><div><div><div><div><div><div><div><div><div><br>mysql> select runtime_uuid, technology, profile_name, hostname, uuid from recovery;<br>
+--------------------------------------+------------+--------------+----------+--------------------------------------+<br>| runtime_uuid | technology | profile_name | hostname | uuid |<br>
+--------------------------------------+------------+--------------+----------+--------------------------------------+<br>| 8b5a6b6c-adbe-11e3-b273-e98376048298 | sofia | internal | asbc2 | 952054fe-adbe-11e3-b291-e98376048298 |<br>
| 8b5a6b6c-adbe-11e3-b273-e98376048298 | sofia | external | asbc2 | 951e4b64-adbe-11e3-b276-e98376048298 |<br>+--------------------------------------+------------+--------------+----------+--------------------------------------+<br>
<b>2 rows</b> in set (0.00 sec)<br><br><br></div><div><b>After crash:</b><br><br><i>Linux screen:</i><br>[root@asbc2 conf]# /usr/local/freeswitch/bin/fs_cli -x 'sofia recover'<br>Recovered 1 call(s)<br><br><i>fs_cli screen:</i><br>
2014-03-17 11:23:56.492759 [WARNING] switch_core_sqldb.c:2715 Invalid cdr data, call not recovered<br><br><br>mysql> select runtime_uuid, technology, profile_name, hostname, uuid from recovery;<br>+--------------------------------------+------------+--------------+----------+--------------------------------------+<br>
| runtime_uuid | technology | profile_name | hostname | uuid |<br>+--------------------------------------+------------+--------------+----------+--------------------------------------+<br>
| acba00a6-adbe-11e3-8380-19442cf25656 | sofia | internal | asbc2 | 952054fe-adbe-11e3-b291-e98376048298 |<br>+--------------------------------------+------------+--------------+----------+--------------------------------------+<br>
<b>1 row</b> in set (0.00 sec)<br><br><br><br><u>Freeswitch's configuration:</u><br><br><div><u>Version:</u><br>FreeSWITCH Version 1.5.8b+git~20140214T000311Z~fe2a4d6d47~64bit (git fe2a4d6 2014-02-14 00:03:11Z 64bit)<br>
</div><div><br></div><u>Both Profiles:</u><br><param name="track-calls" value="true"/><br><param name="odbc-dsn" value="freeswitch:u_freeswitch:XXXXXXXX"/><br><br><u>Switch.conf.xml:</u><br>
<param name="core-db-dsn" value="freeswitch:u_freeswitch:XXXXXXXXXXXX" /><br><param name="core-recovery-db-dsn" value="odbc://freeswitch:u_freeswitch:XXXXXXXXXXXXX"/><br>
<br><br></div><div><u>odbc.ini:</u><br>[freeswitch]<br>Driver = /usr/lib64/<a href="http://libmyodbc5-5.1.5.so">libmyodbc5-5.1.5.so</a><br>SERVER = localhost<br>PORT = 3306<br>DATABASE = freeswitch<br>
OPTION = 67108864<br>USER = u_freeswitch<br>PASSWORD = XXXXXXXXXX<br><br><br><u>odbcinst.ini:</u><br># Driver from the mysql-connector-odbc package<br># Setup from the unixODBC package<br>[MySQL]<br>
Description = ODBC for MySQL<br>Driver = /usr/lib/libmyodbc5.so<br>Setup = /usr/lib/libodbcmyS.so<br>Driver64 = /usr/lib64/libmyodbc5.so<br>Setup64 = /usr/lib64/libodbcmyS.so<br>FileUsage = 1<br>UsageCount = 1<br>
Threading = 0<br>Debug = 1<br>MaxLongVarcharSize = 65536<br><br></div><div><br><br></div><div>Have you an idea with this issue ? Issue is due to beta version ?<br><br></div><div>Thanks in advance.<br><br><br></div><div>
-- <br><div dir="ltr">Cordialement<br><br>HUBERT Mickaël<br>Ingénieur VOIP - Hexanet<br></div>
</div></div></div></div></div></div></div></div></div></div></div></div></div>
<br>
<img src="http://www.hexanet.fr/sites/files/hexanet/files/20130205_signature_hexanet.gif">