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

Darren Schreiber d at d-man.org
Thu Jun 18 00:24:20 PDT 2009 

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:
    <param name="db_dsn" value="zenoss"/>

Not
    <param name="db_dsn" value="tcapi"/>


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

More information about the FreeSWITCH-users mailing list