Установить owncloud в Ubuntu 18

Окружение

• Ubuntu 18.04

Квалификация

• Сервис инженер

Последовательность действий

 curl https://download.owncloud.org/download/repositories/10.0/Ubuntu_18.04/Release.key | sudo apt-key add -
 echo ‘deb http://download.owncloud.org/download/repositories/10.0/Ubuntu_18.04/ /’ | sudo tee /etc/apt/sources.list.d/owncloud.list
 apt -y update
 apt-get -y install apache2
 ufw allow in "Apache Full"
 apt-get -y install php-bz2 php-curl php-gd php-imagick php-intl php-mbstring php-xml php-zip owncloud-files
 apt-get -y install php libapache2-mod-php
 vi /etc/apache2/sites-enabled/000-default.conf
 DocumentRoot /var/www/owncloud
 systemctl restart apache2
 chown -R www-data:www-data /var/www/owncloud/
 mkdir -p /var/owncloud/data
 chown -R www-data /var/owncloud/data
 apt-get -y install postgresql libpq5 libpq-dev
 su postgres
 psql
 CREATE ROLE owncloud ;
 ALTER ROLE owncloud WITH PASSWORD 'myPassword' ;
 ALTER ROLE owncloud WITH LOGIN ;
 CREATE DATABASE owncloud ;
 ALTER DATABASE owncloud OWNER TO owncloud ;
 \q
 

Отредактировать файл

 vi /var/www/owncloud/lib/composer/doctrine/dbal/lib/Doctrine/DBAL/Schema/PostgreSqlSchemaManager.php

Найти и закоментировать

 $data = $this->_conn->fetchAll('SELECT min_value, increment_by FROM ' . $this->_platform->quoteIdentifier($sequenceName));

Вставить

 $version = floatval($this->_conn->getWrappedConnection()->getServerVersion());

   if ($version >= 10) {
      $data = $this->_conn->fetchAll('SELECT min_value, increment_by FROM pg_sequences WHERE schemaname = \'public\' AND sequencename = '.$this->_conn->quote($sequenceName));
   }
   else
   {
       $data = $this->_conn->fetchAll('SELECT min_value, increment_by FROM ' . $this->_platform->quoteIdentifier($sequenceName));
   }