Hi
We received a bug about this
LCG Operations #6205
which probably applies to your case. The apel comfiguration as performed
by YAIM is buggy in that the mysql permissions are insufficient. The
apel client on the CE is supposed to "talk" directly to the mysql
database in the MON box and as such permission to do so must be granted
at the server side (MON BOX). The fix is already being placed in the cvs
branch of the next release. Meanwhile you can simply grant access to the
CE node manually.
Apologies for the problem.
Alessandro
-----Original Message-----
From: LHC Computer Grid - Rollout [mailto:[log in to unmask]]
On Behalf Of Andreas Nowack
Sent: Wednesday, February 02, 2005 2:57 PM
To: [log in to unmask]
Subject: [LCG-ROLLOUT] Problem with apel's accounting db
Hello,
I have some problems with the accounting database on our combined SE and
MON.
During configuration the accounting database and a db user "accounting"
were created. But the cronjob calling "/opt/edg/sbin/edg-rgma-apel -f
/opt/edg/etc/edg-rgma/apel.xml"
fails:
> Wed Feb 2 13:40:38 UTC 2005: edg-rgma-apel - Read-in configuration:
> [quiet, j]{DBUsername=[accounting],
> DBURL=[jdbc:mysql://localhost/accounting], site=[RWTH-Aachen-Test],
> DBPassword=[xxx], joinDelay=[0]} Wed Feb 2 13:40:38 UTC 2005:
> edg-rgma-apel - ------ Starting the apel application ------ Wed Feb 2
> 13:40:38 UTC 2005: edg-rgma-apel - **** Combining tables and
> republishing in LcgRecords **** Wed Feb 2 13:40:38 UTC 2005:
> edg-rgma-apel - Optimising table: LcgRecords Wed Feb 2 13:40:38 UTC
> 2005: edg-rgma-apel - program aborted
> org.edg.info.apel.ApelException: General error: select command denied
to user: [log in to unmask] for table 'LcgRecords'
> at org.edg.info.apel.Table.optimize(Table.java:136)
> at
org.edg.info.apel.LcgRecordsTable.<init>(LcgRecordsTable.java:30)
> at org.edg.info.apel.JoinProcessor.run(JoinProcessor.java:60)
> at
org.edg.info.apel.JoinProcessor.runIfNeeded(JoinProcessor.java:48)
> at org.edg.info.apel.Apel.run(Apel.java:36)
> at org.edg.info.apel.Apel.main(Apel.java:55)
The user root can access this table, but it is empty:
> [root@accip41 apel]# mysql -v -u root -D accounting -p --exec "select
* from LcgRecords;"
> Enter password:
> --------------
> select * from LcgRecords
> --------------
>
> [root@accip41 apel]# mysql -v -u accounting -h localhost.localdomain
-D accounting -p --exec "select * from LcgRecords;"
> Enter password:
> --------------
> select * from LcgRecords
> --------------
>
> ERROR 1142 at line 1: select command denied to user:
[log in to unmask] for table 'LcgRecords'
edg-rgma-apel-test fails for a similar reason:
"org.edg.info.apel.ApelException: General error: select command denied
to user: [log in to unmask] for table 'SpecRecords'"
I don't know what to do. Who can help?
Best regards,
Andreas
------------------------------------------------------------------------
------
Dr. Andreas Nowack email:
[log in to unmask]
RWTH Aachen
III. Phys. Institut B
Sommerfeldstr. / Physikzentrum phone: +49 241 80-27306,-27288
D-52056 Aachen fax: +49 241 80-22244
Germany
------------------------------------------------------------------------
------
|