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

[owncloud_mailing_list at status.e4ward.com]

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/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
>> 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
>