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:[email protected]] > Sent: Tuesday, June 16, 2009 6:44 PM > To: [email protected] > 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:[email protected]] >> Sent: Monday, June 15, 2009 6:44 PM >> To: [email protected] >> 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 >> [email protected] >> 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 >> [email protected] >> 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 > [email protected] > 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 > [email protected] > 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. _______________________________________________ Freeswitch-users mailing list [email protected] http://lists.freeswitch.org/mailman/listinfo/freeswitch-users UNSUBSCRIBE:http://lists.freeswitch.org/mailman/options/freeswitch-users http://www.freeswitch.org
