Skip to content
Advertisement

Install OwnCloud with PostgreSQL – Not Authenticating on Ubuntu 12.04LTS

Okay all I have tried to follow the instructions online for getting Postgresql to work with OwnCloud install but it still gives me the dreaded “PostgreSQL username and/or password not valid You need to enter either an existing account or the administrator.”

I have installed:

  • Ubuntu 12.04LTS
  • Apache 2.2
  • PHP 5.3
  • PostgreSql 9.3
  • OwnCloud 6.0.3

My web server is hosted on an internal server at 192.168.1.11 and I have Postgresql running on port 3145.

Any tips on getting this to work with Postgresql… Here is my config.php file:

$CONFIG = array (
  'instanceid' => 'oc57c67b8ac3',
  'passwordsalt' => '07b04cab4ff3d074dc59fc3ef82650',
  'trusted_domains' =>
  array (
    0 => 'www.example.com',
  ),
  'datadirectory' => '/Cloud/owncloud/data',
  'dbtype' => 'pgsql',
  'version' => '6.0.3.1',
  'dbname' => 'owncloud',
  'dbuser' => 'cloudadm',
  'dbpassword' => 'mypassword',
  'dbhost' => '192.168.1.11:3145',
  'dbtableprefix' => 'oc_',
);

Advertisement

Answer

Per @RandolphCarter — when I upgraded to OwnCloud7.0 I was able to use the wizard, select the PostgreSQL option and enter [serverip]:[Postgresql port number] – e.g. — 192.1.1.1:1118 and it worked with no problems. This is closed.

User contributions licensed under: CC BY-SA
2 People found this is helpful
Advertisement