Setting up a server with VPS.

Eriniel · Jul 29, 2023

Hello everyone,
Not sure if this will ever get a reply since the section seems dead but here we go,i recently got a VPS (from a friend pre-paid) and i tried to run a server for fun as i did play this game and was my first ever MMO.
I wanted to make a server with no custom stuff and such just for the nostalgia,the VPS i got they allow only Ubuntu 22.04 and i guess that's a big issues from what i been seeing around.
I did use this guide https://forum.ragezone.com/threads/talisman-online-server-client-update-2023.1189972/ but i cannot install the mysqlclient15 on that version.
Anyone have any clue how to fix it and/or downgrade my VPS to Ubuntu 16? or are there other ways to run the server on other OS such as Debian/Cento etc. or any other files?
Thank you!

BrunoJacks · Jul 29, 2023

Try this

sudo apt-get update
sudo apt-get install ssh
sudo apt-get -y install apache2 mysql-server php5-mysql php5 libapache2-mod-php5 php5-mcrypt
sudo mysql_install_db
sudo mysql_secure_installation
sudo service apache2 start

kaedehonjou.ph · Jul 29, 2023

you can install .deb file manually using

sudo apt install /path/to/package/name.deb.

Eriniel · Jul 30, 2023

Hello,
Thank you for the fast replies,i tried both above solutions and none seems to work.

1690713813786 - Setting up a server with VPS. - RaGEZONE Forums

kaedehonjou.ph · Jul 30, 2023

installing .deb manually don't work?? try renaming libmysql.deb as a.deb and put it on same location with ./1 then cd on ./1 and type "su" enter password then e then type " apt install a.deb"

Eriniel · Jul 30, 2023

kaedehonjou.ph said:
installing .deb manually don't work?? try renaming libmysql.deb as a.deb and put it on same location with ./1 then cd on ./1 and type "su" enter password then e then type " apt install a.deb"

Hello there,
Thank you again for the reply,yes i did try manually also what you suggested above still doesn't work apparently.

kaedehonjou.ph · Jul 30, 2023

any error message showing when you try to install libmysql.deb?

Eriniel · Jul 30, 2023

kaedehonjou.ph said:
any error message showing when you try to install libmysql.deb?

1690726034768 - Setting up a server with VPS. - RaGEZONE Forums

Same with re-naming it.

kaedehonjou.ph · Jul 30, 2023

try do "apt-get install lib32stdc++6" before install libmysqlclient

Eriniel · Jul 30, 2023

kaedehonjou.ph said:
try do "apt-get install lib32stdc++6" before install libmysqlclient

1690727187734 - Setting up a server with VPS. - RaGEZONE Forums

Installed lib32stdc++6

1690727264864 - Setting up a server with VPS. - RaGEZONE Forums

Uh i think it works now but something else came up.

1690728851561 - Setting up a server with VPS. - RaGEZONE Forums

kaedehonjou.ph · Jul 30, 2023

your screenshot is badly cropped

reupload 3rd screenshot so error message is not crop

edit:

try to use string for mysql username and password like

username :talisman password : secret123

do not leave it blank or *

also you really need "mysql" do not use other db such as mongo , postgresql, sql lite , maria db ... since they are not tested on those

Eriniel · Jul 31, 2023

Hello there,
Iam using MySQL not MariaDB and such.
And here is the pic with the error,seems like its running now but could it be that i did something wrong when i was setting up the db in phpadmin? Seems like none of them works.
P.S. Thanks a lot for all the help!

1690818897705 - Setting up a server with VPS. - RaGEZONE Forums

1690818817699 - Setting up a server with VPS. - RaGEZONE Forums

1690818723643 - Setting up a server with VPS. - RaGEZONE Forums

presnermp · Aug 1, 2023

you need to confirm that the bashscript 1, 2 and 3 are in correct order

run server in this order
1. db server
2. login server
3. game server

stop server in this order
1. login server
2. game server
3. db server

if they are in correct order then only run the db server and do not run the login server

since if db server has error then the next two server would show error aswell

now try to run db_server and and see if it show any error message such as incorrect port of IP before running the other two server

Eriniel · Aug 1, 2023

presnermp said:
you need to confirm that the bashscript 1, 2 and 3 are in correct order

run server in this order
1. db server
2. login server
3. game server

stop server in this order
1. login server
2. game server
3. db server

if they are in correct order then only run the db server and do not run the login server

since if db server has error then the next two server would show error aswell

now try to run db_server and and see if it show any error message such as incorrect port of IP before running the other two server

Hello there thank you for the reply,
I did turn em in correct order however i still get that database error like in the 3rd(last) screenshot.

presnermp · Aug 1, 2023

Eriniel said:
Hello there thank you for the reply,
I did turn em in correct order however i still get that database error like in the 3rd(last) screenshot.

try running this sql query

You must be registered to see links

apparently newer mysql use different password storing algorith look like talisman online use mysql_native_password as algorithm

Eriniel · Aug 1, 2023

presnermp said:
try running this sql query

You must be registered to see links

apparently newer mysql use different password storing algorith look like talisman online use mysql_native_password as algorithm

Hello there,thank you again for the big help the link did fix the DB error however there is something wrong

1690908594820 - Setting up a server with VPS. - RaGEZONE Forums

Update:
Apparently everything seems fine till i open 3 aka game_server

kaedehonjou.ph · Aug 1, 2023

Eriniel said:
Hello there thank you for the reply,
I did turn em in correct order however i still get that database error like in the 3rd(last) screenshot.

hmmn your screenshot is not in order you need to find the very first instance error message usually has keyword of disconnected,unsupported ... etc

you could delete the log folder and all .txt on game _server folder log folder then run the server wait for it to crash and upload the one and only. txt file on game server log folder on pastebin or something so log is easier to read

#edit your are the infamous thomas holder?

Eriniel · Aug 2, 2023

kaedehonjou.ph said:
hmmn your screenshot is not in order you need to find the very first instance error message usually has keyword of disconnected,unsupported ... etc

you could delete the log folder and all .txt on game _server folder log folder then run the server wait for it to crash and upload the one and only. txt file on game server log folder on pastebin or something so log is easier to read

#edit your are the infamous thomas holder?

Hello,
Thank you for the reply,will post the logs as soon as iam off work.
As for your question about this Thomas,no iam not nor heard the name before

iam new to the TO development community i really dont know anyone is why iam posting here

Update:
Hello @kaedehonjou.ph,
As requested i cleared out the log folder in game_server and i started again the server 1>2>3 (as soon as i start 3 everything shutdown)
I did check all the ini. files and such everything seems fine. As you see in those screenshots:

You must be registered to see links

Here is the error i got after opening game_server:

Code:

[20230802 15:06:18 INFO root] Base initialized.
[20230802 15:06:18 INFO root] net device startup ok
[20230802 15:06:18 INFO root]     FDSetSize       = 1024
[20230802 15:06:18 INFO root]     Version         = 110
[20230802 15:06:18 INFO root]     SendBufferSize  = 16384
[20230802 15:06:18 INFO root]     RecvBufferSize  = 131072
[20230802 15:06:18 ERRO root] no sn 1.
[20230802 15:06:18 INFO root] Connected to the db server successfully.
[20230802 15:06:18 INFO root] Connected to the db server successfully.
[20230802 15:06:18 INFO root] Connected to the db server successfully.
[20230802 15:06:18 INFO root] Connected to the login server successfully.
[20230802 15:06:18 INFO root] Register SUCCEEDED
[20230802 15:06:18 INFO root] PK is ENABLED
[20230802 15:06:19 ERRO root] can not find drop class, ID=252 npc=4392
[20230802 15:06:19 ERRO root] can not find drop class, ID=5642 npc=4837
[20230802 15:06:19 ERRO root] can not find drop class, ID=5646 npc=4837
[20230802 15:06:19 ERRO root] can not find drop class, ID=5643 npc=4838
[20230802 15:06:19 ERRO root] can not find drop class, ID=5647 npc=4838
[20230802 15:06:19 ERRO root] can not find drop class, ID=5644 npc=4840
[20230802 15:06:19 ERRO root] can not find drop class, ID=5645 npc=4840
[20230802 15:06:19 ERRO root] can not find drop class, ID=6047 npc=4936
[20230802 15:06:19 ERRO root] can not find drop class, ID=6048 npc=5166
[20230802 15:06:19 ERRO root] can not find drop class, ID=6050 npc=5167
[20230802 15:06:19 ERRO root] can not find drop class, ID=6049 npc=5168
[20230802 15:06:20 WARN root] Npc [5688] is Patrol Type, Path Not Found
[20230802 15:06:20 WARN root] 'banned_only_name.csv' line 0 is EMPTY!
[20230802 15:06:21 ERRO root] º¯ÊýÃû¶ÔÓ¦µÄIDÎ´ÕÒµ½: AddHateRate

AddHateRate(-0.5)
^
[20230802 15:06:22 WARN root] NpcAreaMgr::LoadTable local\common\table/npc_assign.csv: Line=121, Type=random, NpcID=0
[20230802 15:06:22 WARN root] NpcAreaMgr::LoadTable local\common\table/npc_assign.csv: Line=121, Type=random, NpcID=0
[20230802 15:06:22 WARN root] NpcAreaMgr::LoadTable local\common\table/npc_assign.csv: Line=121, Type=random, NpcID=0
[20230802 15:06:22 WARN root] NpcAreaMgr::LoadTable local\common\table/npc_assign.csv: Line=121, Type=random, NpcID=0
[20230802 15:06:22 WARN root] NpcAreaMgr::LoadTable local\common\table/npc_assign.csv: Line=121, Type=random, NpcID=0
[20230802 15:06:22 WARN root] NpcAreaMgr::LoadTable local\common\table/npc_assign.csv: Line=121, Type=random, NpcID=0
[20230802 15:06:22 WARN root] NpcAreaMgr::LoadTable local\common\table/npc_assign.csv: Line=121, Type=random, NpcID=0
[20230802 15:06:22 WARN root] NpcAreaMgr::LoadTable local\common\table/npc_assign.csv: Line=121, Type=random, NpcID=0
[20230802 15:06:22 WARN root] NpcAreaLoadRegion local\common\table/main/ningbiya/npc.csv: Line=88, Type=Common, NpcID=3104
[20230802 15:06:22 WARN root] NpcAreaLoadRegion local\common\table/main/ningbiya/npc.csv: Line=137, Type=Common, NpcID=3104
[20230802 15:06:22 WARN root] NpcAreaLoadRegion local\common\table/main/ningbiya/npc.csv: Line=138, Type=Common, NpcID=3104
[20230802 15:06:22 WARN root] NpcAreaLoadRegion local\common\table/main/ningbiya/npc.csv: Line=588, Type=Common, NpcID=3104
[20230802 15:06:22 WARN root] NpcAreaLoadRegion local\common\table/main/ningbiya/npc.csv: Line=589, Type=Common, NpcID=3104
[20230802 15:06:22 WARN root] NpcAreaLoadRegion local\common\table/main/ningbiya/npc.csv: Line=590, Type=Common, NpcID=3104
[20230802 15:06:22 WARN root] NpcAreaLoadRegion local\common\table/main/ningbiya/npc.csv: Line=591, Type=Common, NpcID=3104
[20230802 15:06:22 WARN root] NpcAreaLoadRegion local\common\table/main/ningbiya/npc.csv: Line=592, Type=Common, NpcID=3104
[20230802 15:06:22 WARN root] NpcAreaLoadRegion local\common\table/main/ningbiya/npc.csv: Line=593, Type=Common, NpcID=3104
[20230802 15:06:22 INFO root] CGameSystemAuction_Svr::Load: 0 Dealing Item Loaded
[20230802 15:06:22 INFO root] CGameSystemAuction_Svr::Load: 0 Dealed Item Loaded
[20230802 15:06:22 INFO root] [CGsGuildSvr::LoadFromDb] Guild Load Success, total = 0
[20230802 15:06:22 INFO root] [CGsGuildSvr::LoadFromDb] GuildTerr Load Success, total = 0
[20230802 15:06:22 INFO root] Connected to the db server successfully.
[20230802 15:06:22 INFO root] [CGsMurderSvr::LoadFromDb] Murder Load Success, total = 0
[20230802 15:06:22 ERRO root] LOG_PROCESS_ERROR(nRetCode) at line 533 in unsupported.
[20230802 15:06:22 ERRO root] LOG_PROCESS_ERROR(nRetCode) at line 154 in unsupported.
[20230802 15:06:22 INFO root] Game System [pve] Init Failed
[20230802 15:06:22 INFO root] AI Manger ÍË³ö, 0¸öAI¶ÔÏó±»´Ý»Ù
[20230802 15:06:22 INFO root] Disconnect from the db server.
[20230802 15:06:22 INFO root] object leak 0
[20230802 15:06:22 INFO root] Disconnect from the db server.
[20230802 15:06:22 INFO root] Disconnect from the db server.
[20230802 15:06:22 INFO root] Disconnect from the db server.
[20230802 15:06:22 ERRO root] Disconnect from the login server. (shutdown)
[20230802 15:06:22 ERRO root] server init failed
[20230802 15:06:22 INFO root] ActorOperate total num = 0, free = 0
[20230802 15:06:22 INFO root] The free npc node list size is 40000, used buffer count is 2.
[20230802 15:06:22 INFO root] The free user node list size is 2000, used buffer count is 1.
[20230802 15:06:22 INFO root] Base exit.
[20230802 15:06:22 INFO root] script engine shutdown Ok
[20230802 15:06:22 INFO root] net device exit ok

Code:

[20230802 16:08:48 INFO root] Base initialized.
[20230802 16:08:48 INFO root] net device startup ok
[20230802 16:08:48 INFO root]     FDSetSize       = 1024
[20230802 16:08:48 INFO root]     Version         = 110
[20230802 16:08:48 INFO root]     SendBufferSize  = 16384
[20230802 16:08:48 INFO root]     RecvBufferSize  = 131072
[20230802 16:08:48 INFO root]

>>>>>  DB Server (Build Dec 11 2009 15:58:11)  <<<<<
[20230802 16:08:48 INFO root] Welcome to the DB Server monitor.
[20230802 16:08:48 INFO root] DB Agent Manager starts listening at (localhost : 9006).
[20230802 16:08:48 INFO root] DB Server starts successfully.
[20230802 16:08:48 INFO root] The db agent server enter thread (0xf7706ac0).
[20230802 16:08:48 INFO root] The db agent game (game user) connected to the database successfully.
[20230802 16:10:09 INFO root] DB server accepts (127.0.0.1 : -23641).
[20230802 16:10:09 INFO root] The db agent server enter thread (0xf6dffac0).
[20230802 16:10:09 INFO root] The db agent login (login server) connected to the database successfully.
[20230802 16:16:41 INFO root] DB server accepts (127.0.0.1 : -27135).
[20230802 16:16:41 INFO root] DB server accepts (127.0.0.1 : -28271).
[20230802 16:16:41 INFO root] The db agent server enter thread (0xf63ffac0).
[20230802 16:16:41 INFO root] DB server accepts (127.0.0.1 : -30303).
[20230802 16:16:41 INFO root] The db agent server enter thread (0xf59ffac0).
[20230802 16:16:41 INFO root] The db agent game (game system) connected to the database successfully.
[20230802 16:16:41 INFO root] The db agent server enter thread (0xf51feac0).
[20230802 16:16:41 INFO root] The db agent log (game log) connected to the database successfully.
[20230802 16:16:41 INFO root] The db agent game (game actor) connected to the database successfully.
[20230802 16:16:45 INFO root] DB server accepts (127.0.0.1 : -24801).
[20230802 16:16:45 INFO root] The db agent server enter thread (0xf49fdac0).
[20230802 16:16:45 INFO root] The db agent game (game rank) connected to the database successfully.
[20230802 16:16:45 ERRO root] [DB] DB_MYSQL_ENGINE_PROCESS_ERROR at line 1241 in (0x0xf5a00680)->unsupported(), 1064, "You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'asc' at line 1", "select * from t_pve_rank order by rank asc".
[20230802 16:16:45 ERRO root] LOG_PROCESS_ERROR(nRetCode) at line 1209 in unsupported.
[20230802 16:16:45 INFO root] The db agent game system information:
Total elapsed time(s) 4
Create table command count 0
One create table command costs time(ms) 0
Create table command rate(per s) 0
Insert command count 0
One insert command costs time(ms) 0
Insert command rate(per s) 0
Update command count 1
One update command costs time(ms) 0
Update command rate(per s) 0
Delete command count 11
One delete command costs time(ms) 0
Delete command rate(per s) 2
Select command count 10
One select command costs time(ms) 0
Select command rate(per s) 2
[20230802 16:16:45 INFO root] The db agent server (game system) exit thread (0xf63ffac0).
[20230802 16:16:45 INFO root] DB server disconnect (unknown : -1) because unknown.
[20230802 16:16:45 INFO root] The db agent game actor information:
Total elapsed time(s) 4
Create table command count 0
One create table command costs time(ms) 0
Create table command rate(per s) 0
Insert command count 0
One insert command costs time(ms) 0
Insert command rate(per s) 0
Update command count 0
One update command costs time(ms) 0
Update command rate(per s) 0
Delete command count 0
One delete command costs time(ms) 0
Delete command rate(per s) 0
Select command count 0
One select command costs time(ms) 0
Select command rate(per s) 0
[20230802 16:16:45 INFO root] The db agent server (game actor) exit thread (0xf59ffac0).
[20230802 16:16:45 INFO root] DB server disconnect (127.0.0.1 : -28271) because unknown.
[20230802 16:16:45 INFO root] The db agent game log information:
Total elapsed time(s) 4
Create table command count 1
One create table command costs time(ms) 0
Create table command rate(per s) 0
Insert command count 0
One insert command costs time(ms) 0
Insert command rate(per s) 0
Update command count 0
One update command costs time(ms) 0
Update command rate(per s) 0
Delete command count 0
One delete command costs time(ms) 0
Delete command rate(per s) 0
Select command count 0
One select command costs time(ms) 0
Select command rate(per s) 0
[20230802 16:16:45 INFO root] The db agent server (game log) exit thread (0xf51feac0).
[20230802 16:16:45 INFO root] DB server disconnect (unknown : -1) because unknown.
[20230802 16:16:45 INFO root] The db agent game rank information:
Total elapsed time(s) 1
Create table command count 0
One create table command costs time(ms) 0
Create table command rate(per s) 0
Insert command count 0
One insert command costs time(ms) 0
Insert command rate(per s) 0
Update command count 0
One update command costs time(ms) 0
Update command rate(per s) 0
Delete command count 0
One delete command costs time(ms) 0
Delete command rate(per s) 0
Select command count 6
One select command costs time(ms) 0
Select command rate(per s) 6
[20230802 16:16:45 INFO root] The db agent server (game rank) exit thread (0xf49fdac0).
[20230802 16:16:45 INFO root] DB server disconnect (127.0.0.1 : -24801) because unknown.

matehun · Sep 14, 2023

Game System [pve] Init Failed
disable pve for server evp

Krisselig · Nov 13, 2023

Eriniel said:

Hello,
Thank you for the reply,will post the logs as soon as iam off work.
As for your question about this Thomas,no iam not nor heard the name before

iam new to the TO development community i really dont know anyone is why iam posting here

Update:
Hello @kaedehonjou.ph,
As requested i cleared out the log folder in game_server and i started again the server 1>2>3 (as soon as i start 3 everything shutdown)
I did check all the ini. files and such everything seems fine. As you see in those screenshots:

You must be registered to see links

Here is the error i got after opening game_server:

Code:

[20230802 15:06:18 INFO root] Base initialized.
[20230802 15:06:18 INFO root] net device startup ok
[20230802 15:06:18 INFO root]     FDSetSize       = 1024
[20230802 15:06:18 INFO root]     Version         = 110
[20230802 15:06:18 INFO root]     SendBufferSize  = 16384
[20230802 15:06:18 INFO root]     RecvBufferSize  = 131072
[20230802 15:06:18 ERRO root] no sn 1.
[20230802 15:06:18 INFO root] Connected to the db server successfully.
[20230802 15:06:18 INFO root] Connected to the db server successfully.
[20230802 15:06:18 INFO root] Connected to the db server successfully.
[20230802 15:06:18 INFO root] Connected to the login server successfully.
[20230802 15:06:18 INFO root] Register SUCCEEDED
[20230802 15:06:18 INFO root] PK is ENABLED
[20230802 15:06:19 ERRO root] can not find drop class, ID=252 npc=4392
[20230802 15:06:19 ERRO root] can not find drop class, ID=5642 npc=4837
[20230802 15:06:19 ERRO root] can not find drop class, ID=5646 npc=4837
[20230802 15:06:19 ERRO root] can not find drop class, ID=5643 npc=4838
[20230802 15:06:19 ERRO root] can not find drop class, ID=5647 npc=4838
[20230802 15:06:19 ERRO root] can not find drop class, ID=5644 npc=4840
[20230802 15:06:19 ERRO root] can not find drop class, ID=5645 npc=4840
[20230802 15:06:19 ERRO root] can not find drop class, ID=6047 npc=4936
[20230802 15:06:19 ERRO root] can not find drop class, ID=6048 npc=5166
[20230802 15:06:19 ERRO root] can not find drop class, ID=6050 npc=5167
[20230802 15:06:19 ERRO root] can not find drop class, ID=6049 npc=5168
[20230802 15:06:20 WARN root] Npc [5688] is Patrol Type, Path Not Found
[20230802 15:06:20 WARN root] 'banned_only_name.csv' line 0 is EMPTY!
[20230802 15:06:21 ERRO root] º¯ÊýÃû¶ÔÓ¦µÄIDÎ´ÕÒµ½: AddHateRate

AddHateRate(-0.5)
^
[20230802 15:06:22 WARN root] NpcAreaMgr::LoadTable local\common\table/npc_assign.csv: Line=121, Type=random, NpcID=0
[20230802 15:06:22 WARN root] NpcAreaMgr::LoadTable local\common\table/npc_assign.csv: Line=121, Type=random, NpcID=0
[20230802 15:06:22 WARN root] NpcAreaMgr::LoadTable local\common\table/npc_assign.csv: Line=121, Type=random, NpcID=0
[20230802 15:06:22 WARN root] NpcAreaMgr::LoadTable local\common\table/npc_assign.csv: Line=121, Type=random, NpcID=0
[20230802 15:06:22 WARN root] NpcAreaMgr::LoadTable local\common\table/npc_assign.csv: Line=121, Type=random, NpcID=0
[20230802 15:06:22 WARN root] NpcAreaMgr::LoadTable local\common\table/npc_assign.csv: Line=121, Type=random, NpcID=0
[20230802 15:06:22 WARN root] NpcAreaMgr::LoadTable local\common\table/npc_assign.csv: Line=121, Type=random, NpcID=0
[20230802 15:06:22 WARN root] NpcAreaMgr::LoadTable local\common\table/npc_assign.csv: Line=121, Type=random, NpcID=0
[20230802 15:06:22 WARN root] NpcAreaLoadRegion local\common\table/main/ningbiya/npc.csv: Line=88, Type=Common, NpcID=3104
[20230802 15:06:22 WARN root] NpcAreaLoadRegion local\common\table/main/ningbiya/npc.csv: Line=137, Type=Common, NpcID=3104
[20230802 15:06:22 WARN root] NpcAreaLoadRegion local\common\table/main/ningbiya/npc.csv: Line=138, Type=Common, NpcID=3104
[20230802 15:06:22 WARN root] NpcAreaLoadRegion local\common\table/main/ningbiya/npc.csv: Line=588, Type=Common, NpcID=3104
[20230802 15:06:22 WARN root] NpcAreaLoadRegion local\common\table/main/ningbiya/npc.csv: Line=589, Type=Common, NpcID=3104
[20230802 15:06:22 WARN root] NpcAreaLoadRegion local\common\table/main/ningbiya/npc.csv: Line=590, Type=Common, NpcID=3104
[20230802 15:06:22 WARN root] NpcAreaLoadRegion local\common\table/main/ningbiya/npc.csv: Line=591, Type=Common, NpcID=3104
[20230802 15:06:22 WARN root] NpcAreaLoadRegion local\common\table/main/ningbiya/npc.csv: Line=592, Type=Common, NpcID=3104
[20230802 15:06:22 WARN root] NpcAreaLoadRegion local\common\table/main/ningbiya/npc.csv: Line=593, Type=Common, NpcID=3104
[20230802 15:06:22 INFO root] CGameSystemAuction_Svr::Load: 0 Dealing Item Loaded
[20230802 15:06:22 INFO root] CGameSystemAuction_Svr::Load: 0 Dealed Item Loaded
[20230802 15:06:22 INFO root] [CGsGuildSvr::LoadFromDb] Guild Load Success, total = 0
[20230802 15:06:22 INFO root] [CGsGuildSvr::LoadFromDb] GuildTerr Load Success, total = 0
[20230802 15:06:22 INFO root] Connected to the db server successfully.
[20230802 15:06:22 INFO root] [CGsMurderSvr::LoadFromDb] Murder Load Success, total = 0
[20230802 15:06:22 ERRO root] LOG_PROCESS_ERROR(nRetCode) at line 533 in unsupported.
[20230802 15:06:22 ERRO root] LOG_PROCESS_ERROR(nRetCode) at line 154 in unsupported.
[20230802 15:06:22 INFO root] Game System [pve] Init Failed
[20230802 15:06:22 INFO root] AI Manger ÍË³ö, 0¸öAI¶ÔÏó±»´Ý»Ù
[20230802 15:06:22 INFO root] Disconnect from the db server.
[20230802 15:06:22 INFO root] object leak 0
[20230802 15:06:22 INFO root] Disconnect from the db server.
[20230802 15:06:22 INFO root] Disconnect from the db server.
[20230802 15:06:22 INFO root] Disconnect from the db server.
[20230802 15:06:22 ERRO root] Disconnect from the login server. (shutdown)
[20230802 15:06:22 ERRO root] server init failed
[20230802 15:06:22 INFO root] ActorOperate total num = 0, free = 0
[20230802 15:06:22 INFO root] The free npc node list size is 40000, used buffer count is 2.
[20230802 15:06:22 INFO root] The free user node list size is 2000, used buffer count is 1.
[20230802 15:06:22 INFO root] Base exit.
[20230802 15:06:22 INFO root] script engine shutdown Ok
[20230802 15:06:22 INFO root] net device exit ok

Code:

[20230802 16:08:48 INFO root] Base initialized.
[20230802 16:08:48 INFO root] net device startup ok
[20230802 16:08:48 INFO root]     FDSetSize       = 1024
[20230802 16:08:48 INFO root]     Version         = 110
[20230802 16:08:48 INFO root]     SendBufferSize  = 16384
[20230802 16:08:48 INFO root]     RecvBufferSize  = 131072
[20230802 16:08:48 INFO root]

>>>>>  DB Server (Build Dec 11 2009 15:58:11)  <<<<<
[20230802 16:08:48 INFO root] Welcome to the DB Server monitor.
[20230802 16:08:48 INFO root] DB Agent Manager starts listening at (localhost : 9006).
[20230802 16:08:48 INFO root] DB Server starts successfully.
[20230802 16:08:48 INFO root] The db agent server enter thread (0xf7706ac0).
[20230802 16:08:48 INFO root] The db agent game (game user) connected to the database successfully.
[20230802 16:10:09 INFO root] DB server accepts (127.0.0.1 : -23641).
[20230802 16:10:09 INFO root] The db agent server enter thread (0xf6dffac0).
[20230802 16:10:09 INFO root] The db agent login (login server) connected to the database successfully.
[20230802 16:16:41 INFO root] DB server accepts (127.0.0.1 : -27135).
[20230802 16:16:41 INFO root] DB server accepts (127.0.0.1 : -28271).
[20230802 16:16:41 INFO root] The db agent server enter thread (0xf63ffac0).
[20230802 16:16:41 INFO root] DB server accepts (127.0.0.1 : -30303).
[20230802 16:16:41 INFO root] The db agent server enter thread (0xf59ffac0).
[20230802 16:16:41 INFO root] The db agent game (game system) connected to the database successfully.
[20230802 16:16:41 INFO root] The db agent server enter thread (0xf51feac0).
[20230802 16:16:41 INFO root] The db agent log (game log) connected to the database successfully.
[20230802 16:16:41 INFO root] The db agent game (game actor) connected to the database successfully.
[20230802 16:16:45 INFO root] DB server accepts (127.0.0.1 : -24801).
[20230802 16:16:45 INFO root] The db agent server enter thread (0xf49fdac0).
[20230802 16:16:45 INFO root] The db agent game (game rank) connected to the database successfully.
[20230802 16:16:45 ERRO root] [DB] DB_MYSQL_ENGINE_PROCESS_ERROR at line 1241 in (0x0xf5a00680)->unsupported(), 1064, "You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'asc' at line 1", "select * from t_pve_rank order by rank asc".
[20230802 16:16:45 ERRO root] LOG_PROCESS_ERROR(nRetCode) at line 1209 in unsupported.
[20230802 16:16:45 INFO root] The db agent game system information:
Total elapsed time(s) 4
Create table command count 0
One create table command costs time(ms) 0
Create table command rate(per s) 0
Insert command count 0
One insert command costs time(ms) 0
Insert command rate(per s) 0
Update command count 1
One update command costs time(ms) 0
Update command rate(per s) 0
Delete command count 11
One delete command costs time(ms) 0
Delete command rate(per s) 2
Select command count 10
One select command costs time(ms) 0
Select command rate(per s) 2
[20230802 16:16:45 INFO root] The db agent server (game system) exit thread (0xf63ffac0).
[20230802 16:16:45 INFO root] DB server disconnect (unknown : -1) because unknown.
[20230802 16:16:45 INFO root] The db agent game actor information:
Total elapsed time(s) 4
Create table command count 0
One create table command costs time(ms) 0
Create table command rate(per s) 0
Insert command count 0
One insert command costs time(ms) 0
Insert command rate(per s) 0
Update command count 0
One update command costs time(ms) 0
Update command rate(per s) 0
Delete command count 0
One delete command costs time(ms) 0
Delete command rate(per s) 0
Select command count 0
One select command costs time(ms) 0
Select command rate(per s) 0
[20230802 16:16:45 INFO root] The db agent server (game actor) exit thread (0xf59ffac0).
[20230802 16:16:45 INFO root] DB server disconnect (127.0.0.1 : -28271) because unknown.
[20230802 16:16:45 INFO root] The db agent game log information:
Total elapsed time(s) 4
Create table command count 1
One create table command costs time(ms) 0
Create table command rate(per s) 0
Insert command count 0
One insert command costs time(ms) 0
Insert command rate(per s) 0
Update command count 0
One update command costs time(ms) 0
Update command rate(per s) 0
Delete command count 0
One delete command costs time(ms) 0
Delete command rate(per s) 0
Select command count 0
One select command costs time(ms) 0
Select command rate(per s) 0
[20230802 16:16:45 INFO root] The db agent server (game log) exit thread (0xf51feac0).
[20230802 16:16:45 INFO root] DB server disconnect (unknown : -1) because unknown.
[20230802 16:16:45 INFO root] The db agent game rank information:
Total elapsed time(s) 1
Create table command count 0
One create table command costs time(ms) 0
Create table command rate(per s) 0
Insert command count 0
One insert command costs time(ms) 0
Insert command rate(per s) 0
Update command count 0
One update command costs time(ms) 0
Update command rate(per s) 0
Delete command count 0
One delete command costs time(ms) 0
Delete command rate(per s) 0
Select command count 6
One select command costs time(ms) 0
Select command rate(per s) 6
[20230802 16:16:45 INFO root] The db agent server (game rank) exit thread (0xf49fdac0).
[20230802 16:16:45 INFO root] DB server disconnect (127.0.0.1 : -24801) because unknown.

theres something wrong with the EVP you are using. I have tried running a server with ubuntu 22 and it works for me, as long as you have the right files for the right client.

Welcome!

Setting up a server with VPS.

Newbie Spellweaver

Junior Spellweaver

Junior Spellweaver

Newbie Spellweaver

Attachments

Junior Spellweaver

Newbie Spellweaver

Junior Spellweaver

Newbie Spellweaver

Attachments

Junior Spellweaver

Newbie Spellweaver

Attachments

Junior Spellweaver

Newbie Spellweaver

Attachments

Newbie Spellweaver

Newbie Spellweaver

Newbie Spellweaver

Newbie Spellweaver

Attachments

Junior Spellweaver

Newbie Spellweaver

Newbie Spellweaver

𝙆𝘼𝙄𝙎𝙀𝙍

About Us

Online statistics

Forum statistics

RaGEZONE Sponsor