Before Starting

• SL5/64bit installation according to the generic guidelines
• list of Computing Element hostnames

Service installation

yum install mysql-server emi-apel

Service Configuration

See APEL Admin Guide, section "3. Installation Instructions"

Steps:

service mysqld start
chkconfig --level 345 mysqld on
mysqladmin password -u root "good_password"

cd ~/
mkdir -m 700 yaim
cd yaim

Cycle for each CE:

for CE in cert-07.cnaf.infn.it cert-09.cnaf.infn.it emitestbed02.cnaf.infn.it; do
  cat > site-info.def.$CE <<EOF
MYSQL_PASSWORD=good_password
SITE_NAME=emitb
CE_HOST=$CE
APEL_DB_PASSWORD=good-apel-password
MON_HOST=`hostname -f`
EOF
done

for i in site-info.def.*; do
  /opt/glite/yaim/bin/yaim -c -n glite-APEL -s $i
  echo "OK?"
  read x
done

Service Testing

Check /var/log/apel.log after a day (see cron).

Looking at the data

#mysql -u accounting -pPWD accounting
mysql -u root -pPWD accounting
   SELECT * FROM EventRecords

-- FrantisekDvorak - 29-May-2011