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

SQL, SQLite...wait

R

Reese

New Member
Joined
Apr 26, 2013
Messages
14
Reaction score
0
I've been out of the OT world for awhile, and I just recently tried to host again ... But I've run into many problems.

First problem:

Everything works fine, I can log in and my friend can log in. The server we're using (FTS) has the AM start off on a solo island - with no way to get off, it seems. Doesn't matter, I'll just create two God characters because we're only roleplaying. I go into PHPMyadmin, "Players" ... and nothing. The characters we just created aren't there. Go into "Accounts" and the accounts aren't there either ... odd. I did some research, and I went into config.lua and changed "Sqlite" to "MySql" thinking that would be the problem. Try and reopen my server and get "SQL can not connect" and it shuts down.

Second problem:

After that, I looked up SQlite and downloaded something that was sort of like PHPmyadmin. I upload the server and go into characters and the previously created characters are there! I changed them into gods, turned "MySql" back into "Sqlite" like the original had, and turned on my server ... and nothing happened or changed.

So we're stuck on this island with regular characters and no where to go and nothing to do.

Before anyone asks, I changed the config.lua to my IP and all the other stuff that you usually do. I've tried looking in the tutorials and used the search engine, but I turn up nothing. If anyone knows what I can do, how to fix it, how to link my server with the Sqlite thing, a tutorial that will set me straight ... that would be great! Thanks.
 
Sort by date Sort by votes
Last edited:
Upvote 0 Downvote
How I edit the SQLite database:

I use SQLite Expert Personal.
Run SQLite Expert Personal.
File -> Open Database.
Go to your server folder.
Change File Type to "All Files".
Open theforgottenserver.s3db.
Then you can modify data.
 
Upvote 0 Downvote
@can't leave the map

You're running the tfs map? you need to add scripts etc to it.. If you take a look on the map editor you start on a small island. You will either need to add the npcs/scripts that are appropriate or use a different map
 
Upvote 0 Downvote
Thank you for all the help :)

I'm following the tutorial now, and I ran into a problem with the OT shutting off because of the SQL change, but I changed "localhost" into the 127. IP. Everything seems to be working and I can log on from this computer, but I'm having one more issue.

I'm not sure if anyone else can log in, but I've had this problem before.
I'm using another computer to log in (same internet connection) and I get to the character log in screen, click "Account Manager", it loads for awhile, but it gives me a connection time out error.

Port 7171, 7172 and 80 are open, firewall and virus scanner are turned off (to test if that was an issue), I've added the three ports to my firewall, the IP in config.lua is the IP I got from whatismyup.
I don't use that IP in the IP changer though, I use my IPv4.
I've tried using the IP I got from whatismyip, "localhost" and other endings for the IPv4 one.

Any ideas?
 
Upvote 0 Downvote
If you can see the characterlist this means everything around port 7171 (loginport) is correct. So check if you did everything around port 7172 the same way and if the gameport in config.lua is also 7172.
From the computer you host the server on you need to login with 127.0.0.1 or your IPv4 address, from an other computer you need to login with the ip from www.whatismyip.com, same as you have in config.lua
 
Upvote 0 Downvote
Well, my config.lua looks like:

-- Connection Config
ip = "IP I got from what is my ip"
bindOnlyGlobalAddress = "no"
loginProtocolPort = 7171
gameProtocolPort = 7172
adminProtocolPort = 7171
statusProtocolPort = 7171

And:

-- MySQL
mysqlHost = "127.0.0.1"
mysqlUser = "myservername"
mysqlPass = "password I picked"
mysqlDatabase = "servernameagain"
mysqlPort = 3306

I went to a port checker and:
Port 7172 is open on my IP
And on another site to double check:
Success: I can see your service on myipaddress on port (7172)
Your ISP is not blocking port 7172
I have PFPortchecker, and that also says 7172 is open.

So 7172 is open.

I tried logging on with the IP I got from whatismyip and now I don't even get to see the character screen, just the "Your character list is being loaded." message.
 
Upvote 0 Downvote
Try using "localhost" or your local IP-address (192.168.X.X) in the IP-changer, this usually solved it for me.
 
Upvote 0 Downvote
@Evan: When I put in the 192.168.x.x IP, it brings me to the character page and when I try to log in it gives me the connection time out screen. If I use the "localhost", it jumps right to "connection timeout".
@Limos: Yeah, I used the IPv4 address to open all of the ports.

Edit:

I'm able to log into my server with the hosting computer, other people are able to log on, I'm just not able to log onto my server with my laptop (same network)
I've tried many IPs (the IP found on http://www.whatismyip.com/, 127.0.0.1, 192.168.x.x (the IPv4 I used is from my host computer and laptop computer), localhost - still nothing)
 
Last edited:
Upvote 0 Downvote
If possible, it may help if you post a screenshot of your port forwarding configurations. It's possible that you've mistakingly forwarded to the wrong port, or used the wrong protocol etc. There is no reason why this should be an issue except for port forwarding and IP configuration. Note that your IP in the configuration should not begin with 192.168, this is a generic local IP address, used on your own network to identify your machine, not a global IP.
 
Upvote 0 Downvote
fdgslkdj.jpg

That's the portforwarding configuration.
-- Connection Config
ip = "24.141.***.**"

Other people are able to log in, and I'm able to log in on my host computer so I don't think it's an issue of portforwarding. I'm just not able to log on with my laptop (that shares the same network as my host computer)
 
Upvote 0 Downvote
You've tried every IP imaginable? (for the laptop IP-changer).
192.168.0.100?
Global IP-address (whatismyip)?
localhost?
 
Upvote 0 Downvote
Reese said:
@Evan: When I put in the 192.168.x.x IP, it brings me to the character page and when I try to log in it gives me the connection time out screen. If I use the "localhost", it jumps right to "connection timeout".
@Limos: Yeah, I used the IPv4 address to open all of the ports.

Edit:

I'm able to log into my server with the hosting computer, other people are able to log on, I'm just not able to log onto my server with my laptop (same network)
I've tried many IPs (the IP found on What Is My IP Address ? | Shows Your IP Address., 127.0.0.1, 192.168.x.x (the IPv4 I used is from my host computer and laptop computer), localhost - still nothing)
Click to expand...
He did :p
 
Upvote 0 Downvote
Yes. I've tried most of the 192.168.0.### IPs (my host IPv4 and my laptop IPv4 on the IPchanger), my global IP, localhost and 127.0.0.1.
The only one that "works" is the 192.168.0.100, which brings me to the character log in screen, lets my choose a character and finally gives me the "Connection time out"

seeexampe1.jpg
That is what I see when I use the IP 192.168.0.100
When I click the account manger:
seeexampl2.jpg
 
Upvote 0 Downvote
As Evan suggested, 192.168.0.100 should work. But then again, your global IP should too. Are you 100% sure you don't have your connection settings in the IP changer set to a different port, and that you entered your IP with no spaces etc (i.e you didn't put a space on the end when copy pasting or something)?

If it is the case that you're unable to login using the global settings, and other people are able to, then it must be something in the way your Tibia client is operating. It could be that it's being blocked by a firewall, that your IP changer doesn't have the required elevation to be able to modify other processes (run as admin to fix this - try all combinations of IP changer and Tibia), or that something in your server is rejecting your connection (though I've no idea why it would do that, and have never seen it before).

Check in config.lua that you have specified the game server port as 7172, too, not sure but I guess that could be an issue.

If not, try manually creating a character, it could be that the account manager is bugged (use AAC or even just dump a character from another database if possible).

Apologies if you've already tried some of this, I'm busy IRL, just trying to help out as I can.
 
Upvote 0 Downvote
My config.lua looks:

-- Connection Config
ip = "24.141.***.**"
bindOnlyGlobalAddress = "no"
loginProtocolPort = 7171
gameProtocolPort = 7172
adminProtocolPort = 7171
statusProtocolPort = 7171
No random spaces or anything like that.
Firewall is down, and I added port 7171, 7172 and 80 to it.

Thanks for all of the suggestions though.

Edit:

Not sure if this matters, but this is what I did:

IP: 192.168.0.102
Connection time out
"Ok"
Brings me to my character screen.

So it appears that no matter what IP I put in, once the connection time out happens from the very beginning (Entering the password and name), if I wait and click "Ok" it will bring me to my character screen.

- - - Updated - - -

Edit again:

I was just wondering if it could be due to a LAN issue? (I'm not actually sure what a LAN is, but my old router would had this issue, but it was always fixed within minutes.)
Or could it be that I changed "Localhost" in the config.lua to say "127.0.0.1" because of MySQL errors?
 
Last edited:
Upvote 0 Downvote
This is a LAN issue, for security reasons, I'm not sure what kind of vulnerabilities it creates, but many new routers ESPECIALLY MODEM/ROUTER COMBINATIONS provided by your ISP, it is what is called no loopback, not allowing computers on your local network to connect via your global ip address, basically what this means is if you set your global ip to your local ip address it would work fine, but then people outside your network wouldn't be able to connect. It's really not fun, you may be able to set up a loopback on your local machines that aren't hosting in order to force them to automatically revert your global ip to the host local ip

What I did for my friend is created a server with no scripts or anything so it used little resources, and gave it it's own seperate mysql user that only has prevelliges to read the database, that way he could connect to that server as the loginserver, and it's global ip is set to the hosts local ip so that all the pcs on his network can use that as a loginserver to connect
 
Upvote 0 Downvote
Back
Top