cconard96
commented
1 year ago I was able to identify that the end_date column value changed from 2050-01-01 00:00:00 to 0000-00-00 00:00:00. After changing the 2050-01-01 00:00:00 end_date user value to NULL I was able to login as expected.
This is a MySQL issue, not a GLPI bug. MySQL TIMESTAMP data type is 32 bit only and therefore cannot support dates past 2038-01-19. Since it cannot support dates in the year 2050, it seems to have set the fields to 0000-00-00.
eduardomozart
trasher
cedric-anne
keguira
Code of Conduct
Is there an existing issue for this?
Version
10.0.7
Bug description
After migrating from GLPI 9.5.2 to GLPI 10.0.7 to a MySQL server without timezone table access, I was able to login the first time but unable to login after
glpi:migration:timestampsmigration.Before migration, the user has the following entry on
glpi_userstable (the password hash was changed to 'glpi' password to avoid data leak):After migration:
After issue the
glpi:migration:timestampscommand:Following the troubleshoots steps available at https://forum.glpi-project.org/viewtopic.php?pid=491839 I was able to identify that the
end_datecolumn value changed from2050-01-01 00:00:00to0000-00-00 00:00:00. After changing the2050-01-01 00:00:00end_date user value toNULLI was able to login as expected.Maybe it's changing the value the
end_datecolumn value of the user to0000-00-00 00:00:00because our host doesn't support MySQL timezones? Most hosting services based on CPanel do not offer access to themysql.time_zone_nametable and GLPI installer allows to continue the GLPI installation/migration just fine. If it's required, this installation check should be changed to enforce it. If it isn't a requirement, maybe there's a bug on TIMEZONE migration or GLPIend_dateverification logic should be changed to handle the0000-00-00 00:00:00value with the same treatment that theNULLvalue has.Relevant log output
sql-errors.log:
Page URL
https://helpdesk.example.com/index.php?noAUTO=1
Steps To reproduce
Your GLPI setup information
Instruções de instalação e configuração
Server
Operating system: Linux scca1.icloudzinc.com 4.18.0-425.3.1.lve.el8.x86_64 #1 SMP Tue Nov 22 22:59:23 EST 2022 x86_64 PHP 7.4.33 litespeed (Core, PDO, PDO_ODBC, Phar, Reflection, SPL, SimpleXML, bcmath, bz2, calendar, ctype, curl, date, dba, dom, enchant, exif, fileinfo, filter, ftp, gd, gettext, gmp, hash, i360, iconv, imap, intl, json, ldap, libxml, litespeed, mbstring, mysqli, mysqlnd, odbc, openssl, pcntl, pcre, pdo_mysql, pdo_pgsql, pdo_sqlite, pgsql, posix, pspell, readline, session, shmop, soap, sockets, sqlite3, standard, sysvmsg, sysvsem, sysvshm, tidy, timezonedb, tokenizer, xml, xmlreader, xmlrpc, xmlwriter, xsl, zip, zlib) Setup: max_execution_time="3000" memory_limit="128M" post_max_size="128M" safe_mode="" session.save_handler="files" upload_max_filesize="128M" Software: LiteSpeed Mozilla/5.0 (Macintosh; Intel Mac OS X 10_15_7) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/113.0.0.0 Safari/537.36 Server Software: MariaDB Server Server Version: 10.3.38-MariaDB-cll-lve Server SQL Mode: NO_ENGINE_SUBSTITUTION Parameters: opoderdasvendasc_glpi@localhost/opoderdasvendasc_glpi Host info: Localhost via UNIX socket PHP version (7.4.33) is supported. Sessions configuration is OK. Allocated memory is sufficient. mysqli extension is installed. Following extensions are installed: dom, fileinfo, json, simplexml. curl extension is installed. gd extension is installed. intl extension is installed. libxml extension is installed. zlib extension is installed. The constant SODIUM_CRYPTO_AEAD_XCHACHA20POLY1305_IETF_NPUBBYTES is present. Database engine version (10.3.38) is supported. No files from previous GLPI version detected. The log file has been created successfully. Write access to /home/opoderdasvendasc/helpdesk/files/_cache has been validated. Write access to /home/opoderdasvendasc/helpdesk/config/ has been validated. Write access to /home/opoderdasvendasc/helpdesk/files/_cron has been validated. Write access to /home/opoderdasvendasc/helpdesk/files has been validated. Write access to /home/opoderdasvendasc/helpdesk/files/_dumps has been validated. Write access to /home/opoderdasvendasc/helpdesk/files/_graphs has been validated. Write access to /home/opoderdasvendasc/helpdesk/files/_lock has been validated. Write access to /home/opoderdasvendasc/helpdesk/files/_pictures has been validated. Write access to /home/opoderdasvendasc/helpdesk/files/_plugins has been validated. Write access to /home/opoderdasvendasc/helpdesk/files/_rss has been validated. Write access to /home/opoderdasvendasc/helpdesk/files/_sessions has been validated. Write access to /home/opoderdasvendasc/helpdesk/files/_tmp has been validated. Write access to /home/opoderdasvendasc/helpdesk/files/_uploads has been validated. PHP 7.4 official support has ended. An upgrade to a more recent PHP version is recommended. 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. PHP directive "session.cookie_secure" should be set to "on" when GLPI can be accessed on HTTPS protocol. PHP directive "session.cookie_httponly" should be set to "on" to prevent client-side script to access cookie values. 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 not present. Following extensions are installed: ctype, iconv, mbstring. Following extensions are not present: sodium. Write access to /home/opoderdasvendasc/helpdesk/glpi/marketplace has been validated. Access to timezone database (mysql) is not allowed.GLPI constants
Libraries
SQL replicas
Notifications
Plugins list
reports Name: Relatórios Version: 1.16.0 State: Enabled Install Method: Manual tasklists Name: Tasks list Version: 2.0.3 State: Enabled Install Method: ManualAnything else?
No response