Can you save tcpdump of mysql connection and parce it in wireshark?
tcpdump -ni eth0 port 3306 -s 65535 -w /tmp/mysql.pcap

I think FS has compiled with version of mysql lib is different then used server on CentOS 5

On Mon, Feb 23, 2015 at 1:48 PM, Chris Martineau <chris@ghosttelecom.com> wrote:

Hi,


Anyone come across any issues using nibblebill on centos 6 to a remote Mysql DB on Centos 5?


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.

If I deploy on a centos 6 platform I get strange issues with the odbc interface.

ISQL connection works fine but when I plug the details into the dsn in the nibblebill configuration it doesn't work?

If I try dsn freeswitch:user:passwd then the module fails to initialise the database and complains that it cannot connect to odbc.

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.


The first configuration works fine on centos 5 with the same software and config and to the same remote db.


The only difference I can see is the odbc drivers which are later versions on centos6. 


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.


Any ideas?


Regards


Chris


_________________________________________________________________________
Professional FreeSWITCH Consulting Services:
consulting@freeswitch.org
http://www.freeswitchsolutions.com

Official FreeSWITCH Sites
http://www.freeswitch.org
http://confluence.freeswitch.org
http://www.cluecon.com

FreeSWITCH-users mailing list
FreeSWITCH-users@lists.freeswitch.org
http://lists.freeswitch.org/mailman/listinfo/freeswitch-users
UNSUBSCRIBE:http://lists.freeswitch.org/mailman/options/freeswitch-users
http://www.freeswitch.org