On Sun, May 27, 2007 at 10:12:33AM +0200, csanyipal wrote: > On Sat, May 26, 2007 at 06:07:32PM -0400, Roberto C. Sánchez wrote: > > > > > Log in to postgres and execute this: > > > > > > > > SELECT * FROM pg_user; > > > > > > > > Paste the results. > > > > > > csanyipal@csanyi-pal:~$ su > > > Password: > > > csanyi-pal:/home/csanyipal# su - postgres > > > postgres@csanyi-pal:~$ SELECT * FROM pg_user; > > > -su: SELECT: command not found > > > > > After 'su - postgres', do this: > > > > postgres@csanyi-pal:~$ psql -d template1 > > > > After that you get a psql prompt. That is where you execute the SELECT > > statement. > > template1=# SELECT * FROM pg_user; > usename | usesysid | usecreatedb | usesuper | usecatupd | passwd | valuntil | useconfig > --------------+----------+-------------+----------+-----------+----------+----------+----------- > postgres | 1 | t | t | t | ******** | | > phpgroupware | 2 | f | f | f | ******** | | > csanyipal | 100 | f | f | f | ******** | | > (3 sor) > > (3 sor) that is (3 raw) > So, there is no www-data user. Either tutos2 needs to create it or you need to create it. Remember, postgres doesn't know anything about your operating system users by default. Regards, -Roberto -- Roberto C. Sánchez http://people.connexer.com/~roberto http://www.connexer.com
Attachment:
signature.asc
Description: Digital signature