one of the problems I ran into with Postgresql and 10.8 os x was the path. OS X has an installation of postgresql so you need to make sure the path to the Postgresql.app is the first in the environment.
export PATH=/Applications/Postgres93.app/Contents/MacOS/bin:$PATH copy and paste this into a terminal session and see if it helps. if yes, add this to your .bash_profile. Ted On Nov 13, 2013, at 3:11 AM, Þór Sigurðsson <[email protected]> wrote: > > Exactly as Ramsey said - although if your database IS in fact on a remote > machine, you would not want "trust", since that would imply anybody could > connect as anybody to any database. > > If your database is "mybase" and your database user is "myuser" and your > development machine is 192.168.0.100, then your line ought to be something > like: > > host mybase myuser 192.168.0.100/32 md5 > > Only use a trust relationship if the server doesn't allow user logins or the > users logging in are truly trusted, and then only for 127.0.0.1/8 :) > > - however > > If your database happens to be on your _local_ machine (same as your > development/deployment) - like the Postgres.app for Mac OS X, then something > else is amuck. > > One thing that comes to mind - does your database actually exist? > > psql -l > > lists the databases > > IF the database you expect to use doesn't exist, of course there will be no > connection - so, if the database doesn't exist, I'll presume that the user > doesn't exist either. In that case, you'll need to create both. > > As the user running the postgres database (logged-in user if "Postgres.app" > or "postgres","psql" or other db-centric user of the OS the DB is running on: > > $ psql > # create user myuser password 'reallySecret2013'; > ... > # create database myuser owner myuser encoding='UTF8'; > ... > # exit > > Then try connecting again. > > Hope this helps :) > > /Þór > > On 12.11.2013, at 21:19, Ramsey Gurley > <[email protected]<mailto:[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]<mailto:[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<http://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]<mailto:[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]<mailto:[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]<mailto:[email protected]>) >> Help/Unsubscribe/Update your Subscription: >> https://lists.apple.com/mailman/options/webobjects-dev/thors%40samgongustofa.is >> >> This email sent to [email protected]<mailto:[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]<mailto:[email protected]>) > Help/Unsubscribe/Update your Subscription: > https://lists.apple.com/mailman/options/webobjects-dev/rgurley%40smarthealth.com > > This email sent to [email protected]<mailto:[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]
