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

[Derek Broes]

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