From 4e1e40d629d41c043edf9bfadfa70c59f2258f14 Mon Sep 17 00:00:00 2001 From: dms Date: Thu, 5 Dec 2002 15:55:11 +0000 Subject: [PATCH] - updates from Morten. Thanks. git-svn-id: https://svn.code.sf.net/p/infobot/code/trunk@723 c11ca15a-4712-0410-83d8-924469b57eb5 --- blootbot/INSTALL | 25 +++++++++++++------------ blootbot/INSTALL.mysql | 36 ++++++++++++++++++++++-------------- blootbot/INSTALL.pgsql | 3 ++- 3 files changed, 37 insertions(+), 27 deletions(-) diff --git a/blootbot/INSTALL b/blootbot/INSTALL index 5cf605e..560cbdb 100644 --- a/blootbot/INSTALL +++ b/blootbot/INSTALL @@ -5,25 +5,26 @@ Method of installation. - Copy files/sample/sample.chan to files/blootbot.chan - Copy files/sample/sample.servers to files/blootbot.servers - Copy files/sample/sample.users to files/blootbot.users + - Edit files/blootbot.config, modify to taste. - Edit files/blootbot.chan to set which channels to join. - Edit files/blootbot.servers to modify list of IRC servers to connect. - Install the following Perl modules: - - Net::IRC perl module - - Debian: (apt-get install libnet-irc-perl) - - WWW::Search - - Debian: (apt-get install libwww-search-perl) - - LWP - - Debian: (apt-get install libwww-perl) - - HTML::Parser - - Debian: (apt-get install libhtml-parser-perl) + - Net::IRC perl module + - Debian: (apt-get install libnet-irc-perl) + - WWW::Search + - Debian: (apt-get install libwww-search-perl) + - LWP + - Debian: (apt-get install libwww-perl) + - HTML::Parser + - Debian: (apt-get install libhtml-parser-perl) - Choose your database: - - MySQL, read INSTALL.mysql (supported) - - SQLite, read INSTALL.sqlite (supported) - - PgSQL, read INSTALL.pgsql (unsupported, may work) - - Berkeley DBM, read INSTALL.dbm (unsupported, may work) + - MySQL, read INSTALL.mysql (supported) + - SQLite, read INSTALL.sqlite (supported) + - PgSQL, read INSTALL.pgsql (unsupported, may work) + - Berkeley DBM, read INSTALL.dbm (unsupported, may work) - There are "bugs" in the perl modules. Read INSTALL.patches on how to fix. diff --git a/blootbot/INSTALL.mysql b/blootbot/INSTALL.mysql index a1c6eba..6b367c1 100644 --- a/blootbot/INSTALL.mysql +++ b/blootbot/INSTALL.mysql @@ -2,24 +2,28 @@ INSTALL.mysql ---------------- - Install a MySQL server and the DBI Perl modules. - - Debian: (apt-get install mysql-server libdbd-mysql-perl) + - Debian: (apt-get install mysql-server libdbd-mysql-perl) + +- Run 'mysqladmin -u root -p create ' + Where is the same as specified in blootbot.config. + +- Run 'setup/setup.pl' -- run 'mysqladmin -u root -p create ' -- 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' + - 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: +You can add a new user manually by connecting to MySQL and performing these +commands: $ mysql -u root -p @@ -27,5 +31,9 @@ ADDITIONAL NOTES: mysql> GRANT USAGE ON *.* TO 'user'@'localhost' IDENTIFIED BY 'yourpassword'; mysql> GRANT ALL PRIVILEGES ON blootbot.* TO 'user'@'localhost'; -for the mysql that are on apt the bot (#debian@OPN), they are available -at http://emu.res.cmu.edu/~apt/blootbot/apt.sql.bz2 +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://emu.res.cmu.edu/~apt/blootbot/apt.sql.bz2 diff --git a/blootbot/INSTALL.pgsql b/blootbot/INSTALL.pgsql index 3130dc8..1810d5f 100644 --- a/blootbot/INSTALL.pgsql +++ b/blootbot/INSTALL.pgsql @@ -4,4 +4,5 @@ Method of installation. - Debian: (apt-get install postgresql) - Debian: (apt-get install libpgperl) -- run 'scripts/setup.pl' +SUPPORT FOR PGSQL IS CURRENTLY BROKEN! You'll have to use one of the other +databases instead. -- 2.39.2