Securing-Optimizing-RH-Linux-1_2_412
Comments and suggestions concerning this book should be mailed to gmourani@videotron.ca
© Copyright 1999-2000 Gerhard Mourani and Open Network Architecture ®
412
Step 3
Once the httpd user www has been included in PostgreSQL, log as the user your PostgreSQL
database runs as, in our case postgres then insert the small script related to PostgreSQL to
create automatically the Webmail IMP database in PostgreSQL.
·
To create automatically Webmail IMP database in PostgreSQL, use the following
commands:
[root@deep /]# cd /home/httpd/horde/imp/config/scripts/
[root@deep scripts]# su postgres
[postgres@deep scripts]$ psql template1 < pgsql_create.sql
// IMP database creation script for postgreSQL
// Author: barce@lines.edu
// Date: Aug-29-1998
// Notes: replace "nobody" with yours httpd username
// Run using: psql template1 < pgsql_create.sql
CREATE DATABASE horde;
CREATEDB
\connect horde
connecting to new database: horde
CREATE TABLE imp_pref (
username text,
sig text,
fullname text,
replyto text,
lang varchar(30)
);
CREATE
CREATE TABLE imp_addr (
username text,
address text,
nickname text,
fullname text
);
CREATE
GRANT SELECT, INSERT, UPDATE ON imp_pref, imp_addr TO www;
CHANGE
EOF
Step 4
We must restart PostgreSQL server for the changes to take effect:
·
To restart PostgreSQL, use the following commands:
[root@deep /]# /etc/rc.d/init.d/postgresql restart
Stopping postgresql service: [ OK ]
Checking postgresql installation: looks good!
Starting postgresql service: postmaster [13474]
Step 5
Copy and rename the file "/home/httpd/horde/phplib/horde_phplib.inc" to
"/home/httpd/php/local.inc", then edit the new "local.inc" file which is your phplib configuration file