OCS Server and Ocs Reports version for MySQL v8

Question

Hello,

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

Thanks.

Answer 1

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

Answer 2

First thanks for your reply!

My question is about what version of OCS reports and server are compatible with Mysql v8

Answer 3

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)

Answer 4

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.

   • For more helpful information, I recommend checking out the Vultr MySQL Installation Guide for Ubuntu: Complete MySQL Setup Tutorial for Ubuntu 20.04

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!