• Open Menu Close Menu
  • Apple
  • Shopping Bag
  • Apple
  • Mac
  • iPad
  • iPhone
  • Watch
  • TV
  • Music
  • Support
  • Search apple.com
  • Shopping Bag

Lists

Open Menu Close Menu
  • Terms and Conditions
  • Lists hosted on this site
  • Email the Postmaster
  • Tips for posting to public mailing lists
Re: Postgresql connection issue
[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

Re: Postgresql connection issue

  • Subject: Re: Postgresql connection issue
  • From: Joe Kramer <email@hidden>
  • Date: Tue, 12 Nov 2013 12:41:00 -0800
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@hidden> 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@hidden> 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 = "" }
> 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 = "" }
> 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@hidden)
> Help/Unsubscribe/Update your Subscription:
>
> This email sent to email@hidden


________________________________

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@hidden)
Help/Unsubscribe/Update your Subscription:

This email sent to email@hidden
  • Follow-Ups:
    • Re: Postgresql connection issue
      • From: Ramsey Gurley <email@hidden>
References: 
 >Postgresql connection issue (From: Joe Kramer <email@hidden>)
 >Re: Postgresql connection issue (From: Þór Sigurðsson <email@hidden>)

  • Prev by Date: WebObjects benchmarks
  • Next by Date: Re: Postgresql connection issue
  • Previous by thread: Re: Postgresql connection issue
  • Next by thread: Re: Postgresql connection issue
  • Index(es):
    • Date
    • Thread