Thread: Build and other trouble with 08.03.0100 on Linux
The build process of psqlodbc 08.03.0100 on Linux (or Unix platforms) seems to have some open ends. The default build uses SSL but doesn't link against any SSL library. Not sure how relevant that is. But I tried disabling the SSL support using the advertised option --disable-openssl, which doesn't work because the actual option is --disable-usessl. (Side note: If you want to fix the option name, it might be nice to use --without-openssl to be consistent with PostgreSQL.) That build then fails because NOT_USE_LIBPQ must be defined. With a successful build I experience various kinds of problems building up a connection, some of which even go away for a while when I try to connect a few times (!!!). The driver version 08.01.0200 I have lying around works without problems on the identical configuration (odbcinst.init and odbc.ini). Is anyone successfully using psqlodbc 08.03.0100 on Unix platforms?
I've not been successfull with either 08.02.0500 or 08.03.0100. I posted my errors to this list last week. I think we may be experiencing the same problem. I'm building on Solaris though. 08.01.0200 works fine for me too. Peter Eisentraut wrote: > The build process of psqlodbc 08.03.0100 on Linux (or Unix platforms) seems to > have some open ends. The default build uses SSL but doesn't link against any > SSL library. Not sure how relevant that is. But I tried disabling the SSL > support using the advertised option --disable-openssl, which doesn't work > because the actual option is --disable-usessl. (Side note: If you want to > fix the option name, it might be nice to use --without-openssl to be > consistent with PostgreSQL.) That build then fails because NOT_USE_LIBPQ > must be defined. With a successful build I experience various kinds of > problems building up a connection, some of which even go away for a while > when I try to connect a few times (!!!). The driver version 08.01.0200 I > have lying around works without problems on the identical configuration > (odbcinst.init and odbc.ini). Is anyone successfully using psqlodbc > 08.03.0100 on Unix platforms? > > -- > Sent via pgsql-odbc mailing list (pgsql-odbc@postgresql.org) > To make changes to your Subscription: > http://mail.postgresql.org/mj/mj_wwwusr?domain=postgresql.org&extra=pgsql-odbc > > -- +-------------------------------------------------------+ | Bruce McAlister Blueface Ltd | | <bruce.mcalister@blueface.ie> http://www.blueface.ie | +-------------------------------------------------------+
Hi. Sorry, very late reaction... Fundamentally, the problem may be included by the reason a protocol differs from 08.01 system. Then, Since we received two or more reports, we need investigate again. Therefore, I will investigate this problem. But, Since it has the now personal problem, there is no free time. Please give me postponement of time. Sorry.... Regards, Hiroshi Saito ----- Original Message ----- From: "Bruce McAlister" <bruce.mcalister@blueface.ie> > I've not been successfull with either 08.02.0500 or 08.03.0100. I posted > my errors to this list last week. I think we may be experiencing the > same problem. I'm building on Solaris though. 08.01.0200 works fine for > me too. > > Peter Eisentraut wrote: >> The build process of psqlodbc 08.03.0100 on Linux (or Unix platforms) seems to >> have some open ends. The default build uses SSL but doesn't link against any >> SSL library. Not sure how relevant that is. But I tried disabling the SSL >> support using the advertised option --disable-openssl, which doesn't work >> because the actual option is --disable-usessl. (Side note: If you want to >> fix the option name, it might be nice to use --without-openssl to be >> consistent with PostgreSQL.) That build then fails because NOT_USE_LIBPQ >> must be defined. With a successful build I experience various kinds of >> problems building up a connection, some of which even go away for a while >> when I try to connect a few times (!!!). The driver version 08.01.0200 I >> have lying around works without problems on the identical configuration >> (odbcinst.init and odbc.ini). Is anyone successfully using psqlodbc >> 08.03.0100 on Unix platforms? >> >> -- >> Sent via pgsql-odbc mailing list (pgsql-odbc@postgresql.org) >> To make changes to your Subscription: >> http://mail.postgresql.org/mj/mj_wwwusr?domain=postgresql.org&extra=pgsql-odbc >> >> > > -- > +-------------------------------------------------------+ > | Bruce McAlister Blueface Ltd | > | <bruce.mcalister@blueface.ie> http://www.blueface.ie | > +-------------------------------------------------------+ > > -- > Sent via pgsql-odbc mailing list (pgsql-odbc@postgresql.org) > To make changes to your Subscription: > http://mail.postgresql.org/mj/mj_wwwusr?domain=postgresql.org&extra=pgsql-odbc
Hi.
FreeBSD of the machine environment which I have does not reproduce a problem.
inet% psql -h localhost
Welcome to psql 8.2.6, the PostgreSQL interactive terminal.
Type: \copyright for distribution terms
\h for help with SQL commands
\? for help with psql commands
\g or terminate with semicolon to execute query
\q to quit
SSL connection (cipher: DHE-RSA-AES256-SHA, bits: 256)
saito=# SELECT ssl_is_used();
ssl_is_used
-------------
t
(1 row)
saito=# \q
inet% iodbctest DSN=PostgreSQL
iODBC Demonstration program
This program shows an interactive SQL processor
Driver Manager: 03.52.0406.0126
Driver: 08.03.0100 (psqlodbcw.so)
SQL>SELECT ssl_is_used();
ssl_is_used
-----------
1
result set 1 returned 1 rows.
SQL>
---
However, It may be that the difference between Linux and something happened the problem.
Therefore, I want to see your log. If possible, please send a log to me.
Regards,
Hiroshi Saito
----- Original Message -----
From: "Bruce McAlister" <bruce.mcalister@blueface.ie>
> I've not been successfull with either 08.02.0500 or 08.03.0100. I posted
> my errors to this list last week. I think we may be experiencing the
> same problem. I'm building on Solaris though. 08.01.0200 works fine for
> me too.
>
> Peter Eisentraut wrote:
>> The build process of psqlodbc 08.03.0100 on Linux (or Unix platforms) seems to
>> have some open ends. The default build uses SSL but doesn't link against any
>> SSL library. Not sure how relevant that is. But I tried disabling the SSL
>> support using the advertised option --disable-openssl, which doesn't work
>> because the actual option is --disable-usessl. (Side note: If you want to
>> fix the option name, it might be nice to use --without-openssl to be
>> consistent with PostgreSQL.) That build then fails because NOT_USE_LIBPQ
>> must be defined. With a successful build I experience various kinds of
>> problems building up a connection, some of which even go away for a while
>> when I try to connect a few times (!!!). The driver version 08.01.0200 I
>> have lying around works without problems on the identical configuration
>> (odbcinst.init and odbc.ini). Is anyone successfully using psqlodbc
>> 08.03.0100 on Unix platforms?
>>
>> --
>> Sent via pgsql-odbc mailing list (pgsql-odbc@postgresql.org)
>> To make changes to your Subscription:
>> http://mail.postgresql.org/mj/mj_wwwusr?domain=postgresql.org&extra=pgsql-odbc