[Owncloud] [spam?] Re: [spam?] Setup Owncloud to use Already-Existing Postgresql Database

[alen vodopijevec]

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, owncloud_mailing_list at status.e4ward.com 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, owncloud_mailing_list at status.e4ward.com 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
>> Owncloud at kde.org
>> https://mail.kde.org/mailman/listinfo/owncloud
> _______________________________________________
> Owncloud mailing list
> Owncloud at kde.org
> 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 -----------------------------
>