Yes, whatever database name and user name the database is expecting but do not have the "MyFancyPassword" in plain text. Create the password as "MyFancyPassword" in the database but convert to MD5 at the database. Copy that md5 converted password from the database and paste into the config file, replacing the plain text version of the password. So, you will only have a MD5 hash in the config file and in the database created from the plaintext of "MYFancyPassword" or whatever you choose to use.
-----Original Message----- From: [email protected] [mailto:[email protected]] On Behalf Of [email protected] Sent: Friday, June 28, 2013 5:27 PM To: [email protected] Subject: Re: [Owncloud] Setup Owncloud to use Already-Existing Postgresql Database Derek, Thanks for the information! To clarify: Are you saying to leave my config file as-is, but create the user with: postgres=# CREATE USER owncloud WITH PASSWORD md5('MyFancyPassword'); ? On 06/28/2013 08:11 PM, Derek Broes wrote: > I had the same issue before. I recreated my password with md5hash in > the database and used that in the config file. Bingo, all works. > > > -----Original Message----- > From: [email protected] [mailto:[email protected]] On > Behalf Of [email protected] > Sent: Friday, June 28, 2013 3:42 PM > To: [email protected] > Subject: [Owncloud] Setup Owncloud to use Already-Existing Postgresql > Database > > Hello all. > > I'm restoring my server, and trying to get owncloud to use my > backed-up postgresql database. I have the database created following this: > http://doc.owncloud.org/server/5.0/admin_manual/configuration/configur > ation_ database.html , and it has all my old data. The config file > looks like this: > > <?php > $CONFIG = array ( > 'instanceid' => '212e71e403343', > 'passwordsalt' => 'c8f5c73ae621e6373a75a580f305b2', > 'datadirectory' => '/media/data/owncloud/data', > 'dbtype' => 'pgsql', > 'dbname' => 'owncloud_database', > 'dbhost' => 'localhost', > 'dbtableprefix' => 'oc_', > 'dbuser' => 'owncloud', > 'dbpassword' => 'MyFancyPassword', > 'installed' => true, > 'maxZipInputSize' => 0, > 'allowZipDownload' => true, > ); > > 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".' > > What's going on here? Any ideas? > _______________________________________________ > Owncloud mailing list > [email protected] > https://mail.kde.org/mailman/listinfo/owncloud > _______________________________________________ Owncloud mailing list [email protected] https://mail.kde.org/mailman/listinfo/owncloud _______________________________________________ Owncloud mailing list [email protected] https://mail.kde.org/mailman/listinfo/owncloud
