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... Sent from the Freeswitch-users mailing list archive at Nabble.com.
Did you compiled freeswitch with this command? ./configure --enable-core-odbc-support makemake installRegards
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:
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
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
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:
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
-- View this message in context: http://www.nabble.com/Error-on-mod_nibblebill-cannot-connect-to-ODBC-tp24045... Sent from the Freeswitch-users mailing list archive at Nabble.com.
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:
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
-- 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@lists.freeswitch.org http://lists.freeswitch.org/mailman/listinfo/freeswitch-users UNSUBSCRIBE:http://lists.freeswitch.org/mailman/options/freeswitch-users http://www.freeswitch.org
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@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:
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
-- 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@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
-- View this message in context: http://www.nabble.com/Error-on-mod_nibblebill-cannot-connect-to-ODBC-tp24045... Sent from the Freeswitch-users mailing list archive at Nabble.com.
participants (4)
-
bakko
-
Darren Schreiber
-
dujinfang
-
Edmar Cruz