INSTALL.mysql
----------------

- Install a MySQL server and the DBI Perl modules.
    - Debian: (apt-get install mysql-server libdbd-mysql-perl)

- Run 'mysqladmin -u root -p create <DB NAME>'
    Where <DB NAME> is the same as specified in blootbot.config.

- Run 'setup/setup.pl'

= Possible problems
    - if connection to localhost is (short) refused, run
	    '/etc/init.d/mysql stop'
	    '/etc/init.d/mysql start'
    - if connection for user is refused, reload grant tables with
	    'mysqladmin -u root -p reload'

* [OPTIONAL]
    - run 'scripts/dbm2mysql.pl old-db' to convert dbm database file
    to mysql.

ADDITIONAL NOTES:
-----------------
You can add a new user manually by connecting to MySQL and performing these
commands:

  $ mysql -u root -p

  mysql> CREATE DATABASE blootbot;
  mysql> GRANT USAGE ON *.* TO 'user'@'localhost' IDENTIFIED BY 'yourpassword';
  mysql> GRANT ALL PRIVILEGES ON blootbot.* TO 'user'@'localhost';

FULL FACTOID DATABASE:
----------------------
You can get the data from the MySQL database that the apt bot uses on
#debian at freenode (irc.freenode.net), at:

    http://lain.cheme.cmu.edu/~apt/blootbot/apt.sql.bz2