Issue with Connecting to my OT

[Stykyz]

Hey there,

First off let me say I did use the search function and the solutions I found did not work.

Here's the problem. I'm able to launch my server just fine, but I can't connect to it. This wasn't an issue until recently. I'm stuck at the character list loading.

Things I have checked.
-Proper ports are open and are showing as open on various port checking sites.
-Windows Firewall is disabled
-Reset Router, Cable Modem and PC.
-Ensure the FREE DNS is working correctly. (I have an AAC on same domain, working fine.)
-Have put my PC on a DMZ to test connection, still no luck.

I don't know if this has anything to do with it but it seems like the trouble started after I disabled Account Manager.

Have tried reenabling but still nothing.

Spoiler: My Server CONFIG

-- The Forgotten Server Config

-- Account Manager
accountManager = "no"
newPlayerChooseVoc = "no"
newPlayerSpawnPosX = 52
newPlayerSpawnPosY = 51
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 = 1
killsToRedSkull = 3
killsToBlackSkull = 6
pzLocked = 60000
criticalHitChance = 7
removeAmmoWhenUsingDistanceWeapon = "yes"
removeChargesFromRunes = "yes"
removeChargesFromWeapons = "yes"
timeToDecreaseFrags = 24 * 60 * 60 * 1000
whiteSkullTime = 15 * 60 * 1000
oldConditionAccuracy = "no"
stairJumpExhaustion = 2000

-- Commands
displayGamemastersWithOnlineCommand = "no"

-- Connection Config
ip = "127.0.0.1"
bindOnlyGlobalAddress = "false"
loginProtocolPort = 7171
gameProtocolPort = 7172
adminProtocolPort = 7171
statusProtocolPort = 7171
loginTries = 10
retryTimeout = 5 * 1000
loginTimeout = 60 * 1000
maxPlayers = "1000"
motd = "XXX"
onePlayerOnlinePerAccount = "yes"
allowClones = "no"
serverName = "XXX"
loginMessage = "XXX"
adminLogsEnabled = "no"
statusTimeout = 5 * 60 * 1000
replaceKickOnLogin = "yes"

-- Death
-- note: Leave deathLosePercent as -1 if you want to use Tibia's
-- death penalty formula. For the old formula, set it to 10. For
-- no skill/experience loss, set it to 0.
deathLosePercent = -1
deathListEnabled = "yes"
maxDeathRecords = 5

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

-- Highscores
highscoreDisplayPlayers = 15
updateHighscoresAfterMinutes = 60

-- Houses
housePriceEachSQM = 1000
houseRentPeriod = "never"

-- Idle
kickIdlePlayerAfterMinutes = 15

-- Item Usage
timeBetweenActions = 200
timeBetweenExActions = 1000

-- Map
mapName = "XXX"
mapAuthor = "Misc"
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 = "XXX"
mysqlPass = "XXX"
mysqlDatabase = "XXX"
mysqlPort = 3306

-- Premium Account
freePremium = "no"

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

-- Rates
rateExp = 7
rateSkill = 4
rateLoot = 3
rateMagic = 4
rateSpawn = 2

-- 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 = "sha1"

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

-- Shutdown
freeMemoryAtShutdown = "yes"

-- Status
ownerName = ""
ownerEmail = "@otland.net"
url = "http://otland.net/"
location = "Europe"

I have posted my CONFIG file. I have removed passwords and usernames for security reasons. Those are the "XXX".

Thanks for any insight you can give me.

 

[Breed]

Did you create your character through the AAC?
Check its x,y,z coordinates and make sure it matches that of what it says in config.lua

in config.php there is this on line 336

// Leave on black square in map and player should get teleported to their selected town.
    // If chars get buggy set this position to a beginner location to force players there.
    $config['default_pos'] = array(
        'x' => 5,
        'y' => 5,
        'z' => 2,
    );

I don't see anything that asks the database what the players position is initially when this is installed so you might need to update that code above.

 

[Stykyz]

Did you create your character through the AAC?
Check its x,y,z coordinates and make sure it matches that of what it says in config

I did create my character through AAC. The XYZ coordinates associated with the character should spawn him in correctly. Config is 50 50 7 and the SQL database shows 50 50 7.

Did you create your character through the AAC?
Check its x,y,z coordinates and make sure it matches that of what it says in config.lua

in config.php there is this on line 336

// Leave on black square in map and player should get teleported to their selected town.
    // If chars get buggy set this position to a beginner location to force players there.
    $config['default_pos'] = array(
        'x' => 5,
        'y' => 5,
        'z' => 2,
    );

I don't see anything that asks the database what the players position is initially when this is installed so you might need to update that code above.

I've attached a screenshot of how it all shows up.

 

[Breed]

Your config says this though, honestly I couldn't tell you what the problem could be, I would check everything comparing the config to the db to the map, townid, temple position, ip address, did you port forward your server? because right now its set to local host

-- The Forgotten Server Config

-- Account Manager
newPlayerSpawnPosX = 52
newPlayerSpawnPosY = 51
newPlayerSpawnPosZ = 7

-- Connection Config
ip = "127.0.0.1"

townid should be 1

newPlayerTownId = 1

 

[Stykyz]

I realized the config said that and changed it. One place I forgot to change it after you brought it to my attention And I am port forwarded.

I just changed from 127.0.0.1 to my no-ip dns address.

Still having the same issue.

Also changed town ID to 1.

Still stuck at your Character list is being loaded. Please Wait.

 

[Breed]

So it works?

restart the server

 

[Stykyz]

Still nothing.

I did notice my server is throwing an error about "Yellow Butterfly" "Rabbit" and "Deer" spawntime can not be less than 1 seconds. Would this cause the isue?

 

[Breed]

post your console window

if u want we dicuss this on skype

 

[Stykyz]

 

[Limos]

I did notice my server is throwing an error about "Yellow Butterfly" "Rabbit" and "Deer" spawntime can not be less than 1 seconds. Would this cause the isue?

Go to the spawn.xml file of your map and change the spawn time or readd them in the map.

 

[Stykyz]

Go to the spawn.xml file of your map and change the spawn time or readd them in the map.

Awesome, thank you! That fixed the issue with the spawn error.

About the other issue. I tried logging in with an account I know doesn't exist and even then I don't get "INcorrect accout name/password". It's like it's not even connecting to the server or trying to.

 

[Breed]

are you using a custom client or an ip changer? to connect?

 

[Stykyz]

I'm using an IP changer to connect. The OTLand IP Changer.

I just tried replacing the Config file as well as trying my luck at connecting with my localhost IP. Still nothing.

 

[Limos]

Are the passwords in the database in sha1? If not, change them.
http://www.sha1.cz/

 

[Stykyz]

Passwords are sha1.

 

[Breed]

I would restart everything, the web server, the ip changer, the client the server and then make sure everything matches, I would probably delete the account & characters made aswell

 

[Stykyz]

I am going to restart my PC then go ahead and re do the AAC, Server and SQL database. Thank you for your help and suggestions guys. I will report back if it fixes it.

 

[OwnerDurk]

well not really guys it aint got his ports working with the server just lettn u guys know

 

[Stykyz]

I figured i'd come back and let everyone know what the issue is and how it was resolved.

Someone failed to mention they had installed Skype on the PC I'm using to get this server setup before I move it to my box with virtual servers.

So port 443 was being used by Skype, but every PORT checker would say it was open.

I didn't realize it was on. I felt like such an idiot after I figured this out. I promptly uninstalled Skype and it worked.

(I have Skype on my phone, I don't need it on my PC.)

 

[Evan]

You can change the port that Skype uses through the options.