[Freeswitch-users] Nibblebill database question
David Villasmil
david.villasmil.work at gmail.com
Wed Feb 13 22:07:35 MSK 2013
Yeah, everything works within isql:
root at lamp ~# isql viking
+---------------------------------------+
| Connected! |
| |
| sql-statement |
| help [tablename] |
| quit |
| |
+---------------------------------------+
SQL> SELECT balance AS nibble_balance FROM sip_users WHERE id='1'
+---------------+
| nibble_balance|
+---------------+
| 100.000000 |
+---------------+
SQLRowCount returns 1
1 rows fetched
SQL> UPDATE sip_users SET balance=balance-0.044817 WHERE id='1'
SQLRowCount returns 1
SQL> SELECT balance AS nibble_balance FROM sip_users WHERE id='1'
+---------------+
| nibble_balance|
+---------------+
| 99.955183 |
+---------------+
SQLRowCount returns 1
1 rows fetched
SQL>
and freeswitch core is also using odbc (although a differen dsn)
David
On Wed, Feb 13, 2013 at 7:07 PM, Steven Ayre <steveayre at gmail.com> wrote:
> 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
>>
>>
>
> _________________________________________________________________________
> 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/e4568e19/attachment-0001.html
Join us at ClueCon 2011 Aug 9-11, 2011
More information about the FreeSWITCH-users
mailing list