Cannot install newest opsi-winst on server

[shade]

The newest version of the opsi-winst package, wont install on our server.

When running opsi-product-updater it fails with:

Installing package file '/var/lib/opsi/repository/opsi-winst_4.11.5.18-1.opsi' on depot 'opsi.fmts.lan'
Getting meta data from package '/var/lib/opsi/repository/opsi-winst_4.11.5.18-1.opsi'
Creating product in backend
Traceback:
line 170 in 'installPackage' in file '/usr/lib/python2.7/dist-packages/OPSI/Backend/Depotserver.py'
line 2536 in 'product_createObjects' in file '/usr/lib/python2.7/dist-packages/OPSI/Backend/Backend.py'
line 1 in 'product_insertObject' in file '<string>'
line 437 in '_dispatchMethod' in file '/usr/lib/python2.7/dist-packages/OPSI/Backend/BackendManager.py'
line 1262 in 'product_insertObject' in file '/usr/lib/python2.7/dist-packages/OPSI/Backend/SQL.py'
line 344 in 'insert' in file '/usr/lib/python2.7/dist-packages/OPSI/Backend/MySQL.py'
line 442 in 'execute' in file '/usr/lib/python2.7/dist-packages/OPSI/Backend/MySQL.py'
line 174 in 'execute' in file '/usr/lib/python2.7/dist-packages/MySQLdb/cursors.py'
line 36 in 'defaulterrorhandler' in file '/usr/lib/python2.7/dist-packages/MySQLdb/connections.py'
==>>> (1406, "Data too long for column 'changelog' at row 1")
Traceback:
line 1187 in '<module>' in file '/usr/bin/opsi-product-updater'
line 1180 in 'main' in file '/usr/bin/opsi-product-updater'
line 672 in 'processUpdates' in file '/usr/bin/opsi-product-updater'
line 1 in 'depot_installPackage' in file '<string>'
line 483 in '_executeMethod' in file '/usr/lib/python2.7/dist-packages/OPSI/Backend/Backend.py'
line 1 in 'depot_installPackage' in file '<string>'
line 483 in '_executeMethod' in file '/usr/lib/python2.7/dist-packages/OPSI/Backend/Backend.py'
line 1 in 'depot_installPackage' in file '<string>'
line 483 in '_executeMethod' in file '/usr/lib/python2.7/dist-packages/OPSI/Backend/Backend.py'
line 102 in 'depot_installPackage' in file '/usr/lib/python2.7/dist-packages/OPSI/Backend/Depotserver.py'
line 387 in 'installPackage' in file '/usr/lib/python2.7/dist-packages/OPSI/Backend/Depotserver.py'
==>>> Backend error: Failed to install package '/var/lib/opsi/repository/opsi-winst_4.11.5.18-1.opsi' on depot 'opsi.fmts.lan': (1406, "Data too long for column 'changelog' at row 1")
ERROR: Backend error: Failed to install package '/var/lib/opsi/repository/opsi-winst_4.11.5.18-1.opsi' on depot 'opsi.fmts.lan': (1406, "Data too long for column 'changelog' at row 1")

[wolfbardo]

mmh,

please post your backendconfiguration

Code: Alles auswählen

cat /etc/opsi/backendManager/dispatch.conf

regards,
Bardo Wolf

[n.wenselowski]

Hi,

I'd go with:

Code: Alles auswählen

opsi-setup --update-mysql
opsi-setup --init-current-config
service opsiconfd restart

-N

[shade]

mmh,

please post your backendconfiguration

Code: Alles auswählen

cat /etc/opsi/backendManager/dispatch.conf

regards,
Bardo Wolf

Ignoring # comment lines, it contains:

backend_.* : mysql, opsipxeconfd
host_.* : mysql, opsipxeconfd
productOnClient_.* : mysql, opsipxeconfd
configState_.* : mysql, opsipxeconfd
.* : mysql

[shade]

Hi,

I'd go with:

Code: Alles auswählen

opsi-setup --update-mysql
opsi-setup --init-current-config
service opsiconfd restart

-N

It fails in the first command:

root@opsi: ~ # opsi-setup --update-mysql
[5] [Apr 07 13:24:14] Connection to database 'opsi' on 'localhost' as user 'opsi' (MySQL.py|45)
[5] [Apr 07 13:24:15] Updating database table HARDWARE_DEVICE_HDAUDIO_DEVICE (MySQL.py|167)
[5] [Apr 07 13:24:15] Updating database table HARDWARE_DEVICE_SCSI_CONTROLLER (MySQL.py|167)
[5] [Apr 07 13:24:15] Updating database table HARDWARE_DEVICE_AUDIO_CONTROLLER (MySQL.py|167)
[5] [Apr 07 13:24:15] Updating database table HARDWARE_DEVICE_VIDEO_CONTROLLER (MySQL.py|167)
[5] [Apr 07 13:24:15] Updating database table HARDWARE_DEVICE_PCI_DEVICE (MySQL.py|167)
[5] [Apr 07 13:24:15] Updating database table HARDWARE_DEVICE_NETWORK_CONTROLLER (MySQL.py|167)
[5] [Apr 07 13:24:15] Updating database table HARDWARE_DEVICE_IDE_CONTROLLER (MySQL.py|167)
[5] [Apr 07 13:24:15] Updating database table HARDWARE_DEVICE_USB_DEVICE (MySQL.py|167)
[5] [Apr 07 13:24:15] Updating database table HARDWARE_DEVICE_PCMCIA_CONTROLLER (MySQL.py|167)
[5] [Apr 07 13:24:15] Updating database table HARDWARE_DEVICE_FLOPPY_CONTROLLER (MySQL.py|167)
[5] [Apr 07 13:24:15] Updating database table HARDWARE_DEVICE_USB_CONTROLLER (MySQL.py|167)
[5] [Apr 07 13:24:15] Updating database table HARDWARE_DEVICE_1394_CONTROLLER (MySQL.py|167)
[5] [Apr 07 13:24:15] Updating productId Columns (MySQL.py|445)
[5] [Apr 07 13:24:15] Updating field 'description' on table PRODUCT_PROPERTY (MySQL.py|458)
[5] [Apr 07 13:24:15] Updating field 'description' on table BOOT_CONFIGURATION (MySQL.py|458)
[5] [Apr 07 13:24:15] Fixing DEFAULT for colum 'created' on table HOST (MySQL.py|469)
[5] [Apr 07 13:24:15] Fixing length of 'hostId' column on HARDWARE_CONFIG_MEMORY_MODULE (MySQL.py|488)
[5] [Apr 07 13:24:15] Fixing length of 'hostId' column on HARDWARE_CONFIG_AUDIO_CONTROLLER (MySQL.py|488)
[5] [Apr 07 13:24:15] Fixing length of 'hostId' column on HARDWARE_CONFIG_NETWORK_CONTROLLER (MySQL.py|488)
[5] [Apr 07 13:24:15] Fixing length of 'hostId' column on HARDWARE_CONFIG_FLOPPY_CONTROLLER (MySQL.py|488)
[5] [Apr 07 13:24:15] Fixing length of 'hostId' column on HARDWARE_CONFIG_MEMORY_BANK (MySQL.py|488)
[5] [Apr 07 13:24:15] Fixing length of 'hostId' column on HARDWARE_CONFIG_IDE_CONTROLLER (MySQL.py|488)
[5] [Apr 07 13:24:15] Fixing length of 'hostId' column on HARDWARE_CONFIG_HDAUDIO_DEVICE (MySQL.py|488)
[5] [Apr 07 13:24:15] Fixing length of 'hostId' column on HARDWARE_CONFIG_COMPUTER_SYSTEM (MySQL.py|488)
[5] [Apr 07 13:24:15] Fixing length of 'hostId' column on HARDWARE_CONFIG_PORT_CONNECTOR (MySQL.py|488)
[5] [Apr 07 13:24:15] Fixing length of 'hostId' column on HARDWARE_CONFIG_OPTICAL_DRIVE (MySQL.py|488)
[5] [Apr 07 13:24:15] Fixing length of 'hostId' column on HARDWARE_CONFIG_USB_DEVICE (MySQL.py|488)
[5] [Apr 07 13:24:15] Fixing length of 'hostId' column on HARDWARE_CONFIG_MONITOR (MySQL.py|488)
[5] [Apr 07 13:24:15] Fixing length of 'hostId' column on HARDWARE_CONFIG_DISK_PARTITION (MySQL.py|488)
[5] [Apr 07 13:24:15] Fixing length of 'hostId' column on HARDWARE_CONFIG_PCI_DEVICE (MySQL.py|488)
[5] [Apr 07 13:24:15] Fixing length of 'hostId' column on HARDWARE_CONFIG_SYSTEM_SLOT (MySQL.py|488)
[5] [Apr 07 13:24:15] Fixing length of 'hostId' column on HARDWARE_CONFIG_KEYBOARD (MySQL.py|488)
[5] [Apr 07 13:24:15] Fixing length of 'hostId' column on HARDWARE_CONFIG_TAPE_DRIVE (MySQL.py|488)
[5] [Apr 07 13:24:15] Fixing length of 'hostId' column on HARDWARE_CONFIG_CHASSIS (MySQL.py|488)
[5] [Apr 07 13:24:15] Fixing length of 'hostId' column on HARDWARE_CONFIG_PCMCIA_CONTROLLER (MySQL.py|488)
[5] [Apr 07 13:24:15] Fixing length of 'hostId' column on HARDWARE_CONFIG_PRINTER (MySQL.py|488)
[5] [Apr 07 13:24:15] Fixing length of 'hostId' column on HARDWARE_CONFIG_POINTING_DEVICE (MySQL.py|488)
[5] [Apr 07 13:24:15] Fixing length of 'depotId' column on PRODUCT_ON_DEPOT (MySQL.py|485)
[2] [Apr 07 13:24:15] Traceback: (Logger.py|757)
[2] [Apr 07 13:24:15] line 2304 in '<module>' in file '/usr/bin/opsi-setup' (Logger.py|757)
[2] [Apr 07 13:24:15] line 2259 in 'main' in file '/usr/bin/opsi-setup' (Logger.py|757)
[2] [Apr 07 13:24:15] line 486 in 'updateMySQLBackend' in file '/usr/lib/python2.7/dist-packages/OPSI/Util/Task/UpdateBackend/MySQL.py' (Logger.py|757)
[2] [Apr 07 13:24:15] line 442 in 'execute' in file '/usr/lib/python2.7/dist-packages/OPSI/Backend/MySQL.py' (Logger.py|757)
[2] [Apr 07 13:24:15] line 174 in 'execute' in file '/usr/lib/python2.7/dist-packages/MySQLdb/cursors.py' (Logger.py|757)
[2] [Apr 07 13:24:15] line 36 in 'defaulterrorhandler' in file '/usr/lib/python2.7/dist-packages/MySQLdb/connections.py' (Logger.py|757)
[2] [Apr 07 13:24:15] ==>>> (1832, "Cannot change column 'depotId': used in a foreign key constraint 'PRODUCT_ON_DEPOT_ibfk_2'") (opsi-setup|2308)

ERROR: (1832, "Cannot change column 'depotId': used in a foreign key constraint 'PRODUCT_ON_DEPOT_ibfk_2'")

[n.wenselowski]

Hi,

does it run normally with mysql in your setup?
Did you setup mysql?


-n

[shade]

Yes, we have been using mysql for over a year.

[shade]

Tried opsi-product-updater agian, it installed this time, with a warning:

Getting meta data from package '/var/lib/opsi/repository/opsi-winst_4.11.5.18-1.opsi'
Using product property defaults: {}
Installing package '/var/lib/opsi/repository/opsi-winst_4.11.5.18-1.opsi'
=================================================================================================
Installing package file '/var/lib/opsi/repository/opsi-winst_4.11.5.18-1.opsi' on depot 'opsi.fmts.lan'
Getting meta data from package '/var/lib/opsi/repository/opsi-winst_4.11.5.18-1.opsi'
Creating product in backend
Data truncated for column 'changelog' at row 1
Locking product 'opsi-winst' on depot 'opsi.fmts.lan'
Checking package dependencies
Running preinst script
Running package script 'preinst'
Unpacking package files
Extracting data from package '/var/lib/opsi/repository/opsi-winst_4.11.5.18-1.opsi'
Setting product property states in backend
Running postinst script
Running package script 'postinst'
Creating package content file
Setting access rights of client-data files
Unlocking product 'opsi-winst_4.11.5.18-1' on depot 'opsi.fmts.lan'
Package '/var/lib/opsi/repository/opsi-winst_4.11.5.18-1.opsi' successfully installed

[n.wenselowski]

Hi,

from the messages I'd think something is wrong with your database.
Good if it works now.


-n

[shade]

Hi,

I'd go with:

Code: Alles auswählen

opsi-setup --update-mysql
opsi-setup --init-current-config
service opsiconfd restart

-N

I found a problem in the mysql config, now the above commands runs with success

First time opsi-setup --update-mysql ran, it outputted many lines with:

Fixing length of 'hostId' column on TABLENAME...