[Freeswitch-users] Nibblebill database question

Wed Feb 13 20:51:17 MSK 2013

And i can connect from the cli:

root at lamp ~# isql viking
+---------------------------------------+
| Connected!                            |
|                                       |
| sql-statement                         |
| help [tablename]                      |
| quit                                  |
|                                       |
+---------------------------------------+
SQL>

strange...

On Wed, Feb 13, 2013 at 6:46 PM, Steven Ayre <steveayre at gmail.com> wrote:

> http://jira.freeswitch.org/browse/FS-5100
>
>
> On 13 February 2013 17:40, Steven Ayre <steveayre at gmail.com> wrote:
>
>> Specifically it's introduced by commit 5c176e8 which was resolving
>> FS-4810, which is indeed adding support for the the generalised DSN
>> interface.
>>
>>
>> http://fisheye.freeswitch.org/changelog/freeswitch.git?showid=5c176e889d8cc2da7efb18a89782407ee5524a74
>> http://jira.freeswitch.org/browse/FS-4810
>>
>> -Steve
>>
>>
>>
>> On 13 February 2013 17:37, Steven Ayre <steveayre at gmail.com> wrote:
>>
>>> Looks like this difference is brought in by the modifications to support
>>> the generalised DSN interface. odbc-dsn would be consistent with all other
>>> modules, so I guess that's why it's happened.
>>>
>>> But...
>>> The HEAD of v1.2.stable understands db_dsn but not odbc-dsn.
>>> The HEAD of master understands odbc-dsn but not db_dsn.
>>>
>>> This is a configuration breaking behaviour, which doesn't seem to have
>>> been documented!
>>>
>>> At the very least it'd make sense for the master branch to understand
>>> both odbc-dsn and db_dsn for backwards compatibility. I'll file a Jira with
>>> a patch (it's a trivial fix) in a moment.
>>>
>>> -Steve
>>>
>>>
>>>
>>>
>>>
>>>
>>> On 13 February 2013 17:33, Steven Ayre <steveayre at gmail.com> wrote:
>>>
>>>> How are you setting the DSN?
>>>>
>>>> The param name mentioned earlier is wrong. Reading the source the
>>>> correct parameter is "odbc-dsn". Looks like the wiki documentation is
>>>> incorrect.
>>>>
>>>> -Steve
>>>>
>>>>
>>>>
>>>>
>>>> On 13 February 2013 15:33, David Villasmil <
>>>> david.villasmil.work at gmail.com> wrote:
>>>>
>>>>> hello Avi,
>>>>>
>>>>> that's right, but nevermind that, that's the output when I was trying
>>>>> something else:
>>>>>
>>>>> 2013-02-12 19:32:07.784156 [INFO] mod_nibblebill.c:498 Beginning new
>>>>> billing on 58e6762b-c049-470e-84f7-519a815ab6f0
>>>>> 2013-02-12 19:32:07.784156 [CRIT] mod_nibblebill.c:535 Failed to log
>>>>> to database!
>>>>> 2013-02-12 19:32:07.784156 [ERR] mod_nibblebill.c:380 Error running
>>>>> this query: [SELECT balance AS nibble_balance FROM sip_users WHERE id='1']
>>>>>
>>>>>
>>>>> On Wed, Feb 13, 2013 at 12:58 PM, Avi Marcus <avi at avimarcus.net>wrote:
>>>>>
>>>>>> Your logs showed the queries run were:
>>>>>>
>>>>>> UPDATE sip_users SET balance=balance-0.018983 WHERE ='1'
>>>>>> SELECT balance AS nibble_balance FROM sip_users WHERE ='1'
>>>>>>
>>>>>>  You just tried now.. "WHERE *id*='1' " -- they are not the same
>>>>>> query...
>>>>>>
>>>>>> -Avi
>>>>>>
>>>>>>
>>>>>>
>>>>>> On Wed, Feb 13, 2013 at 12:48 PM, David Villasmil <
>>>>>> david.villasmil.work at gmail.com> wrote:
>>>>>>
>>>>>>> Hello Rupa,
>>>>>>>
>>>>>>> the query if ok, the user is there:
>>>>>>>
>>>>>>> mysql> select * from sip_users;
>>>>>>>
>>>>>>> +----+----------+----------+----------------+------------+--------------+--------------+
>>>>>>> | id | username | password | rateplan       | balance    | domain
>>>>>>>     | max_channels |
>>>>>>>
>>>>>>> +----+----------+----------+----------------+------------+--------------+--------------+
>>>>>>> |  1 | 1002     | 1234     | retail_default | 100.000000 |
>>>>>>> 192.168.1.44 |            1 |
>>>>>>>
>>>>>>> +----+----------+----------+----------------+------------+--------------+--------------+
>>>>>>> 1 row in set (0.00 sec)
>>>>>>>
>>>>>>>
>>>>>>> and the actual sql executed by nibblebill:
>>>>>>>
>>>>>>> mysql> SELECT balance AS nibble_balance FROM sip_users WHERE id='1';
>>>>>>> +----------------+
>>>>>>> | nibble_balance |
>>>>>>> +----------------+
>>>>>>> |     100.000000 |
>>>>>>> +----------------+
>>>>>>> 1 row in set (0.00 sec)
>>>>>>>
>>>>>>>
>>>>>>> so that's ok..
>>>>>>>
>>>>>>>
>>>>>>> any othe ideas?
>>>>>>>
>>>>>>> Thanks a lot for your help!
>>>>>>>
>>>>>>>
>>>>>>> David
>>>>>>>
>>>>>>>
>>>>>>>
>>>>>>> On Wed, Feb 13, 2013 at 3:35 AM, Rupa Schomaker <rupa at rupa.com>wrote:
>>>>>>>
>>>>>>>>
>>>>>>>> On Tue, Feb 12, 2013 at 5:26 PM, David Villasmil <
>>>>>>>> david.villasmil.work at gmail.com> wrote:
>>>>>>>>
>>>>>>>>> call goes out fine... no billing though:
>>>>>>>>>
>>>>>>>>>
>>>>>>>>> 2013-02-12 19:21:49.844277 [DEBUG] mod_nibblebill.c:504 22 seconds
>>>>>>>>> passed since last bill time of 2013-02-12 19:21:27
>>>>>>>>> 2013-02-12 19:21:49.844277 [DEBUG] mod_nibblebill.c:521 Billing
>>>>>>>>> $0.018983 to 1 (Call: d442dc6b-a3a7-423a-8450-598d17ca43b3 / 0.000000 so
>>>>>>>>> far)
>>>>>>>>> 2013-02-12 19:21:49.844277 [DEBUG] mod_nibblebill.c:351 Doing
>>>>>>>>> update query
>>>>>>>>> [UPDATE sip_users SET balance=balance-0.018983 WHERE ='1']
>>>>>>>>> 2013-02-12 19:21:49.844277 [CRIT] mod_nibblebill.c:535 Failed to
>>>>>>>>> log to database!
>>>>>>>>> 2013-02-12 19:21:49.844277 [DEBUG] mod_nibblebill.c:378 Doing
>>>>>>>>> lookup query
>>>>>>>>> [SELECT balance AS nibble_balance FROM sip_users WHERE ='1']
>>>>>>>>> 2013-02-12 19:21:49.844277 [ERR] mod_nibblebill.c:380 Error
>>>>>>>>> running this query: [SELECT balance AS nibble_balance FROM sip_users WHERE
>>>>>>>>> ='1']
>>>>>>>>>
>>>>>>>>>
>>>>>>>>> the select go fine if executed "by hand"
>>>>>>>>>
>>>>>>>>
>>>>>>>> None of those SQL statements are valid.  (hint: WHERE = '1' is no
>>>>>>>> good).    Been a while since I hacked/worked with nibblebill, but I'm
>>>>>>>> pretty sure the 'id' field isn't not being filled in the sql for some
>>>>>>>> reason.
>>>>>>>>
>>>>>>>>
>>>>>>>> --
>>>>>>>> -Rupa
>>>>>>>>
>>>>>>>>
>>>>>>>> _________________________________________________________________________
>>>>>>>> Professional FreeSWITCH Consulting Services:
>>>>>>>> consulting at freeswitch.org
>>>>>>>> http://www.freeswitchsolutions.com
>>>>>>>>
>>>>>>>> 
>>>>>>>> 
>>>>>>>>
>>>>>>>> Official FreeSWITCH Sites
>>>>>>>> http://www.freeswitch.org
>>>>>>>> http://wiki.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://wiki.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://wiki.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://wiki.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://wiki.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/20130213/686be59e/attachment-0001.html 