Re: Postgres
Re: Postgres
- Subject: Re: Postgres
- From: Philip Mötteli <email@hidden>
- Date: Wed, 29 Oct 2003 23:25:10 +0100
Am 29.10.2003 um 16:51 schrieb Giorgio Valoti:
On Mercoledl, ott 29, 2003, at 16:15 Europe/Rome, Philip Mvtteli wrote:
Am 29.10.2003 um 15:29 schrieb Giorgio Valoti:
On Mercoledl, ott 29, 2003, at 14:38 Europe/Rome, Philip Mvtteli
wrote:
sudo -u postgres /sw/bin/pg_ctl start -D /sw/var/postgresql/data
-l /sw/var/postgresql/logfile -o -i
should be enough. So, let's see... Is your pg_hba.conf file
correctly configured? With something like this:
# TYPE DATABASE IP_ADDRESS MASK AUTH_TYPE
AUTH_ARGUMENT
host all 127.0.0.1 255.255.255.255 trust
When I put just this, I have the following error from Webmin: "SQL
select version() failed : No pg_hba.conf entry for host localhost,
user postgres, database template1"
And from EOModeler isn't any change, nor any log messages.
Before I had this:
# TYPE DATABASE USER IP-ADDRESS IP-MASK
METHOD
local all all
trust
host all all 127.0.0.1 255.255.255.255
trust
local is for UNIX domain sockets, which could explain why you can
connect with Webmin but not with eomodeler.
The second entry should be enough to let access your db from the
loopback interface. You can enable your whole local subnet, but you
should have the same results:
You're right, I tried it with:
# TYPE DATABASE USER IP-ADDRESS IP-MASK
METHOD
host all all 0.0.0.0 0.0.0.0 trust
local all all trust
host all all 127.0.0.1 255.255.255.255 trust
Nothing changes. The same message "Connection Failure: JDBCPlugIn" and
not even a tiny little message in the log file.
Thanks!
Phil
_______________________________________________
webobjects-dev mailing list | email@hidden
Help/Unsubscribe/Archives: http://www.lists.apple.com/mailman/listinfo/webobjects-dev
Do not post admin requests to the list. They will be ignored.
| References: | |
| | >Re: Postgres (From: Giorgio Valoti <email@hidden>) |