ocs-server 2.6 no communication with clients

Question

I've used Ocs Server for many years and the upgrade was always easy to accomplish but not this time with version 2.6. As my previous server has crashed, the disk controller was dead, I've done a brand new install. Ocs is running on Ubuntu 18.04.03 lts

In the web interface, the dashboard indicates, there is 0 machine, in fact there is no more communication/synchronisation between clients and server (most of my network clients are in 2.4 state) but I've tried installing the 2.6 version with the same error.

I've plenty errors coming from all IP clients in /var/log/apache/error.log :

 Can't call method "rollback" on an undefined value at /usr/local/share/perl/5.26.1/Apache/Ocsinventory/Server/System.pm line 312.\n

Line 312 in System.pm file :

  if( $ret==APACHE_SERVER_ERROR ){
    &_log(515,'end', 'error') if $ENV{'OCS_OPT_LOGLEVEL'};
    $dbh->rollback;
  }

I've installed the latest build : OCSNG_UNIX_SERVER_2.6-nightly-2020-01-21.tar.gz but it didn't solve the problem. If you could help me, it would be greatly appreciated.

Answer 1

Problem solved, I forgot to modify the user credential to DB into file /etc/apache2/conf-enabled/zz-ocsinventory-restapi.conf

Answer 2

Hi. Problem solved, I forgot to modify the user credential to DB and name db into file /etc/apache2/conf-enabled/z-ocsinventory-server.conf

# Name of database

# User allowed to connect to database

# Password for user

and restart service Apache2: sudo systemctl restart apache2.service

Please send me a feedback if you solved the problem

Answer 3

When I did a "tail -f /var/log/apache2/error.log" 

I got the error message "Can't call method" rollback "on an undefined value at / usr / local / share / perl / 5.26.1 / Apache / Ocsinventory / Server / System.pm line 282. "

And by thinking I had to change the password of the user of the mariadb database

So I went to the file indicating in the previous answer then I changed the password in the file "/etc/apache2/conf-enabled/z-ocsinventory-server.conf"

change # Password of user mariadb or mysql

then ctrl+X

then systemctl restart apache2.service

then refresh ocs inventory application web

The connection works again between clients and ocs inventory !

Enjoy !