Rocksolid Light

Welcome to Rocksolid Light

mail  files  register  newsreader  groups  login

Message-ID:  

No problem is insoluble. -- Dr. Janet Wallace, "The Deadly Years", stardate 3479.4

devel / comp.databases.mysql / Re: Time zone, after reboot comes back to SYSTEM (Debian Bookworm)

SubjectAuthor
* Time zone, after reboot comes back to SYSTEM (Debian Bookworm)^Bart
`* Time zone, after reboot comes back to SYSTEM (Debian Bookworm)J.O. Aho
 `- Time zone, after reboot comes back to SYSTEM (Debian Bookworm)^Bart

1
Time zone, after reboot comes back to SYSTEM (Debian Bookworm)

<uia8le$d8t0$1@dont-email.me>

  copy mid

https://news.novabbs.org/devel/article-flat.php?id=215&group=comp.databases.mysql#215

  copy link   Newsgroups: comp.databases.mysql
Path: i2pn2.org!i2pn.org!eternal-september.org!feeder2.eternal-september.org!news.eternal-september.org!.POSTED!not-for-mail
From: gabriele1NOSPAM@hotmail.com (^Bart)
Newsgroups: comp.databases.mysql
Subject: Time zone, after reboot comes back to SYSTEM (Debian Bookworm)
Date: Mon, 6 Nov 2023 09:38:06 +0100
Organization: A noiseless patient Spider
Lines: 53
Message-ID: <uia8le$d8t0$1@dont-email.me>
MIME-Version: 1.0
Content-Type: text/plain; charset=UTF-8; format=flowed
Content-Transfer-Encoding: 7bit
Injection-Date: Mon, 6 Nov 2023 08:38:06 -0000 (UTC)
Injection-Info: dont-email.me; posting-host="0090fe2d1d457f01894158c86078e5d7";
logging-data="435104"; mail-complaints-to="abuse@eternal-september.org"; posting-account="U2FsdGVkX19VeHeticMKP9r3jIxKiPwTjg9VxRgHBlQ="
User-Agent: Mozilla Thunderbird
Cancel-Lock: sha1:PNJIisA6uEHvDwfhafUcywymd1s=
Content-Language: en-US
 by: ^Bart - Mon, 6 Nov 2023 08:38 UTC

Hi guys,

I login to MariaDB and I do:

MariaDB [(none)]> SHOW GLOBAL VARIABLES LIKE 'time_zone';
+---------------+--------+
| Variable_name | Value |
+---------------+--------+
| time_zone | SYSTEM |
+---------------+--------+
1 row in set (0,001 sec)

After it I do:

MariaDB [(none)]> SET GLOBAL time_zone = 'Europe/Rome';
Query OK, 0 rows affected (0,004 sec)

And I have:

MariaDB [(none)]> SHOW GLOBAL VARIABLES LIKE 'time_zone';
+---------------+-------------+
| Variable_name | Value |
+---------------+-------------+
| time_zone | Europe/Rome |
+---------------+-------------+
1 row in set (0,001 sec)

After a reboot, like what I wrote in the subject, the time zone value
comes back to system.

I did from command line:
# timedatectl set-timezone Europe/Rome

I have:

# timedatectl
Local time: lun 2023-11-06 09:31:30 CET
Universal time: lun 2023-11-06 08:31:30 UTC
RTC time: lun 2023-11-06 08:31:30
Time zone: Europe/Rome (CET, +0100)
System clock synchronized: yes
NTP service: active
RTC in local TZ: no

I inserted the timezone in 50-mysqld_safe.cnf

But after a reboot I have always the value sets on System.

I'll check asap from Knime if the timezone issue is fixed but I think I
did everything to fix it or I should do other things?

Regards.
^Bart

Re: Time zone, after reboot comes back to SYSTEM (Debian Bookworm)

<kqs7m5Fjgu0U1@mid.individual.net>

  copy mid

https://news.novabbs.org/devel/article-flat.php?id=216&group=comp.databases.mysql#216

  copy link   Newsgroups: comp.databases.mysql
Path: i2pn2.org!rocksolid2!news.neodome.net!fu-berlin.de!uni-berlin.de!individual.net!not-for-mail
From: user@example.net (J.O. Aho)
Newsgroups: comp.databases.mysql
Subject: Re: Time zone, after reboot comes back to SYSTEM (Debian Bookworm)
Date: Mon, 6 Nov 2023 14:23:17 +0100
Lines: 50
Message-ID: <kqs7m5Fjgu0U1@mid.individual.net>
References: <uia8le$d8t0$1@dont-email.me>
Mime-Version: 1.0
Content-Type: text/plain; charset=UTF-8; format=flowed
Content-Transfer-Encoding: 8bit
X-Trace: individual.net 77sObdGKvHZdL/BDGiAGQQEHzTba/Ujj8UEFdJQkubbc3veB3+
Cancel-Lock: sha1:2ppxN/wHiUzYbCfrrsvFf/5sdCg= sha256:4cn71ZdnxPcRe16CCAk3zGzTDu30tGTuQLwyOJJcvlo=
User-Agent: Mozilla Thunderbird
Content-Language: en-US-large
In-Reply-To: <uia8le$d8t0$1@dont-email.me>
 by: J.O. Aho - Mon, 6 Nov 2023 13:23 UTC

On 06/11/2023 09.38, ^Bart wrote:
> Hi guys,
>
> I login to MariaDB and I do:
>
> MariaDB [(none)]> SHOW GLOBAL VARIABLES LIKE 'time_zone';
> +---------------+--------+
> | Variable_name | Value  |
> +---------------+--------+
> | time_zone     | SYSTEM |
> +---------------+--------+
> 1 row in set (0,001 sec)
>
> After it I do:
>
> MariaDB [(none)]> SET GLOBAL time_zone = 'Europe/Rome';
> Query OK, 0 rows affected (0,004 sec)
>
> And I have:
>
> MariaDB [(none)]> SHOW GLOBAL VARIABLES LIKE 'time_zone';
> +---------------+-------------+
> | Variable_name | Value       |
> +---------------+-------------+
> | time_zone     | Europe/Rome |
> +---------------+-------------+
> 1 row in set (0,001 sec)
>
> After a reboot, like what I wrote in the subject, the time zone value
> comes back to system.

https://mariadb.com/kb/en/time-zones/

[mariadb]
default_time_zone = 'Europe/Rome'

or if you want the system time to also be the same:
sudo ln -sf /usr/share/zoneinfo/Europe/Rome /etc/localtime

> I inserted the timezone in 50-mysqld_safe.cnf

That will apply when running in safe mode.

I do favor UTC as timezone as then you don't have to bother about the
heart attack causing time change twice a year.

--
//Aho

Re: Time zone, after reboot comes back to SYSTEM (Debian Bookworm)

<uiia9k$250oi$1@dont-email.me>

  copy mid

https://news.novabbs.org/devel/article-flat.php?id=217&group=comp.databases.mysql#217

  copy link   Newsgroups: comp.databases.mysql
Path: i2pn2.org!i2pn.org!usenet.goja.nl.eu.org!3.eu.feeder.erje.net!feeder.erje.net!news2.arglkargh.de!news.karotte.org!gandalf.srv.welterde.de!eternal-september.org!feeder3.eternal-september.org!news.eternal-september.org!.POSTED!not-for-mail
From: gabriele1NOSPAM@hotmail.com (^Bart)
Newsgroups: comp.databases.mysql
Subject: Re: Time zone, after reboot comes back to SYSTEM (Debian Bookworm)
Date: Thu, 9 Nov 2023 10:55:00 +0100
Organization: A noiseless patient Spider
Lines: 28
Message-ID: <uiia9k$250oi$1@dont-email.me>
References: <uia8le$d8t0$1@dont-email.me> <kqs7m5Fjgu0U1@mid.individual.net>
MIME-Version: 1.0
Content-Type: text/plain; charset=UTF-8; format=flowed
Content-Transfer-Encoding: 7bit
Injection-Date: Thu, 9 Nov 2023 09:55:00 -0000 (UTC)
Injection-Info: dont-email.me; posting-host="3237512ee9fe22d8647d15dd30fa7015";
logging-data="2261778"; mail-complaints-to="abuse@eternal-september.org"; posting-account="U2FsdGVkX18hdGrqQiQKY3ApLYPNlKoSmvYrL2ZjILk="
User-Agent: Mozilla Thunderbird
Cancel-Lock: sha1:czP3WFcyNAyE1m1BHCdB+JmWyE8=
In-Reply-To: <kqs7m5Fjgu0U1@mid.individual.net>
Content-Language: en-US
 by: ^Bart - Thu, 9 Nov 2023 09:55 UTC

> https://mariadb.com/kb/en/time-zones/
>
> [mariadb]
> default_time_zone = 'Europe/Rome'

I did it in /etc/mysql/mariadb.conf.d/nano 50-server.cnf

> or if you want the system time to also be the same:
> sudo ln -sf /usr/share/zoneinfo/Europe/Rome /etc/localtime

Thanks also for this info! :)

>> I inserted the timezone in 50-mysqld_safe.cnf
>
> That will apply when running in safe mode.

You got the point, it is a mistake to modify the file for the safe mode
for what I need.

> I do favor UTC as timezone as then you don't have to bother about the
> heart attack causing time change twice a year.

Also in this case you got the point! :)

Thanks for your reply! :)

^Bart

1
server_pubkey.txt

rocksolid light 0.9.8
clearnet tor