Hello everyone, unfortunately even though I have installed glpi on ns8 and working, there is still the famous time zone error 
“Access to timezone database (mysql) is not allowed.”)Access to timezone database (mysql) is not allowed.
Now I find myself in difficulty because with ns7 I was able through the syntax of php and console to sector the timezone, with podman I navigate in the dark …
Hello @france i thought that issue has been resolved already, Where do you see this error, and what are you doing that you cant?
Hi @oneitonitram nice to read you again ! I have verified that when you edit something on glpi GUI , the timezone on sql is disabled . As written in precenede to enable it , on a post it was necessary to run php /console … etcc . Time zone not enabled - #2 by france? U=france
In addition, email notifications do not want to work.
Here is the version I have
GLPI 10.0.12 ( => /var/www/html/glpi)
Installation mode: TARBALL
Current language:it_IT
is there an update notification on the software center for the App?
We have an Update of the same, and we are running Glpi 10.0.15 an not 10.0.12
you can force update from the terminal by running
api-cli run update-module --data '{"module_url":"ghcr.io/geniusdynamics/glpi:latest","instances":["glpi1"],"force":true}'
or more specifically
api-cli run update-module --data '{"module_url":"ghcr.io/geniusdynamics/glpi:1.1.2","instances":["glpi1"],"force":true}'
We compiled our own docker image because the available ones would not allow us to achieve our desired goals,
We already have that timeOne command enabled
here: docker-glpi/db_setup.sh at combined · geniusdynamics/docker-glpi (github.com)
How have you configured this. we do not have it automatically configured, and you have to do this from the admin interface of glpi
Hi, I tried as you told me, the update goes but the version is always the same.
GLPI 10.0.12 ( => /var/www/html/glpi)
Installation mode: TARBALL
Current language:it_IT
Also in the summary of the apps I don’t see it, and the strange thing and that I try from here to check an update tells me that there is 10.0.15 … !!!
However, it is strange that by executing your commands the system has updated glpi, at least in an apparent way …
Yes of course but it doesn’t work.
Here is the system info
<details><summary>Informazioni sul sistema, l'installazione e la configurazione</summary><pre>GLPI 10.0.12 ( => /var/www/html/glpi)
Installation mode: TARBALL
Current language:it_IT
</pre></details><details><summary>Server</summary><pre>
Operating system: Linux glpi 5.14.0-427.16.1.el9_4.x86_64 #1 SMP PREEMPT_DYNAMIC Wed May 8 17:48:14 UTC 2024 x86_64
PHP 8.2.18 apache2handler (Core, FFI, PDO, Phar, Reflection, SPL, SimpleXML, Zend OPcache, apache2handler, bz2, calendar, ctype,
curl, date, dom, exif, fileinfo, filter, ftp, gd, gettext, hash, iconv, igbinary, imap, intl, json, ldap, libxml, mbstring,
mysqli, mysqlnd, openssl, pcre, pdo_mysql, posix, random, readline, redis, session, shmop, sockets, sodium, standard, sysvmsg,
sysvsem, sysvshm, tokenizer, xml, xmlreader, xmlrpc, 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.59 (Debian) (Apache/2.4.59 (Debian) Server at inquad.duckdns.org Port 80
)
Mozilla/5.0 (Macintosh; Intel Mac OS X 10_15_7) AppleWebKit/605.1.15 (KHTML, like Gecko) Version/17.5 Safari/605.1.15
Server Software: mariadb.org binary distribution
Server Version: 10.11.5-MariaDB-1:10.11.5+maria~ubu2204
Server SQL Mode: STRICT_TRANS_TABLES,ERROR_FOR_DIVISION_BY_ZERO,NO_AUTO_CREATE_USER,NO_ENGINE_SUBSTITUTION
Parameters: glpi@127.0.0.1:3306/glpi
Host info: 127.0.0.1 via TCP/IP
PHP version (8.2.18) 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.5) is supported.
No files from previous GLPI version detected.
The log file has been created successfully.
Write access to /var/www/html/glpi/files/_cache has been validated.
Write access to /var/www/html/glpi/files/_cron has been validated.
Write access to /var/www/html/glpi/files has been validated.
Write access to /var/www/html/glpi/files/_dumps has been validated.
Write access to /var/www/html/glpi/files/_graphs has been validated.
Write access to /var/www/html/glpi/files/_lock has been validated.
Write access to /var/www/html/glpi/files/_pictures has been validated.
Write access to /var/www/html/glpi/files/_plugins has been validated.
Write access to /var/www/html/glpi/files/_rss has been validated.
Write access to /var/www/html/glpi/files/_sessions has been validated.
Write access to /var/www/html/glpi/files/_tmp has been validated.
Write access to /var/www/html/glpi/files/_uploads has been validated.
Web server root directory configuration seems safe.
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 /var/www/html/glpi/marketplace has been validated.
Access to timezone database (mysql) is not allowed.
</pre></details><details><summary>GLPI constants</summary><pre>
GLPI_ROOT: "/var/www/html/glpi"
GLPI_CONFIG_DIR: "/var/www/html/glpi/config"
GLPI_VAR_DIR: "/var/www/html/glpi/files"
GLPI_MARKETPLACE_DIR: "/var/www/html/glpi/marketplace"
GLPI_USE_CSRF_CHECK: "1"
GLPI_CSRF_EXPIRES: "7200"
GLPI_CSRF_MAX_TOKENS: "100"
GLPI_USE_IDOR_CHECK: "1"
GLPI_IDOR_EXPIRES: "7200"
GLPI_ALLOW_IFRAME_IN_RICH_TEXT: false
GLPI_SERVERSIDE_URL_ALLOWLIST: ["/^(https?|feed):\\/\\/[^@:]+(\\/.*)?$/"]
GLPI_TELEMETRY_URI: "https://telemetry.glpi-project.org"
GLPI_INSTALL_MODE: "TARBALL"
GLPI_NETWORK_MAIL: "glpi@teclib.com"
GLPI_NETWORK_SERVICES: "https://services.glpi-network.com"
GLPI_MARKETPLACE_ALLOW_OVERRIDE: true
GLPI_MARKETPLACE_MANUAL_DOWNLOADS: true
GLPI_USER_AGENT_EXTRA_COMMENTS: ""
GLPI_DISABLE_ONLY_FULL_GROUP_BY_SQL_MODE: "1"
GLPI_AJAX_DASHBOARD: "1"
GLPI_CALDAV_IMPORT_STATE: 0
GLPI_DEMO_MODE: "0"
GLPI_CENTRAL_WARNINGS: "1"
GLPI_TEXT_MAXSIZE: "4000"
GLPI_DOC_DIR: "/var/www/html/glpi/files"
GLPI_CACHE_DIR: "/var/www/html/glpi/files/_cache"
GLPI_CRON_DIR: "/var/www/html/glpi/files/_cron"
GLPI_DUMP_DIR: "/var/www/html/glpi/files/_dumps"
GLPI_GRAPH_DIR: "/var/www/html/glpi/files/_graphs"
GLPI_LOCAL_I18N_DIR: "/var/www/html/glpi/files/_locales"
GLPI_LOCK_DIR: "/var/www/html/glpi/files/_lock"
GLPI_LOG_DIR: "/var/www/html/glpi/files/_log"
GLPI_PICTURE_DIR: "/var/www/html/glpi/files/_pictures"
GLPI_PLUGIN_DOC_DIR: "/var/www/html/glpi/files/_plugins"
GLPI_RSS_DIR: "/var/www/html/glpi/files/_rss"
GLPI_SESSION_DIR: "/var/www/html/glpi/files/_sessions"
GLPI_TMP_DIR: "/var/www/html/glpi/files/_tmp"
GLPI_UPLOAD_DIR: "/var/www/html/glpi/files/_uploads"
GLPI_INVENTORY_DIR: "/var/www/html/glpi/files/_inventories"
GLPI_NETWORK_REGISTRATION_API_URL: "https://services.glpi-network.com/api/registration/"
GLPI_MARKETPLACE_PLUGINS_API_URI: "https://services.glpi-network.com/api/marketplace/"
GLPI_I18N_DIR: "/var/www/html/glpi/locales"
GLPI_VERSION: "10.0.12"
GLPI_SCHEMA_VERSION: "10.0.12@b902ef5f5da967c1a9d0826ee8a7dce07d57cf3d"
GLPI_MARKETPLACE_PRERELEASES: false
GLPI_MIN_PHP: "7.4.0"
GLPI_MAX_PHP: "8.4.0"
GLPI_YEAR: "2024"
</pre></details><details><summary>Libraries</summary><pre>
htmlawed/htmlawed version 1.2.14 in (/var/www/html/glpi/vendor/htmlawed/htmlawed)
phpmailer/phpmailer version 6.8.0 in (/var/www/html/glpi/vendor/phpmailer/phpmailer/src)
simplepie/simplepie version 1.5.8 in (/var/www/html/glpi/vendor/simplepie/simplepie/library)
tecnickcom/tcpdf version 6.4.4 in (/var/www/html/glpi/marketplace/pdf/vendor/tecnickcom/tcpdf)
michelf/php-markdown in (/var/www/html/glpi/vendor/michelf/php-markdown/Michelf)
true/punycode in (/var/www/html/glpi/vendor/true/punycode/src)
iamcal/lib_autolink in (/var/www/html/glpi/vendor/iamcal/lib_autolink)
sabre/dav in (/var/www/html/glpi/vendor/sabre/dav/lib/DAV)
sabre/http in (/var/www/html/glpi/vendor/sabre/http/lib)
sabre/uri in (/var/www/html/glpi/vendor/sabre/uri/lib)
sabre/vobject in (/var/www/html/glpi/vendor/sabre/vobject/lib)
laminas/laminas-i18n in (/var/www/html/glpi/vendor/laminas/laminas-i18n/src)
laminas/laminas-servicemanager in (/var/www/html/glpi/vendor/laminas/laminas-servicemanager/src)
monolog/monolog in (/var/www/html/glpi/vendor/monolog/monolog/src/Monolog)
sebastian/diff in (/var/www/html/glpi/vendor/sebastian/diff/src)
donatj/phpuseragentparser in (/var/www/html/glpi/vendor/donatj/phpuseragentparser/src/UserAgent)
elvanto/litemoji in (/var/www/html/glpi/vendor/elvanto/litemoji/src)
symfony/console in (/var/www/html/glpi/vendor/symfony/console)
scssphp/scssphp in (/var/www/html/glpi/vendor/scssphp/scssphp/src)
laminas/laminas-mail in (/var/www/html/glpi/vendor/laminas/laminas-mail/src/Protocol)
laminas/laminas-mime in (/var/www/html/glpi/vendor/laminas/laminas-mime/src)
rlanvin/php-rrule in (/var/www/html/glpi/vendor/rlanvin/php-rrule/src)
ramsey/uuid in (/var/www/html/glpi/vendor/ramsey/uuid/src)
psr/log in (/var/www/html/glpi/vendor/psr/log/Psr/Log)
psr/simple-cache in (/var/www/html/glpi/vendor/psr/simple-cache/src)
psr/cache in (/var/www/html/glpi/vendor/psr/cache/src)
league/csv in (/var/www/html/glpi/vendor/league/csv/src)
mexitek/phpcolors in (/var/www/html/glpi/vendor/mexitek/phpcolors/src/Mexitek/PHPColors)
guzzlehttp/guzzle in (/var/www/html/glpi/vendor/guzzlehttp/guzzle/src)
guzzlehttp/psr7 in (/var/www/html/glpi/vendor/guzzlehttp/psr7/src)
glpi-project/inventory_format in (/var/www/html/glpi/vendor/glpi-project/inventory_format/lib/php)
wapmorgan/unified-archive in (/var/www/html/glpi/vendor/wapmorgan/unified-archive/src)
paragonie/sodium_compat in (/var/www/html/glpi/vendor/paragonie/sodium_compat/src)
symfony/cache in (/var/www/html/glpi/vendor/symfony/cache)
html2text/html2text in (/var/www/html/glpi/vendor/html2text/html2text/src)
symfony/css-selector in (/var/www/html/glpi/vendor/symfony/css-selector)
symfony/dom-crawler in (/var/www/html/glpi/vendor/symfony/dom-crawler)
twig/twig in (/var/www/html/glpi/vendor/twig/twig/src)
twig/string-extra in (/var/www/html/glpi/vendor/twig/string-extra)
symfony/polyfill-ctype not found
symfony/polyfill-iconv not found
symfony/polyfill-mbstring not found
symfony/polyfill-php80 not found
symfony/polyfill-php81 not found
symfony/polyfill-php82 in (/var/www/html/glpi/vendor/symfony/polyfill-php82)
league/oauth2-client in (/var/www/html/glpi/vendor/league/oauth2-client/src/Provider)
league/oauth2-google in (/var/www/html/glpi/vendor/league/oauth2-google/src/Provider)
thenetworg/oauth2-azure in (/var/www/html/glpi/vendor/thenetworg/oauth2-azure/src/Provider)
</pre></details><details><summary>SQL replicas</summary><pre>
Not active
</pre></details><details><summary>Notifications</summary><pre>
Way of sending emails: PHP
</pre></details><details><summary>Plugins list</summary><pre>
barcode Name: Barcode Version: 2.7.1 State: Enabled
Install Method: Marketplace
camerainput Name: Camera Input Version: 2.1.0 State: Enabled
Install Method: Marketplace
pdf Name: Stampa in PDF Version: 3.0.0 State: Enabled
Install Method: Marketplace
</pre></details>```allow us to investigate further
Of course, thank you. I can take any test you want to ask me.
In addition to what was reported, I also wanted to add that the registration key despite being valid and accepted by the glpi system, is lost, perhaps when the ns8 server is restarted.
I wanted to confirm that when the cluster is restarted, glpi does not store the registration key.
HEllo @france we have a new Dev release available for testing.
Release 2.0.0-dev.1 · geniusdynamics/ns8-glpi (github.com)
You could Manually Update to this version for testing, from current release via
api-cli run update-module --data '{"module_url":"ghcr.io/geniusdynamics/glpi:2.0.0-dev.1","instances":["glpi1"],"force":true}'
it should sort most of the previous issues you mentioned.
We are unabe to identify why the Registration key is not persisitent on subsequent restarts
Ok, I’ll try to update manually as soon as possible. I will let you know . Thank you .
Hi, I just installed and verified glpi. Unfortunately nothing has changed. From node it tells me that I have the dev version, but from glpi it always tells me 10 (see attachments). The license disappears and SMTP doesn’t work. It seems that any updates or changes are not being pushed into production. Furthermore, if I check gllpi to see if there is an updated version it tells me yes! My skills stop here, too bad that glpi on ns8 is not working like on ns7. I attach the images to you.
Hello @france if you look closely the version indicated is 10.0.16.
In relation to license not being saved. This is not even after update, Everytime you restart the services, by saving configuration on ns8 setting page, it’s erased. I am not sure why. Maybe @stephdl could help on this.
I’ll try to figure out the possibility of implementing smarthost for emails on glpi and revert, hopefully it solves the smtp not working issue.
How do you explain that any glpi installation, from the node ns8 gives me the correct version but from glpi always the 10.0.2!
Hello after investigations, i have identified where the problem lies.
The actual version you are running is version 10.0.16, However, We have an Environment variable that TElls Glpi what version is running, and that has been defined as 10.0.12 on the database.
So while the version running on the server is 10.0.12, the Glpi database thinks its running Glpi VErsion 10.0.12.
I am pushing an update to update this.
Should be available on Release 2.0.0-dev.2 · geniusdynamics/ns8-glpi (github.com)
Update your version by
api-cli run update-module --data '{"module_url":"ghcr.io/geniusdynamics/glpi:2.0.0-dev.2","instances":["glpi1"],"force":true}'
After testing the update, the value in the database seems to persist. Allow us to investigate the best way to modify this.
Hi, I tried but nothing changes. On glpi it always remains 10.0.2.
Should say (typo) 2.0.0-dev.2 I guess.
So actually it the docker image that we are using is actually outdated so please give me sometime to update the docker image test and release it
fixed, thanx
I doubt this to be the case.
