New GLPI 10 version? (RELEASED AS nethserver-glpi-10-latest)

worth to write a note into the wiki and/or the howto?

1 Like

https://wiki.nethserver.org/doku.php?id=glpi-latest#installation

I did one, maybe too short

1 Like

For what it’s worth, seem understandable and simple enough to me.

1 Like

How can i run this command, every variation i try fails with error No such file or directory

php bin/console glpi:migration:timestamps

I’m guessing it would be the same as the nextcloud console (I think it’s occ) but the principal would be to eitther issue the command from within the folder in glpi that has the comand (bash script etc) or to specify the php version installed on nethserver (ie version 7.3 or 7.4 or 8 not the defaut version 5)

for the latter lets say hypotheticaly the console script is located at /usr/share/glpi/console and the php version was version 7.3 then the comand would look something like this

sudo -u apache scl enable rh-php73 -- php -d memory_limit=1500M -d apc.enable_cli=1 /usr/share/glpi/console glpi:migration:timestamps

oh php81 worked, thanks

1 Like

Btw, for those who are getting crazy with GLPI-Agent in windows clients, you should install and then go to CMD (As admin) and run glpi-agent.bat and glpi-inventory.bat manually, and it takes a really long time to show up in Dashboard… lol, windows is slow, linux is instant inventory.

1 Like

Any easy way to use nethserver-glpi-10-latest where i have installed nethserver-glpi-latest-1.0.8-1.ns7.sdl.noarch.rpm ?! :stuck_out_tongue:

just remove and install again? Lol, i have already 20 computers in inventory! :frowning:

you use the same /var/lib/glpi en the same mysql database, it should be a drop in solution but take a snapshot of the VM is possible before

1 Like

Lol, its never easy, when “updating”

Restricted area.
Only local access allowed.
Check your configuration or contact your administrator.

:confused:

could u explain more ?

1 Like

/var/log/messages error ?

1 Like


Only this “suggested” info… wont change it to enforcing, as i read it looks a bad idea.

then it says:

The database version does not match the version of installed files. An update is needed.

Once i click in “update”

Restricted area.
Only local access allowed.
Check your configuration or contact your administrator.

from log/messages
Sep 6 11:09:08 srv1 journal: Suppressed 1390 messages from /user.slice/user-1319601129.slice
Sep 6 11:10:01 srv1 systemd: Created slice User Slice of apache.
Sep 6 11:10:01 srv1 systemd: Started Session 64666 of user apache.
Sep 6 11:10:01 srv1 systemd: Removed slice User Slice of apache.

check during the install, we need more log

To upgrade, try signal-event nethserver-glpi-10-latest-update

1 Like
Sep  6 14:31:44 srv1 smbd_audit: [2022/09/06 14:31:44.276931,  0] ../../source3/smbd/uid.c:448(change_to_user_internal)
Sep  6 14:31:44 srv1 smbd_audit:  change_to_user_internal: chdir_current_service() failed!
Sep  6 14:31:49 srv1 esmith::event[5700]: Event: nethserver-glpi-10-latest-update
Sep  6 14:31:49 srv1 esmith::event[5700]: Migrating existing database fwrules
Sep  6 14:31:49 srv1 esmith::event[5700]: Migrating existing database accounts
Sep  6 14:31:49 srv1 esmith::event[5700]: Migrating existing database backups
Sep  6 14:31:49 srv1 esmith::event[5700]: Migrating existing database hosts
Sep  6 14:31:49 srv1 esmith::event[5700]: Migrating existing database portforward
Sep  6 14:31:49 srv1 esmith::event[5700]: Migrating existing database networks
Sep  6 14:31:49 srv1 esmith::event[5700]: Migrating existing database squid
Sep  6 14:31:49 srv1 esmith::event[5700]: Migrating existing database separators
Sep  6 14:31:49 srv1 esmith::event[5700]: Migrating existing database fwtimes
Sep  6 14:31:49 srv1 esmith::event[5700]: Migrating existing database tc
Sep  6 14:31:49 srv1 esmith::event[5700]: Migrating existing database contentfilter
Sep  6 14:31:49 srv1 esmith::event[5700]: Migrating existing database vhosts
Sep  6 14:31:49 srv1 esmith::event[5700]: Migrating existing database dhcp
Sep  6 14:31:49 srv1 esmith::event[5700]: Migrating existing database smarthosts
Sep  6 14:31:49 srv1 esmith::event[5700]: Migrating existing database vpn
Sep  6 14:31:49 srv1 esmith::event[5700]: Migrating existing database macs
Sep  6 14:31:49 srv1 esmith::event[5700]: Migrating existing database routes
Sep  6 14:31:49 srv1 esmith::event[5700]: Migrating existing database crontab
Sep  6 14:31:49 srv1 esmith::event[5700]: Migrating existing database dyndns
Sep  6 14:31:49 srv1 esmith::event[5700]: Migrating existing database configuration
Sep  6 14:31:49 srv1 /etc/e-smith/events/nethserver-glpi-10-latest-update/S00initialize-default-databases[5701]: /var/lib/nethserver/db/configuration: OLD squid=service|BlueMode|transparen$
Sep  6 14:31:49 srv1 /etc/e-smith/events/nethserver-glpi-10-latest-update/S00initialize-default-databases[5701]: /var/lib/nethserver/db/configuration: NEW squid=service|BlueMode|transparen$
Sep  6 14:31:49 srv1 /etc/e-smith/events/nethserver-glpi-10-latest-update/S00initialize-default-databases[5701]: /var/lib/nethserver/db/configuration: OLD squid=service|BlueMode|transparen$
Sep  6 14:31:49 srv1 /etc/e-smith/events/nethserver-glpi-10-latest-update/S00initialize-default-databases[5701]: /var/lib/nethserver/db/configuration: NEW squid=service|BlueMode|transparen$
Sep  6 14:31:49 srv1 esmith::event[5700]: Migrating existing database certificates
Sep  6 14:31:49 srv1 esmith::event[5700]: Migrating existing database fwservices
Sep  6 14:31:49 srv1 esmith::event[5700]: Migrating existing database proxypass
Sep  6 14:31:49 srv1 esmith::event[5700]: Action: /etc/e-smith/events/nethserver-glpi-10-latest-update/S00initialize-default-databases SUCCESS [0.208416]
Sep  6 14:31:49 srv1 esmith::event[5700]: expanding /etc/httpd/conf.d/zzz_glpi.conf
Sep  6 14:31:49 srv1 esmith::event[5700]: expanding /etc/httpd/conf.d/glpi.conf
Sep  6 14:31:49 srv1 esmith::event[5700]: expanding /etc/httpd/conf.d/default-virtualhost.inc
Sep  6 14:31:49 srv1 esmith::event[5700]: expanding /etc/opt/rh/rh-mariadb105/my.cnf.d/mariadb-glpi-server.cnf
Sep  6 14:31:49 srv1 esmith::event[5700]: expanding /etc/cron.d/glpi
Sep  6 14:31:49 srv1 esmith::event[5700]: expanding /etc/glpi/config_db.php
Sep  6 14:31:49 srv1 esmith::event[5700]: Event: nethserver-glpi-10-latest-update
Sep  6 14:31:49 srv1 esmith::event[5700]: Migrating existing database fwrules
Sep  6 14:31:49 srv1 esmith::event[5700]: Migrating existing database accounts
Sep  6 14:31:49 srv1 esmith::event[5700]: Migrating existing database backups
Sep  6 14:31:49 srv1 esmith::event[5700]: Migrating existing database hosts
Sep  6 14:31:49 srv1 esmith::event[5700]: Migrating existing database portforward
Sep  6 14:31:49 srv1 esmith::event[5700]: Migrating existing database networks
Sep  6 14:31:49 srv1 esmith::event[5700]: Migrating existing database squid
Sep  6 14:31:49 srv1 esmith::event[5700]: Migrating existing database separators
Sep  6 14:31:49 srv1 esmith::event[5700]: Migrating existing database fwtimes
Sep  6 14:31:49 srv1 esmith::event[5700]: Migrating existing database tc
Sep  6 14:31:49 srv1 esmith::event[5700]: Migrating existing database contentfilter
Sep  6 14:31:49 srv1 esmith::event[5700]: Migrating existing database vhosts
Sep  6 14:31:49 srv1 esmith::event[5700]: Migrating existing database dhcp
Sep  6 14:31:49 srv1 esmith::event[5700]: Migrating existing database smarthosts
Sep  6 14:31:49 srv1 esmith::event[5700]: Migrating existing database vpn
Sep  6 14:31:49 srv1 esmith::event[5700]: Migrating existing database macs
Sep  6 14:31:49 srv1 esmith::event[5700]: Migrating existing database routes
Sep  6 14:31:49 srv1 esmith::event[5700]: Migrating existing database crontab
Sep  6 14:31:49 srv1 esmith::event[5700]: Migrating existing database dyndns
Sep  6 14:31:49 srv1 esmith::event[5700]: Migrating existing database configuration
Sep  6 14:31:49 srv1 /etc/e-smith/events/nethserver-glpi-10-latest-update/S00initialize-default-databases[5701]: /var/lib/nethserver/db/configuration: OLD squid=service|BlueMode|transparen$
Sep  6 14:31:49 srv1 /etc/e-smith/events/nethserver-glpi-10-latest-update/S00initialize-default-databases[5701]: /var/lib/nethserver/db/configuration: NEW squid=service|BlueMode|transparen$
Sep  6 14:31:49 srv1 /etc/e-smith/events/nethserver-glpi-10-latest-update/S00initialize-default-databases[5701]: /var/lib/nethserver/db/configuration: OLD squid=service|BlueMode|transparen$
Sep  6 14:31:49 srv1 /etc/e-smith/events/nethserver-glpi-10-latest-update/S00initialize-default-databases[5701]: /var/lib/nethserver/db/configuration: NEW squid=service|BlueMode|transparen$
Sep  6 14:31:49 srv1 esmith::event[5700]: Migrating existing database certificates
Sep  6 14:31:49 srv1 esmith::event[5700]: Migrating existing database fwservices
Sep  6 14:31:49 srv1 esmith::event[5700]: Migrating existing database proxypass
Sep  6 14:31:49 srv1 esmith::event[5700]: Action: /etc/e-smith/events/nethserver-glpi-10-latest-update/S00initialize-default-databases SUCCESS [0.208416]
Sep  6 14:31:49 srv1 esmith::event[5700]: expanding /etc/httpd/conf.d/zzz_glpi.conf
Sep  6 14:31:49 srv1 esmith::event[5700]: expanding /etc/httpd/conf.d/glpi.conf
Sep  6 14:31:49 srv1 esmith::event[5700]: expanding /etc/httpd/conf.d/default-virtualhost.inc
Sep  6 14:31:49 srv1 esmith::event[5700]: expanding /etc/opt/rh/rh-mariadb105/my.cnf.d/mariadb-glpi-server.cnf
Sep  6 14:31:49 srv1 esmith::event[5700]: expanding /etc/cron.d/glpi
Sep  6 14:31:49 srv1 esmith::event[5700]: expanding /etc/glpi/config_db.php
Sep  6 14:31:49 srv1 esmith::event[5700]: Action: /etc/e-smith/events/actions/generic_template_expand SUCCESS [0.070458]
Sep  6 14:31:49 srv1 esmith::event[5700]: Action: /etc/e-smith/events/nethserver-glpi-10-latest-update/S10nethserver-glpi-10-latest-migrate-files-folder SUCCESS [0.001262]
Sep  6 14:31:49 srv1 su: (to apache) root on none
Sep  6 14:31:50 srv1 esmith::event[5700]: Modo de manutenção ativado. Backdoor usando: http://localhost/glpi//index.php?skipMaintenance=1
Sep  6 14:31:50 srv1 su: (to apache) root on none
Sep  6 14:31:50 srv1 esmith::event[5700]: Alguns dos requisitos de sistemas opcionais estão faltando. Execute "php bin/console glpi:system:check_requirements" para mais detalhes.
Sep  6 14:31:50 srv1 esmith::event[5700]: +----------------------------------+-------------------------------------------------+-------------------------------------------------+
Sep  6 14:31:50 srv1 esmith::event[5700]: |                                  | Atual                                           | Alvo                                            |
Sep  6 14:31:50 srv1 esmith::event[5700]: +----------------------------------+-------------------------------------------------+-------------------------------------------------+
Sep  6 14:31:50 srv1 esmith::event[5700]: | Host do banco de dados           | 127.0.0.1:8105                                  |                                                 |
Sep  6 14:31:50 srv1 esmith::event[5700]: | Nome do banco de dados           | glpi                                            |                                                 |
Sep  6 14:31:50 srv1 esmith::event[5700]: | Usuário do banco de dados        | glpi                                            |                                                 |
Sep  6 14:31:50 srv1 esmith::event[5700]: | Versão do GLPI                   | 10.0.0                                          | 10.0.2                                          |
Sep  6 14:31:50 srv1 esmith::event[5700]: | Versão do banco de dados do GLPI | 10.0.0@9eb698d8fd49f9256d7bd63a6d747587e0effaff | 10.0.2@a130db99c7d9b131c2e2ea59fe0d6260fe93d831 |
Sep  6 14:31:50 srv1 esmith::event[5700]: +----------------------------------+-------------------------------------------------+-------------------------------------------------+
Sep  6 14:31:50 srv1 esmith::event[5700]: Checking database schema integrity...
Sep  6 14:31:51 srv1 esmith::event[5700]: The database schema is not consistent with the installed GLPI version (10.0.0). Run the "php bin/console glpi:database:check_schema_integrity" com$
Sep  6 14:31:51 srv1 su: (to apache) root on none
Sep  6 14:31:51 srv1 esmith::event[5700]: A versão do banco de dados não é compatível com a versão dos arquivos instalados. Uma atualização se faz necessária.
Sep  6 14:31:51 srv1 su: (to apache) root on none
Sep  6 14:31:51 srv1 esmith::event[5700]: A versão do banco de dados não é compatível com a versão dos arquivos instalados. Uma atualização se faz necessária.
Sep  6 14:31:51 srv1 su: (to apache) root on none
Sep  6 14:31:51 srv1 esmith::event[5700]: A versão do banco de dados não é compatível com a versão dos arquivos instalados. Uma atualização se faz necessária.
Sep  6 14:31:51 srv1 su: (to apache) root on none
Sep  6 14:31:52 srv1 esmith::event[5700]: Modo de manutenção desativado.
Sep  6 14:31:52 srv1 esmith::event[5700]: Action: /etc/e-smith/events/nethserver-glpi-10-latest-update/S40nethserver-glpi-10-latest-conf SUCCESS [2.317885]
Sep  6 14:31:52 srv1 systemd: Reloading.
Sep  6 14:31:52 srv1 systemd: [/usr/lib/systemd/system/netdata.service:50] Failed to parse capability in bounding/ambient set, ignoring: CAP_PERFMON
Sep  6 14:31:52 srv1 systemd: [/usr/lib/systemd/system/netdata.service:69] Unknown lvalue 'ProtectControlGroups' in section 'Service'
Sep  6 14:31:52 srv1 esmith::event[5700]: [INFO] service httpd reload
Sep  6 14:31:52 srv1 systemd: Reloading The Apache HTTP Server.
Sep  6 14:31:52 srv1 systemd: Reloaded The Apache HTTP Server.
Sep  6 14:31:52 srv1 systemd: Reloading.
Sep  6 14:31:52 srv1 systemd: [/usr/lib/systemd/system/netdata.service:50] Failed to parse capability in bounding/ambient set, ignoring: CAP_PERFMON
Sep  6 14:31:52 srv1 systemd: [/usr/lib/systemd/system/netdata.service:69] Unknown lvalue 'ProtectControlGroups' in section 'Service'
Sep  6 14:31:52 srv1 esmith::event[5700]: [INFO] service httpd reload
Sep  6 14:31:52 srv1 systemd: Reloading The Apache HTTP Server.
Sep  6 14:31:52 srv1 systemd: Reloaded The Apache HTTP Server.
Sep  6 14:31:52 srv1 systemd: Reloading.
Sep  6 14:31:52 srv1 systemd: [/usr/lib/systemd/system/netdata.service:50] Failed to parse capability in bounding/ambient set, ignoring: CAP_PERFMON
Sep  6 14:31:52 srv1 systemd: [/usr/lib/systemd/system/netdata.service:69] Unknown lvalue 'ProtectControlGroups' in section 'Service'
Sep  6 14:31:52 srv1 esmith::event[5700]: [INFO] service php81-php-fpm restart
Sep  6 14:31:52 srv1 systemd: Stopping The PHP FastCGI Process Manager...
Sep  6 14:31:52 srv1 systemd: Stopped The PHP FastCGI Process Manager.
Sep  6 14:31:52 srv1 systemd: Starting The PHP FastCGI Process Manager...
Sep  6 14:31:52 srv1 systemd: Started The PHP FastCGI Process Manager.
Sep  6 14:31:52 srv1 systemd: Reloading.
Sep  6 14:31:52 srv1 systemd: [/usr/lib/systemd/system/netdata.service:50] Failed to parse capability in bounding/ambient set, ignoring: CAP_PERFMON
Sep  6 14:31:52 srv1 systemd: [/usr/lib/systemd/system/netdata.service:69] Unknown lvalue 'ProtectControlGroups' in section 'Service'
Sep  6 14:31:52 srv1 esmith::event[5700]: [INFO] service rh-mariadb105-mariadb@glpi restart
Sep  6 14:31:52 srv1 systemd: Stopping MariaDB 10.5 database server...
Sep  6 14:31:52 srv1 systemd: Stopped MariaDB 10.5 database server.
Sep  6 14:31:52 srv1 systemd: Starting MariaDB 10.5 database server...
Sep  6 14:31:52 srv1 scl: Database MariaDB is probably initialized in /var/opt/rh/rh-mariadb105/lib/mysql-glpi already, nothing is done.
Sep  6 14:31:52 srv1 scl: If this is not the case, make sure the /var/opt/rh/rh-mariadb105/lib/mysql-glpi is empty before running mysql-prepare-db-dir.
Sep  6 14:31:52 srv1 mysqld-scl-helper: 2022-09-06 14:31:52 0 [Note] /opt/rh/rh-mariadb105/root/usr/libexec/mysqld (mysqld 10.5.16-MariaDB) starting as process 6140 ...
Sep  6 14:31:53 srv1 systemd: Started MariaDB 10.5 database server.
Sep  6 14:31:52 srv1 scl: Database MariaDB is probably initialized in /var/opt/rh/rh-mariadb105/lib/mysql-glpi already, nothing is done.
Sep  6 14:31:52 srv1 scl: If this is not the case, make sure the /var/opt/rh/rh-mariadb105/lib/mysql-glpi is empty before running mysql-prepare-db-dir.
Sep  6 14:31:52 srv1 mysqld-scl-helper: 2022-09-06 14:31:52 0 [Note] /opt/rh/rh-mariadb105/root/usr/libexec/mysqld (mysqld 10.5.16-MariaDB) starting as process 6140 ...
Sep  6 14:31:53 srv1 systemd: Started MariaDB 10.5 database server.
Sep  6 14:31:53 srv1 esmith::event[5700]: Action: /etc/e-smith/events/actions/adjust-services SUCCESS [0.862895]
Sep  6 14:31:53 srv1 esmith::event[5700]: Event: nethserver-glpi-10-latest-update SUCCESS

su - apache -s /bin/bash -c "/opt/remi/php81/root/bin/php /usr/share/glpi/bin/console glpi:maintenance:enable"
su - apache -s /bin/bash -c "/opt/remi/php81/root/bin/php glpi:database:check_schema_integrity"
su - apache -s /bin/bash -c "/opt/remi/php81/root/bin/php /usr/share/glpi/bin/console glpi:maintenance:disable"

what is the output ?

1 Like

[root@srv1 ~]# su - apache -s /bin/bash -c “/opt/remi/php81/root/bin/php /usr/share/glpi/bin/console glpi:maintenance:enable”
Modo de manutenção ativado. Backdoor usando: http://localhost/glpi//index.php?skipMaintenance=1
[root@srv1 ~]# su - apache -s /bin/bash -c “/opt/remi/php81/root/bin/php glpi:database:check_schema_integrity”
Could not open input file: glpi:database:check_schema_integrity
[root@srv1 ~]# su - apache -s /bin/bash -c “/opt/remi/php81/root/bin/php /usr/share/glpi/bin/console glpi:maintenance:disable”
Modo de manutenção desativado.

su - apache -s /bin/bash -c "/opt/remi/php81/root/bin/php /usr/share/glpi/bin/console glpi:maintenance:enable"
su - apache -s /bin/bash -c "/opt/remi/php81/root/bin/php /usr/share/glpi/bin/console glpi:database:check_schema_integrity"
su - apache -s /bin/bash -c "/opt/remi/php81/root/bin/php /usr/share/glpi/bin/console glpi:maintenance:disable"

/usr/share/glpi/bin/console is missing, never ever trust me :’(

1 Like

lol, no worries, wahhaha, i can start all over!

1 Like