|
Installation
Create a MySQL databaseCreate 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 schemeUnzip 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 serverInstall 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 authenticationTo 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 usersFor 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 |