[Freeswitch-users] no file mod_spidermonkey_odbc.so

[Chris Danielson]

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 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
>>
>>
>>     
> _______________________________________________
> 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
>   
-------------- next part --------------
An HTML attachment was scrubbed...
URL: http://lists.freeswitch.org/pipermail/freeswitch-users/attachments/20090107/fb214769/attachment-0002.html