• 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!

Can't connect to MySQL database.

Showarn

Showarn

T
Joined
Jun 24, 2009
Messages
103
Reaction score
0
Location
Sweden
Hello i've portforwaded 7171/80/443/3306 and it works cuz ppls has been on my side when i used it for only counter strike and now iam putted in tibia website instead gesior account maker for mystic spirit 0.2.7 and i configured my config.lua this sqlite "mysql" Database user "root" and "password" etc but i get this error when i try to install website Can't connect to MySQL database. on check database connection any1 now what couses this?


thankz in advance ill rep+
 
Sort by date Sort by votes
yes i have xampp control panel running mysql and apache

here is the config

Code: 
-- The Forgotten Server Config

	-- Account Manager
	accountManager = "yes"
	newPlayerChooseVoc = "yes"
	newPlayerSpawnPosX = 32369
	newPlayerSpawnPosY = 32241
	newPlayerSpawnPosZ = 7
	newPlayerTownId = 5
	newPlayerLevel = 1
	newPlayerMagicLevel = 0
	generateAccountNumber = "yes"

	-- Banishments
	broadcastBanishments = "yes"
	banDays = 7
	finalBanDays = 30
	killsToBan = 5

	-- Battle
	worldType = "pvp"
	hotkeyAimbotEnabled = "yes"
	protectionLevel = 1
	killsToRedSkull = 3
	pzLocked = 60000
	deathLosePercent = 10
	criticalHitChance = 7
	removeAmmoWhenUsingDistanceWeapon = "yes"
	removeChargesFromRunes = "yes"
	timeToDecreaseFrags = 24 * 60 * 60 * 1000
	whiteSkullTime = 15 * 60 * 1000
	oldConditionAccuracy = "no"
	alternativeExhaust = 1000
	stairJumpExhaustion = 2000
	animationTextOnHeal = "yes"

	-- Commands
	displayGamemastersWithOnlineCommand = "no"

	-- Connection Config
	ip = "85.230.72.133"
	loginProtocolPort = 7171
	gameProtocolPort = 7172
	adminProtocolPort = 7171
	statusProtocolPort = 7171
	loginTries = 10
	retryTimeout = 5 * 1000
	loginTimeout = 60 * 1000
	maxPlayers = "1000"
	motd = "Welcome to the Forgotten Server!"
	onePlayerOnlinePerAccount = "yes"
	allowClones = "no"
	serverName = "Forgotten"
	loginMessage = "Welcome to the Forgotten Server!"
	adminLogsEnabled = "no"
	statusTimeout = 5 * 60 * 1000
	replaceKickOnLogin = "yes"

	-- Deathlist
	deathListEnabled = "yes"
	maxDeathRecords = 5

	-- Guilds
	ingameGuildSystem = "yes"

	-- Highscores
	highscoreDisplayPlayers = 15
	updateHighscoresAfterMinutes = 60

	-- Houses
	housePriceEachSQM = 1000
	houseRentPeriod = "never"

	-- Idle
	kickIdlePlayerAfterMinutes = 15

	-- Item Usage
	timeBetweenActions = 200
	timeBetweenExActions = 1000

	-- Map
	mapName = "forgotten"
	mapAuthor = "Komic"
	randomizeTiles = "yes"
	mapStorageType = "relational"

	-- Messaging
	enableRuleViolationReports = "no"
	maxMessageBuffer = 4

	-- MySQL
	mysqlHost = "mysql"
	mysqlUser = "root"
	mysqlPass = "365367"
	mysqlDatabase = "tibia"
	mysqlPort = 3306

	-- Premium Account
	freePremium = "no"

	-- PVP Server
	displayOnOrOffAtCharlist = "no"
	allowChangeOutfit = "yes"
	noDamageToSameLookfeet = "no"
	experienceByKillingPlayers = "no"

	-- Rates
	rateExp = 5
	rateSkill = 3
	rateLoot = 2
	rateMagic = 3
	rateSpawn = 1

	-- Real Server Save
	-- note: serverSaveHour means like 03:00, not that it will save every 3 hours,
	-- if you want such a system use autoSaveEachMinutes. this serversave method
	-- may be unstable, we recommend using otadmin if you want real serversaves.
	serverSaveEnabled = "no"
	serverSaveHour = 3
	shutdownAtServerSave = "yes"
	cleanMapAtServerSave = "yes"

	-- Server saving
	autoSaveEachMinutes = 15
	saveGlobalStorage = "no"

	-- Spawns
	deSpawnRange = 2
	deSpawnRadius = 50

	-- SqLite
	sqliteDatabase = "forgottenserver.s3db"

	-- SQL
	sqlType = "mysql"
	passwordType = "plain"

	-- Startup
	defaultPriority = "high"

	-- Shutdown
	freeMemoryAtShutdown = "yes"

	-- Status
	ownerName = ""
	ownerEmail = ""
	url = ""
	location = "Europe"
 
Upvote 0 Downvote
Try this..

Lua: 
-- The Forgotten Server Config

	-- Account Manager
	accountManager = "yes"
	newPlayerChooseVoc = "yes"
	newPlayerSpawnPosX = 32369
	newPlayerSpawnPosY = 32241
	newPlayerSpawnPosZ = 7
	newPlayerTownId = 5
	newPlayerLevel = 1
	newPlayerMagicLevel = 0
	generateAccountNumber = "yes"

	-- Banishments
	broadcastBanishments = "yes"
	banDays = 7
	finalBanDays = 30
	killsToBan = 5

	-- Battle
	worldType = "pvp"
	hotkeyAimbotEnabled = "yes"
	protectionLevel = 1
	killsToRedSkull = 3
	pzLocked = 60000
	deathLosePercent = 10
	criticalHitChance = 7
	removeAmmoWhenUsingDistanceWeapon = "yes"
	removeChargesFromRunes = "yes"
	timeToDecreaseFrags = 24 * 60 * 60 * 1000
	whiteSkullTime = 15 * 60 * 1000
	oldConditionAccuracy = "no"
	alternativeExhaust = 1000
	stairJumpExhaustion = 2000
	animationTextOnHeal = "yes"

	-- Commands
	displayGamemastersWithOnlineCommand = "no"

	-- Connection Config
	ip = "85.230.72.133"
	loginProtocolPort = 7171
	gameProtocolPort = 7172
	adminProtocolPort = 7171
	statusProtocolPort = 7171
	loginTries = 10
	retryTimeout = 5 * 1000
	loginTimeout = 60 * 1000
	maxPlayers = "1000"
	motd = "Welcome to the Forgotten Server!"
	onePlayerOnlinePerAccount = "yes"
	allowClones = "no"
	serverName = "Forgotten"
	loginMessage = "Welcome to the Forgotten Server!"
	adminLogsEnabled = "no"
	statusTimeout = 5 * 60 * 1000
	replaceKickOnLogin = "yes"

	-- Deathlist
	deathListEnabled = "yes"
	maxDeathRecords = 5

	-- Guilds
	ingameGuildSystem = "yes"

	-- Highscores
	highscoreDisplayPlayers = 15
	updateHighscoresAfterMinutes = 60

	-- Houses
	housePriceEachSQM = 1000
	houseRentPeriod = "never"

	-- Idle
	kickIdlePlayerAfterMinutes = 15

	-- Item Usage
	timeBetweenActions = 200
	timeBetweenExActions = 1000

	-- Map
	mapName = "forgotten"
	mapAuthor = "Komic"
	randomizeTiles = "yes"
	mapStorageType = "relational"

	-- Messaging
	enableRuleViolationReports = "no"
	maxMessageBuffer = 4

	-- MySQL
	sqlHost = "mysql"
	sqlUser = "root"
	sqlPass = "365367"
	sqlDatabase = "tibia"
	sqlPort = 3306

	-- Premium Account
	freePremium = "no"

	-- PVP Server
	displayOnOrOffAtCharlist = "no"
	allowChangeOutfit = "yes"
	noDamageToSameLookfeet = "no"
	experienceByKillingPlayers = "no"

	-- Rates
	rateExp = 5
	rateSkill = 3
	rateLoot = 2
	rateMagic = 3
	rateSpawn = 1

	-- Real Server Save
	-- note: serverSaveHour means like 03:00, not that it will save every 3 hours,
	-- if you want such a system use autoSaveEachMinutes. this serversave method
	-- may be unstable, we recommend using otadmin if you want real serversaves.
	serverSaveEnabled = "no"
	serverSaveHour = 3
	shutdownAtServerSave = "yes"
	cleanMapAtServerSave = "yes"

	-- Server saving
	autoSaveEachMinutes = 15
	saveGlobalStorage = "no"

	-- Spawns
	deSpawnRange = 2
	deSpawnRadius = 50

	-- SqLite
	sqliteDatabase = "forgottenserver.s3db"

	-- SQL
	sqlType = "mysql"
	passwordType = "plain"

	-- Startup
	defaultPriority = "high"

	-- Shutdown
	freeMemoryAtShutdown = "yes"

	-- Status
	ownerName = ""
	ownerEmail = ""
	url = ""
	location = "Europe"
 
Upvote 0 Downvote
Code: 
install = "2"
server_path = "C:/Users/ShowarN/Desktop/Mystic Spirit/"
houseXML_file_subdir = "data\world\forgotten-house.xml"
vocationXML_file_subdir = "data\XML\vocations.xml"
subfolder = ""
forum_link = ""
logo_monster = "Demon"
layout = "tibiacom"
layouts = "rasta,tibiacom,darkritual"
send_emails = "no"
mail_address = "[email protected]"
smtp_enabled = "yes"
smtp_host = "smtp.poczta.onet.pl"
smtp_port = "25"
smtp_auth = "yes"
smtp_user = "[email protected]"
smtp_pass = "qwerty1"
email_lai_sec_interval = "300"
one_email = "yes"
account_number = "custom"
email_days_to_change = "1"
max_players_per_account = "10"
char_type = "main"
char_rook_name = "Rook Sample"
char_vocations = ""
towns_list = "2,Thais:5,Carlin:7,Venore:9,Edron:11,Darashia:1,Ab'Dendriel"
show_mlvl = "1"
show_creationdate = "1"
guild_need_level = "8"
guild_need_pacc = "no"
guild_image_size_kb = "50"
guild_description_chars_limit = "1000"
guild_description_lines_limit = "6"
guild_motd_chars_limit = "150"
access_tickers = "1"
access_news = "2"
access_admin_panel = "3"
last_deaths_limit = "30"
news_ticks_limit = "5"
news_big_limit = "3"
show_vip_status = "1"
show_vip_storage = "0"
vocations_list = "None,Sorcerer,Druid,Paladin,Knight,Master Sorcerer,Elder Druid,Royal Paladin,Elite Knight"
vocations_short_list = "None,Sorcerer,Druid,Paladin,Knight,MS,ED,RP,EK"
darkborder = "#D4C0A1"
lightborder = "#F1E0C6"
vdarkborder = "#505050"
verify_code = "yes"
players_group_id_block = "2"
shop_system = "0"
download_page = "1"
serverinfo_page = "1"
verify_code_shop = "no"
newaccount_premdays = "3"
gallery_page = "0"
signatures = "0"
news_title_color = "white"

yepp xampp is running :/
 
Upvote 0 Downvote
got exactly the same problem but i use uniserver anyone got fix for this?

- - - Updated - - -

amiroslo said:
install = "2"
to
install = "1"
Click to expand...

OMFG! this worked! ive been searching like an fucking dog for some explaination to my problem and this solved it!!


Rep+ to you sir!
 
Upvote 0 Downvote

Similar threads

Steven92
  • Question
Solved database connection issue
Replies
2
Views
398
highsanta
highsanta
Back
Top