[EP8] Docker repack

[HariSeldon]

Is there any command to change the server time?

List of available time zones:

timedatectl list-timezones

Filter the list:

timedatectl list-timezones | grep "Europe"

Change server timezone:

timedatectl set-timezone "Europe/London"

Note that this only changes the timezone for the main server. If you want the DB to have the same timezone, you need to rebuild the container image with the correct timezone. Then create the Cabal server.

# Create a directory for building mssql
mkdir -p mssql
cd mssql

# Creating a DOCKERFILE for mssql (change TZ here)
cat > Dockerfile <<EOF
FROM mcr.microsoft.com/mssql/server:2022-latest
USER root
RUN apt-get -y update && \
apt-get install -y tzdata && \
ln -fs /usr/share/zoneinfo/Europe/London /etc/localtime && \
dpkg-reconfigure -f noninteractive tzdata
CMD [ "/opt/mssql/bin/sqlservr" ]
EOF

# Creating an image with a set time zone
docker build --rm --no-cache -t mssql-tz-2022 .

cd

Finally, I recommend setting the correct time zone in the installer.
Changing the time zone on an already installed server can cause problems that are difficult to deal with if you are not familiar with Linux and Docker.

 

[upanddown]

Finally, I recommend setting the correct time zone in the installer.
Changing the time zone on an already installed server can cause problems that are difficult to deal with if you are not familiar with Linux and Docker.

Hey Hari, how you've been? Can I ask what part of the installation I can change to enable the option of choosing the edition? I noticed it's automatically express edition when installed, I need to enable sqlserver agent as I want to do some automation. Any advice? thank you

 

[OllyDbg]

Hey Hari, how you've been? Can I ask what part of the installation I can change to enable the option of choosing the edition? I noticed it's automatically express edition when installed, I need to enable sqlserver agent as I want to do some automation. Any advice? thank you

Auto backup is included in the repack installation

 

[HariSeldon]

Hey Hari, how you've been? Can I ask what part of the installation I can change to enable the option of choosing the edition? I noticed it's automatically express edition when installed, I need to enable sqlserver agent as I want to do some automation. Any advice? thank you

In server_create.sh.

docker run --name sql_$srv_prefix \
-e "ACCEPT_EULA=Y" \
-e "MSSQL_PID=Express" \
...

But for other editions you will need a license.
See how automation works in cron for database queries. Try to do the same.

 

[upanddown]

Auto backup is included in the repack installation

not that, I mean for example I want a procedure to do something like sending an item at midnight (in which case I'm asleep or away from my computer). I can use sqlserver agent for it, but it's not included in the express edition.

In server_create.sh.

docker run --name sql_$srv_prefix \
-e "ACCEPT_EULA=Y" \
-e "MSSQL_PID=Express" \
...

But for other editions you will need a license.
See how automation works in cron for database queries. Try to do the same.

I see, thank you! big help

 

[HariSeldon]

not that, I mean for example I want a procedure to do something like sending an item at midnight (in which case I'm asleep or away from my computer). I can use sqlserver agent for it, but it's not included in the express edition.




I see, thank you! big help

If your script name is "my_script" and your server id is "main"

Your sql query file:

/home/_server_data/sql/queries/db_my_script.sql

Crontab command:

0 0 * * * root /bin/bash /usr/bin/cabal_db my_script main Server01 -dt

The <DB_NAME> string in your query will be replaced by the DB specified in the command (in the example, it is Server01). You can use this or specify the DB name directly in the script.
For example, file db_my_script.sql:

SELECT COUNT(*) FROM [<DB_NAME>].[dbo].[cabal_character_table] WHERE [Name] = "TestCharacter"

or

SELECT COUNT(*) FROM [Server01].[dbo].[cabal_character_table] WHERE [Name] = "TestCharacter"

 

[upanddown]

If your script name is "my_script" and your server id is "main"

Your sql query file:

/home/_server_data/sql/queries/db_my_script.sql

Crontab command:

0 0 * * * root /bin/bash /usr/bin/cabal_db my_script main Server01 -dt

The <DB_NAME> string in your query will be replaced by the DB specified in the command (in the example, it is Server01). You can use this or specify the DB name directly in the script.
For example, file db_my_script.sql:

SELECT COUNT(*) FROM [<DB_NAME>].[dbo].[cabal_character_table] WHERE [Name] = "TestCharacter"

or

SELECT COUNT(*) FROM [Server01].[dbo].[cabal_character_table] WHERE [Name] = "TestCharacter"

Thank you!

I was looking at the wrong section of the file, I was getting an example from the auto backup so that's why I'm confused.

 

[radiatos]

Hello,

i can't start server
ChatNode01
EventMgrSvr
AgentShop_01
WorldSvr_01_01
LoginSvr_01
Failed.

Hi, i have the same Error.

When i look at the logs, the are always that error:

[##ERROR##] connect 127.0.0.1:23991 fail
[##ERROR##] Link(): link open fail(Automatic), Exit
[##ERROR##] RunServer(): active fail

i use debian 11

 

[HariSeldon]

Hello,

Hi, i have the same Error.

When i look at the logs, the are always that error:

[##ERROR##] connect 127.0.0.1:23991 fail
[##ERROR##] Link(): link open fail(Automatic), Exit
[##ERROR##] RunServer(): active fail

i use debian 11

You need to get used to looking at all available logs, not just the first one you come across.

Port 23991 - GlobalMgrSvr. If GlobalMgrSvr doesn't work - most likely there is a problem in DB agents.

P.S. Make sure you specified the correct credentials for connecting to the database, and the user/password are correct for MS SQL (there is a link to the documentation in the guide).

 

[radiatos]

Yes, I see it...Apparently I can't establish a connection to the SQL Server. Does the install.sh install the mssql server?

I tried now with a fresh install, but now the mssql password didn´t work. I can type anything, it´s always gives me a error.

 

[marlmarl]

i tried default password but always error
mssql password error

 

[MrSensei]

i tried default password but always error
mssql password error

View attachment 264808

You're promoting yourself as a developer, but you don't see what the error says??

 

[marlmarl]

You're promoting yourself as a developer, but you don't see what the error says??

did u try use docker right now/?

 

[MrSensei]

did u try use docker right now/?

Yes, been using it for the past 3 years and it says exactly what's the issue is.

I'm not sure how people fail to handle the most simple installation that has been automated to the point where it can almost be called "one click" and trial and error also became a thing of the past.

 

[marlmarl]

try to install now. check the error

Here

 

[cabaltestserver]

In server_create.sh.

docker run --name sql_$srv_prefix \
-e "ACCEPT_EULA=Y" \
-e "MSSQL_PID=Express" \
...

But for other editions you will need a license.
See how automation works in cron for database queries. Try to do the same.

mr hari can i ask if there is a chance that will you share your battle pass system in website

 

[radiatos]

I think, the Installation via docker use old links for mssql. It didn't install right, so i've tried to install it manually, but it didn't work properly.

MrSensei

You are a Moderator and have experience with the Docker. Would be nice when you can help, when User have Problems here.

 

[radiatos]

Try to stop the SQL Docker installation by pressing CTRL + C. Then check the password stored on configuration file. It's seems that the password FIXED even it's already changed on new_server.conf. Weird!


Easy solution:
- Edit the new_server.conf before to upload on server side. Making sure everything is OK.

And that is really weird....The Passwort match! But i can´t connect to sql-server via Navicat....didn´t know whats the Problem. I just comment out the check for password checking oder server_create.sh...Otherwise i get the same error as marlmarl

so...where´s the problem...XD

 

[marlmarl]

And that is really weird....The Passwort match! But i can´t connect to sql-server via Navicat....didn´t know whats the Problem. I just comment out the check for password checking oder server_create.sh...Otherwise i get the same error as marlmarlView attachment 264826View attachment 264827

so...where´s the problem...XD

did u fix this error ?

 

[radiatos]

did u fix this error ?

Not really...the install.sh doesn´t install mssql-tools, so i install it for myself, but no luck.