Wadmin: 1 revision(s)

2006-07-19T05:34:39Z

1 revision(s)

65.43.2.143: /* Configuration of MySQL */

2006-05-02T14:07:34Z

‎Configuration of MySQL

New page

{{H:h|system admin toc}}

<-[[MediaWiki User's Guide]]: [[Running MediaWiki]]

'''''Warning: no promises of security are made in this guide. It was intended to be run on an offline workstation.'''''

== System ==
*Slackware Linux full install: [http://www.slackware.com]
**Apache: [http://www.apache.org]
**MySQL: [http://www.mysql.org]
**MediaWiki: [http://sourceforge.net/projects/wikipedia]
**Cur dump of the database (20031231_cur_table.sql.bz2): [http://download.wikimedia.org]

Slackware's full installation includes Apache, MySQL, and PHP, though some administrative work is still needed to get them up and running.

== Settings ==

For this guide, I will make the following assumptions about names, directories, and the like, but you will want to make some of them different:

* '''name''' - The wiki needs a name; this example is called '''vicuna'''.
* '''database''' - It also needs a database, which will also be called '''vicuna''' in this example.
* '''passwords''' - There are several passwords involved, most importantly the password for the wiki database, and the initial administrator account you'll create when running the configuration page.
* '''directory''' - The directory where the wiki will be installed. In this example, it's '''/var/wiki'''.

== Configuration of Apache ==

At a minimum, the webserver must access your wiki on demand. There are better and more complex ways of setting it up, but this will suffice. In /etc/apache/httpd.conf, in the section <code>IfModule mod_alias.c</code>, add the following line:

Alias /wiki/ /var/wiki

Replace <code>/var/wiki</code> with the directory you've chosen.

Apache will not be configured to use PHP by default, so you may need to do the following.

# Edit <code>/etc/apache/httpd.conf</code> by uncommenting the line <code>#Include /etc/apache/mod_php.conf</code>
# Edit <code>/etc/apache/mod_php.conf</code> by adding <code>.phtml</code> to the line <code>AddType application/x-httpd-php .php</code>
# If Apache isn't running, enter <code>apachectl start</code>, otherwise, do <code>apachectl restart<code>.

== Configuration of MySQL ==

Perform the following commands as root.

# Copy one of the MySQL configuration files in /etc to my.cnf: <code>cp /etc/my-meduium.cnf /etc/my.cnf</code>
# Initialize the MySQL databases (only necessary once per system, but harmless): <code>su mysql -c mysql_install_db</code>
# Start the MySQL daemon: <code>mysqld_safe --user=mysql &</code>
# Set the root password: <code>mysqladmin -u root password '''''password'''''</code>

You probably want MySQL to start at system boot time. You must edit a couple of init scripts to accomplish this.

* Place the startup script: <code>cp /usr/share/mysql/mysql.server /etc/rc.d/rc.mysql</code>
* Edit <code>/etc/rc.d/rc.M</code> and add the following text near the end:

# Start the MySQL server
if [ -x /etc/rc.d/rc.mysql ]; then
. /etc/rc.d/rc.mysql start
fi

* Edit <code>/etc/rc.d/rc.K</code> and add the following text above the "Kill all processes" section:

# Shut down the MySQL server:
if [ -x /etc/rc.d/rc.mysql ]; then
/etc/rc.d/rc.mysql stop
fi

== Configuration of MediaWiki ==

# Go to the directory where you will install Mediawiki, such as <code>/var</code>, and unpack the package: <code>cd /var</code> <code>tar xzvf ~/mediawiki-1.x.x.tar.gz</code>
# Rename the directory to something manageable: <code>mv mediawiki-1.x.x wiki</code>
# Make the config directory world-writable: <code>chmod o+w wiki/config</code>
# Load the configurating page in your web browser and use it. Go to <code>http://my.host/wiki/config/</code>.
# Once the configuration has completed successfully, shut off the config directory: <code>chmod 700 wiki/config</code>
# And get your LocalSettings.php file installed: <code>mv wiki/config/LocalSettings.php wiki</code>
# Edit LocalSettings.php as desired.

== Loading the dump ==
# Unzip the dump by typing: <code>bunzip2 20031231_cur_table.sql.bz2</code> (this will take a while depending on the size of the dump and the speed of your workstation).
# Import the dump in your database by starting a mysql session as above, if you have not done so, loading the wiki database (the name as you gave above), by typing: <code>use <wiki db></code> and then importing the data by typing: <code>source /path/20031231_cur_table.sql</code>. This will also take a long time.

At this point you should have a working install with some data in it. Other things will also need to be set up (classic TODO here).

==See also==
* [[Running MediaWiki on Linux]]

← Older revision	Revision as of 05:34, 19 July 2006
(No difference)

Help:Running MediaWiki on Slackware Linux - Revision history

Wadmin: 1 revision(s)

65.43.2.143: /* Configuration of MySQL */