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

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

http error 500 after system upgrade (mariadb)

Hi,
ocsinventory-ng server on a Debian Stretch.

After the last system upgrade

(Install: libconfig-inifiles-perl(2.94-1), Upgrade: mariadb-common(10.1.26-0+deb9u1, 10.1.37-0+deb9u1), mariadb-server-core-10.1(10.1.26-0+deb9u1, 10.1.37-0+deb9u1), mariadb-server-10.1(10.1.26-0+deb9u1, 10.1.37-0+deb9u1), mariadb-client-10.1(10.1.26-0+deb9u1, 10.1.37-0+deb9u1), mariadb-client-core-10.1(10.1.26-0+deb9u1, 10.1.37-0+deb9u1), libmariadbclient18:i386 (10.1.26-0+deb9u1, 10.1.37-0+deb9u1)

all agents now receive a http error 500:

Starting OCS Inventory NG Agent on Monday, November 26, 2018 11:31:58.
AGENT => Running OCS Inventory NG Agent Version 2.4.0.0
AGENT => Using OCS Inventory NG FrameWork Version 2.4.0.0
AGENT => Loading plug-in(s)
    DLL PLUGIN => Searching for Plug-in DLL(s) in folder <C:\Program Files (x86)\OCS Inventory Agent\plugins>
    DLL PLUGIN => 0 DLL Plug-in(s) successfully loaded on 0 DLL(s) found
AGENT => Using network connection with Communication Server
    COM PROVIDER => Loading Communication Provider <C:\Program Files (x86)\OCS Inventory Agent\ComHTTP.dll>
AGENT => Using Communication Provider <OCS Inventory NG cURL Communication Provider> Version <2.4.0.0>
AGENT => Sending Prolog
    DID_CHECK => Read DeviceID <WUT-2018-11-25-15-48-17> and MACs <BA:71:75:85:97:6F> in file <ocsinventory.dat>
    COM SERVER => Initializing cURL library for sendRequest
    COM SERVER => Using cURL without server authentication
    COM SERVER => Disabling cURL proxy support
    COM SERVER => Enabling cURL SSL server validation support using CA Bundle <cacert.pem>
    COM SERVER => Sending HTTP Post request to URL <https://ocsinventory.cgil.int.cgil.tn.it/ocsinventory>
    COM SERVER => HTTP Post response received <HTTP Status Code #500>
    COM SERVER => Cleaning cURL library
ERROR *** AGENT => Failed to send Prolog <HTTP Status Code #500>
AGENT => Unloading communication provider
AGENT => Unloading plug-in(s)
AGENT => Execution duration: 00:00:00.

in /var/log/apache2/error.log I see these errors, for every agent connection tried:

DBD::mysql::dr connect warning:  at /usr/share/perl5/Apache/DBI.pm line 213.
[Mon Nov 26 11:44:49.289317 2018] [perl:error] [pid 352] [client 192.168.31.113:52312] Can't call method "rollback" on an undefined value at /usr/local/share/perl/5.24.1/Apache/Ocsinventory/Server/System.pm line 282.\n

ocsinventory-ng server version is 2.5, and agents versions are from 2.3.1 to 2.4

Is there a fix for this? Thanks

asked in OCS Inventory NG server for Unix by (200 points)

5 Answers

0 votes

I'm getting the same error:  Can't call method "rollback" on an undefined value at /usr/local/share/perl5/Apache/Ocsinventory/Server/System.pm line 282.\n

OCS Inventory NG Server Version 2.5, Apache/2.4.6 (CentOS 7) OpenSSL/1.0.2k-fips PHP/5.4.16 mod_perl/2.0.10 Perl/v5.16.3

OCS Inventory NG Agent Version 2.4.0.0

answered ago by (240 points)
0 votes
For me, the fix was correcting the "PerlSetVar OCS_DB_PWD" field in the z-ocsinventory-server.conf file, to the password that was entered during the install.
answered ago by (240 points)
0 votes
Thank you Andrew,

I double-checked, and both z-ocsinventory-server.conf and mysql uses same password for user "ocs".

I decided to hold the mariadb update until new updates will be available.
answered ago by (200 points)
0 votes
Hi,

Did you restart apache after mariadb update?

Regards

Frank
answered ago by (66.4k points)
0 votes

Yes, and I rebooted the ocs server.

I also did the following steps:

  • mysql_upgrade -u root -p
  • mysqlcheck -u root -p --auto-repair --check --all-databases
answered ago by (200 points)
 
Powered by Question2Answer
...