Make sure to follow this example: http://wiki.freeswitch.org/wiki/Mod_spidermonkey_odbc#General_Configuration Remember to use the isql client to test your DSN connection. When that passes you'll be home free. Regards, Chris Stephen Crosby wrote:
I'm assuming you have your driver set up properly since you left that part out, but I got mine working a few weeks ago and I'll show you what I've got if it helps:
odbc.ini: [freeswitch_ph] Driver = /usr/lib/odbc/libmyodbc.so Description = MyODBC 3.51 Driver DSN SERVER = localhost PORT = USER = freeswitch_ph Password = Database = freeswitch_ph OPTION = 3 SOCKET =
somescript.js use("ODBC"); var DSN = 'freeswitch_ph'; var DB_USER = 'freeswitch_ph'; var DB_PASS = ''; var db = new ODBC(DSN, DB_USER, DB_PASS); db.connect();
On Wed, Jan 7, 2009 at 8:53 AM, fidibus83 <fidibus83@aol.com> wrote:
Yes, but why isn't it found?
My odbc.ini configuration:
[fs01_odbc]
Driver=MySQL
SERVER=localhost
PORT=3306
DATABASE=freeswitch
Socket = /var/lib/mysql/mysql.sock
Javascript:
…
use("ODBC");
var DSN="fs01_odbc";
var DB_USER="XXXXX";
var DB_PASS="YYYYY";
var db = new ODBC(DSN, DB_USER, DB_PASS);
db.connect();
…..
________________________________
Von: freeswitch-users-bounces@lists.freeswitch.org [mailto:freeswitch-users-bounces@lists.freeswitch.org] Im Auftrag von Ken Rice Gesendet: Mittwoch, 7. Januar 2009 17:42 An: freeswitch-users@lists.freeswitch.org Betreff: Re: [Freeswitch-users] no file mod_spidermonkey_odbc.so
Well your error tells you explicity DSN not found...
________________________________
From: fidibus83 <fidibus83@aol.com> Reply-To: <freeswitch-users@lists.freeswitch.org> Date: Wed, 7 Jan 2009 17:31:54 +0100 To: <freeswitch-users@lists.freeswitch.org> Subject: Re: [Freeswitch-users] no file mod_spidermonkey_odbc.so
I have another problem!
I want to connect to a mysql database through javascript.
I get this error: [ERR] switch_odbc.c:160 switch_odbc_handle_connect() STATE: IM002 CODE 0 ERROR: [unixODBC] [Driver Manager]Data source name not found, and no default driver specified [ERR] mod_spidermonkey_odbc.c:233 odbc_exec() Database is not connected! [ERR] mod_spidermonkey_odbc.c:289 odbc_next_row() database is not connected!
But when I test by running the utility isql the database is connected!
What's going wrong?
________________________________
Von: freeswitch-users-bounces@lists.freeswitch.org [mailto:freeswitch-users-bounces@lists.freeswitch.org] Im Auftrag von Chris Danielson Gesendet: Mittwoch, 7. Januar 2009 16:39 An: freeswitch-users@lists.freeswitch.org Betreff: Re: [Freeswitch-users] no file mod_spidermonkey_odbc.so
Anytime. Good luck.
fidibus83 wrote: Sorry Chris, my mistake. Mod_spidermonkey_odbc.so does exist now.
I wanted to said that I'm sorry for my stupid mistake that I uncomment the wrong thing.
But thank you very much for your help!
________________________________
Von: freeswitch-users-bounces@lists.freeswitch.org [mailto:freeswitch-users-bounces@lists.freeswitch.org] Im Auftrag von Chris Danielson Gesendet: Mittwoch, 7. Januar 2009 16:17 An: freeswitch-users@lists.freeswitch.org Betreff: Re: [Freeswitch-users] no file mod_spidermonkey_odbc.so
Fidibus, Make sure that you also have installed unixodbc. As shown here: http://wiki.freeswitch.org/wiki/Mod_spidermonkey_odbc#unixodbc
Kind Regards, Chris
fidibus83 wrote: Oh, I'm sorry.
Should I comment mod_spidermonkey_odbc in root/freeswitch/build/modules.conf again?
________________________________
Von: freeswitch-users-bounces@lists.freeswitch.org [mailto:freeswitch-users-bounces@lists.freeswitch.org] Im Auftrag von Michael Jerris Gesendet: Mittwoch, 7. Januar 2009 15:15 An: freeswitch-users@lists.freeswitch.org Betreff: Re: [Freeswitch-users] no file mod_spidermonkey_odbc.so
you would need to modify the modules.conf in the root of the source dir, not in the build dir.
_______________________________________________ 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