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

[owncloud_mailing_list at status.e4ward.com]

Also, I wasn't specific on how I created the owncloud database user-- I followed http://doc.owncloud.org/server/5.0/admin_manual/configuration/configuration_database.html pretty exactly:

CREATE USER owncloud WITH PASSWORD 'MyFancyPassword';
CREATE DATABASE owncloud_database TEMPLATE template0 ENCODING 'UNICODE';
ALTER DATABASE owncloud_database OWNER TO owncloud;
GRANT ALL PRIVILEGES ON DATABASE owncloud_database TO owncloud;

On 06/29/2013 04:03 PM, alen vodopijevec wrote:
> 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 -----------------------------
>>
>
> _______________________________________________
> Owncloud mailing list
> Owncloud at kde.org
> https://mail.kde.org/mailman/listinfo/owncloud