{
case 1:
//DROP the rule that prohibits updates (change of spec).
- //$local_sql = "DROP RULE log_update";
- //$dbms->query($local_sql); //DISABLED FOR NEW ROLE LOG-tABLE ???
+ $local_sql = "DROP RULE log_update ON log";
+ $dbms->query($local_sql); //DISABLED FOR NEW ROLE LOG-tABLE ???
case 2:
//In the log table processed should be false by default
$dbms->query($local_sql);
case 9:
- $local_sql = "ALTER TABLE log_adv_kernel_network ADD COLUMN window TEXT";
- $dbms->query($local_sql);
-
$local_sql = "ALTER TABLE log_adv_kernel_network ADD COLUMN urgp INT";
$dbms->query($local_sql);
$dbms->query("DROP TABLE log_adv_daemon");
$dbms->query("DROP TABLE log_adv");
-//These columns have to be removed when a new version of PGSQL has become mainstream that supportsa DROP COLUMN
-/*
-TODO:
+ case 51:
-GRANT UPDATE ON action_user_actionstepid_seq TO GROUP ops, GROUP admin;
+ $local_sql = "INSERT INTO type_of_issue (name, suggested_priority, description, active)";
+ $local_sql .= " VALUES ('property out of range',5,'The DYNAMIC property of a parameter is out of range', true) ";
+ $dbms->query($local_sql);
+
+ $local_sql = "INSERT INTO parameter_class (name, property_name, description, property_type, notify)";
+ $local_sql .= " VALUES ('filesystem', 'device', 'Volume on which the filesystem resides', 'STATIC', 't')";
+ $dbms->query($local_sql);
+ $local_sql = "INSERT INTO parameter_class (name, property_name, description, property_type, notify)";
+ $local_sql .= " VALUES ('filesystem', 'size', 'Total size in kilobytes', 'STATIC', 't')";
+ $dbms->query($local_sql);
+ $local_sql = "INSERT INTO parameter_class (name, property_name, description, property_type, min, max, notify)";
+ $local_sql .= " VALUES ('filesystem', 'used', 'Number of kilobytes used', 'DYNAMIC', 0, 1000000, 't')";
+ $dbms->query($local_sql);
+ $local_sql = "INSERT INTO parameter_class (name, property_name, description, property_type, min, max, notify)";
+ $local_sql .= " VALUES ('filesystem', 'available', 'Number of kilobytes available', 'DYNAMIC', 1000, 1000000, 't')";
+ $dbms->query($local_sql);
+
+ case 52:
+
+ $local_sql = "INSERT INTO parameter_class (name, property_name, description, property_type, notify)";
+ $local_sql .= " VALUES ('filesystem', 'Inodes', 'Total number of i-nodes', 'STATIC', 't')";
+ $dbms->query($local_sql);
+ $local_sql = "INSERT INTO parameter_class (name, property_name, description, property_type, min, max, notify)";
+ $local_sql .= " VALUES ('filesystem', 'Iused', 'Number of i-nodes used', 'DYNAMIC', 0, 1000000, 't')";
+ $dbms->query($local_sql);
+ $local_sql = "INSERT INTO parameter_class (name, property_name, description, property_type, min, max, notify)";
+ $local_sql .= " VALUES ('filesystem', 'Ifree', 'Number of i-nodes available', 'DYNAMIC', 1000, 1000000, 't')";
+ $dbms->query($local_sql);
+
+ case 53:
+
+ $dbms->query("CREATE GROUP daemon");
+ $dbms->query("CREATE ROLE gnucomo LOGIN PASSWORD 'gnucomo' IN GROUP daemon");
+
+ $dbms->query("GRANT UPDATE ON action_user_actionstepid_seq TO GROUP ops, GROUP admin");
+
+ $dbms->query("GRANT INSERT ON property TO GROUP admin");
+ $dbms->query("GRANT UPDATE ON property TO GROUP admin");
+ $dbms->query("CREATE INDEX log_ab_src ON log_abuse (source, objectid)");
+ $dbms->query("CREATE UNIQUE INDEX log_ab_log ON log_abuse (logid)");
+ $dbms->query("GRANT INSERT ON action_user TO GROUP daemon");
+ $dbms->query("GRANT DELETE ON action_user TO GROUP daemon");
+ $dbms->query("GRANT INSERT ON log_abuse TO GROUP daemon");
+ $dbms->query("GRANT DELETE ON log_abuse TO GROUP daemon");
+ $dbms->query("GRANT SELECT ON log_abuse TO GROUP daemon");
+ $dbms->query("GRANT INSERT ON log_notification TO GROUP daemon");
+ $dbms->query("GRANT DELETE ON log_notification TO GROUP daemon");
+ $dbms->query("GRANT SELECT ON log_notification TO GROUP daemon");
+ $dbms->query("GRANT SELECT,INSERT,DELETE ON log TO GROUP daemon");
+ $dbms->query("GRANT SELECT,INSERT,DELETE ON notification TO GROUP daemon");
+ $dbms->query("GRANT SELECT,INSERT,DELETE,UPDATE ON parameter_class TO GROUP admin");
+ $dbms->query("GRANT SELECT,INSERT ON parameter TO GROUP daemon");
+ $dbms->query("GRANT SELECT,INSERT ON parameter_notification TO GROUP daemon");
+ $dbms->query("GRANT SELECT,INSERT ON history TO GROUP daemon");
+ $dbms->query("GRANT SELECT,INSERT,UPDATE ON object_abuse TO GROUP daemon");
+ $dbms->query("GRANT SELECT,INSERT,UPDATE ON object_statistics TO GROUP daemon");
+ $dbms->query("GRANT SELECT,INSERT,UPDATE ON property TO GROUP daemon");
+ $dbms->query("GRANT SELECT ON object_service TO GROUP daemon");
+ $dbms->query("GRANT SELECT ON object_user TO GROUP daemon");
+ $dbms->query("GRANT SELECT ON parameter_class TO GROUP daemon");
+ $dbms->query("GRANT SELECT ON service_pattern TO GROUP daemon");
+ $dbms->query("GRANT SELECT ON service TO GROUP daemon");
+ $dbms->query("GRANT SELECT ON type_of_issue TO GROUP daemon");
+ $dbms->query("GRANT SELECT ON usr TO GROUP daemon");
+ $dbms->query("GRANT SELECT,UPDATE ON notification_notificationid_seq TO GROUP daemon");
+ $dbms->query("GRANT SELECT,UPDATE ON db_value TO GROUP daemon");
+ $dbms->query("GRANT SELECT,UPDATE ON object TO GROUP daemon");
+ $dbms->query("GRANT UPDATE ON SEQUENCE action_user_actionstepid_seq TO daemon");
+ $dbms->query("GRANT UPDATE ON SEQUENCE log_logid_seq TO daemon");
+ $dbms->query("GRANT UPDATE ON SEQUENCE paramid_seq TO daemon");
+/*
+TODO:
*/
+//These columns have to be removed when a new version of PGSQL has become mainstream that supportsa DROP COLUMN
/*
$local_sql = "ALTER TABLE log DROP COLUMN recognized";
$dbms->query($local_sql);
- $local_sql = "ALTER TABLE logng DROP COLUMN recognized";
- $dbms->query($local_sql);
*/
}