VoIP Mailing List Archives

[darklion11 at yahoo.com]

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-tp24045890p24045890.html
Sent from the Freeswitch-users mailing list archive at Nabble.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

[asannucci at gmail.com]

Did you compiled freeswitch with this command?

./configure --enable-core-odbc-support
makemake installRegards

_______________________________________________
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

[dujinfang at gmail.com]

current configure will automatically use odbc if it's available, no
need the --enable-core-odbc-support anymore.
better to check if unixodbc-dev package installed of not.


On Jun 16, 2009, at 8:51 PM, bakko wrote:

[d at d-man.org]

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@yahoo.com]
Sent: Monday, June 15, 2009 6:44 PM
To: freeswitch-users@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@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@lists.freeswitch.org
http://lists.freeswitch.org/mailman/listinfo/freeswitch-users
UNSUBSCRIBE:http://lists.freeswitch.org/mailman/options/freeswitch-users
http://www.freeswitch.org

[darklion11 at yahoo.com]

my nibble.conf.xml

<configuration name="nibblebill.conf" description="Nibble Billing">
<settings>


<!-- Information for connecting to your database -->




<!-- The database table where your CASH column is located -->


<!-- The column name where we store the value of the account -->


<!-- The column name for the unique ID identifying the account -->



<!-- Default heartbeat interval. Set to 'off' for no heartbeat (i.e.
bill only at end of call) -->


<!-- By default, warn a caller when their balance is at $5.00. You can
set this to a negative number. -->



<!-- By default, terminate a caller when their balance hits $0.00. You
can set this to a negative number. -->



<!-- If a call goes beyond a certain dollar amount, flag or terminate it
-->



</settings>
</configuration>

Account 1001.xml

<include>
<user id="1001" mailbox="1001">
<params>






</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:

[d at d-man.org]

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@yahoo.com]
Sent: Tuesday, June 16, 2009 6:44 PM
To: freeswitch-users@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:

[darklion11 at yahoo.com]

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

Darren Schreiber wrote: