Installation fails because connection string may not be right

🚧 Installation
, ,
1

Hi Everyone,

I am trying to get Nextcloud up and running on Microsoft Azure by following the installation guide on Installation on Linux — Nextcloud 13 Administration Manual 13 documentation.

Special situation: I want the database to be outside of my webserver and to be a Microsoft Azure Managed MySQL instance. This worked fine for me in many other projects. It usually works like any other personal setup mysql database.

I have set up

  • an Ubuntu 16.04.5 LTS as OS
  • Apache2 as Webserver
  • Installed packages are:
    • apache2
    • libapache2-mod-php7.0
    • php7.0-gd
    • php7.0-json
    • php7.0-mysql
    • php7.0-curl
    • php7.0-mbstring
    • php7.0-intl
    • php7.0-mcrypt
    • php-imagick
    • php7.0-xml
    • php7.0-zip
  • Apache config in /etc/apache2/sites-available/nextcloud.conf looks like:
Alias /nextcloud "/var/www/nextcloud/"

<Directory /var/www/nextcloud/>
  Options +FollowSymlinks
  AllowOverride All

 <IfModule mod_dav.c>
  Dav off
 </IfModule>

 Satisfy Any

 SetEnv HOME /var/www/nextcloud
 SetEnv HTTP_HOME /var/www/nextcloud

</Directory>
  • Syslink is created with
sudo ln -s /etc/apache2/sites-available/nextcloud.conf /etc/apache2/sites-enabled/nextcloud.conf
  • Apache is configed like:
sudo a2enmod rewrite
sudo a2enmod headers
sudo a2enmod env
sudo a2enmod dir
sudo a2enmod mime

sudo service apache2 restart

sudo a2enmod ssl
sudo a2ensite default-ssl
sudo service apache2 reload
  • Nextcloud was installed with
wget https://download.nextcloud.com/server/releases/nextcloud-13.0.5.tar.bz2
  • Extracted and copied into /var/www/nextcloud
  • Giving access rights with
sudo chown -R www-data:www-data /var/www/nextcloud/
  • Accessing the Installation Wizard and filling out the data ends in:
    image
  • I have provided the following information:
    • Administrator: <myAdminName (all lowercase letters)>
    • Administrator-password: <MyPassword (lowercase, upercase, special chars, numbers)>
    • DataDirectory : /opt/nextcloud
    • Database adminstraor: <myAdminName (all lowercase letters)>
      NOTE that Microsoft Azure depicts the username as <myAdminName>@<hostname> e.g. dbadmin@my-db
    • Password: <MyPassword (lowercase, upercase, special chars, numbers)>
    • Database: nextcloud
    • Host: <hostname (all lowercase concated with "-")>.mysql.database.azure.com:3306
  • I have disabeld SSL enforcement in the Azure MySQL databse, as this seems to have caused other issues as well
  • Connecting to MySQL database from inside the nextcloud webser with mysql -h <hostname> -u <username> -p works absolutley flawless.

Can you help me get nextcloud up and running with being connected to the Azure MySQL database?

Any thoughts on the error during the installation?

Best,
erosinger

2

Update:
It seems as if the Azure Managed MySQL database is missing permissions to perform actions during the installation. The users are created in the database which is fine:

host user
% oc_nextcloudadm1
% oc_nextcloudadm2
% oc_nextcloudadm3
% oc_nextcloudadm4
% oc_nextcloudadm5
% oc_nextcloudadm6
% oc_nextcloudadm7
% oc_nextcloudadm8
% oc_nextcloudadm9
% oc_nextcloudadmi
… …
localhost oc_nextcloudadm1
localhost oc_nextcloudadm2
localhost oc_nextcloudadm3
localhost oc_nextcloudadm4
localhost oc_nextcloudadm5
localhost oc_nextcloudadm6
localhost oc_nextcloudadm7
localhost oc_nextcloudadm8
localhost oc_nextcloudadm9
localhost oc_nextcloudadmi

But it seems they are missing privileges to do something e.g. create tables.
The nextcloud database is still empty after the failed installation.

mysql> use nextcloud;
Database changed
mysql> show tables;
Empty set (0.04 sec)

Any thoughts on how to proceed?