- Posts: 1
- Thank you received: 0
Welcome to the LimeSurvey Community Forum
Ask the community, share ideas, and connect with other LimeSurvey users!
CentOS 9 - MySQL Database can't connect or create database
- BaffledTrout
- Topic Author
- Offline
- New Member
Less
More
1 year 9 months ago #230513
by BaffledTrout
CentOS 9 - MySQL Database can't connect or create database was created by BaffledTrout
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:
Any ideas?
TIA
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
Attachments:
Please Log in to join the conversation.
- jelo
- Offline
- Platinum Member
Less
More
- Posts: 5033
- Thank you received: 1257
1 year 9 months ago #230552
by jelo
The meaning of the word "stable" for users
www.limesurvey.org/forum/development/117...ord-stable-for-users
Replied by jelo on topic CentOS 9 - MySQL Database can't connect or create database
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.
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.
The meaning of the word "stable" for users
www.limesurvey.org/forum/development/117...ord-stable-for-users
Please Log in to join the conversation.
- JacNunez
- Offline
- New Member
Less
More
- Posts: 1
- Thank you received: 0
1 year 2 months ago - 1 year 2 months ago #240173
by JacNunez
Replied by JacNunez on topic CentOS 9 - MySQL Database can't connect or create database
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
Last edit: 1 year 2 months ago by holch.
Please Log in to join the conversation.