Re: Postgresql connection issue
Re: Postgresql connection issue
- Subject: Re: Postgresql connection issue
- From: Theodore Petrosky <email@hidden>
- Date: Fri, 15 Nov 2013 10:52:42 -0500
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 <email@hidden> 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 <email@hidden> 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 <email@hidden> 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@hidden<mailto:email@hidden>> 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@hidden<mailto:email@hidden>> 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@hidden<mailto: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<mailto: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 = "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@hidden<mailto:email@hidden>)
>>>> Help/Unsubscribe/Update your Subscription:
>>>>
>>>> This email sent to email@hidden<mailto: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<mailto:email@hidden>)
>>> Help/Unsubscribe/Update your Subscription:
>>>
>>> This email sent to email@hidden<mailto:email@hidden>
>>>
>>>
>>>
>>> _______________________________________________
>>> 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
>>
>
_______________________________________________
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