You would think right? I am not deep into that specific part of owncloud and focus on the mobile app side myself but, I haven't spent any time looking into it but would assume the database is expecting hash or, the server is sending a hash of the plaintext. There is a conversion going on somewhere I would think. If it works who cares, if it doesn't I'll look into it more and figure out why it worked for me and still does. I just changed both to plain text and the database cannot be contacted. Changed them back to md5 and viola, a database. Maybe someone that like databases can answer. Not my thing at all.
-----Original Message----- From: [email protected] [mailto:[email protected]] On Behalf Of [email protected] Sent: Friday, June 28, 2013 5:50 PM To: [email protected] Subject: Re: [Owncloud] Setup Owncloud to use Already-Existing Postgresql Database 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/configu >> r 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 _______________________________________________ Owncloud mailing list [email protected] https://mail.kde.org/mailman/listinfo/owncloud
