Unsolved UVDesk Installer Error: "Details are incorrect ! Connection not established."

[MikeJ]

Hello. Thank you for reviewing my post and I look forward to any assistance as I have really enjoyed the look and feel of UVDesk during the live demo.

Problem: When using the web installer, in the Database Configuration step, I specify my details for connecting to the database (MySQL) and despite trying different things, I cannot get past the error at the bottom, "Details are incorrect ! Connection not established.".

My environment:

• Windows Server 2016 (14393.5648)
• Apache 2.4.54 x64
• MySQL 8.0.32 MySQL Community Server - GPL
• PHP 7.4.33
• UVDesk - using manual zip file: uvdesk-community-v1.1.1.zip
• Browser: Chrome v111.0.5563.65

Prior Research:
I did attempt some Google-fu before making this post for assistance and unfortunately the advice provided here, https://forums.uvdesk.com/topic/2068/uvdesk-community-cannot-connect-to-database did not assist with my particular issue, which addressed disabling redis. I'm not using redis and also went a step further and commented out the code in Setup.php around line 245

My Form Entries:

• Server: 127.0.0.1 (also tried localhost)
• Port: 3306
• Username: root
• Password: Tried two different ones, last attempt using 7 character password with one uppercase, 3 numbers, and 3 lowercase letters in case prior password was too crazy.
• Database: UVDesk
• Unchecked and Checked - Automatically create database if not found?

Troubleshooting Performed:

• Success - MySQL 8 shell able to log in with root @ localhost on 3306

• Success - Used PHPMyAdmin to also log in successfully.

• Unsuccessful - Thought maybe not having a DB previously configured might be causing any issues despite the installer saying it could make it for me. Used the shell to create "UVDesk" database. Tried in the installer with the name, "UVDesk", no change.

• Unsuccessful - My root MySQL password was something pretty long.. 4-5 word passphrase, changed to just a 7 character password to test with, one uppercase, 3 numbers, rest lowercase. No special characters.

• Successful - Verified with Chrome's network tools that the information being passed is correct and matched what I typed into the form.

Unsuccessful - Apache conf updated to include Allow Override and Apache restarted:

<Directory "C:\Apache24\htdocs">
    Options Indexes FollowSymLinks
    AllowOverride All
    Require all granted
</Directory>

No Change: My .env file with UVDesk was already set to APP_ENV=dev

Closing
I appreciate any and all assistance sent my way. Thank you for reading through my post. I hope you have a most wonderful day.

[blckhwk]

@MikeJ

Please try to use the username and password that you assigned to the "UVDesk" database when you created it.

My Form Entries:

Server: 127.0.0.1 (also tried localhost)
Port: 3306
Username: root | use the username for accessing the "UVDesk" database
Password: Tried two different ones, last attempt using 7 character password with one uppercase, 3 numbers, and 3 lowercase letters in case prior password was too crazy. | use the password for accessing the "UVDesk" database
Database: UVDesk
Unchecked and Checked - Automatically create database if not found?

[MikeJ]

@blckhwk
Thank you for taking the time to reply. I tried your suggestion and am still presented with the same error message.

Here's what I did so you can review:

• Logged in with PHPMyAdmin.
• Dropped/deleted my existing database: uvdesk
• Created a new user (uvdesk), password (14 letters and 1 number), and allowed access from any host.
• Enabled the checkbox to create a DB with the same username with all privileges....SQL executed successfully.
• Confirmed 'uvdesk' DB name shows up on the left side tree.
• Confirmed 'uvdesk' user account is listed under the DB on the Privileges tab.
  Columns: Username, Host name, type, privileges
  Row 1: uvdesk, %, database-specific, all-privileges.

Opened the UVDesk installer and went back to the same form and entered the following:

• Server: 127.0.0.1
• Port: 3306
• Username: uvdesk
• Password: (15 character alphanumeric password entered, no special chars used)
• Database: uvdesk
• Tried with and without the checkbox to: Automatically create database if not found?

Still receive error: Details are incorrect ! Connection not established.

[Komal Sharma]

Still receive error: Details are incorrect ! Connection not established.

Can you please share your log file from your project. Please follow the below path for log file:

your-project-folder-name/var/log/dev.log