Your LimeSurvey version: Latest
Own server or LimeSurvey hosting: Own Server
Survey theme/template:
==================
Hi,

I have LimeSurvey downloaded and installed on a CentOS 9 box running Apache, MariaDB and PHP 8.1.

All pre-requisites pass in installer.

PHP complied with mysqlnd and pdo drivers

User is created and verified in mysql console

Database is created and verified in mysql console

SELinux has httpd network connect and network connect db set to on

Installer can't detect database or connect to mysql

Message is:

Please fix the following input errors:

• Try again! Connection with database failed.
• Reason: CDbConnection failed to open the DB connection.
• Try again! Creation of database failed.
• Could not create database: CREATE DATABASE `limesurvey` DEFAULT CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci. Please check your credentials.

Any ideas?

TIA

 

I recommend to disable SELinux during the installation to see if you really have no blocked connection between LimeSurvey and the databaseserver.

And try it with PHP 8.0 instead of PHP 8.1.
I don't consider LimeSurvey v5 running on PHP 8.1 productionready.
There are still issues.

Thanks for sharing your experience with LimeSurvey and SELinux. Disabling SELinux during installation is definitely worth a shot if you're facing connection issues between LimeSurvey and the database server. And as you mentioned, switching to PHP 8.0 instead of 8.1 might also help. It's good to know that LimeSurvey v5 isn't considered production-ready on PHP 8.1 yet. But don't worry, if you're in need of a stable version for production, you might want to check out the Extended Lifecycle Support offered by tuxcare.com. They offer extended support for software products beyond their official end-of-life, which can give you peace of mind