Jump to content
  • 0
MikZ

Can't create account (FluxCP)

Question

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

1 answer to this question

Recommended Posts

  • 0

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

Share this post


Link to post
Share on other sites
  • 0
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'
		),

 

Share this post


Link to post
Share on other sites

Join the conversation

You can post now and register later. If you have an account, sign in now to post with your account.

Guest
Answer this question...

×   Pasted as rich text.   Restore formatting

  Only 75 emoji are allowed.

×   Your link has been automatically embedded.   Display as a link instead

×   Your previous content has been restored.   Clear editor

×   You cannot paste images directly. Upload or insert images from URL.

Loading...

×
×
  • Create New...

Important Information

By using this site, you agree to our Terms of Use.