Test

From af4410ddc9f186482684164837b7a2926c115574 Mon Sep 17 00:00:00 2001 From: mj Date: Tue, 2 Oct 2001 09:52:25 +0000 Subject: [PATCH] Added index creation to database creation script. Enhanced the debugging versions of the posting_dupe.template Put info to install dupe prevention trigger into INSTALL.mir --- dbscripts/create_pg.sql | 5 +++- doc/INSTALL.mir | 14 ++++++--- templates-dist/de/open/posting_dupe.template | 44 ++++++++++++++++++++++++---- templates-dist/open/posting_dupe.template | 44 ++++++++++++++++++++++++---- 4 files changed, 92 insertions(+), 15 deletions(-) diff --git a/dbscripts/create_pg.sql b/dbscripts/create_pg.sql index 530591e8..9173fdf5 100755 --- a/dbscripts/create_pg.sql +++ b/dbscripts/create_pg.sql @@ -359,10 +359,13 @@ CREATE TABLE "content" ( "is_mail_sent" boolean DEFAULT '1' NOT NULL, "is_digest_sent" boolean DEFAULT '1' NOT NULL, "to_article_type" smallint DEFAULT '0' NOT NULL, - "to_content" integer + "to_content" integer, + "checksum" integer ) INHERITS ("media"); +CREATE INDEX content_checksum_index ON content (checksum); + -- -- TOC Entry ID 30 (OID 29418) -- diff --git a/doc/INSTALL.mir b/doc/INSTALL.mir index b35d9a23..d74d5ecd 100755 --- a/doc/INSTALL.mir +++ b/doc/INSTALL.mir @@ -59,11 +59,17 @@ as user postgres: cat dbscript/help*.sql | psql -Upostgres dbname cat dbscript/populate*.sql | psql -Upostgres dbname -9. chmod 777 Mir/log +9. Add the dupe prevention trigger to the database: + cd dbscripts/dupetrigger + + There, read INSTALL and follow the instructions. + + +10. chmod 777 Mir/log -10. restart tomcat +11. restart tomcat -11. configure mod_jk +12. configure mod_jk insert the following patch into /etc/apache/httpd.conf. Edit the directories to suit your needs. @@ -79,7 +85,7 @@ If mod_jk.conf-auto doesn't get written or is 0 bytes in size, check your system for file ownership/permissions problems. -12. Add a password to your PostgreSQL user and link it to Mir (optional) +13. Add a password to your PostgreSQL user and link it to Mir (optional) Add a hard to guess password to the PostgreSQL user database: diff --git a/templates-dist/de/open/posting_dupe.template b/templates-dist/de/open/posting_dupe.template index 2ea225b8..d8b5d20a 100755 --- a/templates-dist/de/open/posting_dupe.template +++ b/templates-dist/de/open/posting_dupe.template @@ -1,9 +1,43 @@ + + -Test + indymedia.de | open posting - Posting-Duplikat - -

-Dupe + + + + + + + + + + + + +
+ + Immer ruhig mit den jungen Pferden! + +
+ +
+ Du hast vermutlich den Reload-Button + benutzt oder versucht, Deinen Artikel noch einmal zu posten. Das ist aber + unnötig. Die Tatsache, dass Du diesen Text liest, bedeutet, dass Dein + Posting schon angekommen ist. Er wird gleich auf der Seite auftauchen. Versprochen. +
+ Technischer Hintergrund ist, daß de.indy über einen + Proxy-Server läuft und der ist nicht immer minuten-aktuell. +
+ Keine Panik
+
+ +
+ >> Zurück +
+ - \ No newline at end of file + diff --git a/templates-dist/open/posting_dupe.template b/templates-dist/open/posting_dupe.template index 2ea225b8..d8b5d20a 100755 --- a/templates-dist/open/posting_dupe.template +++ b/templates-dist/open/posting_dupe.template @@ -1,9 +1,43 @@ + + -Test + indymedia.de | open posting - Posting-Duplikat - -