UVdesk

    • Register
    • Login
    • Search
    • Recent

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

    Technical Help
    3
    4
    44
    Loading More Posts
    • Oldest to Newest
    • Newest to Oldest
    • Most Votes
    Reply
    • Reply as topic
    Log in to reply
    This topic has been deleted. Only users with topic management privileges can see it.
    • M
      MikeJ last edited by

      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.

      1 Reply Last reply Reply Quote 0
      • blckhwk
        blckhwk last edited by 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?

        M 1 Reply Last reply Reply Quote 0
        • M
          MikeJ @blckhwk last edited by

          @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.

          1 Reply Last reply Reply Quote 0
          • Komal Sharma
            Komal Sharma UVdesk Staff last edited by

            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         
            

            69da7994-d486-4b40-a57f-fdcdfcf92b90-dev.log-file.png

            1 Reply Last reply Reply Quote 0
            • First post
              Last post