[cks-devl] success report and doc patch

[Simon Josefsson]

I've installed the CVS version of CKS successfully, the patch below to
INSTALL documents some of the details.

Searching using email address is rather slow though.  I noticed the
public CKS server also was slow.  Any thoughts on how to improve the
speed?  I guess it is a database problem.

Index: INSTALL
===================================================================
RCS file: /cvsroot/cks/cks/INSTALL,v
retrieving revision 1.4
diff -u -p -r1.4 INSTALL
--- INSTALL     28 Mar 2002 18:16:37 -0000      1.4
+++ INSTALL     4 Aug 2002 00:17:26 -0000
@@ -9,7 +9,7 @@ install' before the final beta is releas
 Compiling the programs: 
 -----------------------
 Put the IP and db info in the cks_config.c file or copy cks.conf
-in the software archive into /usr/local/etc and edit that file.
+in the software archive into /etc and edit that file.
 run ./configure;make
 (Do not run make install)
 
@@ -26,9 +26,29 @@ used by your database.  You will need th
 
 Steps to setting up the database:
 
-change user to web server user in cks_sql
-create db called openpgp_keys and pguser named for your web server user
-run cks.sql in psql
+1. change user to web server user in cks.sql
+
+$ perl -pi -e 's/nobody/www-data/g' cks.sql
+
+2. create db called openpgp_keys and pguser named for your web server user
+
+# su postgres
+$ createdb -E SQL_ASCII openpgp_keys
+$ createuser --no-createdb --no-adduser www-data
+
+3. run cks.sql in psql
+
+# su www-data
+$ psql openpgp_keys
+...
+\i cks.sql
+
+4. set up pg_hba.conf to allow connections
+
+# cat>>/etc/postgresql/pg_hba.conf
+local        openpgp_keys                                  trust
+host         openpgp_keys        127.0.0.1    255.255.255.255       trust
+^D
 
 Setting up the server:
 ---------------------