Jump to content

Flux MySQL Port


Recommended Posts


  • Group:  Members
  • Topic Count:  8
  • Topics Per Day:  0.00
  • Content Count:  37
  • Reputation:   4
  • Joined:  06/07/13
  • Last Seen:  

i tried to change 3306 to 3333 mysql port from my vps..

and now the flux cant connect to it.. anyone knows where can i change it flux?

 

 

flux/config/server.php

'ServerName'     => 'Server Name',
        // Global database configuration (excludes logs database configuration).
        'DbConfig'       => array(
            // 'Socket'     => '/tmp/mysql.sock',
            //  'Port'       => 3306,  change it to 3333 and delete // didnt helped
            // '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'   => 'localhost',
            'Username'   => 'user',
            'Password'   => 'pass',
            'Database'   => 'ragnarok',
            'Persistent' => true,
            'Timezone'   => 'Asia/Manila' // 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,  change it to 3333 and delete // didnt helped
            // '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'   => 'localhost',
            'Username'   => 'user',
            'Password'   => 'pass',
            'Database'   => 'ragnarok',
            'Persistent' => true,
            'Timezone'   => 'Asia/Manila' // Possible values is as described in the comment in DbConfig.
        ),

 

Link to comment
Share on other sites


  • Group:  Members
  • Topic Count:  3
  • Topics Per Day:  0.00
  • Content Count:  707
  • Reputation:   168
  • Joined:  01/26/12
  • Last Seen:  

Hi BugsLIFE,

 

Your MySQL has to be configured to run on port 3333, then restarted. But why would you change the port? You would have to do this for your emulator as well. 

 

FluxCP can't be set to query MySQL on port 3333 unless your MySQL server is actually listening to port 3333, by default; MySQL is set to use 3306.

Link to comment
Share on other sites


  • Group:  Members
  • Topic Count:  13
  • Topics Per Day:  0.00
  • Content Count:  66
  • Reputation:   6
  • Joined:  11/13/12
  • Last Seen:  

It's commented out. Remove "//" 

 

//  'Port'       => 3306
 
Link to comment
Share on other sites


  • Group:  Members
  • Topic Count:  8
  • Topics Per Day:  0.00
  • Content Count:  37
  • Reputation:   4
  • Joined:  06/07/13
  • Last Seen:  

Hi BugsLIFE,

 

Your MySQL has to be configured to run on port 3333, then restarted. But why would you change the port? You would have to do this for your emulator as well. 

 

FluxCP can't be set to query MySQL on port 3333 unless your MySQL server is actually listening to port 3333, by default; MySQL is set to use 3306.

 

i tried to change it because i am scared of someone who use to ddos attack my server

 

i thought he will target my vpsip+3306 port?.. or that will not work?

 

about the mysql port yes it was working on my vps i check it using this

 

lsof -i :3333 and it i see its LISTEN status

 

 

 

It's commented out. Remove "//" 

 

//  'Port'       => 3306
 

i already did that..    //'Port'       => 3306,  change it to 3333 and delete // didnt helped

Link to comment
Share on other sites


  • Group:  Members
  • Topic Count:  8
  • Topics Per Day:  0.00
  • Content Count:  37
  • Reputation:   4
  • Joined:  06/07/13
  • Last Seen:  

bump? i just need to know how to change sql ports in flux.. instead of default 3306

Link to comment
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
Reply to this topic...

×   Pasted as rich text.   Paste as plain text instead

  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.

×
×
  • Create New...