Thread: HowTo configure and compile with openssl and jdbc on RedHat Enterprise 3?
HowTo configure and compile with openssl and jdbc on RedHat Enterprise 3?
From
chris@goforit.de
Date:
Hi,
yesterday I got a new server running RH ES and now I try to get postgresql
up and running with no success ...
RH ES 3.2.3-20
PostgreSQL 7.4.1 .tgz package from postgresql.org
openssl 0.9.7a with openssl-devel package installed
j2sdk-1.4.2_03 RPM from SUN installed
If I try to run configure with the "--with-openssl=/usr" option, having
the openssl-devel package installed and files verified to be there
(/usr/include/openssl/ssl.h ...) configure will break saying openssl/ssl.h
needs to be available.
Then, having tried without openssl, but with "--with-java" enabled ...
configure suceeds, but compile will fail:
driver:
[copy] Copying 1 file to
/usr/local/src/postgresql-7.4.1/src/interfaces/jdbc/org/postgresql
[echo] Configured build for the JDBC3 edition driver with NO SSL
compile:
[javac] Compiling 77 source files to
/usr/local/src/postgresql-7.4.1/src/interfaces/jdbc/build
[javac]
/usr/local/src/postgresql-7.4.1/src/interfaces/jdbc/org/postgresql/jdbc3/Jdbc3Statement.java:28:
error: Invalid checked exception class `java.sql.SQLException' in
`throws' clause. The exception must be a subclass of an exception
thrown by
`org.postgresql.jdbc1.AbstractJdbc1Statement.createRefCursorResultSet(java.lang.String)'
from class `org.postgresql.jdbc1.AbstractJdbc1Statement'.
[javac] public PGRefCursorResultSet
createRefCursorResultSet (String cursorName) throws SQLException
[javac] ^
[javac]
/usr/local/src/postgresql-7.4.1/src/interfaces/jdbc/org/postgresql/jdbc3/Jdbc3PreparedStatement.java:23:
error: Invalid checked exception class `java.sql.SQLException' in
`throws' clause. The exception must be a subclass of an exception
thrown by
`org.postgresql.jdbc1.AbstractJdbc1Statement.createRefCursorResultSet(java.lang.String)'
from class `org.postgresql.jdbc1.AbstractJdbc1Statement'.
[javac] public PGRefCursorResultSet
createRefCursorResultSet (String cursorName) throws SQLException
[javac] ^
[javac]
/usr/local/src/postgresql-7.4.1/src/interfaces/jdbc/org/postgresql/jdbc3/Jdbc3PoolingDataSource.java:29:
error: Method
`org.postgresql.jdbc2.optional.PoolingDataSource.getDataSource(java.lang.String)'
was defined with return type
`org.postgresql.jdbc2.optional.PoolingDataSource' in class
`org.postgresql.jdbc2.optional.PoolingDataSource'.
[javac] static Jdbc3PoolingDataSource getDataSource(String name)
[javac] ^
[javac]
/usr/local/src/postgresql-7.4.1/src/interfaces/jdbc/org/postgresql/jdbc3/Jdbc3CallableStatement.java:23:
error: Invalid checked exception class `java.sql.SQLException' in
`throws' clause. The exception must be a subclass of an exception
thrown by
`org.postgresql.jdbc1.AbstractJdbc1Statement.createRefCursorResultSet(java.lang.String)'
from class `org.postgresql.jdbc1.AbstractJdbc1Statement'.
[javac] public PGRefCursorResultSet
createRefCursorResultSet (String cursorName) throws SQLException
[javac] ^
[javac] 4 errors
BUILD FAILED
file:/usr/local/src/postgresql-7.4.1/src/interfaces/jdbc/build.xml:116:
Compile failed; see the compiler error output for details.
Total time: 1 second
gmake[3]: *** [all] Error 1
gmake[3]: Leaving directory
`/usr/local/src/postgresql-7.4.1/src/interfaces/jdbc'
gmake[2]: *** [all] Error 2
gmake[2]: Leaving directory `/usr/local/src/postgresql-7.4.1/src/interfaces'
gmake[1]: *** [all] Error 2
gmake[1]: Leaving directory `/usr/local/src/postgresql-7.4.1/src'
gmake: *** [all] Error 2
What do I do wrong?
Thanks
Chris
Hi, For jsdk, I don't know. For openssl, my configure line is : configure --with-openssl No more and is running. Bruno On Thu, 22 Jan 2004 chris@goforit.de wrote: > Hi, > > yesterday I got a new server running RH ES and now I try to get postgresql > up and running with no success ... > > RH ES 3.2.3-20 > PostgreSQL 7.4.1 .tgz package from postgresql.org > openssl 0.9.7a with openssl-devel package installed > j2sdk-1.4.2_03 RPM from SUN installed > > If I try to run configure with the "--with-openssl=/usr" option, having > the openssl-devel package installed and files verified to be there > (/usr/include/openssl/ssl.h ...) configure will break saying openssl/ssl.h > needs to be available. > > Then, having tried without openssl, but with "--with-java" enabled ... > configure suceeds, but compile will fail: > > driver: > [copy] Copying 1 file to > /usr/local/src/postgresql-7.4.1/src/interfaces/jdbc/org/postgresql > [echo] Configured build for the JDBC3 edition driver with NO SSL > > compile: > [javac] Compiling 77 source files to > /usr/local/src/postgresql-7.4.1/src/interfaces/jdbc/build > [javac] > /usr/local/src/postgresql-7.4.1/src/interfaces/jdbc/org/postgresql/jdbc3/Jdbc3Statement.java:28: > error: Invalid checked exception class `java.sql.SQLException' in > `throws' clause. The exception must be a subclass of an exception > thrown by > `org.postgresql.jdbc1.AbstractJdbc1Statement.createRefCursorResultSet(java.lang.String)' > from class `org.postgresql.jdbc1.AbstractJdbc1Statement'. > [javac] public PGRefCursorResultSet > createRefCursorResultSet (String cursorName) throws SQLException > [javac] ^ > [javac] > /usr/local/src/postgresql-7.4.1/src/interfaces/jdbc/org/postgresql/jdbc3/Jdbc3PreparedStatement.java:23: > error: Invalid checked exception class `java.sql.SQLException' in > `throws' clause. The exception must be a subclass of an exception > thrown by > `org.postgresql.jdbc1.AbstractJdbc1Statement.createRefCursorResultSet(java.lang.String)' > from class `org.postgresql.jdbc1.AbstractJdbc1Statement'. > [javac] public PGRefCursorResultSet > createRefCursorResultSet (String cursorName) throws SQLException > [javac] ^ > [javac] > /usr/local/src/postgresql-7.4.1/src/interfaces/jdbc/org/postgresql/jdbc3/Jdbc3PoolingDataSource.java:29: > error: Method > `org.postgresql.jdbc2.optional.PoolingDataSource.getDataSource(java.lang.String)' > was defined with return type > `org.postgresql.jdbc2.optional.PoolingDataSource' in class > `org.postgresql.jdbc2.optional.PoolingDataSource'. > [javac] static Jdbc3PoolingDataSource getDataSource(String name) > [javac] ^ > [javac] > /usr/local/src/postgresql-7.4.1/src/interfaces/jdbc/org/postgresql/jdbc3/Jdbc3CallableStatement.java:23: > error: Invalid checked exception class `java.sql.SQLException' in > `throws' clause. The exception must be a subclass of an exception > thrown by > `org.postgresql.jdbc1.AbstractJdbc1Statement.createRefCursorResultSet(java.lang.String)' > from class `org.postgresql.jdbc1.AbstractJdbc1Statement'. > [javac] public PGRefCursorResultSet > createRefCursorResultSet (String cursorName) throws SQLException > [javac] ^ > [javac] 4 errors > > BUILD FAILED > file:/usr/local/src/postgresql-7.4.1/src/interfaces/jdbc/build.xml:116: > Compile failed; see the compiler error output for details. > > Total time: 1 second > gmake[3]: *** [all] Error 1 > gmake[3]: Leaving directory > `/usr/local/src/postgresql-7.4.1/src/interfaces/jdbc' > gmake[2]: *** [all] Error 2 > gmake[2]: Leaving directory `/usr/local/src/postgresql-7.4.1/src/interfaces' > gmake[1]: *** [all] Error 2 > gmake[1]: Leaving directory `/usr/local/src/postgresql-7.4.1/src' > gmake: *** [all] Error 2 > > What do I do wrong? > > Thanks > Chris > > > ---------------------------(end of broadcast)--------------------------- > TIP 2: you can get off all lists at once with the unregister command > (send "unregister YourEmailAddressHere" to majordomo@postgresql.org) > Bruno LEVEQUE System Engineer SARL NET6D bruno.leveque@net6d.com http://www.net6d.com
Hi, thanks, but it doesn't work. This has been my first guess, but results in the same error as if I add the prefix: checking for openssl/ssl.h... no configure: error: header file <openssl/ssl.h> is required for OpenSSL Even so I checked, file IS there and read permission is granted. I just can't figure out why it doesn't work ... Thanks Chris > Hi, > > For jsdk, I don't know. > > For openssl, my configure line is : > > configure --with-openssl > > No more and is running. > > > Bruno > > > On Thu, 22 Jan 2004 chris@goforit.de wrote: > >> Hi, >> >> yesterday I got a new server running RH ES and now I try to get >> postgresql >> up and running with no success ... >> >> RH ES 3.2.3-20 >> PostgreSQL 7.4.1 .tgz package from postgresql.org >> openssl 0.9.7a with openssl-devel package installed >> j2sdk-1.4.2_03 RPM from SUN installed >> >> If I try to run configure with the "--with-openssl=/usr" option, having >> the openssl-devel package installed and files verified to be there >> (/usr/include/openssl/ssl.h ...) configure will break saying >> openssl/ssl.h >> needs to be available. >> >> Then, having tried without openssl, but with "--with-java" enabled ... >> configure suceeds, but compile will fail: >> >> driver: >> [copy] Copying 1 file to >> /usr/local/src/postgresql-7.4.1/src/interfaces/jdbc/org/postgresql >> [echo] Configured build for the JDBC3 edition driver with NO SSL >> >> compile: >> [javac] Compiling 77 source files to >> /usr/local/src/postgresql-7.4.1/src/interfaces/jdbc/build >> [javac] >> /usr/local/src/postgresql-7.4.1/src/interfaces/jdbc/org/postgresql/jdbc3/Jdbc3Statement.java:28: >> error: Invalid checked exception class `java.sql.SQLException' in >> `throws' clause. The exception must be a subclass of an exception >> thrown by >> `org.postgresql.jdbc1.AbstractJdbc1Statement.createRefCursorResultSet(java.lang.String)' >> from class `org.postgresql.jdbc1.AbstractJdbc1Statement'. >> [javac] public PGRefCursorResultSet >> createRefCursorResultSet (String cursorName) throws SQLException >> [javac] ^ >> [javac] >> /usr/local/src/postgresql-7.4.1/src/interfac
chris@goforit.de writes:
> checking for openssl/ssl.h... no
> configure: error: header file <openssl/ssl.h> is required for OpenSSL
> Even so I checked, file IS there and read permission is granted.
I believe this error means that cpp failed on "#include <openssl/ssl.h>",
so there are more possible reasons for failure than whether the include
file itself exists. For example, it might be trying to include some
other file that's not present. It's pointless to guess with incomplete
information however. Look in the config.log file to see exactly what
the compiler's failure message is.
regards, tom lane
chris@vote4ad.com writes:
> Eh, unfortunately no. The error is not thrown by the compiler but the
> configure script. So there's nothing in the config.log about this.
I assure you there is something relevant in config.log. For example,
I get the following trace for <dld.h>, which doesn't exist here:
configure:7040: checking dld.h usability
configure:7049: gcc -c -O2 -fno-strict-aliasing -g -D_XOPEN_SOURCE_EXTENDED conftest.c >&5
configure:7077: dld.h: No such file or directory
configure:7052: $? = 1
configure: failed program was:
#line 7042 "configure"
#include "confdefs.h"
#include <stdio.h>
#if HAVE_SYS_TYPES_H
# include <sys/types.h>
#endif
#if HAVE_SYS_STAT_H
# include <sys/stat.h>
#endif
#if STDC_HEADERS
# include <stdlib.h>
# include <stddef.h>
#else
# if HAVE_STDLIB_H
# include <stdlib.h>
# endif
#endif
#if HAVE_STRING_H
# if !STDC_HEADERS && HAVE_MEMORY_H
# include <memory.h>
# endif
# include <string.h>
#endif
#if HAVE_STRINGS_H
# include <strings.h>
#endif
#if HAVE_INTTYPES_H
# include <inttypes.h>
#else
# if HAVE_STDINT_H
# include <stdint.h>
# endif
#endif
#if HAVE_UNISTD_H
# include <unistd.h>
#endif
#include <dld.h>
configure:7067: result: no
configure:7071: checking dld.h presence
configure:7078: gcc -E -D_XOPEN_SOURCE_EXTENDED conftest.c
configure:7074: dld.h: No such file or directory
configure:7084: $? = 1
configure: failed program was:
#line 7073 "configure"
#include "confdefs.h"
#include <dld.h>
configure:7102: result: no
configure:7120: checking for dld.h
configure:7127: result: no
regards, tom lane