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.8 available

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

Permission denied on http://SERVER/ocsreports/

Hi, when I go to the home page ocsreports it shows me :

ERROR: MySql connection problem 2002
Permission denied
ERROR: MySql connection problem 2002
Permission denied

It worked yesterday.

httpd/error_log shows:

PHP Warning: mysqli_fetch_object() expect parameter 1 to be mysqli_result, null given in /usr/share/ocsinventory-reports/ocsreports/require/function_commun.php on line 38

Same error on line 67 / 104 / and again 38 with different mysqli methods.

OS : CentOS 7
OCS Server and agent version : 2.8

I've checked:
-All services are running
-Privileges for root and ocs admin on the database (MariaDB 10.5.5)
-dbconfig.inc.php user / password and port aree good.

Any ideas ?
in OCS Inventory NG server for Unix by (160 points)

2 Answers

0 votes

please look here

http://ask.ocsinventory-ng.org/11927/ocs-version-2-7-update-problem-mysql-ssl-enable

in the middle of the errors he has also

PHP Warning: mysqli_fetch_object() expect......

solution was

I've managed to fix it!

the problem was that the old dbconfig.inc.php didn't have new variables needed for v2.7, and i restored the previous from v2.5, already configured, after the update.

define("SSL_KEY","");

define("SSL_CERT","");

define("CA_CERT","");

define("SERVER_PORT","3306");

define("ENABLE_SSL","0");

perhaps it helps you

by (13.4k points)
0 votes
I found the solution on an other website.

It was SELINUX denying external acces to the database.
by (160 points)
 
Powered by Question2Answer
...