Yes,
This is the patch for opsi-setup :
Code: Alles auswählen
--- opsi-setup-old 2014-12-04 09:50:10.158781374 +0100
+++ opsi-setup 2014-12-03 15:48:37.029043590 +0100
@@ -1214,7 +1214,7 @@
logger.notice(u"Updating database table HOST from opsi 3.3 to 3.4")
# SOFTWARE_CONFIG
logger.notice(u"Updating table SOFTWARE_CONFIG")
- mysql.execute(u"alter table SOFTWARE_CONFIG add `hostId` varchar(50) NOT NULL;")
+ mysql.execute(u"alter table SOFTWARE_CONFIG add `hostId` varchar(64) NOT NULL;")
mysql.execute(u"alter table SOFTWARE_CONFIG add `softwareId` varchar(100) NOT NULL;")
for res in mysql.getSet(u"SELECT hostId,host_id FROM `HOST` WHERE `hostId` != ''"):
mysql.execute(u"update SOFTWARE_CONFIG set `hostId`='%s' where `host_id`=%s;" % (res['hostId'].replace("'", "\\'"), res['host_id']))
@@ -1229,7 +1229,7 @@
# HARDWARE_CONFIG
if key.startswith(u'HARDWARE_CONFIG') and 'host_id' in tables[key]:
logger.notice(u"Updating database table %s from opsi 3.3 to 3.4" % key)
- mysql.execute(u"alter table %s add `hostId` varchar(50) NOT NULL;" % key)
+ mysql.execute(u"alter table %s add `hostId` varchar(64) NOT NULL;" % key)
for res in mysql.getSet(u"SELECT hostId,host_id FROM `HOST` WHERE `hostId` != ''"):
mysql.execute(u"update %s set `hostId` = '%s' where `host_id` = %s;" % (key, res['hostId'].replace("'", "\\'"), res['host_id']))
mysql.execute(u"alter table %s drop `host_id`;" % key)
@@ -1240,7 +1240,7 @@
logger.notice(u"Updating database table HARDWARE_INFO from opsi 3.3 to 3.4")
# HARDWARE_INFO
logger.notice(u"Updating table HARDWARE_INFO")
- mysql.execute(u"alter table HARDWARE_INFO add `hostId` varchar(50) NOT NULL;")
+ mysql.execute(u"alter table HARDWARE_INFO add `hostId` varchar(64) NOT NULL;")
for res in mysql.getSet(u"SELECT hostId,host_id FROM `HOST` WHERE `hostId` != ''"):
mysql.execute(u"update HARDWARE_INFO set `hostId` = '%s' where `host_id` = %s;" % (res['hostId'].replace("'", "\\'"), res['host_id']))
mysql.execute(u"alter table HARDWARE_INFO drop `host_id`;")
And for /usr/share/pyshared/OPSI/Backend/SQL.py
Code: Alles auswählen
--- SQL-old.py 2014-12-04 09:47:58.374777845 +0100
+++ SQL.py 2014-12-04 08:41:38.286671262 +0100
@@ -475,7 +475,7 @@
`productId` varchar(255) NOT NULL,
`productVersion` varchar(32) NOT NULL,
`packageVersion` varchar(16) NOT NULL,
- `depotId` varchar(50) NOT NULL,
+ `depotId` varchar(64) NOT NULL,
`productType` varchar(16) NOT NULL,
`locked` bool,
PRIMARY KEY (`productId`, `depotId`),
@@ -802,7 +802,7 @@
u'`hardware_id` INTEGER NOT NULL ' + self._sql.AUTOINCREMENT + ',\n'
hardwareConfigTable = u'CREATE TABLE `' + hardwareConfigTableName + '` (\n' + \
u'`config_id` INTEGER NOT NULL ' + self._sql.AUTOINCREMENT + ',\n' + \
- u'`hostId` varchar(50) NOT NULL,\n' + \
+ u'`hostId` varchar(64) NOT NULL,\n' + \
u'`hardware_id` INTEGER NOT NULL,\n' + \
u'`firstseen` TIMESTAMP NOT NULL DEFAULT \'0000-00-00 00:00:00\',\n' + \
u'`lastseen` TIMESTAMP NOT NULL DEFAULT \'0000-00-00 00:00:00\',\n' + \
Thank you,
Antoine