• There is NO official Otland's Discord server and NO official Otland's server list. The Otland's Staff does not manage any Discord server or server list. Moderators or administrator of any Discord server or server lists have NO connection to the Otland's Staff. Do not get scammed!
  • 2026 staff recruitment is open! Check it out and consider applying!

Gesior - Can't connect to MySQL database. HELP

Zt0ffe

Zt0ffe

New Member
Joined
Sep 26, 2008
Messages
341
Reaction score
4
Location
Sweden
Hello!

When i try to install Geisor 0.3.8 http://otland.net/f118/gesior-0-3-8-a-114275/

i get this error in the third step "Can't connect to MySQL database."

using uniform server version "carbo_6_0_2"

and [8.60] The Forgotten Server 0.3.6 (Crying Damson) V5 from http://otland.net/f18/8-60-forgotten-server-0-3-6-crying-damson-v5-147913/

maybe useful info:
had to change localhost
to
sqlHost = "127.0.0.1" in the ot config

to make the ot server establish connection to sql DB

[video=youtube;2pfT0t8YRy0]http://www.youtube.com/watch?v=2pfT0t8YRy0&feature=youtu.be[/video]
 
Sort by date Sort by votes
Code: 
	accountManager = false
	namelockManager = true
	newPlayerChooseVoc = true
	newPlayerSpawnPosX = 32369
	newPlayerSpawnPosY = 32241
	newPlayerSpawnPosZ = 7
	newPlayerTownId = 1
	newPlayerLevel = 8
	newPlayerMagicLevel = 0
	generateAccountNumber = false

 	comboTime = 100
   	 comboMembers = 2
    	comboFriends = 3
    	comboFriendsClearTime = 5 * 60 * 1000
    	comboFriendsClearInterval = 1 * 60 * 1000
    	comboShowAnimation = 1  

	noDamageToGuildMates = false
	noDamageToPartyMembers = false



	redSkullLength = 30 * 24 * 60 * 60
	blackSkullLength = 45 * 24 * 60 * 60
	dailyFragsToRedSkull = 3
	weeklyFragsToRedSkull = 5
	monthlyFragsToRedSkull = 10
	dailyFragsToBlackSkull = dailyFragsToRedSkull
	weeklyFragsToBlackSkull = weeklyFragsToRedSkull
	monthlyFragsToBlackSkull = monthlyFragsToRedSkull
	dailyFragsToBanishment = dailyFragsToRedSkull
	weeklyFragsToBanishment = weeklyFragsToRedSkull
	monthlyFragsToBanishment = monthlyFragsToRedSkull
	blackSkulledDeathHealth = 40
	blackSkulledDeathMana = 0
	useBlackSkull = true
	useFragHandler = true
	advancedFragList = false

	notationsToBan = 3
	warningsToFinalBan = 4
	warningsToDeletion = 5
	banLength = 7 * 24 * 60 * 60
	killsBanLength = 7 * 24 * 60 * 60
	finalBanLength = 30 * 24 * 60 * 60
	ipBanishmentLength = 1 * 24 * 60 * 60
	broadcastBanishments = true
	maxViolationCommentSize = 200
	violationNameReportActionType = 2
	autoBanishUnknownBytes = false


	worldType = "pvp"
	protectionLevel = 1
	pvpTileIgnoreLevelAndVocationProtection = true
	pzLocked = 60 * 1000
	huntingDuration = 60 * 1000
	criticalHitChance = 7
	criticalHitMultiplier = 1
	displayCriticalHitNotify = false
	removeWeaponAmmunition = true
	removeWeaponCharges = true
	removeRuneCharges = true
	whiteSkullTime = 15 * 60 * 1000
	noDamageToSameLookfeet = false
	showHealingDamage = false
	showHealingDamageForMonsters = false
	fieldOwnershipDuration = 5 * 1000
	stopAttackingAtExit = false
	oldConditionAccuracy = false
	loginProtectionPeriod = 10 * 1000
	deathLostPercent = 10
	stairhopDelay = 2 * 1000
	pushCreatureDelay = 2 * 1000
	deathContainerId = 1987
	gainExperienceColor = 215
	addManaSpentInPvPZone = true
	squareColor = 0
	allowFightback = true

	worldId = 0
	ip = "godsaft.no-ip.org"
	bindOnlyConfiguredIpAddress = false
	loginPort = 7171
	gamePort = 7172
	adminPort = 7171
	statusPort = 7171
	loginTries = 10
	retryTimeout = 5 * 1000
	loginTimeout = 60 * 1000
	maxPlayers = 1000
	motd = "Welcome to the Forgotten Server 8.60!"
	displayOnOrOffAtCharlist = false
	onePlayerOnlinePerAccount = true
	allowClones = false
	serverName = "Forgotten 8.60"
	loginMessage = "Welcome to the Forgotten Server 8.60!"
	statusTimeout = 5 * 60 * 1000
	replaceKickOnLogin = true
	forceSlowConnectionsToDisconnect = false
	loginOnlyWithLoginServer = false
	premiumPlayerSkipWaitList = false

	sqlType = "mysql"
	sqlHost = "127.0.0.1"
	sqlPort = 3306
	sqlUser = "test"
	sqlPass = "test"
	sqlDatabase = "iamking"
	sqlFile = "forgottenserver.s3db"
	sqlKeepAlive = 0
	mysqlReadTimeout = 10
	mysqlWriteTimeout = 10
	encryptionType = "plain"


	deathListEnabled = true
	deathListRequiredTime = 1 * 60 * 1000
	deathAssistCount = 19
	maxDeathRecords = 5


	ingameGuildManagement = true
	levelToFormGuild = 8
	premiumDaysToFormGuild = 0
	guildNameMinLength = 4
	guildNameMaxLength = 20


	highscoreDisplayPlayers = 15
	updateHighscoresAfterMinutes = 60

	buyableAndSellableHouses = true
	houseNeedPremium = true
	bedsRequirePremium = true
	levelToBuyHouse = 1
	housesPerAccount = 0
	houseRentAsPrice = false
	housePriceAsRent = false
	housePriceEachSquare = 1000
	houseRentPeriod = "never"
	houseCleanOld = 0
	guildHalls = false


	timeBetweenActions = 200
	timeBetweenExActions = 1000
	hotkeyAimbotEnabled = true


	mapName = "server"
	mapAuthor = "Komic"
	randomizeTiles = true
	storeTrash = true
	cleanProtectedZones = true
	mailboxDisabledTowns = "-1"


	defaultPriority = "high"
	niceLevel = 5
	coresUsed = "-1"


	optimizeDatabaseAtStartup = true
	removePremiumOnInit = true
	confirmOutdatedVersion = false

	formulaLevel = 5.0
	formulaMagic = 1.0
	bufferMutedOnSpellFailure = false
	spellNameInsteadOfWords = false
	emoteSpells = false


	allowChangeOutfit = true
	allowChangeColors = true
	allowChangeAddons = true
	disableOutfitsForPrivilegedPlayers = false
	addonsOnlyPremium = true

	dataDirectory = "data/"
	bankSystem = true
	displaySkillLevelOnAdvance = false
	promptExceptionTracerErrorBox = true
	separateViplistPerCharacter = false
	maximumDoorLevel = 500
	maxMessageBuffer = 4

	saveGlobalStorage = true
	useHouseDataStorage = false
	storePlayerDirection = false


	checkCorpseOwner = true
	monsterLootMessage = 3
	monsterLootMessageType = 25


	ghostModeInvisibleEffect = false
	ghostModeSpellEffects = true

	idleWarningTime = 14 * 60 * 1000
	idleKickTime = 15 * 60 * 1000
	expireReportsAfterReads = 1
	playerQueryDeepness = 2
	maxItemsPerPZTile = 0
	maxItemsPerHouseTile = 0


	freePremium = false
	premiumForPromotion = true

	blessingOnlyPremium = true
	blessingReductionBase = 30
	blessingReductionDecreament = 5
	eachBlessReduction = 8


	experienceStages = false
	rateExperience = 5.0
	rateExperienceFromPlayers = 0
	rateSkill = 3.0
	rateMagic = 3.0
	rateLoot = 2.0
	rateSpawn = 1


	rateMonsterHealth = 1.0
	rateMonsterMana = 1.0
	rateMonsterAttack = 1.0
	rateMonsterDefense = 1.0


	minLevelThresholdForKilledPlayer = 0.9
	maxLevelThresholdForKilledPlayer = 1.1


	rateStaminaLoss = 1
	rateStaminaGain = 3
	rateStaminaThresholdGain = 12
	staminaRatingLimitTop = 41 * 60
	staminaRatingLimitBottom = 14 * 60
	rateStaminaAboveNormal = 1.5
	rateStaminaUnderNormal = 0.5
	staminaThresholdOnlyPremium = true

	experienceShareRadiusX = 30
	experienceShareRadiusY = 30
	experienceShareRadiusZ = 1
	experienceShareLevelDifference = 2 / 3
	extraPartyExperienceLimit = 20
	extraPartyExperiencePercent = 5
	experienceShareActivity = 2 * 60 * 1000

	globalSaveEnabled = false
	globalSaveHour = 8
	shutdownAtGlobalSave = true
	cleanMapAtGlobalSave = false


	deSpawnRange = 2
	deSpawnRadius = 50

	maxPlayerSummons = 2
	teleportAllSummons = false
	teleportPlayerSummons = false

	ownerName = ""
	ownerEmail = "@otland.net"
	url = "http://otland.net/"
	location = "Europe"
	displayGamemastersWithOnlineCommand = false

	adminLogsEnabled = false
	displayPlayersLogging = true
	prefixChannelLogs = ""
	runFile = ""
	outLogName = ""
	errorLogName = ""
	truncateLogsOnStartup = false
 
Upvote 0 Downvote
xitoz2 said:
1. set encryptionType = "plain" to sha1

2. try localHost instead of 127.0.0.1

3. is your user and pass 'test' ?
Click to expand...

1. I have tried with a sha1 pass and can open the ot server with it, but when trying to setup the website the Can't connect to MySQL database. remains.

2. It was standard on localHost and with it i recived this error
[21/07/2012 23:26:31] Failed connecting to database - MYSQL ERROR: Can't connect to MySQL server on 'localhost' (10061) (2003)

[21/07/2012 23:26:31] > ERROR: Couldn't estabilish connection to SQL database!

so i made i post about it http://otland.net/f16/problem-sql-video-filmet-163538/ and got the tip to change localHost to 127.0.0.1 and the server went online.¨

3. To make it simple for your guys its user:test and pass:test when i get this to work it will be a sha1 pass with diffirent username

Hope you can help me out
 
Upvote 0 Downvote
It's either your user/pw that's wrong or.... nothing? Nothing should prevent you from connecting to the database unless your mysql credentials are setup correctly (Well there's many more, but most likely not in this case).


And you said this is for your website? Did you edit config.php?
 
Upvote 0 Downvote
Code: 
/* Authentication section */
$cfg['Servers'][$i]['auth_type']       = 'cookie';  // Authentication method (config, http or cookie based)?
$cfg['Servers'][$i]['user']            = 'root';    // MySQL user
$cfg['Servers'][$i]['password']        = $password; // MySQL password (only needed with 'config' auth_type)
$cfg['Servers'][$i]['AllowNoPassword'] = false;     // Must use password

/* Server parameters */
$cfg['Servers'][$i]['verbose']      = 'Uniform Server'; // Verbose name for this host - leave blank to show the hostname
$cfg['Servers'][$i]['host']         = '127.0.0.1';      // MySQL hostname or IP address
$cfg['Servers'][$i]['port']         = $port_ini;        // Port set in ini See above
$cfg['Servers'][$i]['socket']       = '';               // Leave blank for default socket
$cfg['Servers'][$i]['connect_type'] = 'tcp';            // How to connect to MySQL server ('tcp' or 'socket')
$cfg['Servers'][$i]['extension']    = 'mysqli';         // MySQL extension to use ('mysql' or 'mysqli')
$cfg['Servers'][$i]['compress']     = false;            // No compression


/* PMA User advanced features */
$cfg['Servers'][$i]['controluser']    = 'pma';
$cfg['Servers'][$i]['controlpass']    = '12345678';

The pma password and config to cookie

This is what i changed in the config.inc.php file


btw before i changed pma pass in here to 12345678 i had this error

Connection for controluser as defined in your configuration failed.
 
Last edited:
Upvote 0 Downvote
Iam not using Xampp, using uniform server. Anyway, when i had xampp before it worked but i heard uniform server is much more secured
 
Upvote 0 Downvote
Okey, Try removed all the NOTES, ex. " NOTE: managerPassword left blank disables manager. " and removed all the help text above, ex. " monsterLootMessage 0 to disable, 1 - only party, 2 - only player, 3 - party or player (like Tibia's) "..

and Works.
 
Upvote 0 Downvote
Back
Top