Hi
Is this deletion "normal"? Perhaps someone could raise a savannah bug if
it is something that should be corrected (but has not yet been notified
to the YAIM developers).
Thanks,
Jeremy
> -----Original Message-----
> From: Testbed Support for GridPP member institutes [mailto:TB-
> [log in to unmask]] On Behalf Of David Robson
> Sent: 02 April 2007 13:38
> To: [log in to unmask]
> Subject: Re: Problem reporting accounting data to GOC
>
> Hi Alessandra
>
> Yes, you are right. Not only did glite 3.0 Update 12 remove our mysql
> entry from /etc/passwd file,
> it also removed it from /etc/group. The ownership of the BlahRecords
> files were changed from
> mysql:mysql to root:root. After reversing these changes and
restarting
> services, we are now
> publishing accounting data again.
>
> Thanks for your help
>
> Dave
>
>
>
> Alessandra Forti wrote:
> > Hi David,
> >
> > it might be a permission problem especially if YAIM has deleted the
> > mysql account. Does the file BlahRecords belong to mysql:mysql with
> > 660 permissions?
> >
> > cheers
> > alessandra
> >
> > David Robson wrote:
> >> Hi,
> >>
> >> We (EFDA-JET) have just received a ticket (* GGUS ID: * 19448) to
say
> >> that EDFA-JET has not been
> >> reporting accounting data to GOC since 2007-01-28. This coincides
> >> with us upgrading to glite 3.0
> >> Update 12. On investigation, we found that the update had removed
> >> the mysql entry from
> >> /etc/passwd. We reinstated the entry and restarted all services.
> >> However, we are still not
> >> publishing. We then did a yum update for glite to update 17.
Still
> >> not publishing.
> >>
> >> On running
> >>
> >> env RGMA_HOME=/opt/glite APEL_HOME=/opt/glite
> >> /opt/glite/bin/apel-publisher -f
> >> /opt/glite/etc/glite-apel-publisher/publisher-config-yaim.xml
> >>
> >> We get the error message shown at the end of this email
> >>
> >> Firstly, does anyone know about the "Can't find file:
> >> './accounting/BlahdRecord
> >> s.frm' (errno: 13)" message? We do have one
> >> (/var/lib/mysql/accounting/BlahdRecords.frm),
> >> but I assume that either,
> >>
> >> a) a process is running in the wrong directory
> >>
> >> or
> >>
> >> b) Some environmental variable is not set
> >>
> >>
> >> Any ideas anyone??
> >>
> >> Dave
> >>
> >>
> >> env RGMA_HOME=/opt/glite APEL_HOME=/opt/glite
> >> /opt/glite/bin/apel-publisher -f
> >> /opt/glite/etc/glite-apel-publisher/publisher-config-yaim.xml
> >>
> >> BC_PROVIDER is not set, using default location
> >> ...
/opt/glite/share/glite-security-trustmanager/bcprov-jdk14-122.jar
> >> Fri Mar 23 16:58:26 UTC 2007: apel-publisher - Read-in
configuration:
> >> [logenabled, j] [DBUsername=accounting,
> >> DBURL=jdbc:mysql://grid003.jet.efda.org:3306/accounting,
> >> DBPassword=****, site=EFDA-JET, republish=missing]
> >> Fri Mar 23 16:58:26 UTC 2007: apel-publisher - ------ Starting the
> >> apel application ------
> >> Fri Mar 23 16:58:26 UTC 2007: apel-publisher - Optimising table:
> >> EventRecords
> >> Fri Mar 23 16:58:26 UTC 2007: apel-publisher - Optimising table:
> >> GkRecords
> >> Fri Mar 23 16:58:26 UTC 2007: apel-publisher - Optimising table:
> >> MessageRecords
> >> Fri Mar 23 16:58:26 UTC 2007: apel-publisher - Optimising table:
> >> SpecRecords
> >> Fri Mar 23 16:58:26 UTC 2007: apel-publisher - Optimising table:
> >> LcgRecords
> >> Fri Mar 23 16:58:26 UTC 2007: apel-publisher - Checking Blahd
table:
> >> BlahdRecords
> >> Fri Mar 23 16:58:26 UTC 2007: apel-publisher - Can't find file:
> >> './accounting/BlahdRecords.frm' (errno: 13)
> >> Fri Mar 23 16:58:26 UTC 2007: apel-publisher - Creating Blahd
table:
> >> Fri Mar 23 16:58:26 UTC 2007: apel-publisher - Optimising table:
> >> BlahdRecords
> >> Fri Mar 23 16:58:26 UTC 2007: apel-publisher - **** Combining
tables
> >> and republishing in LcgRecords ****
> >> Fri Mar 23 16:58:26 UTC 2007: apel-publisher - Checking valid CPU
> >> spec data exists
> >> Fri Mar 23 16:58:26 UTC 2007: apel-publisher - CPU spec values
found
> >> Fri Mar 23 16:58:51 UTC 2007: apel-publisher -
> >> ====================================
> >> Fri Mar 23 16:58:51 UTC 2007: apel-publisher - Synchronisation
> >> data check Fri Mar 23 16:58:51 UTC 2007: apel-publisher -
> >> ====================================
> >> Fri Mar 23 16:58:52 UTC 2007: apel-publisher - Finding all records
in
> >> local database since the last successful publish timestamp :
> >> 2007-03-23 10:40:23
> >> Fri Mar 23 16:58:52 UTC 2007: apel-publisher - No records found
> >> Fri Mar 23 16:58:52 UTC 2007: apel-publisher -
> >> ====================================
> >> Fri Mar 23 16:58:52 UTC 2007: apel-publisher - Completed
> >> Synchronisation data check
> >> Fri Mar 23 16:58:52 UTC 2007: apel-publisher -
> >> ====================================
> >> Fri Mar 23 16:58:52 UTC 2007: apel-publisher - Publisher Mode =
Apel
> >> Publisher (Default)
> >> Fri Mar 23 16:58:52 UTC 2007: apel-publisher - Building account
> >> records for LCG CE
> >> Fri Mar 23 16:58:52 UTC 2007: apel-publisher - LCG CE: Stitching
> >> together all accounting records
> >> Fri Mar 23 16:58:52 UTC 2007: apel-publisher - LCG CE: Stitching
> >> completed
> >> Fri Mar 23 16:58:52 UTC 2007: apel-publisher - No accounting data
to
> >> store
> >> Fri Mar 23 16:58:52 UTC 2007: apel-publisher - Number of Joined
> >> accounting records: 0
> >> Fri Mar 23 16:58:52 UTC 2007: apel-publisher - Build complete
> >> Fri Mar 23 16:58:52 UTC 2007: apel-publisher - Building account
> >> records for data through the new Glite CE
> >> Fri Mar 23 16:58:52 UTC 2007: apel-publisher - GliteCE: Stitching
> >> together all accounting records
> >> Fri Mar 23 16:58:52 UTC 2007: apel-publisher - program aborted
> >> org.glite.apel.core.ApelException: java.sql.SQLException: Can't
find
> >> file: './accounting/BlahdRecords.frm' (errno: 13)
> >> at
> >>
>
org.glite.apel.core.db.MySQLImpl.joinAccountingRecordsGliteCE(MySQLImpl.
ja
> va:1573)
> >>
> >> at
> >>
>
org.glite.apel.core.db.MySQLImpl.generateAccountRecordsGliteCE(MySQLImpl
.j
> ava:745)
> >>
> >> at
> >>
>
org.glite.apel.publisher.AccountManager.processRecords(AccountManager.ja
va
> :304)
> >>
> >> at
> >>
org.glite.apel.publisher.AccountManager.run(AccountManager.java:141)
> >> at
> >>
>
org.glite.apel.publisher.ApelPublisher.runJoinProcessor(ApelPublisher.ja
va
> :117)
> >>
> >> at
> >> org.glite.apel.publisher.ApelPublisher.run(ApelPublisher.java:65)
> >> at
> >> org.glite.apel.publisher.ApelPublisher.main(ApelPublisher.java:234)
> >> Caused by: java.sql.SQLException: Can't find file:
> >> './accounting/BlahdRecords.frm' (errno: 13)
> >> at
com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:2851)
> >> at com.mysql.jdbc.MysqlIO.sendCommand(MysqlIO.java:1531)
> >> at com.mysql.jdbc.MysqlIO.sqlQueryDirect(MysqlIO.java:1622)
> >> at com.mysql.jdbc.Connection.execSQL(Connection.java:2379)
> >> at com.mysql.jdbc.Connection.execSQL(Connection.java:2306)
> >> at
com.mysql.jdbc.Statement.executeQuery(Statement.java:1192)
> >> at
> >>
>
org.glite.apel.core.db.MySQLImpl.joinAccountingRecordsGliteCE(MySQLImpl.
ja
> va:1570)
> >>
> >> ... 6 more
> >>
> >
|