<html>
<head>
<meta http-equiv="Content-Type" content="text/html; charset=iso-8859-1">
<style type="text/css" style="display:none;"><!-- P {margin-top:0;margin-bottom:0;} --></style>
</head>
<body dir="ltr">
<div id="divtagdefaultwrapper" 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<br>
</p>
<p><br>
</p>
<p>Chris<br>
</p>
</div>
</body>
</html>