-
Posts
1302 -
Joined
-
Last visited
-
Days Won
4
Content Type
Profiles
Forums
Downloads
Jobs Available
Server Database
Third-Party Services
Top Guides
Store
Everything posted by mrlongshen
-
sir i have grant all permission for my user. still get this error. Error: PDOException Message: SQLSTATE[HY000] [2003] Can't connect to MySQL server on '116.xxx.xxx.136' (4) File: /home/syokro8/public_html/cpanel/lib/Flux/Connection.php:81
-
Well, anyone who likes pink haha Yeah, it's flux based. Here's a different view: nah. the bg is much better. 9.7/10. make the default theme for hercules
-
no custom diff on 2013 client ;(
-
Hello all.. First thing I want to share is, I have a vps server with full root access. 2nd thing is, I have a webhosting. The problem is. I want to install my fluxcp on my website. what should i config, in fluxcp/config/server.php folder? when I try configure the below configuration error. Its seem mysql does not accept connection from webhosting. on my thinking, i create a subdomain on my webhosting. cpanel.xxxx.net then i upload the fluxcp file on the subdomain. then i setup like below. but i got an error. is that false i setup like below ? i put my vps ip on there ? <?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' => 'FluxRO', // 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' => '116.xxx.xxx.136', <--My VPS IP 'Username' => 'xxxxx', <--My sql username 'Password' => 'xxxxxxxxxxx', <--My sql passwd 'Database' => 'xxxxxxxx_rag', <--My sql database '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' => '127.0.0.1', 'Username' => 'ragnarok', 'Password' => 'ragnarok', 'Database' => 'ragnarok', 'Persistent' => true, 'Timezone' => null // Possible values is as described in the comment in DbConfig. ), // Login server configuration. 'LoginServer' => array( 'Address' => '127.0.0.1', 'Port' => 6900, 'UseMD5' => true, 'NoCase' => true, // rA account case-sensitivity; Default: Case-INsensitive (true). 'GroupID' => 0, // Default account group ID during registration. //'Database' => 'ragnarok' ), 'CharMapServers' => array( array( 'ServerName' => 'FluxRO', 'Renewal' => true, 'MaxCharSlots' => 9, 'DateTimezone' => null, // Specifies game server's timezone for this char/map pair. (See: http://php.net/timezones) //'ResetDenyMaps' => 'sec_pri', // Defaults to 'sec_pri'. This value can be an array of map names. //'Database' => 'ragnarok', // Defaults to DbConfig.Database 'ExpRates' => array( 'Base' => 100, // Rate at which (base) exp is given 'Job' => 100, // Rate at which job exp is given 'Mvp' => 100 // MVP bonus exp rate ), 'DropRates' => array( // The rate the common items (in the ETC tab, besides card) are dropped 'Common' => 100, 'CommonBoss' => 100, // The rate healing items (that restore HP or SP) are dropped 'Heal' => 100, 'HealBoss' => 100, // The rate usable items (in the item tab other then healing items) are dropped 'Useable' => 100, 'UseableBoss' => 100, // The rate at which equipment is dropped 'Equip' => 100, 'EquipBoss' => 100, // The rate at which cards are dropped 'Card' => 100, 'CardBoss' => 100, // The rate adjustment for the MVP items that the MVP gets directly in their inventory 'MvpItem' => 100 ), 'CharServer' => array( 'Address' => '127.0.0.1', 'Port' => 6121 ), 'MapServer' => array( 'Address' => '127.0.0.1', 'Port' => 5121 ), // -- WoE days and times -- // First parameter: Starding day 0=Sunday / 1=Monday / 2=Tuesday / 3=Wednesday / 4=Thursday / 5=Friday / 6=Saturday // Second parameter: Starting hour in 24-hr format. // Third paramter: Ending day (possible value is same as starting day). // Fourth (final) parameter: Ending hour in 24-hr format. // ** (Note, invalid times are ignored silently.) 'WoeDayTimes' => array( //array(0, '12:00', 0, '14:00'), // Example: Starts Sunday 12:00 PM and ends Sunday 2:00 PM //array(3, '14:00', 3, '15:00') // Example: Starts Wednesday 2:00 PM and ends Wednesday 3:00 PM ), // Modules and/or actions to disallow access to during WoE. 'WoeDisallow' => array( array('module' => 'character', 'action' => 'online'), // Disallow access to "Who's Online" page during WoE. array('module' => 'character', 'action' => 'mapstats') // Disallow access to "Map Statistics" page during WoE. ) ) ) ) ); ?> when i want to install. i got this error. Exception Details Error: PDOException Message: SQLSTATE[HY000] [2003] Can't connect to MySQL server on '116.xxx.xxx.136' (4) <--This is my vps IP! File: /home/syokro8/public_html/cpanel/lib/Flux/Connection.php:81 how to fix this ? what should i do ? i dont want point my website cpanel.xxxxx.net to ip 111.xxx.xxx.xxx like that. i want when i open my cpanel.xxx.net its will a control panel. not point. please regard~ TENSION~~!! ****i hope someone will try to guide and help me. thx you.
-
yahhh. mysterious is girlish. hehehe.. 9.5/10 for girl. hehehe is this flux sir ?
-
Katazui's Easter Egg (Hide & Seek Event)
mrlongshen replied to Katazui's topic in Game, Event, Quest Script Releases
why we start the event there are popup ? huhu -
so sad
-
you can set how many you want. its included on the script. thx
-
hello sir. please update
-
nice mysterious.. 9/10. dont you want make the navigation menu on the center not the left side ?
-
set your account id on your clientinfo.xml
-
can someone rename this map to market ?
-
Street Mall Shops ( All in One NPC )
mrlongshen replied to Virtue's topic in Utility Script Releases
when i try call armor. its not appear. but weapon appear. weird. -
yeah. all the process is still same right? only the item desc is different...
-
repack using the grf editor.
-
how to connect the fluxcp to the sql database on forum. when i tried to connect mysql cannot connected. Its seem disallow connection from outside. ohhh. thx alot sir . got command to backup database ? mayb automatically every weekend ?
-
sir im on centos .. same right ... ? i will try the 'setsebool -P httpd_can_network_connect=1' btw.. can i run the the main.sql and log.sql on my webhost ? cannot ea ? i want to save the database on webhost so then i can backup if the vps got problem.
-
thx alot sir +1 for u . hehee btw i need to configure my flux cp config, to my vps server database right ? 1000 MB (1GB) Web And Email Space 50000 MB (50GB) Bandwidth/month Unlimited Subdomain and Domain Unlimited Email Unlimited mySQL Unlimited Addon & Park Domain its enough right ? As Myth said, use your sql user/password to connect flux cp to the vps. I always create a separate user just to connect to sql. Example: If I host my website with asurahosting, I will need to make sure that the new User has ALL privileges and the allowed host it can connect to is cpanel.asurahosting.com In my users list in phpmyadmin it looks like this user1/password/127.0.0.1 - allows my server to start using its local ip and permissions user2/password/localhost - allows any user on any IP to connect via phpmyadmin user3/password/cpanel.asurahosting.com - allows my webserver to connect to sql This way all the passwords are different and I can keep track of which user connects to what via sql. Those website stats you gave me seem pretty good, more than enough for what you need. hello sir, i dont understand.. i have a website. then i install main.sql. and log.sql then i config my inter.conf with on my website sql. but when i start cannot connect. how do i config my server on vps but running all sql in my webhosting ? is that possible ? or not ? and for the flux cp, should i install in website or vps ? bump post~ I install my control panel on my webhosting, and then i config my server.php to point my sql serves on the vps. but i got this error. Exception DetailsError: PDOException Message: SQLSTATE[HY000] [2003] Can't connect to MySQL server on '116.xxx.212.xxx' (4) what should i do ? just a control panel problem, but my server running well
-
hahaha.. rilek
-
i said to u its not a paid. hahaha. i hate u <3
-
+1 for . if u got a prontera collection please share with me
-
yes. i want this. please share sir this two maps..
-
nope . not thiss... .
-
sprite reposites have been closed. zz so sad.. promise 27 July will be back. but until now still same.
-
nope. its free release. i forgot where i get before this. so sad bro