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

[owncloud_mailing_list at status.e4ward.com]

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