[Owncloud] Setup Owncloud to use Already-Existing Postgresql Database

[Derek Broes]

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: owncloud-bounces at kde.org [mailto:owncloud-bounces at kde.org] On Behalf
Of owncloud_mailing_list at status.e4ward.com
Sent: Friday, June 28, 2013 5:50 PM
To: owncloud at kde.org
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: owncloud-bounces at kde.org [mailto:owncloud-bounces at kde.org] On 
> Behalf Of owncloud_mailing_list at status.e4ward.com
> Sent: Friday, June 28, 2013 5:27 PM
> To: owncloud at kde.org
> 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: owncloud-bounces at kde.org [mailto:owncloud-bounces at kde.org] On 
>> Behalf Of owncloud_mailing_list at status.e4ward.com
>> Sent: Friday, June 28, 2013 3:42 PM
>> To: owncloud at kde.org
>> 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
>> 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
>

_______________________________________________
Owncloud mailing list
Owncloud at kde.org
https://mail.kde.org/mailman/listinfo/owncloud