Installation of TBDev (torrent tracker)

Install PHP GD for captcha

yum install php-gd

Create virtual host with following PHP settings:

php_value memory_limit      16M
php_value error_reporting   E_ALL^E_NOTICE
php_flag  log_errors        on
php_flag  report_memleaks   on
php_flag  short_open_tag    on
php_flag  register_globals  off
php_flag  magic_quotes_gpc  off
php_flag  allow_url_fopen   on
php_flag  display_errors    on
php_flag  display_startup_errors on
php_flag  file_uploads        on
php_value upload_max_filesize 8M

Define default character set for this virtual host

AddDefaultCharset windows-1251

Download TBDev 2.1.4 from tbdev development site and extract into a server directory or checkout svn. Run mysql and create a new database

create database tbdev_db default character set cp1251 collate cp1251_general_ci;
create user tbdev_user@localhost identified by 'tbdev_pass';
grant all privileges on tbdev_db.* to tbdev_user@localhost;

Note the SQL folder with a single file database.sql. Load the default structure:

(echo "set names cp1251;" ; cat SQL/database.sql)  | mysql -utbdev_user -ptbdev_pass tbdev_db

Edit the include/secrets.php file:

$mysql_host = "localhost";
$mysql_user = "tbdev_user";
$mysql_pass = "tbdev_pass";
$mysql_db = "tbdev_db";
$mysql_charset = "cp1251";  // don't change this

Randomize cookie generator. Edit include/init.php, find the following line and replace empty salt by a random value

define ('COOKIE_SALT', );

Secure the config files:

chown root:apache include/secrets.php include/init.php
chmod 640 include/secrets.php include/init.php

Configure default theme in include/config.php (diff)

Grant apache permission to upload torrents

chown apache ./torrents

Now restart apache and point yout browser to the new virtual server. The first registered user becomes administrator (note that e-mail verification does not happen for him). You are ready to upload torrents.
I then changed block visibility:

Block State Напоминание о правилах OFF Новости OFF Опрос OFF Релизы OFF Релизы, которым нужны раздающие OFF Статистика Only Users Загрузка сервера Only Users Администрация Only Admins Пользователи Only Users Поиск Only Users

.