Re: jdbc connection from Eomodeler to postgresql 7.2.3 - Mailing list pgsql-novice

From János Löbb
Subject Re: jdbc connection from Eomodeler to postgresql 7.2.3
Date
Msg-id 02F49278-E145-11D6-8E9B-000A27DD8970@janos.mail.yale.edu
Whole thread Raw
In response to jdbc connection from Eomodeler to postgresql 7.2.3  (János Löbb <janos.lobb@yale.edu>)
List pgsql-novice
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)
>


pgsql-novice by date:

Previous
From: "Devinder K Rajput"
Date:
Subject: Re: [ADMIN] newbie qs; examining databases and tables
Next
From: "cristi"
Date:
Subject: PostgreSQL 7.2.1 Programmer's Guide in pdf format