[SACRED 2 ONLINE MULTIPLAYER: HOW-TO, DISCUSSION & DEVELOPMENT]

Actually I'm having problem starting the lobby. 

sacred2_charax_db   | Version: '10.4.12-MariaDB-1:10.4.12+maria~bionic'  socket: '/var/run/mysqld/mysqld.sock'  port: 3306  mariadb.org binary distribution
sacred2_charax_lb   | [Log system ready]
sacred2_charax_lb   | 
sacred2_charax_lb   | Unhandled Exception:
sacred2_charax_lb   | System.DllNotFoundException: System.Data.SQLite.dll assembly:<unknown assembly> type:<unknown type> member:(null)
sacred2_charax_lb   |   at (wrapper managed-to-native) System.Data.SQLite.UnsafeNativeMethods.sqlite3_config_none(System.Data.SQLite.SQLiteConfigOpsEnum)

 

This is my folder structure

 

find . -name \* -print
.
./gameserver.docker-compose.yml
./volume
./volume/lb
./volume/lb/BouncyCastle.Crypto.dll
./volume/lb/S2Lobby.exe.config
./volume/lb/S2Library.dll
./volume/lb/System.Data.SQLite.dll
./volume/lb/S2Lobby.exe
./volume/lb/lobby_log.txt
./volume/lb/ip.cfg
./volume/gs
./volume/gs/vanilla
./volume/gs/vanilla/pak
./volume/gs/vanilla/pak/spawn.zip
./volume/gs/vanilla/pak/generic.zip
./volume/gs/vanilla/pak/persector.zip
./volume/gs/vanilla/scripts
./volume/gs/vanilla/scripts/autoexec.txt
./volume/gs/vanilla/scripts/behaviour.txt
./volume/gs/vanilla/scripts/genMipMapInfo.txt
./volume/gs/vanilla/scripts/shared
./volume/gs/vanilla/scripts/shared/itemtype.txt
./volume/gs/vanilla/scripts/shared/typification.txt
./volume/gs/vanilla/scripts/shared/staticinfo.txt
./volume/gs/vanilla/scripts/shared/iteminfo.txt
./volume/gs/vanilla/scripts/shared/spells.txt
./volume/gs/vanilla/scripts/shared/material.txt
./volume/gs/vanilla/scripts/shared/defines.txt
./volume/gs/vanilla/scripts/shared/creatureinfo.txt
./volume/gs/vanilla/scripts/shared/books.txt
./volume/gs/vanilla/scripts/server
./volume/gs/vanilla/scripts/server/questscripts.txt
./volume/gs/vanilla/scripts/server/weather.txt
./volume/gs/vanilla/scripts/server/blueprint.txt
./volume/gs/vanilla/scripts/server/equipsets.txt
./volume/gs/vanilla/scripts/server/pathObjects.txt
./volume/gs/vanilla/scripts/server/spawn.txt
./volume/gs/vanilla/scripts/server/quest.txt
./volume/gs/vanilla/scripts/server/region.txt
./volume/gs/vanilla/scripts/server/heroes
./volume/gs/vanilla/scripts/server/heroes/dryadin.txt
./volume/gs/vanilla/scripts/server/heroes/templeguard.txt
./volume/gs/vanilla/scripts/server/heroes/seraphim.txt
./volume/gs/vanilla/scripts/server/heroes/centurio.txt
./volume/gs/vanilla/scripts/server/heroes/highelve.txt
./volume/gs/vanilla/scripts/server/heroes/inquisitor.txt
./volume/gs/vanilla/scripts/server/heroes/dragonmage.txt
./volume/gs/vanilla/scripts/server/waypoints.txt
./volume/gs/vanilla/scripts/server/triggerarea.txt
./volume/gs/vanilla/scripts/server/faction.txt
./volume/gs/vanilla/scripts/server/portals.txt
./volume/gs/vanilla/scripts/server/worldobjects.txt
./volume/gs/vanilla/scripts/server/worldobjecthints.txt
./volume/gs/vanilla/scripts/server/treasure.txt
./volume/gs/vanilla/scripts/server/weaponpool.txt
./volume/gs/vanilla/scripts/server/creatures.txt
./volume/gs/vanilla/scripts/server/triggervolumes.txt
./volume/gs/vanilla/scripts/server/respawn.txt
./volume/gs/vanilla/scripts/server/spawnpos.txt
./volume/gs/vanilla/scripts/server/drop.txt
./volume/gs/vanilla/scripts/server/balance.txt
./volume/gs/vanilla/scripts/landscape.txt
./volume/gs/vanilla/scripts/startPos.txt
./volume/gs/vanilla/scripts/roadmap.txt
./volume/gs/vanilla/scripts/heightmap.txt
./volume/gs/vanilla/system
./volume/gs/vanilla/system/plugin_win32platform.dll
./volume/gs/vanilla/system/orcSystem.dll
./volume/gs/vanilla/system/plugin_filesystem.dll
./volume/gs/vanilla/system/memmgr.dll
./volume/gs/vanilla/system/s2gs.exe
./volume/gs/vanilla/system/s2core.dll
./volume/gs/vanilla/system/zlib1.dll
./volume/gs/vanilla/system/tincat3.dll
./volume/gs/vanilla/system/plugins_srv.cfg
./volume/gs/vanilla/system/s2logicdll.dll
./volume/gs/vanilla/system/s2logic.dll
./volume/gs/vanilla/system/plugin_filezip.dll
./volume/gs/vanilla/system/s2vista.dll
./volume/gs/vanilla/system/stlport.5.0.dll
./volume/db
./volume/db/multi-master.info
./volume/db/ib_buffer_pool
./volume/db/ib_logfile1
./volume/db/aria_log_control
./volume/db/mysql
./volume/db/mysql/*
./lobby.docker-compose.yml
./.env
./gameserver.dockerfile

 

[SACRED 2 ONLINE MULTIPLAYER: HOW-TO, DISCUSSION & DEVELOPMENT]

I feel a bit awkward because I didn't get to put gameserver files into gs folder
Tomorrow I'm going to put it online. I'm looking forward to work on the server side storing of characters. If you're used to any kind of instant messaging platform, I'd like to join you for leading me through better understanding on the server protocol used by gs for working on this subject.

Have a good night!

[SACRED 2 ONLINE MULTIPLAYER: HOW-TO, DISCUSSION & DEVELOPMENT]

On 12/31/2019 at 2:21 PM, NegativeOne said:

That was closed net and I don't think we will get that working. If you start the game server with parameters for closed net you will see an error message that states it's not supported. They probably had special servers for closed net and unless someone figures out what the differences are we have to stick to open net servers.

I have almost set up a server on my own on linux, but I got the always restarting problem maybe bound to port misconfiguration on firewall or sorta kind of that. However I was thinking about a possible implementation of a closed net server. We may wrap the connection message sent by client into connection manager and redirecting it into an open server storing account name. In database table we may store that account's characters and allow users to only create new characters or use the local stored characters created directly on server lobby.

Hoping on an answer, I'd like to have an advice for configuring iptables to allow connections. I'm using OVH as hosting provider.

Kind Regards