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.creat eRefCursorResultSet(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.creat eRefCursorResultSet(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.g etDataSource(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.creat eRefCursorResultSet(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 (AT) postgresql (DOT) org)

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 (AT) goforit (DOT) de wrote:

Bruno LEVEQUE
System Engineer
SARL NET6D
bruno.leveque (AT) net6d (DOT) com
http://www.net6d.com

---------------------------(end of broadcast)---------------------------
TIP 8: explain analyze is your friend

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


---------------------------(end of broadcast)---------------------------
TIP 7: don't forget to increase your free space map settings

chris (AT) goforit (DOT) de writes:
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

---------------------------(end of broadcast)---------------------------
TIP 4: Don't 'kill -9' the postmaster

chris (AT) vote4ad (DOT) com writes:
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

---------------------------(end of broadcast)---------------------------
TIP 9: the planner will ignore your desire to choose an index scan if your
joining column's datatypes do not match