Changeset 481 for trunk/docs/README.UPGRADE

Timestamp:

Jul 18, 2015, 5:06:52 PM (9 years ago)

Author:

katerina

Message:

Enhancements and fixes for tickets #374, #375, #376, #377, #378, and #379.

File:

• trunk/docs/README.UPGRADE (modified) (2 diffs)

trunk/docs/README.UPGRADE

@@ +1 @@
+to 4.0.0 and higher: if you use "ReportCheckflags = yes" (off by default),
+  you need to change the database scheme:
+
+  -- mysql:
+          ALTER TABLE samhain.log ADD COLUMN checkflags_old BIGINT UNSIGNED;
+          ALTER TABLE samhain.log ADD COLUMN checkflags_new BIGINT UNSIGNED;
+
+  -- postgres:
+          ALTER TABLE samhain.log ADD COLUMN checkflags_old NUMERIC(20); 
+          ALTER TABLE samhain.log ADD COLUMN checkflags_new NUMERIC(20);
+
+  --oracle:
+          ALTER TABLE samhain.log ADD checkflags_old NUMBER(20); 
+          ALTER TABLE samhain.log ADD checkflags_new NUMBER(20); 
+
 to 2.8.0 and higher: samhain supports IPv6 now, which means that the
   size of the 'ip' column in the database must be increased from
@@ -40 +55 @@
   -- this may cause spurious warnings about modified links, if you check
      against a database created with an earlier version of samhain 
-
-
 
 from lower to 2.3.x: the database scheme has changed slightly.