This is my note on how to prepare for installation moodle in centos 5 ..
via command prompt MySQL command.
1. Enter MySQL command prompt with password :
mysql -u root -p
2. Create Blank database.
mysql> create database edu_namran;
Query OK, 1 row affected (0.05 sec)
3. Verify database.
mysql>show databases;
4. create a user
mysql> create user 'someuser' @'localhost' IDENTIFIED BY 'somepass';
Query OK, 0 rows affected (0.06 sec)
5. grant user access to db
mysql> GRANT ALL on edu_namran.* to 'someuser'@'localhost';
Query OK, 0 rows affected (0.04 sec)
6. verify :
[root@fedora html]# mysql -u edunamran -p
Enter password:
Welcome to the MySQL monitor. Commands end with ; or \g.
Your MySQL connection id is 147
Server version: 5.0.45 Source distribution
Type 'help;' or '\h' for help. Type '\c' to clear the buffer.
mysql> show databases;
+--------------------+
| Database |
+--------------------+
| information_schema |
| edunamran_db |
| test |
+--------------------+
3 rows in set (0.00 sec)
mysql> use edunamran_db;
Database changed
mysql> show tables;
Empty set (0.00 sec)
7. check the required packaged .. before installing
yum install php-mbstring php-xmlrpc
Your machine might already have these package.
And if you're on someone else hosting with cpanel and all..
you might want to get administrator help to get this package added to the machine.
But it was kinda optional, will work without these also.Only a bit optimization advantage if these packages are installed.
8. then.. just proceed with the install.php interface under admin section..
Reference :
1. http://www.debuntu.org/how-to-create-a-mysql-database-and-set-privileges-to-a-user
4) Module parameters.
———————
The following module parameters can be passed:
mode=
Possible values are 0 (round robin policy, default) and 1 (active backup
policy), and 2 (XOR). See question 9 and the HA section for additional info.
miimon=
Use integer value for the frequency (in ms) of MII link monitoring. Zero value
is default and means the link monitoring will be disabled. A good value is 100
if you wish to use link monitoring. See HA section for additional info.
downdelay=
Use integer value for delaying disabling a link by this number (in ms) after
the link failure has been detected. Must be a multiple of miimon. Default
value is zero. See HA section for additional info.
updelay=
Use integer value for delaying enabling a link by this number (in ms) after
the “link up” status has been detected. Must be a multiple of miimon. Default
value is zero. See HA section for additional info.
arp_interval=
Use integer value for the frequency (in ms) of arp monitoring. Zero value
is default and means the arp monitoring will be disabled. See HA section
for additional info. This field is value in active_backup mode only.
arp_ip_target=
An ip address to use when arp_interval is > 0. This is the target of the
arp request sent to determine the health of the link to the target.
Specify this value in ddd.ddd.ddd.ddd format.
If you need to configure several bonding devices, the driver must be loaded
several times. I.e. for two bonding devices, your /etc/conf.modules must look
like this:
alias bond0 bonding
alias bond1 bonding
options bond0 miimon=100
options bond1 -o bonding1 miimon=100
4) Module parameters.
———————
The following module parameters can be passed:
mode=
Possible values are 0 (round robin policy, default) and 1 (active backup
policy), and 2 (XOR). See question 9 and the HA section for additional info.
miimon=
Use integer value for the frequency (in ms) of MII link monitoring. Zero value
is default and means the link monitoring will be disabled. A good value is 100
if you wish to use link monitoring. See HA section for additional info.
downdelay=
Use integer value for delaying disabling a link by this number (in ms) after
the link failure has been detected. Must be a multiple of miimon. Default
value is zero. See HA section for additional info.
updelay=
Use integer value for delaying enabling a link by this number (in ms) after
the “link up” status has been detected. Must be a multiple of miimon. Default
value is zero. See HA section for additional info.
arp_interval=
Use integer value for the frequency (in ms) of arp monitoring. Zero value
is default and means the arp monitoring will be disabled. See HA section
for additional info. This field is value in active_backup mode only.
arp_ip_target=
An ip address to use when arp_interval is > 0. This is the target of the
arp request sent to determine the health of the link to the target.
Specify this value in ddd.ddd.ddd.ddd format.
If you need to configure several bonding devices, the driver must be loaded
several times. I.e. for two bonding devices, your /etc/conf.modules must look
like this:
alias bond0 bonding
alias bond1 bonding
options bond0 miimon=100
options bond1 -o bonding1 miimon=100