Added index creation to database creation script.

[mir.git] / doc / INSTALL.mir

diff --git a/doc/INSTALL.mir b/doc/INSTALL.mir
index fdc33f9..d74d5ec 100755 (executable)
--- a/doc/INSTALL.mir
+++ b/doc/INSTALL.mir
@@ -57,12 +57,19 @@ as user postgres:
 8. create base table
        psql -Upostgres dbname < dbscripts/create_pg.sql
        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. restart tomcat 
+10. chmod 777 Mir/log 
 
-11. configure mod_jk 
+11. restart tomcat 
+
+12. configure mod_jk 
 
 insert the following patch into /etc/apache/httpd.conf. Edit the directories
 to suit your needs.
@@ -77,6 +84,36 @@ Do not put any JkMount lines into your httpd.conf!
 If mod_jk.conf-auto doesn't get written or is 0 bytes in size, check your
 system for file ownership/permissions problems.
 
+
+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:
+
+# psql -U postgres Mir
+alter user postgres with password 'yourpassword';
+
+
+Then, in /etc/postgresql/pg_hba.conf you should make sure that nobody can
+use the database without a password:
+
+local           all                                                                               password
+host         all         127.0.0.1     255.0.0.0           password
+host         all         0.0.0.0       0.0.0.0             reject
+
+
+Then, change the database password line in config.properties:
+
+Database.Username=postgres
+Database.Password=yourpassword
+
+You should make sure that no copy of config.properties (neither in mir nor
+in Mir/src nor in Mir/WEB-INF/classes) is world-readable. Else you wouldn't
+have to install a password, anyway.
+
+If you can't access PostgreSQL after this for any reason, try to change
+"password" in /etc/postgresql/pg_hba.conf into "trust". This should disable
+any authentication method and make the database accessible again.
+
 that's it :)
 
 now the admin-application is accesable via: