[Freeswitch-users] Nibblebill issues on centos 6?

Mon Feb 23 20:26:33 MSK 2015

As far as I remember do next

1. Same odbc.ini on both servers
2. Be sure mysql user has permitions

LD
On Feb 23, 2015 11:55 AM, "Chris Martineau" <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 <
> freeswitch-users-bounces at lists.freeswitch.org> on behalf of Sergey
> Safarov <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>
> 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
>> 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
>> 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
> 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
> http://lists.freeswitch.org/mailman/listinfo/freeswitch-users
> UNSUBSCRIBE:http://lists.freeswitch.org/mailman/options/freeswitch-users
> http://www.freeswitch.org
>
-------------- next part --------------
An HTML attachment was scrubbed...
URL: http://lists.freeswitch.org/pipermail/freeswitch-users/attachments/20150223/ae84db70/attachment-0001.html 