[Freeswitch-users] Nibblebill database question

Wed Feb 13 21:07:10 MSK 2013

Do the SQL queries work ok within isql?

On 13 February 2013 17:51, David Villasmil
<david.villasmil.work at gmail.com>wrote:

> 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
>>
>>
>
> _________________________________________________________________________
> 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/6a225da2/attachment-0001.html 