Specifically it's introduced by commit 5c176e8 which was resolving FS-4810, which is indeed adding support for the the generalised DSN interface.-SteveOn 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.-SteveOn 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.-SteveOn 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-519a815ab6f02013-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:
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.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:272013-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"
--
-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