Hi,

Thanks for responding.

Tried that. I assume you are looking for traffic arriving at the db server?

Either way, this filter shows nothing at the source end and and nothing at the destination either when completing a call.

I have added some log entries to track what was happening.

Here are the errors with the dsn set up as normal...

2015-02-23 16:32:21.693244 [CONSOLE] switch_loadable_module.c:1935 Stopping: mod_nibblebill

2015-02-23 16:32:21.693244 [CONSOLE] switch_loadable_module.c:1955 mod_nibblebill unloaded.

2015-02-23 16:32:21.693244 [ERR] mod_nibblebill.c:147 Handle using: [freeswitch:opensips:opensipsrw] Global: [freeswitch:opensips:opensipsrw]

2015-02-23 16:32:21.693244 [CRIT] switch_core_sqldb.c:482 Failure! ODBC NOT AVAILABLE! Can't connect to DSN freeswitch

2015-02-23 16:32:21.693244 [CRIT] mod_nibblebill.c:294 Cannot Open ODBC Database!

2015-02-23 16:32:21.693244 [CONSOLE] switch_loadable_module.c:1465 Successfully Loaded [mod_nibblebill]

Call end...

2015-02-23 16:45:38.933258 [ERR] mod_nibblebill.c:147 Handle using: [freeswitch:opensips:opensipsrw] Global: [freeswitch:opensips:opensipsrw]

2015-02-23 16:45:38.933258 [CRIT] switch_core_sqldb.c:482 Failure! ODBC NOT AVAILABLE! Can't connect to DSN freeswitch

2015-02-23 16:45:38.933258 [ERR] mod_nibblebill.c:202 Unable to retrieve handle2: [freeswitch:opensips:opensipsrw]

2015-02-23 16:45:38.933258 [CRIT] mod_nibblebill.c:584 Failed to log to database!

2015-02-23 16:45:38.933258 [ERR] mod_nibblebill.c:147 Handle using: [freeswitch:opensips:opensipsrw] Global: [freeswitch:opensips:opensipsrw]

2015-02-23 16:45:38.933258 [CRIT] switch_core_sqldb.c:482 Failure! ODBC NOT AVAILABLE! Can't connect to DSN freeswitch

2015-02-23 16:45:38.933258 [ERR] mod_nibblebill.c:183 Unable to retrieve handle1: [freeswitch:opensips:opensipsrw]

2015-02-23 16:45:38.933258 [ERR] mod_nibblebill.c:429 Error running this query: [SELECT balance AS nibble_balance FROM accounts WHERE billingid='1204' and plan='0']

And just with the dsn name...

2015-02-23 16:33:37.473239 [CONSOLE] switch_loadable_module.c:1935 Stopping: mod_nibblebill

2015-02-23 16:33:37.473239 [CONSOLE] switch_loadable_module.c:1955 mod_nibblebill unloaded.

2015-02-23 16:33:37.473239 [ERR] mod_nibblebill.c:147 Handle using: [freeswitch] Global: [freeswitch]

2015-02-23 16:33:37.473239 [CONSOLE] switch_loadable_module.c:1465 Successfully Loaded [mod_nibblebill]

Call end...

2015-02-23 16:34:10.793251 [ERR] mod_nibblebill.c:147 Handle using: [freeswitch] Global: [freeswitch]

2015-02-23 16:34:10.793251 [ERR] mod_nibblebill.c:195 Reached here okay2: [freeswitch]

2015-02-23 16:34:10.793251 [ERR] switch_core_sqldb.c:586 NATIVE SQL ERR [no such table: accounts]

UPDATE accounts SET balance=balance-round(0.030000+0.0004,3) WHERE billingid='1204' and plan='0'

2015-02-23 16:34:10.793251 [CRIT] mod_nibblebill.c:584 Failed to log to database!

2015-02-23 16:34:10.793251 [ERR] mod_nibblebill.c:147 Handle using: [freeswitch] Global: [freeswitch]

2015-02-23 16:34:10.793251 [ERR] mod_nibblebill.c:176 Reached here okay1: [freeswitch]

2015-02-23 16:34:10.793251 [ERR] switch_core_sqldb.c:1196 SQL ERR: [SELECT balance AS nibble_balance FROM accounts WHERE billingid='1204' and plan='0'] no such table: accounts

2015-02-23 16:34:10.793251 [ERR] mod_nibblebill.c:429 Error running this query: [SELECT balance AS nibble_balance FROM accounts WHERE billingid='1204' and plan='0']

Here is the isql output.

This is with USER and PASSWORD set in odbc.ini but the above errors are the same whether they are set or not in the ini file.

[root@GC007MS ~]# isql freeswitch

+---------------------------------------+

| Connected! |

| |

| sql-statement |

| help [tablename] |

| quit |

| |

+---------------------------------------+

SQL> ^C

Regards

Chris

From: freeswitch-users-bounces@lists.freeswitch.org <freeswitch-users-bounces@lists.freeswitch.org> on behalf of Sergey Safarov <s.safarov@gmail.com>
Sent: 23 February 2015 16:00
To: FreeSWITCH Users Help
Subject: Re: [Freeswitch-users] Nibblebill issues on centos 6?

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