Bug 27989 - Nextcloud 21 beta3 installation wizard fails with Mariadb error
Summary: Nextcloud 21 beta3 installation wizard fails with Mariadb error
Status: RESOLVED DUPLICATE of bug 27784
Alias: None
Product: Mageia
Classification: Unclassified
Component: RPM Packages (show other bugs)
Version: 8
Hardware: x86_64 Linux
Priority: Normal major
Target Milestone: ---
Assignee: Joseph Wang
QA Contact:
URL: http://pix.toile-libre.org/?img=16092...
Whiteboard:
Keywords:
Depends on:
Blocks:
 
Reported: 2020-12-30 10:52 CET by christian barranco
Modified: 2020-12-31 02:42 CET (History)
1 user (show)

See Also:
Source RPM: mariadb-10.5.8-1.mga8.src.rpm or php-pdo_mysql-8.0.0-2.mga8 or ?
CVE:
Status comment:


Attachments

Description christian barranco 2020-12-30 10:52:06 CET
Description of problem:
Cannot complete NC21 beta3 installation with NGINX, PHP-FPM and Mariadb.
I succeed to reach the NC21 installation wizard page and, after entering required information to create admin user and to connect to the MySQL database, the following error is displayed : "Error while trying to initialise the database: There is no active transaction"
NC21 beta3 works with similar NGINX and PHP-FPM (7.3) installation on Mageia 7.

Version-Release number of selected component (if applicable):
Latest components provided with Mageia8 for NGINX, PHP-FPM and Mariadb
NEXTCLOUD component from nextcloud.com site (NC21 beta3)

How reproducible:always after following the below steps


Steps to Reproduce:
1.Install NGINX/1.18.0 by urpmi nginx
2.Install PHP-FPM, PHP 8.0.0 version, by urpmi php php php-apcu php-bcmath php-bz2 php-ctype php-cgi php-cli php-curl php-dom php-exif php-fileinfo php-fpm php-gd php-iconv php-imagick php-intl php-json php-ldap php-mbstring php-mysql php-opcache php-openssl php-pcntl php-pdo_mysql php-posix php-session php-tokenizer php-xml php-xmlreader php-xmlwriter php-zip php-zlib
3.Enable and start NGINX and PHP-FPM services
3.Modify /etc/nginx/conf.d/default.conf to listen to a socket, like PHP-FPM, and to interpret PHP scripts.
4.Create a script info.php to call phpinfo() command
5.At this stage, browsing localhost will reach the NGINX/Mageia welcome page and, browsing localhost/info.php will reach the phpinfo html page
6.NGINX and PHP-FPM configuration adjustment for NEXTCLOUD by modifying /etc/nginx/nginx.conf, /etc/php-fpm.d/www.conf, /etc/php.ini, /etc/php.d/05_date.ini, /etc/php.d/99_opcache.ini
7.MariaDB/MySQL 15.1 installation by urpmi mariadb
8.MariaDB initial setup by enabling and starting mysql service and by running mysql_secure_installation
9.Create database by running mysql -uroot -p and then : CREATE DATABASE nextcloud CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci; CREATE USER admin@localhost IDENTIFIED BY 'mot-de-passe-nc'; GRANT ALL PRIVILEGES on nextcloud.* to admin@localhost; FLUSH privileges; quit;
10.Create NGINX host configuration file for NEXTCLOUD per nextcloud admin documentation : /etc/nginx/conf.d/nextcloud
11.Download https://download.nextcloud.com/server/prereleases/nextcloud-21.0.0beta3.zip
12.Unzip and copy the nextcloud folder in /var/www
13.chown -R apache:apache /var/www/nextcloud
14.Create folder /data/ncdata owned by apache:apache to host MySQL database
15.Restart nginx, php-fpm, mariadb services
15.Browse localhost/nextcloud
16.Nextcloud installation wizard page is displayed.
17.Enter required information to create admin user + connect to the MySQL database
18.Click on Complete Installation
19.Following error is displayed : "Error while trying to initialise the database: There is no active transaction"
David Walser 2020-12-30 11:49:55 CET

Assignee: bugsquad => joequant

Comment 1 christian barranco 2020-12-30 15:38:48 CET
Update:
I just tested NC21 beta3 with Mageia8 beta2, using PostgreSQL instead of MariaDB and, it works!
Looks like then the issue is around MariaDB itself or its management by NC21.
Comment 2 Morgan Leijström 2020-12-31 02:42:16 CET
Thank you for the detailed steps :)

And the testing.

Not working with MariaDB seem to be a duplicate of 27784.

*** This bug has been marked as a duplicate of bug 27784 ***

Resolution: (none) => DUPLICATE
Status: NEW => RESOLVED
CC: (none) => fri


Note You need to log in before you can comment on or make changes to this bug.