APEL
APEL
ncm-apel only writes the configuration file for both the ce/gk and the rgma-server
- RGMA_SERVER: /opt/glite/etc/glite-apel-publisher/publisher-config.xml
- CE/GK: /opt/glite/etc/glite-apel-pbs/parser-config.xml
What is needed (only once) is to configure the mysql-server on the RGMA-server to accept the APEL data. This data is fed into the db through cron-jobs
- RGMA_SERVER: /etc/cron.d/apel-publisher.ncm-cron.cron
- CE/GK: /etc/cron.d/apel-pbs-log-parser.ncm-cron.cron
Run the commands in these jobs to see if all is working well.
Initial configuration
- set APEL_HOME vairable (eg check the cron job)
export APEL_HOME=/opt/glite
Run the following script to setup the accounting DB-structure on the RGMA-server only: /opt/glite/share/glite-apel-core/scripts/apel-db-config.py Follow the instructions on what to add as variables (values such as user, db adn password can be found in the /opt/glite/etc/glite-apel-publisher/publisher-config.xml file). Eg. /opt/glite/share/glite-apel-core/scripts/apel-db-config.py --user accounting --password yeah_right --database accounting --gkhost gridce.iihe.ac.be --cehost gridce.iihe.ac.be -o ./accounting.sql It will create a .sql-file. Then one has to run
mysql -u root -p < ./accounting.sql
Then run the cron-jobs to test the config.
Remark 1: when you see something like
apel-publisher - Checking valid CPU spec data exists apel-publisher - program aborted apel-publisher - Cannot generate any accounting records because no cpu spec value is defined in the SpecRecords table, spec values are added when running the CPUProcessor, check user documentation for more help
First run the cron-job on the CE, it will fix this.
Remark 2: because we have separate private routes from our CE to pur RGMA-server, we had to add an extra line in the accounting.sql to allow connection through this interface (CE is gridce.iihe.ac.be, private address is gridce.wn.iihe.ac.be).
use mysql;
INSERT INTO user (host,user,password,create_priv, drop_priv) VALUES ('gridce.wn.iihe.ac.be','accounting',password('yeah_right'),'Y','Y');
flush privileges;
Accessing the mysql database
- To access the database on APEL
mysql -u accounting -h apel.iihe.ac.be -p
- The password can be found in
cat /etc/accounting.conf
In case of data not being published
In case the data is not being published, the gap needs to be closed.
the info on how to do this can be found in this page: ApelGapPublishing