keguira
commented
6 months ago I don't understand this issue or maybe it's a misunderstanding of what is defined, where and "what for" (and maybe a label thing)
The timezone (or offset by default) defined in Setup > General > Default values corresponds to the time zone applied by default for all users unless you ovewrite it at user-level.
This configuration handles the timezone function (Europe/Lisbon for example).
In authentication, the offset (and not timezone compliant) corresponds to an offset applied in the use case of ldap sync . It's the time_offset value stored in glpi_config table and it seems to be a legacy thing. This is not used anywhere else.
There is no place in GLPI where you declare your server-side configurated timezones / offsets (OS, mysql/mariadb and php levels) as they can use a specific value or the OS one.
As for version 10.x and 11.x, all points in time (datetime) are still stored as TIMESTAMP (so relative to UTC with a range from 1970 to 2038).
litbea
trasher
Code of Conduct
Is there an existing issue for this?
Version
10.0.14
Bug description
GLPI server time zone should be located in Setup > General, instead of /front/auth.settings.php in my opinion.
Relevant log output
No response
Page URL
/front/auth.settings.php
Steps To reproduce
No response
Your GLPI setup information
Information about system installation and configuration
Server
Operating system: Linux soporte.uva.es 5.15.0-205.149.5.1.el9uek.x86_64 #2 SMP Fri Apr 5 11:29:36 PDT 2024 x86_64 PHP 8.0.30 fpm-fcgi (Core, PDO, Phar, Reflection, SPL, SimpleXML, Zend OPcache, apcu, bz2, calendar, cgi-fcgi, ctype, curl, date, dom, exif, fileinfo, filter, ftp, gd, gettext, hash, iconv, intl, json, ldap, libxml, mbstring, mysqli, mysqlnd, openssl, pcre, pdo_mysql, pdo_sqlite, session, sockets, sodium, sqlite3, standard, tokenizer, xml, xmlreader, xmlwriter, xsl, zip, zlib) Setup: max_execution_time="600" memory_limit="64M" post_max_size="8M" safe_mode="" session.save_handler="files" upload_max_filesize="2M" disable_functions="" Software: Apache/2.4.57 (Oracle Linux Server) OpenSSL/3.0.7 () Mozilla/5.0 (Windows NT 10.0; Win64; x64; rv:125.0) Gecko/20100101 Firefox/125.0 Server Software: MariaDB Server Server Version: 10.11.7-MariaDB Server SQL Mode: STRICT_TRANS_TABLES,ERROR_FOR_DIVISION_BY_ZERO,NO_AUTO_CREATE_USER,NO_ENGINE_SUBSTITUTION Parameters: glpi_user@127.0.0.1/glpi_db Host info: 127.0.0.1 via TCP/IP PHP version (8.0.30) is supported. Sessions configuration is OK. Allocated memory is sufficient. mysqli extension is installed. Following extensions are installed: dom, fileinfo, filter, libxml, json, simplexml, xmlreader, xmlwriter. curl extension is installed. gd extension is installed. intl extension is installed. zlib extension is installed. The constant SODIUM_CRYPTO_AEAD_XCHACHA20POLY1305_IETF_NPUBBYTES is present. Database engine version (10.11.7) is supported. No files from previous GLPI version detected. The log file has been created successfully. Write access to /servicio/aplicacion/static-glpi-files/_cache has been validated. Write access to /servicio/aplicacion/static-glpi-files/_cron has been validated. Write access to /servicio/aplicacion/static-glpi-files has been validated. Write access to /servicio/aplicacion/static-glpi-files/_dumps has been validated. Write access to /servicio/aplicacion/static-glpi-files/_graphs has been validated. Write access to /servicio/aplicacion/static-glpi-files/_lock has been validated. Write access to /servicio/aplicacion/static-glpi-files/_pictures has been validated. Write access to /servicio/aplicacion/static-glpi-files/_plugins has been validated. Write access to /servicio/aplicacion/static-glpi-files/_rss has been validated. Write access to /servicio/aplicacion/static-glpi-files/_sessions has been validated. Write access to /servicio/aplicacion/static-glpi-files/_tmp has been validated. Write access to /servicio/aplicacion/static-glpi-files/_uploads has been validated. PHP 8.0 is no longer maintained by its community. Even if GLPI still supports this PHP version, an upgrade to a more recent PHP version is recommended. Indeed, this PHP version may contain unpatched security vulnerabilities. Web server root directory configuration is not safe as it permits access to non-public files. See installation documentation for more details. GLPI data directories are located in a secured path. Sessions configuration is secured. OS and PHP are relying on 64 bits integers. exif extension is installed. ldap extension is installed. openssl extension is installed. Following extensions are installed: bz2, Phar, zip. Zend OPcache extension is installed. Following extensions are installed: ctype, iconv, mbstring, sodium. Write access to /servicio/aplicacion/_materiales/glpi-10014/marketplace has been validated. Timezones seems loaded in database.GLPI constants
Libraries
LDAP directories
Server: '192.168.21.24', Port: '389', BaseDN: 'ou=personal,dc=uva,dc=es', Connection filter: none, RootDN: 'uid=incidencias_uva,ou=aplicaciones,ou=gestion,dc=uva,dc=es', Use TLS: noneSQL replicas
Notifications
Plugins list
formcreator Name: Form Creator Version: 2.13.5 State: Enabled Install Method: Manual oauthimap Name: Oauth IMAP Version: 1.4.2 State: Enabled Install Method: ManualAnything else?
No response