Jump to content
  • 0
GM Clerk

Error everytime i try installing FLUXCP in my Webhosting >

Question

Error everytime i try installing FLUXCP in my Webhosting

 

thats my Conf of FluxCP : 

 

1- application.php : 

<?php
// This is the application configuration file. All values have been set to
// the default, and should be changed as needed.
return array(
	'ServerAddress'        => 'RO Domain Name Here <ro.ragnarok.com>',              // This value is the hostname:port under which Flux runs. (e.g., example.com or example.com:80)
	'BaseURI'              => '',                       // The base URI is the base web root on which your application lies.
	'InstallerPassword'    => '01',         // Installer/updater password.
	'RequireOwnership'     => false,                     // Require the executing user to be owner of the FLUX_ROOT/data/ directory tree? (Better for security)
	                                                    // WARNING: This will be mostly IGNORED on non-POSIX-compliant OSes (e.g. Windows).
	'DefaultLoginGroup'    => null,
	'DefaultCharMapServer' => null,
	'DefaultLanguage'      => 'en_us',                  // Specify the default control panel language (see FLUX_ROOT/lang/ directory for available languages.)
	'SiteTitle'            => 'RO Control Panel',     // This value is only used if the theme decides to use it.
	'ThemeName'            => array('default', 'emphaino'), // Names of the themes you would like to use.  Themes are in FLUX_ROOT/themes. First theme listed will be default theme.
	'ScriptTimeLimit'      => 0,                        // Script execution time limit. Specifies (in seconds) how long a page should run before timing out. (0 means forever)
	'MissingEmblemBMP'     => 'empty.bmp',              //
	'ItemIconNameFormat'   => '%d.png',                 // The filename format for item icons (defaults to {itemid}.png).
	'ItemImageNameFormat'  => '%d.png',                 // The filename format for item images (defaults to {itemid}.png).
	'MonsterImageNameFormat' => '%d.gif',               // The filename format for monster images (defaults to {monsterid}.gif).
	'JobImageNameFormat'   => '%d.gif',                 // The filename format for job images (defaults to {jobid}.gif).
	'ForceEmptyEmblem'     => false,                    // Forcefully display empty guild emblems, helpful when you don't have GD2 installed.
	'EmblemCacheInterval'  => 12,                       // Hourly interval to re-cache guild emblems (set to 0 to disable emblem cache).
	'SessionCookieExpire'  => 48,                       // Duration in hours.
	'AdminMenuGroupLevel'  => AccountLevel::LOWGM,      // The starting group ID for which module actions are moved into the admin menu for display.
	'DateDefaultTimezone'  => null,                     // The default timezone, consult the PHP manual for valid timezones: http://php.net/timezones (null for defaut system TZ)
	'DateFormat'           => 'Y-m-d',                  // Default DATE format to be displayed in pages.
	'DateTimeFormat'       => 'Y-m-d H:i:s',            // Default DATETIME format to be displayed in pages.
	'ShowSinglePage'       => true,                     // Whether or not to show the page numbers even if there's only one page.
	'ResultsPerPage'       => 20,                       // The number of results to display in a paged set, per page.
	'PagesToShow'          => 10,                       // The number of page numbers to display at once.
	'PageJumpMinimumPages' => 1,                        // Minimum number of required pages before page jump box is shown. (0 to always show!)
	'ShowPageJump'         => true,                     // Whether or not to show the "Page Jump" box.
	'SingleMatchRedirect'  => true,                     // Whether or not to redirect to view action from index page if only one match is returned (and action is allowed).
	'SingleMatchRedirectItem' => false,                 // Same as above, for item module.
	'SingleMatchRedirectMobs' => false,                 // Same as above, for monster module.
	'UsernameAllowedChars' => 'a-zA-Z0-9_',             // PCRE Format Pattern. default: 'a-zA-Z0-9_' (alphanumeric and underscore)
                                                        // WARNING: This string isn't escaped so be careful which chars you use!
                                                        // PCRE Pattern Ref: http://php.net/manual/en/pcre.pattern.php
	'MinUsernameLength'    => 4,                        // Minimum username length.
	'MaxUsernameLength'    => 23,                       // Maximum username length.
	'MinPasswordLength'    => 8,                        // Minimum password length.
	'MaxPasswordLength'    => 31,                       // Maximum password length.
	'PasswordMinUpper'     => 1,                        // Number of upper-case letters to require in passwords.
	'PasswordMinLower'     => 1,                        // Number of lower-case letters to require in passwords.
	'PasswordMinNumber'    => 1,                        // Number of numbers to require in passwords.
	'PasswordMinSymbol'    => 0,                        // Number of symbols to require in passwords.
	'EmailStrictCheck'     => false,                    // Whether to enable stricter checks for email addresses. (NOTE: there are perfectly valid email addresses that will be rejected if this setting is enabled).
	'GMMinPasswordLength'  => 8,                        // Minimum password length for GM accounts.
	'GMPasswordMinUpper'   => 1,                        // Number of upper-case letters to require in passwords for GM accounts.
	'GMPasswordMinLower'   => 1,                        // Number of lower-case letters to require in passwords for GM accounts.
	'GMPasswordMinNumber'  => 1,                        // Number of numbers to require in passwords for GM accounts.
	'GMPasswordMinSymbol'  => 1,                        // Number of symbols to require in passwords for GM accounts.
	'RandomPasswordLength' => 16,                       // This is the length of the random password generated by the "Reset Password" feature. (NOTE: Hardcoded minimum value of 8)
	'AllowUserInPassword'  => false,                    // Whether or not to allow the password to contain the username. (NOTE: A case-insensitive search is performed)
	'AllowDuplicateEmails' => false,                    // Whether or not to allow duplicate e-mails to be used in registration. (See Mailer config options)
	'RequireEmailConfirm'  => false,                    // Require e-mail confirmation during registration.
	'RequireChangeConfirm' => false,                    // Require confirmation when changing e-mail addresses.
	'EmailConfirmExpire'   => 48,                       // E-mail confirmations expire hours. Unconfirmed accounts will expire after this period of time.
	'MailerFromAddress'    => '[email protected]',      // The e-mail address displayed in the From field.
	'MailerFromName'       => 'MailerName',             // The name displayed with the From e-mail address.
	'MailerUseSMTP'        => false,                    // Whether or not to use a separate SMTP server for sending mail.
	'MailerSMTPUseSSL'     => false,                    // Whether or not mailer should connect using SSL (yes for GMail).
	'MailerSMTPUseTLS'     => false,                    // Same as above SSL setting, but for TLS.  This setting will override the SSL setting.
	'MailerSMTPPort'       => null,                     // When MailerUseSMTP is true: SMTP server port (mailer will default to 25).
	'MailerSMTPHosts'      => null,                     // When MailerUseSMTP is true: A string host or array of hosts (e.g., 'host1' or array('host1', 'backuphost')).
	'MailerSMTPUsername'   => null,                     // When MailerUseSMTP is true: Authorized username for SMTP server.
	'MailerSMTPPassword'   => null,                     // When MailerUseSMTP is true: Authorized password for SMTP server (for above user).
	'ServerStatusCache'    => 2,                        // Store a cached server status and refresh every X minutes.  Default: 2 minutes (value is measured in minutes).
	'ServerStatusTimeout'  => 2,                        // For each server, spend X amount of seconds to determine whether it's up or not.
	'SessionKey'           => 'fluxSessionData',        // Shouldn't be changed, just specifies the session key to be used for session data.
	'DefaultModule'        => 'main',                   // This is the module to execute when none has been specified.
	'DefaultAction'        => 'index',                  // This is the default action for any module, probably should leave this alone. (Deprecated)
	'GzipCompressOutput'   => false,                    // Whether or not to compress output using zlib.
	'GzipCompressionLevel' => 9,                        // zlib compression level. (1~9)
	'OutputCleanHTML'      => false,                     // Use this if you have Tidy installed to clean your HTML output when serving pages.
	'ShowCopyright'        => true,                     // Whether or not to show the copyright footer.
	'ShowRenderDetails'    => true,                     // Shows the "page rendered in X seconds" and "number of queries executed: X" in the default theme.
	'UseCleanUrls'         => false,                    // Set to true if you're running Apache and it supports mod_rewrite and .htaccess files.
	'DebugMode'            => false,                    // Set to false to minimize technical details from being output by Flux. WARNING: DO NOT USE THIS OPTION ON A PUBLICALLY-ACCESSIBLE CP.
	'UseCaptcha'           => true,                     // Use CAPTCHA image for account registration to prevent automated account creations. (Requires GD2/FreeType2)
	'UseLoginCaptcha'      => false,                    // Use CAPTCHA image for account logins. (Requires GD2/FreeType2)
	'EnableReCaptcha'      => false,                    // Enables the use of reCAPTCHA instead of Flux's native GD2 library (http://www.google.com/recaptcha)
	'ReCaptchaPublicKey'   => '...',                    // This is your reCAPTCHA public key [REQUIRED FOR RECAPTCHA] (sign up at http://www.google.com/recaptcha)
	'ReCaptchaPrivateKey'  => '...',                    // This is your reCAPTCHA private key [REQUIRED FOR RECAPTCHA] (sign up at http://www.google.com/recaptcha)
	'ReCaptchaTheme'       => 'white',                  // ReCaptcha theme to use (see: http://code.google.com/apis/recaptcha/docs/customization.html#Standard_Themes)
	'DisplaySinglePages'   => true,                     // Whether or not to display paging for single page results.
	'ForwardYears'         => 15,                       // (Visual) The number of years to display ahead of the current year in date inputs.
	'BackwardYears'        => 30,                       // (Visual) The number of years to display behind the current year in date inputs.
	'ColumnSortAscending'  => ' â–²',                     // (Visual) Text displayed for ascending sorted column names.
	'ColumnSortDescending' => ' â–¼',                     // (Visual) Text displayed for descending sorted column names.
	'CreditExchangeRate'   => 1.0,                      // The rate at which currency is exchanged for credits.
	'MinDonationAmount'    => 2.0,                      // Minimum donation amount. (NOTE: Actual donations made that are less than this account won't be exchanged)
	'DonationCurrency'     => 'USD',                    // Preferred donation currency. Only donations made in this currency will be processed for credit deposits.
	'MoneyDecimalPlaces'   => 2,                        // (Visual) Number of decimal places to display in amount.
	'MoneyThousandsSymbol' => ',',                      // (Visual) Thousandths place separator (a period in European currencies).
	'MoneyDecimalSymbol'   => '.',                      // (Visual) Decimal separator (a comma in European currencies).
	'AcceptDonations'      => true,                     // Whether or not to accept donations.
	'PayPalIpnUrl'         => 'www.sandbox.paypal.com', // The URL for PayPal's IPN responses (www.paypal.com for live and www.sandbox.paypal.com for testing)
	'PayPalBusinessEmail'  => '[email protected]',        // Enter the e-mail under which you have registered your business account.
	'PayPalReceiverEmails' => array(                    // These are the receiver e-mail addresses who are allowed to receive payment.
		//'[email protected]',                             // -- This array may be empty if you only use one e-mail
		//'[email protected]'                              // -- because your Business Email is also checked.
	),
	'GStorageLeaderOnly'   => false,                    // Only allow guild leader to view guild storage rather than all members?
	'DivorceKeepChild'     => false,                    // Keep child after divorce?
	'DivorceKeepRings'     => false,                    // Keep wedding rings after divorce?
	'IpWhitelistPattern'   =>                           // PCRE Format Pattern. It's recommended you add your gameserver, webserver and server owner's IPs here.
		'(127\.0\.0\.1|0(\.[0\*]){3})',                 // WARNING: This string isn't escaped so be careful which chars you use!
		                                                // By default, whitelists 127.0.0.1 (localhost) and 0.0.0.0 (all interfaces; whitelists all wildcard bans that can achive this too)
	'AllowIpBanLogin'      => false,                    // Allow logging into account from banned IP.
	'AllowTempBanLogin'    => false,                    // Allow logging in of temporarily banned accounts.
	'AllowPermBanLogin'    => false,                    // Allow logging in of permanently banned accounts.
	'AutoRemoveTempBans'   => true,                     // Automatically remove expired temporary bans on certain pages.
	'ItemShopMaxCost'      => 99,                       // Max price an item can be sold for.
	'ItemShopMaxQuantity'  => 99,                       // Max quantity the item may be sold at once for.
	'ItemShopItemPerPage'  => 5,                        // The number of items to display per page in the "Item Shop" page.
	'HideFromWhosOnline'   => AccountLevel::LOWGM,      // Levels greater than or equal to this will be hidden from the "Who's Online" page.
	'HideFromMapStats'     => AccountLevel::LOWGM,      // Levels greater than or equal to this will be hidden from the "Map Stats" page.
	'EnableGMPassSecurity' => AccountLevel::LOWGM,      // Levels greater than or equal to this will be required to use passwords that meet the earlier GM Password settings.
	'ChargeGenderChange'   => 0,                        // You can specify this as the number of credits to charge for gender change.  Can be 0 for free change.
	'BanPaymentStatuses'   => array(                    // Payment statuses that will automatically ban the account owner if received.
		'Cancelled_Reversal',                           // -- 'Cancelled_Reversal'
		'Reversed',                                     // -- 'Reversed'
	),
	
	'HoldUntrustedAccount' => 0,                        // This is the time in hours to hold a donation crediting process for, if the account
	                                                    // isn't a trusted account. Specify 0 or false to disable this feature.
	
	'AutoUnholdAccount'    => false,                    // Enable this to auto-unhold an account and credit it if the transaction is still
	                                                    // valid.  This only applies if you are using the HoldUnstrustedAccount feature.
	                                                    // If you want to run a cron job instead, you can make a request to the '/donate/update'
	                                                    // module/action with the InstallerPassword as the password to run the update task.
	                                                    // With clean URLs: http://<server>/<baseURI>/donate/update?password=<InstallerPassword>
	                                                    // Without clean URLs: http://<server>/<baseURI>?module=donate&action=update&password=<InstallerPassword>
	                                                    // NOTE: This option is HIGHLY inefficient, it's recommended to run a cron job instead.
	
	'AutoPruneAccounts'    => false,                    // Enable this to automatically prune expired accounts. Enabling this is a performance
	                                                    // performance killer. See 'AutoUnholdAccount' for running this task as a cron job,
		                                                // the module is 'account' and the action is 'prune'.
	                                                    // With clean URLs: http://<server>/<baseURI>/account/prune?password=<InstallerPassword>
	                                                    // Without clean URLs: http://<server>/<baseURI>?module=account&action=prune&password=<InstallerPassword>
	
	'ShopImageExtensions'  => array(                    // These are the image extensions allowed for uploading in the item shop.
		'png', 'jpg', 'gif', 'bmp', 'jpeg'
	),
	'NoResetPassGroupLevel'  => AccountLevel::LOWGM,    // Minimum group level of account to prevent password reset using control panel.
	
	'CharRankingLimit'       => 20,                     //
	'GuildRankingLimit'      => 20,                     //
	'ZenyRankingLimit'       => 20,                     //
	'DeathRankingLimit'      => 20,                     //
	'AlchemistRankingLimit'  => 20,                     //
	'BlacksmithRankingLimit' => 20,                     //
	
	'RankingHideGroupLevel'  => AccountLevel::LOWGM,    //
	'InfoHideZenyGroupLevel' => AccountLevel::LOWGM,    // Minimum group level of account to hide zeny from in server information page.
	
	'CharRankingThreshold'      => 0,                   // Number of days the character must have logged in within to be listed in character ranking. (0 = disabled)
	'ZenyRankingThreshold'      => 0,                   // Number of days the character must have logged in within to be listed in zeny ranking. (0 = disabled)
	'DeathRankingThreshold'     => 0,                   // Number of days the character must have logged in within to be listed in death ranking. (0 = disabled)
	'AlchemistRankingThreshold' => 0,                   // Number of days the character must have logged in within to be listed in death ranking. (0 = disabled)
	
	'HideTempBannedCharRank'  => false,                 // Hide temporarily banned characters from ranking.
	'HidePermBannedCharRank'  => true,                  // Hide permanently banned characters from ranking.
	
	'HideTempBannedZenyRank'  => false,                 // Hide temporarily banned characters from ranking.
	'HidePermBannedZenyRank'  => true,                  // Hide permanently banned characters from ranking.
	
	'HideTempBannedDeathRank' => false,                 // Hide temporarily banned characters from ranking.
	'HidePermBannedDeathRank' => true,                  // Hide permanently banned characters from ranking.
	
	'HideTempBannedAlcheRank' => false,                 // Hide temporarily banned characters from ranking.
	'HidePermBannedAlcheRank' => true,                  // Hide permanently banned characters from ranking.
	
	'HideTempBannedSmithRank' => false,                 // Hide temporarily banned characters from ranking.
	'HidePermBannedSmithRank' => true,                  // Hide permanently banned characters from ranking.
	
	'HideTempBannedStats'     => false,                 // Hide temporarily banned accounts from statistics.
	'HidePermBannedStats'     => true,                  // Hide permanently banned accounts from statistics.
	
	'SortJobsByAmount'        => false,                 // Sort job class information on statistics page by descending quantity (false = Sort by Job ID).
	
	'CpLoginLogShowPassword'  => false,                 // Show password in CP login log (also see access.php's SeeCpLoginLogPass).
	
	'CpResetLogShowPassword'  => false,                 // Show password in CP "password resets" log (also see access.php's SeeCpResetPass).
	
	'CpChangeLogShowPassword' => false,                 // Show password in CP "password changes" log (also see access.php's SeeCpChangePass).
	
	'AdminMenuNewStyle'       => true,                  // Use new-style admin menu;  Applies to 'default' theme.
	
	// These are the main menu items that should be displayed by themes.
	// They route to modules and actions.  Whether they are displayed or
	// not at any given time depends on the user's account group level and/or
	// their login status.
	'MenuItems' => array(
		//'Main Menu'   => array(
		//	'Home'          => array('module' => 'main'),
			//'Forums'        => array('exturl' => 'http://www.fluxro.com/community'),
		//),
		'Account'     => array(
			'Register'      => array('module' => 'account', 'action' => 'create'),
			'Login'         => array('module' => 'account', 'action' => 'login'),
			'My Account'    => array('module' => 'account', 'action' => 'view'),
			'History'       => array('module' => 'history'),
			'Logout'        => array('module' => 'account', 'action' => 'logout'),
		),
		'Donations'   => array(
			'Donate'        => array('module' => 'donate'),
			'Purchase'      => array('module' => 'purchase'),
		),
		'Information' => array(
			'Server Info'   => array('module' => 'server', 'action' => 'info'),
			'Server Status' => array('module' => 'server', 'action' => 'status'),
			'WoE Hours'     => array('module' => 'woe'),
			'Castles'       => array('module' => 'castle'),
			"Who's Online"  => array('module' => 'character', 'action' => 'online'),
			'Map Statistics'=> array('module' => 'character', 'action' => 'mapstats'),
			'Ranking Info'  => array('module' => 'ranking', 'action' => 'character'),
		),
		'Database'    => array(
			'Item Database' => array('module' => 'item'),
			'Mob Database'  => array('module' => 'monster'),
		),
		'Misc. Stuff' => array(
			'Hercules Logs' => array('module' => 'logdata'),
			'CP Logs'       => array('module' => 'cplog'),
			'IP Ban List'   => array('module' => 'ipban'),
			'Accounts'      => array('module' => 'account'),
			'Characters'    => array('module' => 'character'),
			'Guilds'        => array('module' => 'guild'),
			'Send Mail'     => array('module' => 'mail'),
			'Re-Install'    => array('module' => 'install', 'action' => 'reinstall'),
			//'Auction'       => array('module' => 'auction'),
			//'Economy'       => array('module' => 'economy'),
		)
	),
	
	// Sub-menu items that are displayed for any action belonging to a
	// particular module. The format it simple.
	'SubMenuItems' => array(
		'history' => array(
			'gamelogin'  => 'Game Logins',
			'cplogin'    => 'CP Logins',
			'emailchange'=> 'E-Mail Changes',
			'passchange' => 'Password Changes',
			'passreset'  => 'Password Resets'
		),
		'account' => array(
			'index'      => 'List Accounts',
			'view'       => 'View Account',
			'changepass' => 'Change Password',
			'changemail' => 'Change E-mail',
			'changesex'  => 'Change Gender',
			'transfer'   => 'Transfer Credits',
			'xferlog'    => 'Credit Transfer History',
			'cart'       => 'Go to Shopping Cart',
			'login'      => 'Login',
			'create'     => 'Register',
			'resetpass'  => 'Reset Password',
			'resend'     => 'Resend E-mail Confirmation'
		),
		'guild' => array(
			'index'  => 'List Guilds',
			'export' => 'Export Guild Emblems'
		),
		'server' => array(
			'status'     => 'View Status',
			'status-xml' => 'View Status as XML'
		),
		'logdata' => array(
			//'char'    => 'Characters',
			//'inter'   => 'Interactions',
			'command' => 'Commands',
			//'branch'  => 'Branches',
			'chat'    => 'Chat Messages',
			'login'   => 'Logins',
			//'mvp'     => 'MVP',
			//'npc'     => 'NPC',
			'pick'    => 'Item Picks',
			'zeny'    => 'Zeny'
		),
		'cplog' => array(
			'paypal'     => 'PayPal Transactions',
			'login'      => 'Logins',
			'resetpass'  => 'Password Resets',
			'changepass' => 'Password Changes',
			'changemail' => 'E-mail Changes',
			'ban'        => 'Account Bans',
			'ipban'      => 'IP Bans'
		),
		'purchase' => array(
			'index'    => 'Shop',
			'cart'     => 'Go to Cart',
			'checkout' => 'Checkout',
			'clear'    => 'Empty Cart',
			'pending'  => 'Pending Redemption'
		),
		'donate' => array(
			'index'   => 'Make a Donation',
			'history' => 'Donation History',
			'trusted' => 'Trusted PayPal E-mails'
		),
		'ipban' => array(
			'index' => 'IP Ban List',
			'add'   => 'Add IP Ban'
		),
		'ranking' => array(
			'character'  => 'Character Ranking',
			'guild'      => 'Guild Ranking',
			'zeny'       => 'Zeny Ranking',
			'death'      => 'Death Ranking',
			'alchemist'  => 'Alchemist Ranking',
			'blacksmith' => 'Blacksmith Ranking'
		),
		'item' => array(
			'index' => 'List Items',
			'add'   => 'Add Item'
		)
	),
	
	'AllowMD5PasswordSearch'       => false,
	'ReallyAllowMD5PasswordSearch' => false, // Are you POSITIVELY sure?
	
	// Specifies which modules and actions should be ignored by Tidy
	// (enabled/disabled by the OutputCleanHTML option).
	'TidyIgnore' => array(
		array('module' => 'captcha'),
		array('module' => 'guild', 'action' => 'emblem')
	),
	
	// Job classes, loaded from another file to avoid cluttering this one.
	// There isn't normally a need to modify this file, unless it's been
	// modified in an update. (In English: DON'T TOUCH THIS.)
	'JobClasses' => include('jobs.php'),
	
	// Alchemist job classes, mostly used for alchemist rankings.
	// Should be left alone unless new alchemist-related job classes are introduced.
	'AlchemistJobClasses' => include('jobs_alchemist.php'),
	
	// Blacksmith job classes, mostly used for blacksmith rankings.
	// Should be left alone unless new blacksmith-related job classes are introduced.
	'BlacksmithJobClasses' => include('jobs_blacksmith.php'),

	// Gender-linked Job class IDs and their corresponding names.
	// Should be left alone unless new gender-specific job classes are introduced.
	'GenderLinkedJobClasses' => include('jobs_gender_linked.php'),
	
	// Homunculus class IDs and their corresponding names.
	// Best not to mess with this either.
	'HomunClasses' => include('homunculus.php'),

	// Item Types with their corresponding names.
	// Shouldn't touch this either.
	'ItemTypes' => include('itemtypes.php'),
	
	// Specil Item Types with their corresponding names (For Weapons & Ammo by default).
	// Shouldn't touch this either.
	'ItemTypes2' => include('itemtypes2.php'),
	
	// Common Equip Location Combinations with their corresponding names.
	// Shouldn't touch this unless you've added custom combinations.
	'EquipLocationCombinations' => include('equip_location_combinations.php'),
	
	// Error Code -> Error Type mapping.
	// Shouldn't need touching, however modifying loginerrors.php should be relatively safe.
	'LoginErrors' => include('loginerrors.php'),
	
	// Hercules equip jobs mapping.
	'EquipJobs' => include('equip_jobs.php'),
	
	// Hercules equip locations mapping.
	'EquipLocations' => include('equip_locations.php'),
	
	// Hercules equip upper mapping.
	'EquipUpper' => include('equip_upper.php'),
	
	// Hercules monster sizes mapping.
	'MonsterSizes' => include('sizes.php'),
	
	// Hercules monster races mapping.
	'MonsterRaces' => include('races.php'),
	
	// Hercules elements mapping.
	'Elements' => include('elements.php'),
	
	// Hercules attributes mapping.
	'Attributes' => include('attributes.php'),
	
	// Hercules monster modes mapping.
	'MonsterModes' => include('monstermode.php'),
	
	// Item shop categories.
	'ShopCategories' => include('shopcategories.php'),
	
	// Item pick and zeny log types.
	'PickTypes' => include('picktypes.php'),
	
	// Castle names.
	'CastleNames' => include('castlenames.php'),
	
	// DON'T TOUCH. THIS IS FOR DEVELOPERS.
	'FluxTables' => array(
		'CreditsTable'        => 'cp_credits',
		'CreditTransferTable' => 'cp_xferlog',
		'ItemShopTable'       => 'cp_itemshop',
		'TransactionTable'    => 'cp_txnlog',
		'RedemptionTable'     => 'cp_redeemlog',
		'AccountCreateTable'  => 'cp_createlog',
		'AccountBanTable'     => 'cp_banlog',
		'IpBanTable'          => 'cp_ipbanlog',
		'DonationTrustTable'  => 'cp_trusted',
		'AccountPrefsTable'   => 'cp_loginprefs',
		'CharacterPrefsTable' => 'cp_charprefs',
		'ResetPasswordTable'  => 'cp_resetpass',
		'ChangeEmailTable'    => 'cp_emailchange',
		'LoginLogTable'       => 'cp_loginlog',
		'ChangePasswordTable' => 'cp_pwchange'
	)
);
?>

2 - servers.php

<?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'     => 'RO',
		// 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'   => 'VPS IP HERE',
			'Username'   => 'root',
			'Password'   => 'Password Of Root User',
			'Database'   => 'ragnarok db name here',
			'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'   => 'VPS IP HERE',
			'Username'   => 'root',
			'Password'   => 'Password Of Root User',
			'Database'   => 'ragnarok db name here',
			'Persistent' => true,
			'Timezone'   => null // Possible values is as described in the comment in DbConfig.
		),
		// Login server configuration.
		'LoginServer'    => array(
			'Address'  => 'VPS IP HERE',
			'Port'     => 6900,
			'UseMD5'   => false,
			'NoCase'   => true, // Hercules account case-sensitivity; Default: Case-INsensitive (true).
			'GroupID'  => 0,    // Default account group ID during registration.
			//'Database' => 'ragnarok'
		),
		'CharMapServers' => array(
			array(
				'ServerName'      => 'RO',
				'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
				'MaxBaseLevel'    => 150,
				'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'     => 'VPS IP HERE',
					'Port'        => 6121
				),
				'MapServer'       => array(
					'Address'     => 'VPS IP HERE',
					'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.
				)
			)
		)
	)
);
?>

my MYSQL Settings Is : 

 

1- User : 

MwTBdQy.png

uY6ZXIO.png

Now When i try Installing the FLUXCP : 

sMhvWB8.png

 

when i click update RO : 

4jXL1P5.png

 

 

what can i do to fix this errors ?

Share this post


Link to post
Share on other sites

4 answers to this question

Recommended Posts

  • 0

Seems like MySQL is not accepting remote connection

If it's Linux vps, open

/etc/mysql/my.cnf or /etc/my.cnf

(check which one exist and open it, some OS have it under etc folder, some have under mysql folder as mentioned above)

Find

bind-address = 127.0.0.1

Comment it (by adding # at beginning )

#bind-address = 127.0.0.1

 

And restart the MySQL

Share this post


Link to post
Share on other sites
  • 0

Thanks for your Reply @Dastgir 

thats my " my.cnf " 

[mysqld]
datadir=/var/lib/mysql
socket=/var/lib/mysql/mysql.sock
user=mysql
# Disabling symbolic-links is recommended to prevent assorted security risks
symbolic-links=0

[mysqld_safe]
log-error=/var/log/mysqld.log
pid-file=/var/run/mysqld/mysqld.pid

please tell me what i should add or edit ?

Share this post


Link to post
Share on other sites
  • 0

2 cases:
1) if you are having fluxcp and SQL on same vps, try changing ip from localhost to 127.0.0.1 or vice versa and one should work
2) if webhost fluxcp and SQL are on different vps,
The error is showing connection refused, that means it is not even accepting the connection to check user/pass, so change my.cnf to

[mysqld]
datadir=/var/lib/mysql
socket=/var/lib/mysql/mysql.sock
user=mysql
# Disabling symbolic-links is recommended to prevent assorted security risks
symbolic-links=0
bind-address = 0.0.0.0

[mysqld_safe]
log-error=/var/log/mysqld.log
pid-file=/var/run/mysqld/mysqld.pid

And restart mysql

 

Edit: I am not used to phpmyadmin, so I cannot tell if that way is proper.
However, you can add grant by following way via ssh(putty):
Login to vps, then type this to login to mysql:
mysql -u root -p
It will ask for password , enter it
Then type these 2 commands
GRANT ALL PRIVILEGES ON *.* TO 'root'@'YOUR_WEB_URL_OR_IP' IDENTIFIED BY 'PASSWORD_HERE';FLUSH PRIVILEGES;

Change YOUR_WEB_URL_OR_IP to your website domain or ip, or replace it by % if you don't want to restrict login by ip/domain

Share this post


Link to post
Share on other sites
  • 0

I do all of this 

now my.cnf : 

[mysqld]
datadir=/var/lib/mysql
socket=/var/lib/mysql/mysql.sock
user=mysql
# Disabling symbolic-links is recommended to prevent assorted security risks
symbolic-links=0
bind-address = 0.0.0.0

[mysqld_safe]
log-error=/var/log/mysqld.log
pid-file=/var/run/mysqld/mysqld.pid

and the changes in the SSH : 

E3qmDe6.png

 

 

The Error when Installing : 

 

bqgR8l4.png

 

iam sorry for this much errors :(

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.