like ramsey said: # TYPE DATABASE USER ADDRESS METHOD # IPv4 local connections: host all admin 10.1.5.100/32 trust
the line above is on my database machine (10.1.2.10). it allows 10.1.5.100 to talk to the database in a trust setting. these are local on my internal network. Ted 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]
