ForestRacks / PteroInstaller

Pterodactyl Panel installer for ForestRacks customers with full automation.
https://forestracks.com
GNU General Public License v3.0
32 stars 11 forks source link

MySQL connection fails #4

Closed devosm closed 7 months ago

devosm commented 7 months ago

Have tried multiple times to use this installer (each time rolling back to a snapshot before running the installer, as well as a complete reinstall of the VM)

Yet I keep running into this error

 [ERROR] Unable to connect to the MySQL server using the provided credentials. The    
         error returned was "SQLSTATE[HY000] [2054] Server sent charset (0) unknown to
         the client. Please, report to the developers".                               

 [ERROR] Your connection credentials have NOT been saved. You will need to provide    
         valid connection information before proceeding.   

Any idea what's causing this?

This is what is shown right before the error hits

 INFO  Application key set successfully.  

* Downloaded pterodactyl panel files & installed composer dependencies!
* Performing MySQL queries..
* Creating MySQL user..
* Creating database..
* Granting privileges..
* Flushing privileges..
* MySQL database created & configured!

 // Provide the email address that eggs exported by this Panel should be from. This   
 // should be a valid email address.                                                  

 // The application URL MUST begin with https:// or http:// depending on if you are   
 // using SSL or not. If you do not include the scheme your emails and other content  
 // will link to the wrong location.                                                  

 // The timezone should match one of PHP's supported timezones. If you are unsure,    
 // please reference https://php.net/manual/en/timezones.php.                         

 // Please reference https://pterodactyl.io/panel/1.0/additional_configuration.html#telemetry for more detailed information regarding telemetry data and
 // collection.                                                                       

 ! [NOTE] You've selected the Redis driver for one or more options, please provide    
 !        valid connection information below. In most cases you can use the defaults  
 !        provided unless you have modified your setup.                               

 // By default a Redis server instance has no password as it is running locally and   
 // inaccessible to the outside world. If this is the case, simply hit enter without  
 // entering a value.                                                                 

 ! [NOTE] It is highly recommended to not use "localhost" as your database host as we 
 !        have seen frequent socket connection issues. If you want to use a local     
 !        connection you should be using "127.0.0.1".                                 

 ! [NOTE] Using the "root" account for MySQL connections is not only highly frowned   
 !        upon, it is also not allowed by this application. You'll need to have       
 !        created a MySQL user for this software.  
Zinidia commented 7 months ago

Hi, MariaDB had an update that removed certain types of usage from the mysql command. I'm aware of this issue and will fix our installer as soon as possible.

Zinidia commented 7 months ago

Thanks for your patience, this issue is now fixed.