Katlas installation notes: Difference between revisions

From Knot Atlas
Jump to navigationJump to search
No edit summary
 
Line 3: Line 3:
==Upgrading MySQL==
==Upgrading MySQL==
For better or worse, I decided to upgrade MySQL to version 4.0 before doing anything else. I mostly followed [http://dev.mysql.com/doc/mysql/en/linux-rpm.html these instructions].
For better or worse, I decided to upgrade MySQL to version 4.0 before doing anything else. I mostly followed [http://dev.mysql.com/doc/mysql/en/linux-rpm.html these instructions].

''Warning: do not install MySQL 4.1. It is incompatible with mediawiki. Install version 4.0.''


For this I need three RPMs which are all available with only a little digging at [http://www.mysql.com/ mysql.com]
For this I need three RPMs which are all available with only a little digging at [http://www.mysql.com/ mysql.com]

Revision as of 14:25, 29 July 2005

Okay... these are my notes while trying to setup the wiki on katlas.

Upgrading MySQL

For better or worse, I decided to upgrade MySQL to version 4.0 before doing anything else. I mostly followed these instructions.

Warning: do not install MySQL 4.1. It is incompatible with mediawiki. Install version 4.0.

For this I need three RPMs which are all available with only a little digging at mysql.com

  • MySQL-shared-compat-4.0.25-0.i386.rpm
  • MySQL-server-4.0.25-0.i386.rpm
  • MySQL-client-4.0.25-0.i386.rpm

The first of these is required so we don't break dependencies while upgrading. Install it first, with

rpm -iv MySQL-shared-compat-4.0.25-0.i386.rpm

Then upgrade the other two packages

rpm -U MySQL-server-4.0.25-0.i386.rpm
rpm -U MySQL-client-4.0.25-0.i386.rpm

Note the warning the server install gives --

PLEASE REMEMBER TO SET A PASSWORD FOR THE MySQL root USER !
To do so, start the server, then issue the following commands:
/usr/bin/mysqladmin -u root password 'new-password'
/usr/bin/mysqladmin -u root -h katlas.math.toronto.edu password 'new-password'
See the manual for more instructions.

(note however that you need to upgrade the client package before mysqladmin is available to do this!)

I also deleted the local anonymous account, and put a password on the remote anonymous account. (Ask User:Scott for these passwords.)

Apache

I had to fix the server name, from katlas to katlas.math.toronto.edu in httpd.conf

I added

AllowOverride FileInfo

in the httpd.conf file, in the section for /var/www/html, so I could use .htaccess files to rewrite the wiki URLs nicely.