Forum GLPI-Project

pc86

Member

Registered: 2020-10-01

Posts: 4

LDAP Sync broken after 9.5.1 upgrade from 9.5.0 *** SOLVED

Hello GLPI Guy's

The LDAP is no longer working after upgrade to 9.5.1

I have the following error msg:

PHP User Warning (512): Table does not exists in /home/parc/public_html/glpi/inc/dbmysql.class.php at line 1009
PHP User Error (256): Missing table name in /home/parc/public_html/glpi/inc/dbmysqliterator.class.php at line 277

Steps for action:
* Go to Administration / Users
* Select an user
* Go to Synchronisation
* Click on Force Synchronization

LDAP authentification is working fine

any help or advice is welcome

Best regards
PhilippeC.

 
GLPI 9.5.1 ( => /home/parc/public_html/glpi)
Installation mode: TARBALL

Server
 
Operating system: Linux ********  4.15.0-91-generic #92-Ubuntu SMP Fri Feb 28 11:09:48 UTC 2020 x86_64
PHP 7.2.24-0ubuntu0.18.04.6 apache2handler (Core, PDO, Phar, Reflection, SPL, SimpleXML, Zend OPcache, apache2handler, apc,
	apcu, bz2, calendar, ctype, curl, date, dom, exif, fileinfo, filter, ftp, gd, gettext, hash, iconv, imagick, imap, intl, json,
	ldap, libxml, mbstring, memcache, mysqli, mysqlnd, openssl, pcre, pdo_mysql, posix, readline, recode, session, shmop, soap,
	sockets, sodium, standard, sysvmsg, sysvsem, sysvshm, tidy, tokenizer, wddx, xml, xmlreader, xmlrpc, xmlwriter, xsl, zip, zlib)
Setup: max_execution_time="600" memory_limit="128M" post_max_size="16M" safe_mode="" session.save_handler="files"
	upload_max_filesize="20M" 
Software: Apache/2.4.29 (Ubuntu) (Apache/2.4.29 (Ubuntu) Server at parc.******** Port 443)
	Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/83.0.4103.116 Safari/537.36
Server Software: mariadb.org binary distribution
	Server Version: 10.4.14-MariaDB-1:10.4.14+maria~bionic
	Server SQL Mode: 
	Parameters: *****@********/*****
	Host info: Localhost via UNIX socket
	
PHP version is at least 7.2.0 - Perfect!PHP version is at least 7.2.0 - Perfect!
Sessions support is available - Perfect!Sessions support is available - Perfect!
Allocated memory > 64 Mio - Perfect!Allocated memory > 64 Mio - Perfect!
mysqli extension is installedmysqli extension is installed
ctype extension is installedctype extension is installed
fileinfo extension is installedfileinfo extension is installed
json extension is installedjson extension is installed
mbstring extension is installedmbstring extension is installed
iconv extension is installediconv extension is installed
zlib extension is installedzlib extension is installed
curl extension is installedcurl extension is installed
gd extension is installedgd extension is installed
simplexml extension is installedsimplexml extension is installed
intl extension is installedintl extension is installed
ldap extension is installedldap extension is installed
apcu extension is installedapcu extension is installed
Zend OPcache extension is installedZend OPcache extension is installed
xmlrpc extension is installedxmlrpc extension is installed
CAS extension is installedCAS extension is installed
exif extension is installedexif extension is installed
zip extension is installedzip extension is installed
bz2 extension is installedbz2 extension is installed
sodium extension is installedsodium extension is installed
Database version seems correct (10.4.14) - Perfect!Database version seems correct (10.4.14) - Perfect!
Access to timezone database (mysql) is not allowed.Access to timezone database (mysql) is not allowed.
The log file has been created successfully.The log file has been created successfully.
Write access to /etc/parc/ has been validated.Write access to /etc/parc/ has been validated.
Write access to /var/lib/parc/files has been validated.Write access to /var/lib/parc/files has been validated.
Write access to /var/lib/parc/files/_dumps has been validated.Write access to /var/lib/parc/files/_dumps has been validated.
Write access to /var/lib/parc/files/_sessions has been validated.Write access to /var/lib/parc/files/_sessions has been validated.
Write access to /var/lib/parc/files/_cron has been validated.Write access to /var/lib/parc/files/_cron has been validated.
Write access to /var/lib/parc/files/_graphs has been validated.Write access to /var/lib/parc/files/_graphs has been validated.
Write access to /var/lib/parc/files/_lock has been validated.Write access to /var/lib/parc/files/_lock has been validated.
Write access to /var/lib/parc/files/_plugins has been validated.Write access to /var/lib/parc/files/_plugins has been validated.
Write access to /var/lib/parc/files/_tmp has been validated.Write access to /var/lib/parc/files/_tmp has been validated.
Write access to /var/lib/parc/files/_cache has been validated.Write access to /var/lib/parc/files/_cache has been validated.
Write access to /var/lib/parc/files/_rss has been validated.Write access to /var/lib/parc/files/_rss has been validated.
Write access to /var/lib/parc/files/_uploads has been validated.Write access to /var/lib/parc/files/_uploads has been validated.
Write access to /var/lib/parc/files/_pictures has been validated.Write access to /var/lib/parc/files/_pictures has been validated.
Write access to /home/parc/public_html/glpi/marketplace has been validated.Write access to /home/parc/public_html/glpi/marketplace has been validated.

GLPI constants
 
GLPI_ROOT: /home/parc/public_html/glpi
GLPI_CONFIG_DIR: /etc/parc/
GLPI_VAR_DIR: /var/lib/parc/files
GLPI_LOG_DIR: /var/log/parc
GLPI_MARKETPLACE_DIR: /home/parc/public_html/glpi/marketplace
GLPI_USE_CSRF_CHECK: 1
GLPI_CSRF_EXPIRES: 7200
GLPI_CSRF_MAX_TOKENS: 100
GLPI_TELEMETRY_URI: https://telemetry.glpi-project.org
GLPI_INSTALL_MODE: TARBALL
GLPI_NETWORK_MAIL: glpi@teclib.com
GLPI_NETWORK_SERVICES: https://services.glpi-network.com
GLPI_MARKETPLACE_PRERELEASES: 
GLPI_USER_AGENT_EXTRA_COMMENTS: 
GLPI_AJAX_DASHBOARD: 1
GLPI_CALDAV_IMPORT_STATE: 0
GLPI_DEMO_MODE: 0
GLPI_FORCE_EMPTY_SQL_MODE: 1
GLPI_DOC_DIR: /var/lib/parc/files
GLPI_CACHE_DIR: /var/lib/parc/files/_cache
GLPI_CRON_DIR: /var/lib/parc/files/_cron
GLPI_DUMP_DIR: /var/lib/parc/files/_dumps
GLPI_GRAPH_DIR: /var/lib/parc/files/_graphs
GLPI_LOCAL_I18N_DIR: /var/lib/parc/files/_locales
GLPI_LOCK_DIR: /var/lib/parc/files/_lock
GLPI_PICTURE_DIR: /var/lib/parc/files/_pictures
GLPI_PLUGIN_DOC_DIR: /var/lib/parc/files/_plugins
GLPI_RSS_DIR: /var/lib/parc/files/_rss
GLPI_SESSION_DIR: /var/lib/parc/files/_sessions
GLPI_TMP_DIR: /var/lib/parc/files/_tmp
GLPI_UPLOAD_DIR: /var/lib/parc/files/_uploads
GLPI_NETWORK_REGISTRATION_API_URL: https://services.glpi-network.com/api/registration/
GLPI_MARKETPLACE_PLUGINS_API_URI: https://services.glpi-network.com/api/glpi-plugins/
GLPI_I18N_DIR: /home/parc/public_html/glpi/locales
GLPI_VERSION: 9.5.1
GLPI_SCHEMA_VERSION: 9.5.0
GLPI_MIN_PHP: 7.2.0
GLPI_YEAR: 2020

Libraries
 
htmlawed/htmlawed version 1.2.5 in (/home/parc/public_html/glpi/vendor/htmlawed/htmlawed)
phpmailer/phpmailer version 6.1.6 in (/home/parc/public_html/glpi/vendor/phpmailer/phpmailer/src)
simplepie/simplepie version 1.5.5 in (/home/parc/public_html/glpi/vendor/simplepie/simplepie/library)
tecnickcom/tcpdf version 6.3.5 in (/home/parc/public_html/glpi/vendor/tecnickcom/tcpdf)
michelf/php-markdown in (/home/parc/public_html/glpi/vendor/michelf/php-markdown/Michelf)
true/punycode in (/home/parc/public_html/glpi/vendor/true/punycode/src)
iamcal/lib_autolink in (/home/parc/public_html/glpi/vendor/iamcal/lib_autolink)
sabre/dav in (/home/parc/public_html/glpi/vendor/sabre/dav/lib/DAV)
sabre/http in (/home/parc/public_html/glpi/vendor/sabre/http/lib)
sabre/uri in (/home/parc/public_html/glpi/vendor/sabre/uri/lib)
sabre/vobject in (/home/parc/public_html/glpi/vendor/sabre/vobject/lib)
laminas/laminas-cache in (/home/parc/public_html/glpi/vendor/laminas/laminas-cache/src)
laminas/laminas-i18n in (/home/parc/public_html/glpi/vendor/laminas/laminas-i18n/src)
laminas/laminas-serializer in (/home/parc/public_html/glpi/vendor/laminas/laminas-serializer/src)
monolog/monolog in (/home/parc/public_html/glpi/vendor/monolog/monolog/src/Monolog)
sebastian/diff in (/home/parc/public_html/glpi/vendor/sebastian/diff/src)
elvanto/litemoji in (/home/parc/public_html/glpi/vendor/elvanto/litemoji/src)
symfony/console in (/home/parc/public_html/glpi/vendor/symfony/console)
scssphp/scssphp in (/home/parc/public_html/glpi/vendor/scssphp/scssphp/src)
laminas/laminas-mail in (/home/parc/public_html/glpi/vendor/laminas/laminas-mail/src/Protocol)
laminas/laminas-mime in (/home/parc/public_html/glpi/vendor/laminas/laminas-mime/src)
rlanvin/php-rrule in (/home/parc/public_html/glpi/vendor/rlanvin/php-rrule/src)
blueimp/jquery-file-upload in (/home/parc/public_html/glpi/vendor/blueimp/jquery-file-upload/server/php)
ramsey/uuid in (/home/parc/public_html/glpi/vendor/ramsey/uuid/src)
psr/log in (/home/parc/public_html/glpi/vendor/psr/log/Psr/Log)
psr/simple-cache in (/home/parc/public_html/glpi/vendor/psr/simple-cache/src)
mexitek/phpcolors in (/home/parc/public_html/glpi/vendor/mexitek/phpcolors/src/Mexitek/PHPColors)
guzzlehttp/guzzle in (/home/parc/public_html/glpi/vendor/guzzlehttp/guzzle/src)
wapmorgan/unified-archive in (/home/parc/public_html/glpi/vendor/wapmorgan/unified-archive/src)
paragonie/sodium_compat in (/home/parc/public_html/glpi/vendor/paragonie/sodium_compat/src)
phpCas version 1.3.3 in (/usr/share/php)

LDAP directories
 
Server: '**********', Port: '389', BaseDN: 'DC=*******,DC=FR', Connection filter:
		'(&(objectClass=user)(!(cn=Health*))(objectCategory=person)(!(userAccountControl:1.2.840.113556.1.4.803:=2)))', RootDN:
		'cn=tech-glpi,OU=******,DC=********,DC=FR', Use TLS: none

SQL replicas
 
Not active

Notifications
 
Way of sending emails: SMTP (anonymous@localhost)

Mails receivers
 
Name: '**@*******' Active: Yes
	Server: '{********/pop/validate-cert/tls}' Login: '*******' Password: Yes

Plugins list
 
	addressing           Name: Adressage IP                   Version: 2.8.0      State: Not installed
	treeview             Name: Arborescence                   Version: 1.9.0      State: Enabled
	behaviors            Name: Comportements                  Version: 2.4.1      State: Enabled
	mydashboard          Name: Dashboard                      Version: 1.8.0      State: Installed / not activated
	datainjection        Name: Data injection                 Version: 2.8.0      State: Enabled
	consumables          Name: Demande de consommables        Version: 1.5.0      State: Not installed
	escalade             Name: Escalades                      Version: 2.6.0      State: Enabled
	fusioninventory      Name: FusionInventory                Version: 9.5.0+1.0  State: Enabled
	geninventorynumber   Name: Génération de numéros d'invent Version: 2.5.0      State: Enabled
	tag                  Name: Gestion des tags               Version: 2.7.0      State: Enabled
	tasklists            Name: Liste des tâches               Version: 1.6.0      State: Enabled

Last edited by pc86 (2020-10-02 12:10:10)

pc86

Member

Registered: 2020-10-01

Posts: 4

Re: LDAP Sync broken after 9.5.1 upgrade from 9.5.0 *** SOLVED

Finally
I have found the problem.

I had a rule in the "Authorizations assignment rules" which created the mess:

Criterion was :
* Group is <NAME OF THE GROUP>
* Group under <NAME OF THE GROUP>

My mistake

fralla2

Member

Registered: 2018-03-28

Posts: 9

Re: LDAP Sync broken after 9.5.1 upgrade from 9.5.0 *** SOLVED

Had the same error message on 9.5.2 but with mailcollectors and formcreator plugins....

For the mail collector, I managed to pinpoint it down to this business rule :
- Criteria : Category - Name IS "N/A" (0)
- Actions : Category Assign "Service des Technologies" (43)

I tried changed it to "Category - Name Does not exist" but that didn't work
Disabling this rules compleatly worked

I still haven't fount the one that messes up with formcreator thow... Same error message