You are not logged in.

Announcement

 Téléchargez la dernière version stable de GLPI      -     Et vous, que pouvez vous faire pour le projet GLPI ? :  Contribuer
 Download last stable version of GLPI                      -     What can you do for GLPI ? :  Contribute

#1 2021-11-03 12:00:08

psih@monaco-telecom.mc
Member
Registered: 2021-11-03
Posts: 2

GLPI + SCCM - Problem to connect to the MSSQL server via the GUI

Hi

Config
----------------------------------
- CENTOS 7 (UpToDate)
- PHP 7.3.31 (cli) (built: Sep 30 2021 17:05:50) ( NTS )
- Zend Engine v3.3.31, Copyright (c) 1998-2018 Zend Technologies
    with Zend OPcache v7.3.31, Copyright (c) 1999-2018, by Zend Technologies
    with Xdebug v2.7.2, Copyright (c) 2002-2019, by Derick Rethans
- MariaDB 10.4.12
- GLPI 9.5.6
- FusionInventory 9.5+3.0
- SCCM 2.3.0

=======================================================================================================================
Extract config
=======================================================================================================================
Operating system: Linux xxxxxxxxxx 3.10.0-1160.42.2.el7.x86_64 #1 SMP Tue Sep 7 14:49:57 UTC 2021 x86_64
PHP 7.3.31 apache2handler (Core, PDO, PDO_Firebird, PDO_ODBC, Phar, Reflection, SPL, SimpleXML, Zend OPcache, amqp,
    apache2handler, apcu, bcmath, bz2, calendar, ctype, curl, date, dba, dom, enchant, exif, fileinfo, filter, ftp, gd, geoip,
    gettext, gmp, hash, iconv, igbinary, imagick, imap, interbase, intl, json, ldap, libsmbclient, libxml, lzf, mbstring, memcached,
    mongodb, msgpack, mysqli, mysqlnd, odbc, openssl, pcre, pdo_dblib, pdo_mysql, pdo_pgsql, pdo_sqlite, pdo_sqlsrv, pgsql, posix,
    pspell, recode, redis, session, shmop, smbclient, snmp, soap, sockets, sodium, sqlite3, sqlsrv, ssh2, standard, sysvmsg,
    sysvsem, sysvshm, tidy, tokenizer, wddx, xdebug, xml, xmlreader, xmlrpc, xmlwriter, xsl, yaml, zip, zlib)
Setup: max_execution_time="30" memory_limit="128M" post_max_size="8M" safe_mode="" session.save_handler="files"
    upload_max_filesize="2M"
Software: Apache/2.4.6 (CentOS) OpenSSL/1.0.2k-fips PHP/7.3.31 mod_perl/2.0.11 Perl/v5.16.3 ()
    Mozilla/5.0 (X11; Linux x86_64; rv:78.0) Gecko/20100101 Firefox/78.0
Server Software: MariaDB Server
    Server Version: 10.4.21-MariaDB
    Server SQL Mode:
    Parameters: glpi@localhost/glpi
    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
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.21) - Perfect!Database version seems correct (10.4.21) - Perfect!

The log file has been created successfully.The log file has been created successfully.
Write access to /data/glpi-9.5.6/files/_cache has been validated.Write access to /data/glpi-9.5.6/files/_cache has been validated.
Write access to /data/glpi-9.5.6/config has been validated.Write access to /data/glpi-9.5.6/config has been validated.
Write access to /data/glpi-9.5.6/files/_cron has been validated.Write access to /data/glpi-9.5.6/files/_cron has been validated.
Write access to /data/glpi-9.5.6/files has been validated.Write access to /data/glpi-9.5.6/files has been validated.
Write access to /data/glpi-9.5.6/files/_dumps has been validated.Write access to /data/glpi-9.5.6/files/_dumps has been validated.
Write access to /data/glpi-9.5.6/files/_graphs has been validated.Write access to /data/glpi-9.5.6/files/_graphs has been validated.
Write access to /data/glpi-9.5.6/files/_lock has been validated.Write access to /data/glpi-9.5.6/files/_lock has been validated.
Write access to /data/glpi-9.5.6/files/_pictures has been validated.Write access to /data/glpi-9.5.6/files/_pictures has been validated.
Write access to /data/glpi-9.5.6/files/_plugins has been validated.Write access to /data/glpi-9.5.6/files/_plugins has been validated.
Write access to /data/glpi-9.5.6/files/_rss has been validated.Write access to /data/glpi-9.5.6/files/_rss has been validated.
Write access to /data/glpi-9.5.6/files/_sessions has been validated.Write access to /data/glpi-9.5.6/files/_sessions has been validated.
Write access to /data/glpi-9.5.6/files/_tmp has been validated.Write access to /data/glpi-9.5.6/files/_tmp has been validated.
Write access to /data/glpi-9.5.6/files/_uploads has been validated.Write access to /data/glpi-9.5.6/files/_uploads has been validated.
Write access to /data/glpi-9.5.6/marketplace has been validated.Write access to /data/glpi-9.5.6/marketplace has been validated.
Web access to files directory is protectedWeb access to files directory is protected
For security reasons, SELinux mode should be Enforcing.For security reasons, SELinux mode should be Enforcing.

GLPI constants

GLPI_ROOT: /data/glpi-9.5.6
GLPI_CONFIG_DIR: /data/glpi-9.5.6/config
GLPI_VAR_DIR: /data/glpi-9.5.6/files
GLPI_MARKETPLACE_DIR: /data/glpi-9.5.6/marketplace
GLPI_USE_CSRF_CHECK: 1
GLPI_CSRF_EXPIRES: 7200
GLPI_CSRF_MAX_TOKENS: 100
GLPI_USE_IDOR_CHECK: 1
GLPI_IDOR_EXPIRES: 7200
GLPI_ALLOW_IFRAME_IN_RICH_TEXT:
GLPI_TELEMETRY_URI:
GLPI_INSTALL_MODE: TARBALL
GLPI_NETWORK_MAIL: glpi@teclib.com
GLPI_NETWORK_SERVICES:
GLPI_MARKETPLACE_PRERELEASES:
GLPI_MARKETPLACE_ALLOW_OVERRIDE: 1
GLPI_MARKETPLACE_MANUAL_DOWNLOADS: 1
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: /data/glpi-9.5.6/files
GLPI_CACHE_DIR: /data/glpi-9.5.6/files/_cache
GLPI_CRON_DIR: /data/glpi-9.5.6/files/_cron
GLPI_DUMP_DIR: /data/glpi-9.5.6/files/_dumps
GLPI_GRAPH_DIR: /data/glpi-9.5.6/files/_graphs
GLPI_LOCAL_I18N_DIR: /data/glpi-9.5.6/files/_locales
GLPI_LOCK_DIR: /data/glpi-9.5.6/files/_lock
GLPI_LOG_DIR: /data/glpi-9.5.6/files/_log
GLPI_PICTURE_DIR: /data/glpi-9.5.6/files/_pictures
GLPI_PLUGIN_DOC_DIR: /data/glpi-9.5.6/files/_plugins
GLPI_RSS_DIR: /data/glpi-9.5.6/files/_rss
GLPI_SESSION_DIR: /data/glpi-9.5.6/files/_sessions
GLPI_TMP_DIR: /data/glpi-9.5.6/files/_tmp
GLPI_UPLOAD_DIR: /data/glpi-9.5.6/files/_uploads
GLPI_NETWORK_REGISTRATION_API_URL:
GLPI_MARKETPLACE_PLUGINS_API_URI:
GLPI_I18N_DIR: /data/glpi-9.5.6/locales
GLPI_VERSION: 9.5.6
GLPI_SCHEMA_VERSION: 9.5.6
GLPI_MIN_PHP: 7.2.0
GLPI_YEAR: 2021

Libraries

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

LDAP directories

Server: 'ldaps://xxxxxxxxxxxx', Port: '636', BaseDN: 'DC=gmt,DC=intra', Connection filter:
        '(&(objectClass=user)(objectCategory=person))', RootDN: 'xxxxxx@xxxxxxx', Use TLS: none

SQL replicas

Not active

Notifications

Way of sending emails: SMTP (anonymous@mtsmtp.prod.lan)

Mails receivers

Plugins list

    badges               Name: Badges                         Version: 2.6.0      State: Enabled
    datainjection        Name: Data injection                 Version: 2.9.0      State: Enabled
    domains              Name: Domains                        Version: 2.2.1      State: Enabled
    manageentities       Name: Entities portal                Version: 3.2.2      State: Enabled
    environment          Name: Environment                    Version: 2.4.1      State: Enabled
    fusioninventory      Name: FusionInventory                Version: 9.5+3.0    State: Enabled
    resources            Name: Human Resources                Version: 2.7.0      State: Enabled
    sccm                 Name: Interface - SCCM               Version: 2.3.0      State: Enabled
    addressing           Name: IP Adressing                   Version: 2.9.0      State: Enabled
    ocsinventoryng       Name: OCS Inventory NG               Version: 1.7.3      State: Enabled
    printercounters      Name: Printer counters               Version: 1.7.0      State: Enabled
    manufacturersimports Name: Suppliers imports              Version: 2.3.1      State: Enabled
    tag                  Name: Tag Management                 Version: 2.8.1      State: Enabled

OCS Inventory NG
Host: localhost
Connection: Ok
Use the OCSNG software dictionary: No

=======================================================================================================================



Logs
----------------------------------
==> /var/log/httpd/error_log <==
[Wed Nov 03 10:46:48.010088 2021] [core:notice] [pid 15321] AH00052: child pid 4023 exit signal Segmentation fault (11)

Tests connectivity
---------------------------------
# sqlcmd -S 10.99.xxx.xxx\\SCCM,1433 -U xxxxx -Q "SELECT * FROM dbo.CM_GMT;"
Password:
Msg 208, Level 16, State 1, Server VWB-SQL-P01\SCCM, Line 1
Nom d'objet 'dbo.CM_GMT' non valide.
# sqlcmd -S 10.99.xxx.xxx\\SCCM,1433 -U xxxxx
Password:
1> quit

Problem
--------------------------------
Not working via the GUI. We have in the logs "Segmentation fault"

Last edited by psih@monaco-telecom.mc (2021-11-11 16:23:20)

Offline

Board footer

Powered by FluxBB