Problems with ODBC

fidibus83

6 Jan 2009 6 Jan '09

1:59 p.m.

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 cant 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 <load module="mod_spidermonkey_odbc"/> build/modules.conf languages/mod_spidermonkey_odbc Here my configurations: odbc.ini [fs01_odbc] Driver=MySQL SERVER=localhost PORT=3306 DATABASE=freeswitch Socket= /var/run/mysqld/mysqld.sock odbcinst.ini [MySQL] Description = ODBC for MySQL Driver = /usr/local/lib/libodbc.so UsageCount = 1 Can you help me? What do I wrong? Thanks! Regards, fidibus

Attachments:

attachment.html (text/html — 8.1 KB)

Show replies by date

Raul Fragoso

6 Jan 6 Jan

2:29 p.m.

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:

...

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

<load module="mod_spidermonkey_odbc"/>

build/modules.conf

languages/mod_spidermonkey_odbc

Here my configurations:

odbc.ini

[fs01_odbc]

Driver=MySQL

SERVER=localhost

PORT=3306

DATABASE=freeswitch

Socket= /var/run/mysqld/mysqld.sock

odbcinst.ini

[MySQL]

Description = ODBC for MySQL

Driver = /usr/local/lib/libodbc.so

UsageCount = 1

Can you help me? What do I wrong?

Thanks!

Regards, fidibus

_______________________________________________ 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

Brian West

2:45 p.m.

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:

...

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 =

Michael Jerris

2:45 p.m.

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> 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

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

<load module="mod_spidermonkey_odbc"/>

build/modules.conf languages/mod_spidermonkey_odbc

Here my configurations:

odbc.ini

[fs01_odbc]

Driver=MySQL

SERVER=localhost

PORT=3306

DATABASE=freeswitch

Socket= /var/run/mysqld/mysqld.sock

odbcinst.ini

[MySQL]

Description = ODBC for MySQL

Driver = /usr/local/lib/libodbc.so

UsageCount = 1

Can you help me? What do I wrong?

Thanks!

Regards, fidibus

_______________________________________________ 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

Raymond Chandler

3:12 p.m.

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

fidibus83

3:30 p.m.

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] Cant 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

Raymond Chandler

5:12 p.m.

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:

...

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

------------------------------------------------------------------------

_______________________________________________ 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

fidibus83

7 Jan 7 Jan

1:08 p.m.

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: 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] Cant 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 _____ _______________________________________________ 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

6510

Age (days ago)

6511

Last active (days ago)

List overview

Download

7 comments

5 participants

participants (5)

Brian West
fidibus83
Michael Jerris
Raul Fragoso
Raymond Chandler