Solved TFS error

[nextpro]

Hi. I made my database and i will install gesior acc but i can't start engine
[05/09/2014 19:48:03] Failed connecting to database - MYSQL ERROR: Can't connect to MySQL server on 'localhost' (10061) (2003)

[05/09/2014 19:48:03] > ERROR: Couldn't estabilish connection to SQL database!
How can I fix it?

 

[dominique120]

In config.lua change mysql server from "localhost" to "127.0.0.1"

 

[nextpro]

U mean sqlhost? Done but..
ailed connecting to database - MYSQL ERROR: Access denied for user 'root'@'localhost' (using password: YES) (1045)

edit. Ok, i got bad password xD. Thank you

 

[dominique120]

Post the sql section of config.lua so that we can see it.

 

[nextpro]

Working fine now but i have problem with items.xml... TFS can't load it but I loaded it on other engine (VisumGold) and it work fine here. Why TFS can't load it?

 

[dominique120]

Because its probably not formatted correctly. Can you post the error you get?

 

[nextpro]

[05/09/2014 21:15:56] [Warning - Items::loadFromXml] Cannot load items file.
[05/09/2014 21:15:56] Line: 21977, Info: Couldn't find end of Start Tag attribute line 21977
Line 21977 in items.xml:
<attribute key="skillClub" value"15"/>

 

[Limos]

Post items.xml
http://pastebin.com/

Which server do you use btw?

 

[nextpro]

It's too large to paste it. I'm sure that there aren't any errors because I opened it on VisumGold and it worked

 

[Limos]

To large to post in pastebin? If it is, you can also upload it on speedyshare.

Post which server you use.

 

[nextpro]

http://otland.net/threads/8-60-the-forgotten-server-0-3-6-crying-damson-v8.147913/

 

[Limos]

Post your items.xml, in pastebin or if it's to big to post there, upload it on speedyshare.
http://www.speedy*****malware.localhost/

 

[nextpro]

http://www.speedy*****malware.localhost/czpxT/items.xml

 

[Limos]

http://www.speedy*****malware.localhost/69hRv/items.xml
<attribute key="skillClub" value="15"/>
= was missing, there were also other mistakes which I fixed aswell.
If you add new items, use ctrl f to find the id and change the attributes and name there, don't add the same id more than 1x. Only add a new id if it's not added yet.

 

[nextpro]

Working fine, thank. But now nobody can connect with serv. I'm using hamachi for tests before official start (then i will buy dedictaed server). I wrote hamachi ip in config.lua but still nobody can connect with page and can't login in game.

 

[Limos]

What happens when they try to login? What kind of error do they get from the client? Did you open port 7171 and 7172?

 

[nextpro]

I don't know now because all friends are afk now. It's probably error 1061 (they see char list but can't login). All worked when i used visumgold.
Connection config:
loginPort = 7171
gamePort = 7172
adminPort = 7171
statusPort = 7171
loginTries = 10
retryTimeout = 5 * 1000
loginTimeout = 60 * 1000
maxPlayers = 1000


sqlType = "mysql"
sqlHost = "127.0.0.1"
sqlPort = 3306
sqlUser = "root"
sqlPass = "my password"
sqlDatabase = "database name"
sqlFile = "mysql.sql"
sqlKeepAlive = 0
mysqlReadTimeout = 10
mysqlWriteTimeout = 10
encryptionType = "plain"

 

[Rer]

You typed good IP in "ip = " ?

 

[nextpro]

yes

 

[Limos]

If people can see their characterlist, this means port 7171 is open.
You can use this tool this see if port 7172 is open aswell: http://www.************/ports
Make sure you have your global ip (http://www.whatismyip.com/) in config.lua. You can also try to turn off your firewall and anti-virus programs.
If it still doesn't work, you can also try to restart your computer and router after that.