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 2017-08-08 21:56:33

jmoran
Member
Registered: 2017-08-08
Posts: 11

Plugin ocsinventoryng for GLPI - Connection to the database failed

Hello

The Plugin ocsinventoryng for GLPI Connection to the database failed. As you can see the user is being denied. However I can log on to MYSQL via the command line. I have even tried stopping the Firewall. The user ocs_glpi has all permissions on the database, both the OCS Database and the GLPI Database as 'ocs_glpi'@'localhost' and 'ocs_glpi'@'%'.

Any suggestions? Could there be an issue where by the password contains characters that either PHP, or MySQL do not like?


Logging on via command line:
[root@servername ~]# mysql --host=localhost --user=ocs_glpi -p ocsweb
Enter password:
Reading table information for completion of table and column names
You can turn off this feature to get a quicker startup with -A
Welcome to the MySQL monitor.  Commands end with ; or \g.
Your MySQL connection id is 11
Server version: 5.7.19 MySQL Community Server (GPL)
Copyright (c) 2000, 2017, Oracle and/or its affiliates. All rights reserved.
Oracle is a registered trademark of Oracle Corporation and/or its
affiliates. Other names may be trademarks of their respective
owners.
Type 'help;' or '\h' for help. Type '\c' to clear the current input statement.
mysql> exit
Bye
[root@servername ~]# mysql --host=127.0.0.1 --user=ocs_glpi -p ocsweb
Enter password:
Reading table information for completion of table and column names
You can turn off this feature to get a quicker startup with -A
Welcome to the MySQL monitor.  Commands end with ; or \g.
Your MySQL connection id is 13
Server version: 5.7.19 MySQL Community Server (GPL)
Copyright (c) 2000, 2017, Oracle and/or its affiliates. All rights reserved.
Oracle is a registered trademark of Oracle Corporation and/or its
affiliates. Other names may be trademarks of their respective
owners.
Type 'help;' or '\h' for help. Type '\c' to clear the current input statement.
mysql>



Versions:
CentOS 7
OCS Server 2.3.1
GLPI 9.1.6
GLPI OCS Inventory NG Plugin    1.3.3


ERRORS:

cat /var/log/mysqld.log
2017-08-08T17:44:06.344225Z 614 [Note] Access denied for user 'ocs_glpi'@'localhost' (using password: YES)
2017-08-08T17:44:06.346458Z 615 [Note] Access denied for user 'ocs_glpi'@'localhost' (using password: YES)
2017-08-08T17:44:07.956108Z 617 [Note] Access denied for user 'ocs_glpi'@'localhost' (using password: YES)
2017-08-08T17:44:07.972113Z 619 [Note] Access denied for user 'ocs_glpi'@'localhost' (using password: YES)
2017-08-08T17:44:07.973759Z 620 [Note] Access denied for user 'ocs_glpi'@'localhost' (using password: YES)
2017-08-08T17:45:51.380558Z 625 [Note] Access denied for user 'ocs_glpi'@'localhost' (using password: YES)
2017-08-08T17:45:51.382849Z 626 [Note] Access denied for user 'ocs_glpi'@'localhost' (using password: YES)


cat /var/log/glpi/php-errors.log
2017-08-08 19:36:37 [2@servername]
  *** PHP Warning(2): mysqli::__construct(): (HY000/2002): php_network_getaddresses: getaddrinfo failed: Name or service not known
  Backtrace :
  :
  inc/dbmysql.class.php:121                          mysqli->__construct()
  inc/dbmysql.class.php:81                           DBmysql->connect()
  plugins/ocsinventoryng/inc/dbocs.class.php:57      DBmysql->__construct()
  ...ins/ocsinventoryng/inc/ocsdbclient.class.php:53 PluginOcsinventoryngDBocs->__construct()
  ...ins/ocsinventoryng/inc/ocsserver.class.php:5243 PluginOcsinventoryngOcsDbClient->__construct()
  ...ins/ocsinventoryng/inc/ocsserver.class.php:5227 PluginOcsinventoryngOcsServer::getDBocs()
  ...ins/ocsinventoryng/inc/snmpocslink.class.php:70 PluginOcsinventoryngOcsServer::checkOCSconnection()
  inc/commonglpi.class.php:208                       PluginOcsinventoryngSnmpOcslink->getTabNameForItem()
  plugins/ocsinventoryng/inc/ocsserver.class.php:198 CommonGLPI->addStandardTab()
  inc/commonglpi.class.php:158                       PluginOcsinventoryngOcsServer->defineTabs()
  ajax/updatecurrenttab.php:51                       CommonGLPI->defineAllTabs()
2017-08-08 19:36:57 [2@servername]
  *** PHP Warning(2): mysqli::__construct(): php_network_getaddresses: getaddrinfo failed: Name or service not known
  Backtrace :
  :
  inc/dbmysql.class.php:121                          mysqli->__construct()
  inc/dbmysql.class.php:81                           DBmysql->connect()
  plugins/ocsinventoryng/inc/dbocs.class.php:57      DBmysql->__construct()
  ...ins/ocsinventoryng/inc/ocsdbclient.class.php:53 PluginOcsinventoryngDBocs->__construct()
  ...ins/ocsinventoryng/inc/ocsserver.class.php:5243 PluginOcsinventoryngOcsDbClient->__construct()
  ...ins/ocsinventoryng/inc/ocsserver.class.php:5227 PluginOcsinventoryngOcsServer::getDBocs()
  plugins/ocsinventoryng/inc/ocsserver.class.php:133 PluginOcsinventoryngOcsServer::checkOCSconnection()
  inc/commonglpi.class.php:208                       PluginOcsinventoryngOcsServer->getTabNameForItem()
  plugins/ocsinventoryng/inc/ocsserver.class.php:197 CommonGLPI->addStandardTab()
  inc/commonglpi.class.php:158                       PluginOcsinventoryngOcsServer->defineTabs()
  ajax/updatecurrenttab.php:51                       CommonGLPI->defineAllTabs()
2017-08-08 19:36:57 [2@servername]
  *** PHP Warning(2): mysqli::__construct(): (HY000/2002): php_network_getaddresses: getaddrinfo failed: Name or service not known
  Backtrace :
  :
  inc/dbmysql.class.php:121                          mysqli->__construct()
  inc/dbmysql.class.php:81                           DBmysql->connect()
  plugins/ocsinventoryng/inc/dbocs.class.php:57      DBmysql->__construct()
  ...ins/ocsinventoryng/inc/ocsdbclient.class.php:53 PluginOcsinventoryngDBocs->__construct()
  ...ins/ocsinventoryng/inc/ocsserver.class.php:5243 PluginOcsinventoryngOcsDbClient->__construct()
  ...ins/ocsinventoryng/inc/ocsserver.class.php:5227 PluginOcsinventoryngOcsServer::getDBocs()
  plugins/ocsinventoryng/inc/ocsserver.class.php:133 PluginOcsinventoryngOcsServer::checkOCSconnection()
  inc/commonglpi.class.php:208                       PluginOcsinventoryngOcsServer->getTabNameForItem()
  plugins/ocsinventoryng/inc/ocsserver.class.php:197 CommonGLPI->addStandardTab()
  inc/commonglpi.class.php:158                       PluginOcsinventoryngOcsServer->defineTabs()
  ajax/updatecurrenttab.php:51                       CommonGLPI->defineAllTabs()
2017-08-08 19:37:18 [2@servername]
  *** PHP Warning(2): mysqli::__construct(): php_network_getaddresses: getaddrinfo failed: Name or service not known
  Backtrace :
  :
  inc/dbmysql.class.php:121                          mysqli->__construct()
  inc/dbmysql.class.php:81                           DBmysql->connect()
  plugins/ocsinventoryng/inc/dbocs.class.php:57      DBmysql->__construct()
  ...ins/ocsinventoryng/inc/ocsdbclient.class.php:53 PluginOcsinventoryngDBocs->__construct()
  ...ins/ocsinventoryng/inc/ocsserver.class.php:5243 PluginOcsinventoryngOcsDbClient->__construct()
  ...ins/ocsinventoryng/inc/ocsserver.class.php:5227 PluginOcsinventoryngOcsServer::getDBocs()
  ...ins/ocsinventoryng/inc/snmpocslink.class.php:70 PluginOcsinventoryngOcsServer::checkOCSconnection()
  inc/commonglpi.class.php:208                       PluginOcsinventoryngSnmpOcslink->getTabNameForItem()
  plugins/ocsinventoryng/inc/ocsserver.class.php:198 CommonGLPI->addStandardTab()
  inc/commonglpi.class.php:158                       PluginOcsinventoryngOcsServer->defineTabs()
  ajax/updatecurrenttab.php:51                       CommonGLPI->defineAllTabs()
2017-08-08 19:37:18 [2@servername]
  *** PHP Warning(2): mysqli::__construct(): (HY000/2002): php_network_getaddresses: getaddrinfo failed: Name or service not known
  Backtrace :
  :
  inc/dbmysql.class.php:121                          mysqli->__construct()
  inc/dbmysql.class.php:81                           DBmysql->connect()
  plugins/ocsinventoryng/inc/dbocs.class.php:57      DBmysql->__construct()
  ...ins/ocsinventoryng/inc/ocsdbclient.class.php:53 PluginOcsinventoryngDBocs->__construct()
  ...ins/ocsinventoryng/inc/ocsserver.class.php:5243 PluginOcsinventoryngOcsDbClient->__construct()
  ...ins/ocsinventoryng/inc/ocsserver.class.php:5227 PluginOcsinventoryngOcsServer::getDBocs()
  ...ins/ocsinventoryng/inc/snmpocslink.class.php:70 PluginOcsinventoryngOcsServer::checkOCSconnection()
  inc/commonglpi.class.php:208                       PluginOcsinventoryngSnmpOcslink->getTabNameForItem()
  plugins/ocsinventoryng/inc/ocsserver.class.php:198 CommonGLPI->addStandardTab()
  inc/commonglpi.class.php:158                       PluginOcsinventoryngOcsServer->defineTabs()
  ajax/updatecurrenttab.php:51                       CommonGLPI->defineAllTabs()
2017-08-08 19:37:18 [2@servername]
  *** PHP Warning(2): mysqli::__construct(): (HY000/1045): Access denied for user 'ocs_glpi'@'localhost' (using password: YES)
  Backtrace :
  :
  inc/dbmysql.class.php:112                          mysqli->__construct()
  inc/dbmysql.class.php:81                           DBmysql->connect()
  plugins/ocsinventoryng/inc/dbocs.class.php:57      DBmysql->__construct()
  ...ins/ocsinventoryng/inc/ocsdbclient.class.php:53 PluginOcsinventoryngDBocs->__construct()
  ...ins/ocsinventoryng/inc/ocsserver.class.php:5243 PluginOcsinventoryngOcsDbClient->__construct()
  ...ins/ocsinventoryng/inc/ocsserver.class.php:5227 PluginOcsinventoryngOcsServer::getDBocs()
  plugins/ocsinventoryng/inc/ocsserver.class.php:133 PluginOcsinventoryngOcsServer::checkOCSconnection()
  inc/commonglpi.class.php:208                       PluginOcsinventoryngOcsServer->getTabNameForItem()
  plugins/ocsinventoryng/inc/ocsserver.class.php:197 CommonGLPI->addStandardTab()
  inc/commonglpi.class.php:158                       PluginOcsinventoryngOcsServer->defineTabs()
  inc/commonglpi.class.php:707                       CommonGLPI->defineAllTabs()
  inc/commonglpi.class.php:1152                      CommonGLPI->showTabsContent()
  plugins/ocsinventoryng/front/ocsserver.form.php:73 CommonGLPI->display()
2017-08-08 19:37:18 [2@servername]
  *** PHP Warning(2): mysqli::__construct(): (HY000/1045): Access denied for user 'ocs_glpi'@'localhost' (using password: YES)
  Backtrace :
  :
  inc/dbmysql.class.php:112                          mysqli->__construct()
  inc/dbmysql.class.php:81                           DBmysql->connect()
  plugins/ocsinventoryng/inc/dbocs.class.php:57      DBmysql->__construct()
  ...ins/ocsinventoryng/inc/ocsdbclient.class.php:53 PluginOcsinventoryngDBocs->__construct()
  ...ins/ocsinventoryng/inc/ocsserver.class.php:5243 PluginOcsinventoryngOcsDbClient->__construct()
  ...ins/ocsinventoryng/inc/ocsserver.class.php:5227 PluginOcsinventoryngOcsServer::getDBocs()
  ...ins/ocsinventoryng/inc/snmpocslink.class.php:70 PluginOcsinventoryngOcsServer::checkOCSconnection()
  inc/commonglpi.class.php:208                       PluginOcsinventoryngSnmpOcslink->getTabNameForItem()
  plugins/ocsinventoryng/inc/ocsserver.class.php:198 CommonGLPI->addStandardTab()
  inc/commonglpi.class.php:158                       PluginOcsinventoryngOcsServer->defineTabs()
  inc/commonglpi.class.php:707                       CommonGLPI->defineAllTabs()
  inc/commonglpi.class.php:1152                      CommonGLPI->showTabsContent()
  plugins/ocsinventoryng/front/ocsserver.form.php:73 CommonGLPI->display()
2017-08-08 19:37:18 [2@servername]
  *** PHP Warning(2): mysqli::__construct(): (HY000/1045): Access denied for user 'ocs_glpi'@'localhost' (using password: YES)
  Backtrace :
  :
  inc/dbmysql.class.php:112                          mysqli->__construct()
  inc/dbmysql.class.php:81                           DBmysql->connect()
  plugins/ocsinventoryng/inc/dbocs.class.php:57      DBmysql->__construct()
  ...ins/ocsinventoryng/inc/ocsdbclient.class.php:53 PluginOcsinventoryngDBocs->__construct()
  ...ins/ocsinventoryng/inc/ocsserver.class.php:5243 PluginOcsinventoryngOcsDbClient->__construct()
  ...ins/ocsinventoryng/inc/ocsserver.class.php:5227 PluginOcsinventoryngOcsServer::getDBocs()
  plugins/ocsinventoryng/inc/ocsserver.class.php:133 PluginOcsinventoryngOcsServer::checkOCSconnection()
  inc/commonglpi.class.php:208                       PluginOcsinventoryngOcsServer->getTabNameForItem()
  plugins/ocsinventoryng/inc/ocsserver.class.php:197 CommonGLPI->addStandardTab()
  inc/commonglpi.class.php:158                       PluginOcsinventoryngOcsServer->defineTabs()
  ajax/updatecurrenttab.php:51                       CommonGLPI->defineAllTabs()
2017-08-08 19:37:18 [2@servername]
  *** PHP Warning(2): mysqli::__construct(): (HY000/1045): Access denied for user 'ocs_glpi'@'localhost' (using password: YES)
  Backtrace :
  :
  inc/dbmysql.class.php:112                          mysqli->__construct()
  inc/dbmysql.class.php:81                           DBmysql->connect()
  plugins/ocsinventoryng/inc/dbocs.class.php:57      DBmysql->__construct()
  ...ins/ocsinventoryng/inc/ocsdbclient.class.php:53 PluginOcsinventoryngDBocs->__construct()
  ...ins/ocsinventoryng/inc/ocsserver.class.php:5243 PluginOcsinventoryngOcsDbClient->__construct()
  ...ins/ocsinventoryng/inc/ocsserver.class.php:5227 PluginOcsinventoryngOcsServer::getDBocs()
  ...ins/ocsinventoryng/inc/snmpocslink.class.php:70 PluginOcsinventoryngOcsServer::checkOCSconnection()
  inc/commonglpi.class.php:208                       PluginOcsinventoryngSnmpOcslink->getTabNameForItem()
  plugins/ocsinventoryng/inc/ocsserver.class.php:198 CommonGLPI->addStandardTab()
  inc/commonglpi.class.php:158                       PluginOcsinventoryngOcsServer->defineTabs()
  ajax/updatecurrenttab.php:51                       CommonGLPI->defineAllTabs()
2017-08-08 19:37:24 [2@servername]
  *** PHP Warning(2): mysqli::__construct(): (HY000/1045): Access denied for user 'ocs_glpi'@'localhost' (using password: YES)
  Backtrace :
  :
  inc/dbmysql.class.php:112                          mysqli->__construct()
  inc/dbmysql.class.php:81                           DBmysql->connect()
  plugins/ocsinventoryng/inc/dbocs.class.php:57      DBmysql->__construct()
  ...ins/ocsinventoryng/inc/ocsdbclient.class.php:53 PluginOcsinventoryngDBocs->__construct()
  ...ins/ocsinventoryng/inc/ocsserver.class.php:5243 PluginOcsinventoryngOcsDbClient->__construct()
  ...ins/ocsinventoryng/inc/ocsserver.class.php:5227 PluginOcsinventoryngOcsServer::getDBocs()
  ...ins/ocsinventoryng/inc/ocsserver.class.php:1376 PluginOcsinventoryngOcsServer::checkOCSconnection()
  plugins/ocsinventoryng/inc/ocsserver.class.php:165 PluginOcsinventoryngOcsServer->showDBConnectionStatus()
  inc/commonglpi.class.php:483                       PluginOcsinventoryngOcsServer::displayTabContentForItem()
  ajax/common.tabs.php:97                            CommonGLPI::displayStandardTab()
2017-08-08 19:37:24 [2@servername]
  *** PHP Warning(2): mysqli::__construct(): (HY000/1045): Access denied for user 'ocs_glpi'@'localhost' (using password: YES)
  Backtrace :
  :
  inc/dbmysql.class.php:112                          mysqli->__construct()
  inc/dbmysql.class.php:81                           DBmysql->connect()
  plugins/ocsinventoryng/inc/dbocs.class.php:57      DBmysql->__construct()
  ...ins/ocsinventoryng/inc/ocsdbclient.class.php:53 PluginOcsinventoryngDBocs->__construct()
  ...ins/ocsinventoryng/inc/ocsserver.class.php:5243 PluginOcsinventoryngOcsDbClient->__construct()
  ...ins/ocsinventoryng/inc/ocsserver.class.php:5227 PluginOcsinventoryngOcsServer::getDBocs()
  plugins/ocsinventoryng/inc/ocsserver.class.php:133 PluginOcsinventoryngOcsServer::checkOCSconnection()
  inc/commonglpi.class.php:208                       PluginOcsinventoryngOcsServer->getTabNameForItem()
  plugins/ocsinventoryng/inc/ocsserver.class.php:197 CommonGLPI->addStandardTab()
  inc/commonglpi.class.php:158                       PluginOcsinventoryngOcsServer->defineTabs()
  ajax/updatecurrenttab.php:51                       CommonGLPI->defineAllTabs()
2017-08-08 19:37:24 [2@servername]
  *** PHP Warning(2): mysqli::__construct(): (HY000/1045): Access denied for user 'ocs_glpi'@'localhost' (using password: YES)
  Backtrace :
  :
  inc/dbmysql.class.php:112                          mysqli->__construct()
  inc/dbmysql.class.php:81                           DBmysql->connect()
  plugins/ocsinventoryng/inc/dbocs.class.php:57      DBmysql->__construct()
  ...ins/ocsinventoryng/inc/ocsdbclient.class.php:53 PluginOcsinventoryngDBocs->__construct()
  ...ins/ocsinventoryng/inc/ocsserver.class.php:5243 PluginOcsinventoryngOcsDbClient->__construct()
  ...ins/ocsinventoryng/inc/ocsserver.class.php:5227 PluginOcsinventoryngOcsServer::getDBocs()
  ...ins/ocsinventoryng/inc/snmpocslink.class.php:70 PluginOcsinventoryngOcsServer::checkOCSconnection()
  inc/commonglpi.class.php:208                       PluginOcsinventoryngSnmpOcslink->getTabNameForItem()
  plugins/ocsinventoryng/inc/ocsserver.class.php:198 CommonGLPI->addStandardTab()
  inc/commonglpi.class.php:158                       PluginOcsinventoryngOcsServer->defineTabs()
  ajax/updatecurrenttab.php:51                       CommonGLPI->defineAllTabs()
2017-08-08 19:37:25 [2@servername]
  *** PHP Warning(2): mysqli::__construct(): (HY000/1045): Access denied for user 'ocs_glpi'@'localhost' (using password: YES)
  Backtrace :
  :
  inc/dbmysql.class.php:112                          mysqli->__construct()
  inc/dbmysql.class.php:81                           DBmysql->connect()
  plugins/ocsinventoryng/inc/dbocs.class.php:57      DBmysql->__construct()
  ...ins/ocsinventoryng/inc/ocsdbclient.class.php:53 PluginOcsinventoryngDBocs->__construct()
  ...ins/ocsinventoryng/inc/ocsserver.class.php:5243 PluginOcsinventoryngOcsDbClient->__construct()
  ...ins/ocsinventoryng/inc/ocsserver.class.php:5227 PluginOcsinventoryngOcsServer::getDBocs()
  plugins/ocsinventoryng/inc/ocsserver.class.php:133 PluginOcsinventoryngOcsServer::checkOCSconnection()
  inc/commonglpi.class.php:208                       PluginOcsinventoryngOcsServer->getTabNameForItem()
  plugins/ocsinventoryng/inc/ocsserver.class.php:197 CommonGLPI->addStandardTab()
  inc/commonglpi.class.php:158                       PluginOcsinventoryngOcsServer->defineTabs()
  ajax/updatecurrenttab.php:51                       CommonGLPI->defineAllTabs()
2017-08-08 19:37:25 [2@servername]
  *** PHP Warning(2): mysqli::__construct(): (HY000/1045): Access denied for user 'ocs_glpi'@'localhost' (using password: YES)
  Backtrace :
  :
  inc/dbmysql.class.php:112                          mysqli->__construct()
  inc/dbmysql.class.php:81                           DBmysql->connect()
  plugins/ocsinventoryng/inc/dbocs.class.php:57      DBmysql->__construct()
  ...ins/ocsinventoryng/inc/ocsdbclient.class.php:53 PluginOcsinventoryngDBocs->__construct()
  ...ins/ocsinventoryng/inc/ocsserver.class.php:5243 PluginOcsinventoryngOcsDbClient->__construct()
  ...ins/ocsinventoryng/inc/ocsserver.class.php:5227 PluginOcsinventoryngOcsServer::getDBocs()
  ...ins/ocsinventoryng/inc/snmpocslink.class.php:70 PluginOcsinventoryngOcsServer::checkOCSconnection()
  inc/commonglpi.class.php:208                       PluginOcsinventoryngSnmpOcslink->getTabNameForItem()
  plugins/ocsinventoryng/inc/ocsserver.class.php:198 CommonGLPI->addStandardTab()
  inc/commonglpi.class.php:158                       PluginOcsinventoryngOcsServer->defineTabs()
  ajax/updatecurrenttab.php:51                       CommonGLPI->defineAllTabs()
2017-08-08 19:38:27 [2@servername]
  *** PHP Warning(2): mysqli::__construct(): (HY000/1045): Access denied for user 'ocs_glpi'@'localhost' (using password: YES)
  Backtrace :
  :
  inc/dbmysql.class.php:112                          mysqli->__construct()
  inc/dbmysql.class.php:81                           DBmysql->connect()
  plugins/ocsinventoryng/inc/dbocs.class.php:57      DBmysql->__construct()
  ...ins/ocsinventoryng/inc/ocsdbclient.class.php:53 PluginOcsinventoryngDBocs->__construct()
  ...ins/ocsinventoryng/inc/ocsserver.class.php:5243 PluginOcsinventoryngOcsDbClient->__construct()
  ...ins/ocsinventoryng/inc/ocsserver.class.php:5227 PluginOcsinventoryngOcsServer::getDBocs()
  plugins/ocsinventoryng/inc/ocsserver.class.php:133 PluginOcsinventoryngOcsServer::checkOCSconnection()
  inc/commonglpi.class.php:208                       PluginOcsinventoryngOcsServer->getTabNameForItem()
  plugins/ocsinventoryng/inc/ocsserver.class.php:197 CommonGLPI->addStandardTab()
  inc/commonglpi.class.php:158                       PluginOcsinventoryngOcsServer->defineTabs()
  inc/commonglpi.class.php:707                       CommonGLPI->defineAllTabs()
  inc/commonglpi.class.php:1152                      CommonGLPI->showTabsContent()
  plugins/ocsinventoryng/front/ocsserver.form.php:73 CommonGLPI->display()
2017-08-08 19:38:27 [2@servername]
  *** PHP Warning(2): mysqli::__construct(): (HY000/1045): Access denied for user 'ocs_glpi'@'localhost' (using password: YES)
  Backtrace :
  :
  inc/dbmysql.class.php:112                          mysqli->__construct()
  inc/dbmysql.class.php:81                           DBmysql->connect()
  plugins/ocsinventoryng/inc/dbocs.class.php:57      DBmysql->__construct()
  ...ins/ocsinventoryng/inc/ocsdbclient.class.php:53 PluginOcsinventoryngDBocs->__construct()
  ...ins/ocsinventoryng/inc/ocsserver.class.php:5243 PluginOcsinventoryngOcsDbClient->__construct()
  ...ins/ocsinventoryng/inc/ocsserver.class.php:5227 PluginOcsinventoryngOcsServer::getDBocs()
  ...ins/ocsinventoryng/inc/snmpocslink.class.php:70 PluginOcsinventoryngOcsServer::checkOCSconnection()
  inc/commonglpi.class.php:208                       PluginOcsinventoryngSnmpOcslink->getTabNameForItem()
  plugins/ocsinventoryng/inc/ocsserver.class.php:198 CommonGLPI->addStandardTab()
  inc/commonglpi.class.php:158                       PluginOcsinventoryngOcsServer->defineTabs()
  inc/commonglpi.class.php:707                       CommonGLPI->defineAllTabs()
  inc/commonglpi.class.php:1152                      CommonGLPI->showTabsContent()
  plugins/ocsinventoryng/front/ocsserver.form.php:73 CommonGLPI->display()
2017-08-08 19:38:27 [2@servername]
  *** PHP Warning(2): mysqli::__construct(): (HY000/1045): Access denied for user 'ocs_glpi'@'localhost' (using password: YES)
  Backtrace :
  :
  inc/dbmysql.class.php:112                          mysqli->__construct()
  inc/dbmysql.class.php:81                           DBmysql->connect()
  plugins/ocsinventoryng/inc/dbocs.class.php:57      DBmysql->__construct()
  ...ins/ocsinventoryng/inc/ocsdbclient.class.php:53 PluginOcsinventoryngDBocs->__construct()
  ...ins/ocsinventoryng/inc/ocsserver.class.php:5243 PluginOcsinventoryngOcsDbClient->__construct()
  ...ins/ocsinventoryng/inc/ocsserver.class.php:5227 PluginOcsinventoryngOcsServer::getDBocs()
  plugins/ocsinventoryng/inc/ocsserver.class.php:133 PluginOcsinventoryngOcsServer::checkOCSconnection()
  inc/commonglpi.class.php:208                       PluginOcsinventoryngOcsServer->getTabNameForItem()
  plugins/ocsinventoryng/inc/ocsserver.class.php:197 CommonGLPI->addStandardTab()
  inc/commonglpi.class.php:158                       PluginOcsinventoryngOcsServer->defineTabs()
  ajax/updatecurrenttab.php:51                       CommonGLPI->defineAllTabs()
2017-08-08 19:38:27 [2@servername]
  *** PHP Warning(2): mysqli::__construct(): (HY000/1045): Access denied for user 'ocs_glpi'@'localhost' (using password: YES)
  Backtrace :
  :
  inc/dbmysql.class.php:112                          mysqli->__construct()
  inc/dbmysql.class.php:81                           DBmysql->connect()
  plugins/ocsinventoryng/inc/dbocs.class.php:57      DBmysql->__construct()
  ...ins/ocsinventoryng/inc/ocsdbclient.class.php:53 PluginOcsinventoryngDBocs->__construct()
  ...ins/ocsinventoryng/inc/ocsserver.class.php:5243 PluginOcsinventoryngOcsDbClient->__construct()
  ...ins/ocsinventoryng/inc/ocsserver.class.php:5227 PluginOcsinventoryngOcsServer::getDBocs()
  ...ins/ocsinventoryng/inc/snmpocslink.class.php:70 PluginOcsinventoryngOcsServer::checkOCSconnection()
  inc/commonglpi.class.php:208                       PluginOcsinventoryngSnmpOcslink->getTabNameForItem()
  plugins/ocsinventoryng/inc/ocsserver.class.php:198 CommonGLPI->addStandardTab()
  inc/commonglpi.class.php:158                       PluginOcsinventoryngOcsServer->defineTabs()
  ajax/updatecurrenttab.php:51                       CommonGLPI->defineAllTabs()
2017-08-08 19:38:29 [2@servername]
  *** PHP Warning(2): mysqli::__construct(): (HY000/1045): Access denied for user 'ocs_glpi'@'localhost' (using password: YES)
  Backtrace :
  :
  inc/dbmysql.class.php:112                          mysqli->__construct()
  inc/dbmysql.class.php:81                           DBmysql->connect()
  plugins/ocsinventoryng/inc/dbocs.class.php:57      DBmysql->__construct()
  ...ins/ocsinventoryng/inc/ocsdbclient.class.php:53 PluginOcsinventoryngDBocs->__construct()
  ...ins/ocsinventoryng/inc/ocsserver.class.php:5243 PluginOcsinventoryngOcsDbClient->__construct()
  ...ins/ocsinventoryng/inc/ocsserver.class.php:5227 PluginOcsinventoryngOcsServer::getDBocs()
  ...ins/ocsinventoryng/inc/ocsserver.class.php:1376 PluginOcsinventoryngOcsServer::checkOCSconnection()
  plugins/ocsinventoryng/inc/ocsserver.class.php:165 PluginOcsinventoryngOcsServer->showDBConnectionStatus()
  inc/commonglpi.class.php:483                       PluginOcsinventoryngOcsServer::displayTabContentForItem()
  ajax/common.tabs.php:97                            CommonGLPI::displayStandardTab()
2017-08-08 19:38:29 [2@servername]
  *** PHP Warning(2): mysqli::__construct(): (HY000/1045): Access denied for user 'ocs_glpi'@'localhost' (using password: YES)
  Backtrace :
  :
  inc/dbmysql.class.php:112                          mysqli->__construct()
  inc/dbmysql.class.php:81                           DBmysql->connect()
  plugins/ocsinventoryng/inc/dbocs.class.php:57      DBmysql->__construct()
  ...ins/ocsinventoryng/inc/ocsdbclient.class.php:53 PluginOcsinventoryngDBocs->__construct()
  ...ins/ocsinventoryng/inc/ocsserver.class.php:5243 PluginOcsinventoryngOcsDbClient->__construct()
  ...ins/ocsinventoryng/inc/ocsserver.class.php:5227 PluginOcsinventoryngOcsServer::getDBocs()
  plugins/ocsinventoryng/inc/ocsserver.class.php:133 PluginOcsinventoryngOcsServer::checkOCSconnection()
  inc/commonglpi.class.php:208                       PluginOcsinventoryngOcsServer->getTabNameForItem()
  plugins/ocsinventoryng/inc/ocsserver.class.php:197 CommonGLPI->addStandardTab()
  inc/commonglpi.class.php:158                       PluginOcsinventoryngOcsServer->defineTabs()
  ajax/updatecurrenttab.php:51                       CommonGLPI->defineAllTabs()
2017-08-08 19:38:29 [2@servername]
  *** PHP Warning(2): mysqli::__construct(): (HY000/1045): Access denied for user 'ocs_glpi'@'localhost' (using password: YES)
  Backtrace :
  :
  inc/dbmysql.class.php:112                          mysqli->__construct()
  inc/dbmysql.class.php:81                           DBmysql->connect()
  plugins/ocsinventoryng/inc/dbocs.class.php:57      DBmysql->__construct()
  ...ins/ocsinventoryng/inc/ocsdbclient.class.php:53 PluginOcsinventoryngDBocs->__construct()
  ...ins/ocsinventoryng/inc/ocsserver.class.php:5243 PluginOcsinventoryngOcsDbClient->__construct()
  ...ins/ocsinventoryng/inc/ocsserver.class.php:5227 PluginOcsinventoryngOcsServer::getDBocs()
  ...ins/ocsinventoryng/inc/snmpocslink.class.php:70 PluginOcsinventoryngOcsServer::checkOCSconnection()
  inc/commonglpi.class.php:208                       PluginOcsinventoryngSnmpOcslink->getTabNameForItem()
  plugins/ocsinventoryng/inc/ocsserver.class.php:198 CommonGLPI->addStandardTab()
  inc/commonglpi.class.php:158                       PluginOcsinventoryngOcsServer->defineTabs()
  ajax/updatecurrenttab.php:51                       CommonGLPI->defineAllTabs()
2017-08-08 19:39:01 [@servername]
  *** PHP Warning(2): mysqli::__construct(): (HY000/1045): Access denied for user 'ocs_glpi'@'localhost' (using password: YES)
  Backtrace :
  :
  inc/dbmysql.class.php:112                          mysqli->__construct()
  inc/dbmysql.class.php:81                           DBmysql->connect()
  plugins/ocsinventoryng/inc/dbocs.class.php:57      DBmysql->__construct()
  ...ins/ocsinventoryng/inc/ocsdbclient.class.php:53 PluginOcsinventoryngDBocs->__construct()
  ...ins/ocsinventoryng/inc/ocsserver.class.php:5243 PluginOcsinventoryngOcsDbClient->__construct()
  ...ins/ocsinventoryng/inc/ocsserver.class.php:6876 PluginOcsinventoryngOcsServer::getDBocs()
  inc/crontask.class.php:832                         PluginOcsinventoryngOcsServer::cronocsng()
  front/cron.php:88                                  CronTask::launch()
2017-08-08 19:39:01 [@servername]
  *** PHP Warning(2): mysqli::__construct(): (HY000/1045): Access denied for user 'ocs_glpi'@'localhost' (using password: YES)
  Backtrace :
  :
  inc/dbmysql.class.php:112                          mysqli->__construct()
  inc/dbmysql.class.php:81                           DBmysql->connect()
  plugins/ocsinventoryng/inc/dbocs.class.php:57      DBmysql->__construct()
  ...ins/ocsinventoryng/inc/ocsdbclient.class.php:53 PluginOcsinventoryngDBocs->__construct()
  ...ins/ocsinventoryng/inc/ocsserver.class.php:5243 PluginOcsinventoryngOcsDbClient->__construct()
  ...ins/ocsinventoryng/inc/ocsserver.class.php:5227 PluginOcsinventoryngOcsServer::getDBocs()
  ...ins/ocsinventoryng/inc/ocsserver.class.php:2120 PluginOcsinventoryngOcsServer::checkOCSconnection()
  ...ins/ocsinventoryng/inc/ocsserver.class.php:6884 PluginOcsinventoryngOcsServer::manageDeleted()
  inc/crontask.class.php:832                         PluginOcsinventoryngOcsServer::cronocsng()
  front/cron.php:88                                  CronTask::launch()
2017-08-08 19:39:01 [@servername]
  *** PHP Warning(2): mysqli::query(): Couldn't fetch mysqli
  Backtrace :
  :
  inc/dbmysql.class.php:171                          mysqli->query()
  ...s/ocsinventoryng/inc/ocsdbclient.class.php:1070 DBmysql->query()
  ...ins/ocsinventoryng/inc/ocsserver.class.php:6896 PluginOcsinventoryngOcsDbClient->getComputersToUpdate()
  inc/crontask.class.php:832                         PluginOcsinventoryngOcsServer::cronocsng()
  front/cron.php:88                                  CronTask::launch()
2017-08-08 19:39:01 [@servername]
  *** PHP Warning(2): DBmysql::query(): Couldn't fetch mysqli
  Backtrace :
  inc/dbmysql.class.php:175
  ...s/ocsinventoryng/inc/ocsdbclient.class.php:1070 DBmysql->query()
  ...ins/ocsinventoryng/inc/ocsserver.class.php:6896 PluginOcsinventoryngOcsDbClient->getComputersToUpdate()
  inc/crontask.class.php:832                         PluginOcsinventoryngOcsServer::cronocsng()
  front/cron.php:88                                  CronTask::launch()
2017-08-08 19:39:01 [@servername]
  *** PHP Notice(8): Trying to get property of non-object
  Backtrace :
  ...s/ocsinventoryng/inc/ocsdbclient.class.php:1073
  ...ins/ocsinventoryng/inc/ocsserver.class.php:6896 PluginOcsinventoryngOcsDbClient->getComputersToUpdate()
  inc/crontask.class.php:832                         PluginOcsinventoryngOcsServer::cronocsng()
  front/cron.php:88                                  CronTask::launch()

Offline

#2 2017-08-09 15:14:01

yllen
GLPI-DEV
From: Sillery (51)
Registered: 2008-01-14
Posts: 15,273

Re: Plugin ocsinventoryng for GLPI - Connection to the database failed

Have you write password as asked?
Can you directly connect to OCS database with user ocs_glpi user and the password?


CentOS 6.5 - CentOS 7.x
PHP 5.6 - PHP 7.x - MySQL 5.6  - MariaDB 10.2 + APC + oOPcache
GLPI from 0.72 to dev version
Certifiée ITIL (ITV2F, ITILF, ITILOSA)

Offline

#3 2017-08-09 15:34:57

jmoran
Member
Registered: 2017-08-08
Posts: 11

Re: Plugin ocsinventoryng for GLPI - Connection to the database failed

Yes, I can connnect to the Database via the command line in a Bash Shell. Yes, I am typing the password correctly.

yllen wrote:

Have you write password as asked?
Can you directly connect to OCS database with user ocs_glpi user and the password?

Offline

#4 2017-08-11 15:27:49

jmoran
Member
Registered: 2017-08-08
Posts: 11

Re: Plugin ocsinventoryng for GLPI - Connection to the database failed

Does anyone have any suggestions on how to resolve the Plugin ocsinventoryng for GLPI Connection to the database failed issue?

Offline

#5 2017-08-11 15:35:27

grajek
Member
Registered: 2015-03-16
Posts: 72

Re: Plugin ocsinventoryng for GLPI - Connection to the database failed

This is probably due to default MySql configuration behaviour not accepting remote connections. Check this article:
http://www.debianhelp.co.uk/remotemysql.htm


GLPI 9.5.1 CentOS

Offline

#6 2017-08-11 20:20:37

jmoran
Member
Registered: 2017-08-08
Posts: 11

Re: Plugin ocsinventoryng for GLPI - Connection to the database failed

Thanks grajek ... I tried the details from your link with no success.

Connecting using the following methods all work:
mysql -u ocs_glpi -p -h 192.168.3.72 ocsweb - Success
mysql -u ocs_glpi -p -h localhost ocsweb - Success
From my Windows workstation using MySQL Workbench configured to the Server's IP using Standard IP and Port 3306 also works.

In GLPI I am using:
Host: localhost    (I have tried the external IP as well)
Database: ocsweb
User: ocs_glpi

grajek wrote:

This is probably due to default MySql configuration behaviour not accepting remote connections. Check this article:
http://www.debianhelp.co.uk/remotemysql.htm

Offline

#7 2017-08-15 19:23:47

jmoran
Member
Registered: 2017-08-08
Posts: 11

Re: Plugin ocsinventoryng for GLPI - Connection to the database failed

Does anyone have any suggestions on how to resolve the Plugin ocsinventoryng for GLPI Connection to the database failed issue? I can connect to MYSQLandthe DB using the username and password using several methods.

Offline

#8 2017-08-16 09:32:31

yllen
GLPI-DEV
From: Sillery (51)
Registered: 2008-01-14
Posts: 15,273

Re: Plugin ocsinventoryng for GLPI - Connection to the database failed

The mysql error is clear : Access denied for user 'ocs_glpi'@'localhost'
In GLPI, have you write password in ocsinventory configuration? have you activate the config?


CentOS 6.5 - CentOS 7.x
PHP 5.6 - PHP 7.x - MySQL 5.6  - MariaDB 10.2 + APC + oOPcache
GLPI from 0.72 to dev version
Certifiée ITIL (ITV2F, ITILF, ITILOSA)

Offline

#9 2017-08-16 16:57:01

jmoran
Member
Registered: 2017-08-08
Posts: 11

Re: Plugin ocsinventoryng for GLPI - Connection to the database failed

Hello ... Yes I agree the error is clear and I have made the Plugin's Configuration active. The password I am using in the configuration is the same password I am using from the command line and from my workstation when testing the connection to the mysql db remotely.

yllen wrote:

The mysql error is clear : Access denied for user 'ocs_glpi'@'localhost'
In GLPI, have you write password in ocsinventory configuration? have you activate the config?

Last edited by jmoran (2017-08-16 16:58:32)

Offline

#10 2022-01-24 14:31:32

mcsoto
Member
Registered: 2019-09-06
Posts: 14

Re: Plugin ocsinventoryng for GLPI - Connection to the database failed

I am with the same problem now. I can connect with the same credentials that I use remotely without problems but I can't get the extension to connect to the database

Offline

Board footer

Powered by FluxBB