How to add disk arrays after snconnect has been installed

How to add storage arrays to a SNconnect that doesn't show the desired arrays in the dashboard view. This comes from the BOM not including all the storage in the .fw file used during the inital install.

Here is an example of the DashBoard showing 2 array but customer wants to see more.

Since the psql script is array specific I'm providing examples of by array type.

###Example of adding a DH 424 array with 10.1.10.126 and 10.1.10.128 IP addresses:

SELECT variable_name, variable_value, created_date, modified_date, created_by_id, modified_by_id FROM mint_setting;
INSERT INTO mint_setting (variable_name,variable_value,created_date,modified_date,created_by_id,modified_by_id) VALUES ('qxsTypes','424','2016-01-08 10:42:29-06','2016-01-08 10:42:29-06',0,0);
INSERT INTO mint_setting (variable_name,variable_value,created_date,modified_date,created_by_id,modified_by_id) VALUES ('qxs_424_RAIDArraysTotal','1','2016-01-08 10:42:29-06','2016-01-08 10:42:29-06',0,0);
INSERT INTO mint_setting (variable_name,variable_value,created_date,modified_date,created_by_id,modified_by_id) VALUES ('qxs424-0-name','xcellis-md','2016-01-08 10:42:29-06','2016-01-08 10:42:29-06',0,0);
INSERT INTO mint_setting (variable_name,variable_value,created_date,modified_date,created_by_id,modified_by_id) VALUES ('qxs424-0-a','10.1.10.126','2016-01-08 10:42:29-06','2016-01-08 10:42:29-06',0,0);
INSERT INTO mint_setting (variable_name,variable_value,created_date,modified_date,created_by_id,modified_by_id) VALUES ('qxs424-0-b','10.1.10.128','2016-01-08 10:42:29-06','2016-01-08 10:42:29-06',0,0);
SELECT variable_name, variable_value, created_date, modified_date, created_by_id, modified_by_id FROM mint_setting;

###Example of a QXS1200 array

###Example of 4844 DotHill Array

Updated script to add the current time to the QXS entries when adding them to the DB.

Sample entry:

INSERT INTO mint_setting (variable_name,variable_value,created_date,modified_dat

e,created_by_id,modified_by_id) VALUES ('qxsTypes','464',now(),now(),0,0);

INSERT INTO mint_setting (variable_name,variable_value,created_date,modified_dat

e,created_by_id,modified_by_id) VALUES ('qxs_464_RAIDArraysTotal','1',now(),now(

),0,0);

INSERT INTO mint_setting (variable_name,variable_value,created_date,modified_dat

e,created_by_id,modified_by_id) VALUES ('qxs464-0-name','MPE-MDS',now(),now(),0,

0);

INSERT INTO mint_setting (variable_name,variable_value,created_date,modified_dat

e,created_by_id,modified_by_id) VALUES ('qxs464-0-a','172.24.3.153',now(),now(),

0,0);

Uses now(), so the current time is part of the created_date and modified_date fields.

Adding Multiple Arrays:

SELECT variable_name, variable_value, created_date, modified_date, created_by_id, modified_by_id FROM mint_setting;

INSERT INTO mint_setting (variable_name,variable_value,created_date,modified_date,created_by_id,modified_by_id) VALUES ('qxsTypes','1200,5600','2016-01-08 10:42:29-06','2016-01-08 10:42:29-06',0,0);

INSERT INTO mint_setting (variable_name,variable_value,created_date,modified_date,created_by_id,modified_by_id) VALUES ('qxs_1200_RAIDArraysTotal','4','2016-01-08 10:42:29-06','2016-01-08 10:42:29-06',0,0);

INSERT INTO mint_setting (variable_name,variable_value,created_date,modified_date,created_by_id,modified_by_id) VALUES ('qxs1200-0-name','qxs1','2016-01-08 10:42:29-06','2016-01-08 10:42:29-06',0,0);

INSERT INTO mint_setting (variable_name,variable_value,created_date,modified_date,created_by_id,modified_by_id) VALUES ('qxs1200-0-a','10.192.64.46','2016-01-08 10:42:29-06','2016-01-08 10:42:29-06',0,0);
INSERT INTO mint_setting (variable_name,variable_value,created_date,modified_date,created_by_id,modified_by_id) VALUES ('qxs1200-0-b','10.192.64.46','2016-01-08 10:42:29-06','2016-01-08 10:42:29-06',0,0);

INSERT INTO mint_setting (variable_name,variable_value,created_date,modified_date,created_by_id,modified_by_id) VALUES ('qxs1200-1-name','qxs2','2016-01-08 10:42:29-06','2016-01-08 10:42:29-06',0,0);

INSERT INTO mint_setting (variable_name,variable_value,created_date,modified_date,created_by_id,modified_by_id) VALUES ('qxs1200-1-a','10.192.64.48','2016-01-08 10:42:29-06','2016-01-08 10:42:29-06',0,0);
INSERT INTO mint_setting (variable_name,variable_value,created_date,modified_date,created_by_id,modified_by_id) VALUES ('qxs1200-1-b','10.192.64.48','2016-01-08 10:42:29-06','2016-01-08 10:42:29-06',0,0);

INSERT INTO mint_setting (variable_name,variable_value,created_date,modified_date,created_by_id,modified_by_id) VALUES ('qxs1200-2-name','qxs3','2016-01-08 10:42:29-06','2016-01-08 10:42:29-06',0,0);

INSERT INTO mint_setting (variable_name,variable_value,created_date,modified_date,created_by_id,modified_by_id) VALUES ('qxs1200-2-a','10.192.64.50','2016-01-08 10:42:29-06','2016-01-08 10:42:29-06',0,0);
INSERT INTO mint_setting (variable_name,variable_value,created_date,modified_date,created_by_id,modified_by_id) VALUES ('qxs1200-2-b','10.192.64.50','2016-01-08 10:42:29-06','2016-01-08 10:42:29-06',0,0);

INSERT INTO mint_setting (variable_name,variable_value,created_date,modified_date,created_by_id,modified_by_id) VALUES ('qxs1200-3-name','qxs4','2016-01-08 10:42:29-06','2016-01-08 10:42:29-06',0,0);

INSERT INTO mint_setting (variable_name,variable_value,created_date,modified_date,created_by_id,modified_by_id) VALUES ('qxs1200-3-a','10.192.64.52','2016-01-08 10:42:29-06','2016-01-08 10:42:29-06',0,0);
INSERT INTO mint_setting (variable_name,variable_value,created_date,modified_date,created_by_id,modified_by_id) VALUES ('qxs1200-3-b','10.192.64.52','2016-01-08 10:42:29-06','2016-01-08 10:42:29-06',0,0);

INSERT INTO mint_setting (variable_name,variable_value,created_date,modified_date,created_by_id,modified_by_id) VALUES ('qxs_5600_RAIDArraysTotal','3','2016-01-08 10:42:29-06','2016-01-08 10:42:29-06',0,0);

INSERT INTO mint_setting (variable_name,variable_value,created_date,modified_date,created_by_id,modified_by_id) VALUES ('qxs5600-0-name','xcellis-data1','2016-01-08 10:42:29-06','2016-01-08 10:42:29-06',0,0);

INSERT INTO mint_setting (variable_name,variable_value,created_date,modified_date,created_by_id,modified_by_id) VALUES ('qxs5600-0-a','10.192.64.111','2016-01-08 10:42:29-06','2016-01-08 10:42:29-06',0,0);
INSERT INTO mint_setting (variable_name,variable_value,created_date,modified_date,created_by_id,modified_by_id) VALUES ('qxs5600-0-b','10.192.64.111','2016-01-08 10:42:29-06','2016-01-08 10:42:29-06',0,0);

INSERT INTO mint_setting (variable_name,variable_value,created_date,modified_date,created_by_id,modified_by_id) VALUES ('qxs5600-1-name','xcellis-data2','2016-01-08 10:42:29-06','2016-01-08 10:42:29-06',0,0);

INSERT INTO mint_setting (variable_name,variable_value,created_date,modified_date,created_by_id,modified_by_id) VALUES ('qxs5600-1-a','10.192.64.112','2016-01-08 10:42:29-06','2016-01-08 10:42:29-06',0,0);
INSERT INTO mint_setting (variable_name,variable_value,created_date,modified_date,created_by_id,modified_by_id) VALUES ('qxs5600-1-b','10.192.64.112','2016-01-08 10:42:29-06','2016-01-08 10:42:29-06',0,0);

INSERT INTO mint_setting (variable_name,variable_value,created_date,modified_date,created_by_id,modified_by_id) VALUES ('qxs5600-2-name','xcellis-data3','2016-01-08 10:42:29-06','2016-01-08 10:42:29-06',0,0);

INSERT INTO mint_setting (variable_name,variable_value,created_date,modified_date,created_by_id,modified_by_id) VALUES ('qxs5600-2-a','10.192.64.113','2016-01-08 10:42:29-06','2016-01-08 10:42:29-06',0,0);
INSERT INTO mint_setting (variable_name,variable_value,created_date,modified_date,created_by_id,modified_by_id) VALUES ('qxs5600-2-b','10.192.64.113','2016-01-08 10:42:29-06','2016-01-08 10:42:29-06',0,0);

SELECT variable_name, variable_value, created_date, modified_date, created_by_id, modified_by_id FROM mint_setting;

After the script is written you must run it as the postgres user.

The example script is named psql.qxs.add.sql.txt and the following command is used to enter the snconnect DB and insert the data needed into the correct tables.

#   sudo su - postgres
-bash-4.1$      psql connect_db < /tmp/psql.qxs.add.sql.txt
-bash-4.1$      exit

This functionality has been added into a SNC app: