[10.77][TFS 1.2] ORTS, a real map project

[Vyperhate]

Ok, this is driving me mad... I keep getting this error when trying to open the www:

Failed to connect to MySQL: (1045) Access denied for user 'Shattered'@'localhost' (using password: YES)
Install:

1. Make sure you have imported TFS database. (OTdir/forgottenserver.sql OR OTdir/schemas/mysql.sql)
   
   
2. Import the below schema to a TFS database in phpmyadmin:
3. Edit config.php with correct mysql connection details.

YES I have updated my MySQL connection info with the correct info in the config.lua for the www! Hence why it is custom in the error message (just making this clear as it is the only solution I have seen).
I am also using the updated build from github. The server (using the exact same connection info as the www of course) is able to connect to MySQL with no issues and starts right up.

Any ideas?

 

[Flower]

Ok, this is driving me mad... I keep getting this error when trying to open the www:




YES I have updated my MySQL connection info with the correct info in the config.lua for the www! Hence why it is custom in the error message (just making this clear as it is the only solution I have seen).
I am also using the updated build from github. The server (using the exact same connection info as the www of course) is able to connect to MySQL with no issues and starts right up.

Any ideas?

You are writing that you have changed the info in config.lua, I assume you mean that you changed it in config.php

Well, the error message clearly states that access is denied, so if you are sure that you entered the correct information in the right place then check if the user has all necessary access rights:

select user,host from mysql.user;

show grants for 'Shattered'@'localhost';

 

[Vyperhate]

You are writing that you have changed the info in config.lua, I assume you mean that you changed it in config.php

Well, the error message clearly states that access is denied, so if you are sure that you entered the correct information in the right place then check if the user has all necessary access rights:

select user,host from mysql.user;

show grants for 'Shattered'@'localhost';

Yes that is what I meant. I switched to Gesior 2012 instead and it works fine. I was able to connect with 10.35 though it was crashing pretty much every 3-4 minutes so I went ahead and did a clean compile, plus deleting the database/user, (basically a clean start) just to be sure it was all good. Now the problem I'm having is the client tells me that only those with version 10.36 are allowed to connect... I am using the updated build from github as I said before which is only version 10.35 right? Why would it suddenly change? Did someone do a new commit and I just overlooked it? I any case, if I try using 10.36 the game just crashes as soon as I select a character.

 

[GOD Esteve]

Some good VPS to keep this server?

 

[Flower]

Yes that is what I meant. I switched to Gesior 2012 instead and it works fine. I was able to connect with 10.35 though it was crashing pretty much every 3-4 minutes so I went ahead and did a clean compile, plus deleting the database/user, (basically a clean start) just to be sure it was all good. Now the problem I'm having is the client tells me that only those with version 10.36 are allowed to connect... I am using the updated build from github as I said before which is only version 10.35 right? Why would it suddenly change? Did someone do a new commit and I just overlooked it? I any case, if I try using 10.36 the game just crashes as soon as I select a character.

forgottenserver source is at the moment 10.36, committed in https://github.com/otland/forgottenserver/commit/9e814caab2e367ef3f4e0b5e34896ac23c8b296d

take a look at this bug report for some ideas of why it crashes with 10.36 https://github.com/otland/forgottenserver/issues/623

 

[Techrlz]

The TFS is stable

But the datapack no.

 

[Benna]

It's weird the teleporters to gnomebase worked earlier now it seems that they just stop working, because of the client update?

 

[vingo]

forgottenserver source is at the moment 10.36, committed in https://github.com/otland/forgottenserver/commit/9e814caab2e367ef3f4e0b5e34896ac23c8b296d

take a look at this bug report for some ideas of why it crashes with 10.36 https://github.com/otland/forgottenserver/issues/623

its because you dont swap ur items.otb and items.xml file


But I still get random crashes because of a duplicate teleport or stairs on the map, does anyone have the same problem?

 

[Vyperhate]

forgottenserver source is at the moment 10.36, committed in https://github.com/otland/forgottenserver/commit/9e814caab2e367ef3f4e0b5e34896ac23c8b296d

take a look at this bug report for some ideas of why it crashes with 10.36 https://github.com/otland/forgottenserver/issues/623

This doesn't help me at all really. The only advice given there is to update all files. I am using the most recent files and am still having this crash. So I've compiled the latest version of TFS from Github, have the most recent files for this map, also from Github, crashes when loading a character in 10.36. Does not allow connection at all with any version other than 10.36... What am I doing wrong?

 

[Vyperhate]

Ok, it is something with the files. If I copy the map files only from the real map into the folder from TFS from Github and launch it I can connect fine. Tons of server errors due to missing resources of course, but it works otherwise. So what files do I need to copy over? I already tried the items.otb and items.xml files. That didn't work.

 

[Tagon]

Why this server crash so often ? he cant work longer than 10 mins on x64, any1 tested timelife?

 

[WibbenZ]

Why this server crash so often ? he cant work longer than 10 mins on x64, any1 tested timelife?

http://otland.net/threads/10-31-the-forgotten-server-1-0-915.207351/
That exe has worked for alot of others, but the best is if you compile your own, in your own computer.

 

[Tagon]

In which compilator is possible to compile it ?
Im actually using MS Visual Studio 2013 Ultimate, but there yelling some errors:

7 IntelliSense: cannot open source file "boost/asio.hpp" c:\Users\Tagon\Desktop\forgottenserver-master\src\otpch.h 30 1 theforgottenserver
9 IntelliSense: identifier "lua_State" is undefined c:\Users\Tagon\Desktop\forgottenserver-master\src\luascript.h 259 3 theforgottenserver


and much more

 

[Tagon]

Okey !!
In source code you have missing one file, lua.hpp

Can you include it?

 

[Techrlz]

@Tagon:

https://github.com/otland/forgottenserver/blob/master/src/luascript.h

 

[Tagon]

1 IntelliSense: identifier "WSA13" is undefined c:\Users\Tagon\Desktop\boost_1_55_0\boost\asio\error.hpp 70 19 theforgottenserver
2 IntelliSense: identifier "WSA102" is undefined c:\Users\Tagon\Desktop\boost_1_55_0\boost\asio\error.hpp 73 34 theforgottenserver
3 IntelliSense: identifier "WSA100" is undefined c:\Users\Tagon\Desktop\boost_1_55_0\boost\asio\error.hpp 76 20 theforgottenserver
4 IntelliSense: identifier "WSA113" is undefined c:\Users\Tagon\Desktop\boost_1_55_0\boost\asio\error.hpp 79 23 theforgottenserver
5 IntelliSense: identifier "WSA103" is undefined c:\Users\Tagon\Desktop\boost_1_55_0\boost\asio\error.hpp 82 21 theforgottenserver
6 IntelliSense: identifier "WSA106" is undefined c:\Users\Tagon\Desktop\boost_1_55_0\boost\asio\error.hpp 90 24 theforgottenserver
7 IntelliSense: identifier "WSA107" is undefined c:\Users\Tagon\Desktop\boost_1_55_0\boost\asio\error.hpp 93 24 theforgottenserver
8 IntelliSense: identifier "WSA108" is undefined c:\Users\Tagon\Desktop\boost_1_55_0\boost\asio\error.hpp 96 22 theforgottenserver
9 IntelliSense: identifier "WSA9" is undefined c:\Users\Tagon\Desktop\boost_1_55_0\boost\asio\error.hpp 99 20 theforgottenserver
10 IntelliSense: identifier "WSA14" is undefined c:\Users\Tagon\Desktop\boost_1_55_0\boost\asio\error.hpp 102 11 theforgottenserver
11 IntelliSense: identifier "WSA110" is undefined c:\Users\Tagon\Desktop\boost_1_55_0\boost\asio\error.hpp 105 22 theforgottenserver
12 IntelliSense: identifier "WSA112" is undefined c:\Users\Tagon\Desktop\boost_1_55_0\boost\asio\error.hpp 108 17 theforgottenserver
13 IntelliSense: identifier "WSA4" is undefined c:\Users\Tagon\Desktop\boost_1_55_0\boost\asio\error.hpp 111 17 theforgottenserver
14 IntelliSense: identifier "WSA22" is undefined c:\Users\Tagon\Desktop\boost_1_55_0\boost\asio\error.hpp 114 22 theforgottenserver
15 IntelliSense: identifier "WSA115" is undefined c:\Users\Tagon\Desktop\boost_1_55_0\boost\asio\error.hpp 117 18 theforgottenserver
16 IntelliSense: identifier "WSA38" is undefined c:\Users\Tagon\Desktop\boost_1_55_0\boost\asio\error.hpp 120 19 theforgottenserver
17 IntelliSense: identifier "WSA116" is undefined c:\Users\Tagon\Desktop\boost_1_55_0\boost\asio\error.hpp 123 18 theforgottenserver
18 IntelliSense: identifier "WSA117" is undefined c:\Users\Tagon\Desktop\boost_1_55_0\boost\asio\error.hpp 126 19 theforgottenserver
19 IntelliSense: identifier "WSA118" is undefined c:\Users\Tagon\Desktop\boost_1_55_0\boost\asio\error.hpp 129 25 theforgottenserver
20 IntelliSense: identifier "WSA24" is undefined c:\Users\Tagon\Desktop\boost_1_55_0\boost\asio\error.hpp 132 20 theforgottenserver
21 IntelliSense: identifier "WSA119" is undefined c:\Users\Tagon\Desktop\boost_1_55_0\boost\asio\error.hpp 135 21 theforgottenserver
22 IntelliSense: identifier "WSA123" is undefined c:\Users\Tagon\Desktop\boost_1_55_0\boost\asio\error.hpp 148 24 theforgottenserver
23 IntelliSense: identifier "WSA126" is undefined c:\Users\Tagon\Desktop\boost_1_55_0\boost\asio\error.hpp 151 19 theforgottenserver
24 IntelliSense: identifier "WSA128" is undefined c:\Users\Tagon\Desktop\boost_1_55_0\boost\asio\error.hpp 154 16 theforgottenserver
25 IntelliSense: identifier "WSA130" is undefined c:\Users\Tagon\Desktop\boost_1_55_0\boost\asio\error.hpp 162 29 theforgottenserver
26 IntelliSense: identifier "WSA138" is undefined c:\Users\Tagon\Desktop\boost_1_55_0\boost\asio\error.hpp 168 15 theforgottenserver
27 IntelliSense: identifier "WSA140" is undefined c:\Users\Tagon\Desktop\boost_1_55_0\boost\asio\error.hpp 176 17 theforgottenserver
28 IntelliSense: identifier "WSA11001L" is undefined c:\Users\Tagon\Desktop\boost_1_55_0\boost\asio\error.hpp 182 20 theforgottenserver
29 IntelliSense: identifier "WSA11002L" is undefined c:\Users\Tagon\Desktop\boost_1_55_0\boost\asio\error.hpp 185 30 theforgottenserver
30 IntelliSense: identifier "WSA11004L" is undefined c:\Users\Tagon\Desktop\boost_1_55_0\boost\asio\error.hpp 188 13 theforgottenserver
31 IntelliSense: identifier "WSA11003L" is undefined c:\Users\Tagon\Desktop\boost_1_55_0\boost\asio\error.hpp 191 17 theforgottenserver
32 IntelliSense: identifier "BOOST_ASIO_OS_DEF_0x00000002" is undefined c:\Users\Tagon\Desktop\boost_1_55_0\boost\asio\ip\resolver_query_base.hpp 66 22 theforgottenserver
33 IntelliSense: identifier "BOOST_ASIO_OS_DEF_0x00000001" is undefined c:\Users\Tagon\Desktop\boost_1_55_0\boost\asio\ip\resolver_query_base.hpp 67 15 theforgottenserver
34 IntelliSense: identifier "BOOST_ASIO_OS_DEF_0x00000004" is undefined c:\Users\Tagon\Desktop\boost_1_55_0\boost\asio\ip\resolver_query_base.hpp 68 20 theforgottenserver
35 IntelliSense: identifier "BOOST_ASIO_OS_DEF_0x00000008" is undefined c:\Users\Tagon\Desktop\boost_1_55_0\boost\asio\ip\resolver_query_base.hpp 69 23 theforgottenserver
36 IntelliSense: identifier "BOOST_ASIO_OS_DEF_0x00000800" is undefined c:\Users\Tagon\Desktop\boost_1_55_0\boost\asio\ip\resolver_query_base.hpp 70 17 theforgottenserver
37 IntelliSense: identifier "BOOST_ASIO_OS_DEF_0x00000100" is undefined c:\Users\Tagon\Desktop\boost_1_55_0\boost\asio\ip\resolver_query_base.hpp 71 20 theforgottenserver
38 IntelliSense: identifier "BOOST_ASIO_OS_DEF_0x00000400" is undefined c:\Users\Tagon\Desktop\boost_1_55_0\boost\asio\ip\resolver_query_base.hpp 72 26 theforgottenserver
39 IntelliSense: identifier "BOOST_ASIO_OS_DEF_0" is undefined c:\Users\Tagon\Desktop\boost_1_55_0\boost\asio\ip\multicast.hpp 51 3 theforgottenserver
40 IntelliSense: identifier "BOOST_ASIO_OS_DEF_12" is undefined c:\Users\Tagon\Desktop\boost_1_55_0\boost\asio\ip\multicast.hpp 52 3 theforgottenserver
41 IntelliSense: identifier "BOOST_ASIO_OS_DEF_13" is undefined c:\Users\Tagon\Desktop\boost_1_55_0\boost\asio\ip\multicast.hpp 80 3 theforgottenserver
42 IntelliSense: identifier "BOOST_ASIO_OS_DEF_9" is undefined c:\Users\Tagon\Desktop\boost_1_55_0\boost\asio\ip\multicast.hpp 108 3 theforgottenserver
43 IntelliSense: identifier "BOOST_ASIO_OS_DEF_10" is undefined c:\Users\Tagon\Desktop\boost_1_55_0\boost\asio\ip\multicast.hpp 144 3 theforgottenserver
44 IntelliSense: identifier "BOOST_ASIO_OS_DEF_11" is undefined c:\Users\Tagon\Desktop\boost_1_55_0\boost\asio\ip\multicast.hpp 181 3 theforgottenserver
45 IntelliSense: identifier "BOOST_ASIO_OS_DEF_0x0001" is undefined c:\Users\Tagon\Desktop\boost_1_55_0\boost\asio\ip\tcp.hpp 126 37 theforgottenserver
46 IntelliSense: identifier "BOOST_ASIO_OS_DEF_0" is undefined c:\Users\Tagon\Desktop\boost_1_55_0\boost\asio\ip\unicast.hpp 59 3 theforgottenserver
47 IntelliSense: identifier "BOOST_ASIO_OS_DEF_4" is undefined c:\Users\Tagon\Desktop\boost_1_55_0\boost\asio\ip\unicast.hpp 60 3 theforgottenserver

I checked path for files and subfolder with files and all is correct, any advice why i have a lot of undefinied?

 

[Taywedge]

So I've created an account and a character and when I'm trying to login, I select my character and it just says "connecting to the game world. Please wait" until it times out. Can somebody please help me fix this problem?

 

[Taywedge]

So I've created an account and a character and when I'm trying to login, I select my character and it just says "connecting to the game world. Please wait" until it times out. Can somebody please help me fix this problem?

I also made sure I have the proper ports open, and I can connect through other distro's no problem.

 

[Wartio]

@Printer would you like to update this distro too 10.37 ?, It would be very helpfull to many of us

 

[Taywedge]

So I've created an account and a character and when I'm trying to login, I select my character and it just says "connecting to the game world. Please wait" until it times out. Can somebody please help me fix this problem?

Nevermind, I solved it.