My favorites | Sign in
Project Home Downloads Wiki Issues Source
READ-ONLY: This project has been archived. For more information see this post.
Search
for
Installation  
Updated Aug 15, 2011 by mat...@muhonen.net

Create a MySQL database

Create a new MySQL database by logging into MySQL as the root user. Use the command mysql -uroot -p for this. On the MySQL console, give the following commands to create a database named timelet with the password timelet:

CREATE DATABASE timelet;
GRANT ALL ON timelet.* to ‘timelet’@localhost IDENTIFIED BY ‘timelet’;
FLUSH PRIVILEGES;

Install the database scheme

Unzip timelet to a directory and install the database scheme by running the following command in the directory you unzipped timelet to:

mysql -utimelet -ptimelet timelet < sql/setup.sql

If you get errors in this stage, make sure the database was correctly created.

Install timelet to a HTTP server

Install the Apache HTTP server, PHP and the PEAR DB package. Unzip timelet to a directory, which is served by Apache. If you created a database with a different name or password, modify inc/prepend.php and make sure the database settings match the created database (line 40):

class Settings {
        function get_db_dsn() {
                return "mysql://timelet:timelet@localhost/timelet";
        }
}

Make sure the base URL in config.inc.php matches the URL you installed timelet to. For example, if you installed Timelet to http://example.org/timelet/, baseurl should contain:

$config['baseurl'] = '/timelet';

In this stage, Timelet should respond, if you go to the URL where you installed Timelet to.

Enable HTTP basic authentication

To require an authentication for accessing timelet, enable the HTTP basic authentication in Apache. Create a .htaccess file in the directory you installed Timelet to:

AuthType Basic
AuthName "timelet"
AuthUserFile /usr/local/apache/passwd/passwords
Require valid-user

Create a password file:

touch /usr/local/apache/passwd/passwords

Create users

For each Timelet user, you need to do the following:

1. Create the user in Timelet's database. Log in to the MySQL console and create the user by the following command:

INSERT INTO users(username, firstname, lastname) VALUES('myuser', 'Firstname', 'Lastname');

2. Create a password to Apache's password file you defined in .htaccess:

htpasswd /usr/local/apache/passwd/passwords myuser
Powered by Google Project Hosting