[Grand Fantasia] Server files

[Kamuisensei]

The server works in local access, but when I access it through an external connection, I get the following error "system error", does anyone know how to solve the problem?

 

[EddieJr]

I have 0 experience with this but I'm trying to install with Ubuntu. The following error appears:

You must be registered to see links

Perhaps I should try with Centos?

 

[pierreninja]

your problem is in the ports have you released them yet? Do you have vps or did you make a vm on your pc?

I have 0 experience with this but I'm trying to install with Ubuntu. The following error appears:

You must be registered to see links

Perhaps I should try with Centos?

the error is in two factors
1- you are in the home folder put it in the root folder
2- you have the gfserver folder and the following remove the first folder it should look like this
root@vps:~/gf_server#

Hope this helps

 

[EddieJr]

Thanks a lot Pierre Ninja. I had to login as root in order to put the folder on the root.

I managed to get the server started with Ubuntu as taught by mudevs. But I can't access any of the pages to register or check server status.

You must be registered to see links

Perhaps I can edit the databases manually. Any tools for such job?

Complete beginner here but very curious and persistant.

 

[orion13]

@mazda2GT2RSL here is the information you asked for :

Spoiler

PGSQL Info:
DB Port : 5432
Initial DB : postgres
Username : spiritking
Password : antiroot

WinSCP Info:
Protocol : SFTP
Hostname : 192.168.1.99
Port : 22
User : root
Password : antiroot

Thanks to the log files of PGSQL, I realized that the UTF-8 encoding of the Databases is not good.
I converted them to LATIN1. For now, I've reported that it fixed the Public Billboards and the Guild Message Board.
For the Arenas, I just tested the Sprite Arena (Quiz) which works well.
For the Dungeons, i tested "Prairie Cave" (OK).

 

[soras2]

Is it working well in latin1 @orion13 ? To test the arenas, I recommend this command: /bf_ch_num 1 8 2 /bf_ch_num [arena] [level] [number of players]

 

[Kamuisensei]

Is it possible to access the server via WAN? I've tried several ways and I can't release external server access

 

[GaRocK]

Thanks to the log files of PGSQL, I realized that the UTF-8 encoding of the Databases is not good.
I converted them to LATIN1. For now, I've reported that it fixed the Public Billboards and the Guild Message Board.
For the Arenas, I just tested the Sprite Arena (Quiz) which works well.
For the Dungeons, i tested "Prairie Cave" (OK).

Okay, I'm gonna commit this change on my script to import databases, if this doesn't break anything else then it will be a good solution for the arena troubles.

EDIT:

Already changed the create database encoding to LATIN1. Gonna test soon
orion13 I have some doubts about this change should I change the:

SET client_encoding = 'UTF8';

on GF_LS.sql
to LATIN1 too?

 

[orion13]

I converted the 3 DBs to Latin1, it works well.
While searching the source code of MissionServer with the "Cutter" tool, I made an important discovery: 2 new definitions to add in the "setup.ini"
Battlefield=1
FamilyBattle=1

 

[soras2]

what distro are you using to put in latin1?

 

[orion13]

I'm on Centos, I changed the System Locale to "en_GB.iso88591" because there was a compatibility problem with Latin1
localectl set-locale LANG=en_GB.iso88591

 

[itachi77]

I converted the 3 DBs to Latin1, it works well.
While searching the source code of MissionServer with the "Cutter" tool, I made an important discovery: 2 new definitions to add in the "setup.ini"
Battlefield=1
FamilyBattle=1

Did you use just the command on terminal to convert all 3 database to Latin1 or you create a new db and restore again?
I try it here and doesn't work as well

 

[orion13]

I erased the dbs, recreated new ones with LATIN1 encoding, and restored the dump.
After backing up the DBs (which were in UTF-8), I edited the dumps and modified the line before restoring them :
SET client_encoding = 'UTF-8';
to
SET client_encoding = 'LATIN1';

Maybe there is another way to do it but I don't know Postgresql well.

 

[itachi77]

I erased the dbs, recreated new ones with LATIN1 encoding, and restored the dump.
After backing up the DBs (which were in UTF-8), I edited the dumps and modified the line before restoring them :
SET client_encoding = 'UTF-8';
to
SET client_encoding = 'LATIN1';

Maybe there is another way to do it but I don't know Postgresql well.

Are you able to get in Ilusory Arena and quit? or that keep unstuck anyway?
What do you tested until the moment who wasn't working yet?

I did the same thing you said up side, create a new db with LATIN1 encoding and changed all "SET client_encoding ='LATIN1';" and anyway arena and other stuff doesn't work to me.
Also where exactly are you adding the two new lines on setup.ini?

 

[soras2]

Are you able to get in Ilusory Arena and quit? or that keep unstuck anyway?
What do you tested until the moment who wasn't working yet?

I did the same thing you said up side, create a new db with LATIN1 encoding and changed all "SET client_encoding ='LATIN1';" and anyway arena and other stuff doesn't work to me.
Also where exactly are you adding the two new lines on setup.ini?

you must use centos, what you asked about does not work the arena still sends you to random places on the map

and the exit button doesn't work either

 

[brokopoly60]

I completed the builds of wan ip and successfully logged into the game.
After I have completed all the functions, I'll make a release, which also includes making the GUI of the GM tool.

 

[GaRocK]

I converted the 3 DBs to Latin1, it works well.
While searching the source code of MissionServer with the "Cutter" tool, I made an important discovery: 2 new definitions to add in the "setup.ini"
Battlefield=1
FamilyBattle=1

Inside the setup.ini in the [MissionServer] session right?

 

[Tryout]

Everything is running and I can even create an account, but I have a problem connecting in the game as it shows an Error. I already disabled firewall and I am also using Ubuntu 22.04 from DigitalOcean.

LoginServer logs:

Spoiler

1,2023/01/22 09:23:37,[EVENT] Connected to database[127.0.0.1].
2,2023/01/22 09:23:37,[EVENT] Get 1 world servers from DB.
3,2023/01/22 09:23:37,[EVENT] Load 1 records of AccountID from database.
4,2023/01/22 09:23:37,[EVENT] Load login_version: [Unknown_Version(Login)] from database done.
5,2023/01/22 09:23:37,[LoginServer.cc:72],Init Default NetCommand Table...
6,2023/01/22 09:23:38,RSA size = 256 size(e) = 2
7,2023/01/22 09:23:38,RSA size = 256 size(e) = 2
8,2023/01/22 09:23:38,Server is rolling on TCP 0.0.0.0:6543.
9,2023/01/22 09:23:38,Connect to 127.0.0.1<0x88C0908:10>:7777.
10,2023/01/22 09:23:38,Connect to 127.0.0.1<0x88D2828:11>:5560.
11,2023/01/22 09:23:38,[EVENT] LoginServer (with BillingGateway support) booting...
12,2023/01/22 09:23:38,[EVENT] EventUpdatePopulation constructed.
13,2023/01/22 09:23:38,Add New Epoll 9
14,2023/01/22 09:23:38,Add New Epoll 10
15,2023/01/22 09:23:38,Add New Epoll 11
16,2023/01/22 09:23:38,[EVENT] Update world: [1010] state: [0] ver: [Unknown_Version] successful.
17,2023/01/22 09:23:44,EVAL(5.914996 secs): {Network I/O}
18,2023/01/22 09:23:44,EVAL(5.917359 secs): {Main Loop}
19,2023/01/22 09:23:44,[EVENT] Update world: [1010] state: [1] ver: [006.058.64.64] successful.
20,2023/01/22 09:23:44,[EVENT] Update population of 1 servers.
21,2023/01/22 09:23:50,EVAL(6.006086 secs): {Network I/O}
22,2023/01/22 09:23:50,EVAL(6.006763 secs): {Main Loop}
23,2023/01/22 09:23:50,[EVENT] Update population of 1 servers.
24,2023/01/22 09:23:56,EVAL(6.007114 secs): {Network I/O}
25,2023/01/22 09:23:56,EVAL(6.008818 secs): {Main Loop}
26,2023/01/22 09:23:56,[EVENT] Update population of 1 servers.
27,2023/01/22 09:24:02,EVAL(6.001472 secs): {Network I/O}
28,2023/01/22 09:24:02,EVAL(6.002438 secs): {Main Loop}
29,2023/01/22 09:24:02,[EVENT] Update population of 1 servers.
30,2023/01/22 09:24:08,EVAL(6.006152 secs): {Network I/O}
31,2023/01/22 09:24:08,EVAL(6.006901 secs): {Main Loop}
32,2023/01/22 09:24:08,[EVENT] Update population of 1 servers.
33,2023/01/22 09:24:14,EVAL(6.006240 secs): {Network I/O}
34,2023/01/22 09:24:14,EVAL(6.006835 secs): {Main Loop}
35,2023/01/22 09:24:14,[EVENT] Update population of 1 servers.
36,2023/01/22 09:24:20,EVAL(6.006112 secs): {Network I/O}
37,2023/01/22 09:24:20,EVAL(6.006847 secs): {Main Loop}
38,2023/01/22 09:24:20,[EVENT] Update population of 1 servers.
39,2023/01/22 09:24:26,EVAL(6.006112 secs): {Network I/O}
40,2023/01/22 09:24:26,EVAL(6.006843 secs): {Main Loop}
41,2023/01/22 09:24:26,[EVENT] Update population of 1 servers.
42,2023/01/22 09:24:32,EVAL(6.006106 secs): {Network I/O}
43,2023/01/22 09:24:32,EVAL(6.006755 secs): {Main Loop}
44,2023/01/22 09:24:32,[EVENT] Update population of 1 servers.
45,2023/01/22 09:24:35,SOCKET 12: accepted by 9
46,2023/01/22 09:24:35,TCP <0x88D5108:12>: connected from (null) [210.1.128.52].
47,2023/01/22 09:24:35,EVAL(2.905708 secs): {Network I/O}
48,2023/01/22 09:24:35,EVAL(2.906326 secs): {Main Loop}
49,2023/01/22 09:24:35,Add New Epoll 12
50,2023/01/22 09:24:35,TCP <0x88D5108:12>: connection from '210.1.128.52' encrypted.
51,2023/01/22 09:24:35,[EVENT] Bind AccountName: [inplay] with SessionID: [1] in NE_CL_ServerLoginAccount.
52,2023/01/22 09:24:35,[NE_CL_ServerLoginAccount.cc:104],[DEBUG] [ 210.1.128.52null) ] Name: [inplay], Version: [006.058.64.64] 53,2023/01/22 09:24:35,[NC_G_ClientAccountLogin.cc:10],CNE_G_ClientAccountLogin ReturnCode=1
54,2023/01/22 09:24:35,[NE_G_ClientAccountLogin.cc:70],[ERROR] This username: [inplay] is already using with WRONG account id.
55,2023/01/22 09:24:38,EVAL(2.885988 secs): {Network I/O}
56,2023/01/22 09:24:38,EVAL(2.886051 secs): {Main Loop}

 

[Zore93]

Mirror Mega.nz:

You must be registered to see links

 

[rivotril]

(rm: cannot remove '/var/www/html/index.html' : no such file or directory)

I always get this error when trying to create my server, does anyone know how to resolve it and what do I need to do to get it?