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:darklio...@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:darklio...@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