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.".
- 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
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?
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:
Options Indexes FollowSymLinks
Require all granted
No Change: My .env file with UVDesk was already set to APP_ENV=dev
I appreciate any and all assistance sent my way. Thank you for reading through my post. I hope you have a most wonderful day.