VoIP Mailing List Archives

[fidibus83 at aol.com]

Hello,

I need your help again!

I want to use ODBC in javascripts.

First I installed unixodbc and I did all the steps what are mentioned in wiki: mod spidermonkey odbc.

But when I test my ODBC Setup by running isql I get this error:
[ISQL]ERROR: Could not SQLConnect

And I can’t start FS. I get this Error:
./freeswitch: error while loading shared libraries: libodbc.so.1: cannot open shared object file: No such file or directory

I uncomment:

conf/autoload_configs/spidermonkey.conf.xml

[raul at etellicom.com]

Your odbcinst.ini file doesn't seem to have the MySQL ODBC driver
installed correctly. Did you install the libmyodbc package ?
This is the contents of my /etc/odbcinst.ini file with a working driver
for MySQL:

[MySQL]
Description = MySQL driver
Driver = /usr/lib/odbc/libmyodbc.so
Setup = /usr/lib/odbc/libodbcmyS.so
CPTimeout =
CPReuse =


On Tue, 2009-01-06 at 14:59 +0100, fidibus83 wrote:

[mike at jerris.com]

That error seemsto indicatethat unixodbc is not installed or not correctly installed.


Mike

On Jan 6, 2009, at 8:59 AM, "fidibus83" <fidibus83@aol.com (fidibus83@aol.com)> wrote:

[brian at freeswitch.org]

Chances are the paths to the .so's are wrong... I would verify that
info... if you're on 64bit it would be in lib64.

/b

On Jan 6, 2009, at 8:29 AM, Raul Fragoso wrote:

[intralanman at freeswi...]

fidibus83 wrote:

[fidibus83 at aol.com]

The libmyodbc package is installed.

But I see I have a lot of version of libmyodbc:
libmyodbc3.so
libmyodbc3_r.so
libmyodbc3_r-3.51.14.so
libmyodbc3-3.51.14.so

I changed odbcinst.ini:

[MySQL]
Description = ODBC for MySQL
Driver = /usr/lib/libmyodbc3.so
Setup = /usr/lib/libodbcmyS.so

I run isgl –vvv and I get this:

[08S01] [unixODBC] [MySQL] [ODBC 3.51 Driver] Can’t connect to local MySQL server through socket ‘/var/run/mysqld/mysqld.sock’ (2)
[ISQL] ERROR: Could not SQLConnect


Von: freeswitch-users-bounces@lists.freeswitch.org [mailto:freeswitch-users-bounces@lists.freeswitch.org] Im Auftrag von Raymond Chandler
Gesendet: Dienstag, 6. Januar 2009 16:13
An: freeswitch-users@lists.freeswitch.org
Betreff: Re: [Freeswitch-users] Problems with ODBC


fidibus83 wrote:
Hello,

I need your help again!

I want to use ODBC in javascripts.

First I installed unixodbc and I did all the steps what are mentioned in wiki: mod spidermonkey odbc.

But when I test my ODBC Setup by running isql I get this error:
[ISQL]ERROR: Could not SQLConnect
This isn't really a general purpose ODBC list, but using the -v option of isql tends to yield more verbose output (imagine that!)

so you get:
isql -vvv freeswitch freeswitch freeswitch
[IM002][unixODBC][Driver Manager]Data source name not found, and no default driver specified
[ISQL]ERROR: Could not SQLConnect


as opposed to:
isql freeswitch freeswitch freeswitch
[ISQL]ERROR: Could not SQLConnect

-Ray

[intralanman at freeswi...]

is mysql running on the localhost? if so, is that the correct path to the .sock?

you might also try using 127.0.0.1 as the host instead of localhost to force a network connection.

-Ray


fidibus83 wrote:

[fidibus83 at aol.com]

Thanks for your help. It works.


Von: freeswitch-users-bounces@lists.freeswitch.org [mailto:freeswitch-users-bounces@lists.freeswitch.org] Im Auftrag von Raymond Chandler
Gesendet: Dienstag, 6. Januar 2009 18:13
An: freeswitch-users@lists.freeswitch.org
Betreff: Re: [Freeswitch-users] Problems with ODBC


is mysql running on the localhost? if so, is that the correct path to the .sock?

you might also try using 127.0.0.1 as the host instead of localhost to force a network connection.

-Ray


fidibus83 wrote:
<![endif]--> <![endif]-->The libmyodbc package is installed.

But I see I have a lot of version of libmyodbc:
libmyodbc3.so
libmyodbc3_r.so
libmyodbc3_r-3.51.14.so
libmyodbc3-3.51.14.so

I changed odbcinst.ini:

[MySQL]
Description = ODBC for MySQL
Driver = /usr/lib/libmyodbc3.so
Setup = /usr/lib/libodbcmyS.so

I run isgl –vvv and I get this:

[08S01] [unixODBC] [MySQL] [ODBC 3.51 Driver] Can’t connect to local MySQL server through socket ‘/var/run/mysqld/mysqld.sock’ (2)
[ISQL] ERROR: Could not SQLConnect


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 Raymond Chandler
Gesendet: Dienstag, 6. Januar 2009 16:13
An: freeswitch-users@lists.freeswitch.org (freeswitch-users@lists.freeswitch.org)
Betreff: Re: [Freeswitch-users] Problems with ODBC


fidibus83 wrote:
Hello,

I need your help again!

I want to use ODBC in javascripts.

First I installed unixodbc and I did all the steps what are mentioned in wiki: mod spidermonkey odbc.

But when I test my ODBC Setup by running isql I get this error:
[ISQL]ERROR: Could not SQLConnect
This isn't really a general purpose ODBC list, but using the -v option of isql tends to yield more verbose output (imagine that!)

so you get:
isql -vvv freeswitch freeswitch freeswitch
[IM002][unixODBC][Driver Manager]Data source name not found, and no default driver specified
[ISQL]ERROR: Could not SQLConnect


as opposed to:
isql freeswitch freeswitch freeswitch
[ISQL]ERROR: Could not SQLConnect

-Ray