Going through install.php process, wrong database password provides no useful feedback #5121

New issue

Open

opened 2026-02-20 16:29:58 -05:00 by deekerman · 0 comments

deekerman commented

2026-02-20 16:29:58 -05:00

Owner

Originally created by @NucleaPeon on GitHub (Oct 25, 2023).

Issue

I was going through https://docs.suitecrm.com/admin/installation-guide/downloading-installing/ to install SuiteCRM. All things considered, a pretty straightforward process (thank you). I got to the configuration page where you enter details.
When I went through the mysql_secure_installation process, I didn't set the root password. (I assume this issue would apply to a wrong db root password, but haven't verified that.)
When I filled in the db user (root user) password going through the installation wizard, I used what I thought I had set it to. When clicking the Next button, I'd get a message along the lines of Preparing DB in a modal that flashes on the page for less than a second and ... nothing.

I later went through mysql_secure_installation and set things up properly and the wizard continued.

Expected Behavior

If a bad password is supplied to the mysql / mariadb user or root password is not set, a prompt should be displayed that should recommend checking database credentials. If needed, db user should attempt to login to the database given credentials to ensure it works and return attempt success or failure.

The issue being a lack of feedback when the form is incorrect.

Actual Behavior

In the logs, it gives the messages:

Begin: DB Check Process ******************
testing with mysql:mysqli
Basic form info is valid, continuing Process.
Testing user account...

Modal pops up for a split second with a progress bar.

Possible Fix

Do a connection to root mysql / mariadb account and return if things work. Maybe a select 1; query or something brief and minimal. If false, show a modal with db message and a confirm button so user knows the potential problem area

Steps to Reproduce

Set up Debian 12 vm
Install dependencies
Run mysql_secure_installation but when prompted for changing root password choose "N"
Extract SuiteCRM 7.14.1 to /var/www/html/SuiteCRM-7.14.1/
Set permissions
Go through wizard (install.php)

Context

Without a clear message in the logs or information on the database, I spent some time reading the page and it clicked that maybe my db connection wasn't working correctly as DB was mentioned in the progress bar prompt that flickered on. Tried logging in as root to mariadb and it failed, so I fixed that up and install process worked as expected.

Your Environment

OS: Debian 12
SuiteCRM version: 7.14.1 new installation
Php 8.2
Default browser, firefox 115.3.0esr

Originally created by @NucleaPeon on GitHub (Oct 25, 2023). #### Issue I was going through https://docs.suitecrm.com/admin/installation-guide/downloading-installing/ to install SuiteCRM. All things considered, a pretty straightforward process (thank you). I got to the configuration page where you enter details. When I went through the ``mysql_secure_installation`` process, I didn't set the root password. (I assume this issue would apply to a wrong db root password, but haven't verified that.) When I filled in the db user (root user) password going through the installation wizard, I used what I thought I had set it to. When clicking the Next button, I'd get a message along the lines of ``Preparing DB`` in a modal that flashes on the page for less than a second and ... nothing. I later went through ``mysql_secure_installation`` and set things up properly and the wizard continued. #### Expected Behavior If a bad password is supplied to the mysql / mariadb user or root password is not set, a prompt should be displayed that should recommend checking database credentials. If needed, db user should attempt to login to the database given credentials to ensure it works and return attempt success or failure. The issue being a lack of feedback when the form is incorrect. #### Actual Behavior In the logs, it gives the messages: ``` Begin: DB Check Process ****************** testing with mysql:mysqli Basic form info is valid, continuing Process. Testing user account... ``` Modal pops up for a split second with a progress bar. #### Possible Fix Do a connection to root mysql / mariadb account and return if things work. Maybe a ``select 1;`` query or something brief and minimal. If false, show a modal with db message and a confirm button so user knows the potential problem area #### Steps to Reproduce 1. Set up Debian 12 vm 2. Install dependencies 3. Run mysql_secure_installation but when prompted for changing root password choose "N" 4. Extract SuiteCRM 7.14.1 to /var/www/html/SuiteCRM-7.14.1/ 5. Set permissions 6. Go through wizard (install.php) #### Context Without a clear message in the logs or information on the database, I spent some time reading the page and it clicked that maybe my db connection wasn't working correctly as DB was mentioned in the progress bar prompt that flickered on. Tried logging in as root to mariadb and it failed, so I fixed that up and install process worked as expected. #### Your Environment * OS: Debian 12 * SuiteCRM version: 7.14.1 new installation * Php 8.2 * Default browser, firefox 115.3.0esr