Windows When logging into my server, the "Your character list is being loaded." pops up then exits

[person551]

I can't log into my server.

This is the guide I'm following: https://otland.net/threads/your-first-open-tibia-server.140934/

I did everything up until the third part. Port 80 is in use for my router, so I forwarded port 8080 instead (I managed to get this working without forwarding port 80 before. I don't want to make the server public, I just want to play it myself.)

Right now I'm trying to log into my server to test it, and I've tried several things, each ending in either a response: "Clients only 10.41 accepted!" or it goes to the "Your character list is being loaded." and then the pop up exits, leaving me on the art work screen in the tibia client.

What IP should I be using in the IP changer? I tried 127.0.0.1, my external IP, and the IPv4 I saw on the command prompt. What else do I need to know or do? Thanks in advance.

 

[Shyzoul]

This is the guide I'm following: Your First Open Tibia Server

since youre trying to do a playground server, ill try to write the quickly way as possible to connect to the server, follow carefully each step
1: download the server, i suggest tfs 1.2, but can be any you want.
32bit https://github.com/otland/forgottenserver/releases/download/v1.2/theforgottenserver-v1.2-win32.zip
64bit https://github.com/otland/forgottenserver/releases/download/v1.2/theforgottenserver-v1.2-win64.zip
2: download your database server manager (uni server z)
https://sourceforge.net/projects/miniserver/files/latest/download?source=files
3: download correct client to server version (for tfs 1.2 you can 10.97 or 10.98)
http://************/windows.php
4: extract UniServerZ and theforgottenserver.zip, open UniServerZ folder and run UniController.exe, in a first time it will ask a password to root user, you can type 123, when it displays the main menu you click in start MySQL button, then click in MySQL Console, you should see a CLI window, paste these commands there: (dont forget semicolon at end)
Create a database that your server will connect to

CREATE DATABASE my_server_db;

Select the database you've created to make modifications you need

USE my_server_db;

ok now you need to pay attention, you will import a db schema that server use, you can find it on server you've previously downloaded root folder, the file is schema.sql, you need tell mysql the path to find it. if you're copying the path from Windows Explorer, change all backslashs (C:\this\is\wrong) to fowardslashs (C:/this/is/okay)

source C:/Users/user_name/Downloads/theforgottenserver-v1.2-win64/schema.sql;

you should see some Query Ok messages, without any errors or warnings, now create your account and character to play.

INSERT INTO accounts (id,name,password,type,premdays) VALUES("1","123qwe","05fe7461c607c33229772d402505601016a7d0ea",6,365);

now you have an account, your account name and password is 123qwe, lets create a character

INSERT INTO players (name,group_id,account_id,town_id) VALUES("Admin",3,1,2);

ok now you have an admin player to play, you can close mysql CLS window (DONT STOP MySQL, just close the command window), now youre configuring the server
open config.lua in your server folder, scroll down until you see your -- MySQL settings
change:
mysqlUser = "forgottenserver"
to user root, you didnt create other than root because if it's a playground server, you can use root user just fine, it should be:
mysqlUser = "root"
now
mysqlPass = ""
you've choosen the password 123 so,
mysqlPass = "123"
last but not least
mysqlDatabase = "forgottenserver"
you've create one with a different name previously
mysqlDatabase = "my_server_db"
save and close the file.
5: run theforgottenserver.exe wait until you see a message "Forgotten Server Online!", open your ip changer, (you can use localhost or 127.0.0.1, they are the same), enter your account:123qwe password:123qwe, enjoy =)
every time you want to start the server, open uni server z, click in start MySQL, run theforgottenserver.exe.

 

[person551]

Thank you very much for the reply. It has been very helpful.

I did get one warning while doing the CLS window stuff, but it didn't prevent me from logging on.

How do I create a normal character? I want it to be a male knight. I tried messing around with it, and I made a few characters, but they each had 0 capacity.

Is there an easier way to do this? I'm not very good with CLS...

Also, how do I add premium time?

EDIT: I've made a few characters and now there's no premium time left. I don't know what happened. Is there anyway to do the account manager like my old server? It seems much easier.

Also I think I've changed my mind. I want the server to be open to a few friends. I don't think I need a website, but how do I make it playable for them? Sorry for the inconvenience.

If you could point me in the direction of a good tutorial, I could give it a try myself. Or if you could provide me with one, either way . Thanks in advance!

 

[Shyzoul]

Also, how do I add premium time?

go to config.lua search for freePremium, set to true.

Also I think I've changed my mind. I want the server to be open to a few friends. I don't think I need a website, but how do I make it playable for them? Sorry for the inconvenience.

With server, it's already playable, your problem is router port forwarding, while your server is running try with this tool http://************/portchecker.php, if it says closed, then you need to forward your router ports 7171 and 7172, make a google search with "router brand port forwarding", if even youre sure your router is fowarded for those ports and portchecker still returning "closed", probably it is a problem in anti-virus/windows firewall rules, here i cant help you out, i ever used linux for networking stuff, however, im sure you can find these tutorials here on otland.

EDIT: I've made a few characters and now there's no premium time left. I don't know what happened. Is there anyway to do the account manager like my old server? It seems much easier.

im not aware of any server with account manager, afaik znote's aac is easy to install btw(https://github.com/Znote/ZnoteAAC), anyway, for convenience i've just wrote these scripts(talkactions), didn't tested, let me if it is buggy.
https://gist.github.com/wgrriffel/b1f684683d142325510c43dc5c3f30a0

my plan of usage for it is
/newacc AccountName(required), Password(required, this must be in hashed as sha1, you can do it by seaching in google sha1 hash, try this one http://passwordsgenerator.net/sha1-hash-generator/), Type(optional, entries: admin, gm, senior tutor, tutor, default:normal)
e.g.: /newacc 123, 40BD001563085FC35165329EA1FF5C5ECBDBBEEF, admin
/newcharacter Name(required), accountId(required, when you create an account it should display that account id, or use accid_byname.lua script with player name, it will display account ID, vocation[optional: entries: knight, paladin, sorcerer, druid, default: knight], group_id[optional, entries: admin, gamemaster, default: player], gender[optional, entries: mele, female, default: mele])
e.g. /newchar Sorcerer, 2, sorcerer, player, male
/checkacc PlayerName
e.g.: /checkacc Sorcerer
everything that is optional means that if you dont fill, it will create with default value.
hope it works and be useful.

 

[person551]

Thanks so much! I have a new character who is exactly what I want.

I couldn't get the new account command to work though. I entered in the format you listed and it returned in the chat menu the specifics, but then I couldn't log onto that account. The new character command worked perfectly however.

The last command, which checks the player account number, works as well.

I couldn't get port 80 to forward because it's in use by my router (ZyXel), so anyone that can help me with that would be much appreciated.

Thanks a lot Shyzoul. You've been a real help.

 

[Shyzoul]

I couldn't get the new account command to work though. I entered in the format you listed and it returned in the chat menu the specifics, but then I couldn't log onto that account. The new character command worked perfectly however.

i read this twice, couldnt find nothing wrong with code, only thing i can think of is that if server doesnt get all letters to lower case by itself, in this case, ive update the script to double check it, can you copy&paste create_account.lua again and see if it is fixed? as a reminder to changes take effect you must have to type /reload talkactions after you replaced the code with new one.

 

[person551]

I repasted the code as you asked, then restarted the server. It still has the same problem: the chat returns the information, but when I go to log into the account it says that the account number or password isn't correct.

EDIT: I can just create new accounts using the CLS window right? So this isn't a huge problem.

 

[Shyzoul]

I repasted the code as you asked, then restarted the server. It still has the same problem: the chat returns the information, but when I go to log into the account it says that the account number or password isn't correct.

are you using the SHA-1 hash as password right? i mean, if you want 123 password you should use 40BD001563085FC35165329EA1FF5C5ECBDBBEEF not 123,
/newacc 123, 40BD001563085FC35165329EA1FF5C5ECBDBBEEF

edit:
try other sha1 hash website, http://www.sha1-online.com/

 

[person551]

It works with the new website you provided. Thank you!