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

[owncloud_mailing_list at status.e4ward.com]

Huh, I figured it out. My old Owncloud install used mysql, and I was using a password with various special characters in it. That same password will not work with postgresql... I needed to change the password with something that was simply alpha-numeric. Everything is working now. Is that a postgresql limitation, a php limitation, or an Owncloud limitation?

That's probably why the "hash" hack worked. It really was just a password of letters and numbers.

Thanks guys!

Kyle Fazzari

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