Forum GLPI-Project

Calej

Member

Registered: 2021-04-12

Posts: 3

Connection problems between GLPI and OCS Inventory

Good morning everyone!

I have GLPI 9.5.4 installed on-premises and I have installed the OCS Inventory plugins, which is also installed on-premises.

Well, the problem comes when trying to connect to the OCS database. I enter the OCS IP address and the DB and user data, and I get a connection failure in the Test section.

When I use debug mode and try to connect to the db in OCS Inventory the following Warning is displayed

PHP Warning (2): mysqli::real_connect(): (HY000/2002): Connection refused in /var/www/glpi/inc/dbmysql.class.php at line 185
PHP Warning (2): mysqli::real_connect(): (HY000/2002): Connection refused in /var/www/glpi/inc/dbmysql.class.php at line 185

nimek20

Member

Registered: 2018-07-03

Posts: 14

Re: Connection problems between GLPI and OCS Inventory

I have a similar problem.

GLPI: 9.5.5 (Windows)
OCS 2.9 (Ubuntu)

Warning: mysqli :: real_connect (): The server requested authentication method unknown to the client [caching_sha2_password] in C: \ xampp \ htdocs \ glpi \ inc \ dbmysql.class.php on line 185

Warning: mysqli :: real_connect (): (HY000 / 2054): The server requested authentication method unknown to the client in C: \ xampp \ htdocs \ glpi \ inc \ dbmysql.class.php on line 185

Warning: mysqli :: real_connect (): The server requested authentication method unknown to the client [caching_sha2_password] in C: \ xampp \ htdocs \ glpi \ inc \ dbmysql.class.php on line 185

Warning: mysqli :: real_connect (): (HY000 / 2054): The server requested authentication method unknown to the client in C: \ xampp \ htdocs \ glpi \ inc \ dbmysql.class.php on line 185

Please help.

nimek20

Member

Registered: 2018-07-03

Posts: 14

Re: Connection problems between GLPI and OCS Inventory

Problem with OCS Inventory NG (GPLv2+ 1.7.3)

I have disabled the plug and there are no problems.

oj69

Member

From: Somewhere in the cloud

Registered: 2021-02-01

Posts: 157

Re: Connection problems between GLPI and OCS Inventory

why not using fusioninventory with GLPI ?

nimek20

Member

Registered: 2018-07-03

Posts: 14

Re: Connection problems between GLPI and OCS Inventory

I use the advantages of Fusion and OCS. There are differences in the plugins and the data that can be downloaded from devices. OCS finds more devices than Fusion.

nimek20

Member

Registered: 2018-07-03

Posts: 14

Re: Connection problems between GLPI and OCS Inventory

Problem solved.

https://stackoverflow.com/questions/523 … unknown-to

Edit my.cnf file on OCS Inventory server and put this setting in mysqld section:

[mysqld]
default_authentication_plugin= mysql_native_password

Then run following in mysql command:

FLUSH PRIVILEGES;

sudo /etc/init.d/mysql stop
sudo /etc/init.d/mysql start

and done!