Hi,
In my opinion is a typical infrastructure bug, and someone should raise
a savannah bug as well,
and changes from mysql:mysql -> root:root has not been notified.
Cheers
Paul
On Mon, 2 Apr 2007, Coles, J (Jeremy) wrote:
> 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
> > >>
> > >
>
--
Dr. Paul A. Trepka ;Intl:+44(0)151 794 2137
Oliver Lodge Laboratory ;Fax: +44(0)151 794 3444
Dept. of Physics ;e-mail: [log in to unmask]
The University of Liverpool
Liverpool L69 7ZE
England, UK
|