Nach Linux Umzug und OPSI Update Fehler "Bad workbench local url:"

Antworten
Linuxuser
Beiträge: 9
Registriert: 03 Aug 2018, 12:16

Nach Linux Umzug und OPSI Update Fehler "Bad workbench local url:"

Beitrag von Linuxuser »

Hallo UIB,

folgendes Problem.

Kunde hat OPSI 4.0 auf 10.04 und ich sollte es auf 16.04 hochziehen.
Inplace Upgrade hatte nicht funktioniert (alter Kernel wollte nicht installieren und und und...)

ALTER OPSI: 192.168.125.103

Daher mit Eurem Image eine Neuinstallation neben den alten OPSI Server.
* Repository kopiert
25 2018-07-31 13:44:46 root@opsi cd /var/lib/opsi/repository
31 2018-07-31 13:45:25 root@opsi rsync -HavP 192.168.125.103:$PWD/* .

* Custom Software
34 2018-07-31 14:14:23 root@opsi cd /usr/src/
37 2018-07-31 14:15:03 root@opsi rsync -HavP 192.168.125.103:$PWD/opsi .

* Opsi Pakete installieren
104 2018-07-31 16:24:44 root@opsi cd /usr/src/opsi/
107 2018-07-31 16:29:13 root@opsi find . -name "*.opsi" -print0 | xargs -r0 opsi-package-manager -i --force

* Erstellen eines Konfig-Backups und stoppen von OPSI ALT
1175 2018-07-31 17:23:47 root@opsi opsi-backup create
970 2018-08-01 16:55:43 root@opsi opsi-backup create --backends all


* OPSI-NEU
266 2018-08-01 16:54:30 root@opsi rsync -HavP 192.168.125.103:opsi_4.0.7.45_2018-08-01_16-53-11.588143.tar.bz2 .
269 2018-08-01 16:55:02 root@opsi opsi-backup restore opsi_4.0.7.45_2018-08-01_16-53-11.588143.tar.bz2

278 2018-08-01 16:56:59 root@opsi rsync -HavP 192.168.125.103:opsi_4.0.7.45_2018-08-01_16-55-43.867385.tar.bz2 .
283 2018-08-01 17:00:28 root@opsi opsi-backup restore opsi_4.0.7.45_2018-08-01_16-55-43.867385.tar.bz2 --backends mysql
315 2018-08-01 17:07:41 root@opsi opsi-backup restore opsi_4.0.7.45_2018-08-01_16-55-43.867385.tar.bz2 --configuration

* alle Konfig´s und SQL-DB sind auf der neuen OPSI VM
349 2018-08-01 17:23:37 root@opsi vim /etc/network/interfaces
-> Alte IP eingetragen und neu gestartet

* So OPSI lässt sich starten und alle alten Pakete inkl. Install-Stände sind zu sehen

Nun aber erhalte ich die Meldungen, dass OPSI den Workbencht nicht findet
┏━━━━━━━
┃ root@opsi:~# opsi-set-rights
┃ [5] [Aug 03 12:19:10] Setting rights on directory u'/etc/opsi' (Rights.py|116)
┃ [5] [Aug 03 12:19:10] Setting rights on directory u'/var/log/opsi' (Rights.py|116)
┃ [5] [Aug 03 12:19:10] Setting rights on directory u'/var/lib/opsi' (Rights.py|116)
┃ [4] [Aug 03 12:19:19] Unable to get path of workbench directory: Bad workbench local url: None (Rights.py|190)
┃ [5] [Aug 03 12:19:19] Setting rights on directory u'/tftpboot/linux' (Rights.py|116)
┃ [5] [Aug 03 12:19:20] Setting rights on directory u'/var/lib/opsi/depot' (Rights.py|116)
┃ [5] [Aug 03 12:19:26] Setting rights on directory u'/var/www/html/opsi' (Rights.py|116)
┗━━━━━━━
* Ein Symlink wie in einem anderen Thread klappte nicht
* Anpassen unter GUI -> Server-Konfiguration -> Host-parameter -> configed
configed.workbench.default = /var/lib/opsi/workbench
brachte keine Besserung

* Dann habe ich noch den Befehl "opsi-setup --update-mysql" gefunden, dieser zeigt noch mehr Fehler
[5] [Aug 03 12:00:17] Connection to database 'opsi' on 'localhost' as user 'opsi' (MySQL.py|81)
[5] [Aug 03 12:00:17] Creating opsi base (SQL.py|500)
[5] [Aug 03 12:00:18] Creating opsi base (SQL.py|500)
[5] [Aug 03 12:00:19] Creating opsi base (SQL.py|500)
[5] [Aug 03 12:00:19] Setting up default values. (ConfigurationData.py|81)
[5] [Aug 03 12:00:20] Finished setting up default values. (ConfigurationData.py|89)
[5] [Aug 03 12:00:20] Setting missing value for workbenchLocalUrl on opsi.<KUNDE>-dt.de to file:///home/opsiproducts (ConfigurationData.py|66)
[5] [Aug 03 12:00:20] Setting missing value for workbenchRemoteUrl on opsi.<KUNDE>dt.de to smb://<KUDNE>-opsi/opsi_workbench (ConfigurationData.py|73)
[2] [Aug 03 12:00:20] Traceback: (Logger.py|798)
[2] [Aug 03 12:00:20] File "/usr/bin/opsi-setup", line 1242, in <module>
main()
(Logger.py|798)
[2] [Aug 03 12:00:20] File "/usr/bin/opsi-setup", line 1206, in main
update()
(Logger.py|798)
[2] [Aug 03 12:00:20] File "/usr/bin/opsi-setup", line 269, in update
updateBackendData(backend) # opsi 4.0 -> 4.1
(Logger.py|798)
[2] [Aug 03 12:00:20] File "/usr/lib/python2.7/dist-packages/OPSI/Util/Task/UpdateBackend/ConfigurationData.py", line 40, in updateBackendData
setDefaultWorkbenchLocation(backend)
(Logger.py|798)
[2] [Aug 03 12:00:20] File "/usr/lib/python2.7/dist-packages/OPSI/Util/Task/UpdateBackend/ConfigurationData.py", line 78, in setDefaultWorkbenchLocation
backend.host_updateObjects(changedServers)
(Logger.py|798)
[2] [Aug 03 12:00:20] File "<string>", line 1, in host_updateObjects
(Logger.py|798)
[2] [Aug 03 12:00:20] File "/usr/lib/python2.7/dist-packages/OPSI/Backend/Backend.py", line 522, in _executeMethod
return meth(**kwargs)
(Logger.py|798)
[2] [Aug 03 12:00:20] File "<string>", line 1, in host_updateObjects
(Logger.py|798)
[2] [Aug 03 12:00:20] File "/usr/lib/python2.7/dist-packages/OPSI/Backend/Backend.py", line 522, in _executeMethod
return meth(**kwargs)
(Logger.py|798)
[2] [Aug 03 12:00:20] File "/usr/lib/python2.7/dist-packages/OPSI/Backend/Backend.py", line 2085, in host_updateObjects
updateOrInsert(host)
(Logger.py|798)
[2] [Aug 03 12:00:20] File "/usr/lib/python2.7/dist-packages/OPSI/Backend/Backend.py", line 2078, in updateOrInsert
self._backend.host_updateObject(host)
(Logger.py|798)
[2] [Aug 03 12:00:20] File "<string>", line 1, in host_updateObject
(Logger.py|798)
[2] [Aug 03 12:00:20] File "/usr/lib/python2.7/dist-packages/OPSI/Backend/BackendManager.py", line 423, in _dispatchMethod
res = meth(**kwargs)
(Logger.py|798)
[2] [Aug 03 12:00:20] File "/usr/lib/python2.7/dist-packages/OPSI/Backend/SQL.py", line 1072, in host_updateObject
self._sql.update('HOST', where, data)
(Logger.py|798)
[2] [Aug 03 12:00:20] File "/usr/lib/python2.7/dist-packages/OPSI/Backend/MySQL.py", line 429, in update
self.execute(query, conn, cursor)
(Logger.py|798)
[2] [Aug 03 12:00:20] File "/usr/lib/python2.7/dist-packages/OPSI/Backend/MySQL.py", line 484, in execute
res = cursor.execute(query)
(Logger.py|798)
[2] [Aug 03 12:00:20] File "/usr/lib/python2.7/dist-packages/MySQLdb/cursors.py", line 226, in execute
self.errorhandler(self, exc, value)
(Logger.py|798)
[2] [Aug 03 12:00:20] File "/usr/lib/python2.7/dist-packages/MySQLdb/connections.py", line 36, in defaulterrorhandler
raise errorvalue
(Logger.py|798)
[2] [Aug 03 12:00:20] ==>>> (1054, "Unknown column 'workbenchLocalUrl' in 'field list'") (opsi-setup|1246)

ERROR: (1054, "Unknown column 'workbenchLocalUrl' in 'field list'")


Habt Ihr eine Idee?

Merci
Benutzeravatar
ThomasT
uib-Team
Beiträge: 529
Registriert: 26 Jun 2013, 12:26

Re: Nach Linux Umzug und OPSI Update Fehler "Bad workbench local url:"

Beitrag von ThomasT »

Hast du vor dem opsi-set-rights mit der angepassten configed.workbench.default = /var/lib/opsi/workbench ein opsi-setup --init-current-config gemacht?
Kein Support per DM!
_________________________
opsi support - https://www.uib.de/
For productive opsi installations we recommend support contracts.
Linuxuser
Beiträge: 9
Registriert: 03 Aug 2018, 12:16

Re: Nach Linux Umzug und OPSI Update Fehler "Bad workbench local url:"

Beitrag von Linuxuser »

Hi ThomasT,

hier der Output

root@opsi:~# opsi-setup --init-current-config
[5] [Aug 03 14:31:41] Creating opsi base (SQL.py|500)
[5] [Aug 03 14:31:41] Try to find a Configserver. (InitializeBackend.py|69)
[2] [Aug 03 14:31:41] Traceback: (Logger.py|798)
[2] [Aug 03 14:31:41] File "/usr/bin/opsi-setup", line 1242, in <module>
main()
(Logger.py|798)
[2] [Aug 03 14:31:41] File "/usr/bin/opsi-setup", line 1198, in main
initializeBackends(ipAddress)
(Logger.py|798)
[2] [Aug 03 14:31:41] File "/usr/lib/python2.7/dist-packages/OPSI/Util/Task/InitializeBackend.py", line 105, in initializeBackends
backend.host_insertObject(configServer)
(Logger.py|798)
[2] [Aug 03 14:31:41] File "<string>", line 1, in host_insertObject
(Logger.py|798)
[2] [Aug 03 14:31:41] File "/usr/lib/python2.7/dist-packages/OPSI/Backend/Backend.py", line 522, in _executeMethod
return meth(**kwargs)
(Logger.py|798)
[2] [Aug 03 14:31:41] File "<string>", line 1, in host_insertObject
(Logger.py|798)
[2] [Aug 03 14:31:41] File "/usr/lib/python2.7/dist-packages/OPSI/Backend/Backend.py", line 522, in _executeMethod
return meth(**kwargs)
(Logger.py|798)
[2] [Aug 03 14:31:41] File "<string>", line 1, in host_insertObject
(Logger.py|798)
[2] [Aug 03 14:31:41] File "/usr/lib/python2.7/dist-packages/OPSI/Backend/Backend.py", line 522, in _executeMethod
return meth(**kwargs)
(Logger.py|798)
[2] [Aug 03 14:31:41] File "<string>", line 1, in host_insertObject
(Logger.py|798)
[2] [Aug 03 14:31:41] File "/usr/lib/python2.7/dist-packages/OPSI/Backend/BackendManager.py", line 423, in _dispatchMethod
res = meth(**kwargs)
(Logger.py|798)
[2] [Aug 03 14:31:41] File "/usr/lib/python2.7/dist-packages/OPSI/Backend/SQL.py", line 1064, in host_insertObject
self._sql.update('HOST', where, data, updateWhereNone=True)
(Logger.py|798)
[2] [Aug 03 14:31:41] File "/usr/lib/python2.7/dist-packages/OPSI/Backend/MySQL.py", line 429, in update
self.execute(query, conn, cursor)
(Logger.py|798)
[2] [Aug 03 14:31:41] File "/usr/lib/python2.7/dist-packages/OPSI/Backend/MySQL.py", line 484, in execute
res = cursor.execute(query)
(Logger.py|798)
[2] [Aug 03 14:31:41] File "/usr/lib/python2.7/dist-packages/MySQLdb/cursors.py", line 226, in execute
self.errorhandler(self, exc, value)
(Logger.py|798)
[2] [Aug 03 14:31:41] File "/usr/lib/python2.7/dist-packages/MySQLdb/connections.py", line 36, in defaulterrorhandler
raise errorvalue
(Logger.py|798)
[2] [Aug 03 14:31:41] ==>>> (1054, "Unknown column 'workbenchLocalUrl' in 'field list'") (opsi-setup|1246)

ERROR: (1054, "Unknown column 'workbenchLocalUrl' in 'field list'")
Antworten