Webapplication plugin migration to GLPI 9.5.2 core

glpi.al · 2020-10-13 12:39:11

Hi,
migrating the webapplication plugin to the core doesn't mantain the "Associated Items" in the new "Item" tab.
Best Regards.

mboot59 · 2020-10-20 19:23:36

yes i was about to complain about the same

J2C99 · 2020-11-04 15:48:17

Yes, I confirm too

The column helpdisk_item_type from glpi_profiles is empty , it doesn't contains "PluginWebapplicationsWebapplication" or equivalence (normaly it must be Webapplication after the migration).
I'm looking for the table with the list of all 'Associated Items'.

mboot59 · 2020-12-04 19:39:21

Before the update to 9.5 make a backup of the tables: with

<code>
<?php

// create backup of all glpi_plugin_webapplication tables

ini_set("memory_limit", "-1");
ini_set("max_execution_time", "0");

define("GLPI_ROOT", '/home/mboot/public_html/glpi');

include (GLPI_ROOT . '/inc/includes.php');

function backup_webapps() {
global $DB;

$migration = new Migration("");

$sql = "
SHOW TABLES LIKE
'glpi_plugin_webapplication%'
";
foreach ($DB->request($sql) as $data) {
foreach( $data as $key => $val ) {
print_r($val);
$migration -> copyTable($val, "backup_{$val}");
echo "\n";
}
}
}

function main()
{
backup_webapps();
exit(0);
}

main();
<cdode>

after installing 9.5.3 and running the iinternal migration for werapps to appliances run additional::

<code>
<?php

// create backup of all glpi_plugin_webapplication tables

ini_set("memory_limit", "-1");
ini_set("max_execution_time", "0");

define("GLPI_ROOT", '/home/mboot/public_html/glpi-953');

include (GLPI_ROOT . '/inc/includes.php');

function verify_tables()
{
global $DB;

$tables = [
"glpi_appliances",
"backup_glpi_plugin_webapplications_webapplications",
"backup_glpi_plugin_webapplications_webapplications_items",
];
foreach($tables as $index => $table) {
if( !$DB->tableExists($table) ) {
echo "FATAL: we have no table {$table}\n";
exit(101);
}
}
}

function iter_webapps_link_items() {
global $DB;

verify_tables();

// what we actually need is the matching a_id, with wi.items_id and wi.itemtype
// so we can insert the assoc_link between appliance and item(itemtype)

// wi.plugin_webapplications_webapplications_id as app_id,

$sql = <<<EOS
SELECT
wi.items_id,
wi.itemtype,
a.id as a_id

FROM
backup_glpi_plugin_webapplications_webapplications_items wi
LEFT JOIN
backup_glpi_plugin_webapplications_webapplications wa
ON
wi.plugin_webapplications_webapplications_id = wa.id
LEFT JOIN
glpi_appliances a
ON
wa.name = a.name

WHERE wa.is_deleted = 0
AND wa.entities_id = a.entities_id
AND wa.is_recursive = a.is_recursive
AND wa.locations_id = a.locations_id
AND wa.users_id_tech = a.users_id_tech
AND wa.groups_id_tech = a.groups_id_tech

EOS;

foreach ($DB->request($sql) as $data) {
print_r($data);

$items_id = $data['items_id'];
$itemtype = $data['itemtype'];
$appliance_id = $data['a_id'];

$sql = <<<EOS
INSERT INTO
glpi_appliances_items
(
appliances_id,
items_id,
itemtype
) VALUES (
'{$appliance_id}',
'{$items_id}',
'{$itemtype}'
)
EOS;
echo "($items_id,$itemtype,$appliance_id)\n";

$DB->request($sql);
}
}

function main()
{
iter_webapps_link_items();
exit(0);
}

main();
</code>

this links all the migrated web-apps to the assets (items)

Last edited by mboot59 (2020-12-04 19:42:44)

mboot59 · 2020-12-04 19:41:52

note for the above, i have also certificates linked to webapps , that is currently not migratable as there is no certificate tab nor is certificate linkable in the dropdown

Forum GLPI-Project

Announcement

#1 2020-10-13 12:39:11

Webapplication plugin migration to GLPI 9.5.2 core

#2 2020-10-20 19:23:36

Re: Webapplication plugin migration to GLPI 9.5.2 core

#3 2020-11-04 15:48:17

Re: Webapplication plugin migration to GLPI 9.5.2 core

#4 2020-12-04 19:39:21

Re: Webapplication plugin migration to GLPI 9.5.2 core

#5 2020-12-04 19:41:52

Re: Webapplication plugin migration to GLPI 9.5.2 core

Board footer