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 <jkmarti...@gmail.com> 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 (Webobjects-dev@lists.apple.com)
> Help/Unsubscribe/Update your Subscription:
> https://lists.apple.com/mailman/options/webobjects-dev/thors%40samgongustofa.is
>
> This email sent to th...@samgongustofa.is
________________________________
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 (Webobjects-dev@lists.apple.com)
Help/Unsubscribe/Update your Subscription:
https://lists.apple.com/mailman/options/webobjects-dev/archive%40mail-archive.com
This email sent to arch...@mail-archive.com
