After enabling LogNet it seems to work fine again and also shows the playercount again in DSL so issue was on my side, thanks for the help and the pointing to the right direction.

2 Likes

But I’m still not sure if the steam CMD is really up to date with the version we play due to some BUGs that I had reported before in other posts but I’ll deal with that in another post within the forum:face_with_monocle:

Your posts had server logs: that does not provide any information about what SteamCMD did.

If you suspect a problem with DSL/SteamCMD, that’s the SteamCMD Log and Launcher Logs tabs which are interesting, because that’s where we see the actual command line used to ask SteamCMD to update the server, which product id, which mods, which branch, etc…

1 Like

Not sure, where do you see that, which version of Windows, what type of machine hardware?

Windows 10 Pro.

It is about prioritizing programs vs background services. Background services are usually recommended for servers.

https://www.tenforums.com/tutorials/89429-adjust-processor-resources-best-performance-windows-10-a.html#option1

~WRD0000.jpg

I honestly that does not make much difference, but what can make a hell of difference are things like:

  • Having anti-virus exclusions so the game files and folders are not scanned
  • Removing useless things like disk indexing, Cortana, weather and news updates, etc…
  • Having the game installed on a SSD
  • Doing things like running the game server on a different set of CPU cores (like have windows use Core 0 and have the game server run on the cores at the end

What I generally do is to open the resource monitor, and check the various tabs (cpu, disk, network) and look at what is actually accessing resources, and if really something should not be accessing anything, I either add some exclusions or I stop services

2 Likes

This sounds like it lead to a failed relationship…

Basically, a server runs best when all it’s doing is server, which should come as no surprise. Fastest cpu, fastest ram (with enough space that windows doesnt start caching crap) and the fastest sdd you can afford (with the correct pci bus to take advantage of it). Shut down anything else that isnt necessary for the server to run. What I love is that with the right hardware, the server will basically be idling silently at low temp. I cant even notice my server is on even tho it runs 24/7.

1 Like

Toolguy realmente descobri um problema porém não sei como resolver:

Na primeira pasta (pasta 1), o save atual do meu DSL não exibe a masmorra de Kurak.

Na segunda pasta (pasta 2), após uma nova instalação do DSL com o mesmo arquivo DSL usado na “pasta 1”, o problema da masmorra de Kurak não ocorre.

Como mencionado anteriormente, na pasta 1 estão todos os arquivos de base do jogo e o save de todos os jogadores no servidor. No entanto, a masmorra de Kurak não está sendo exibida. Esse problema não acontece na pasta 2.

Ao transferir o arquivo game.db da pasta 1 para a pasta 2, o jogo funciona, mas a masmorra de Kurak também não é exibida.

ao instalar o DSL sem configurar corretamente as portas de IP, a masmorra de Kurak não é exibida na “pasta 1”.

Por outro lado, na “pasta 2”, o DSL foi instalado com todas as configurações de antivírus e firewall atualizadas e funcionando corretamente, e a masmorra de Kurak é exibida sem problemas. No entanto, ao copiar o arquivo game.db da “pasta 1” para a “pasta 2” para não perder o progresso do jogo, algo acontece e a masmorra de Kurak continua sem funcionar, mesmo estando dentro de uma pasta em que ela funciona normalmente.

Há algum elemento que não foi instalado ou configurado corretamente quando as portas e configurações não estão adequadas durante a instalação. Além disso, outro problema é que, mesmo após realizar reparos e abrir as portas de IP anteriormente fechadas, o DSL não ajusta automaticamente as configurações referentes aos valores das portas de IP, que agora estão abertas.

:sleepy: Caso não haja nenhuma outra alternativa disponível, a próxima medida a ser tomada seria executar uma limpeza completa (“WIPE”) no servidor DSL. No entanto, antes de chegar a essa etapa vou esperar a solução se houver de sua resposta porém, aqui estão algumas dicas para aqueles que estão instalando o DSL e acreditam que não terão problemas após configurar as portas de IP.

Quais arquivos devo atualizar junto com o game.db para que a masmorra de Kurak funcione corretamente dentro de um servidor DSL?

That is a problem with the game.db itself, not the launcher. By your own tests, you have isolated it to the game database. That means it has nothing to do with the launcher. The launcher just starts the server. A corrupted database has nothing to do with the launcher.

OK, got it! Thank you!

~WRD0000.jpg

Claro, você mesmo pode testar se quiser, e qualquer outra pessoa pode seguir estas etapas:

Deixe-me explicar por que o arquivo game.db é baixado quando iniciamos o DSL. No entanto, ele falha ao baixar ou configurar qualquer coisa se as portas não forem abertas corretamente antes de instalar qualquer DSL. Vou mostrar como fiz a instalação e porque isso se torna um problema ao iniciar o DSL sem abrir as portas em um IP antes de iniciar o DSL pela primeira vez e baixar e instalar os arquivos:

Nota: No Brasil, precisamos informar ao provedor de serviços de Internet para abrir as portas IP, então a maioria das pessoas provavelmente encontrará esse problema, e algumas podem nem ter um servidor DSL, apesar de terem um PC que atenda às especificações exigidas.

  1. Instale o DSL em um IP com portas fechadas sem verificar o endereço MAC ou testar as portas.

  2. Entre no jogo dentro do servidor que você acabou de instalar usando o DSL com portas fechadas.

  3. Vá para a masmorra KURAK e tente entrar ou ativar o portal que leva à masmorra.

  4. Saia do jogo e atualize as portas IP, abrindo todas elas.

  5. Entre novamente no jogo com as portas abertas e o firewall ativado e verifique a masmorra KURAK novamente para ver se funciona corretamente.

@darthphysicist Obrigado por ajudar a resolver esse problema. Espero que você possa realizar os testes em algum momento e nos ajude a encontrar uma solução antes de “Age Of War”. No entanto, gostaria de lembrar que eu sei como resolver o problema com uma simples limpeza (WIPE), mas isso resultará na exclusão de todo o progresso do servidor e de todos os jogadores. :relieved:

Apesar de parecer simples usar o arquivo game.db para jogar em um servidor DSL, na prática isso se torna um problema. Por exemplo, se você tentar transferir o arquivo game.db de um DSL configurado com portas abertas para outro DSL com portas fechadas mesmo sendo abertas posteriormente, o resultado será o mesmo, o arquivo não funcionará corretamente. Este é o problema que estou enfrentando no momento.

Para esclarecer, o problema que estou relatando não se refere a fechar as portas de um DSL já instalado. Estou me referindo a instalar um DSL em um IP que possui as portas fechadas. Mesmo que eu abra as portas depois de entrar no jogo, ainda não consigo visualizar a masmorra de Kurak.

I did the tests generating a modified “Multihome” which allowed me to generate a game.db, but not get online.
In my case, the Transportory stone was not even generated.
The generated game.db was 20 kb smaller than the default, after analyzing the game.db it was identified that it didn’t generate all the writes in the tables inside the game.db
After some tests I was able to recreate the Transportory stone working 100%.

The procedure will delete from game.db some files Transportory stone that prevent it from working, in my tests after the server was restarted in 100% of the time (more than 20 tests) recreated the Transportory stone with the option to light up working 100%.

Attention: If you test and I believe that will correct the problem of your game.db for this issue of Kurak make for safety a backup of your game.db and save in a different folder if you need to return with your original game.db.


1- Open Windows Notepad, paste the text below, click save, change the “Type” to “All text files (*)” and in “Name” put: InactiveCleanout_Kurak.bat

@echo Inactive Cleanout In Progress
for %%a in (game.db) do (
echo “%%a”
sqlite3.exe %%a < InactiveCleanout_Kurak.sql
)
exit


2- Open Windows Notepad, paste the text below, click save, change the “Type” to “All text files (*)” and in “Name” put: InactiveCleanout_Kurak.sql

delete from actor_position where class like ‘%BP_PL_Kurak_Teleporter.BP_PL_Kurak_Teleporter_C’;
delete from static_buildables where name like ‘%BP_PL_Kurak_Teleporter%’;
VACUUM;
REINDEX;
ANALYZE;
pragma integrity_check;
exit


  • The files created need to be placed inside the game folder …\DedicatedServerLauncher\ConanExilesDedicatedServer\ConanSandbox\Saved - place where will be your game.db and where is also sqlite3.exe

  • The server must be stopped to make the change in the game.db

  • Double click on the file with .bat extension “InactiveCleanout_Kurak.bat”

Then restart the server, check if it will appear for you the item to light the Transportory stone and if it will work as my tests performed.
I hope I was able to help you.

2 Likes

Obrigado por testar e fazer uma alternativa para o funcionamento da masmorra e realmente como pode ver existe o problema e pode afetar qualquer servidor privado DSL ou dedicados, estou testando e já analizei os comandos que estou testando vou editar o texto assim que terminar…

@Funcom_Community DSL deveria ter as configurações ajustada, claramente há algo de errado com os arquivos baixados :thinking:

Yes, there is a problem with your database, but NO, the DSL isn’t causing a problem with your Kurak dungeon. What you’re experiencing is a corrupted database which has absolutely nothing to do with the DSL (as you’ve been told several times). To fix your problem you can either start over with a fresh database (everyone loses their progression), or try to fix your database manually. If you’re unsure how to do the later then the former may be your only option (@Carlos_SLeite tried to help you with this).

A corrupted database can affect any player or server at any time (it’s a game issue, not a DSL problem) and is usually indicative of mod usage.

Prefiro não realizar um reset completo… Por favor, tente testar conforme mencionei anteriormente e verá que não é apenas o meu dispositivo que apresenta problemas. Peço que não me mencione, a menos que tenha algo construtivo a dizer sobre o assunto.

@Toolguy,

This issue game.db corrupted, in my opinion the best option for All would be that the files downloaded within the DSL allow to create a game.db 100% offline without relying on the internet, blocked ports, External IP or Multihome.

To avoid this situation of creating a corrupted “game.db” database, that is, with partial absence of information due to internet connection failures or blocked ports I suggest:

  • Before DSL start the database or especially create a new database perform an initial routine of internet connection tests, this way ensure:

  • That the ports are cleared;
    Currently there is an option to “Test Port Accessibility” for manual testing, if you can use this feature in the DSL startup routine you may be able to partially resolve the situation.

  • That the DSL has access to the Internet.
    If possible creating a routine to test if the “External IP” and “Multihome” are accessing the internet might be one way.

If it is possible to implement these checks I believe it may eliminate this situation of corrupted database that can be identified late and force server administrators to reset the database “wipe”.

I hope I have helped.

1 Like

@tiagoturilli @Carlos_SLeite you completely both confused me with the link between open ports, closed ports and the game db.

Although it seems simple to use the game.db file to play on a DSL server, in practice this becomes a problem. For example, if you try to transfer the game.db file from a DSL configured with ports open to another DSL with ports closed even if they are opened afterwards, the result will be the same, the file will not work correctly. This is the problem I’m facing at the moment.

To clarify, the problem I’m reporting is not about closing ports on an already installed DSL. I’m referring to installing a DSL on an IP that has the ports closed. Even if I open the doors after logging into the game, I still can’t see Kurak’s dungeon.

The DSL does not care about the game db (other than when doing backups), it does not open any ports, all it does is to allow you to select the ports using a UI instead of having to edit .ini files.

To avoid this situation of creating a corrupted “game.db” database, that is, with partial absence of information due to internet connection failures or blocked ports I suggest:

  • Before DSL start the database or especially create a new database perform an initial routine of internet connection tests, this way ensure:

The DSL does not create the gamedb, all it does is to install or update the game from Steam, and that’s the game itself that does create the game database.

If starting the game without a working internet setup does corrupt the database, it’s something that needs to be signaled to the Conan Exiles development team, but there’s nothing the DSL can do about it.


So, let me ask a question just to clarify things: Are you saying that basically if you have a working game server, with your Kurak dungeon and everything, then you shut it down, you unplug the ethernet cable (or cut wifi), you start the game server again, that results in a corrupted game.db?

Eu não disse que fiz ou que aconteceu isso. Eu nunca fico sem internet e nunca desligo minha conexão. Eu apenas pedi para minha provedora de internet abrir as portas depois da instalação do DSL. No entanto, é importante entender que se alguém instalar o DSL com as portas de IP fechadas, ocorrerá um problema conhecido como ‘BUG na masmorra de Kurak’ e o serviço não irá funcionar. Já expliquei tudo isso em outro post anteriormente, mas não mencionei nada sobre desligar a internet. :thinking:

Vou tentar enviar um reporte desse erro para o suporte de conan mas espero que Mayra possar olha também sobre esse assunto, meus arquivos game,db com lembrando que esse BUG na masmorra de Kurak acontece ao usar o DSL usando a Internet ON-LINE com as portas de IP exemplo: 7777 fechadas
image

I performed more tests:
I will try to be objective:

  • The server game.db running with Kurak’s dungeon and everything else will not get corrupted if entered with the internet disconnected;

  • The game.db will not get corrupted if created with the internet disconnected (test performed on the game opening on Steam with the internet disconnected);

  • The game.db will be corrupted when created by the DSL when the routine runs and identifies some failure and closes the server. The failures that are known so far are: Closed ports (@tiagoturilli ) and Incorrect Multihome (@Carlos_SLeite ).

When monitoring the failure happening I notice that when creating the game.db it is 220 kb (game_backup_2.db), I analyzed it and it is practically all empty with only the tables created, but when the DSL closes the server adds lines within the tables of game. db tables, as it is missing the Kurak row in the “actor_position” table (it was what was missing in my tests) and the Kurak row was created in the “static_buildables” table the access to Kurak Dungeon will not be allowed even when restarting the server in a 100% working DSL will not correct the missing game.db data

The process I described above for @tiagoturilli should solve his problem, it deletes from the “actor_position” and “static_buildables” tables Kurak’s data, this way when the server is restarted it will completely recreate Kurak’s lines, I hope he does the test with a copy of the game.db keeping the original saved in another folder to ensure the information contained in his server’s game.db.
image

Sim, estou testando no momento … :mag:

I don’t understand what this means.

The DSL does not create a game.db, all it does is to start the server, and by the way you can do that manually by launching the ConanExilesDedicatedServer\StartServer.bat manually.

when the routine runs and identifies some failure and closes the server.

What are the specific error messages you see when the ports are not open or Multihome is not set properly? (and please, just the relevant error messages, not the entire log file).