cedric-anne
commented
2 years ago Problem: neither command works and I must admit that I wondered if I should run the command on my remote sql server or on my VM hosting the GLPI 10 files.
Hi,
You must run these commands on the GLPI host server, from the GLPI root directory, and using the same user as your webserver (do not run them using root user, to prevent rights issues later).
Regards
Code of Conduct
Is there an existing issue for this?
Version
GLPI 10
Bug description
Hello team, Thank you in advance for all you do!
I created a VM to put the beta of GLPI 10 to see what this new version gave. I connected my remote database on which my data of my GLPI 9.4 are currently. When I arrive on the home page I have this message: " 11 columns use the deprecated definition, DATETIME. Launch the command "php bin/console glpi:migration:timestamps" to migrate them. 66 tables use the deprecated charset, utf8mb3. Run the command "php bin/console glpi:migration:utf8mb4" to migrate them."
Problem: neither command works and I must admit that I wondered if I should run the command on my remote sql server or on my VM hosting the GLPI 10 files.
Any idea how to solve these two error messages please?
Thanks again 🙏
Relevant log output
Page URL
myglpiserver/front/central.php
Steps To reproduce
No response
Your GLPI setup information
Informations sur le système, l'installation et la configuration
Server
Operating system: Linux myglpiserver 4.19.0-17-amd64 #1 SMP Debian 4.19.194-3 (2021-07-18) x86_64 PHP 7.4.27 apache2handler (Core, FFI, PDO, Phar, Reflection, SPL, SimpleXML, Zend OPcache, apache2handler, apc, apcu, bz2, calendar, ctype, curl, date, dom, exif, fileinfo, filter, ftp, gd, gettext, hash, iconv, intl, json, libxml, mbstring, mysqli, mysqlnd, openssl, pcre, pdo_mysql, posix, readline, session, shmop, sockets, sodium, standard, sysvmsg, sysvsem, sysvshm, tokenizer, xml, xmlreader, xmlwriter, xsl, zip, zlib) Setup: max_execution_time="30" memory_limit="128M" post_max_size="8M" safe_mode="" session.save_handler="files" upload_max_filesize="2M" Software: Apache/2.4.38 (Debian) (Apache/2.4.38 (Debian) Server at myIPglpiserver Port 80 ) Mozilla/5.0 (Macintosh; Intel Mac OS X 10_15_7) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/96.0.4664.110 Safari/537.36 Server Software: Debian 10 Server Version: 10.3.29-MariaDB-0+deb10u1 Server SQL Mode: STRICT_TRANS_TABLES,ERROR_FOR_DIVISION_BY_ZERO,NO_AUTO_CREATE_USER,NO_ENGINE_SUBSTITUTION Parameters: myglpiuser@myIPsqlserver Host info: myIPsqlserver via TCP/IP PHP version (7.4.27) 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. Database engine version (10.3.29) is supported. 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/config 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 access to files directory is protected exif extension is installed. ldap extension is not present. openssl extension is installed. zip extension is installed. bz2 extension is installed. 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.GLPI constants
Libraries
SQL replicas
Notifications
Plugins list
Anything else?
No response