Hi,
Installing Nextcloud 10.0.1 on PostgreSQL there is an error in the PG
syntax. I had to remove the âCREATEDBâ and late execute this command
manually via the pgsql command line:
alter role oc_fraber with password âxxxâ;
grant ALL ON schema public to oc_fraber;
grant CONNECT ON DATABASE nextcloud TO oc_fraber;
Please include this in the installerâŚ
Cheers,
Frank
Founder: http://www.project-open.com/
Twitter: @projop
/var/www/nextcloud/lib/private/Setup
[root@kassel2 Setup]# diff -w PostgreSQL.php PostgreSQL.php~
146c146
< $query = $connection->prepare(âALTER ROLE " . addslashes($this->dbUser) . " WITH PASSWORD 'â . addslashes($this->dbPassword) . â'â);
$query = $connection->prepare("ALTER ROLE " . addslashes($this->dbUser) . " CREATEDB WITH PASSWORD '" . addslashes($this->dbPassword) . "'");
149c149
< $query = $connection->prepare(âCREATE USER " . addslashes($this->dbUser) . " WITH PASSWORD 'â . addslashes($this->dbPassword) . â'â);
$query = $connection->prepare("CREATE USER " . addslashes($this->dbUser) . " CREATEDB PASSWORD '" . addslashes($this->dbPassword) . "'");