UBC Physics & Astronomy
omega.phas.ubc.ca
142.103.236.90 (PUBLIC) - 192.168.1.90 (server)

Machine Type: 7947-AC1, Serial No.: 0662328, Product name: IBM System x3650 M2 server
Warranty expires April 26 2012, 1-800-426-7378

System Info

omega.png
-------------------------------------------------------------------------------
|            |  |  |  |  |  |  |  |  |  |  |  |    |                                |
|            |                                     |                                |
|            |      12 x 2.5" 300Gb Disks          |                                |
|            |                                     |--------------------------------|
|            |  |  |  |  |  |  |  |  |  |  |  |    |            DVD                 |
------------------------------------------------------------------------------------
10-11-23 Currently 3 disk slots used with 146GB (15K) disks (FRU 42D0678).    9 free slots.   146 GB, 10K disks are FRU 43W7538. 
Sales Order Number: 2006267030,  Build Date: 09-05-23
MAC Address 1: 00-1A-64-E5-44-6C
MAC Address 2: 00-1A-64-E5-44-6E
Feature  Qty   Description                          Feature  Qty   Description
1823      1    NVIDIA Quadro FX 570                 4163      1    UltraSlim Enhanced SATA Multi-
3639      1    Intel Xeon Processor L5520 4C        5653      1    System Common planar for 1U/2U
4411      1    Addl lntel Xeon Processor L552       6311      2    2.8m, 10A/100-250V, C13 to IEC
4303      1    IBM System x3650 M2 PCI- Expres      7553      1    8 HDD Enablement Kit
5088      1    IBM System x3650 M2 PCI- Expres      9206      1    No Preload S Feature
5864      1    ServeRAID-MR1Di Li-Ion Battery       2100      1    IBM 675W Redundant Power Supply
5536      3    IBM 146GB 15K 6Gbps SAS 2.5" S       5601      1    Base
3571      1    ServeRAID-MR10i SAS/SATA Contr       9724      1    System Documentation and Softw
3964      16   2GB DDR3-1333 2Rx8 LP RDIMM          2578      1    System Packaging-WW
7552      1    Hot swap SAS/SATA 4 Pac HDD Kit      4069      9    2.5" HDD Filler Bezel
9067      1    Internal SAS RAID - Setup by C       4039      1    Slide Kit
4040      1    GBM, CMA

MegaRAID Applications -> System Tools -> MegaRAID Storage Manager StartUpGuiUsername: rootPwd:root passwd
/usr/local/MegaRAID Storage Manager/startupui.sh

omega_MegaRAID_Physical.png
omega_MegaRAID_Logical.png

Local system engineers: Dave Peterson 604-297-2410(o), 604-551-5116(c) or Duncan Furniss
F1 - Setup     Alt-F1 - Sysboot
To start IBM Director Server manually, run /opt/ibm/director/bin/twgstart
ServeRAID Adapter Quick Reference
IBM ServeRAID-MR10i SAS/SATA Controller   (Press Ctrl-H on bootup to enter...)
S/NP288800908FRUnone
SubVendorID 0x1014 Encryption Capable No
SubDeviceID0x364 NVRAMSize 32 KB
Port Count 8 Memory Size 256 MB
Host Interface PCIE Min Stripe Size 8 KB
Firmware Ver 1.40.32-0602 Max Stripe Size 1 MB
Firmware Pkge Ver 11.0.1-0012 Virtual Drive Count 0
Firmware Time Mar 20, 2009; 15:55:43 Drive Count 3
WebBIOS Ver 2.2-16-Rel    
Battery Backup Present Coercion Mode 1GB-way
Set Factory Defaults No S.M.A.R.T. Polling 300 secs
Cluster Mode Disabled Alarm Control Enabled
Rebuild Rate 30 Patrol Read Rate 30
BGI Rate 30 Cache Flush Interval 4
CC Rate 30 Spinup Drive Count 2
Reconstruction Rate 30 Spinup Delay 12
Controller BIOS Enabled StopOnError Enabled
NCQ Enabled Drive Powersave Disabled
SSD Guard Enabled Schedule CC Supported
Stop on CC error No    
Maintain PD Fail History Enabled    

Disaster Recovery MySQL Backups Using ZRM

Force page loads to go through HTTPS
The easiest and most secure way is to set up a permanent redirect. Enable named virtual hosts and add a Redirect directive to the VirtualHost in /etc/httpd/conf/httpd.conf. 
 NameVirtualHost *:80

   ServerName localhost
   Redirect permanent / https://localhost
Assuming you already have SSL installed and configured correctly in your webserver for whatever directory phpMyAdmin is in, open up the index.php file, and at the very top, just after the comments end, but before the includes, add these few lines: 
 if '$_SERVER["SERVER_PORT"] != 443'{
$head = "Location: https://" . $_SERVER["HTTP_HOST"] .  $_SERVER["REQUEST_URI"];
header'$head';
exit;
}
Apache Redirect HTTP to HTTPS using mod_rewrite
Edit your httpd.conf file or the file where your virtual host is specified and add these lines to redirect http to https: 
RewriteEngine On
RewriteCond %{HTTPS} off
RewriteRule (.*) https://%{HTTP_HOST}%{REQUEST_URI}
In many cases, you can also just add those lines to a file named .htaccess in the folder that you want to redirect http to https.

Note: You can also redirect a single page from http to http in Apache by using this in your configuration file or .htaccess file: 
RewriteEngine On
RewriteRule ^apache-redirect-http-to-https\.html$ https://www.yoursite.com/apache-redirect-http-to-https.html [R=301,L]
15-07-20
What is the best way to reduce the size of ibdata in mysql?
(Section showing contents of above link hidden to save screen space - edit html to see) Also see How to shrink/purge ibdata1 file in MySQL 
[root@omega mysql]# mysql -u root -p
Server version: 5.0.95-log Source distribution (mysql-server-5.0.95-5.el5_9)
mysql> SELECT IFNULL(B.engine,'Total') "Storage Engine",
    -> CONCAT(LPAD(REPLACE(FORMAT(B.DSize/POWER(1024,pw),3),',',''),17,' '),' ',
    -> SUBSTR(' KMGTP',pw+1,1),'B') "Data Size", CONCAT(LPAD(REPLACE(
    -> FORMAT(B.ISize/POWER(1024,pw),3),',',''),17,' '),' ',
    -> SUBSTR(' KMGTP',pw+1,1),'B') "Index Size", CONCAT(LPAD(REPLACE(
    -> FORMAT(B.TSize/POWER(1024,pw),3),',',''),17,' '),' ',
    -> SUBSTR(' KMGTP',pw+1,1),'B') "Table Size"
    -> FROM (SELECT engine,SUM(data_length) DSize,SUM(index_length) ISize,
    -> SUM(data_length+index_length) TSize FROM information_schema.tables
    -> WHERE table_schema NOT IN ('mysql','information_schema','performance_schema')
    -> AND engine IS NOT NULL GROUP BY engine WITH ROLLUP) B,
    -> (SELECT 3 pw) A ORDER BY TSize;
+----------------+----------------------+----------------------+----------------------+
| Storage Engine | Data Size            | Index Size           | Table Size           |
+----------------+----------------------+----------------------+----------------------+
| MEMORY         |             0.000 GB |             0.000 GB |             0.000 GB | 
| InnoDB         |             0.561 GB |             0.203 GB |             0.764 GB | 
| MyISAM         |             7.987 GB |             0.081 GB |             8.068 GB | 
| Total          |             8.548 GB |             0.284 GB |             8.832 GB | 
+----------------+----------------------+----------------------+----------------------+
4 rows in set (34.73 sec)
 13-07-31
mysql-zrm - remote logical backups of omega failed
Error: Couldn't read status information for table general_log ()
mysqldump: Couldn't execute 'show create table `general_log`': Table 'mysql.general_log' doesn't exist (1146)
Full02:backup:ERROR: mysqldump did not succeed.
...and...
Error: Couldn't read status information for table slow_log ()
mysqldump: Couldn't execute 'show create table `slow_log`': Table 'mysql.slow_log' doesn't exist (1146)
Full02:backup:ERROR: mysqldump did not succeed.
As workaround on the 5.0 servers create the tables as they are on 5.1: 
mysql> CREATE TABLE IF NOT EXISTS general_log (
  event_time timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
  user_host mediumtext NOT NULL,
  thread_id int(11) NOT NULL,
  server_id int(10) unsigned NOT NULL,
  command_type varchar(64) NOT NULL,
  argument mediumtext NOT NULL
) ENGINE=CSV DEFAULT CHARSET=utf8 COMMENT='General log';
Query OK, 0 rows affected, 1 warning (0.01 sec)

mysql> CREATE TABLE IF NOT EXISTS slow_log (
  start_time timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
  user_host mediumtext NOT NULL,
  query_time time NOT NULL,
  lock_time time NOT NULL,
  rows_sent int(11) NOT NULL,
  rows_examined int(11) NOT NULL,
  db varchar(512) NOT NULL,
  last_insert_id int(11) NOT NULL,
  insert_id int(11) NOT NULL,
  server_id int(10) unsigned NOT NULL,
  sql_text mediumtext NOT NULL
) ENGINE=CSV DEFAULT CHARSET=utf8 COMMENT='Slow log';
Query OK, 0 rows affected, 1 warning (0.03 sec)
13-06-27
httpd failed to start
/var/log/httpd/error_log showed: 
[root@omega ~]# tail /var/log/httpd/error_log
[Thu Jun 27 08:19:32 2013] [error] SSL Library Error: -8181 Certificate has expired
[Thu Jun 27 08:19:32 2013] [error] Unable to verify certificate 'Server-Cert'. 
Add "NSSEnforceValidCerts off" to nss.conf so the server can start until the problem 
can be resolved.

mod_nss provides strong cryptography for the Apache Web server via the Secure Sockets Layer (SSL) and Transport Layer Security (TLS) protocols, using the Network Security Services (NSS) security library.

Added that line to /etc/httpd/conf.d/nss.conf and then httpd was able to restart.

To see the expired certificate: 
[root@omega ~]# certutil -d /etc/httpd/alias -L -n Server-Cert
Certificate:
    Data:
        Version: 3 (0x2)
        Serial Number: 3 (0x3)
        Signature Algorithm: PKCS #1 SHA-1 With RSA Encryption
        Issuer: "CN=Certificate Shack,O=example.com,C=US"
        Validity:
            Not Before: Sat Jun 27 09:04:57 2009
            Not After : Thu Jun 27 09:04:57 2013
        Subject: "CN=localhost.localdomain,O=example.com,C=US"
... (more...)
To fix: (steel blog), or (local copy) 
[root@omega tmp]# openssl pkcs12 -export -in /etc/pki/tls/certs/omega.phas.ubc.ca.crt -inkey /etc/pki/tls/private/omega.phas.ubc.ca.key -out omega.phas.ubc.ca.pkcs12 -name Server-Cert -passout pass:omega_pkcs12_
[root@omega tmp]# openssl pkcs12 -in omega.phas.ubc.ca.pkcs12 -info
[root@omega tmp]# sudo pk12util pk12util -i omega.phas.ubc.ca.pkcs12 -d /etc/httpd/alias -W omega_pkcs12_
pk12util: using nickname: omega.phas.ubc.ca - GoDaddy.com, Inc.
pk12util: PKCS12 IMPORT SUCCESSFUL

[root@omega tmp]# sudo certutil -A -d /etc/httpd/alias/ -n "Go Daddy" -t "CT,," -a -i /etc/pki/tls/certs/gd_bundle.crt

[root@omega tmp]# sudo certutil -A -d /etc/httpd/alias/ -n "Go Daddy" -t "CT,," -a -i /etc/pki/tls/certs/gd_bundle.crt
[root@omega tmp]# sudo certutil -L -d /etc/httpd/alias

Certificate Nickname                                         Trust Attributes
                                                             SSL,S/MIME,JAR/XPI

cacert                                                       CTu,Cu,Cu
Server-Cert                                                  u,u,u
Go Daddy                                                     CT,, 
alpha                                                        u,pu,u
omega.phas.ubc.ca - GoDaddy.com, Inc.                        u,u,u

[root@omega tmp]# sudo certutil -V -u V -d /etc/httpd/alias -n "omega.phas.ubc.ca - GoDaddy.com, Inc."
certutil: certificate is valid
Now edit /etc/httpd/conf.d/nss.conf and make the following change: 
#NSSNickname Server-Cert
NSSNickname "omega.phas.ubc.ca - GoDaddy.com, Inc."
and comment out this line: 
"NSSEnforceValidCerts off"
12-10-3
NFSv4 mounts - /etc/rc.d/rc.local change
Added the following to /etc/rc.d/rc.local so that NFSv4 export of /www/sites works 
mount -n --bind /www/sites /export/sites
12-05-24
otrs upgrade
# rpm -Uvh otrs-3.1.5-01.noarch.rpm
# cd /opt/otrs/bin
# ./otrs.RebuildConfig.pl
# service httpd restart
12-03-07
otrs installation/upgrade
[root@omega otrs]# cd /www/sites/otrs/
[root@omega otrs]# ln -s /www/sites/otrs /opt/otrs
[root@omega otrs]# rpm -qpR otrs-3.1.2-01.noarch.rpm
perl  
perl(DBI)  
perl(URI)  
mod_perl  
httpd  
procmail  
perl(Date::Format)  
perl(LWP::UserAgent)  
perl(Net::DNS)  
perl(IO::Socket::SSL)  
perl(XML::Parser)  
/bin/sh  
/bin/sh  
rpmlib(PayloadFilesHavePrefix) <= 4.0-1
rpmlib(CompressedFileNames) <= 3.0.4-1
rpmlib(PayloadIsBzip2) <= 3.0.5-1
[root@omega otrs]# yum provides "perl(Date::Format)"
Loaded plugins: rhnplugin, security
1:perl-TimeDate-1.16-5.el5.noarch : A Perl module for time and date manipulation
Repo        : rhel-x86_64-server-5
Matched from:
Other       : perl(Date::Format)
[root@omega otrs]# yum install perl-TimeDate

cp /opt/otrs on gamma to omega:/www/sites/otrs
downloaded 
otrs-2.4.12-01.noarch.rpm
otrs-3.0.10-01.noarch.rpm
otrs-3.1.2-01.noarch.rpm
root@gamma:/opt]$ cd /tmp
root@gamma:/tmp]$ mysqldump --opt -u root -p otrs > otrs.sql
root@gamma:/tmp]$ scp otrs.sql omega:/tmp

[root@omega opt]# cd /tmp
[root@omega tmp]# du -h otrs.sql 
288M	otrs.sql
[root@omega tmp]# mysql -u root -p otrs < otrs.sql 

cd otrs/scripts
cat DBUpdate-to-2.4.mysql.sql | mysql -p -f -u root otrs

su - otrs
-bash-3.2$ ./DBUpdate-to-2.4.pl 
Start migration of the system...

NOTICE: Rebuild config...  done.
NOTICE: Clean up old cache files...  done.
NOTICE: Migrate queue based customer notifications...  done.

Migration of the system completed!
exit
11-12-09
Enable kvm virtualization
First, make sure the RHEL Virtualization channel is enabled for the server. 
yum install kvm virt-manager
yum install libvirt virt-viewer virt-what
Now reboot... 
 # lsmod | grep kvm 
kvm_intel              85256  0 
kvm                   224800  2 ksm,kvm_intel
# service libvirtd status
libvirtd (pid  5113) is running...
Move /var/lib/libvirt to filesystem with more space... 
# pwd
/var/lib
# ls -ld libvirt
drwxr-xr-x 7 root root 4096 Dec  9 14:36 libvirt
# tar cf - ./libvirt | (cd /www; tar xfBp -)
# ls -l /www/libvirt/
total 20
drwx--x--x 2 root root 4096 Jun 29 08:17 boot
drwxr-xr-x 2 root root 4096 Jun 29 08:17 dnsmasq
drwx--x--x 2 root root 4096 Jun 29 08:17 images
drwx------ 2 root root 4096 Dec  9 14:36 network
drwx------ 4 root root 4096 Dec  9 14:36 qemu
# mv libvirt libvirt.orig
# ln -s /www/libvirt /var/lib/libvirt
# ls -ld libvirt*
lrwxrwxrwx 1 root root   12 Dec  9 15:12 libvirt -> /www/libvirt
drwxr-xr-x 7 root root 4096 Dec  9 14:36 libvirt.orig
11-11-30
Disable Weak Ciphers and SSL 2.0 in Apache
Updated to the following lines in all /etc/httpd/conf.d/*ssl* files: 
SSLProtocol -ALL +SSLv3 +TLSv1
SSLCipherSuite ALL:!ADH:RC4+RSA:+HIGH:+MEDIUM:!LOW:!SSLv2:!EXPORT
11-10-26
Installed PECL uploadprogrss library 
[root@omega ~]# pecl install uploadprogress
...
Build process completed successfully
Installed /usr/lib64/php/modules/uploadprogress.so
Created /etc/php.d/uploadprogress.ini 
[root@omega etc]# cat /etc/php.d/uploadprogress.ini 
; Enable uploadprogress extension module
extension=uploadprogress.so
11-02-02
Turned off iptables - control all access through FWSM.
10-12-15 added new disks First used MegaRAID Storage Manager (/usr/local/MegaRAID Storage Manager/startupui.sh) to create RAID array (named "RAID6", raid 6 with hot spare). Then did the following: 
[root@omega ~]# fdisk -l

Disk /dev/sda: 145.9 GB, 145999527936 bytes
255 heads, 63 sectors/track, 17750 cylinders
Units = cylinders of 16065 * 512 = 8225280 bytes

   Device Boot      Start         End      Blocks   Id  System
/dev/sda1   *           1          13      104391   83  Linux
/dev/sda2              14       17750   142472452+  8e  Linux LVM

Disk /dev/sdb: 1793.9 GB, 1793996095488 bytes
255 heads, 63 sectors/track, 218107 cylinders
Units = cylinders of 16065 * 512 = 8225280 bytes

Disk /dev/sdb doesn't contain a valid partition table
[root@omega ~]# fdisk /dev/sdb
Device contains neither a valid DOS partition table, nor Sun, SGI or OSF disklabel
Building a new DOS disklabel. Changes will remain in memory only,
until you decide to write them. After that, of course, the previous
content won't be recoverable.

The number of cylinders for this disk is set to 218107.
There is nothing wrong with that, but this is larger than 1024,
and could in certain setups cause problems with:
1) software that runs at boot time (e.g., old versions of LILO)
2) booting and partitioning software from other OSs
   (e.g., DOS FDISK, OS/2 FDISK)
Warning: invalid flag 0x0000 of partition table 4 will be corrected by w(rite)

Command (m for help): n
Command action
   e   extended
   p   primary partition (1-4)
p
Partition number (1-4): 1
First cylinder (1-218107, default 1): 
Using default value 1
Last cylinder or +size or +sizeM or +sizeK (1-218107, default 218107): 
Using default value 218107

Command (m for help): t
Selected partition 1
Hex code (type L to list codes): 8e
Changed system type of partition 1 to 8e (Linux LVM)

Command (m for help): p

Disk /dev/sdb: 1793.9 GB, 1793996095488 bytes
255 heads, 63 sectors/track, 218107 cylinders
Units = cylinders of 16065 * 512 = 8225280 bytes

   Device Boot      Start         End      Blocks   Id  System
/dev/sdb1               1      218107  1751944446   8e  Linux LVM

Command (m for help): w
The partition table has been altered!

Calling ioctl() to re-read partition table.
Syncing disks.

[root@omega ~]# lvm
lvm> pvcreate /dev/sdb1
  Physical volume "/dev/sdb1" successfully created
lvm> pvdisplay
  /dev/hda: open failed: No medium found
  --- Physical volume ---
  PV Name               /dev/sda2
  VG Name               VolGroup00
  PV Size               135.87 GB / not usable 29.25 MB
  Allocatable           yes (but full)
  PE Size (KByte)       32768
  Total PE              4347
  Free PE               0
  Allocated PE          4347
  PV UUID               5HqATO-GAqA-21Qa-WsKX-WLqO-up3c-ky14hf
   
  "/dev/sdb1" is a new physical volume of "1.63 TB"
  --- NEW Physical volume ---
  PV Name               /dev/sdb1
  VG Name               
  PV Size               1.63 TB
  Allocatable           NO
  PE Size (KByte)       0
  Total PE              0
  Free PE               0
  Allocated PE          0
  PV UUID               eWG9Sg-IL6o-izXY-0ILO-GOcV-t3JA-xicBbK
   
lvm> vgcreate VolGroup01 /dev/sdb1
  Volume group "VolGroup01" successfully created
lvm> vgdisplay
  --- Volume group ---
  VG Name               VolGroup01
  System ID             
  Format                lvm2
  Metadata Areas        1
  Metadata Sequence No  1
  VG Access             read/write
  VG Status             resizable
  MAX LV                0
  Cur LV                0
  Open LV               0
  Max PV                0
  Cur PV                1
  Act PV                1
  VG Size               1.63 TB
  PE Size               4.00 MB
  Total PE              427720
  Alloc PE / Size       0 / 0   
  Free  PE / Size       427720 / 1.63 TB
  VG UUID               ZnWPNx-1U8k-kaNX-ZsQi-hRGL-y5N6-OUtcFt
   
  --- Volume group ---
  VG Name               VolGroup00
  System ID             
  Format                lvm2
  Metadata Areas        1
  Metadata Sequence No  3
  VG Access             read/write
  VG Status             resizable
  MAX LV                0
  Cur LV                2
  Open LV               2
  Max PV                0
  Cur PV                1
  Act PV                1
  VG Size               135.84 GB
  PE Size               32.00 MB
  Total PE              4347
  Alloc PE / Size       4347 / 135.84 GB
  Free  PE / Size       0 / 0   
  VG UUID               9II0kW-67Ym-y2Vx-GQdm-nwHS-j9b0-UD5m9G
   
lvm> lvcreate -n LogVol00 VolGroup01
  Please specify either size or extents (not both)
lvm> lvcreate -l 427720 -n LogVol00 VolGroup01
  Logical volume "LogVol00" created
lvm> exit
  Exiting.
[root@omega ~]# ls /mnt
iso
[root@omega ~]# mkdir /mnt/test
[root@omega ~]# mkfs -t ext3 /dev/VolGroup01/LogVol00
mke2fs 1.39 (29-May-2006)
Filesystem label=
OS type: Linux
Block size=4096 (log=2)
Fragment size=4096 (log=2)
219004928 inodes, 437985280 blocks
21899264 blocks (5.00%) reserved for the super user
First data block=0
Maximum filesystem blocks=4294967296
13367 block groups
32768 blocks per group, 32768 fragments per group
16384 inodes per group
Superblock backups stored on blocks: 
	32768, 98304, 163840, 229376, 294912, 819200, 884736, 1605632, 2654208, 
	4096000, 7962624, 11239424, 20480000, 23887872, 71663616, 78675968, 
	102400000, 214990848

Writing inode tables: done                            
Creating journal (32768 blocks): done
Writing superblocks and filesystem accounting information: done

This filesystem will be automatically checked every 27 mounts or
180 days, whichever comes first.  Use tune2fs -c or -i to override.
[root@omega ~]#
Added the following line to /etc/fstab: 
/dev/VolGroup01/LogVol00 /www                   ext3    defaults        1 3
Now, mount the filesystem: 
[root@omega ~]# mount /www
[root@omega ~]# df -h
Filesystem            Size  Used Avail Use% Mounted on
/dev/mapper/VolGroup00-LogVol00
                      100G   38G   57G  40% /
/dev/sda1              99M   41M   54M  44% /boot
tmpfs                  16G     0   16G   0% /dev/shm
192.168.1.32:/home    1.5T  1.2T  247G  84% /home
192.168.1.32:/home2   447G  307G  136G  70% /home2
192.168.1.32:/ahome    27G   13G   15G  47% /ahome
192.168.1.32:/opt/sysadmin/common
                       15G  4.0G   11G  28% /opt/sysadmin/common
/dev/mapper/VolGroup01-LogVol00
                      1.7T  197M  1.6T   1% /www
10-11-08 server failure 
Had a major power bump two days ago (Sat 6th).  omega will not restart.  IBM sent a tech. 
He replaced the motherboard and then updated the EFI:
Using the IBM UpdateExpress System Pack Installer:
1. First update IMM by itself
2. Then updated the following all at once:
                                       New Version
   - uEFI                                 1.09
   - Dynamic System Analysis (DSA)        3.20
   - ServeRAID MR10i                     11.0.1-0033a
   - Broadcom NetXtreme                   2.15a
Upgrading OTRS 
wget ftp://ftp.samurai.com/pub/otrs/SRPMS/redhat/8.0/otrs-2.2.1-01.src.rpm
rpmbuild --rebuild otrs-2.2.1-01.src.rpm
rpm -Uvh /usr/src/redhat/RPMS/i386/otrs-2.2.1-01.i386.rpm
cat /opt/otrs/scripts/DBUpdate-to-2.2.mysql.sql | mysql -p -f -u root otrs
service mysqld restart
/opt/otrs/bin/SetPermissions.sh /opt/otrs otrs apache
chown otrs:apache /opt/otrs/Kernel/Config.pm
service otrs restart

Log in as 'root@localhost' and select Admin -> SysConfig
to make sure that OTRS updates the configuration files.
10-06-01 System Changes for c21 Drupal Site
  1. php.ini -- various limits up'ed 
     
diff /etc/php.ini /etc/php.ini.20100601
300,302c300,302
< max_execution_time = 180     ; Maximum execution time of each script, in seconds
< max_input_time = 120	; Maximum amount of time each script may spend parsing request data
< memory_limit = 256M      ; Maximum amount of memory a script may consume (16MB)
---
> max_execution_time = 30     ; Maximum execution time of each script, in seconds
> max_input_time = 60	; Maximum amount of time each script may spend parsing request data
> memory_limit = 32M      ; Maximum amount of memory a script may consume (16MB)
468c468
< post_max_size = 150M
---
> post_max_size = 8M
573c573
< upload_max_filesize = 75M
---
> upload_max_filesize = 2M
  2. Install tex-live get the install tarball 
            cd /tmp
        wget http://mirror.xtan.org/systems/texlive/tlnet/install-tl-unx.tar.gz
        tar -xzf install-tl-unx.tar.gz
        cd install-tl-datetime
        ./install-tl
        wait...
        wait...
        wait...
        installing into  /usr/local/texlive//2009
        use /home/grieve/perl/tex-links to symlink bin dir in /usr/bin
  3. Install new version of c21 site
    • Shaun will provide tarball of the drupal c21 files; Shaun's dev site has the files down one level in "public". 1st save the working "settings file" 
      cp /var/www/html/sites/c21.phas.ubc.ca/sites/default/settings.php /tmp
      Unpack the tarball... 
      cd /var/www/html/sites/c21.phas.ubc.ca/;
               tar -xf /$tmp/c21.tar .
               cd public; mv `ls -A` ..;
               cd ..; rmdir public;
      Replace the "settings.php" file. 
      cd /var/www/html/sites/c21.phas.ubc.ca/sites/default
          cp /tmp/settings.php .
      A snapshot of the development DB is a file C21-datetime.mysql.gz This file should be found in $C21/sites/default/files/backup_migrate/manual. Copy the snapshot to somewhere viisble to your broswer... Use phpMyAdmin to "drop" the existing DB -- drupal616_c21_phas_ubc_ca.
      Create a new DB with the same name.
      Import the snapshot to populate the new DB.
        Set the owerships & permissions. See Drupal Page 
      cd $C21
            chown -R apache:apache .
            cd sites
find . -type d -name files -exec chmod ug=rwx,o= '{}' \;
find . -name files -type d -exec find '{}' -type f \; | while read FILE; do chmod ug=rw,o= "$FILE"; done
find . -name files -type d -exec find '{}' -type d \; | while read DIR; do chmod ug=rwx,o= "$DIR"; done
10-05-31 Upgrade php to version 5.2
Reference: Installing php-5.2 on CentOS/RHEL
Previously I had installed (doengraded) php V5.1.6 (see below). Now, we need to have php 5.2. 
cd /usr/local/src
mkdir php5.2
cd php5.2/
wget http://dev.centos.org/centos/5/testing/SRPMS/php-5.2.10-1.el5.centos.src.rpm
rpm -ivh php-5.2.10-1.el5.centos.src.rpm 
cd /usr/src/redhat/SOURCES/
cp /usr/local/src/php5.2/php-5.2.13.tar.bz2 .
cd ../SPECS/
cp php.spec php524.spec
vim php.spec 
yum groupinstall "Development Tools"
rpmbuild -ba php.spec
.....
Checking for unpackaged file(s): /usr/lib/rpm/check-files /var/tmp/php-5.2.13-1-root-root
Wrote: /usr/src/redhat/SRPMS/php-5.2.13-1.src.rpm
Wrote: /usr/src/redhat/RPMS/x86_64/php-5.2.13-1.x86_64.rpm
Wrote: /usr/src/redhat/RPMS/x86_64/php-cli-5.2.13-1.x86_64.rpm
Wrote: /usr/src/redhat/RPMS/x86_64/php-common-5.2.13-1.x86_64.rpm
Wrote: /usr/src/redhat/RPMS/x86_64/php-devel-5.2.13-1.x86_64.rpm
Wrote: /usr/src/redhat/RPMS/x86_64/php-imap-5.2.13-1.x86_64.rpm
Wrote: /usr/src/redhat/RPMS/x86_64/php-ldap-5.2.13-1.x86_64.rpm
Wrote: /usr/src/redhat/RPMS/x86_64/php-pdo-5.2.13-1.x86_64.rpm
Wrote: /usr/src/redhat/RPMS/x86_64/php-mysql-5.2.13-1.x86_64.rpm
Wrote: /usr/src/redhat/RPMS/x86_64/php-pgsql-5.2.13-1.x86_64.rpm
Wrote: /usr/src/redhat/RPMS/x86_64/php-odbc-5.2.13-1.x86_64.rpm
Wrote: /usr/src/redhat/RPMS/x86_64/php-soap-5.2.13-1.x86_64.rpm
Wrote: /usr/src/redhat/RPMS/x86_64/php-snmp-5.2.13-1.x86_64.rpm
Wrote: /usr/src/redhat/RPMS/x86_64/php-xml-5.2.13-1.x86_64.rpm
Wrote: /usr/src/redhat/RPMS/x86_64/php-xmlrpc-5.2.13-1.x86_64.rpm
Wrote: /usr/src/redhat/RPMS/x86_64/php-mbstring-5.2.13-1.x86_64.rpm
Wrote: /usr/src/redhat/RPMS/x86_64/php-ncurses-5.2.13-1.x86_64.rpm
Wrote: /usr/src/redhat/RPMS/x86_64/php-gd-5.2.13-1.x86_64.rpm
Wrote: /usr/src/redhat/RPMS/x86_64/php-bcmath-5.2.13-1.x86_64.rpm
Wrote: /usr/src/redhat/RPMS/x86_64/php-dba-5.2.13-1.x86_64.rpm
Wrote: /usr/src/redhat/RPMS/x86_64/php-debuginfo-5.2.13-1.x86_64.rpm
Executing(%clean): /bin/sh -e /var/tmp/rpm-tmp.56458
....
cd /usr/local/src/php5.2
wget http://dev.centos.org/centos/5/testing/SRPMS/php-extras-5.2.9-2.el5.centos.3.src.rpm
rpm -ivh php-extras-5.2.9-2.el5.centos.3.src.rpm
[root@omega php5.2]# cd /usr/src/redhat/SPECS/
[root@omega SPECS]# cp php-extras.spec php-extras529.spec 
[root@omega SPECS]# vim php-extras.spec 
[root@omega SPECS]# cd ../SOURCES/
[root@omega SOURCES]# mv php-5.2.10.tar.bz2 php-5.2.10.tar.bz2.notused
[root@omega SOURCES]# mv php-5.2.9.tar.bz2 php-5.2.9.tar.bz2.notusecd
[root@omega SOURCES]# mv php-5.2.9.tar.bz2.notusecd php-5.2.9.tar.bz2.notused
[root@omega SOURCES]# cd ../SPECS/
[root@omega SPECS]# ll
total 112
-rw-r--r-- 1 root root 33949 May 31 15:17 php524.spec
-rw-r--r-- 1 root root  9862 May 31 15:51 php-extras529.spec
-rw-rw-r-- 1 root root  9862 Sep 10  2009 php-extras.spec
-rw-r--r-- 1 root root 33949 May 31 15:18 php.spec
[root@omega SPECS]# vim php-extras.spec 
[root@omega SPECS]# rpmbuild -ba php-extras.spec 
error: Failed build dependencies:
	php-devel = 5.2.13 is needed by php-extras-5.2.13-1.x86_64
	libedit-devel is needed by php-extras-5.2.13-1.x86_64
	libmcrypt-devel is needed by php-extras-5.2.13-1.x86_64
	mhash-devel is needed by php-extras-5.2.13-1.x86_64
	libtidy-devel is needed by php-extras-5.2.13-1.x86_64
	freetds-devel is needed by php-extras-5.2.13-1.x86_64
[root@omega SPECS]# yum install libedit-devel libmcrypt-devel mhash-devel libtidy-devel freetds-devel
[root@omega SPECS]# rpmbuild -ba php-extras.spec error: Failed build dependencies:
	php-devel = 5.2.13 is needed by php-extras-5.2.13-1.x86_64
[root@omega SPECS]# cd /usr/src/redhat/RPMS/x86_64/
[root@omega x86_64]# 
rpm -Uvh php-5.2.13-1.x86_64.rpm 
         php-bcmath-5.2.13-1.x86_64.rpm 
         php-cli-5.2.13-1.x86_64.rpm 
         php-common-5.2.13-1.x86_64.rpm 
         php-dba-5.2.13-1.x86_64.rpm 
         php-debuginfo-5.2.13-1.x86_64.rpm 
         php-devel-5.2.13-1.x86_64.rpm 
         php-gd-5.2.13-1.x86_64.rpm 
         php-imap-5.2.13-1.x86_64.rpm 
         php-ldap-5.2.13-1.x86_64.rpm 
         php-mbstring-5.2.13-1.x86_64.rpm 
         php-mysql-5.2.13-1.x86_64.rpm  
         php-ncurses-5.2.13-1.x86_64.rpm 
         php-odbc-5.2.13-1.x86_64.rpm 
         php-pdo-5.2.13-1.x86_64.rpm 
         php-pgsql-5.2.13-1.x86_64.rpm 
         php-snmp-5.2.13-1.x86_64.rpm 
         php-soap-5.2.13-1.x86_64.rpm 
         php-xml-5.2.13-1.x86_64.rpm 
         php-xmlrpc-5.2.13-1.x86_64.rpm
service httpd restart
cd ../../SPECS/
rpmbuild -ba php-extras.spec
At this point, I got failed tests on mhash: 
FAILED TEST SUMMARY
---------------------------------------------------------------------
mhash() test [tests/001.phpt]
mhash_keygen_s2k() test [tests/003.phpt]
so I found a different site for the php-extras rpm (that was at version 5.2.13) and tried again, this time I didn't even have to modify the spec file. reference page 
cd /usr/local/src/php5.2/
wget http://www.atoomnet.net/php/php-5.2.13/SRPMS/php-extras-5.2.13-1.src.rpm
rpm -ivh php-extras-5.2.13-1.src.rpm 
cd /usr/src/redhat/SPECS/
rpmbuild -ba php-extras.spec 
....
Wrote: /usr/src/redhat/SRPMS/php-extras-5.2.13-1.src.rpm
Wrote: /usr/src/redhat/RPMS/x86_64/php-dbase-5.2.13-1.x86_64.rpm
Wrote: /usr/src/redhat/RPMS/x86_64/php-readline-5.2.13-1.x86_64.rpm
Wrote: /usr/src/redhat/RPMS/x86_64/php-mcrypt-5.2.13-1.x86_64.rpm
Wrote: /usr/src/redhat/RPMS/x86_64/php-mhash-5.2.13-1.x86_64.rpm
Wrote: /usr/src/redhat/RPMS/x86_64/php-tidy-5.2.13-1.x86_64.rpm
Wrote: /usr/src/redhat/RPMS/x86_64/php-mssql-5.2.13-1.x86_64.rpm
Wrote: /usr/src/redhat/RPMS/x86_64/php-extras-debuginfo-5.2.13-1.x86_64.rpm
....
[root@omega SPECS]# pwd
/usr/src/redhat/SPECS
[root@omega SPECS]# cd ../RPMS/x86_64/
[root@omega x86_64]# rpm -Uvh php-dbase-5.2.13-1.x86_64.rpm php-readline-5.2.13-1.x86_64.rpm php-mcrypt-5.2.13-1.x86_64.rpm php-mhash-5.2.13-1.x86_64.rpm php-tidy-5.2.13-1.x86_64.rpm php-mssql-5.2.13-1.x86_64.rpm 
Preparing...                ########################################### [100%]
	file /usr/lib64/php/modules/dbase.so from install of php-dbase-5.2.13-1.x86_64 conflicts with file from package php-common-5.2.13-1.x86_64
[root@omega x86_64]# rpm -Uvh php-readline-5.2.13-1.x86_64.rpm php-mcrypt-5.2.13-1.x86_64.rpm php-mhash-5.2.13-1.x86_64.rpm php-tidy-5.2.13-1.x86_64.rpm php-mssql-5.2.13-1.x86_64.rpm 
Preparing...                ########################################### [100%]
   1:php-mssql              ########################################### [ 20%]
   2:php-readline           ########################################### [ 40%]
   3:php-mcrypt             ########################################### [ 60%]
   4:php-mhash              ########################################### [ 80%]
   5:php-tidy               ########################################### [100%]
[root@omega x86_64]# php -v
PHP Warning:  Module 'readline' already loaded in Unknown on line 0
PHP 5.2.13 (cli) (built: May 31 2010 16:18:06) 
Copyright (c) 1997-2010 The PHP Group
Zend Engine v2.2.0, Copyright (c) 1998-2010 Zend Technologies
10-05-28 Downgrade php to version <= 5.2
Previously I had installed php V5.3 (see below). Now, for the C21 website using Drupal 6.16 we need to have php 5.2. Since it was easiest to downgrrade to php 5.1.6 I did that and will test to see if it is OK or we need to now upgrade to php 5.2. 
service httpd stop
rpm -e php-pdo-5.3.0-2.el5.remi.2 
 php-mysql-5.3.0-2.el5.remi.2 
 php-devel-5.3.0-2.el5.remi.2 
 php-xml-5.3.0-2.el5.remi.2 
 php-5.3.0-2.el5.remi.2 
 php-mbstring-5.3.0-2.el5.remi.2 
 php-pear-1.9.0-1.el5.remi 
 php-common-5.3.0-2.el5.remi.2 
 php-cli-5.3.0-2.el5.remi.2 
 php-ldap-5.3.0-2.el5.remi.2 
 php-odbc-5.3.0-2.el5.remi.2 
 php-gd-5.3.0-2.el5.remi.2 
 phpMyAdmin-3.2.2-1.el5.remi 
 php-mcrypt-5.3.0-2.el5.remi.2   (all on one line)

yum install php
yum install php-mysql php-pdo php-devel php-xml php-mbstring 
    php-pear php-ldap php-odbc php-gd php-mcrypt phpMyAdmin  (all on one line)
# backup mysql dbases...
cd /var/lib
tar cf - ./mysql | (cd /opt/sysadmin; tar xfBp -)
service mysqld stop
rpm -e mysql-connector-odbc mysqlclient15 mysql-libs mysql-server 
  mod_auth_mysql mysql-devel mysql libdbi-dbd-mysql php-mysql 
  perl-DBD-MySQL MySQL-python phpMyAdmin maatkit  (all on one line)
yum install mysql-connector-odbc mysqlclient15 
    mysql-libs mysql-server mod_auth_mysql mysql-devel mysql 
    libdbi-dbd-mysql php-mysql perl-DBD-MySQL MySQL-python 
    phpMyAdmin maatkit   (all on one line)
service mysqld start
service httpd start
[root@omega lib]# php -v 
PHP 5.1.6 (cli) (built: Jan 14 2010 13:11:11) 
Copyright (c) 1997-2006 The PHP Group
Zend Engine v2.1.0, Copyright (c) 1998-2006 Zend Technologies
10-05-10 bacula-5.0.2 installed 
rpmbuild --rebuild --define "build_rhel5 1" --define "build_client_only 1" bacula-5.0.2-1.src.rpm
rpm -Uvh /usr/src/redhat/RPMS/x86_64/bacula-client-5.0.2-1.x86_64.rpm /usr/src/redhat/RPMS/x86_64/bacula-libs-5.0.2-1.x86_64.rpm
10-03-08 mod_evasive installed 
[root@omega ~]# yum install mod_evasive
Edit /etc/httpd/conf.d/mod_evasive.conf to set email addr for reporting.
10-01-21 Installed Bacula Client 
[root@omega src]# scp mail:/usr/src/redhat/RPMS/x86_64/bacula-client-3.0.1-1.x86_64.rpm .
[root@omega src]# rpm -Uvh bacula-client-3.0.1-1.x86_64.rpm
[root@omega src]# vi /etc/bacula/bacula-fd.conf
10-01-17 Installed f*ex (file exchange program)
f*ex runs as a service from xinetd.d. To access it you go to http://omega.phas.ubc.ca:8080/fup 
[root@omega fex-20091210]# ./install -p 8080 142.103.236.90
checking prerequisites
found xinetd
found /usr/lib/sendmail
prerequisites checked, ok
creating user fex
Installing:
bin -> /home/fex/bin
bin/schwuppdiwupp.pl -> /home/fex/bin/schwuppdiwupp.pl
bin/fex_cleanup -> /home/fex/bin/fex_cleanup
bin/sexget -> /home/fex/bin/sexget
bin/sexsend -> /home/fex/bin/sexsend
bin/xx -> /home/fex/bin/xx
bin/fexsend -> /home/fex/bin/fexsend
bin/zz -> /home/fex/bin/zz
bin/fexget -> /home/fex/bin/fexget
bin/fac -> /home/fex/bin/fac
bin/fexsrv -> /home/fex/bin/fexsrv
bin/logwatch -> /home/fex/bin/logwatch
cgi-bin -> /home/fex/cgi-bin
cgi-bin/fur -> /home/fex/cgi-bin/fur
cgi-bin/sex -> /home/fex/cgi-bin/sex
cgi-bin/fix -> /home/fex/cgi-bin/fix
cgi-bin/fup -> /home/fex/cgi-bin/fup
cgi-bin/mma -> /home/fex/cgi-bin/mma
cgi-bin/foc -> /home/fex/cgi-bin/foc
cgi-bin/fop -> /home/fex/cgi-bin/fop
cgi-bin/rup -> /home/fex/cgi-bin/rup
cgi-bin/fuc -> /home/fex/cgi-bin/fuc
lib -> /home/fex/lib
lib/dop -> /home/fex/lib/dop
lib/fex.ph -> /home/fex/lib/fex.ph
lib/fup.pl -> /home/fex/lib/fup.pl
lib/fex.pp -> /home/fex/lib/fex.pp
etc -> /home/fex/etc
etc/xinetd_fex -> /home/fex/etc/xinetd_fex
etc/mime.types -> /home/fex/etc/mime.types
htdocs -> /home/fex/htdocs
htdocs/FAQ.html -> /home/fex/htdocs/FAQ.html
09-10-19 Installed memcached 
yum install memcached

yum install perl-Cache-Memcached

yum install php-pecl-memcache memcached-selinux
Loaded plugins: rhnplugin, security
Setting up Install Process
Resolving Dependencies
--> Running transaction check
---> Package memcached-selinux.x86_64 0:1.2.8-1.el5 set to be updated
---> Package php-pecl-memcache.x86_64 0:2.2.5-1.el5 set to be updated
--> Processing Dependency: php-api = 20041225 for package: php-pecl-memcache
--> Finished Dependency Resolution
php-pecl-memcache-2.2.5-1.el5.x86_64 from epel has depsolving problems
  --> Missing Dependency: php-api = 20041225 is needed by package php-pecl-memcache-2.2.5-1.el5.x86_64 (epel)
Error: Missing Dependency: php-api = 20041225 is needed by package php-pecl-memcache-2.2.5-1.el5.x86_64 (epel)
 You could try using --skip-broken to work around the problem
 You could try running: package-cleanup --problems
                        package-cleanup --dupes
                        rpm -Va --nofiles --nodigest
The program package-cleanup is found in the yum-utils package.

yum install yum-utils
09-09-23 Installed php 5.3 and updated MySQL
Previously I had installed the epel repository as follows: 
wget http://download.fedora.redhat.com/pub/epel/5/i386/epel-release-5-3.noarch.rpm
rpm -Uvh epel-release-5*.rpm
Now install remi repository as follows: 
wget http://rpms.famillecollet.com/enterprise/remi-release-5.rpm
rpm -Uvh remi-release-5*.rpm
Next tried to upgrade php as follows: 
yum --enablerepo=remi update php
Failed with conficts from mysql-libs and mysql. So tried: 
yum --enablerepo=remi update mysql
Got many errors like: 
Transaction Check Error:
  file /etc/my.cnf from install of mysql-libs-5.1.39-1.el5.remi.x86_64 conflicts with file from package mysql-5.0.77-3.el5.i386
  file /usr/share/man/man1/mysqlshow.1.gz from install of mysql-5.1.39-1.el5.remi.x86_64 conflicts with file from package mysql-5.0.77-3.el5.i386
So did the following: 
yum install t1lib
cd /var/cache/yum/remi/packages
rpm -Uvh --replacefiles *.rpm
Preparing...                ########################################### [100%]

WARNING : This php-* RPM are not official Fedora build and
overrides the official ones. Don't file bugs on Fedora Project.

Use dedicated forums http://forums.famillecollet.com/

   1:php-common             warning: /etc/php.ini created as /etc/php.ini.rpmnew
########################################### [  6%]

WARNING : This MySQL RPM is not an official Fedora build and it
overrides the official one. Don't file bugs on Fedora Project.
Use dedicated forums http://forums.famillecollet.com/

   2:mysql-libs             ########################################### [ 12%]
   3:mysqlclient15          ########################################### [ 18%]
   4:mysql                  ########################################### [ 24%]
   5:php-cli                ########################################### [ 29%]
   6:php                    ########################################### [ 35%]
   7:sqlite2                ########################################### [ 41%]
   8:php-pdo                ########################################### [ 47%]
   9:mysql-devel            ########################################### [ 53%]
  10:mysql-server           ########################################### [ 59%]
  11:php-devel              ########################################### [ 65%]
  12:php-gd                 ########################################### [ 71%]
  13:php-ldap               ########################################### [ 76%]
  14:php-mbstring           ########################################### [ 82%]
  15:php-mcrypt             ########################################### [ 88%]
  16:php-mysql              ########################################### [ 94%]
  17:php-odbc               ########################################### [100%]

yum --enablerepo=remi install php-xml

yum --enablerepo=remi update phpMyAdmin
php-xml satisfys the "dom" extension requirement of magento.

Everything appears to be OK so far - I have restarted MySQL and php now is at version 5.3.0.
09-07-28 Installed MySQL-zrm - backup for MySQL dbases 
cd /usr/local/src
yum install perl-XML-Parser
wget http://www.zmanda.com/downloads/community/ZRM-MySQL/2.1/RPM/MySQL-zrm-2.1-1.noarch.rpm
rpm -Uvh MySQL-zrm-2.1-1.noarch.rpm
09-07-21 Installed maakit - A toolkit that provides advanced functionality for MySQL. 
cd /usr/local/src
wget http://maatkit.googlecode.com/files/maatkit-4047-1.noarch.rpm
yum install perl-TermReadKey
rpm -Uvh maatkit-4047-1.noarch.rpm
09-07-18 Installed RAID monitoring Software ( ServeRAID MR Support CD) 
cd /usr/local/src
mount -o loop ibm_sw_sraidmr_10.35_anyos_32-64.iso /mnt/iso
yum install libXp
yum install net-snmp
cd /mnt/iso/MSM/Linux/
./install.sh 
[root@omega Linux]# rpm -qa | grep -i mega
MegaRAID_Storage_Manager-2.91-03
YYY home 
-
ZZZ home 
-

NOTES:
passwd, shadow, group files:   rsync'd from alpha hourly via /etc/cron.hourly/passwd
/www:   samba shared (/var/httpd/htdocs only to trek/ada2)
WWW STATS

After editing httpd.conf, run the apachectl configtest to test your config.
RSYNC info:
[root@www sysadmin]# crontab -l 
-
09-06-26 Ran UpdateXpress: 
[root@omega]# cd /opt/sysadmin/IBM/UpdateXpress
[root@omega UpdateXpress]# ./uxspi300.rhel5 &

(1) Broadcom BNX2 RHEL5 Driver
	Name: Broadcom BNX2 RHEL5 Driver
	New Version: 	bnx2-1.8.2b
	Reboot: 	Reboot Required to take effect
	Status: 	Successfully Installed

(2) IBM and LSI Basic or Integrated RAID SAS Controller Driver
	Name: IBM and LSI Basic or Integrated RAID SAS Controller Driver
	New Version: 	4.16.80.01
	Reboot: 	Reboot Required to take effect
	Status: 	Successfully Installed
Installed phpMyAdmin 
[root@omega ~]# rpm -Uv http://download.fedora.redhat.com/pub/epel/5/x86_64/epel-release-5-3.noarch.rpm 
Retrieving http://download.fedora.redhat.com/pub/epel/5/x86_64/epel-release-5-3.noarch.rpm
warning: /var/tmp/rpm-xfer.pzvNVL: Header V3 DSA signature: NOKEY, key ID 217521f6
Preparing packages for installation...
epel-release-5-3
[root@omega ~]# yum install phpMyAdmin
Loaded plugins: rhnplugin, security
epel                                                                                | 2.1 kB     00:00     
primary.sqlite.bz2                                                                  | 3.2 MB     00:01     
Setting up Install Process
Parsing package install arguments
Resolving Dependencies
--> Running transaction check
---> Package phpMyAdmin.noarch 0:2.11.9.5-1.el5 set to be updated
--> Processing Dependency: php-mbstring >= 4.1.0 for package: phpMyAdmin
--> Running transaction check
---> Package php-mbstring.x86_64 0:5.1.6-23.2.el5_3 set to be updated
--> Processing Dependency: php-common = 5.1.6-23.2.el5_3 for package: php-mbstring
--> Running transaction check
--> Processing Dependency: php-common = 5.1.6-23.el5 for package: php
--> Processing Dependency: php-common = 5.1.6-23.el5 for package: php-cli
--> Processing Dependency: php-common = 5.1.6-23.el5 for package: php-pdo
--> Processing Dependency: php-common = 5.1.6-23.el5 for package: php-odbc
--> Processing Dependency: php-common = 5.1.6-23.el5 for package: php-ldap
--> Processing Dependency: php-common = 5.1.6-23.el5 for package: php-mysql
---> Package php-common.x86_64 0:5.1.6-23.2.el5_3 set to be updated
--> Running transaction check
---> Package php-mysql.x86_64 0:5.1.6-23.2.el5_3 set to be updated
---> Package php-pdo.x86_64 0:5.1.6-23.2.el5_3 set to be updated
---> Package php-ldap.x86_64 0:5.1.6-23.2.el5_3 set to be updated
---> Package php.x86_64 0:5.1.6-23.2.el5_3 set to be updated
---> Package php-cli.x86_64 0:5.1.6-23.2.el5_3 set to be updated
---> Package php-odbc.x86_64 0:5.1.6-23.2.el5_3 set to be updated
--> Finished Dependency Resolution

Dependencies Resolved

===========================================================================================================
 Package                Arch             Version                      Repository                      Size
===========================================================================================================
Installing:
 phpMyAdmin             noarch           2.11.9.5-1.el5               epel                           4.2 M
Updating:
 php                    x86_64           5.1.6-23.2.el5_3             rhel-x86_64-server-5           1.2 M
 php-cli                x86_64           5.1.6-23.2.el5_3             rhel-x86_64-server-5           2.2 M
 php-common             x86_64           5.1.6-23.2.el5_3             rhel-x86_64-server-5           152 k
 php-ldap               x86_64           5.1.6-23.2.el5_3             rhel-x86_64-server-5            37 k
 php-mysql              x86_64           5.1.6-23.2.el5_3             rhel-x86_64-server-5            88 k
 php-odbc               x86_64           5.1.6-23.2.el5_3             rhel-x86_64-server-5            53 k
 php-pdo                x86_64           5.1.6-23.2.el5_3             rhel-x86_64-server-5            65 k
Installing for dependencies:
 php-mbstring           x86_64           5.1.6-23.2.el5_3             rhel-x86_64-server-5           1.0 M

Transaction Summary
===========================================================================================================
Install      2 Package(s)         
Update       7 Package(s)         
Remove       0 Package(s)         

Total download size: 8.9 M
Is this ok [y/N]: y
Downloading Packages:
(1/9): php-ldap-5.1.6-23.2.el5_3.x86_64.rpm                                         |  37 kB     00:00     
(2/9): php-odbc-5.1.6-23.2.el5_3.x86_64.rpm                                         |  53 kB     00:00     
(3/9): php-pdo-5.1.6-23.2.el5_3.x86_64.rpm                                          |  65 kB     00:00     
(4/9): php-mysql-5.1.6-23.2.el5_3.x86_64.rpm                                        |  88 kB     00:00     
(5/9): php-common-5.1.6-23.2.el5_3.x86_64.rpm                                       | 152 kB     00:00     
(6/9): php-mbstring-5.1.6-23.2.el5_3.x86_64.rpm                                     | 1.0 MB     00:01     
(7/9): php-5.1.6-23.2.el5_3.x86_64.rpm                                              | 1.2 MB     00:01     
(8/9): php-cli-5.1.6-23.2.el5_3.x86_64.rpm                                          | 2.2 MB     00:01     
(9/9): phpMyAdmin-2.11.9.5-1.el5.noarch.rpm                                         | 4.2 MB     00:00     
-----------------------------------------------------------------------------------------------------------
Total                                                                      892 kB/s | 8.9 MB     00:10     
warning: rpmts_HdrFromFdno: Header V3 DSA signature: NOKEY, key ID 37017186
Importing GPG key 0x37017186 "Red Hat, Inc. (release key) <security@redhat.com>" from /etc/pki/rpm-gpg/RPM-GPG-KEY-redhat-release
Is this ok [y/N]: y
warning: rpmts_HdrFromFdno: Header V3 DSA signature: NOKEY, key ID 217521f6
Importing GPG key 0x217521F6 "Fedora EPEL <epel@fedoraproject.org>" from /etc/pki/rpm-gpg/RPM-GPG-KEY-EPEL
Is this ok [y/N]: y
Running rpm_check_debug
Running Transaction Test
Finished Transaction Test
Transaction Test Succeeded
Running Transaction
  Updating       : php-common                                      [ 1/16] 
  Updating       : php-pdo                                         [ 2/16] 
  Updating       : php-mysql                                       [ 3/16] 
  Installing     : php-mbstring                                    [ 4/16] 
  Updating       : php-cli                                         [ 5/16] 
  Updating       : php                                             [ 6/16] 
  Installing     : phpMyAdmin                                      [ 7/16] 
  Updating       : php-ldap                                        [ 8/16] 
  Updating       : php-odbc                                        [ 9/16] 
  Cleanup        : php-common                                      [10/16] 
  Cleanup        : php                                             [11/16] 
  Cleanup        : php-ldap                                        [12/16] 
  Cleanup        : php-pdo                                         [13/16] 
  Cleanup        : php-mysql                                       [14/16] 
  Cleanup        : php-cli                                         [15/16] 
  Cleanup        : php-odbc                                        [16/16] 

Installed: phpMyAdmin.noarch 0:2.11.9.5-1.el5
Dependency Installed: php-mbstring.x86_64 0:5.1.6-23.2.el5_3
Updated: php.x86_64 0:5.1.6-23.2.el5_3 php-cli.x86_64 0:5.1.6-23.2.el5_3 php-common.x86_64 0:5.1.6-23.2.el5_3 php-ldap.x86_64 0:5.1.6-23.2.el5_3 php-mysql.x86_64 0:5.1.6-23.2.el5_3 php-odbc.x86_64 0:5.1.6-23.2.el5_3 php-pdo.x86_64 0:5.1.6-23.2.el5_3
Complete!
-
DISASTER RECOVERY
  1. Install a new server.
  2. Load RHEL V5. 
Additional, non-critical items to take care of:
  1. Install APCUPSD
  2. Check webalizer installation (web stats).
DISASTER RECOVERY
  1. Install a new server.
  2. Load RHEL V5  (or newer).
  3. Make sure you select to install the web server and associated modules.
  4. Make sure you select to install the mysql server and associated modules.
  5. Copy over backup files from alpha:/home/backups/www (these files are rsync'd daily).
  6. Make sure mysqld and httpd are started.
  7. Make sure to set a root password for mysqld (admin -u root password newpassword).
  8. Install phpMyAdmin. Create phpMyAdmin dbases: mysql -u root -p < create_tables_mysql_4_1_2+.sql
  9. Install php-mbstring package from redhat network package archive so phpMyAdmin doesn't complain.
  10. Get include files installed into /php/includes.
  11. Check /etc/php.ini configuration file.
  12. Check /etc/http/conf configuration files including certificate files. 
    /etc/http/conf/ssl.crt/www.phas.ubc.ca.crt
               /etc/http/conf/ssl.crt/gd_bundle.crt
               /etc/http/conf/ssl.key/www.phas.ubc.ca.key
  13. Install MySQL-zrm.
Additional, non-critical items to take care of:
  1. Install APCUPSD
  2. Check webalizer installation (web stats).

MySQL Backups
 Using Zmanda   (ZRM for MySQL Community Edition - version 1.2.1)
The MySQL databases are backed up nightly (see crontab -l output below).
Configuration data is kept in files in /etc/mysql-zrm.
Backups are kept in /home/backups/omega/var/lib/mysql-zrm
Logs are kept in /var/log/mysql-zrm

To run a backup immediately: mysql-zrm-scheduler --now --backup-set BackupSet01[02,03]
To Schedule a (daily at 5am) backup: mysql-zrm-scheduler --add --interval daily --start 05:00 --backup-level 0 --backup-set BackupSet01
Verification that scheduler has been configured: mysql-zrm-scheduler --query

Backup Reports: 
mysql-zrm-reporter --help (to see all options)
mysql-zrm-reporter --destination /home/backups/omega/var/lib/mysql-zrm/ --where backup-set=daily --show backup-method-info
mysql-zrm-reporter --destination /home/backups/omega/var/lib/mysql-zrm/ --where backup-set=daily --show backup-retention-info
mysql-zrm-reporter --destination /home/backups/omega/var/lib/mysql-zrm/ --where backup-set=monthly --show backup-performance-info
mysql-zrm-reporter --destination /home/backups/omega/var/lib/mysql-zrm/ --where backup-set=monthly --show restore-full-info
mysql-zrm-reporter --destination /home/backups/omega/var/lib/mysql-zrm/ --where backup-set=daily --show restore-incr-info
Restoring Databases:
  1. Find our which backups are available: 
    mysql-zrm-reporter --destination /home/backups/omega/var/lib/mysql-zrm/ --where backup-set=daily -show restore-info
mysql-zrm-reporter --destination /home/backups/omega/var/lib/mysql-zrm/ --where backup-set=monthly -show restore-info
  2. Assuming you want to restore the backup which is in /home/backups/omega/var/lib/mysql-zrm/monthly/20061114144656: 
    mysql-zrm --action restore --backup-set monthly --source-directory /home/backups/omega/var/lib/mysql-zrm/monthly/20061114144656

08-08-xx
-

08-08-xx

Setting up the Xen host - RHEL 5

NOTE: RHEL 5's SELinux (Security Enhanced Linux) policy expects images to live in /var/lib/xen/images.

Setting up the Xen hypervisor and domain 0 is straightforward. The procedure goes like this:

  1. Install RHEL 5.1 normally on a local drive. You can install for SAN boot as well, but that is outside the scope of this article.
  2. After you have RHEL 5.1 up and running, install the Xen kernel from the installation source, like this:

    Listing 1. Installing the Xen kernel packages
    rpm -ivh kernel-xen-2.6.18-53.el5.i686.rpm
rpm -ivh kernel-xen-devel-2.6.18-53.el5.i686.rpm
  3. Now you should have a new entry in your boot manager, /boot/grub/grub.conf. Make sure it boots the Xen kernel by default. Reboot the system.
  4. Verify that you're now running the Xen kernel after reboot:

    Listing 2. Verifying the Xen kernel
                            
[root@xenhost ~]# uname -a
Linux xenhost 2.6.18-53.el5xen #1 SMP Wed Oct 10 17:06:12 EDT 2007 i686 i686 i386 
 GNU/Linux
  5. Congratulation! You now have a Xen hypervisor with Dom0 running on top of it.

Installing the Xen tools

Now that Xen is running, you need to install some tools to interact with it. In the RHEL 5.1 installation source, the Xen tools are in the /VT directory. The basic command-line tools are very powerful but not pretty, and the graphical tool is easy to use but not powerful. That's life! Anyway, let's go ahead and install both of them.

These are the dependent packages that you have to install first; get them from the /Server directory on the DVD or CDs:

Listing 3. Installing the dependent packages for Xen tools 
rpm -ivh bridge-utils-1.1-2.i386.rpm
rpm -ivh dnsmasq-2.39-2.el5.i386.rpm
rpm -ivh gnome-python2-gnomekeyring-2.16.0-1.fc6.i386.rpm
rpm -ivh xen-libs-3.0.3-41.el5.i386.rpm

When installing the Xen tools packages, it seems to me that there is a circular dependency no matter what order I install them in, so I have to force the first package to install without dependency verification and then install the rest in this order:

Listing 4. Installing the Xen tools packages
rpm -ivh --nodeps libvirt-0.2.3-9.el5.i386.rpm
rpm -ivh libvirt-devel-0.2.3-9.el5.i386.rpm
rpm -ivh libvirt-python-0.2.3-9.el5.i386.rpm
rpm -ivh python-virtinst-0.103.0-3.el5.noarch.rpm
rpm -ivh xen-3.0.3-41.el5.i386.rpm
rpm -ivh xen-devel-3.0.3-41.el5.i386.rpm
rpm -ivh virt-manager-0.4.0-3.el5.i386.rpm
rpm -ivh gnome-applet-vm-0.1.2-1.el5.i386.rpm
rpm -ivh Virtualization-en-US-5.1.0-12.noarch.rpm

Alright, let's kick some tires and try some commands now! But before you do that, you have to start the xend daemon. All of the Xen management tools communicate with the xend daemon to extract information. To start it, run xend start as root. Normally the xend service is set to start at system boot, so you don't have to do this every time.

Now you can run the command xm info to see some information from the Xen hypervisor.

Listing 5. Displaying the Xen hypervisor information
[root@xenhost ~]# xm info
host                   : xenhost
release                : 2.6.18-53.el5xen
version                : #1 SMP Wed Oct 10 17:06:12 EDT 2007
machine                : i686
nr_cpus                : 4
nr_nodes               : 1
sockets_per_node       : 2
cores_per_socket       : 2
threads_per_core       : 1
cpu_mhz                : 2992
hw_caps                : bfebfbff:20100000:00000000:00000140:0004e3bd:00000000:00000001
total_memory           : 4095
free_memory            : 20
xen_major              : 3
xen_minor              : 1
xen_extra              : .0-53.el5
xen_caps               : xen-3.0-x86_32p hvm-3.0-x86_32 hvm-3.0-x86_32p
xen_pagesize           : 4096
platform_params        : virt_start=0xf5800000
xen_changeset          : unavailable
cc_compiler            : gcc version 4.1.2 20070626 (Red Hat 4.1.2-14)
cc_compile_by          : brewbuilder
cc_compile_domain      : build.redhat.com
cc_compile_date        : Wed Oct 10 16:30:55 EDT 2007
xend_config_format     : 2

Then you can run the command xm list to see the running virtual machines. Naturally at this point, you'll only see the domain 0 running. You can use xentop for this as well.

Listing 6. Listing the running Xen guests
[root@xenhost ~]# xm list
Name                                      ID Mem(MiB) VCPUs State   Time(s)
Domain-0                                   0     2928     4 r-----  61790.3

If those two commands run successfully, then you can be assured that your Xen environment is configured properly. If the commands can't connect to the xend daemon, try to reboot the machine. Alternatively, you can look at the Xen logs in the /var/log/xen directory.

If you prefer a graphical tool, log on to a Gnome session, and then go to the menu Applications > System Tools > Virtual Machine Manager. You should see the status of your virtual machines as in Figure 4.

Figure 4. Virtual Machine Manager main panel
Virtual Machine Manager main panel

Installing the multipath driver

Now that the Xen environment is up and running, it's time to install the drivers to access the SAN storage. The first thing to install is the HBA adapter driver, which is the QLogic driver in my case. Download the QLogic driver installation package from the vendor's Web site and install it according to its documentation. You must turn off the default failover option afterward by adding an option in /etc/modprobe.conf as follows:


Listing 7. Option to disable QLogic driver failover
options qla2xxx ql2xfailover=0
The rest of this article (Multipath storage with Xen and DS4800)...
08-03-28

How to: Install and Setup XEN Virtualization software on CentOS:

  1. Login as the root and type the following commands:
    # yum install xen virt-manager kernel-xen
    # chkconfig xend on
    # reboot
  2. Boot your server using XEN kernel.
  3. Now use gui tool called virt-manager:
    # virt-manager &
08-01-xx
webmaster@phas.ubc.ca [Dept. Home Page] last updated: 07/08/22