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

[Derek Broes]

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