Adlice Software.

Migration

Migration: Von 4.X zu 4.3

  • TABELLE storage_metas, SPALTE value: Ändern Sie den Typ von TEXT auf LONGTEXT.

Migration: Von 4.3 zu 5.X

  • Voraussetzungen aktualisieren:
sudo pip install oletools pdfminer
  • Usercake aktualisieren:
CREATE TABLE IF NOT EXISTS `uc_sessions` (
 `sessionStart` int(11) NOT NULL,
 `sessionData` text NOT NULL,
 `sessionID` varchar(255) NOT NULL,
 PRIMARY KEY (`sessionID`)
 ) ENGINE=InnoDB  DEFAULT CHARSET=utf8;
 
INSERT INTO `uc_configuration` (`id`, `name`, `value`) VALUES 
 (9, 'remember_me_length', '1wk');

  • Installer ausführen (um das neue Schema zu erstellen), indem Sie den Ordner „install“ wiederherstellen und dann zum Stammverzeichnis navigieren

  • **Migration ausführen: **(Führen Sie diese Abfragen aus)

INSERT INTO samples (md5, filename, threat, size, date, uploader, sha256) 
SELECT md5, filename, vendor as threat, filesize as size, timestamp as date, user as uploader, 
(SELECT value from storage_metas m WHERE m.name = '_sha256' AND m.md5 = s.md5) as sha256 
FROM storage s;
 
INSERT INTO samples_cuckoo (md5, scan_id, status) 
SELECT md5, cuckoo_id as scan_id, is_cuckoo_scanned as status
FROM storage;
 
INSERT INTO samples_metas (md5, comment) 
SELECT md5,
(SELECT value from storage_metas m WHERE m.name = '_comment' AND m.md5 = s.md5) as comment
FROM storage s;
 
INSERT INTO samples_mime (md5, data) 
SELECT md5,
(SELECT value from storage_metas m WHERE m.name = '_mime' AND m.md5 = s.md5) as data
FROM storage s;
 
INSERT INTO samples_ssdeep (md5, data) 
SELECT md5,
(SELECT value from storage_metas m WHERE m.name = '_ssdeep' AND m.md5 = s.md5) as data
FROM storage s;
 
INSERT INTO samples_favorite (md5, user) 
SELECT md5, value as user
FROM storage_metas WHERE name = '_favorite';
 
INSERT INTO samples_pedata (md5, data, icon) 
SELECT md5,
(SELECT value from storage_metas m WHERE m.name = '_pedata' AND m.md5 = s.md5) as data, 
(SELECT value from storage_metas m WHERE m.name = '_icon' AND m.md5 = s.md5) as icon
FROM storage s;s
 
INSERT INTO samples_tag (md5, tag) 
SELECT md5, value as tag from storage_metas m WHERE m.name = '_tag';
 
INSERT INTO samples_url (md5, name, url) 
SELECT md5, 
SUBSTRING_INDEX(SUBSTRING_INDEX(value, '|', 1), '|', -1) as name,
SUBSTRING_INDEX(SUBSTRING_INDEX(value, '|', 2), '|', -1) as url 
FROM storage_metas m 
WHERE m.name = '_url';
 
INSERT INTO samples_virustotal (md5, link, scan_id, score, status) 
SELECT md5, vtlink as link, vt_scan_id as scan_id, vtscore as score, is_vtscanned as status
FROM storage;

  • Speicherort des Cron-Skripts ändern (von /src/cron.php zu /cron.php)

  • Alte Tabellen entfernen: samples, samples_metas (wenn Sie sicher sind, dass die Migration abgeschlossen ist)

Migration: Von 5.0 zu 5.1

  • Installieren Sie peepdf
pip install peepdf

Migration: Von 5.1 zu 6.0

  • Usercake aktualisieren:
INSERT INTO `uc_permissions` (`id`, `name`) VALUES 
 (9, 'Yed Uploader');

  • In der Tabelle samples_metas: Spalte „comment“ entfernen (Datenverlust)

  • In der Tabelle samples_cuckoo: Spalte „score“ hinzufügen (TEXT)

  • In der Tabelle samples_pedata: Spalten „company“, „product“, „version“ hinzufügen (TEXT)

  • Führen Sie /install aus (oder /rename_me_to_install)

  • Führen Sie den Storage-Migrator unter /src/tools/storage_segment.php aus

Migration: Von 6.0 zu 6.1

  • In der Tabelle samples: Spalte „processed“ hinzufügen (int, Standardwert: 1)

  • In der Tabelle samples_metas: Spalte „downloads_count“ hinzufügen (int, Standardwert: 0)

  • Wenn Sie den Cron verwenden: fügen Sie analysis_cron.php zur Cron-Tabelle hinzu, ein guter Wert wäre alle 5 Minuten

Migration: Von 6.1 zu 6.2 und Von 6.2 zu 7.0