http://jdbc.postgresql.org/download.html
Go check the jdbc version that they recommend. It does not match what yor error messages point to. Ted Sent from my iPad > On Nov 12, 2013, at 5:35 PM, Ramsey Gurley <[email protected]> wrote: > > For what it’s worth, I needed my local machine in the file under its > 192.168.x.x address for everything to work. May be because the database is > dedicated? Don’t know. Here’s what I have though: > > postgresql.conf > listen_addresses = 'localhost,192.168.100.96’ > pg_hba.conf > host all all 192.168.100.96/32 md5 > > >> On Nov 12, 2013, at 3:23 PM, Joe Kramer <[email protected]> wrote: >> >> The DB is on the same machine, so not sure why I would need another host >> entry. >> >> Sent from my iPhone >> >>> On Nov 12, 2013, at 1:50 PM, Theodore Petrosky <[email protected]> wrote: >>> >>> btw, did you read this in the pg_hba.conf file: >>> >>> # >>> # If you want to allow non-local connections, you need to add more >>> # "host" records. In that case you will also need to make PostgreSQL >>> # listen on a non-local interface via the listen_addresses >>> # configuration parameter, or via the -i or -h command line switches. >>> >>> # CAUTION: Configuring the system for local "trust" authentication >>> # allows any local user to connect as any PostgreSQL user, including >>> # the database superuser. If you do not trust all your local users, >>> # use another authentication method. >>> >>> and from postgresql.conf >>> >>> #------------------------------------------------------------------------------ >>> # CONNECTIONS AND AUTHENTICATION >>> #------------------------------------------------------------------------------ >>> >>> # - Connection Settings - >>> >>> listen_addresses = '*' # what IP address(es) to listen on; >>> # comma-separated list of addresses; >>> # defaults to 'localhost'; use '*' for all >>> # (change requires restart) >>> >>> >>> >>> >>>> On Nov 12, 2013, at 4:19 PM, Ramsey Gurley <[email protected]> wrote: >>>> >>>> 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/tedpet5%40yahoo.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]
