Can't create account (FluxCP)

M

MikZ

New member
Messages
461
Points
0
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?

 
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

 
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
Click to expand...
Hi @meko, Already did that.

Code: 
			<?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'
		),
 
You must log in or register to reply here.
Back
Top