[Freeswitch-users] no file mod_spidermonkey_odbc.so

[Stephen Crosby]

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 at 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 at lists.freeswitch.org
> [mailto:freeswitch-users-bounces at lists.freeswitch.org] Im Auftrag von Ken
> Rice
> Gesendet: Mittwoch, 7. Januar 2009 17:42
> An: freeswitch-users at 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 at aol.com>
> Reply-To: <freeswitch-users at lists.freeswitch.org>
> Date: Wed, 7 Jan 2009 17:31:54 +0100
> To: <freeswitch-users at 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 at lists.freeswitch.org
> [mailto:freeswitch-users-bounces at lists.freeswitch.org] Im Auftrag von Chris
> Danielson
> Gesendet: Mittwoch, 7. Januar 2009 16:39
> An: freeswitch-users at 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 at lists.freeswitch.org
> [mailto:freeswitch-users-bounces at lists.freeswitch.org] Im Auftrag von Chris
> Danielson
> Gesendet: Mittwoch, 7. Januar 2009 16:17
> An: freeswitch-users at 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 at lists.freeswitch.org
> [mailto:freeswitch-users-bounces at lists.freeswitch.org] Im Auftrag von
> Michael Jerris
> Gesendet: Mittwoch, 7. Januar 2009 15:15
> An: freeswitch-users at 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 at lists.freeswitch.org
> http://lists.freeswitch.org/mailman/listinfo/freeswitch-users
> UNSUBSCRIBE:http://lists.freeswitch.org/mailman/options/freeswitch-users
> http://www.freeswitch.org
>
>