Re: Does psqlODBC actually work on osx? - Mailing list pgsql-odbc

> > We have a client trying to connect to PostgreSQL server 9.2 from an osx
> > client with our software via ODBC, he has asked for instructions to
> > assist him setting up.
> >
> > I have attempted the setup myself using psqlODBC and no matter what I do
> > configuration wise, the driver fails to connect (via iodbctestw and
> > iodbc administrator) stating that the password is incorrect - I know
> > this is not the case because I am using identical configuration to my
> > linux machine where it works fine.
> What is the exact error message you are getting?
> Are you connecting from within the same network as your Linux machine?
> Just trying to eliminate the possibility that it is a pg_hba.conf issue.
All on same internal network.
Server 10.0.0.3, working machine(s) 10.0.0.24, 10.0.0.25 etc. broken
machine 10.0.0.26
I've tried also setting the pg_hba.conf to 'trust' and even then it
doesn't seem to work.

Various config info and traces below.



Snippet from configuration (Although I've played with various other
options SSLmode etc. here as well)

[test]
Driver=psqlODBC
Server=10.0.0.3
Database=todo
Username=postgres
Password=postgres13




iodbctestw error messsage:
1: SQLDriverConnectW = FATAL: password authentication failed for user
"postgres" (210) SQLSTATE=28P01



Trace:
** Trace started on Tue Nov 04 18:17:38 2014
** Driver Manager: 03.52.0607.1008


[000000.001003]
iodbctestw      7FFF70390CC0 ENTER SQLAllocHandle
        SQLSMALLINT       1 (SQL_HANDLE_ENV)
        SQLHANDLE         0x0 (SQL_NULL_HANDLE)
        SQLHANDLE       * 0x100046340

[000000.001049]
iodbctestw      7FFF70390CC0 EXIT  SQLAllocHandle with return code 0 (SQL_SUCCESS)
        SQLSMALLINT       1 (SQL_HANDLE_ENV)
        SQLHANDLE         0x0 (SQL_NULL_HANDLE)
        SQLHANDLE       * 0x100046340 (0x100110c70)

[000000.001093]
iodbctestw      7FFF70390CC0 ENTER SQLSetEnvAttr
        SQLHENV           0x100110c70
        SQLINTEGER        200 (SQL_ATTR_ODBC_VERSION)
        SQLPOINTER        0x3
        SQLINTEGER      * 4294967291 (SQL_IS_UINTEGER)

[000000.001149]
iodbctestw      7FFF70390CC0 EXIT  SQLSetEnvAttr with return code 0 (SQL_SUCCESS)
        SQLHENV           0x100110c70
        SQLINTEGER        200 (SQL_ATTR_ODBC_VERSION)
        SQLPOINTER        0x3
        SQLINTEGER      * 4294967291 (SQL_IS_UINTEGER)

[000000.001192]
iodbctestw      7FFF70390CC0 ENTER SQLAllocHandle
        SQLSMALLINT       2 (SQL_HANDLE_DBC)
        SQLHANDLE         0x100110c70
        SQLHANDLE       * 0x100046348

[000000.001238]
iodbctestw      7FFF70390CC0 EXIT  SQLAllocHandle with return code 0 (SQL_SUCCESS)
        SQLSMALLINT       2 (SQL_HANDLE_DBC)
        SQLHANDLE         0x100110c70
        SQLHANDLE       * 0x100046348 (0x100110f20)

[000000.001279]
iodbctestw      7FFF70390CC0 ENTER SQLSetConnectOptionW
        SQLHDBC           0x100110f20
        SQLUSMALLINT      1051 (unknown connection attribute)
        SQLLEN            4295220960

[000000.001322]
iodbctestw      7FFF70390CC0 EXIT  SQLSetConnectOptionW with return code 0 (SQL_SUCCESS)
        SQLHDBC           0x100110f20
        SQLUSMALLINT      1051 (unknown connection attribute)
        SQLLEN            4295220960

[000000.001366]
iodbctestw      7FFF70390CC0 ENTER SQLGetInfoW
        SQLHDBC           0x100110f20
        SQLUSMALLINT      171 (SQL_DM_VER)
        SQLPOINTER        0x7fff5fbfeb80
        SQLSMALLINT       1020
        SQLSMALLINT     * 0x7fff5fbff60c

[000000.001438]
iodbctestw      7FFF70390CC0 EXIT  SQLGetInfoW with return code 0 (SQL_SUCCESS)
        SQLHDBC           0x100110f20
        SQLUSMALLINT      171 (SQL_DM_VER)
        SQLPOINTER        0x7fff5fbfeb80
                  | 03.52.0607.1008                          |
        SQLSMALLINT       1020
        SQLSMALLINT     * 0x7fff5fbff60c (15)

[000000.002935]
iodbctestw      7FFF70390CC0 ENTER SQLDriverConnectW
        SQLHDBC           0x100110f20
        SQLPOINTER        0x0
        SQLWCHAR        * 0x7fff5fbfdb80
                  | DSN=test;UID=postgres;PWD=**********     |
        SQLSMALLINT       -3 (SQL_NTS)
        SQLWCHAR        * 0x100048840
        SQLSMALLINT       4096
        SQLSMALLINT     * 0x7fff5fbff60e
        SQLUSMALLINT      1 (SQL_DRIVER_COMPLETE)

[000000.017832]
iodbctestw      7FFF70390CC0 EXIT  SQLDriverConnectW with return code -1 (SQL_ERROR)
        SQLHDBC           0x100110f20
        SQLPOINTER        0x0
        SQLWCHAR        * 0x7fff5fbfdb80
        SQLSMALLINT       -3 (SQL_NTS)
        SQLWCHAR        * 0x100048840
        SQLSMALLINT       4096
        SQLSMALLINT     * 0x7fff5fbff60e
        SQLUSMALLINT      1 (SQL_DRIVER_COMPLETE)

[000000.017936]
iodbctestw      7FFF70390CC0 ENTER SQLGetDiagRecW
        SQLSMALLINT       2 (SQL_HANDLE_DBC)
        SQLHDBC           0x100110f20
        SQLSMALLINT       1
        SQLWCHAR        * 0x7fff5fbfdad0
        SQLINTEGER      * 0x7fff5fbfdb0c
        SQLWCHAR        * 0x7fff5fbfd2d0
        SQLSMALLINT       512
        SQLSMALLINT     * 0x0

[000000.018047]
iodbctestw      7FFF70390CC0 EXIT  SQLGetDiagRecW with return code 0 (SQL_SUCCESS)
        SQLSMALLINT       2 (SQL_HANDLE_DBC)
        SQLHDBC           0x100110f20
        SQLSMALLINT       1
        SQLWCHAR        * 0x7fff5fbfdad0
                  | 28P01                                    |
        SQLINTEGER      * 0x7fff5fbfdb0c (210)
        SQLWCHAR        * 0x7fff5fbfd2d0
                  | FATAL: password authentication failed fo |
                  | r user "postgres"                        |
        SQLSMALLINT       512
        SQLSMALLINT     * 0x0

[000000.018306]
iodbctestw      7FFF70390CC0 ENTER SQLGetDiagRecW
        SQLSMALLINT       2 (SQL_HANDLE_DBC)
        SQLHDBC           0x100110f20
        SQLSMALLINT       2
        SQLWCHAR        * 0x7fff5fbfdad0
        SQLINTEGER      * 0x7fff5fbfdb0c
        SQLWCHAR        * 0x7fff5fbfd2d0
        SQLSMALLINT       512
        SQLSMALLINT     * 0x0

[000000.018480]
iodbctestw      7FFF70390CC0 EXIT  SQLGetDiagRecW with return code 100 (SQL_NO_DATA_FOUND)
        SQLSMALLINT       2 (SQL_HANDLE_DBC)
        SQLHDBC           0x100110f20
        SQLSMALLINT       2
        SQLWCHAR        * 0x7fff5fbfdad0
        SQLINTEGER      * 0x7fff5fbfdb0c
        SQLWCHAR        * 0x7fff5fbfd2d0
        SQLSMALLINT       512
        SQLSMALLINT     * 0x0

[000000.018544]
iodbctestw      7FFF70390CC0 ENTER SQLGetDiagRecW
        SQLSMALLINT       1 (SQL_HANDLE_ENV)
        SQLHENV           0x100110c70
        SQLSMALLINT       1
        SQLWCHAR        * 0x7fff5fbfdad0
        SQLINTEGER      * 0x7fff5fbfdb0c
        SQLWCHAR        * 0x7fff5fbfd2d0
        SQLSMALLINT       512
        SQLSMALLINT     * 0x0

[000000.018833]
iodbctestw      7FFF70390CC0 EXIT  SQLGetDiagRecW with return code 100 (SQL_NO_DATA_FOUND)
        SQLSMALLINT       1 (SQL_HANDLE_ENV)
        SQLHENV           0x100110c70
        SQLSMALLINT       1
        SQLWCHAR        * 0x7fff5fbfdad0
        SQLINTEGER      * 0x7fff5fbfdb0c
        SQLWCHAR        * 0x7fff5fbfd2d0
        SQLSMALLINT       512
        SQLSMALLINT     * 0x0

[000000.018940]
iodbctestw      7FFF70390CC0 ENTER SQLGetDiagRecW
        SQLSMALLINT       2 (SQL_HANDLE_DBC)
        SQLHDBC           0x100110f20
        SQLSMALLINT       1
        SQLWCHAR        * 0x7fff5fbff9e0
        SQLINTEGER      * 0x7fff5fbffa1c
        SQLWCHAR        * 0x7fff5fbff1e0
        SQLSMALLINT       512
        SQLSMALLINT     * 0x0

[000000.019015]
iodbctestw      7FFF70390CC0 EXIT  SQLGetDiagRecW with return code 100 (SQL_NO_DATA_FOUND)
        SQLSMALLINT       2 (SQL_HANDLE_DBC)
        SQLHDBC           0x100110f20
        SQLSMALLINT       1
        SQLWCHAR        * 0x7fff5fbff9e0
        SQLINTEGER      * 0x7fff5fbffa1c
        SQLWCHAR        * 0x7fff5fbff1e0
        SQLSMALLINT       512
        SQLSMALLINT     * 0x0

[000000.019083]
iodbctestw      7FFF70390CC0 ENTER SQLGetDiagRecW
        SQLSMALLINT       1 (SQL_HANDLE_ENV)
        SQLHENV           0x100110c70
        SQLSMALLINT       1
        SQLWCHAR        * 0x7fff5fbff9e0
        SQLINTEGER      * 0x7fff5fbffa1c
        SQLWCHAR        * 0x7fff5fbff1e0
        SQLSMALLINT       512
        SQLSMALLINT     * 0x0

[000000.019149]
iodbctestw      7FFF70390CC0 EXIT  SQLGetDiagRecW with return code 100 (SQL_NO_DATA_FOUND)
        SQLSMALLINT       1 (SQL_HANDLE_ENV)
        SQLHENV           0x100110c70
        SQLSMALLINT       1
        SQLWCHAR        * 0x7fff5fbff9e0
        SQLINTEGER      * 0x7fff5fbffa1c
        SQLWCHAR        * 0x7fff5fbff1e0
        SQLSMALLINT       512
        SQLSMALLINT     * 0x0

[000000.019216]
iodbctestw      7FFF70390CC0 ENTER SQLFreeHandle
        SQLSMALLINT       2 (SQL_HANDLE_DBC)
        SQLHDBC           0x100110f20

[000000.019263]
iodbctestw      7FFF70390CC0 EXIT  SQLFreeHandle with return code 0 (SQL_SUCCESS)
        SQLSMALLINT       2 (SQL_HANDLE_DBC)
        SQLHDBC           0x100110f20

[000000.019297]
iodbctestw      7FFF70390CC0 ENTER SQLFreeHandle
        SQLSMALLINT       1 (SQL_HANDLE_ENV)
        SQLHENV           0x100110c70

[000000.019328]
iodbctestw      7FFF70390CC0 EXIT  SQLFreeHandle with return code 0 (SQL_SUCCESS)
        SQLSMALLINT       1 (SQL_HANDLE_ENV)
        SQLHENV           0x100110c70

** Trace finished on Tue Nov 04 18:17:38 2014


>
> >
> >
> > Has anybody actually tested psqlODBC on OSX recently? Does it actually
> > work? Is there some known issue that causes this password thing, if so
> > what is the workaround?
> > (I'm trying on Snow Leopard myself but even information about a more
> > recent version would be great to know)