X-Git-Url: https://git.donarmstrong.com/?a=blobdiff_plain;f=blootbot%2FINSTALL.mysql;h=40063e541c7edb491845092054d09d873f11abf4;hb=b750234261969648d1a4198a47203c6135212d08;hp=78f2747bcfc7a2c18d438b2093215d7126e14f25;hpb=33c3689694cd5ecc9ab68161e34eb2231470d6bb;p=infobot.git

diff --git a/blootbot/INSTALL.mysql b/blootbot/INSTALL.mysql
index 78f2747..40063e5 100644
--- a/blootbot/INSTALL.mysql
+++ b/blootbot/INSTALL.mysql
@@ -1,18 +1,39 @@
 INSTALL.mysql
 ----------------
 
-- Debian: (apt-get install mysql-server)
-- Debian: (apt-get install libdbd-mysql-perl)
+- 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'
 
-- run 'mysqladmin -u root -p create <DB NAME>'
-- run 'scripts/setup_user.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'
-- run 'scripts/setup_tables.pl'
+    - 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.
+    - 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