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

Localhost problem

U

Ussef

New Member
Joined
May 27, 2009
Messages
123
Reaction score
2
Can't connect to MySQL server on 'localhost' (10061) .. i get this error whenever i put local host on mysql
but when i change it to 127.0.0.1 it works but it doesnt work globally so i guess this is my problem for the server so please
could u tell me how to make it work on localhost.

-- MySQL
mysqlHost = "127.0.0.1"
 
Sort by date Sort by votes
-- The Forgotten Server Config

-- Account Manager
accountManager = "yes"
newPlayerChooseVoc = "yes"
newPlayerSpawnPosX = 824
newPlayerSpawnPosY = 885
newPlayerSpawnPosZ = 7
newPlayerTownId = 1
newPlayerLevel = 1
newPlayerMagicLevel = 0
generateAccountNumber = "no"

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

-- Battle
worldType = "pvp"
hotkeyAimbotEnabled = "yes"
protectionLevel = 100
killsToRedSkull = 6
killsToBlackSkull = 12
pzLocked = 50000
deathLosePercent = 2
criticalHitChance = 7
removeAmmoWhenUsingDistanceWeapon = "yes"
removeChargesFromRunes = "yes"
removeChargesFromWeapons = "yes"
timeToDecreaseFrags = 24 * 60 * 60 * 1000
whiteSkullTime = 15 * 60 * 1000
oldConditionAccuracy = "no"
stairJumpExhaustion = 1400
stairJumpExhaustion = 2000

-- Commands
displayGamemastersWithOnlineCommand = "no"

-- Connection Config
ip = "41.42.25.16"
bindOnlyGlobalAddress = "no"
loginProtocolPort = 7171
gameProtocolPort = 7172
adminProtocolPort = 7171
statusProtocolPort = 7171
loginTries = 10
retryTimeout = 5 * 1000
loginTimeout = 60 * 1000
maxPlayers = "50"
motd = "Welcome the Zombie Apocalypse!"
onePlayerOnlinePerAccount = "no"
allowClones = "no"
serverName = "ZA"
loginMessage = "Think you got what it takes to survive in this world?, dont forget that you can buy meat by using the !meat command ;)"
adminLogsEnabled = "no"
statusTimeout = 5 * 60 * 1000
replaceKickOnLogin = "yes"


-- Guilds
ingameGuildSystem = "yes"
levelToCreateGuild = 50
minGuildNameLength = 4
maxGuildNameLength = 20

-- Highscores
highscoreDisplayPlayers = 15
updateHighscoresAfterMinutes = 60

-- Houses
housePriceEachSQM = 1000
houseRentPeriod = "never"

-- Idle
kickIdlePlayerAfterMinutes = 10

-- Item Usage
timeBetweenActions = 200
timeBetweenExActions = 1000

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

-- Market
marketEnabled = "yes"
marketOfferDuration = 30 * 24 * 60 * 60
premiumToCreateMarketOffer = "yes"
checkExpiredMarketOffersEachMinutes = 60
maxMarketOffersAtATimePerPlayer = 100

-- Messaging
maxMessageBuffer = 4

-- MySQL
mysqlHost = "127.0.0.1"
mysqlUser = "******"
mysqlPass = "******"
mysqlDatabase = "*****"
mysqlPort = 3306

-- Premium Account
freePremium = "yes"

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

-- Rates
rateExp = 1
rateSkill = 20
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 = 1
shutdownAtServerSave = "no"
cleanMapAtServerSave = "yes"

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

-- Spawns
deSpawnRange = 2
deSpawnRadius = 50

-- SqLite
sqliteDatabase = "forgottenserver.s3db"

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

-- Startup
defaultPriority = "high"
startupDatabaseOptimization = "yes"

-- Shutdown
freeMemoryAtShutdown = "yes"

-- Status
ownerName = ""
ownerEmail = "@otland.net"
url = "http://otland.net/"
location = "Europe"
 
Upvote 0 Downvote
Programmer said:
Have you tried running it with "localhost" rather than "127.0.0.1"?
Click to expand...

Ofcourse he tried it.
That is what hes problem is.
Read the content next time lol.

So basicly when u put in mysql "localhost " in config.lua, u get a error when u launch the server. -> At phpmyadmin when u made the user what did u choosed at "host"? : "localhost" or "127.0.0.1" or Something else like ur ip-adress?
 
Upvote 0 Downvote
Ive portforwarded my server and made the mysql page work and linked it with my server but the idea is that whenever i enter to my server .. i press start game in tibia and write any account number or password and it says loading char and then it vanishes and it keeps happening it doesnt give me server disconnected or anything it just vanishes . so i guess its from the localhost or something related to the database because when i put localhost the server doesnt start but when i put 127.0.0.1 it works only locally. ..
because when i log from my local ip it works just fine but when i log on from the global ip 41.42.25.16 it doesnt work and the screen vanishes. i dont know what the problem is .. when i check my portforward it says that its working and im putting the right ip which is 41.42.25.16 .. i dont know what is wrong ...
 
Upvote 0 Downvote
Ussef said:
Ive portforwarded my server and made the mysql page work and linked it with my server but the idea is that whenever i enter to my server .. i press start game in tibia and write any account number or password and it says loading char and then it vanishes and it keeps happening it doesnt give me server disconnected or anything it just vanishes . so i guess its from the localhost or something related to the database because when i put localhost the server doesnt start but when i put 127.0.0.1 it works only locally. ..
because when i log from my local ip it works just fine but when i log on from the global ip 41.42.25.16 it doesnt work and the screen vanishes. i dont know what the problem is .. when i check my portforward it says that its working and im putting the right ip which is 41.42.25.16 .. i dont know what is wrong ...
Click to expand...

Then just login with the ipv4 adress. cmd > ipconfig > scroll down and u see ipv4 adress. use that one.
 
Upvote 0 Downvote

Similar threads

Steven92
  • Question
Solved database connection issue
Replies
2
Views
276
highsanta
highsanta
E
  • Question
how to have an woking theforgottenserver 1.2 due to a prob of mysql and sha2?
Replies
2
Views
426
PuszekLDZ
PuszekLDZ
E
  • Question
Windows otclientv8 do not connects to remote ip instead it uses local ip
Replies
3
Views
270
Tenzhiro
Tenzhiro
O
  • Question
Solved Mysql disconnect problems /Myaac
Replies
4
Views
401
Ownerchrissi
O
P
  • Question
Solved [TFS 1.4] OTClient won't log in (Error 11001)
Replies
0
Views
736
Pidign
P
Epsilons
  • Question
OTClient Stuck on "Please wait : Connecting to login server" (ERROR: got a network message with invalid checksum)
Replies
10
Views
683
Epsilons
Epsilons
R
  • Question
OTClient RSA KEY.PEM rare problem... please someone?
Replies
3
Views
252
revelationsbr
R
Drucken
  • Question
TFS 1.X+ 2 server 1 mysql server
Replies
3
Views
347
Drucken
Drucken
F
  • Question
Cant start my server?
Replies
0
Views
98
frolic
F
E
  • Question
Windows cant connect with port 7172 on local lan "connection failes error 10061"
Replies
1
Views
275
cs007
cs007
Back
Top