Hello,
I have the same issue. Mysql user/paswd/database are correct in /etc/apache2/sites-enabled/z-ocsinventory-server.conf & in /usr/share/ocsinventory-reports/ocsreports/dbconfig.inc.php.
However, when browsing the database structure, I did not come across a table 'operator'.
I included it like so:
CREATE TABLE `operators` (
`ID` varchar(255) NOT NULL DEFAULT '',
`FIRSTNAME` varchar(255) DEFAULT NULL,
`LASTNAME` varchar(255) DEFAULT NULL,
`PASSWD` varchar(50) DEFAULT NULL,
`ACCESSLVL` int(11) DEFAULT NULL,
`COMMENTS` text,
`NEW_ACCESSLVL` varchar(255) DEFAULT NULL,
`EMAIL` varchar(255) DEFAULT NULL,
`USER_GROUP` varchar(255) DEFAULT NULL,
PRIMARY KEY (`ID`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;
INSERT INTO `operators` (`ID`, `FIRSTNAME`, `LASTNAME`, `PASSWD`, `ACCESSLVL`, `COMMENTS`, `NEW_ACCESSLVL`, `EMAIL`, `USER_GROUP`) VALUES
('admin', 'Jord', 'WEGGE', '21232f297a57a5a743894a0e4a801fc3', 1, 'Default administrator account', 'sadmin', 'jwegge@aquabio.be', '');
Where the hash is an md5 of 'admin'.
Does OCS 2.2 uberhaupt still uses mysql for its users?
Thanks in advance.
Using ubuntu 14.04.4 x64 and OCS from OCSNG_UNIX_SERVER-2.2.tar.gz
Regards,
Jord