Databaseless

Competitibia · Feb 14, 2023

why not enable tfs to run databaseless aka dont save nothing forget everything[TESTMODE] ? would be probably easier to get the headless chickens to get into it without XML for first time. need to take care of those people on old engines.

Infernum · Feb 14, 2023

headless chickens are headless chickens. why create a solution which keeps them away from setting up an actual database (which they need to at some point) instead of just directing them to solutions we have here already over the course of years and years to learn how to set one up properly just because they used old engines?

Competitibia · Feb 14, 2023

Infernum said:
headless chickens are headless chickens. why create a solution which keeps them away from setting up an actual database (which they need to at some point) instead of just directing them to solutions we have here already over the course of years and years to learn how to set one up properly just because they used old engines?

was thinking more of tfs on the go if i wanna test script for someone that Im writing why have to setup db and everything that is so much effort just to test the code 100%
especially with so many distributions.

Jpstafe · Feb 14, 2023

Competitibia said:
why not enable tfs to run databaseless aka dont save nothing forget everything[TESTMODE] ? would be probably easier to get the headless chickens to get into it without XML for first time. need to take care of those people on old engines.

think those people on old engines ,should move on. instead of a whole community adapting things for them

Competitibia · Feb 14, 2023

Jpstafe said:
think those people on old engines ,should move on. instead of a whole community adapting things for them

there is second use

Infernum · Feb 14, 2023

Competitibia said:
was thinking more of tfs on the go if i wanna test script for someone that Im writing why have to setup db and everything that is so much effort just to test the code 100%
especially with so many distributions.

just take the time to set up basic test servers then. it'd take less time to set up a number of test servers for all distros you claim to use than it would be to wait for someone to create a likely incompatible tfs patch to remove pretty much every database interaction in the source code for every single one of those distros

hellboy · Feb 14, 2023

Competitibia said:
was thinking more of tfs on the go if i wanna test script for someone that Im writing why have to setup db and everything that is so much effort just to test the code 100%
especially with so many distributions.

Create basic docker-compose.yml and run it on docker for testing purpose?

hellboy · Feb 22, 2023

@Competitibia

We need:

docker image named tfs based on Dockerfile in the forgotten server git repository (You need change version of alpine linux in tag 1.4.2)
create directory "docker" for mysql files
put in config.lua

Code:

mysqlHost = "db"
mysqlUser = "tfs"
mysqlPass = "tfs"
mysqlDatabase = "tfs"
mysqlPort = 3306

docker-compose.yml

Code:

version: "3.7"
services:
  db:
    image: mariadb
    container_name: "mariadb-container"
    restart: unless-stopped
    environment:
      - MYSQL_DATABASE=tfs
      - MYSQL_USER=tfs
      - MYSQL_PASSWORD=tfs
      - MYSQL_RANDOM_ROOT_PASSWORD=yes
    volumes:
      - ./docker/db-volume:/var/lib/mysql
    ports:
      - "127.0.0.1:3306:3306"

  tfs:
    image: tfs
    container_name: "tfs-container"
    ports:
      - "127.0.0.1:7171:7171"
      - "127.0.0.1:7172:7172"
    depends_on:
      - db
    volumes:
      - ./data:/srv/data
      - ./config.lua:/srv/config.lua

How to use?
1. go into tfs directory
2. docker-compose up
3. connect to database using any sql client (127.0.0.1 3306) and import schema
4. add some user in database
5. play on 127.0.0.1

Michael Orsino · Feb 23, 2023

You lost all the headless chickens at docker-compose up and then again at each step after
A docker solution is fantastic for experienced developers, but I don't think it is the answer for new users entering the community with no knowledge (i.e. how most of us started our open tibia journeys)

Sqlite was a great alternative to XML and a soft introduction into databases for new and existing users alike. I can't remember why it got deprecated, but it was likely to clean up the codebase a ton, or maybe sqlite couldn't support the direction that TFS was heading. Not sure, probably somebody will be around who can answer that question though!

I'm not sure how viable it is, but having an embedded mysql server included in TFS could make onboarding easier, and this is probably the avenue I would investigate further. Embedded mysql server with a default localhost only config and reintroducing an in-game account manager, and there you have it, we're back to download & run (which in my (unpopular opinion) is a damn good thing for the community)

Competitibia · Feb 23, 2023

Michael 4463 said:
You lost all the headless chickens at docker-compose up and then again at each step after
A docker solution is fantastic for experienced developers, but I don't think it is the answer for new users entering the community with no knowledge (i.e. how most of us started our open tibia journeys)

Sqlite was a great alternative to XML and a soft introduction into databases for new and existing users alike. I can't remember why it got deprecated, but it was likely to clean up the codebase a ton, or maybe sqlite couldn't support the direction that TFS was heading. Not sure, probably somebody will be around who can answer that question though!

I'm not sure how viable it is, but having an embedded mysql server included in TFS could make onboarding easier, and this is probably the avenue I would investigate further. Embedded mysql server with a default localhost only config and reintroducing an in-game account manager, and there you have it, we're back to download & run (which in my (unpopular opinion) is a damn good thing for the community)

exactly i have evolera files here with sqlite executable if yyou are interested in porting it to tfs 1.5 its tfs 0.3.6 ccrying damson files

iNux · Feb 23, 2023

There are different guides of how to execute Linux commands that does everything for you, setup the server, database , connect the database to the server, apply AAC and start the server . I believe that there is a thread called ONE SCRIPT TO...

We have everything, we just have to find it and use it. I do like the idea of using docker images though

Source · Feb 23, 2023

I use SQLite personally, though I'm not planning on releasing my from scratch server for free anytime soon as it took a lot of work and I don't feel this community as a whole (there are minor exceptions, but again as a whole) deserve everything for free. Most people here that are building anything remotely professional take a price for their services.

Btw the downside with SQLite, probably the same with XML, is that serversaves are likely going to be way slower because SQLite write speeds are atrocious. It also doesn't support parallel connections I believe, so I'm not sure you can use it with a website as well as a server at the same time.
But for my use it's perfect, at least for now, might swap it out for MySQL somewhere down the road.

hellboy · Feb 23, 2023

SQLite was removed in TFS 1.0. As far as I remember TFS 1.0 is based on TFS 0.2. But I can't find TFS 0.2 source repository.

Changelog 1.0

A free and open-source MMORPG server emulator written in C++ - otland/forgottenserver

github.com

There is some comment about that SQLite. I'm not sure if it's valid.

Compiling - The Forgotten Server 1.1 SQLite

Hello, Guys I need help the TFS 1.1, i look for the server tfs and i can't localize the SQLite. I need it for using database in my server. Could someone help me? Thanks.

otland.net

And here is additional database support discussion.

Add option to choose DB by alfuveam · Pull Request #2092 · otland/forgottenserver

PT-BR Olá, com esse commit, se torna possível escolher o DB, no momento testei com 2 DB: MySQL e PostgreSQL. Acho necessário desenvolver a opção para conexão com o DB via ODBC, SQLite e MariaDB. C...

github.com

Headless chickens should start to learn how to set up things. Poke with config.lua and set up local mysql server. Just google it...
I don't see other way.

Competitibia · Feb 23, 2023

hellboy said:
SQLite was removed in TFS 1.0. As far as I remember TFS 1.0 is based on TFS 0.2. But I can't find TFS 0.2 source repository.

Changelog 1.0

A free and open-source MMORPG server emulator written in C++ - otland/forgottenserver

github.com

There is some comment about that SQLite. I'm not sure if it's valid.

Compiling - The Forgotten Server 1.1 SQLite

Hello, Guys I need help the TFS 1.1, i look for the server tfs and i can't localize the SQLite. I need it for using database in my server. Could someone help me? Thanks.

otland.net

And here is additional database support discussion.

Add option to choose DB by alfuveam · Pull Request #2092 · otland/forgottenserver

PT-BR Olá, com esse commit, se torna possível escolher o DB, no momento testei com 2 DB: MySQL e PostgreSQL. Acho necessário desenvolver a opção para conexão com o DB via ODBC, SQLite e MariaDB. C...

github.com

Headless chickens should start to learn how to set up things. Poke with config.lua and set up local mysql server. Just google it...
I don't see other way.

Download and run is how you drag them into community. You would be surprised how difficult simple computer tasks can be for average person ur parents never asked u for IT help?

hellboy · Feb 24, 2023

Competitibia said:
Download and run is how you drag them into community. You would be surprised how difficult simple computer tasks can be for average person ur parents never asked u for IT help?

I guess my parents don't need to know this. Anyway the are capable of fallowing simple instruction. It's more than enough to install mysql form tutorial and edit config.lua...

If we want to get more fresh blood. Maybe we should provide good user friendly tutorials?

iNux · Mar 12, 2023

SIMPLE ALL IN ONE: From nothing to a fully working dedicated server on Ubuntu

Ubuntu is a distribution based on Debian so if you are familiar with Debian, you will know how to use Ubuntu too. This is the simplest guide how to configure your dedicated server ever. It cannot be simpler :) You need a recent Ubuntu version (20.04 minimum). It also makes TFS compilation with...

otland.net

Databaseless

Pain & Glory WHole

︈

Pain & Glory WHole

Well-Known Member

Pain & Glory WHole

︈

Intermediate OT User

Intermediate OT User

Premium User

Pain & Glory WHole

Well-Known Member

Veteran OT User

Intermediate OT User

Pain & Glory WHole

Intermediate OT User

Well-Known Member

Similar threads