Recommended settings for config.php

🚧 Installation
1

Please delete everything above when creating your topic and provide the following:

Nextcloud version (eg, 13.0.1):
Operating system and version (Mageia 6 x86_64):
Apache or nginx version (Apache 2.4.27):
PHP version (5.6.35):

The issue you are facing:
Manual installation. What are the recommended initial settings for dbuser (and dbpassword) on initial creation of config.php? If I use “apache”, I get “exception ‘Doctrine\DBAL\DBALException’ with message 'Failed to connect to the database”,
but if I use ‘root’, I get
"Uncaught exception ‘Doctrine\DBAL\DBALException’ with message ‘Failed to connect to the database: An exception occured in driver: SQLSTATE[08006] [7] FAT
AL:  role “root” does not exist’ in /var/www/nextcloud/lib/private/DB/Connection.php:64"
systemctl status postgresql.service shows postgresql IS running

Is this the first time you’ve seen this error? (Y):Y

Steps to replicate it:

The output of your config.php file in /path/to/nextcloud (make sure you remove any identifiable information!):

<?php
$CONFIG = array (
  'instanceid' => 'ociyv3cyh8ul',
  'passwordsalt' => '',
  'trusted_domains' => 
  array (
    0 => 'localhost',
    1 => 'share.gemmill.name',
    2 => '192.168.1.9',
  ),
  'datadirectory' => '/mnt/raid/nextcloud/data',
  'version' => '13.0.1',
  'dbtype' => 'pgsql',
  'dbhost' => '192.168.1.9',
  'dbname' => 'nextcloud',
  'dbuser' => 'root',
  'dbpassword' => '****',
  'dbtableprefix' => 'oc_',
  'installed' => true,
  'knowledgebaseenabled' => true,
  'mail_domain' => 'gemmill.name',
  'mail_smtpmode' => 'smtp',
  'mail_from_address' => 'nextcloud',
  'overwrite.cli.url' => 'https://share.gemmill.name/nextcloud',
  'htaccess.RewriteBase' => '/nextcloud',
  'logtimezone' => 'UTC',
  'preview_libreoffice_path' => '/usr/bin/libreoffice',
  'supportedDatabases' => array(
	'pgsql',
),
  'updater.release.channel' => 'stable',
  'secret' => '************',
  'updater.secret' => '***************',
  'maintenance' => true,
  'theme' => '',
);

The output of your Apache/nginx/system log in /var/log/____:

[Wed Apr 04 15:58:40.587493 2018] [:error] [pid 22240] [client 192.168.1.9:43968] PHP Fatal error:  Uncaught exception 'Doctrine\\DBAL\\DBALException' with message 'Failed to connect to the database: An exception occured in driver: SQLSTATE[08006] [7] FATAL:  role "root" does not exist' in /var/www/nextcloud/lib/private/DB/Connection.php:64\nStack trace:\n#0 /var/www/nextcloud/3rdparty/doctrine/dbal/lib/Doctrine/DBAL/Connection.php(429): OC\\DB\\Connection->connect()\n#1 /var/www/nextcloud/3rdparty/doctrine/dbal/lib/Doctrine/DBAL/Connection.php(389): Doctrine\\DBAL\\Connection->getDatabasePlatformVersion()\n#2 /var/www/nextcloud/3rdparty/doctrine/dbal/lib/Doctrine/DBAL/Connection.php(328): Doctrine\\DBAL\\Connection->detectDatabasePlatform()\n#3 /var/www/nextcloud/3rdparty/doctrine/dbal/lib/Doctrine/DBAL/Connection.php(623): Doctrine\\DBAL\\Connection->getDatabasePlatform()\n#4 /var/www/nextcloud/lib/private/DB/Connection.php(151): Doctrine\\DBAL\\Connection->setTransactionIsolation(2)\n#5 /var/www/nextcloud/3rdparty/doctrine/dbal/lib/Doctrine/DBAL/DriverManager.php(172): OC\\DB\\Connection->__construct(Array, Object(Doctrine\\D in /var/www/nextcloud/lib/private/DB/Connection.php on line 64
2

= 08006

connection failure

Check your Postgresql settings :wink: