!!! Inrichten server Scharnhorst 

Het betreft een OpenVZ (VPS) met Fedora Core 5.

Na de (reeds lange tijd uitgevoerde) installatie vanuit OpenVZ, moet er nu MySQL bij op.

Het volgende gedaan :

* ''yum install mysql''
* ''yum -y groupinstall "MySQL Database"''
* ''/etc/init.d/mysqld start'' :
{{{
[root@scharnhorst init.d]# ./mysqld start
Initializing MySQL database:  Installing all prepared tables
Fill help tables

To start mysqld at boot time you have to copy support-files/mysql.server
to the right place for your system

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 scharnhorst password 'new-password'
See the manual for more instructions.

You can start the MySQL daemon with:
cd /usr ; /usr/bin/mysqld_safe &

You can test the MySQL daemon with the benchmarks in the 'sql-bench' directory:
cd sql-bench ; perl run-all-tests

Please report any problems with the /usr/bin/mysqlbug script!

The latest information about MySQL is available on the web at
http://www.mysql.com
Support MySQL by buying support/licenses at http://shop.mysql.com
                                                           [  OK  ]
Starting MySQL:                                            [  OK  ]
}}}
* ''/usr/bin/mysqladmin -u root password XXXXXX''
* op blackpearl: ''mysqldump krmdb -u root -p > mysqldumpkrm.sql''
* overpiepen mysqldumpkrm.sql naar scharnhorst
* ''mysql -u root -p''  en dan: 
** ''create database krmdb''
** ''use krmdb;''
** ''source mysqldumpkrm.sql''
** en test: ''select count(*) from peuter''  ==> 975 rijen
** aanmaken user kruimeluser : '' create user 'kruimeluser'@'localhost' identified by "XXXXXXXX";''    __ ==> LET OP de DUBBELE quotes om het password__
** granten op alle tabellen: ''grant select,insert,update,delete on krmdb.* to kruimeluser;''
* overpiepen mysql connector: 
{{{
blackpearl:/usr/local/tomcat/lib # scp mysql-connector-java-3.1.8-bin.jar root@scharnhorst:/usr/local/tomcat/lib
root@scharnhorst's password: 
mysql-connector-java-3.1.8-bin.jar                                                  100%  400KB 399.6KB/s   00:00  
}}}
* aanleggen log directory voor krm ''mkdir /usr/local/tomcat/logs/krm''
* install tor, [see attached log|tor-install-log.txt]


!! T O D O

* -