Local time timezone

[LarsV]

Hi,

i installed a MSSQL 2022 LCX Container under Proxmox. In the console i set the timezone to Europe/Berlin correctly. The command "date" shows the right time.
i also set over pct set 105 --timezone host to the host timezone.

If i connect over the MS SQL Server Management Studio to the SQL Server and execute
"SELECT GETDATE()" i get 2 hours later the wrong time.
"SELECT CURRENT_TIMEZONE()" => (UTC) Coordinated Universal Time

i reboot, try different ways to solve the probleme from searching here in the forum and also at google - still nothing helps

Thats what i try in my lcx Container 105 (MSSQL) console:

• root@MSSQL: dpkg-reconfigure tzdata but there is the correct timezone
• root@MSSQL: ln -fs /usr/share/zoneinfo/Europe/Berlin /etc/localtime

At the PVE Shell

• root@PVE: pct set 105 --timezone host
• cat /etc/pve/nodes/pve/lxc/105.conf shows that "timezone: host"

Do i have to reboot the hole pve node?

thanks 4 help,
Lars

 

[gfngfn256]

I would try:

1. Shutdown the LXC​

​

2. Remove the timezone setting from the LXC with: pct set 105 --delete timezone​

​

3. Start the LXC & configure inside LXC using dpkg-reconfigure tzdata​

 

[LarsV]

Hi,

many thanks

i shutdown the LXC
remove the timezone
controll with cat /etc/pve/nodes/pve/lxc/105.conf -> now timezone is in the conf.
start LXC
open console and start dpkg-reconfigure tzdata


it's still the same, also in the Management Studio


After reboot the LXC no changes :-(

what did you mean configure inside the LXC?
is there another way besides opening the console on the left menu?

 

[gfngfn256]

is there another way besides opening the console on the left menu?

There are many ways - but that console in Proxmox GUI is good. I meant to do it in the LXC & not the host.


I don't use MS SQL Server, but skimming through a number of MS docs (example) - I believe that the SQL (on Linux) may read the system info AT THE TIME OF CREATION.

Maybe this happens at the time of database creation. So try creating a new database & compare the results.

Or possibly try recreating this LXC fresh, first setting the TZ in the LXC & then installing SQL.