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.java:1573)
>>
>> at
>> org.glite.apel.core.db.MySQLImpl.generateAccountRecordsGliteCE(MySQLImpl.java:745)
>>
>> at
>> org.glite.apel.publisher.AccountManager.processRecords(AccountManager.java:304)
>>
>> at
>> org.glite.apel.publisher.AccountManager.run(AccountManager.java:141)
>> at
>> org.glite.apel.publisher.ApelPublisher.runJoinProcessor(ApelPublisher.java: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.java:1570)
>>
>> ... 6 more
>>
>
|