Re: Postgresql connection issue
Re: Postgresql connection issue
- Subject: Re: Postgresql connection issue
- From: Theodore Petrosky <email@hidden>
- Date: Fri, 15 Nov 2013 09:58:45 -0500
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