<div class="gmail_quote"><div>Hi,<br><br>Thanks for replying. The advise u gave resolved my problem. I want to ask three questions related to nibble bills, as I 'm listing down below;<br><br>1- Can we select/use dynamic tables for billing using nibble bill?<br>
2- Can we define more than two tables and attributes in nibblebill.conf.xml?<br>3- As Nibble bill is use to deduct amount of user account, Can we deduct minutes instead of cash? Because my case is, if a user buy a package and I only want to deducts his/her minutes. How we can resolve it by nibble bill? / What other way we can resolve it?<br>
<br>Kindly advise soon.<br><br> </div><blockquote class="gmail_quote" style="border-left: 1px solid rgb(204, 204, 204); margin: 0pt 0pt 0pt 0.8ex; padding-left: 1ex;"><br>---------- Forwarded message ----------<br>From: Todd Baumgartner <<a href="mailto:todd.baumgartner@gmail.com">todd.baumgartner@gmail.com</a>><br>
To: <a href="mailto:freeswitch-users@lists.freeswitch.org">freeswitch-users@lists.freeswitch.org</a><br>Date: Tue, 6 Oct 2009 10:31:06 -0400<br>Subject: Re: [Freeswitch-users] Cannot connect to ODBC driver/database freeswitchdb<br>
Ahmed,<br><br>I believe you need to specify the database name as it is configured in the odbc.ini<br><br>I am assuming you have something like this in your nibblebill.conf.xml<br><br> <param name="db_dsn" value="freeswitchdb"/><br>
<br>Try changing it to this as it is named in the odbc.ini:<br><br> <param name="db_dsn" value="MySQL-freeswitch"/><br><br><br>Thanks,<br><br>Todd<br><br><br><br><div class="gmail_quote">On Tue, Oct 6, 2009 at 6:11 AM, Ahmed Munir <span dir="ltr"><<a href="mailto:ahmedmunir007@gmail.com" target="_blank">ahmedmunir007@gmail.com</a>></span> wrote:<br>
<blockquote class="gmail_quote" style="border-left: 1px solid rgb(204, 204, 204); margin: 0pt 0pt 0pt 0.8ex; padding-left: 1ex;">Hi,<div><br></div><div>I've installed FS on Ubuntu 9.04 and I want to run mod_nibbles on it. I follow the steps to configure my ODBC connection with MySQL as explained in wiki (mod_nibbles and mod_spidermonkey). But FS, unable to connect it. The error I got is listed below when I restart FS,</div>
<div><br></div><div><div>2009-10-06 15:47:21.164590 [ERR] switch_odbc.c:188 STATE: IM002 CODE 0 ERROR: [unixODBC][Driver Manager]Data source name not found, and no default driver specified</div><div>2009-10-06 15:47:21.164617 [CRIT] mod_nibblebill.c:221 Cannot connect to ODBC driver/database freeswitchdb (user: root / pass password)</div>
<div><div>2009-10-06 15:47:21.164650 [CONSOLE] switch_loadable_module.c:889 Successfully Loaded [mod_nibblebill]</div><div>2009-10-06 15:47:21.164664 [NOTICE] switch_loadable_module.c:248 Adding Application 'nibblebill'</div>
<div>2009-10-06 15:47:21.164710 [NOTICE] switch_loadable_module.c:270 Adding API Function 'nibblebill'</div></div><div><br></div><div>But when I use isql it accepts my odbc connection i.e. isql MySQL-freeswitch</div>
<div><br></div><div>I'm listing my settings of odbc.ini and odbcinst.ini as listed below;</div><div><br></div><div>odbc.ini</div><div>--------------</div><div>[MySQL-freeswitch]</div><div><div>Driver = MySQL</div>
<div>#Driver = /usr/lib/odbc/libodbcmyS.so </div><div>Description = Connector/ODBC Driver DSN With FreeSwitch</div><div>SERVER = localhost</div><div>PORT = 3306</div><div>USER = root</div><div>
Password = password</div><div>Database = freeswitchdb</div></div><div><br></div>odbcinst.ini</div><div>-------------------</div><div><div>[MySQL]</div><div>Description = ODBC for MySQL</div><div>Driver = /usr/lib/odbc/libmyodbc.so</div>
<div>Setup = /usr/lib/odbc/libodbcmyS.so</div><div>FileUsage = 1</div><div><br></div></div><div><br></div><div>odbc.ini and odbcinst.ini are located at /etc/. Even I set my odbc connection setting as I provide with this link; <a href="http://dev.mysql.com/doc/refman/5.0/en/connector-odbc-configuration-dsn-unix.html" target="_blank">http://dev.mysql.com/doc/refman/5.0/en/connector-odbc-configuration-dsn-unix.html</a></div>
<div><br></div><div>But unfortunately my problem is unresolved then.</div><div><br></div><div><br></div><div>Kindly advise me, how can I resolve this problem? </div><div><br>-- <br>Regards,<br><br>Ahmed Munir<br><br><br>
</div>
<br>_______________________________________________<br>
FreeSWITCH-users mailing list<br>
<a href="mailto:FreeSWITCH-users@lists.freeswitch.org" target="_blank">FreeSWITCH-users@lists.freeswitch.org</a><br>
<a href="http://lists.freeswitch.org/mailman/listinfo/freeswitch-users" target="_blank">http://lists.freeswitch.org/mailman/listinfo/freeswitch-users</a><br>
UNSUBSCRIBE:<a href="http://lists.freeswitch.org/mailman/options/freeswitch-users" target="_blank">http://lists.freeswitch.org/mailman/options/freeswitch-users</a><br>
<a href="http://www.freeswitch.org" target="_blank">http://www.freeswitch.org</a><br>
<br></blockquote></div><br>
<br>_______________________________________________<br>
FreeSWITCH-users mailing list<br>
<a href="mailto:FreeSWITCH-users@lists.freeswitch.org">FreeSWITCH-users@lists.freeswitch.org</a><br>
<a href="http://lists.freeswitch.org/mailman/listinfo/freeswitch-users" target="_blank">http://lists.freeswitch.org/mailman/listinfo/freeswitch-users</a><br>
UNSUBSCRIBE:<a href="http://lists.freeswitch.org/mailman/options/freeswitch-users" target="_blank">http://lists.freeswitch.org/mailman/options/freeswitch-users</a><br>
<a href="http://www.freeswitch.org" target="_blank">http://www.freeswitch.org</a><br>
<br></blockquote></div><br><br clear="all"><br>-- <br>Regards,<br><br>Ahmed Munir<br><br><br>