From: | Adrian Klaver <adrian(dot)klaver(at)aklaver(dot)com> |
---|---|
To: | Igor Korot <ikorot01(at)gmail(dot)com> |
Cc: | Michael Paquier <michael(dot)paquier(at)gmail(dot)com>, Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>, PostgreSQL ODBC list <pgsql-odbc(at)postgresql(dot)org> |
Subject: | Re: Connection failed [was: Re: Distribution package for OSX] |
Date: | 2016-12-07 05:15:04 |
Message-ID: | 4600a871-de4f-e7a2-68ad-2827610fac08@aklaver.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-odbc |
On 12/06/2016 08:48 PM, Igor Korot wrote:
> Hi, guys,
> So I moved a little further with this.
>
> First of all I found out that default OSX install comes with client tools
> pre-installed. No server.
>
> So I installed the PostgreSQL server on my Mac.
>
> Next is trying to connect with iODBC.
>
> But first I tried to open SQL Shell (psql). Here is the session log:
>
> [code]
> Last login: Tue Dec 6 23:11:08 on ttys001
> /Library/PostgreSQL/9.1/scripts/runpsql.sh; exit
> Igors-MacBook-Air:~ igorkorot$ /Library/PostgreSQL/9.1/scripts/runpsql.sh; exit
> Server [localhost]:
> Database [postgres]:
> Port [5432]:
> Username [postgres]:
> Password for user postgres:
> psql (9.1.24)
> Type "help" for help.
>
> postgres=# \q
> logout
>
> [Process completed]
> [/code]
>
> So I presume that the server is running.
>
> Next I tried to configure ODBC. Since there is no psqlODBCS.so to
> setup the connection,
> I tried to do it manually.
>
> Here are the files:
>
> [code]
> Igors-MacBook-Air:~ igorkorot$ cat .odbcinst.ini
> [ODBC Drivers]
> MySQL ODBC 5.3 Unicode Driver = Installed
> MySQL ODBC 5.3 ANSI Driver = Installed
> PostgreSQL Unicode Driver = Installed
>
> [ODBC Connection Pooling]
> PerfMon = 0
> Retry Wait =
>
> [MySQL ODBC 5.3 Unicode Driver]
> Driver = /usr/local/lib/libmyodbc5w.so
>
> [MySQL ODBC 5.3 ANSI Driver]
> Driver = /usr/local/lib/libmyodbc5a.so
>
> [PostgreSQL Unicode Driver]
> Driver = /usr/local/lib/psqlodbcw.so
>
> Igors-MacBook-Air:~ igorkorot$ cat .odbc.ini
> [ODBC Data Sources]
> myodbc = MySQL ODBC 5.3 Unicode Driver
> myodbca = MySQL ODBC 5.3 ANSI Driver
> postgre = PostgreSQL Unicode Driver
>
> [ODBC]
> Trace = 0
> TraceAutoStop = 0
> TraceFile =
> TraceLibrary =
>
> [myodbc]
> Driver = MySQL ODBC 5.3 Unicode Driver
> SERVER = localhost
> PORT = 3306
>
> [myodbca]
> Driver = MySQL ODBC 5.3 ANSI Driver
> SERVER = localhost
> PORT = 3306
>
> [postgre]
> Driver = PostgreSQL Unicode Driver
> SERVER = localhost
> PORT = 5432
> User = postgres
> Password = wasqra
> Database = postgres
> [/code]
If I am following this:
then should it not be:
[postgre]
Driver = /usr/local/lib/psqlodbcw.so
host = localhost
SERVER = localhost
ServerName = localhost
PORT = 5432
UserName = postgres
Password = wasqra
Database = postgres
>
> Please tell me if I made a mistake configuring the DSN.
>
> Now when trying to connect to the database I'm getting following error:
How did you connect?
>
> [quote]
> Could not connect to server. No such file or directory.
> [/quote]
>
> Also, just for the reference, here is the files in /usr/local/lib:
>
> [code]
> Igors-MacBook-Air:~ igorkorot$ ls -la /usr/local/lib/
> total 27152
> drwxr-xr-x 14 root wheel 476 Dec 3 10:45 .
> drwxrwxr-x 9 root wheel 306 Jun 4 2016 ..
> -rwxr-xr-x 1 root wheel 367404 Jan 12 2016 libcppunit-1.12.1.0.0.dylib
> lrwxr-xr-x 1 root wheel 27 Jan 12 2016
> libcppunit-1.12.1.dylib -> libcppunit-1.12.1.0.0.dylib
> -rw-r--r-- 1 root wheel 3740688 Jan 12 2016 libcppunit.a
> lrwxr-xr-x 1 root wheel 27 Jan 12 2016 libcppunit.dylib ->
> libcppunit-1.12.1.0.0.dylib
> -rwxr-xr-x 1 root wheel 860 Jan 12 2016 libcppunit.la
> -rwxr-xr-x 1 root wheel 4604056 Jun 18 2014 libmyodbc5a.so
> -rwxr-xr-x 1 root wheel 4600096 Jun 18 2014 libmyodbc5w.so
> drwxr-xr-x 3 root wheel 102 Jan 12 2016 pkgconfig
> -rwxr-xr-x 1 root wheel 945 Dec 3 10:45 psqlodbcw.la
> -rwxr-xr-x 1 root wheel 555716 Dec 3 10:45 psqlodbcw.so
> lrwxr-xr-x 1 root wheel 16 Jan 31 2016 wxPython -> wxPython-3.0.2.0
> drwxr-xr-x 6 root wheel 204 Nov 27 2014 wxPython-3.0.2.0
> [/code]
>
> Could anyone spot an error?
> Or maybe I have to have a non-default database in order to connect via ODBC?
>
> Thank you.
>
> P.S.: Hopefully the mailer will understand that there is a
> continuation of the old thread...
>
> On Sat, Dec 3, 2016 at 2:30 PM, Adrian Klaver <adrian(dot)klaver(at)aklaver(dot)com> wrote:
>> On 12/03/2016 11:00 AM, Igor Korot wrote:
>>>
>>> Adrian,
>>
>>
>>>
>>> Thank you.
>>>
>>> BTW, is there a setup library generated? Maybe that the reason the driver
>>> is
>>> not in the list?
>>>
>>>>
>>
>> To add:
>>
>> http://www.iodbc.org/dataspace/doc/iodbc/wiki/iodbcWiki/ODBCOnUnix
>>
>>
>> --
>> Adrian Klaver
>> adrian(dot)klaver(at)aklaver(dot)com
>
--
Adrian Klaver
adrian(dot)klaver(at)aklaver(dot)com
From | Date | Subject | |
---|---|---|---|
Next Message | Igor Korot | 2016-12-07 16:41:26 | Re: Connection failed [was: Re: Distribution package for OSX] |
Previous Message | Igor Korot | 2016-12-07 04:48:36 | Connection failed [was: Re: Distribution package for OSX] |