MikZ 5 Posted May 8, 2020 Good day! I recently transfer my VPS to other hosting sites. And upon changing the IP address in my Fluxcp everything works fine except account creation. It say Uh oh, what happened? Did some googling and I end up getting these errors. [2020-05-09 01:57:11] (PDOException) Exception PDOException: SQLSTATE[HY000] [2002] Connection timed out [2020-05-09 01:57:11] (PDOException) **TRACE** #0 /homepages/19/d739599868/htdocs/LibRO/lib/Flux/Connection.php(81): PDO->__construct('mysql:host=192....', 'Test', 'TestPass*', Array) [2020-05-09 01:57:11] (PDOException) **TRACE** #1 /homepages/19/d739599868/htdocs/LibRO/lib/Flux/Connection.php(94): Flux_Connection->connect(Object(Flux_Config)) [2020-05-09 01:57:11] (PDOException) **TRACE** #2 /homepages/19/d739599868/htdocs/LibRO/lib/Flux/Connection.php(159): Flux_Connection->getConnection() [2020-05-09 01:57:11] (PDOException) **TRACE** #3 /homepages/19/d739599868/htdocs/LibRO/lib/Flux/LoginServer.php(179): Flux_Connection->getStatement('SELECT userid F...') [2020-05-09 01:57:11] (PDOException) **TRACE** #4 /homepages/19/d739599868/htdocs/LibRO/modules/account/create.php(32): Flux_LoginServer->register('test0000', 'TestPass01', 'TestPass01', '[email protected]...', 'M', '2020-05-09', 'uVEIp') [2020-05-09 01:57:11] (PDOException) **TRACE** #5 /homepages/19/d739599868/htdocs/LibRO/lib/Flux/Template.php(375): include('/homepages/19/d...') [2020-05-09 01:57:11] (PDOException) **TRACE** #6 /homepages/19/d739599868/htdocs/LibRO/lib/Flux/Dispatcher.php(170): Flux_Template->render() [2020-05-09 01:57:11] (PDOException) **TRACE** #7 /homepages/19/d739599868/htdocs/LibRO/index.php(173): Flux_Dispatcher->dispatch(Array) [2020-05-09 01:57:11] (PDOException) **TRACE** #8 {main} [2020-05-09 01:57:15] (PDOException) Exception PDOException: SQLSTATE[HY000] [2002] Connection timed out [2020-05-09 01:57:15] (PDOException) **TRACE** #0 /homepages/19/d739599868/htdocs/LibRO/lib/Flux/Template.php(375): include() [2020-05-09 01:57:15] (PDOException) **TRACE** #1 /homepages/19/d739599868/htdocs/LibRO/lib/Flux/Dispatcher.php(170): Flux_Template->render() [2020-05-09 01:57:15] (PDOException) **TRACE** #2 /homepages/19/d739599868/htdocs/LibRO/index.php(173): Flux_Dispatcher->dispatch(Array) [2020-05-09 01:57:15] (PDOException) **TRACE** #3 {main} What does these errors means? Quote Share this post Link to post Share on other sites
0 meko 170 Posted May 8, 2020 From the error it appears that FluxCP is trying to connect to your mysql server but fails to reach it and the connection times out. You may have forgotten to update the DbConfig.Hostname when you moved to your new host Quote Share this post Link to post Share on other sites
0 MikZ 5 Posted May 9, 2020 4 hours ago, meko said: From the error it appears that FluxCP is trying to connect to your mysql server but fails to reach it and the connection times out. You may have forgotten to update the DbConfig.Hostname when you moved to your new host Hi @meko, Already did that. <?php return array( // Example server configuration. You may have more arrays like this one to // specify multiple server groups (however they should share the same login // server whilst they are allowed to have multiple char/map pairs). array( 'ServerName' => 'Test', // Global database configuration (excludes logs database configuration). 'DbConfig' => array( //'Socket' => '/tmp/mysql.sock', //'Port' => 3306, //'Encoding' => 'utf8', // Connection encoding -- use whatever here your MySQL tables collation is. 'Convert' => 'utf8', // -- 'Convert' option only works when 'Encoding' option is specified and iconv (http://php.net/iconv) is available. // -- It specifies the encoding to convert your MySQL data to on the website (most likely needs to be utf8) 'Hostname' => '1**.**.**.**', 'Username' => 'Test', 'Password' => 'Test01', 'Database' => 'Test', 'Persistent' => true, 'Timezone' => null // Example: '+0:00' is UTC. // The possible values of 'Timezone' is as documented from the MySQL website: // "The value can be given as a string indicating an offset from UTC, such as '+10:00' or '-6:00'." // "The value can be given as a named time zone, such as 'Europe/Helsinki', 'US/Eastern', or 'MET'." (see below continuation!) // **"Named time zones can be used only if the time zone information tables in the mysql database have been created and populated." ), // This is kept separate because many people choose to have their logs // database accessible under different credentials, and often on a // different server entirely to ensure the reliability of the log data. 'LogsDbConfig' => array( //'Socket' => '/tmp/mysql.sock', //'Port' => 3306, //'Encoding' => null, // Connection encoding -- use whatever here your MySQL tables collation is. 'Convert' => 'utf8', // -- 'Convert' option only works when 'Encoding' option is specified and iconv (http://php.net/iconv) is available. // -- It specifies the encoding to convert your MySQL data to on the website (most likely needs to be utf8) 'Hostname' => '1**.**.**.**', 'Username' => 'Test', 'Password' => 'Test01', 'Database' => 'Test', 'Persistent' => true, 'Timezone' => null // Possible values is as described in the comment in DbConfig. ), // Login server configuration. 'LoginServer' => array( 'Address' => '1**.**.**.**', 'Port' => 6900, 'UseMD5' => false, 'NoCase' => true, // Hercules account case-sensitivity; Default: Case-INsensitive (true). 'GroupID' => 0, // Default account group ID during registration. //'Database' => 'ragnarok' ), Quote Share this post Link to post Share on other sites
Good day!
I recently transfer my VPS to other hosting sites.
And upon changing the IP address in my Fluxcp everything works fine except account creation. It say Uh oh, what happened?
Did some googling and I end up getting these errors.
[2020-05-09 01:57:11] (PDOException) Exception PDOException: SQLSTATE[HY000] [2002] Connection timed out [2020-05-09 01:57:11] (PDOException) **TRACE** #0 /homepages/19/d739599868/htdocs/LibRO/lib/Flux/Connection.php(81): PDO->__construct('mysql:host=192....', 'Test', 'TestPass*', Array) [2020-05-09 01:57:11] (PDOException) **TRACE** #1 /homepages/19/d739599868/htdocs/LibRO/lib/Flux/Connection.php(94): Flux_Connection->connect(Object(Flux_Config)) [2020-05-09 01:57:11] (PDOException) **TRACE** #2 /homepages/19/d739599868/htdocs/LibRO/lib/Flux/Connection.php(159): Flux_Connection->getConnection() [2020-05-09 01:57:11] (PDOException) **TRACE** #3 /homepages/19/d739599868/htdocs/LibRO/lib/Flux/LoginServer.php(179): Flux_Connection->getStatement('SELECT userid F...') [2020-05-09 01:57:11] (PDOException) **TRACE** #4 /homepages/19/d739599868/htdocs/LibRO/modules/account/create.php(32): Flux_LoginServer->register('test0000', 'TestPass01', 'TestPass01', '[email protected]...', 'M', '2020-05-09', 'uVEIp') [2020-05-09 01:57:11] (PDOException) **TRACE** #5 /homepages/19/d739599868/htdocs/LibRO/lib/Flux/Template.php(375): include('/homepages/19/d...') [2020-05-09 01:57:11] (PDOException) **TRACE** #6 /homepages/19/d739599868/htdocs/LibRO/lib/Flux/Dispatcher.php(170): Flux_Template->render() [2020-05-09 01:57:11] (PDOException) **TRACE** #7 /homepages/19/d739599868/htdocs/LibRO/index.php(173): Flux_Dispatcher->dispatch(Array) [2020-05-09 01:57:11] (PDOException) **TRACE** #8 {main} [2020-05-09 01:57:15] (PDOException) Exception PDOException: SQLSTATE[HY000] [2002] Connection timed out [2020-05-09 01:57:15] (PDOException) **TRACE** #0 /homepages/19/d739599868/htdocs/LibRO/lib/Flux/Template.php(375): include() [2020-05-09 01:57:15] (PDOException) **TRACE** #1 /homepages/19/d739599868/htdocs/LibRO/lib/Flux/Dispatcher.php(170): Flux_Template->render() [2020-05-09 01:57:15] (PDOException) **TRACE** #2 /homepages/19/d739599868/htdocs/LibRO/index.php(173): Flux_Dispatcher->dispatch(Array) [2020-05-09 01:57:15] (PDOException) **TRACE** #3 {main}
What does these errors means?
Share this post
Link to post
Share on other sites