Hello,
When configuring RMON yaim function config_apel_rgma is executed.
config_apel_rgma performs mysql command:
mysql --pass=$MYSQL_PASSWORD --exec "grant all on accounting.* to
'accounting'@'localhost' identified by 'APELDB_PWD'"
I've executed this command once more but with
[log in to unmask]
After that /opt/edg/sbin/edg-rgma-apel -f /opt/edg/etc/edg-rgma/apel.xml
>> /var/log/apel.log
executed successfully.
Thu Mar 24 17:29:08 UTC 2005: edg-rgma-apel - Read-in configuration:
[quiet, j]{DBUsername=[accounting],
DBURL=[jdbc:mysql://localhost/accounting], site=[ru-SPB-PNPI-HEPD],
DBPassword=[APELDB_PWD], joinDelay=[0]}
Thu Mar 24 17:29:08 UTC 2005: edg-rgma-apel - ------ Starting the apel
application ------
Thu Mar 24 17:29:08 UTC 2005: edg-rgma-apel - **** Combining tables and
republishing in LcgRecords ****
Thu Mar 24 17:29:08 UTC 2005: edg-rgma-apel - Optimising table: LcgRecords
Thu Mar 24 17:29:08 UTC 2005: edg-rgma-apel - Optimising table: GkRecords
Thu Mar 24 17:29:08 UTC 2005: edg-rgma-apel - Optimising table:
EventRecords
Thu Mar 24 17:29:08 UTC 2005: edg-rgma-apel - Optimising table:
MessageRecords
Thu Mar 24 17:29:08 UTC 2005: edg-rgma-apel - Stitching together all
accounting
records
Thu Mar 24 17:29:08 UTC 2005: edg-rgma-apel - Stitching completed
Thu Mar 24 17:29:08 UTC 2005: edg-rgma-apel - WARNING - No accounting
records were generated
Thu Mar 24 17:29:08 UTC 2005: edg-rgma-apel - **** Join processing
complete ****Thu Mar 24 17:29:08 UTC 2005: edg-rgma-apel - ------
Processing finished ---
Why were No accounting records generated ?
However there is one more apel related problem.
I've installed CE, SE, MON, WN on one machine.
When configuring CE_torque yaim function config_apel_pbs is executed.
config_apel_pbs writes to /opt/edg/etc/edg-rgma/apel.xml information
related to CPUProcessor, PBSLogProcessor, GKLogProcessor.
When configuring MON yaim function config_apel_rgma is executed.
It writes its own information to /opt/edg/etc/edg-rgma/apel.xml and
erases the information previously written by config_apel_pbs function.
What to do ? Should I merge the information from both functions to
/opt/edg/etc/edg-rgma/apel.xml ?
Or anything else ?
Thank you.
On Tue, 22 Mar 2005, Steve Traylen wrote:
> Date: Tue, 22 Mar 2005 12:54:00 +0000
> From: Steve Traylen <[log in to unmask]>
> Reply-To: LHC Computer Grid - Rollout <[log in to unmask]>
> To: [log in to unmask]
> Subject: Re: [LCG-ROLLOUT] edg-rgma-apel error
>
> On Tue, Mar 22, 2005 at 03:33:19PM +0300 or thereabouts, Anatoly Oreshkin wrote:
> > Hello,
> >
> > In file /var/log/apel.log I see error messages:
> >
> > Tue Mar 22 10:46:06 UTC 2005: edg-rgma-apel - Read-in configuration:
> > [quiet, j]{DBUsername=[accounting],
> > DBURL=[jdbc:mysql://localhost/accounting], site=[ru-SPB-PNPI-HEPD],
> > DBPassword=[APELDB_PWD], joinDelay=[0]}
> > Tue Mar 22 10:46:06 UTC 2005: edg-rgma-apel - ------ Starting the apel
> > application ------
> > Tue Mar 22 10:46:06 UTC 2005: edg-rgma-apel - **** Combining tables and
> > republishing in LcgRecords ****
> > Tue Mar 22 10:46:06 UTC 2005: edg-rgma-apel - program aborted
> > org.edg.info.apel.ApelException: Unable to setup a database connection:
> > Invalid
> > authorization specification: Access denied for user:
> > [log in to unmask] (Using password: YES)
> > at org.edg.info.apel.DBUtils.createConnection(DBUtils.java:58)
> > at org.edg.info.apel.DBUtils.<init>(DBUtils.java:41)
> > at org.edg.info.apel.Table.<init>(Table.java:58)
> > at
> > org.edg.info.apel.LcgRecordsTable.<init>(LcgRecordsTable.java:28)
> > 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)
> >
> >
> > I have no user accounting on my cluster. Should I create it ?
> > Why didn't it created automatically when installing LCG2 ?
> >
> > How can I enable access for accounting user to database ?
>
> This is just a mysql access error, your apel clients must be able
> to access the mysql accounting database.
>
> Steve
> >
> > Thank you.
>
> --
> Steve Traylen
> [log in to unmask]
> http://www.gridpp.ac.uk/
>
|