[Freeswitch-users] Error on mod_nibblebill cannot connect to ODBC

Edmar Cruz darklion11 at yahoo.com
Thu Jun 18 01:31:22 PDT 2009 

Ok thanks a lot for that. Sorry my mistake..

Darren Schreiber wrote:
> 
> Call me crazy but your DB DSN appears to be zenoss, but you have a db dsn
> of
> "tcapi" still in the config file.
> 
> If your test was:
> # isql zenoss edmar edmar 
>  
> 
> Then zenoss should be your db_dsn:
>     
> 
> Not
>     
> 
> 
> You should be seeing something about the ODBC connection failing at
> FreeSWITCH startup if you look at the log closely (search for
> mod_nibblebill) that indicates this, too.
> 
> - Darren
> 
> 
> -----Original Message-----
> From: Edmar Cruz [mailto:darklion11 at yahoo.com] 
> Sent: Tuesday, June 16, 2009 6:44 PM
> To: freeswitch-users at lists.freeswitch.org
> Subject: Re: [Freeswitch-users] Error on mod_nibblebill cannot connect to
> ODBC
> 
> 
> my nibble.conf.xml
> 
> <configuration name="nibblebill.conf" description="Nibble Billing">
>   <settings>
>    
> 
>     <!-- Information for connecting to your database -->
>     param name="db_username" value="edmar"/>
>     param name="db_password" value="edmar"/>
>     param name="db_dsn" value="tcapi"/>
> 
>     <!-- The database table where your CASH column is located -->
>     
> 
>     <!-- The column name where we store the value of the account -->
>     param name="db_column_cash" value="cash"/>
> 
>     <!-- The column name for the unique ID identifying the account -->
>     param name="db_column_account" value="id"/>
> 
> 
>     <!-- Default heartbeat interval. Set to 'off' for no heartbeat (i.e.
> bill only at end of call) -->
>     param name="global_heartbeat" value="1"/>
> 
>     !-- By default, warn a caller when their balance is at $5.00. You can
> set this to a negative number. -->
>     param name="lowbal_amt" value="5"/>
>     param name="lowbal_action" value="play ding"/>
> 
>     <!-- By default, terminate a caller when their balance hits $0.00. You
> can set this to a negative number. -->
>     param name="nobal_amt" value="0"/>
>     param name="nobal_action" value="hangup"/>
> 
>     <!-- If a call goes beyond a certain dollar amount, flag or terminate
> it
> -->
>     param name="percall_max_amt" value="100"/>
>     param name="percall_action" value="hangup"/>
> 
>   </settings>
> </configuration>
> 
> Account 1001.xml
> 
> <include>
>   <user id="1001" mailbox="1001">
>     <params>
>       param name="password" value="1234"/>
>       param name="vm-password" value="1001"/>
>       param name="vm-mailto" value=""/>
>       param name="vm-email-all-messages" value="false"/>
>       param name="vm-delete-file" value="false"/>
>       param name="vm-attach-file" value="false"/>
>     </params>
>     <variables>
>       <variable name="toll_allow" value="domestic,international,local"/>
>       <variable name="accountcode" value="1001"/>
>       <variable name="user_context" value="default"/>
>       <variable name="effective_caller_id_name" value="Extension 1001"/>
>       <!--<variable name="nibble_rate" value="0.10"/>
>       <variable name="nibble_account" value="1001"/>-->
>       <variable name="effective_caller_id_number" value="1001"/>
>       <variable name="outbound_caller_id_name"
> value="$${outbound_caller_name}"/>
>       <variable name="outbound_caller_id_number"
> value="$${outbound_caller_id}"/>
>       <variable name="callgroup" value="techsupport"/>
>       <variable name="name" value="Edmar"/>
>       <variable name="label" value=""/>
>       <variable name="areacode" value="63"/>
>       <variable name="effective_caller_int_name" value=""/>
>       <variable name="effective_caller_int_number" value=""/>
>       <variable name="record_calls" value="false"/>
>       <variable name="vm_active" value="true"/>
>       <variable name="process_cdr" value="false"/>
>       <variable name="cfwd_active" value="false"/>
>       <variable name="cfwd_dest" value=""/>
>       <variable name="cfwd_busyactive" value="false"/>
>       <variable name="cfwd_busydest" value=""/>
>       <variable name="cfwd_noansweractive" value="false"/>
>       <variable name="cfwd_noanswerdest" value=""/>
>       <variable name="cfwd_noanswerseconds" value=""/>
>       <variable name="call_progressaudio" value="0"/>
>       <variable name="allow_outbound" value="true"/>
>       <variable name="allow_xfer" value="false"/>
>       <variable name="hotline_active" value="true"/>
>       <variable name="hotline_dest" value=""/>
>       <variable name="classofservice" value="0"/>
>     </variables>
>   </user>
> </include>
> 
> 
> I check unixodbc has been installed. 
> 
> # isql zenoss edmar edmar 
> [SQL]>
> 
> Connected successfully but on freeswitch error Cannot connect to user ODBC
> [root]
> 
> 
> Darren Schreiber wrote:
>> 
>> What is in your ODBC settings in nibblebill.conf.xml ? Can you paste the
>> real logs from FS's logs? The info below is not nearly detailed enough. 
>> 
>> -----Original Message-----
>> From: Edmar Cruz [mailto:darklion11 at yahoo.com] 
>> Sent: Monday, June 15, 2009 6:44 PM
>> To: freeswitch-users at lists.freeswitch.org
>> Subject: [Freeswitch-users] Error on mod_nibblebill cannot connect to
>> ODBC
>> 
>> 
>> Hi
>> 
>> I experiencing an error on mod_nibblebill. I already load it from
>> autoload_configs, especially mod_spidermonkey. Uncomment
>> mod_spidermonkey_odbc. I also download unixodbc and created the files
>> /etc/odbcinst.ini and /etc/odbc.ini with the correct format
>> 
>> [zenoss]
>> DATABASE = tcapi
>> USER        = root
>> PASS        = password
>> .....
>> 
>> I type also on the console isql zenoss root password. Also working...
>> 
>> But an error occur on freeswitch Cannot connect to user [root] ...
>> 
>> What do you thinks is the problem?
>> --
>> View this message in context:
>>
> http://www.nabble.com/Error-on-mod_nibblebill-cannot-connect-to-ODBC-tp24045
>> 890p24045890.html
>> Sent from the Freeswitch-users mailing list archive at Nabble.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
>> 
>> 
>> _______________________________________________
>> 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
>> 
>> 
> 
> -- 
> View this message in context:
> http://www.nabble.com/Error-on-mod_nibblebill-cannot-connect-to-ODBC-tp24045
> 890p24065638.html
> Sent from the Freeswitch-users mailing list archive at Nabble.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
> 
> 
> _______________________________________________
> 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
> 
> 

-- 
View this message in context: http://www.nabble.com/Error-on-mod_nibblebill-cannot-connect-to-ODBC-tp24045890p24088636.html
Sent from the Freeswitch-users mailing list archive at Nabble.com.

More information about the FreeSWITCH-users mailing list