btw, did you read this in the pg_hba.conf file:
#
# If you want to allow non-local connections, you need to add more
# "host" records. In that case you will also need to make PostgreSQL
# listen on a non-local interface via the listen_addresses
# configuration parameter, or via the -i or -h command line switches.
# CAUTION: Configuring the system for local "trust" authentication
# allows any local user to connect as any PostgreSQL user, including
# the database superuser. If you do not trust all your local users,
# use another authentication method.
and from postgresql.conf
#------------------------------------------------------------------------------
# CONNECTIONS AND AUTHENTICATION
#------------------------------------------------------------------------------
# - Connection Settings -
listen_addresses = '*' # what IP address(es) to listen on;
# comma-separated list of addresses;
# defaults to 'localhost'; use '*' for
all
# (change requires restart)
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]
