Wait... I'm sorry I'm slow but isn't that the same as just having a password that's just a jumble of letters and numbers?
Kyle On 06/28/2013 08:44 PM, Derek Broes wrote: > 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
