[ Contents | << Previous | Next >> ]
Kalendus uses MySQL as its database backend. (Alternate databases such as PostgreSQL are in the works.)
You have a MySQL database server running.
Create the MySQL database to use. This can be named whatever you like; I will assume 'calendar'.
Create the MySQL user for the Kalendus scripts to login as. This user must have read and write access (select, insert, update, delete). I will use the 'kalendus' user, and assume the mysql database server is running on 'mysql.example.com' and the apache server is running on 'www.example.com'.
prompt> mysql -h mysql.example.com -u root -p Enter password: **** mysql> CREATE DATABASE calendar; mysql> GRANT select, insert, update, delete ON calendar.* TO kalendus@www.example.com IDENTIFIED BY 'password';
In order to connect to the MySQL database, the mysql server hostname, database, username and password must be stored in the cgi-bin/calendar/KalendusConfig.pm file.
$db_database = 'calendar'; $db_hostname = 'mysql.example.com'; $db_username = 'kalendus'; $db_password = 'password';
The install/tables.mysql file contains the definitions of all the tables that Kalendus needs.
The install/data.en.sql file contains the initial data such as month and weekday names, in English.
These can either be redirected into the mysql command line client, as shown below, or simply pasted into a mysql client such as phpmyadmin.
To create the tables, the user must have create priveleges, so the 'kalendus' user created above may not work. Use the root user or some other user that has create priveleges for the 'calendar' database.
prompt> mysql -h mysql.example.com -u root -p calendar < tables.sql Enter password: **** prompt> mysql -h mysql.example.com -u root -p calendar < data.en.sql Enter password: ****