<div dir="ltr">Can you save tcpdump of mysql connection and parce it in wireshark?<div>tcpdump -ni eth0 port 3306 -s 65535 -w /tmp/mysql.pcap</div><div><br></div><div>I think FS has compiled with version of mysql lib is different then used server on CentOS 5</div></div><div class="gmail_extra"><br><div class="gmail_quote">On Mon, Feb 23, 2015 at 1:48 PM, Chris Martineau <span dir="ltr"><<a href="mailto:chris@ghosttelecom.com" target="_blank">chris@ghosttelecom.com</a>></span> wrote:<br><blockquote class="gmail_quote" style="margin:0 0 0 .8ex;border-left:1px #ccc solid;padding-left:1ex">
<div dir="ltr">
<div style="font-size:12pt;color:#000000;background-color:#ffffff;font-family:Calibri,Arial,Helvetica,sans-serif">
<p>Hi,<br>
</p>
<p><br>
</p>
<p>Anyone come across any issues using nibblebill on centos 6 to a remote Mysql DB on Centos 5?<br>
</p>
<p><br>
</p>
<p>Doesn't matter what version of Freeswitch I am using, if I deploy it on our existing centos 5 servers to a mysql db deployed also on a centos 5 server it works fine.<br>
</p>
<p>If I deploy on a centos 6 platform I get strange issues with the odbc interface.<br>
</p>
<p>ISQL connection works fine but when I plug the details into the dsn in the nibblebill configuration it doesn't work?<br>
</p>
<p>If I try dsn freeswitch:user:passwd then the module fails to initialise the database and complains that it cannot connect to odbc.<br>
</p>
<p>The only combination that works is just setting dsn to freeswitch which seems to get by the db handle code but then fails with a 'cannot find table' error.<br>
</p>
<p><br>
</p>
<p>The first configuration works fine on centos 5 with the same software and config and to the same remote db.<br>
</p>
<p><br>
</p>
<p>The only difference I can see is the odbc drivers which are later versions on centos6. </p>
<p><br>
</p>
<p>Could this be something to do with new passwords formats on mysql? The versions of mysql being used are using the old format but setting the old_passwords entry in my.cnf makes no difference, set or unset.<br>
</p>
<p><br>
</p>
<p>Any ideas?<br>
</p>
<p><br>
</p>
<p>Regards<span class="HOEnZb"><font color="#888888"><br>
</font></span></p><span class="HOEnZb"><font color="#888888">
<p><br>
</p>
<p>Chris<br>
</p>
</font></span></div>
</div>
<br>_________________________________________________________________________<br>
Professional FreeSWITCH Consulting Services:<br>
<a href="mailto:consulting@freeswitch.org">consulting@freeswitch.org</a><br>
<a href="http://www.freeswitchsolutions.com" target="_blank">http://www.freeswitchsolutions.com</a><br>
<br>
Official FreeSWITCH Sites<br>
<a href="http://www.freeswitch.org" target="_blank">http://www.freeswitch.org</a><br>
<a href="http://confluence.freeswitch.org" target="_blank">http://confluence.freeswitch.org</a><br>
<a href="http://www.cluecon.com" target="_blank">http://www.cluecon.com</a><br>
<br>
FreeSWITCH-users mailing list<br>
<a href="mailto:FreeSWITCH-users@lists.freeswitch.org">FreeSWITCH-users@lists.freeswitch.org</a><br>
<a href="http://lists.freeswitch.org/mailman/listinfo/freeswitch-users" target="_blank">http://lists.freeswitch.org/mailman/listinfo/freeswitch-users</a><br>
UNSUBSCRIBE:<a href="http://lists.freeswitch.org/mailman/options/freeswitch-users" target="_blank">http://lists.freeswitch.org/mailman/options/freeswitch-users</a><br>
<a href="http://www.freeswitch.org" target="_blank">http://www.freeswitch.org</a><br></blockquote></div><br></div>