Adlice Software.

Migración

Migración: De 4.X a 4.3

  • TABLA storage_metas, COLUMNA value: Cambiar el tipo de TEXT a LONGTEXT.

Migración: De 4.3 a 5.X

  • Actualizar los requisitos previos:
sudo pip install oletools pdfminer
  • Actualizar Usercake:
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');

  • Ejecutar el instalador (para crear el nuevo esquema), restaurando la carpeta “install” y luego navegando a la raíz

  • **Ejecutar la migración: **(Ejecute estas consultas)

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;

  • Modificar la ubicación del script de Cron (de /src/cron.php a /cron.php)

  • Eliminar las tablas antiguas: samples, samples_metas (cuando esté seguro de que la migración se ha completado)

Migración: De 5.0 a 5.1

  • Instalar peepdf
pip install peepdf

Migración: De 5.1 a 6.0

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

  • En la tabla samples_metas: eliminar la columna “comment” (pérdida de datos)

  • En la tabla samples_cuckoo: añadir la columna “score” (TEXT)

  • En la tabla samples_pedata: añadir las columnas “company”, “product”, “version” (TEXT)

  • Ejecutar /install (o /rename_me_to_install)

  • Ejecutar el migrador de almacenamiento en /src/tools/storage_segment.php

Migración: De 6.0 a 6.1

  • En la tabla samples: añadir la columna “processed” (int, valor predeterminado: 1)

  • En la tabla samples_metas: añadir la columna “downloads_count” (int, valor predeterminado: 0)

  • Si utiliza el Cron: añadir analysis_cron.php a la tabla cron, un buen valor sería cada 5 min

Migración: De 6.1 a 6.2 y De 6.2 a 7.0