Re: Postgresql deying access

2011-02-12 Thread Nicolas Barbier
2011/2/11 Petr Salinger : 2011-02-11 12:12:50 CET LOG:  could not get peer credentials: Interrupted system call > > The problem seems be in postgresql package. > The sizeof(struct cmsgcred) is 84 on kfrebsd-amd64, there is no reason > for padding it  at the end to 8-byte boundary by kern

Re: Postgresql deying access

2011-02-11 Thread Petr Salinger
2011-02-11 12:12:50 CET LOG:  could not get peer credentials: Interrupted system call The problem seems be in postgresql package. The sizeof(struct cmsgcred) is 84 on kfrebsd-amd64, there is no reason for padding it at the end to 8-byte boundary by kernel. But postgresql want these extra 4 byte

Re: Postgresql deying access

2011-02-11 Thread Nicolas Barbier
2011/2/11 Nicolas Barbier : > 2011/2/11 Emanuele Balla : > >> 2011-02-11 12:12:50 CET LOG:  could not get peer credentials: >> Interrupted system call > > I think that this is enough to tell the porters what the problem is. I > also think I have seen similar problems being mentioned before, is > k

Re: Postgresql deying access

2011-02-11 Thread Nicolas Barbier
2011/2/11 Emanuele Balla : > On 2/11/11 12:04 PM, Nicolas Barbier wrote: > >>> postgres@netmon:~$ psql template1 >>> psql: FATAL:  Ident authentication failed for user "postgres" >> >> * What does the PostgreSQL log say? > > You're right (dumb me): > > 2011-02-11 12:12:50 CET LOG:  could not get p

Re: Postgresql deying access

2011-02-11 Thread Emanuele Balla
On 2/11/11 12:04 PM, Nicolas Barbier wrote: >> postgres@netmon:~$ psql template1 >> psql: FATAL: Ident authentication failed for user "postgres" > > * What does the PostgreSQL log say? You're right (dumb me): 2011-02-11 12:12:50 CET LOG: could not get peer credentials: Interrupted system call

Re: Postgresql deying access

2011-02-11 Thread Nicolas Barbier
2011/2/11 Petr Salinger : >> Setting up postgresql (8.4.7-0squeeze2) ... > >> root@netmon:~# su - postgres >> postgres@netmon:~$ psql template1 >> psql: FATAL:  Ident authentication failed for user "postgres" > > This command works for me on kfreebsd-i386 > with both 8.4.5-0squeeze2 and 8.4.7-0squ

Re: Postgresql deying access

2011-02-11 Thread Nicolas Barbier
2011/2/10 Emanuele Balla : > postgres@netmon:~$ psql template1 > psql: FATAL:  Ident authentication failed for user "postgres" * What does the PostgreSQL log say? * Does it work when you install an identd? (That shouldn't be required when connecting using UNIX sockets, but it may be help diagnose

Re: Postgresql deying access

2011-02-11 Thread Emanuele Balla
On 2/11/11 11:35 AM, Petr Salinger wrote: > >> Setting up postgresql (8.4.7-0squeeze2) ... > >> root@netmon:~# su - postgres >> postgres@netmon:~$ psql template1 >> psql: FATAL: Ident authentication failed for user "postgres" > > This command works for me on kfreebsd-i386 > with both 8.4.5-0squ

Re: Postgresql deying access

2011-02-11 Thread Petr Salinger
Setting up postgresql (8.4.7-0squeeze2) ... root@netmon:~# su - postgres postgres@netmon:~$ psql template1 psql: FATAL: Ident authentication failed for user "postgres" This command works for me on kfreebsd-i386 with both 8.4.5-0squeeze2 and 8.4.7-0squeeze2 postgresql version. $ uname -srv

Postgresql deying access

2011-02-10 Thread Emanuele Balla
Hi, I just installed a test machine where I expect to run (also) postgresql. After installing the package, I'm unable to access as postgresql user: [...] Starting PostgreSQL 8.4 database server: main. Setting up postgresql (8.4.7-0squeeze2) ... Setting up postgresql-client (8.4.7-0squeeze2) ... r