I am new to this forum and to using OCS Inventory. I did not perform the installation myself and I am using a Ubuntu 22.04 virtual machine with this service.
Nom du système : Linux x86_64
Version : 5.15.0-87-generic
RAM totale :1898 Mo
RAM disponible :623 Mo
CPU : Intel(R) Xeon(R) E-2314 CPU @ 2.80GHz
Distribution :Ubuntu 22.04.3 LTS
Version de PHP : 8.1.2
Serveur Web : Apache/2.4.52 (Ubuntu)
Serveur SQL : Ubuntu 22.04 version 10.6.12-MariaDB-0ubuntu0.22.04.1
When I arrived, the service was not fully functional.
Remounting it on the server using the agents installed on the machines in the park properly brought back the computers with their information and installed software.
However, the homepage was completely blank with only the top banner, and the software part of the park was empty.
I did some research and came across the following link: https://ask.ocsinventory-ng.org/14287/all-software-tab-empty-in-ocs-inventory-server?show=14287#q14287
Having exactly the same problem as this gentleman, I followed the steps to add the 'software_link' table to my database. For the creation, I referred to the GitHub link below: https://github.com/OCSInventory-NG/OCSInventory-ocsreports/blob/master/files/ocsbase_new.sql
DROP TABLE IF EXISTS `software_link`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!50503 SET character_set_client = utf8mb4 */;
CREATE TABLE `software_link` (
`ID` bigint NOT NULL AUTO_INCREMENT,
`NAME_ID` int NOT NULL,
`PUBLISHER_ID` int NOT NULL,
`VERSION_ID` int NOT NULL,
`CATEGORY_ID` int DEFAULT NULL,
`IDENTIFIER` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL,
`COUNT` int DEFAULT NULL,
PRIMARY KEY (`ID`),
KEY `NAME_ID` (`NAME_ID`),
KEY `PUBLISHER_ID` (`PUBLISHER_ID`),
KEY `VERSION_ID` (`VERSION_ID`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3;
/*!40101 SET character_set_client = @saved_cs_client */;
-- Dumping data for table `software_link`
LOCK TABLES `software_link` WRITE;
/*!40000 ALTER TABLE `software_link` DISABLE KEYS */;
/*!40000 ALTER TABLE `software_link` ENABLE KEYS */;
This did not have the desired effect; I did not retrieve the 'all_software' functionality, but the dashboards on the homepage appeared.
So, in a moment of madness, I copied the entire GitHub content into my database.
I suspect this reset the database. At least I started afresh.
The only issue now is that I would like the agents to report the data again, but nothing seems to be happening. Do you think I can retrieve anything from this virtual machine, or should I reload my backup?
Thank you to those who are willing to help.