You are not logged in.
Pages: 1
I noticed that the glpi from the settings gave me a warning on the time zone. In fact it had never been set.
I followed the guide of glpi and then, having a centos 7 machine, I launched the guide command: mysql_tzinfo_to_sql /usr/share/zoneinfo | mysql -p -u root mysql
these errors occurred to me:
Warning: Unable to load '/usr/share/zoneinfo/leapseconds' as time zone. Skipping it.
Warning: Unable to load '/usr/share/zoneinfo/tzdata.zi' as time zone. Skipping it.
Despite this I have now managed to select the correct time zone.
the problem is that now in a glpi screen this warning appears:
483 columns are not compatible with timezones usage.
How can I solve the problem?
it looks like I have to run this command, but where?
"Many date fields were using the DATETIME type, but this does not allow to rely on timezones. Timezone support requires all fields to use TIMESTAMP data type, but this query can be very long and therefore is not included in the standard update process.
Using the glpi:migration:timestamps command will change those fields to the correct data type, but read documentation on timezones before."
Last edited by Afol (2022-06-24 16:43:08)
Offline
Resolved.
I navigated to bin -> Console and ran the command:
php console glpi:migration:timestamps
Did the migration and now the error does not come out anymore.
Last edited by Afol (2022-06-24 16:56:53)
Offline
I had the same problem and searched for 3 days. Finally I said to myself I will try to give great privileges to the user
on the zoneinfo directory. And it worked for me.
root@mydomain:~# mysql -u root -p
Enter password:
Welcome to the MariaDB monitor. Commands end with ; or \g.
Your MariaDB connection id is 132
Server version: 10.5.15-MariaDB-0+deb11u1 Debian 11
Copyright (c) 2000, 2018, Oracle, MariaDB Corporation Ab and others.
Type 'help;' or '\h' for help. Type '\c' to clear the current input statement.
MariaDB [(none)]> GRANT SELECT ON `mysql`.`/usr/share/zoneinfo` TO 'glpi'@'localhost;
'> FLUSH PRIVILEGES;
root@mydomain:~# service apache2 restart
Last edited by Nr-02 (2022-07-08 16:49:17)
Offline
Pages: 1