Fedora16 with horde

Amazing, I have got horde with a postgres backend to work on Fedora16.

Links:

• https://fedorahosted.org/spacewalk/wiki/PostgreSQLServerSetup  -- helped with installing postgres and setting the permissions for accessing the database.
• http://forum.parallels.com/showthread.php?t=74634 -- php.ini change to pickup modules.  I'm using x86_64 so I guess things went wrong with the 'lib64' path not being included?
• http://wiki.kolab.org/Configure_Horde_with_PostgreSQL -- example postgres configuration with horde.
• http://www.horde.org/apps/horde/docs/UPGRADING -- Horde Upgrade Instructions

Install Postgres:

yum install php-pgsql postgresql postgresql-server
chkconfig postgresql on
postgresql-setup initdb
service postgresql start
su - postgres
cp /usr/share/horde/scripts/sql/create.pgsql.sql .
vim create.pgsql.sql  -- (set a password for the horde user)
psql -d template1 -f create.pgsql.sql
(if all the tables and indexes don't fly up the screen as they are created then you have a problem.  For me it took awhile to get pg_hba.conf correct.  See supplementary points below.)
exit  -- (return to the root user)
psql -h 127.0.0.1 -p 5432 -U horde -d horde  -- (to test logging into the horde database as the horde user.)
rm /var/lib/pgsql/create.pgsql.sql

Supplementary Points:

• Horde is out of date in the Fedora16 repository!  I persisted thinking that things will be easier if I use the Fedora packages :-(
• http://your-server/horde/test.php -- is not working and the doco I have found so far is not relevant for activating the test feature.
• Turn off selinux as the provided policies are not good enough.  (Now that I've saved you some time maybe you can work on the selinux policies for me???)
• Add the following to /etc/php.ini and service httpd restart for fedora16_x86-64:
• extension_dir = "/usr/lib64/php/modules"
•  Add the following to /var/lib/pgsql/data/pg_hba.conf before the "local all all peer" line to allow the horde database user to login via a localhost TCP socket.  Don't forget to reload the database configuration service postgresql reload :

local horde horde md5
host  horde horde 127.0.0.1/8 md5
host  horde horde ::1/128 md5
local horde postgres  ident

• Clean out the postgres database to retry the horde initialisation:

su - postgres
psql
DROP DATABASE horde;
DROP USER horde;