[Solved] Erros on OPSI (maybe my mistake)

[guillaume]

Hi guys,

I post on the french section my issue but no answers at this time. I try on the English channel (orignial link : viewtopic.php?f=16&t=12451&p=54454#p54454) :

After OPSI server update, i encounter some issues :

• On the GUO tool, if i try to get hardware informations i get :

  juil. 08 15:40:19.629 2021 -- Opsi service error: [ProgrammingError] (1146, "Table 'opsi.HARDWARE_CONFIG_TPM' doesn't exist")

• I try to execute the command below to repair things and get :

  opsi-setup --init-current-config -> opsi-setup : command not found

  or

  sudo opsi-set-rights -> command not found

Does commands have been replaced by other i do not know ? I don't think so.

Thanks for your help, i hope you will be able to gimme a hand on that.

Guillaume

[wolfbardo]

Whatd Linux distro you are running

Code: Alles auswählen

lsb_release-a

Which opsi-packages are installed

Code: Alles auswählen

dpkg -l | grep opsi
or
rpm -qa | grep opsi

regards,
bardo wolf

[guillaume]

Hi Bardo Wolf,

Here is the release :

Distributor ID: Ubuntu
Description: Ubuntu 18.04.6 LTS
Release: 18.04
Codename: bionic

Here are opsi-packages installed :

ii opsi-configed 4.0.7.6.34-2 all OPSI config editor
ii opsi-linux-support 4.1.1-3 all Configure system to be able to deploy Linux with opsi.
rc opsi-server 4.1.1.6-1 all opsi server configuration package
ii opsi-tftpd-hpa 5.2.8-76 amd64 HPA's tftp server
ii opsi-utils 4.1.1.37-1 all utilites for working with opsi.
ii opsi-vm-config 4.1.2 all Configuration of opsi VM.
ii opsi-windows-support 4.1.1-8 all Install utilities useful for deploying Windows with opsi.
ii opsiconfd 4.1.1.20-1 all opsi configuration service
ii opsipxeconfd 4.1.1.20-3 all opsi pxe configuration daemon
ii python-opsi 4.1.1.101-1 all opsi python library

Thanks a lot for your fast answer, very very appreciated !

Guillaume

[wolfbardo]

the package

rc opsi-server 4.1.1.6-1 all opsi server configuration package

is broken.

Fix it with

Code: Alles auswählen

apt install opsi-server

regards
bardo wolf

[guillaume]

Thanks for your answer.

Will it scratch all configuration ?
Do i have to make something before doing anything or will it be transparency and simply restore corrupted Table and missing commands ?

Thank you, regards.
Guillaume

[wolfbardo]

Code: Alles auswählen

apt install opsi-server

will fix your broken rc opsi-serverpackage.

Code: Alles auswählen

opsi-setup --update-mysql
opsi-setup --init-current-config

will (hopefully) fix your database

Code: Alles auswählen

systemctl restart opsiconfd
systemctl restart opsipxeconfd

regards,
bardo wolf

[guillaume]

Hi Wolfbardo,

I repair my OPSI server and want to thank you so much. You save me time, you cannot imagine !!
Everything's look fine now to me.

Thank you so so much.

Regards
Guillaume