Fix update instructions for OTOBO 10.1. add table stats_report, install Perl packages

[Marcobrmn]

Hey guys,

I am having the same issue like in RotherOSS/otobo#1613 in our productive environment, but I didnt managed to resolve the problem.
I have updated to OTOBO 10.1 yesterday.

When I am trying to generate a new Report I get the message:
(And I am receiving an error Email every 10 Minutes 👍 )

Table 'otobo.stats_report' doesn't exist, SQL: '
SELECT id
FROM stats_report
WHERE name = ? LIMIT 1'

The Table is not present in the OTOBO DB (MariaDB).

Unfortunately there is no Create Table command in the "/opt/otobo/scripts/database/otobo-schema.mysql.sql" script too.

Would it be enough to create the table via script by myself to get it working? Would be nice if one of you could send me the command :)

Thanks and have a great day!

[bschmalhofer]

Hi @Marcobrmn ,

first I was confused that the file /opt/otobo/scripts/database/otobo-schema.mysql.sql still exists in your updated installations. This file is not part of OTOBO 10.1.1. But checking Step 3 of https://doc.otobo.org/manual/installation/10.1/en/content/updating.html I found that the current installation instructions do not remove files that are no longer part of the OTOBO installation. Just for assurance, the table stats_report should be declared in_/opt/otobo/scripts/database/otobo-schema.xml_ .

But I think that you ran into a different problem. Did you execute Step 5 of https://doc.otobo.org/manual/installation/10.1/en/content/updating.html ? I think that the command /opt/otobo/scripts/DBUpdate-to-10.1.pl
does add the table.

Please also note the for these kind of questions the use of the forum at https://otobo.de/en/forums/otobo/otobo-forum/ is recommended.

Best regards,
Bernhard

[Marcobrmn]

Hi @bschmalhofer,

thank you for the fast reply!

Well I have followed the instructions for OTOBO 10.0, my fault :)
The only difference in the documentation 10.0 and 10,1 I could find is the Step 5 with the DBUpdate script you have mentioned.
After executing it, the reports are running again and the table exists in my DB.
Thank you!

Another thing I would like to mention, if others have the problem too:
After following the instruction step by step i could not manage to get otobo to run again. The things I did different to get it running:
Step 3:
The command
cp -r otobo-10.1.1/* /opt/otobo (with the star)
does not work for me, it copied the folder, not the files into the opt/otobo directory.

I used this command, by replacing the files in the current otobo dir:
(I did not delete the existing otobo dir)
sudo cp -r otobo-10.1.1/. /opt/otobo

Step 4:
I received an error message while trying to execute the command. After a while I found out that some Peal packages were missing.
In my case those packages where missing:
sudo apt-get install -y libcgi-psgi-perl libdbix-connector-perl libfile-chmod-perl liblist-allutils-perl libpath-class-perl libtext-trim-perl libpath-class-perl libplack-perl libplack-middleware-header-perl libplack-perl libplack-middleware-reverseproxy-perl libconst-fast-perl

Are those steps right or could this cause problems in the future, because I did not use a clean /opt/otobo dir?

[bschmalhofer]

Hi @Marcobrmn ,

you are perfectly right. The update instructions for OTOBO 10.1 are incomplete. Therefore I have moved this issue to the relevant repository doc-otobo-installation.

Regarding Step 3: In your case the directory /opt/otobo was apparently no longer there. However I think that the instructions should not be adapted, as in the regular case the directory /opt/otobo would still exist.

Regarding Step 4: An extra step needs to be added to the instructions. This missing step would be equivalent to Step 2 of https://doc.otobo.org/manual/installation/10.1/en/content/installation.html.

Thanks again for the detailed report. We aim to become more professional in future releases.

Best regards,
Bernhard