Thanks for your help! It’s working! I insert the user and the password in
odbc.ini.

 

  _____  

Von: freeswitch-users-boun...@lists.freeswitch.org
[mailto:freeswitch-users-boun...@lists.freeswitch.org] Im Auftrag von Chris
Danielson
Gesendet: Mittwoch, 7. Januar 2009 19:32
An: freeswitch-users@lists.freeswitch.org
Betreff: Re: [Freeswitch-users] no file mod_spidermonkey_odbc.so

 

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  <mailto:fidibu...@aol.com>
<fidibu...@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-boun...@lists.freeswitch.org
[mailto:freeswitch-users-boun...@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  <mailto:fidibu...@aol.com> <fidibu...@aol.com>
Reply-To:  <mailto:freeswitch-users@lists.freeswitch.org>
<freeswitch-users@lists.freeswitch.org>
Date: Wed, 7 Jan 2009 17:31:54 +0100
To:  <mailto:freeswitch-users@lists.freeswitch.org>
<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-boun...@lists.freeswitch.org
[mailto:freeswitch-users-boun...@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-boun...@lists.freeswitch.org
[mailto:freeswitch-users-boun...@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-boun...@lists.freeswitch.org
[mailto:freeswitch-users-boun...@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
  
_______________________________________________
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

Reply via email to