PostgreSQL Config
From DAViCal Wiki
Some things to check in your PostgreSQL configuration are:
Contents |
pg_hba.conf
The PostgreSQL pg_hba.conf file is used to control access to the PostgreSQL database. DAViCal needs the web user to be set up to access the database and for security reasons this is a different database user from the one which owns the database.
Changes to pg_hba.conf to allow the 'davical_dba' and 'davical_app' users to connect
The pg_hba.conf file is parsed from top to bottom by PostgreSQL and the first matching rule is the one that applies. This means that if you want to add a rule allowing the 'davical_app' and 'davical_dba' users access to the DAViCal database you probably need to add it fairly early in the file, rather than appending it at the bottom.
See Database/Users for more information about setting up the 'davical_app' and 'davical_dba' users.
Installations prior to 0.9.4
In installations prior to 0.9.4 the database user used by the application was called 'general', rather than 'davical_app'. Installations prior to 0.9.3 the default database name was 'rscds' rather than 'davical'. These changes should be taken into consideration when reading the current documentation.
If your database is currently named in this way then there should really be no need to change it. You will very likely want to create a configuration file for the update-davical-database program however.
Changes to pg_hba.conf to allow the 'general' user to connect
The pg_hba.conf file is parsed from top to bottom by PostgreSQL and the first matching rule is the one that applies. This means that if you want to add a rule allowing the user 'general' access to the RSCDS database you probably need to add it fairly early in the file, rather than appending it at the bottom.
