Re: [OT] Re: installing tutos2



On Fri, May 25, 2007 at 01:56:54PM -0400, Roberto C. Sánchez wrote:
On Fri, May 25, 2007 at 06:33:21PM +0200, csanyipal wrote:

/etc/postgresql/8.1/main/pg_hba.conf :

------------------>
# Database administrative login by UNIX sockets
local all postgres ident sameuser

# TYPE DATABASE USER CIDR-ADDRESS METHOD

# "local" is for Unix domain socket connections only
local all all ident sameuser

# IPv4 local connections:
host all all 127.0.0.1/32 md5

# IPv6 local connections:
host all all ::1/128 md5

# I edited this for tutos:
host tutos 127.0.0.1 255.255.255.255 trust

Did you try this?

host tutos www-data 127.0.0.1 255.255.255.255 trust

Yes,now and after I edited the pg_hba.conf, I restarted postgresql too.

But I get the same error message:

Opening the database POSTGRES: tutos@localhost:5432 as www-data

Detail

DBerror: POSTGRES: tutos@localhost:5432 as www-data no connection

When I reconfigured tutos2 I give to www-data user an empty password
(hit enter).

I added now my username to www-data group.

--
Regards, Paul Csányi
http://www.freewebs.com/csanyi-pal/index.htm


--
To UNSUBSCRIBE, email to debian-user-REQUEST@xxxxxxxxxxxxxxxx
with a subject of "unsubscribe". Trouble? Contact listmaster@xxxxxxxxxxxxxxxx



Relevant Pages

  • Re: [SLE] postgresql on SuSE 10 (half solved)
    ... I can not login from KNoda. ... I set my password for postgres like this: ... # might also need to raise shared_buffers to support more connections. ...
    (SuSE)
  • Re: where is postgresql-8.3s packagers instructions?
    ... # "local" is for Unix domain socket connections only ... Configure pgadmin3 to use unix sockets. ... you can set one by using the psql tool as the user "postgres". ... how to set the password of the database user postgres? ...
    (Debian-User)
  • Re: How Common Lisp sucks
    ... Which is why I love Lisp!! ... also using postgres) for each request. ... but it tells me that making connections to ... postgres is really expensive- if you don't pool connections, ...
    (comp.lang.lisp)
  • Re: PDO: Switch database user without reopening connection
    ... multiple users set up on my Postgres database with varying levels of ... the postgres user they are logged in as to one that can make ... modifications to the database as well (editors get update permission, ... Unless you are using persistent connections, there is not much use in changing. ...
    (comp.lang.php)
  • Re: Damn you, FEDEX! or Nikon D40 lost in Springfield, MO blackhole.
    ... the 2 mp Mavica he had been using with a Nikon D40. ... After shopping around, he got me to order one for him. ... The shipper had it insured, but from what I have read it could take weeks to sort this crap out. ... You may get your insurance from FedEx and a couple weeks later they find it and deliver it. ...
    (alt.photography)