Message board installation documentation

From Wiki

Jump to: navigation, search

extract zip into web/php (or wherever you want php files to go)

mysql.conf

  • make sure mysql.conf is only readable by approved users (your user and the webserver?, or just your user if suexec is being used).
  • edit mysql.conf to contain host (localhost), username, password, and db you created in mysql.
    • if you have a mediawiki wiki, then you specify the db of the wiki here too.

mysql

  • you must set up a user that can read and write to a database
   create database test;
   grant usage on *.* to test@localhost identified by 'YOUR PASSWORD HERE';
   grant alter, create, create temporary tables, delete, drop, execute, index, insert, lock tables, select, update on test.* to test@localhost;
   grant select on wiki.* to test@localhost;   not needed if you don't have a wiki
   quit
  • you must also run msg/notes/tables.sql on that database as that user

apache

alias /msg/ /home/test/web/php/msg.php
aliasmatch ^/msg/thread..../$ /home/test/web/php/msg.php
<directory /home/test/web/php>
   addhandler cgi-script .php
   options +execcgi
</directory>

exact actions i took to setup mb

your actions will be different. especially if your server is in windows.

# useradd test
# usermod -a -G modphp test   not needed if you're using suexec
# sudo -u test -i
$ mkdir web web/php web/htdocs web/logs
$ cd web/php
$ tar -xf ../../msg.tar.bz2
$ chgrp modphp msg/mysql.conf   not needed if you're using suexec
$ chmod o= msg/mysql.conf
$ vim msg/mysql.conf
$ mysql -uroot -p
   create database test;
   grant usage on *.* to test@localhost identified by 'YOUR PASSWORD HERE';
   grant alter, alter routine, create, create routine, create temporary tables, delete, drop, execute, index, insert, lock tables, select, update on test.* to test@localhost;
   grant select on wiki.* to test@localhost;
   quit
$ mysql -utest -p test <msg/notes/tables.sql

edited /etc/apache2/ as seen above in apache section

# /etc/init.d/apache2 restart
Personal tools