Yeah, everything works within isql: root@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@gmail.com> wrote:
Do the SQL queries work ok within isql?
On 13 February 2013 17:51, David Villasmil <david.villasmil.work@gmail.com
wrote:
And i can connect from the cli:
root@lamp ~# isql viking +---------------------------------------+ | Connected! | | | | sql-statement | | help [tablename] | | quit | | | +---------------------------------------+ SQL>
strange...
On Wed, Feb 13, 2013 at 6:46 PM, Steven Ayre <steveayre@gmail.com> wrote:
http://jira.freeswitch.org/browse/FS-5100
On 13 February 2013 17:40, Steven Ayre <steveayre@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=5c176e889d8cc2... http://jira.freeswitch.org/browse/FS-4810
-Steve
On 13 February 2013 17:37, Steven Ayre <steveayre@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@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@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@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@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@rupa.com>wrote: >>> >>>> >>>> On Tue, Feb 12, 2013 at 5:26 PM, David Villasmil < >>>> david.villasmil.work@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@freeswitch.org >>>> http://www.freeswitchsolutions.com >>>> >>>> FreeSWITCH-powered IP PBX: The CudaTel Communication Server >>>> http://www.cudatel.com >>>> >>>> Official FreeSWITCH Sites >>>> http://www.freeswitch.org >>>> http://wiki.freeswitch.org >>>> http://www.cluecon.com >>>> >>>> FreeSWITCH-users mailing list >>>> FreeSWITCH-users@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@freeswitch.org >>> http://www.freeswitchsolutions.com >>> >>> FreeSWITCH-powered IP PBX: The CudaTel Communication Server >>> http://www.cudatel.com >>> >>> Official FreeSWITCH Sites >>> http://www.freeswitch.org >>> http://wiki.freeswitch.org >>> http://www.cluecon.com >>> >>> FreeSWITCH-users mailing list >>> FreeSWITCH-users@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@freeswitch.org >> http://www.freeswitchsolutions.com >> >> FreeSWITCH-powered IP PBX: The CudaTel Communication Server >> http://www.cudatel.com >> >> Official FreeSWITCH Sites >> http://www.freeswitch.org >> http://wiki.freeswitch.org >> http://www.cluecon.com >> >> FreeSWITCH-users mailing list >> FreeSWITCH-users@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@freeswitch.org > http://www.freeswitchsolutions.com > > FreeSWITCH-powered IP PBX: The CudaTel Communication Server > http://www.cudatel.com > > Official FreeSWITCH Sites > http://www.freeswitch.org > http://wiki.freeswitch.org > http://www.cluecon.com > > FreeSWITCH-users mailing list > FreeSWITCH-users@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@freeswitch.org http://www.freeswitchsolutions.com
FreeSWITCH-powered IP PBX: The CudaTel Communication Server http://www.cudatel.com
Official FreeSWITCH Sites http://www.freeswitch.org http://wiki.freeswitch.org http://www.cluecon.com
FreeSWITCH-users mailing list FreeSWITCH-users@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@freeswitch.org http://www.freeswitchsolutions.com
FreeSWITCH-powered IP PBX: The CudaTel Communication Server http://www.cudatel.com
Official FreeSWITCH Sites http://www.freeswitch.org http://wiki.freeswitch.org http://www.cluecon.com
FreeSWITCH-users mailing list FreeSWITCH-users@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@freeswitch.org http://www.freeswitchsolutions.com
FreeSWITCH-powered IP PBX: The CudaTel Communication Server http://www.cudatel.com
Official FreeSWITCH Sites http://www.freeswitch.org http://wiki.freeswitch.org http://www.cluecon.com
FreeSWITCH-users mailing list FreeSWITCH-users@lists.freeswitch.org http://lists.freeswitch.org/mailman/listinfo/freeswitch-users UNSUBSCRIBE:http://lists.freeswitch.org/mailman/options/freeswitch-users http://www.freeswitch.org