You are not logged in.
Pages: 1
Bonsoir,
Je n'arrive pas à visualiser dans fusioninventory ma découverte réseau sur une plage ip "imprimantes"
Fusioninventory>Réseau>plage IP :
10.18.96.66
10.18.96.126
Fusioninventory>Tâches>Gestion des tâches :
créée avec l'agent "serveur glpi" et activé
Mon serveur glpi à bien tous les agents à jour :
fusioninventory-agent --list-tasks
Deploy (v2.0.4)
NetInventory (v2.2.1)
WakeOnLan (v2.0)
NetDiscovery (v2.2.1)
Collect (v2.3.17)
ESX (v2.2.1)
Inventory (v1.0)
Cron configuré :
crontab -u root -e
* * * * * /usr/bin/php7.0 /var/www/glpi/front/cron.php &>/dev/null
par contre sur mon serveur aucun souci : fusioninventory-netdiscovery --first 10.18.96.66 --last 10.18.96.126 --debug
<REQUEST>
<CONTENT>
<DEVICE>
<AUTHSNMP>1</AUTHSNMP>
<CONTACT>JJ</CONTACT>
<DESCRIPTION>OKI OkiLAN 8450e Rev.08.51 10/100BASE Ethernet PrintServer: Attached to C5950 Rev.N1.01 : Copyright (c) 2007 Oki Data Corporation. All rights reserved.</DESCRIPTION>
<IP>10.18.96.80</IP>
<IPS>
<IP>10.18.96.80</IP>
</IPS>
<LOCATION>DSI Office</LOCATION>
<MAC>00:80:87:6b:1d:c9</MAC>
<MANUFACTURER>OKI DATA CORP</MANUFACTURER>
<MEMORY>256</MEMORY>
<MODEL>C5950</MODEL>
<SNMPHOSTNAME>C5950-KK-FR02</SNMPHOSTNAME>
<TYPE>PRINTER</TYPE>
<UPTIME>27 days, 01:25:58.05</UPTIME>
<VENDOR>OKI</VENDOR>
</DEVICE>
<MODULEVERSION>2.2.1</MODULEVERSION>
<PROCESSNUMBER>1</PROCESSNUMBER>
</CONTENT>
<DEVICEID>foo</DEVICEID>
<QUERY>NETDISCOVERY</QUERY>
</REQUEST>
Offline
Dans les logs de la tache c'est marqué quoi?
T'as bien mis les communautés dans la plage IP ?
Offline
Bonjour,
Je ne vois même pas les logs dans la tâche. les logs apache2 ci-dessous:
PHP Fatal error: Uncaught Error: Call to a member function fetch_array() on boolean in /var/www/glpi/inc/dbmysql.class.php:254\nStack trace:\n#0 /var/www/glpi/plugins/fusioninventory/inc/statediscovery.class.php(161): DBmysql->fetch_array(false)\n#1 /var/www/glpi/plugins/fusioninventory/front/statediscovery.php(53): PluginFusioninventoryStateDiscovery->display()\n#2 {main}\n thrown in /var/www/glpi/inc/dbmysql.class.php on line 254, referer: http://osf-glpi/plugins/fusioninventory/front/taskjob.php
PHP Fatal error: Uncaught Error: Call to a member function fetch_array() on boolean in /var/www/glpi/inc/dbmysql.class.php:254\nStack trace:\n#0 /var/www/glpi/plugins/fusioninventory/inc/stateinventory.class.php(112): DBmysql->fetch_array(false)\n#1 /var/www/glpi/plugins/fusioninventory/front/stateinventory.php(54): PluginFusioninventoryStateInventory->display()\n#2 {main}\n thrown in /var/www/glpi/inc/dbmysql.class.php on line 254, referer: http://osf-glpi/plugins/fusioninventory/front/statediscovery.php
Version MySQL 5.7.16-0ubuntu0.16.04.1 - PHP : 7.0.8
Last edited by patrice.nguyen (2016-11-08 11:08:27)
Offline
Humm, je vois MySQL 5.7.16, ça ne fonctionnera pas en effet, passe sur un MySQL 5.6
Offline
Mon GLPI est sur la dernière version MySQL avec ubuntu. comment puis-je rétrograder vers une ancienne version ?
Je dois tout casser ?? car je ne peux pas ajouter une ancienne version il me dira que la dernière version est déjà installé.
Merci pour ton aide
Offline
Bonjour,
vous pouvez probablement installer mariadb et importer un dump de la base mysql dans mariadb ?
Trouver la panne avant de réparer...
GLPI10.0.10 (ubuntu 22.04 PHP8.1 Mariadb10.6 ) plugins : comportements 2.7.2 reports 1.16.0 formcreator 2.13.8, datainjection 2.13.4 fields 1.21.6
Offline
Bonjour Ladenrée,
Quelle version de Mariadb dois-je installer svp pour être sur de faire fonctionner fusioninventory dessus. Merci
Offline
Prends la dernière, ça doit fonctionner
Offline
Alors j'ai fait la mirgation mysql vers mariadb
apt-get install mariadb-server mariadb-client
mysql_upgrade --force
mysql -u root -p all-databases < all-databases.sql
Connexion glpi
A link to the Mysql server could not be established. Please check your configuration.
Le serveur Mysql est inaccessible. Vérifiez votre configuration
si je fais mysql -u root -p
ERROR 2002 (HY000): Can't connect to local MySQL server through socket '/var/run/mysqld/mysqld.sock' (2 "No such file or directory")
je ne comprends plus rien pourtant j'ai suivi la migration simple, pouvez-vous m'aider?
Offline
systemctl status mysql.service
nov. 09 16:53:04 osf-glpi mysqld[2613]: 161109 16:53:04 [Note] Plugin 'FEEDBACK' is disabled.
nov. 09 16:53:04 osf-glpi mysqld[2613]: 161109 16:53:04 [Note] Server socket created on IP: '127.0.0.1'.
nov. 09 16:53:04 osf-glpi mysqld[2613]: 161109 16:53:04 [ERROR] Fatal error: mysql.user table is damaged or in unsupported 3.2
nov. 09 16:53:04 osf-glpi mysqld_safe[2639]: mysqld from pid file /var/run/mysqld/mysqld.pid ended
nov. 09 16:53:34 osf-glpi /etc/init.d/mysql[2918]: 0 processes alive and '/usr/bin/mysqladmin --defaults-file=/etc/mysql/debia
nov. 09 16:53:34 osf-glpi /etc/init.d/mysql[2918]: [61B blob data]
nov. 09 16:53:34 osf-glpi /etc/init.d/mysql[2918]: error: 'Can't connect to local MySQL server through socket '/var/run/mysqld
nov. 09 16:53:34 osf-glpi /etc/init.d/mysql[2918]: Check that mysqld is running and that the socket: '/var/run/mysqld/mysqld.s
nov. 09 16:53:34 osf-glpi /etc/init.d/mysql[2918]:
nov. 09 16:53:34 osf-glpi mysql[2436]: ...fail!
nov. 09 16:53:34 osf-glpi systemd[1]: mysql.service: Control process exited, code=exited status=1
nov. 09 16:53:34 osf-glpi systemd[1]: Failed to start LSB: Start and stop the mysql database server daemon.
-- Subject: L'unité (unit) mysql.service a échoué
-- Defined-By: systemd
-- Support: http://lists.freedesktop.org/mailman/li … temd-devel
journalctl -xe
nov. 09 16:53:04 osf-glpi mysqld_safe[2639]: mysqld from pid file /var/run/mysqld/mysqld.pid ended
nov. 09 16:53:34 osf-glpi /etc/init.d/mysql[2918]: 0 processes alive and '/usr/bin/mysqladmin --defaults-file=/etc/mysql/debia
nov. 09 16:53:34 osf-glpi /etc/init.d/mysql[2918]: [61B blob data]
nov. 09 16:53:34 osf-glpi /etc/init.d/mysql[2918]: error: 'Can't connect to local MySQL server through socket '/var/run/mysqld
nov. 09 16:53:34 osf-glpi /etc/init.d/mysql[2918]: Check that mysqld is running and that the socket: '/var/run/mysqld/mysqld.s
nov. 09 16:53:34 osf-glpi /etc/init.d/mysql[2918]:
nov. 09 16:53:34 osf-glpi mysql[2436]: ...fail!
nov. 09 16:53:34 osf-glpi systemd[1]: mysql.service: Control process exited, code=exited status=1
nov. 09 16:53:34 osf-glpi systemd[1]: Failed to start LSB: Start and stop the mysql database server daemon.
-- Subject: L'unité (unit) mysql.service a échoué
-- Defined-By: systemd
-- Support: http://lists.freedesktop.org/mailman/listinfo/systemd-devel
--
-- L'unité (unit) mysql.service a échoué, avec le résultat failed.
nov. 09 16:53:34 osf-glpi systemd[1]: mysql.service: Unit entered failed state.
nov. 09 16:53:34 osf-glpi systemd[1]: mysql.service: Failed with result 'exit-code'.
nov. 09 16:53:34 osf-glpi sudo[2417]: pam_unix(sudo:session): session closed for user root
nov. 09 16:54:01 osf-glpi CRON[2946]: pam_unix(cron:session): session opened for user root by (uid=0)
nov. 09 16:54:01 osf-glpi CRON[2947]: (root) CMD (/usr/bin/php7.0 /var/www/glpi/front/cron.php &>/dev/null)
nov. 09 16:54:01 osf-glpi CRON[2946]: pam_unix(cron:session): session closed for user root
nov. 09 16:55:01 osf-glpi CRON[2949]: pam_unix(cron:session): session opened for user root by (uid=0)
nov. 09 16:55:01 osf-glpi CRON[2950]: (root) CMD (/usr/bin/php7.0 /var/www/glpi/front/cron.php &>/dev/null)
nov. 09 16:55:01 osf-glpi CRON[2949]: pam_unix(cron:session): session closed for user root
nov. 09 16:56:01 osf-glpi CRON[2954]: pam_unix(cron:session): session opened for user root by (uid=0)
nov. 09 16:56:01 osf-glpi CRON[2955]: (root) CMD (/usr/bin/php7.0 /var/www/glpi/front/cron.php &>/dev/null)
nov. 09 16:56:01 osf-glpi CRON[2954]: pam_unix(cron:session): session closed for user root
nov. 09 16:57:01 osf-glpi CRON[2959]: pam_unix(cron:session): session opened for user root by (uid=0)
nov. 09 16:57:01 osf-glpi CRON[2960]: (root) CMD (/usr/bin/php7.0 /var/www/glpi/front/cron.php &>/dev/null)
nov. 09 16:57:01 osf-glpi CRON[2959]: pam_unix(cron:session): session closed for user root
Offline
Bon j'ai supprimé MySQL et MariaDB
et je viens de réinstaller MriaDB 10.0.27 sous ubuntu 16.04
comment puis-je restaurer mon glpi sachant que j'ai sauvegardé avant avec MySQL un dump de alldatabases
Offline
Pages: 1