You are not logged in.
Hi,
After upgrading to v10 I am getting these two errors when I login to GLPI.
390 tables are using the deprecated utf8mb3 storage charset. Run the "php bin/console glpi:migration:utf8mb4" command to migrate them.
1302 primary or foreign keys columns are using signed integers. Run the "php bin/console glpi:migration:unsigned_keys" command to migrate them.
I have tried running the command, however I am getting the following error.
$ php bin/console glpi:migration:utf8mb4
Could not open input file: bin/console
Can someone kindly advise? Thank you!
Offline
cd /var/www/html/glpi
and then:
sudo php bin/console...
Last edited by WebGreg (2022-05-04 08:25:17)
--
GLPI 10.0.17
GLPI-Inventory 1.4.0
Ubuntu Server 20.04 LTS
Offline
WebGreg,
Worked like a charm! Thank you, you rock!
[glpi]# php bin/console glpi:migration:utf8mb4
Found 394 table(s) requiring migration to "utf8mb4".
Do you want to continue? [Yes/no]yes
394/394 [============================] 100%
Migration done.
[glpi]# php bin/console glpi:migration:unsigned_keys
Found 1311 primary/foreign key columns(s) using signed integers.
Do you want to continue? [Yes/no]yes
1311/1311 [============================] 100%
Migration done.
Offline
Hi
I have the same problem. But wenn I try cd /var/www/html/glpi in Putty, the "www" folder could not be found. And by using ls in the var folder there does no "www" subfolder appear. What am I doing wrong?
Thanks
Offline
Maybe a different system?
Or probably You have the GLPI directory in a different location.
--
GLPI 10.0.17
GLPI-Inventory 1.4.0
Ubuntu Server 20.04 LTS
Offline
Yes, it runs on a Synology NAS and I could not find the GLPI directory yet by using cd an ls. As I am not very firm to Linux, I have no idea how to search the directory. Any hints?
Offline
You have to find the right directory.
Try with
locate glpi
or with find
find / -iname glpi
then cd to the right folder
Offline
Maybe \\server\web\glpi ?
Edit: https://forum.glpi-project.org/viewtopic.php?id=204173
Last edited by WebGreg (2022-08-03 20:58:39)
--
GLPI 10.0.17
GLPI-Inventory 1.4.0
Ubuntu Server 20.04 LTS
Offline
Yeah, I found it. Thanks!
But after typing
sudo php bin/console glpi:migration:timestamps
I received:
PHP Parse error: syntax error, unexpected '?' in /volume1/web/glpi/bin/console on line 75
And I habe no Idea, what that means.
Offline
If you are seeing that error, it is likely that the PHP version running from the command line is older than what is supported by GLPI (7.4 minimum).
Since you can have different versions of PHP running through Apache and the CLI, it is possible the CLI uses an older version.
GLPI Collaborator and Plugin Developer.
My non-English comments are automated translations. Sorry for any confusion that causes.
Mes commentaires non anglais sont des traductions automatiques. Désolé pour toute confusion qui cause.
Mis comentarios que no están en inglés son traducciones automáticas. Perdón por cualquier confusión que cause.
Offline
As written above, try finding php executables and check the versione
Offline
Long time ago, but thank you cconard90 + Kaya84
I found out, that my PHP version ist 7.4, but in spite of that the parse error still exists.
Anyway, I heard, GLPI is not runing on DSM 7. And as I will have to migrate to the new version bevor June 23 (eol 6.x), I'm asking myself wether it is worth to go on with this.
Does anyone know, wether GLPI wil run on DSM 7 some day?
Offline
I don't know who manages the Synology app for GLPI but I don't think it is maintained by the GLPI developers or Teclib.
GLPI Collaborator and Plugin Developer.
My non-English comments are automated translations. Sorry for any confusion that causes.
Mes commentaires non anglais sont des traductions automatiques. Désolé pour toute confusion qui cause.
Mis comentarios que no están en inglés son traducciones automáticas. Perdón por cualquier confusión que cause.
Offline
@ReneM You can change the php version of your CLI on Synology with the following commands:
cd /bin
sudo rm php
sudo cp /volume1/@appstore/PHP7.4/usr/local/bin/php74 /bin/php
php -v
Last edited by davida (2022-09-03 12:38:29)
Offline
Regarding DSM 7 and GLPI
Yes it’s possible, there is no standard installation package from Synology for DSM 7, but you can install GLPI manually on DSM 7.
There is a step by step guide. Unfortunately I cannot post a link here.
Offline
Hello. I am moving from a DS1512+ to a DS1821+. I suspect the DS1821+ will come with some form of DSM7.x I really need my GLPI on the new system. How can I find these instructions you mention for installing GLPI on DSM 7.x please?
Carl
Offline
You can find the instruction on this site:
davidanders.de + "/how-to-install-glpi-10-on-synology-dsm-7"
Offline
Thank you very much for the info.
I have another question. Since it looks like all the parameters seem pretty similar to my current installation on my DS1512+. If I perform a Hyper backup of the package, Websites, SQL settings / database and then restore those to my new DS1821+ should that not restore my database etc?
Offline
If you want to migrate the GLPI installation from one Synology to another I don't recommend to use Hyperbackup (as it's a backup of the GLPI Synology package, which does not exist on the new Synology (DSM 7)
I would do the following:
1. Install the same version of GLPI on the new / target Synology as on the old one.
2. Migrate GLPI by copying the database and all files in the glpi web directory.
2.1 To copy the database you can use phpMyAdmin to download a full copy of the db and upload the file to the new Synology.
2.2 Just copy all files in glpi folder of your web directory to the new Synology (maybe zip them for transfer)
3. Upgrade / Update the GLPI on the target Synology according to the GLPI docs
Offline