I did two more things here. I started the postmaster with the -i
option and moved the postgresql.jar file into /Library/Java/Extensions.
Now when I try to connect EOModeler does not complain anymore about
the CLASSPATH but I am getting a different error message:
===============
Something unusual has occured to cause the driver to fail. Please
report this exception: Exception: java.sql.SQLException: FATAL 1: No
pg_hba.conf entry for host 204.90.81.246, user postgres, database test
Stack Trace:
java.sql.SQLException: FATAL 1: No pg_hba.conf entry for host
204.90.81.246, user postgres, database test
at org.postgresql.Connection.openConnection(Unknown Source)
at org.postgresql.Driver.connect(Unknown Source)
at java.sql.DriverManager.getConnection(DriverManager.java:512)
at java.sql.DriverManager.getConnection(DriverManager.java:141)
at JDBCContext.connect(JDBCContext.java:192)
at JDBCContext._tryConnect(JDBCContext.java:249)
at JDBCContext._fetchJDBCInfo(JDBCContext.java:474)
at JDBCPlugIn.jdbcInfo(JDBCPlugIn.java:588)
at JDBCAdaptor.jdbcInfo(JDBCAdaptor.java:166)
End of Stack Trace
===================
at the psql prompt I see:
test=# FATAL 1: No pg_hba.conf entry for host 204.90.81.246, user
postgres, database test
in the console I see:
2002-10-16 16:08:47.636 EOModeler[676] CFLog (0):
CFPropertyListCreateFromXMLData(): Old-style plist parser: missing
semicolon in dictionary.
2002-10-16 16:08:47.651 EOModeler[676] CFLog (0):
CFPropertyListCreateFromXMLData(): The file name for this data might be
(or it might not): file://localhost/usr/share/zoneinfo/America/New_York
2002-10-16 16:08:49.671 EOModeler[676] Loaded bundle with path
/Developer/EOMBundles/EOJavaClientExtensions.EOMbundle
Initializing PostgresqlPlugin
So, what am I still not doing right ?
What is the syntax to add a pg_hba.conf entry ?
Thanks ahead,
János
P.S. If I use URL jdbc:postgresql:test then I am IN !!
On Tuesday, Oct 15, 2002, at 18:33 America/New_York, János Löbb wrote:
> When I try to connect to Postgresql /7.2.3/ from EOModeler /Webobjects
> 5.1.4/ I am getting the following message:
>
> Connection Failure
> JDBC connection failed for driver :'org.postgresql.Driver'. Driver not
> found in Java Runtime! Please verify your CLASSPATH environment
> variable. The current CLASSPATH for your application is :
> /Developer/Applications/EOModeler.app/Contents/Resources/Java/
> eomodeler.zip:/Users/janos/Library/Java:/Library/Java:/System/Library/
> Java:/Network/Library/Java:/System/Library/Frameworks/
> JavaVM.framework/Classes/classes.jar:/System/Library/Frameworks/
> JavaVM.framework/Classes/ui.jar:/Developer/Applications/EOModeler.app/
> Contents/Resources/Java/eomodeler.zip
>
> I compiled postgresql with the --with-java option. I am using the
> following parameters when I try to connect:
>
> user: postgres
> password: postgres
> URL: jdbc:postgresql:test
>
> If I specify the driver as org.postgresql.Driver, the error message is
> the same. In the console I can see the message:
>
> Initializing PostgresqlPlugin
>
> I downloaded the PosgresqlPluginBundle from softrack, compiled it and
> placed the product into the /Developer/EOMBundles directory. I also
> copied postgresql.jar into the /Library/java folder, so it is in the
> CLASSPATH for EOModeler.
>
> What should I do different ?
>
> János
> P.S. postgresql is running :) From top:
> 17261 postgres 0.0% 0:00.00 1 8 17 84K 1.61M 228K
> 13.4M
> 17260 postgres 0.0% 0:00.01 1 8 18 32K 1.61M 156K
> 14.4M
> 17259 postgres 0.0% 0:00.81 1 10 17 40K 1.61M 760K
> 13.4M
>
>
>
> ---------------------------(end of
> broadcast)---------------------------
> TIP 2: you can get off all lists at once with the unregister command
> (send "unregister YourEmailAddressHere" to majordomo@postgresql.org)
>