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, [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 _______________________________________________ Owncloud mailing list [email protected] https://mail.kde.org/mailman/listinfo/owncloud
