[Freeswitch-users] Error! Failed to log to database using nibblebill
Shahzad Bhatti
shahzad.bhatti at g-r-v.com
Wed Mar 6 17:54:38 MSK 2013
Mr. Muhammad Shahzad thanks alot for your reply,
i think that the user data source is not accessed as i try to use
[root at localhost scripts]# isql -v test root 12345678
*[IM002][unixODBC][Driver Manager]Data source name not found, and no
default driver specified
[ISQL]ERROR: Could not SQLConnect
*
but if i try
[root at localhost scripts]# isql -v freeswitch root 12345678
+---------------------------------------+
| Connected! |
| |
| sql-statement |
| help [tablename] |
| quit |
| |
+---------------------------------------+
thats what i find, any help now is really highly appreciated.
Regards
Shahzad Bhatti.
On Tue, Mar 5, 2013 at 9:47 PM, <
freeswitch-users-request at lists.freeswitch.org> wrote:
> Send FreeSWITCH-users mailing list submissions to
> freeswitch-users at lists.freeswitch.org
>
> To subscribe or unsubscribe via the World Wide Web, visit
> http://lists.freeswitch.org/mailman/listinfo/freeswitch-users
> or, via email, send a message with subject or body 'help' to
> freeswitch-users-request at lists.freeswitch.org
>
> You can reach the person managing the list at
> freeswitch-users-owner at lists.freeswitch.org
>
> When replying, please edit your Subject line so it is more specific
> than "Re: Contents of FreeSWITCH-users digest..."
>
> Today's Topics:
>
> 1. Re: Playing of mms stream by means of FS (xmppser)
> 2. Re: Error! Failed to log to database using nibblebill
> (Muhammad Shahzad)
>
>
> ---------- Forwarded message ----------
> From: xmppser <xmppser at gmail.com>
> To: freeswitch-users at lists.freeswitch.org
> Cc:
> Date: Tue, 5 Mar 2013 07:40:01 -0800 (PST)
> Subject: Re: [Freeswitch-users] Playing of mms stream by means of FS
> Ok, thanks,
>
> Since there is no body would like to share the code for this feature, I
> will
> implement mod_vlc to play video in freeswitch ,and i will opensource the
> code. there is no reason , i like opensource.
>
> Thanks
> Best Regards.
>
>
>
> --
> View this message in context:
> http://freeswitch-users.2379917.n2.nabble.com/Playing-of-mms-stream-by-means-of-FS-tp7579341p7588255.html
> Sent from the freeswitch-users mailing list archive at Nabble.com.
>
>
>
>
> ---------- Forwarded message ----------
> From: Muhammad Shahzad <shaheryarkh at gmail.com>
> To: FreeSWITCH Users Help <freeswitch-users at lists.freeswitch.org>
> Cc:
> Date: Tue, 5 Mar 2013 17:46:57 +0100
> Subject: Re: [Freeswitch-users] Error! Failed to log to database using
> nibblebill
> humm, i am not very sure what is the problem then. Can you try below and
> reply me with result?
>
> 1. Enable SQL query log on db server side, and see what SQL FS sends to
> the server? An ODBC trace file may also help.
>
> 2. Why are you defining both column name and custom SQLs? Typically you
> use only one of them, not both at the same time, so comment out one of them
> and test.
>
> 3. The custom SQL you are using has back-quotes, though these are
> permitted by ANSI SQL, but may create problem for other languages, i.e. the
> SQL you specify is in an XML file, which is interpreted by C++, which is
> then send to ODBC and then send to actual db server. Any of these
> interfaces may misinterpret them (Step 1 will give you clear clue on this).
>
> Thank you.
>
>
> On Tue, Mar 5, 2013 at 5:11 PM, Shahzad Bhatti <shahzad.bhatti at g-r-v.com>wrote:
>
>> thanks Mr. Muhammad Shahzad for the reply but issue is that when i use to
>> access database on console there it works fine but when i use in dialplan
>> here it not works
>>
>> here is my console output
>> *[root at localhost includes]# isql -v freeswitch*
>> *+---------------------------------------+*
>> *| Connected! |*
>> *| |*
>> *| sql-statement |*
>> *| help [tablename] |*
>> *| quit |*
>> *| |*
>> *+---------------------------------------+*
>> *SQL> use test;*
>> *SQLRowCount returns 0*
>> *SQL> select * from tb_accounts;*
>> *
>> +-----------+----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+-------------------------+
>> *
>> *| id | name
>>
>>
>> | cash |
>> *
>> *
>> +-----------+----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+-------------------------+
>> *
>> *| 1 | shahzad
>>
>>
>> | 10 |*
>> *| 2 | saeed
>>
>>
>> | 50 |*
>> *| 3 | usman
>>
>>
>> | 10 |*
>> *
>> +-----------+----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+-------------------------+
>> *
>> *SQLRowCount returns 3*
>> *3 rows fetched*
>> *SQL> update tb_accounts set cash = cash -1 where id =1;*
>> *SQLRowCount returns 1*
>> *SQL> select * from tb_accounts;*
>> *
>> +-----------+----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+-------------------------+
>> *
>> *| id | name
>>
>>
>> | cash |
>> *
>> *
>> +-----------+----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+-------------------------+
>> *
>> *| 1 | shahzad
>>
>>
>> | 9 |*
>> *| 2 | saeed
>>
>>
>> | 50 |*
>> *| 3 | usman
>>
>>
>> | 10 |*
>> *
>> +-----------+----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+-------------------------+
>> *
>> *SQLRowCount returns 3*
>> *3 rows fetched*
>> here u can see that update is also working, and here is my dialplan xml
>> * <document type="freeswitch/xml">*
>> * <section name="dialplan" description="RE Dial Plan For
>> FreeSwitch">*
>> * <context name="public">*
>> * <extension name="checkBalance">*
>> * <condition field="destination_number"
>> expression="^126$">*
>> * <action application="set"
>> data="nibble_rate=0.03"/>*
>> * <action application="set"
>> data="nibble_account=1"/>*
>> * <action application="answer"/>*
>> * <action application="hangup"/>*
>> * </condition>*
>> * </extension>*
>> * </context>*
>> * </section>*
>> * </document>
>> *
>>
>> i also check that the user and password and database is also correct.
>>
>> any help is appreciated
>>
>> Regards
>>
>> Shahzad Bhatti
>>
>> ---------- Forwarded message ----------
>>>> From: Muhammad Shahzad <shaheryarkh at gmail.com>
>>>> To: FreeSWITCH Users Help <freeswitch-users at lists.freeswitch.org>
>>>> Cc:
>>>> Date: Fri, 1 Mar 2013 17:07:39 +0100
>>>> Subject: Re: [Freeswitch-users] Error! Failed to log to database using
>>>> nibblebill
>>>> Problem is with SELECT query, most likely db connection parameters are
>>>> missing/invalid OR the db user configured does not have enough permissions
>>>> to execute SELECT,
>>>>
>>>> 2013-03-01 22:29:52.293493 [ERR] mod_nibblebill.c:380 Error running
>>>> this query: [SELECT `cash` AS nibble_balance FROM `tb_accounts` WHERE
>>>> `id`=1]
>>>>
>>>> Login db server from FS machine with same db user as configured in FS
>>>> configs and run above query, it would give you hint on what is actually
>>>> wrong.
>>>>
>>>> Thank you.
>>>>
>>>>
>>>> On Fri, Mar 1, 2013 at 1:42 PM, Shahzad Bhatti <
>>>> shahzad.bhatti at g-r-v.com> wrote:
>>>>
>>>>> hi
>>>>> i am using a nibblebill the call cost but have some problem in it.
>>>>> my nibblebill.conf.xml file is as
>>>>>
>>>>> http://pastebin.freeswitch.org/20650
>>>>>
>>>>> and console log is
>>>>>
>>>>> http://pastebin.freeswitch.org/20651
>>>>>
>>>>> i got Error *Failed to log to database! *Doing update query
>>>>>
>>>>> reply me about the issue
>>>>>
>>>>> Regards
>>>>>
>>>>> Shahzad Bhatti
>>>>>
>>>>
>> _________________________________________________________________________
>> 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
>>
>>
>
>
> --
> Muhammad Shahzad
> -----------------------------------
> CISCO Rich Media Communication Specialist (CRMCS)
> CISCO Certified Network Associate (CCNA)
> Cell: +49 176 99 83 10 85
> MSN: shari_786pk at hotmail.com
> Email: shaheryarkh at googlemail.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/20130306/14a0588e/attachment-0001.html
Join us at ClueCon 2011 Aug 9-11, 2011
More information about the FreeSWITCH-users
mailing list