[Freeswitch-users] Nibblebill issues on centos 6?

Tue Feb 24 11:55:06 MSK 2015

Hi

As I understand it you install the relevant drivers and then install freeswitch which detects the presence of the drivers and compiles appropriately?

I have compiled a number of times as I have changed versions to test.

Is there some way I can tell if it has compiled with odbc?

Is there a way to force it?

Regards

Chris

________________________________
From: freeswitch-users-bounces at lists.freeswitch.org <freeswitch-users-bounces at lists.freeswitch.org> on behalf of Brian West <brian at freeswitch.org>
Sent: 23 February 2015 18:45
To: FreeSWITCH Users Help
Subject: Re: [Freeswitch-users] Nibblebill issues on centos 6?

Probably helpful if you compile FreeSWITCH with ODBC support! :)

On Mon, Feb 23, 2015 at 10:54 AM, Chris Martineau <chris at ghosttelecom.com<mailto:chris at ghosttelecom.com>> wrote:

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...

Loading...

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...
Loading...
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 at GC007MS ~]# isql freeswitch
+---------------------------------------+
| Connected!                            |
|                                       |
| sql-statement                         |
| help [tablename]                      |
| quit                                  |
|                                       |
+---------------------------------------+
SQL> ^C

Regards

Chris

________________________________
From: freeswitch-users-bounces at lists.freeswitch.org<mailto:freeswitch-users-bounces at lists.freeswitch.org> <freeswitch-users-bounces at lists.freeswitch.org<mailto:freeswitch-users-bounces at lists.freeswitch.org>> on behalf of Sergey Safarov <s.safarov at gmail.com<mailto:s.safarov at 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 at ghosttelecom.com<mailto:chris at 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 at freeswitch.org<mailto:consulting at 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 at lists.freeswitch.org<mailto:FreeSWITCH-users at lists.freeswitch.org>
http://lists.freeswitch.org/mailman/listinfo/freeswitch-users
UNSUBSCRIBE:http://lists.freeswitch.org/mailman/options/freeswitch-users
http://www.freeswitch.org

_________________________________________________________________________
Professional FreeSWITCH Consulting Services:
consulting at freeswitch.org<mailto:consulting at 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 at lists.freeswitch.org<mailto:FreeSWITCH-users at lists.freeswitch.org>
http://lists.freeswitch.org/mailman/listinfo/freeswitch-users
UNSUBSCRIBE:http://lists.freeswitch.org/mailman/options/freeswitch-users
http://www.freeswitch.org

--

Brian West
brian at freeswitch.org<mailto:brian at freeswitch.org>

[http://billing.freeswitch.org/templates/default/img/whmcslogo.png]

Twitter: @FreeSWITCH , @briankwest
http://www.freeswitchbook.com
http://www.freeswitchcookbook.com

T:+19184209001 | F:+19184209002 | M:+1918424WEST (9378)
iNUM:+883 5100 1420 9001 | ISN:410*543 | Skype:briankwest
-------------- next part --------------
An HTML attachment was scrubbed...
URL: http://lists.freeswitch.org/pipermail/freeswitch-users/attachments/20150224/5d40f13e/attachment-0001.html 