Re: Connection failed [was: Re: Distribution package for OSX]

Adrian,

On Wed, Dec 7, 2016 at 12:15 AM, Adrian Klaver
<adrian(dot)klaver(at)aklaver(dot)com> wrote:
> 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:
>
> http://www.iodbc.org/dataspace/doc/iodbc/wiki/iodbcWiki/FAQ#What%27s%20an%20odbc.ini%20and%20what%20do%20I%20put%20in%20it%3F
>
> 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

Thank you for the help.
Changing the ~/odbc.ini as per your writing made my code connect to the DB.

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