Is the db on the same machine as the app? If not, this won’t work. You need to add the IP of your app server. Something like...
host all all 192.168.0.100 trust On Nov 12, 2013, at 1:41 PM, Joe Kramer <[email protected]> wrote: > Thanks for the reply. Here is my config in pg_hba.conf. It seems like this > should not be causing the issue. Any other thoughts or something I am missing > in this config? > > Thanks, > > Joe > > # TYPE DATABASE USER ADDRESS METHOD > > # "local" is for Unix domain socket connections only > local all all trust > # IPv4 local connections: > host all all 127.0.0.1/32 trust > # IPv6 local connections: > host all all ::1/128 trust > > > On Tue, Nov 12, 2013 at 2:36 AM, Þór Sigurðsson <[email protected]> > wrote: > > Have you given the user permission to connect to the database ? > > Take a look at pg_hba.conf. Add a line for the user. If you _want_ the user > to use a password, then the last column should be "password" or better yet > "md5". If you want a trust-level connection, set it to "trust". > > On 12.11.2013, at 09:58, Joe Kramer <[email protected]> wrote: > > > Hi all, > > > > It has been some time since I have done any WebObjects development and I am > > trying to resurrect an old project on a new machine. I went through all the > > steps to get WebObjects/Wonder installed and I can run HelloWorld. The > > problem appears to be with my Postgresql JDBC connection. I am running > > Postgres93.app. I added the postgresql-9.3-1100.jdbc3.jar to my project's > > Resources folder and added that jar to the build path. When I run and try > > to bootstrap my database, I cannot connect and I get the following error. > > Is there something that I missed in the setup process? Any help would be > > appreciated. > > > > Thanks, > > > > Joe Kramer > > > > Nov 12 01:49:37 GALApplication[9199] WARN NSLog - An exception occurred > > while trying to open a channel: N/A > > Nov 12 01:49:37 GALApplication[9199] INFO > > er.transaction.adaptor.Exceptions - Database Exception occured: > > java.lang.IllegalStateException: _obtainOpenChannel -- > > com.webobjects.eoaccess.EODatabaseContext > > com.webobjects.eoaccess.EODatabaseContext@105585dc: failed to open database > > channel. Check your connection dictionary, and ensure your database is > > correctly configured. > > Nov 12 01:49:37 GALApplication[9199] DEBUG NSLog - Using JDBCPlugIn > > 'PostgresqlPlugIn' for JDBCAdaptor@1767199109 > > Nov 12 01:49:37 GALApplication[9199] INFO > > er.extensions.eof.ERXDatabaseContextDelegate - GALDatabase: {plugin = > > "PostgresqlPlugIn"; username = "jkramer"; driver = "org.postgresql.Driver"; > > password = "<password deleted for log>"; URL = > > "jdbc:postgresql://localhost/gal_database?useBundledJdbcInfo=true"; } > > Nov 12 01:49:37 GALApplication[9199] INFO > > er.transaction.adaptor.ConnectionAnalyzer - Checking JDBC connection with > > information {plugin = "PostgresqlPlugIn"; username = "jkramer"; driver = > > "org.postgresql.Driver"; password = "<password deleted for log>"; URL = > > "jdbc:postgresql://localhost/gal_database?useBundledJdbcInfo=true"; } > > Nov 12 01:49:37 GALApplication[9199] INFO > > er.transaction.adaptor.ConnectionAnalyzer - Trying to create JDBCAdaptor... > > Nov 12 01:49:37 GALApplication[9199] INFO > > er.transaction.adaptor.ConnectionAnalyzer - Successfully created adaptor > > com.webobjects.jdbcadaptor.JDBCAdaptor > > Nov 12 01:49:37 GALApplication[9199] INFO > > er.transaction.adaptor.ConnectionAnalyzer - Trying to create plugin... > > Nov 12 01:49:37 GALApplication[9199] DEBUG NSLog - Using JDBCPlugIn > > 'PostgresqlPlugIn' for JDBCAdaptor@1616586953 > > Nov 12 01:49:37 GALApplication[9199] INFO > > er.transaction.adaptor.ConnectionAnalyzer - Created plugin > > com.webobjects.jdbcadaptor.PostgresqlPlugIn > > Nov 12 01:49:37 GALApplication[9199] INFO > > er.transaction.adaptor.ConnectionAnalyzer - Trying to load JDBC driver > > org.postgresql.Driver... > > Nov 12 01:49:37 GALApplication[9199] INFO > > er.transaction.adaptor.ConnectionAnalyzer - Successfully loaded JDBC > > driver org.postgresql.Driver > > Nov 12 01:49:37 GALApplication[9199] INFO > > er.transaction.adaptor.ConnectionAnalyzer - JDBC driver and plugin are > > loaded, trying to connect... > > Nov 12 01:49:37 GALApplication[9199] INFO > > er.transaction.adaptor.ConnectionAnalyzer - Error: Exception thrown while > > connecting. > > Check exception message carefully. > > Nov 12 01:49:37 GALApplication[9199] ERROR > > er.transaction.adaptor.ConnectionAnalyzer - No connection. > > Nov 12 01:49:37 GALApplication[9199] WARN NSLog - A fatal exception > > occurred: _obtainOpenChannel -- com.webobjects.eoaccess.EODatabaseContext > > com.webobjects.eoaccess.EODatabaseContext@105585dc: failed to open database > > channel. Check your connection dictionary, and ensure your database is > > correctly configured. > > [2013-11-12 1:49:37 PST] <main> java.lang.IllegalStateException: > > _obtainOpenChannel -- com.webobjects.eoaccess.EODatabaseContext > > com.webobjects.eoaccess.EODatabaseContext@105585dc: failed to open database > > channel. Check your connection dictionary, and ensure your database is > > correctly configured. > > at > > com.webobjects.eoaccess.EODatabaseContext._obtainOpenChannel(EODatabaseContext.java:1967) > > at > > com.webobjects.eoaccess.EODatabaseContext._objectsWithFetchSpecificationEditingContext(EODatabaseContext.java:3054) > > at > > com.webobjects.eoaccess.EODatabaseContext.objectsWithFetchSpecification(EODatabaseContext.java:3195) > > at > > com.webobjects.eocontrol.EOObjectStoreCoordinator.objectsWithFetchSpecification(EOObjectStoreCoordinator.java:488) > > at > > com.webobjects.eocontrol.EOEditingContext.objectsWithFetchSpecification(EOEditingContext.java:4069) > > at > > er.extensions.eof.ERXEC.objectsWithFetchSpecification(ERXEC.java:1308) > > at > > com.webobjects.eocontrol.EOEditingContext.objectsWithFetchSpecification(EOEditingContext.java:4444) > > at > > er.extensions.eof.ERXFetchSpecification.fetchObjects(ERXFetchSpecification.java:155) > > at org.luth.eo._Product.fetchProducts(_Product.java:207) > > at org.luth.eo._Product.fetchAllProducts(_Product.java:201) > > at org.luth.eo._Product.fetchAllProducts(_Product.java:197) > > at org.luth.Application.migrateDbaseDB(Application.java:72) > > at org.luth.Application.<init>(Application.java:65) > > at sun.reflect.NativeConstructorAccessorImpl.newInstance0(Native > > Method) > > at > > sun.reflect.NativeConstructorAccessorImpl.newInstance(NativeConstructorAccessorImpl.java:39) > > at > > sun.reflect.DelegatingConstructorAccessorImpl.newInstance(DelegatingConstructorAccessorImpl.java:27) > > at java.lang.reflect.Constructor.newInstance(Constructor.java:513) > > at java.lang.Class.newInstance0(Class.java:357) > > at java.lang.Class.newInstance(Class.java:310) > > at com.webobjects.appserver.WOApplication.main(WOApplication.java:547) > > at > > er.extensions.appserver.ERXApplication.main(ERXApplication.java:861) > > at org.luth.Application.main(Application.java:58) > > _______________________________________________ > > Do not post admin requests to the list. They will be ignored. > > Webobjects-dev mailing list ([email protected]) > > Help/Unsubscribe/Update your Subscription: > > https://lists.apple.com/mailman/options/webobjects-dev/thors%40samgongustofa.is > > > > This email sent to [email protected] > > > ________________________________ > > Fyrirvari á tölvupósti / e-mail disclaimer > http://samgongustofa.is/fyrirvari/ > > _______________________________________________ > Do not post admin requests to the list. They will be ignored. > Webobjects-dev mailing list ([email protected]) > Help/Unsubscribe/Update your Subscription: > https://lists.apple.com/mailman/options/webobjects-dev/rgurley%40smarthealth.com > > This email sent to [email protected]
_______________________________________________ Do not post admin requests to the list. They will be ignored. Webobjects-dev mailing list ([email protected]) Help/Unsubscribe/Update your Subscription: https://lists.apple.com/mailman/options/webobjects-dev/archive%40mail-archive.com This email sent to [email protected]
