Dedicated server with mysql: Page 2 - Godot Community Forums

This is a READ-ONLY snapshot of the Godot Community Forums when TwistedTwigleg was the owner, which is hosted for archival reasons only. The current Godot Community Forums can be found here.

Some links may point to external websites, including the current Godot Community Forums. These websites are not associated with TwistedTwigleg.

Dedicated server with mysql

noals

The main goal here is to have: Clients (godot 4) <-> Server (whatever)<-> Database (whatever) and i just want to keep it as simple as possible.
The client should portable to android later.

Cleber

noals You can use the module this way. It is able to connect with local or remote databases. Obviously you will still need to configure your Mysql server to accept remote connections.
The advantages:
You can have a godot server on the same machine as your XAMP and make connections with your clients using Enet, which uses UPD and is consequently is much faster than TCP.
It is easy to setup the Enet network with Godot.
You can pretect the your DB requiring SSL.
PS: Never allow your clients to connect directly to the database.

Pixophir

Yeah, I got that.

Is it a game ?
Why the server(whatever, http ?) ?
Why the database(whatever) ?
What kind of requests and how frequently do you issue to the database ?
What kind of data is stored there, and how much to merit a database ?

noals

Pixophir

Yes, it is a game.
By "whatever", i mean any database, through it should be a relational database for players infos, characters infos, inventories, monsters, usual stuff in online games kinda.
I didn't even designed the whole thing, i just wanted to get started with the basic movement of the player.

The player is in a maze represented by a table in the database, similar to a tilemap kinda.
I sent a request to get the type of tile and its angle depending on the coordinates of the player in the maze, i sent back the info to the client that generate the (3D) tile ingame.
Basically the world around the player is generated (and deleted) as he journey through it, but it is still a persistent world and the maze isn't procedurally generated.
I won't use physic, collision or fancy stuff, i don't think it would be a lot of requests relatively speaking but the server-side will requires more work because of the persistent world.

noals

I made some progress but i'm a bit stuck with Godot.

I was a able to get my little c++ server to connect to the postgresql database and if i'm not wrong, it initialize an ENet server on my localhost (ENET_HOST_ANY) on port 1234 and should be listening to incoming events.

The problem is that there is no incoming events so it's hard to tell if my server is really online ^^;
I suppose i need to use something like that:

var enet_p = ENetPacketPeer.new()
enet_p.connect_to_host("127.0.0.1",1234,0,0)

but i'm not really familiar with GDScript yet.
How could i make a little script just to see if the client actually connect to the server?

thx

Cleber

noals Hi, This module is compiled using scons.
You have to setup the SCsub file with the path to you boost lib and the MySQL C++ connector lib.
Than just compile the engine as you normally would.
Anyway, I'm working on this module again.
This module works on Linux, Windows, should work on Macos as well.
Recently I was able to compile it for Android, but the whole connector needs to be compiled together.
The connector also suports soquets and SSL.
If you need any extra help, you can create a issue on githob reposity.

noals

Cleber
Sorry, i'm not using the module and i switched to posgresql.
I have a working ENet server (tested with a c++ client) through i'm working on it, creating c++ classes/functions to get the infos i want from the database.

My question here is if i can initialize a godot Enet client and connect it to my c++ server.
I'm not really familiar with GDScript and i have a lot to do already, i will check some tutorials later about that if i ever do.
To be honest, i'm thinking about giving up on godot and simply using a c++ game engine like urho3D to go on with my project.
I will see later when i'm done working on my server and database.

thx

Cleber

noals It's 100% possible. Godot has a low level Enet API to handle it.
Check it out: https://docs.godotengine.org/en/latest/classes/class_enetconnection.html
Another issue you might want to consider, is that the Enet library doesn't support IPV6, however the Godot's devs has added this support to the mechanism, and some anothers features, like DTLS and data compression.
Read the docs, check some exemples. the work is simpler using Godot. I'm using Godot for some another aplications but games and I'm pretty glad with. There are many advantages in using Godot as a framework.

noals

Cleber

thank you for the informations but then, i should i use another network library already?
And i will need to make a module for godot... ><;
yeah, i like godot, it's been usefull already and will still be but i'm not sure it will really fit my needs.
Bah one thing at a time, thx anyway.

in 18 years, by the time i finish my game, ipv4 will be obsolete already, damn lol

Cleber

noals You can use Enet with no issues. The Enet lib used in Godot can work IPV6, DTLS and Compression and those features are very important in any internet aplication.
Implement this features by yourself is like reinvent the wheel.
Give me an overview of your project and maybe I can paint it better.

noals

Cleber

Don't bother, i'm learning at the same time.
Here, i switched to Boost::Asio, i have my client-server running through i'm a bit struggling with multi-threading and stuff like that for now, i'm just started.

« Previous Page