So,

- listen_addresses=localhost is enabled
- you have created user with password
- in pg_hba.conf you have something like:
host    all             all             ::1/128 md5

Please check this "host" detail and try to connect with -h localhost switch added.

regards,
--
alen



On 29.06.2013 20:01, [email protected] wrote:
Alen,

I've tested two situations:

-----
1. local all all peer

MUST add -h localhost to connect  ccessfully.

2. local all all md5

Don't need -h localhost to connect successfully (although actually using -h in 
this scenario is untested).
-----

I get the same results in both of these situations (i.e. 'FATAL:  password authentication 
failed for user "owncloud"').

Does that answer your question?

Kyle

On 06/29/2013 12:47 AM, alen vodopijevec wrote:
On 29.06.2013 00:41, [email protected] wrote:
I have verified that the database login works with psql -d owncloud_database -U owncloud -W and 
entering the password in the config file. However, owncloud says "Failed to connect to 
database," and my postgresql log says 'FATAL:  password authentication failed for user 
"owncloud".'
Hi, can you connect from command line even if you add |"|-h localhost" switch 
to psql?

If not:
1. in postgresql.conf, uncomment
listen_addresses = 'localhost'

2. in pg_hba.conf add "md5" on the right place.

regards,
--
alen

||

_______________________________________________
Owncloud mailing list
[email protected]
https://mail.kde.org/mailman/listinfo/owncloud
_______________________________________________
Owncloud mailing list
[email protected]
https://mail.kde.org/mailman/listinfo/owncloud



----------------------------- UPOZORENJE -----------------------------

    Automatskom detekcijom utvrdjeno je da se u ovoj poruci
    pojavljuje rijec "PASSWORD" ili "LOZINKA",
    ili tekst podsjeca na tzv. phishing poruku.

    AKO SE U PORUCI TRAZI DA POSALJETE VASU IRB LOZINKU ILI
    DA UNESETE IRB PODATKE NA NAVEDENOM LINKU, RADI SE O
    NAPADU S CILJEM KRADJE I ZLOUPOTREBE PODATAKA.

  Centar za informatiku i racunarstvo,
  Institut Rudjer Boskovic

----------------------------- UPOZORENJE -----------------------------


_______________________________________________
Owncloud mailing list
[email protected]
https://mail.kde.org/mailman/listinfo/owncloud

Reply via email to