Changeset 170 for trunk/docs/README.UPGRADE

Timestamp:

Apr 30, 2008, 11:56:45 PM (17 years ago)

Author:

katerina

Message:

Plenty of compiler warnings fixed, SQL query length fixed, doc update.

File:

• trunk/docs/README.UPGRADE (modified) (1 diff)

trunk/docs/README.UPGRADE

@@ -1 +1 @@
 
+to 2.4.4 and higher: it is possible now to store the full content of
+  small files in the baseline database. To support this feature with
+  logging to an RDBMS, the DB schema for Oracle needs to be adjusted
+  by converting the link_old, link_new columns from VARCHAR2 to CLOB:
+
+  -- Oracle:
+      ALTER TABLE samhain.log ADD tmp_name CLOB;
+      UPDATE samhain.log SET tmp_name=link_old;
+      ALTER TABLE samhain.log DROP COLUMN link_old;
+      ALTER TABLE samhain.log RENAME COLUMN tmp_name to link_old;
+
+      ALTER TABLE samhain.log ADD tmp_name CLOB;
+      UPDATE samhain.log SET tmp_name=link_new;
+      ALTER TABLE samhain.log DROP COLUMN link_new;
+      ALTER TABLE samhain.log RENAME COLUMN tmp_name to link_new;
+
+  -- Samhain server (yule): if you are logging to the RDBMS via
+     the server (yule), as recommended, you need to also upgrade the 
+     server, because earlier versions had a too restrictive limit on 
+     the maximum length of an SQL query.
+
+    
 to 2.3.3 and higher: a bug has been fixed that resulted in an additional
   slash at the beginning of the linked path of symlinks in the root