Welcome to OCS Inventory NG community support, where you can ask questions and receive answers from other members of the community.

Please ask questions only in English or French.

Release 2.12.3 available

The official documentation can be found on https://wiki.ocsinventory-ng.org. Read it before asking your question.

OCS Server and Ocs Reports version for MySQL v8

Hello,

I want to know the versions of OCS Inv. Server and OCS Inv. Reports, it is compatible with MySQL v8.

Thanks.
in OCS Inventory NG server for Unix by (350 points)

4 Answers

0 votes

Hi,

Yes, my installation works well with MySQL v8, just becarefull with authentification configuration in MySQL v8. In my case with Debian, i ve follow this tutorial, sorry in french...i'm french user ^^

link

Regards

by (5.7k points)
0 votes
First thanks for your reply!

My question is about what version of OCS reports and server are compatible with Mysql v8
by (350 points)
0 votes
sorry, i don't known for all version, in my case OCS V2.8.1 + MySQL v8 (server upgraded with all intermediate version from OCS v 2.1 under Windows only for upgrade BDD, finaly only use v2.8.1 in production)
by (5.7k points)
0 votes

I encountered a similar issue while setting up OCS Inventory NG Server and OCS Reports with MySQL v8, and I wanted to share my experience in case it helps others.

Problem:

I needed to know which versions of OCS Inventory Server and OCS Reports were compatible with MySQL v8. After some research and trial and error, I found that the installation works well with MySQL v8, but there are some important things to keep in mind, especially related to authentication configuration in MySQL v8.

Solution:

  1. MySQL v8 Compatibility: Both OCS Inventory Server and OCS Reports work perfectly with MySQL v8, but there are a few specific configurations that need to be addressed for smooth operation, especially related to authentication. By default, MySQL v8 uses caching_sha2_password as the authentication method, which can cause issues when connecting older clients like the OCS Inventory Server.

  2. Authentication Configuration:

    • In my case, I had to ensure that MySQL v8 was configured to use mysql_native_password for user authentication to make it compatible with OCS Inventory Server.
    • This can be done by running the following MySQL command:
    ALTER USER 'root'@'localhost' IDENTIFIED WITH mysql_native_password BY 'yourpassword';
    
    • This command switches the root user's authentication to the older mysql_native_password method, which works better with legacy applications like OCS.
  3. Debian Setup: I followed a Debian tutorial (in French) that guided me through the steps of installing MySQL v8 and configuring it for compatibility with OCS Inventory. If you're using a similar system, I would highly recommend checking out the tutorial for further details on installation and configuration

  4. Vultr’s Documentation Help: For those using Vultr as their cloud provider, I also found their detailed documentation very helpful. The guide on how to install MySQL on Ubuntu and configure it properly for applications like OCS Inventory is comprehensive and can save a lot of time during setup.

Conclusion:

By ensuring proper authentication configuration in MySQL v8 and following the steps provided in the tutorials and documentation, I was able to successfully get OCS Inventory NG Server and OCS Reports running with MySQL v8 on my system.

I hope this helps others who are facing similar compatibility issues between OCS Inventory and MySQL v8!

ago by (260 points)
 
Powered by Question2Answer
...