Hello all, Thank you to everyone, especially Ted, for all the help to get my dev environment set up. Some combination of re-installing PostgreSQL, adjusting my PATH variable, grumbling/shaking my fists in anger, setting default DB connection variables in my properties file, and/or re-adding all the necessary frameworks to my build path has done the trick and things seem to be in order. Personally I think it was all the grumbling. But in all seriousness, I can't say enough good things about the fine folks on this list. I have been lurking on the list for years with very little opportunity to use WO, but I always know I can come to this list if (when) I get into a bind. Thanks so much!
Regards, Joe On Fri, Nov 15, 2013 at 7:52 AM, Theodore Petrosky <tedp...@yahoo.com>wrote: > well yes and no! ARD uses postgresql on all versions of OS X. this is > what causes the conflict as it listens on port 5432 also. > > although this link refers to Lion, I found the same issue on Mountain Lion > > > http://joneslee85.wordpress.com/2011/10/27/fix-postgres-permission-denied-issue-on-osx-lion/ > > > > > > On Nov 15, 2013, at 10:03 AM, Þór Sigurðsson <th...@samgongustofa.is> > wrote: > > > Only 10.8 server has a postgres installation - not the client. > > > > The path isn't required for connectivity - only that the machine is > listening on localhost:5432 (which is the default for Postgres93.app ) > > > > On 15.11.2013, at 14:58, Theodore Petrosky <tedp...@yahoo.com> wrote: > > > >> 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 <th...@samgongustofa.is> > 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 <rgur...@smarthealth.com > <mailto:rgur...@smarthealth.com>> 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 <jkmarti...@gmail.com<mailto: > jkmarti...@gmail.com>> 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 < > th...@samgongustofa.is<mailto:th...@samgongustofa.is>> 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 <jkmarti...@gmail.com<mailto: > 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 > <mailto: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<mailto: > 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 > <mailto:Webobjects-dev@lists.apple.com>) > >>> Help/Unsubscribe/Update your Subscription: > >>> > https://lists.apple.com/mailman/options/webobjects-dev/rgurley%40smarthealth.com > >>> > >>> This email sent to rgur...@smarthealth.com<mailto: > rgur...@smarthealth.com> > >>> > >>> > >>> > >>> _______________________________________________ > >>> 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/tedpet5%40yahoo.com > >>> > >>> This email sent to tedp...@yahoo.com > >> > > > > > _______________________________________________ > 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/jkmartin19%40gmail.com > > This email sent to jkmarti...@gmail.com
_______________________________________________ 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
