VoIP Mailing List Archives

[fidibus83 at aol.com]

Hello,

[mike at jerris.com]

you would need to modify the modules.conf in the root of the source dir, not in the build dir.


On Jan 7, 2009, at 8:14 AM, fidibus83 wrote:

[fidibus83 at aol.com]

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.



On Jan 7, 2009, at 8:14 AM, fidibus83 wrote:




Hello,

[chris at maxpowersoft.com]

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:

[fidibus83 at aol.com]

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 (freeswitch-users-bounces@lists.freeswitch.org) [mailto:freeswitch-users-bounces@lists.freeswitch.org (freeswitch-users-bounces@lists.freeswitch.org)] Im Auftrag von Michael Jerris
Gesendet: Mittwoch, 7. Januar 2009 15:15
An: freeswitch-users@lists.freeswitch.org (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.



On Jan 7, 2009, at 8:14 AM, fidibus83 wrote:





Hello,

[chris at maxpowersoft.com]

Anytime. Good luck.

fidibus83 wrote:

[fidibus83 at aol.com]

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:
<![endif]--> <![endif]-->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 (freeswitch-users-bounces@lists.freeswitch.org) [mailto:freeswitch-users-bounces@lis ([email]freeswitch-users-bounces@lis[/email])ts.freeswitch.org] Im Auftrag von Chris Danielson
Gesendet: Mittwoch, 7. Januar 2009 16:17
An: freeswitch-users@lists.freeswitch.org (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 (freeswitch-users-bounces@lists.freeswitch.org) [mailto:freeswitch-users-bounces@lists.freeswitch.org (freeswitch-users-bounces@lists.freeswitch.org)] Im Auftrag von Michael Jerris
Gesendet: Mittwoch, 7. Januar 2009 15:15
An: freeswitch-users@lists.freeswitch.org (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.



On Jan 7, 2009, at 8:14 AM, fidibus83 wrote:






Hello,

[krice at suspicious.org]

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] ([email]freeswitch-users-bounces@lists.freeswitch.org][/email]) 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] ([email]freeswitch-users-bounces@lists.freeswitch.org][/email]) 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] ([email]freeswitch-users-bounces@lists.freeswitch.org][/email]) 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.

[fidibus83 at aol.com]

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:

…

[stevecrozz at gmail.com]

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:

[chris at maxpowersoft.com]

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:

[fidibus83 at aol.com]

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


Von: freeswitch-users-bounces@lists.freeswitch.org [mailto:freeswitch-users-bounces@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: