[mirrorbrain-commits] [opensuse-svn] r6333 - trunk/tools/download-redirector-v2

From: Novell Forge SVN <noreply_at_novell.com>
Date: Tue, 3 Feb 2009 02:44:34 -0700 (MST)
Author: poeml
Date: 2009-02-03 02:44:31 -0700 (Tue, 03 Feb 2009)
New Revision: 6333

Modified:
   trunk/tools/download-redirector-v2/INSTALL
Log:
work on documenting more details about the installation of MirrorBrain, both
regarding MySQL and PostgreSQL


Modified: trunk/tools/download-redirector-v2/INSTALL
===================================================================
--- trunk/tools/download-redirector-v2/INSTALL	2009-02-03 09:35:41 UTC (rev 6332)
+++ trunk/tools/download-redirector-v2/INSTALL	2009-02-03 09:44:31 UTC (rev 6333)
_at_@ -1,6 +1,6 @@
 These instructions show how to install:
 
-1. mod_mirrorbrain, the redirector module for apache.  
+1. mod_mirrorbrain, the Apache module
 2. other needed components
 3. the database
 
_at_@ -11,16 +11,24 @@
 http://download.opensuse.org/repositories/Apache:/Modules/
 http://club.mandriva.com/xwiki/bin/view/rpms/Application/apache-mod_zrkadlo
 
-It can be built simply with
-apxs2 -c -Wc,"-Wall -g" mod_mirrorbrain.c
+It can be built with the following steps:
+# unpack the tarball
+cd mod_mirrorbrain
+apxs2 -c mod_mirrorbrain.c
 
+To install the module in the right place, you would typically call
+apxs2 -i mod_mirrorbrain.c
 
+Building, installing and activation can typically be combined in one call:
+apxs2 -cia mod_mirrorbrain.c
 
+
+
 After installation of mod_mirrorbrain, you'll need to:
 
 
 - install GeoIP library, commandline tools, and geoip apache module
-  (openSUSE packages GeoIP + libGeoIP1 + apache2-mod_geoip)
+  (openSUSE/SLE packages: GeoIP, libGeoIP1, apache2-mod_geoip)
 
 - configure mod_geoip:
     GeoIPEnable On
_at_@ -34,43 +42,146 @@
 - install mod_form
   http://apache.webthing.com/svn/apache/forms/mod_form.c
   http://apache.webthing.com/svn/apache/forms/mod_form.h
-  (openSUSE package apache2-webthings-collection)
+  (openSUSE/SLE package: apache2-webthings-collection)
 
+- install the following Python modules:
+      python-cmdln
+      python-sqlobject
+      python-mysql (when using MySQL)
+      python-psycopg2 (when using PostgreSQL)
 
+- for the scanner, which is written in Perl, a few Perl modules are required:
+      perl-libwww-perl
+      perl-DBD-mysql (when using MySQL)
+      perl-DBD-Pg (when using PostgreSQL)
 
-- install a database adapter for the DBD library, for example MySQL
-  (openSUSE package: libapr-util1-dbd-mysql)
 
+- choose a database to use with MirrorBrain, and continue with the respective
+  description below:
 
 
-- log into your database at root, e.g. for mysql:
-    mysql -u root -p
-  there, create the database and grant write permissions for a local user:
-    create database redirector;
-    grant all privileges on redirector.* to wwwrun_at_localhost identified by '12345';
+   a) Using MySQL
 
-  run the sql file which creates the tables and indices:
-    mysql -u wwwrun -p -D redirector < /usr/share/doc/packages/apache2-mod_zrkadlo/sql/opensuse-redirector.sql
+      - install the MySQL database adapter for the DBD library
+        (openSUSE/SLE package: libapr-util1-dbd-mysql)
 
-- the mysql InnoDB engine needs to be configured to use enough memory for the
-  database. This is probably the most important thing to know and the most
-  frequent deployment error, to not tune this. Use the innodb_buffer_pool_size
-  value to match it to the size of your database. The default value is tiny.
-  Although, when your database is tiny, too, it won't matter much. But for
-  larger databases, the value needs to be increased, possibly considerably.
+      
+      - install and start MySQL
+      
+      - log into your database at root:
+          mysql -u root -p
+        there, create the database and grant write permissions for a local user:
+          create database mirrorbrain;
+          grant all privileges on mirrorbrain.* to wwwrun_at_localhost identified by '12345';
+      
+        run the sql file which creates the tables and indices:
+          mysql -u wwwrun -p -D mirrorbrain < /usr/share/doc/packages/apache2-mod_zrkadlo/sql/mirrorbrain-mysql.sql
+      
+      - the mysql InnoDB engine needs to be configured to use enough memory for the
+        database. This is probably the most important thing to know and the most
+        frequent deployment error, to not tune this. Use the innodb_buffer_pool_size
+        value to match it to the size of your database. The default value is tiny.
+        Although, when your database is tiny, too, it won't matter much. But for
+        larger databases, the value needs to be increased, possibly considerably.
   
 
-- create /etc/mirrorbrain.conf with the following content:
+    b) Using PostgreSQL
 
+       - install the PostgreSQL database adapter for the DBD library
+         (openSUSE/SLE package: libapr-util1-dbd-pgsql)
+       
+       - install postgresql and start it
+
+       - create the postgresql user account and database:
+
+
+           su - postgres
+           
+           root_at_powerpc:~ # su - postgres
+           postgres_at_powerpc:~> createuser -P mb
+           Enter password for new role: 
+           Enter it again: 
+           Shall the new role be a superuser? (y/n) n
+           Shall the new role be allowed to create databases? (y/n) n
+           Shall the new role be allowed to create more new roles? (y/n) n
+           CREATE ROLE
+           
+           postgres_at_powerpc:~> createdb -O mb mirrorbrain
+           CREATE DATABASE
+           postgres_at_powerpc:~> 
+
+
+           postgres_at_powerpc:~> vi data/pg_hba.conf
+           # TYPE  DATABASE    USER        CIDR-ADDRESS          METHOD
+           # "local" is for Unix domain socket connections only
+           #local   all         all                               ident sameuser
+           #local   all         all                               trust
+           local   all         all                               password
+           # IPv4 local connections:
+           host    all         all         127.0.0.1/32          password
+           # IPv6 local connections:
+           host    all         all         ::1/128               password
+           
+           
+           root_at_powerpc:~ # rcpostgresql restart
+           
+           root_at_powerpc:~ # su - postgres
+           postgres_at_powerpc:~> psql mirrorbrain mb
+           Password for user mb: 
+           Welcome to psql 8.1.11, the PostgreSQL interactive terminal.
+           [...]
+
+
+
+
+       - psql -U mb -f /dev/shm/mirrorbrain-postgresql.sql mirrorbrain
+
+           Password for user mb: 
+           BEGIN
+           psql:/dev/shm/mirrorbrain-postgresql.sql:14: NOTICE:  CREATE TABLE will create implicit sequence "file_id_seq" for serial column "file.id"
+           psql:/dev/shm/mirrorbrain-postgresql.sql:14: NOTICE:  CREATE TABLE / PRIMARY KEY will create implicit index "file_pkey" for table "file"
+           CREATE TABLE
+           CREATE INDEX
+           psql:/dev/shm/mirrorbrain-postgresql.sql:45: NOTICE:  CREATE TABLE will create implicit sequence "server_id_seq" for serial column "server.id"
+           psql:/dev/shm/mirrorbrain-postgresql.sql:45: NOTICE:  CREATE TABLE / PRIMARY KEY will create implicit index "server_pkey" for table "server"
+           psql:/dev/shm/mirrorbrain-postgresql.sql:45: NOTICE:  CREATE TABLE / UNIQUE will create implicit index "server_identifier_key" for table "server"
+           CREATE TABLE
+           CREATE INDEX
+           psql:/dev/shm/mirrorbrain-postgresql.sql:61: NOTICE:  CREATE TABLE / UNIQUE will create implicit index "file_server_fileid_key" for table "file_server"
+           CREATE TABLE
+           CREATE INDEX
+           CREATE INDEX
+           psql:/dev/shm/mirrorbrain-postgresql.sql:83: NOTICE:  CREATE TABLE will create implicit sequence "marker_id_seq" for serial column "marker.id"
+           psql:/dev/shm/mirrorbrain-postgresql.sql:83: NOTICE:  CREATE TABLE / PRIMARY KEY will create implicit index "marker_pkey" for table "marker"
+           CREATE TABLE
+           psql:/dev/shm/mirrorbrain-postgresql.sql:92: NOTICE:  CREATE TABLE will create implicit sequence "country_id_seq" for serial column "country.id"
+           psql:/dev/shm/mirrorbrain-postgresql.sql:92: NOTICE:  CREATE TABLE / PRIMARY KEY will create implicit index "country_pkey" for table "country"
+           CREATE TABLE
+           CREATE FUNCTION
+           COMMIT
+
+
+
+
+- create a group and user to run the mirrorbrain tools under:
+    groupadd mirrorbrain
+    useradd mirrorbrain -g mirrorbrain
+
+- create /etc/mirrorbrain.conf with the content below. File permissions should
+  be 0640, ownership root:mirrorbrain
+
+
   [general]
   instances = go-oo
 
   [go-oo]
   dbuser = wwwrun
   dbpass = 12345
+  # use "mysql" for MySQL, and "postgresql" for PostgreSQL
+  dbdriver = mysql
   dbhost = your_host.example.com
   dbport = 3306
-  dbname = redirector
+  dbname = mirrorbrain
   
   [mirrorprobe]
   logfile = /var/log/mirrorprobe.log
_at_@ -78,7 +189,6 @@
   mailto = your_mail_at_example.com, another_mail_at_example.com
 
 
-  
 - load the Apache modules:
    a2enmod form
    a2enmod dbd
_at_@ -102,7 +212,7 @@
         # reconnect=0 is needed with the mysql adapter. It means that connections
         # should not be "reanimated", because prepared statements would be lost anyway,
         # so dead connections should rather be invalidated and new ones made.
-        DBDParams "host=localhost, user=wwwrun, pass=12345, dbname=redirector, reconnect=0"
+        DBDParams "host=localhost, user=wwwrun, pass=12345, dbname=mirrorbrain, reconnect=0"
         # # threaded MPMs only. prefork will have use db connection per process
         <IfModule !prefork.c>
                 # 

_______________________________________________
Opensuse-svn mailing list
Opensuse-svn_at_forge.novell.com
http://forge.novell.com/mailman/listinfo/opensuse-svn


_______________________________________________
mirrorbrain-commits mailing list

Note: To remove yourself from this list, send a mail with the content
 	unsubscribe
to the address mirrorbrain-commits-request_at_mirrorbrain.org
Received on Tue Feb 03 2009 - 09:44:52 GMT

This archive was generated by hypermail 2.3.0 : Mon Feb 20 2012 - 23:47:04 GMT