Re: Postgresql connection issue

2013-11-18 Thread Pascal Robert
Since when OS X became "a economic deployment environment" ? - Mail original - De: "Daniel D CIV NAVAIR Beatty, 474300D" À: "WebObjects-Dev List" Envoyé: Lundi 18 Novembre 2013 13:28:01 Objet: RE: Postgresql connection issue Hi, I have one stupid question

Re: Postgresql connection issue

2013-11-18 Thread Ramsey Gurley
er [jkmarti...@gmail.com] > Sent: Sunday, November 17, 2013 1:13 AM > To: Theodore Petrosky > Cc: WebObjects Development > Subject: Re: Postgresql connection issue > > Hello all, > > Thank you to everyone, especially Ted, for all the help to get my dev > environment set up.

RE: Postgresql connection issue

2013-11-18 Thread Beatty, Daniel D CIV NAVAIR, 474300D
AM To: Theodore Petrosky Cc: WebObjects Development Subject: Re: Postgresql connection issue 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

Re: Postgresql connection issue

2013-11-17 Thread Joe Kramer
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 th

Re: Postgresql connection issue

2013-11-15 Thread Theodore Petrosky
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

Re: Postgresql connection issue

2013-11-15 Thread Theodore Petrosky
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

Re: Postgresql connection issue

2013-11-13 Thread Þór Sigurðsson
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,

Re: Postgresql connection issue

2013-11-12 Thread Theodore Petrosky
http://jdbc.postgresql.org/download.html Go check the jdbc version that they recommend. It does not match what yor error messages point to. Ted Sent from my iPad > On Nov 12, 2013, at 5:35 PM, Ramsey Gurley wrote: > > For what it’s worth, I needed my local machine in the file under its >

Re: Postgresql connection issue

2013-11-12 Thread Ramsey Gurley
For what it’s worth, I needed my local machine in the file under its 192.168.x.x address for everything to work. May be because the database is dedicated? Don’t know. Here’s what I have though: postgresql.conf listen_addresses = 'localhost,192.168.100.96’ pg_hba.conf host all all

Re: Postgresql connection issue

2013-11-12 Thread Joe Kramer
The DB is on the same machine, so not sure why I would need another host entry. Sent from my iPhone > On Nov 12, 2013, at 1:50 PM, Theodore Petrosky wrote: > > 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"

Re: Postgresql connection issue

2013-11-12 Thread Theodore Petrosky
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 comm

Re: Postgresql connection issue

2013-11-12 Thread Theodore Petrosky
like ramsey said: # TYPE DATABASEUSERADDRESS METHOD # IPv4 local connections: hostall admin 10.1.5.100/32 trust the line above is on my database machine (10.1.2.10). it allows 10.1.5.100 to talk to the database in a trust s

Re: Postgresql connection issue

2013-11-12 Thread Ramsey Gurley
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... hostall all 192.168.0.100trust On Nov 12, 2013, at 1:41 PM, Joe Kramer wrote: > Thanks for the reply. Here is my config in pg

Re: Postgresql connection issue

2013-11-12 Thread Joe Kramer
Using PGAdmin to connect and the DB is up and running. On Tue, Nov 12, 2013 at 1:09 PM, Theodore Petrosky wrote: > did you confirm that the database is running? > > what do you use to talk directly to the database? psql, pgadmin? > > Ted > > > On Nov 12, 2013, at 4:58 AM, Joe Kramer wrote: > >

Re: Postgresql connection issue

2013-11-12 Thread Theodore Petrosky
did you confirm that the database is running? what do you use to talk directly to the database? psql, pgadmin? Ted On Nov 12, 2013, at 4:58 AM, Joe Kramer 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

Re: Postgresql connection issue

2013-11-12 Thread Joe Kramer
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 DATABASEUSERADDRESS METHOD # "local" is for Unix domain socket connect

Re: Postgresql connection issue

2013-11-12 Thread Þór Sigurðsson
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,