View Source: WebCalendarPostgresql

Note: This page has been locked and cannot be edited.
The [WebCalendar System Administration  Guide|http://cvs.sourceforge.net/cgi-bin/viewcvs.cgi/*checkout*/webcalendar/webcalendar/docs/WebCalendar-SysAdmin.html?rev=HEAD&content-type=text/html] does not adequately explain how to set up ~WebCalendar to use the Postgresql database.  Here's some further info.

This is on Fedora Core 1 linux with Postgresql 7.3.4 and ~WebCalendar 0.9.45.

I assume you have the postgresql rpms installed.  Firs, run the following (as root) to start postgres and enable it on boot:

<verbatim>
# /sbin/chkconfig postgresql on
# /etc/init.d/postgresql start
</verbatim>

Now su to the postgres user to edit a few configuration files and load up the database tables.  Generally you need to perform database maintenance tasks as user postgres.

Edit  the file /var/lib/pgsql/data/postgresql.conf and add the line
<verbatim>
tcp_ip_socket=true
</verbatim>

Edit /var/lib/pgsql/data/pg_hba.conf and make it look like this:
<verbatim>
# TYPE  DATABASE    USER        IP-ADDRESS        IP-MASK           METHOD

local   all         all                                             trust
host    all         all         127.0.0.1         255.255.255.255   trust

# Using sockets credentials for improved security. Not available everywhere,
# but works on Linux, *BSD (and probably some others)

#local  all     all             ident   sameuser
</verbatim>
(i.e. comment out the 'ident' line' and uncomment the two lines that don't use 'ident')

Reload postgresql (still as user postgres):
<verbatim>
$ /usr/bin/pg_ctl -D /var/lib/pgsql/data/ restart
</verbatim>

Create a postgres user for the webcalendar database, and create the webcalendar database.
<verbatim>
$ createuser -A -D -P webcal
<type in a password for the webcal user>
$ createdb -O webcal webcal
</verbatim>

Load the tables into the database:
<verbatim>
$ psql -U webcal webcal
Welcome to psql 7.3.4-RH, the PostgreSQL interactive terminal.

Type:  \copyright for distribution terms
       \h for help with SQL commands
       \? for help on internal slash commands
       \g or terminate with semicolon to execute query
       \q to quit

webcalendar=> \i /var/www/html/webcal/tables-postgres.sql  (actually loads the tables)
webcalendar=> \d  (will list all the tables)
webcalendar=> \q  (quit psql)
</verbatim>

That's it, the database is now set up for webcalendar.   Use the admin web interface as described in the docs to point webcalendar at your database using the database name, username, and password you created above.

Note that this is probably not the most secure way to configure postgresql.

CategoryGeekStuff

CategoryLinuxStuff
View Source: WebCalendarPostgresql

Main Categories

Search

Toolbox

RecentChanges

Favorite Categories

Views
