4 - Install a MySQL server and the DBI Perl modules.
5 - Debian: (apt-get install mysql-server libdbd-mysql-perl)
7 - Run 'mysqladmin -u root -p create <DB NAME>'
8 Where <DB NAME> is the same as specified in blootbot.config.
10 - Run 'setup/setup.pl'
13 - if connection to localhost is (short) refused, run
14 '/etc/init.d/mysql stop'
15 '/etc/init.d/mysql start'
16 - if connection for user is refused, reload grant tables with
17 'mysqladmin -u root -p reload'
20 - run 'scripts/dbm2mysql.pl old-db' to convert dbm database file
25 You can add a new user manually by connecting to MySQL and performing these
30 mysql> CREATE DATABASE blootbot;
31 mysql> GRANT USAGE ON *.* TO 'user'@'localhost' IDENTIFIED BY 'yourpassword';
32 mysql> GRANT ALL PRIVILEGES ON blootbot.* TO 'user'@'localhost';
34 FULL FACTOID DATABASE:
35 ----------------------
36 You can get the data from the MySQL database that the apt bot uses on
37 #debian at freenode (irc.freenode.net), at:
39 http://lain.cheme.cmu.edu/~apt/blootbot/apt.sql.bz2