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

Windows ERROR showing up when starting OTS

Mikolaj

Mikolaj

Banned User
Joined
Jun 11, 2010
Messages
92
Reaction score
2
Hello, I looked for help on many forums but like, I have to wait 1 or 2 days for reply or sometimes they don't even reply...

I have a huge problem. When I start my OTS, the following Erros shows up:
111111111111111dc.jpg


Please don't tell me to check config.lua because I did... I can't find any mistake there. :(

I hope for a quick reply and I hope you can help me solve this problem. :((

P.S I HAVE NO IDEA IF THIS IS THE PLACE TO POST THAT PROBLEM...
 
Sort by date Sort by votes
Come on... Is that all u can tell me??? R u joking me? I know u wanted to help but like. Im not stupid. Its obvious that u open xampp... ANY1 ELSE WANNA TRY TO HELP ME?
 
Upvote 0 Downvote
have u write your "database" in to your config?
Code: 
	-- Database
	sqlType = "mysql"
	sqlHost = "localhost"
	sqlPort = 3306
	sqlUser = "PHPMYADMIN USERNAME"
	sqlPass = "PHPMYADMIN PASS"
	sqlDatabase = "YOURDATABASE NAME"
	sqlFile = "forgottenserver.s3db"
	sqlKeepAlive = 0
	mysqlReadTimeout = 10
	mysqlWriteTimeout = 10
	encryptionType = "plain"
 
Upvote 0 Downvote
Yes. I have everything... sqluser = "root"
sqlpass = "mypassword by which im logging to database"

i dont have "plain", i have written "sha1" and it was always like that... this problem started to show up after i configured acc maker... but then i uninstalled xampp and installed it again...

also i dnt have:
sqlFile = "forgottenserver.s3db"

coz i have
sqlFile = "BakamyOts.s3db"

so everything is fine...
 
Upvote 0 Downvote
I am having the same problem it seems. My MySQL is located on another server, because of certain reasons. I've entered all the information correctly. I can connect to phpMyAdmin from the web browser just fine, same login information. When I go to start the server it takes a while like it's connecting but then it say it wasn't able to connect.

Here is my config info(private info disclosed):

sqlType = "mysql"
sqlHost = "ip-address"
sqlPort = 3306
sqlUser = "root"
sqlPass = "password"
sqlDatabase = "tibia"
sqlFile = "realserver.s3db"
sqlKeepAlive = 0
mysqlReadTimeout = 10
mysqlWriteTimeout = 10
encryptionType = "plain"
Click to expand...

EDIT:
I've ran the tibia server on the server in which my database is located and it runs just fine. But on two different servers it's feeding me an error like Mikolaj had received.
 
Upvote 0 Downvote
BlackList said:
I am having the same problem it seems. My MySQL is located on another server, because of certain reasons. I've entered all the information correctly. I can connect to phpMyAdmin from the web browser just fine, same login information. When I go to start the server it takes a while like it's connecting but then it say it wasn't able to connect.

Here is my config info(private info disclosed):



EDIT:
I've ran the tibia server on the server in which my database is located and it runs just fine. But on two different servers it's feeding me an error like Mikolaj had received.
Click to expand...

In phpmyadmin make a user for your OT, and instead of "localhost" write in the tfs server ip. Then use that user when connecting.

Root only allows 127.0.0.1 or localhost to login. phpmyadmin is a hosted mysql manager client on same comp as database, thats why you can login to root through phpmyadmin.

Etc: if database is on IP 85.167.57.154, and TFS server is on IP 81.164.57.153
Then in config.lua you need to write IP: 85.167.57.154 in mysql configurations.

And in mysqlIP/phpmyadmin you need to click priviledges, add user, add tfs server ip (in this sample: 81.164.57.153) on a user that got access to the OT database.

And use that username/pass in config.lua

Also you need to edit mysql configuration file to allow remote connections to the database.

in mysql configuration file: comment in: bind-address = 127.0.0.1
 
Last edited:
Upvote 0 Downvote
Derek Boom Boom said:
UniServer is crap aswell, the best way is just to download clear WWW Server (apache2, nginx, lighttpd?), MySQL and PHP5.
Click to expand...

Thats just bothersome when you can just download uniform server on windows. If you ever grow so much to want to get greater performance than uniform server can give you then linux is the way.
 
Upvote 0 Downvote
So guys, what should I do?

@Znote - Im sorry but from your first reply I didn't really understand what you're saying.

I am just very confused because like 1 week ago everything worked very well.... So what the hell happened to my comp that now it doesn't work?? :S
Is it possible that this error occurs because my ip changed??

I am using a WI FI internet (stealing from my neighbour so don't even ask me to go there and ask for something xD). I observed that my IP adress changes like once in month? I dont know... I just checked it and I realized that it was different then 1 week ago. But the one I had 1 week ago, i had it for the last month? or something like that.(im checking my ip on the site whatismyipadress.com)

I actually wanted to know if I can host my ots without using hamachi but I have no idea how... I am getting lost when it comes to those "technical problems" (like ip adress or connection issues)...

Please, I need a clear explanation what I have to do...


EDIT: I download the uniserver - this thing u know... And i pressed phpmyadmin and it showed an error. A new site opened with something like this:
dfdffddffddfdf.jpg


EDIT(2): I though that you might need some more informations. So here is screenshot of my uhmmm Idk how to call it....
dsddsdsdsdsdsd.jpg
 
Last edited:
Upvote 0 Downvote
@up

xampp is already running. Enter task manager, kill httpd or apache and kill mysql* process. Then start uniform server.
 
Upvote 0 Downvote
Znote - I did exacly everything as in the tutorial about uniserver...

I turned on my ots... And the same ERROR occurs as in my 1st post....

So im back to where i was ;sssss


Anyway thanks for Help. Ill give u rep for that...
 
Last edited:
Upvote 0 Downvote
Back
Top