GLPI SETUP - Etape 0 - L'extension mysqli est absente

toni2m · 2019-09-04 15:24:37

Bonjour,

Je souhaiterais installer GLPI 9.4.3 sur Ubuntu 18.04.

Lors de l'étape 0 : vérification de la compatibilité de l'environnement avec l'exécution de GLPI, il y a une erreur lors du : Test de l'extension mysqli => L'extension mysqli est absente.

Versions :
Apache 2.4.29
php 7.2.19
MariaDB-1:10.4.7

Merci pour votre aide.

meuced · 2019-09-06 10:12:41

Regarde dans la conf de php, tu dois avoir une ligne correspondante en commentaire, avec un ; devant. Il suffit de l'enlever et restart Apache.

toni2m · 2019-09-06 18:06:22

J'ai bien décommenté la ligne et redémarré apache mais rien n'a changé

Mr.Propre · 2019-09-09 09:37:37

toni2m wrote:

J'ai bien décommenté la ligne et redémarré apache mais rien n'a changé

Pourrions-nous avoir le résultat d'un phpinfo() ?

toni2m · 2019-09-09 11:47:15

Hello, tout d'abord merci de prendre du temps pour analyser mon problème.

Voici le résultat :

PHP Version 7.2.19-0ubuntu0.18.04.2
System	Linux vm-glpi-01 4.15.0-1040-gcp #42-Ubuntu SMP Wed Aug 7 15:17:54 UTC 2019 x86_64
Build Date	Aug 12 2019 19:34:28
Server API	Apache 2.0 Handler
Virtual Directory Support	disabled
Configuration File (php.ini) Path	/etc/php/7.2/apache2
Loaded Configuration File	/etc/php/7.2/apache2/php.ini
Scan this dir for additional .ini files	/etc/php/7.2/apache2/conf.d

Additional .ini files parsed	/etc/php/7.2/apache2/conf.d/10-opcache.ini, /etc/php/7.2/apache2/conf.d/10-pdo.ini, /etc/php/7.2/apache2/conf.d/15-xml.ini, /etc/php/7.2/apache2/conf.d/20-apcu.ini, /etc/php/7.2/apache2/conf.d/20-apcu_bc.ini, /etc/php/7.2/apache2/conf.d/20-calendar.ini, /etc/php/7.2/apache2/conf.d/20-ctype.ini, /etc/php/7.2/apache2/conf.d/20-curl.ini, /etc/php/7.2/apache2/conf.d/20-dom.ini, /etc/php/7.2/apache2/conf.d/20-exif.ini, /etc/php/7.2/apache2/conf.d/20-fileinfo.ini, /etc/php/7.2/apache2/conf.d/20-ftp.ini, /etc/php/7.2/apache2/conf.d/20-gd.ini, /etc/php/7.2/apache2/conf.d/20-gettext.ini, /etc/php/7.2/apache2/conf.d/20-iconv.ini, /etc/php/7.2/apache2/conf.d/20-imagick.ini, /etc/php/7.2/apache2/conf.d/20-imap.ini, /etc/php/7.2/apache2/conf.d/20-intl.ini, /etc/php/7.2/apache2/conf.d/20-json.ini, /etc/php/7.2/apache2/conf.d/20-ldap.ini, /etc/php/7.2/apache2/conf.d/20-mbstring.ini, /etc/php/7.2/apache2/conf.d/20-memcache.ini, /etc/php/7.2/apache2/conf.d/20-pdo_mysql.ini, /etc/php/7.2/apache2/conf.d/20-phar.ini, /etc/php/7.2/apache2/conf.d/20-posix.ini, /etc/php/7.2/apache2/conf.d/20-pspell.ini, /etc/php/7.2/apache2/conf.d/20-readline.ini, /etc/php/7.2/apache2/conf.d/20-recode.ini, /etc/php/7.2/apache2/conf.d/20-shmop.ini, /etc/php/7.2/apache2/conf.d/20-simplexml.ini, /etc/php/7.2/apache2/conf.d/20-sockets.ini, /etc/php/7.2/apache2/conf.d/20-sysvmsg.ini, /etc/php/7.2/apache2/conf.d/20-sysvsem.ini, /etc/php/7.2/apache2/conf.d/20-sysvshm.ini, /etc/php/7.2/apache2/conf.d/20-tidy.ini, /etc/php/7.2/apache2/conf.d/20-tokenizer.ini, /etc/php/7.2/apache2/conf.d/20-wddx.ini, /etc/php/7.2/apache2/conf.d/20-xmlreader.ini, /etc/php/7.2/apache2/conf.d/20-xmlrpc.ini, /etc/php/7.2/apache2/conf.d/20-xmlwriter.ini, /etc/php/7.2/apache2/conf.d/20-xsl.ini

PHP API	20170718
PHP Extension	20170718
Zend Extension	320170718
Zend Extension Build	API320170718,NTS
PHP Extension Build	API20170718,NTS
Debug Build	no
Thread Safety	disabled
Zend Signal Handling	enabled
Zend Memory Manager	enabled
Zend Multibyte Support	provided by mbstring
IPv6 Support	enabled
DTrace Support	available, disabled
Registered PHP Streams	https, ftps, compress.zlib, php, file, glob, data, http, ftp, phar
Registered Stream Socket Transports	tcp, udp, unix, udg, ssl, tls, tlsv1.0, tlsv1.1, tlsv1.2
Registered Stream Filters	zlib.*, string.rot13, string.toupper, string.tolower, string.strip_tags, convert.*, consumed, dechunk, convert.iconv.*



Configuration
apache2handler
Apache Version	Apache/2.4.29 (Ubuntu)
Apache API Version	20120211
Server Administrator	webmaster@localhost
Hostname: xxxxx
User/Group	www-data(33)/33
Max Requests	Per Child: 0 - Keep Alive: on - Max Per Connection: 100
Timeouts	Connection: 300 - Keep-Alive: 5
Virtual Server	Yes
Server Root	/etc/apache2

Loaded Modules	core mod_so mod_watchdog http_core mod_log_config mod_logio mod_version mod_unixd mod_access_compat mod_alias mod_auth_basic mod_authn_core mod_authn_file mod_authz_core mod_authz_host mod_authz_user mod_autoindex mod_deflate mod_dir mod_env mod_filter mod_mime prefork mod_negotiation mod_php7 mod_reqtimeout mod_setenvif mod_status

Directive	Local Value	Master Value
engine	1	1
last_modified	0	0
xbithack	0	0

Merci.
Cordialement,
Tony

edit la denrée : ajout balise code ;-)

Last edited by LaDenrée (2019-09-10 11:19:01)

Mr.Propre · 2019-09-10 11:09:18

Il aurait été pas mal de mettre tout ça entre balises "code" pour gagner en visibilité.

Et bien ? Tu vois que ta conf. n'a que :
20-pdo_mysql.ini
Il manque donc :
20-mysqli.ini

toni2m · 2019-09-13 00:51:20

Merci pour vos réponses
A présent dans le phpinfo mysqli apparait bien

 
System	Linux vm-glpi-01 4.15.0-1042-gcp #45-Ubuntu SMP Mon Sep 9 15:14:38 UTC 2019 x86_64
Build Date	Aug 12 2019 19:34:28
Server API	Apache 2.0 Handler
Virtual Directory Support	disabled
Configuration File (php.ini) Path	/etc/php/7.2/apache2
Loaded Configuration File	/etc/php/7.2/apache2/php.ini
Scan this dir for additional .ini files	/etc/php/7.2/apache2/conf.d
Additional .ini files parsed	/etc/php/7.2/apache2/conf.d/10-opcache.ini, /etc/php/7.2/apache2/conf.d/10-pdo.ini, /etc/php/7.2/apache2/conf.d/15-xml.ini, /etc/php/7.2/apache2/conf.d/20-apcu.ini, /etc/php/7.2/apache2/conf.d/20-apcu_bc.ini, /etc/php/7.2/apache2/conf.d/20-bz2.ini, /etc/php/7.2/apache2/conf.d/20-calendar.ini, /etc/php/7.2/apache2/conf.d/20-ctype.ini, /etc/php/7.2/apache2/conf.d/20-curl.ini, /etc/php/7.2/apache2/conf.d/20-dom.ini, /etc/php/7.2/apache2/conf.d/20-exif.ini, /etc/php/7.2/apache2/conf.d/20-fileinfo.ini, /etc/php/7.2/apache2/conf.d/20-ftp.ini, /etc/php/7.2/apache2/conf.d/20-gd.ini, /etc/php/7.2/apache2/conf.d/20-gettext.ini, /etc/php/7.2/apache2/conf.d/20-iconv.ini, /etc/php/7.2/apache2/conf.d/20-imagick.ini, /etc/php/7.2/apache2/conf.d/20-imap.ini, /etc/php/7.2/apache2/conf.d/20-intl.ini, /etc/php/7.2/apache2/conf.d/20-json.ini, /etc/php/7.2/apache2/conf.d/20-ldap.ini, /etc/php/7.2/apache2/conf.d/20-mbstring.ini, /etc/php/7.2/apache2/conf.d/20-memcache.ini, /etc/php/7.2/apache2/conf.d/20-mysqli.ini, /etc/php/7.2/apache2/conf.d/20-pdo_mysql.ini, /etc/php/7.2/apache2/conf.d/20-phar.ini, /etc/php/7.2/apache2/conf.d/20-posix.ini, /etc/php/7.2/apache2/conf.d/20-pspell.ini, /etc/php/7.2/apache2/conf.d/20-readline.ini, /etc/php/7.2/apache2/conf.d/20-recode.ini, /etc/php/7.2/apache2/conf.d/20-shmop.ini, /etc/php/7.2/apache2/conf.d/20-simplexml.ini, /etc/php/7.2/apache2/conf.d/20-sockets.ini, /etc/php/7.2/apache2/conf.d/20-sysvmsg.ini, /etc/php/7.2/apache2/conf.d/20-sysvsem.ini, /etc/php/7.2/apache2/conf.d/20-sysvshm.ini, /etc/php/7.2/apache2/conf.d/20-tidy.ini, /etc/php/7.2/apache2/conf.d/20-tokenizer.ini, /etc/php/7.2/apache2/conf.d/20-wddx.ini, /etc/php/7.2/apache2/conf.d/20-xmlreader.ini, /etc/php/7.2/apache2/conf.d/20-xmlrpc.ini, /etc/php/7.2/apache2/conf.d/20-xmlwriter.ini, /etc/php/7.2/apache2/conf.d/20-xsl.ini, /etc/php/7.2/apache2/conf.d/20-zip.ini
PHP API	20170718
PHP Extension	20170718
Zend Extension	320170718
Zend Extension Build	API320170718,NTS
PHP Extension Build	API20170718,NTS
Debug Build	no
Thread Safety	disabled
Zend Signal Handling	enabled
Zend Memory Manager	enabled
Zend Multibyte Support	provided by mbstring
IPv6 Support	enabled
DTrace Support	available, disabled
Registered PHP Streams	https, ftps, compress.zlib, php, file, glob, data, http, ftp, compress.bzip2, phar, zip
Registered Stream Socket Transports	tcp, udp, unix, udg, ssl, tls, tlsv1.0, tlsv1.1, tlsv1.2
Registered Stream Filters	zlib.*, string.rot13, string.toupper, string.tolower, string.strip_tags, convert.*, consumed, dechunk, bzip2.*, convert.iconv.*

par contre je vois qu'il manque l'extension mysqli.so dans le repertoire :

 /usr/lib/php/20170718$ ls
apc.so       curl.so      gd.so       intl.so      opcache.so    pspell.so     sockets.so  tokenizer.so  xmlwriter.so
apcu.so      dom.so       gettext.so  json.so      pdo.so        readline.so   sysvmsg.so  wddx.so       xsl.so
bz2.so       exif.so      iconv.so    ldap.so      pdo_mysql.so  recode.so     sysvsem.so  xml.so        zip.so
calendar.so  fileinfo.so  imagick.so  mbstring.so  phar.so       shmop.so      sysvshm.so  xmlreader.so
ctype.so     ftp.so       imap.so     memcache.so  posix.so      simplexml.so  tidy.so     xmlrpc.so

Je viens de me rendre compte également de ces problèmes :

php -m | grep -i mysqli
PHP Warning:  PHP Startup: Unable to load dynamic library 'mysqli' (tried: /usr/lib/php/20170718/mysqli (/usr/lib/php/20170718/mysqli: cannot open shared object file: No such file or directory), /usr/lib/php/20170718/mysqli.so (/usr/lib/php/20170718/mysqli.so: cannot open shared object file: No such file or directory)) in Unknown on line 0
PHP Warning:  PHP Startup: Unable to load dynamic library 'pdo_mysql' (tried: /usr/lib/php/20170718/pdo_mysql (/usr/lib/php/20170718/pdo_mysql: cannot open shared object file: No such file or directory), /usr/lib/php/20170718/pdo_mysql.so (/usr/lib/php/20170718/pdo_mysql.so: undefined symbol: mysqlnd_allocator)) in Unknown on line 0
PHP Warning:  PHP Startup: Unable to load dynamic library '/usr/lib/php/20170718/' (tried: /usr/lib/php/20170718/ (/usr/lib/php/20170718/: cannot read file data: Is a directory), /usr/lib/php/20170718//usr/lib/php/20170718/.so (/usr/lib/php/20170718//usr/lib/php/20170718/.so: cannot open shared object file: No such file or directory)) in Unknown on line 0
PHP Warning:  PHP Startup: Unable to load dynamic library 'pdo_mysql.so' (tried: /usr/lib/php/20170718/pdo_mysql.so (/usr/lib/php/20170718/pdo_mysql.so: undefined symbol: mysqlnd_allocator), /usr/lib/php/20170718/pdo_mysql.so.so (/usr/lib/php/20170718/pdo_mysql.so.so: cannot open shared object file: No such file or directory)) in Unknown on line 0
PHP Warning:  PHP Startup: Unable to load dynamic library 'pdo_mysql.so' (tried: /usr/lib/php/20170718/pdo_mysql.so (/usr/lib/php/20170718/pdo_mysql.so: undefined symbol: mysqlnd_allocator), /usr/lib/php/20170718/pdo_mysql.so.so (/usr/lib/php/20170718/pdo_mysql.so.so: cannot open shared object file: No such file or directory)) in Unknown on line 0

Une idée svp ?
Merci

Last edited by toni2m (2019-09-13 01:13:11)

meuced · 2019-09-18 08:57:34

As-tu installé un paquet qui s'appelerait php-mysql ou approchant ? (style php5-mysql, etc...).
Donne le résultat d'un : dpkg -l | grep mysql

toni2m · 2019-09-23 23:10:22

oui j'ai installé des packages de ce style

voici le résultat de "dpkg -l | grep mysql" :

ii  dbconfig-mysql                 2.0.9                                       all          dbconfig-common MySQL/M
ariaDB support
ii  libdbd-mysql-perl              4.046-1                                     amd64        Perl5 database interfac
e to the MariaDB/MySQL database
ii  libmysqlclient20:amd64         5.7.27-0ubuntu0.18.04.1                     amd64        MySQL database client l
ibrary
ii  mariadb-common                 1:10.4.7+maria~bionic                       all          MariaDB database common
 files (e.g. /etc/mysql/conf.d/mariadb.cnf)
ii  mysql-common                   1:10.4.7+maria~bionic                       all          MariaDB database common
 files (e.g. /etc/mysql/my.cnf)
ii  php-mysql                      1:7.2+60ubuntu1                             all          MySQL module for PHP [d
efault]
ii  php7.2-mysql                   7.2.19-0ubuntu0.18.04.2                     amd64        MySQL module for PHP

Mr.Propre · 2019-09-30 11:35:36

Tant que les bibliothèques mysqli ne seront pas installés, cela ne fonctionnera pas.
Repars d'un serveur propre et installe PhpMyAdmin, cela devrait mettre en place les paquetages qu'il faut.

Forum GLPI-Project

Announcement

#1 2019-09-04 15:24:37

GLPI SETUP - Etape 0 - L'extension mysqli est absente

#2 2019-09-06 10:12:41

Re: GLPI SETUP - Etape 0 - L'extension mysqli est absente

#3 2019-09-06 18:06:22

Re: GLPI SETUP - Etape 0 - L'extension mysqli est absente

#4 2019-09-09 09:37:37

Re: GLPI SETUP - Etape 0 - L'extension mysqli est absente

#5 2019-09-09 11:47:15

Re: GLPI SETUP - Etape 0 - L'extension mysqli est absente

#6 2019-09-10 11:09:18

Re: GLPI SETUP - Etape 0 - L'extension mysqli est absente

#7 2019-09-13 00:51:20

Re: GLPI SETUP - Etape 0 - L'extension mysqli est absente

#8 2019-09-18 08:57:34

Re: GLPI SETUP - Etape 0 - L'extension mysqli est absente

#9 2019-09-23 23:10:22

Re: GLPI SETUP - Etape 0 - L'extension mysqli est absente

#10 2019-09-30 11:35:36

Re: GLPI SETUP - Etape 0 - L'extension mysqli est absente

Board footer