Permission denied on http://SERVER/ocsreports/

Question

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 ?

Answer 1

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

apfiorotto's 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

Answer 2

I found the solution on an other website.

It was SELINUX denying external acces to the database.