Mysql- sqlite ?

[George00]

whenever i change
My the sqlite text i cant connect to forgotten.exe it says cannot obtain sql connection.. i am using a xampp mysql database

sqlType = "mysql"
sqlHost = "localhost"
sqlPort = 3306
sqlUser = "root"
sqlPass = "78952412q"
sqlDatabase = "theforgottenserver"
sqlFile = "forgottenserver.s3db"
sqlKeepAlive = 0
mysqlReadTimeout = 10
mysqlWriteTimeout = 10
encryptionType = "plain"
limos..

 

[Limos]

Better use uniform server, follow this tutorial. The MySQL part is explained at the start.
http://otland.net/threads/video-tut...ing-ot-server-website-and-shop-system.166818/

 

[George00]

I did still says couldnt establish connection to sql database.. i did import schemas/Mysql becuase i didnt have any forgotten.SQL

 

[Limos]

Is your MySQL running? Can you post the whole error?

 

[George00]

What do you mean is your mysql running ? i am in phpadmin and i have created a database and all that stuff

 

[Limos]

If it's running, you see this (green)

Follow the tutorial step by step, look if you did everything right, if it still doesn't work, post the full error.

 

[George00]

Green both of them !

https://imgur.com/EMCs1Z5

 

[Limos]

Change localhost in config.lua to 127.0.0.1.

 

[George00]

It says temple position is wrong but it is 1000 1000 7

 

[Limos]

From what? Change the temple position of players or the account manager in the database (phpmyadmin) in the table players.
For new players that are created with the account manager change the positions at the top of config.lua or if you use a website change town id in that config.

 

[George00]

change to 1 ? account maker

Ok so i changed it to 1 now when i add my own ip in config it wont connect to the server i have opened ports 7171 7172 80 443

 

[Limos]

If you login from the computer that hosts the server, use your IPv4 address in your IP Changer, from other computers use your global ip.

 

[George00]

should the settings be
loginPort = 7172
gamePort = 7171
adminPort = 7171
statusPort = 7171

 

[Limos]

loginPort = 7171
gamePort = 7172
adminPort = 7171
statusPort = 7171

 

[George00]

Oh god the forgotten server takes years to start up its loading all tiles or something.. is this normal ?

 

[Limos]

Years is a bit long, but if you have a big map it can take a few minutes.

 

[George00]

Okay my friend is now online but one thing i've realized is that when i open chests they act like a loot..?

 

[Limos]

What do you mean?

 

[George00]

i dont get the reward i only open it and inside is the reward

Oh and my map sucks im thinking of using a fully edited evolution because im new and i'd like to work by an edired one to make it custom.. got any maps ?

 

[Limos]

Did you added actionid 2000 to the chest and an uniqueid?

You can look here for maps:
http://otland.net/forums/maps.50/

You can edit your post by clicking edit and then add the new information instead of creating a new post.

It's not allowed to double post (a double post is when you post after yourself in less than 24 hours), edit your post instead, I already merged about 30 posts of you.