Thank you Steve.
I'm looking into this.
Elena
On 11 Dec 2012, at 11:54, Stephen Jones wrote:
> Dunno what the problem is - it could just take some time to propagate?
>
> But there is such a thing in the world as the "Gap Publisher".
>
> To use it, you have to uncomment some of the XML in /etc/glite-apel-pbs/parser-config-yaim.xml
>
> Steve
>
>
> On 12/11/2012 11:47 AM, Elena Korolkova wrote:
>> Hello
>>
>> we have a problem with db access for accounting user. It was fixed yesterday.
>>
>> Publishing is running ok on ce and apel:
>>
>> env APEL_HOME=/ /usr/bin/apel-pbs-log-parser -f /etc/glite-apel-pbs/parser-config-yaim.xml
>> .......
>> Tue Dec 11 10:23:52 UTC 2012: apel-pbs-log-parser - Ignoring already processed accounting log file: lcgce2.shef.ac.uk /var/log/cream/accounting/blahp.log-20121202
>> Tue Dec 11 10:23:52 UTC 2012: apel-pbs-log-parser - Ignoring already processed accounting log file: lcgce2.shef.ac.uk /var/log/cream/accounting/blahp.log-20121208
>> Tue Dec 11 10:23:52 UTC 2012: apel-pbs-log-parser - Ignoring already processed accounting log file: lcgce2.shef.ac.uk /var/log/cream/accounting/blahp.log-20121124
>> Tue Dec 11 10:23:52 UTC 2012: apel-pbs-log-parser - Ignoring already processed accounting log file: lcgce2.shef.ac.uk /var/log/cream/accounting/blahp.log-20121107
>> Tue Dec 11 10:23:52 UTC 2012: apel-pbs-log-parser - Blahd records inserted: 2679
>> Tue Dec 11 10:23:52 UTC 2012: apel-pbs-log-parser - ------ Processing finished -----
>>
>> [root@lcg ~]# env APEL_HOME=/ JAVA_HOME=/etc/alternatives/java_sdk_1.6.0 /usr/bin/apel-publisher -f /etc/glite-apel-publisher/publisher-config-yaim.xml
>> =====Starting APEL Publisher=====
>> Tue Dec 11 10:48:05 GMT 2012
>> Current versions of APEL RPMS:
>> glite-apel-core-2.0.14-4.sl5.noarch
>> glite-apel-yaim-1.0.2-3.sl5.noarch
>> glite-apel-publisher-2.0.16-0.sl5.noarch
>> emi-apel-1.0.0-0.sl5.noarch
>> Copying certificates from /etc/grid-security to the Java key store used by the APEL Publisher
>> Tue Dec 11 10:49:43 UTC 2012: apel-publisher - Read-in configuration: [logenabled, p, inspectTables, j, publishGlobalDN] [DBUsername=accounting, DBURL=jdbc:mysql://localhost:3306/accounting, DBPassword=****, site=UKI-NORTHGRID-SHEF-HEP, Timeout for awaiting a reply from the consumer.=1800000, The max. num of accounting records in each JMS message=1000, Batch size=100000, republish=missing]
>> Tue Dec 11 10:49:43 UTC 2012: apel-publisher - ------ Starting the APEL Publisher ------
>> Tue Dec 11 10:49:44 UTC 2012: apel-publisher - **** APEL is examining the schema ****
>> Tue Dec 11 10:49:44 UTC 2012: apel-publisher - Checking the LcgRecords table
>> Tue Dec 11 10:49:44 UTC 2012: apel-publisher - The LcgRecords schema is up-to-date
>> Tue Dec 11 10:49:44 UTC 2012: apel-publisher - Checking the BlahdRecords table
>> ........
>> Tue Dec 11 10:49:44 UTC 2012: apel-publisher - Synchronisation data check
>> Tue Dec 11 10:49:44 UTC 2012: apel-publisher - ====================================
>> Tue Dec 11 10:49:44 UTC 2012: apel-publisher - Finding all records in local database since the last successful publish timestamp : 2012-12-11 09:34:00
>> .......
>>
>> Tue Dec 11 11:31:10 UTC 2012: apel-publisher - Publishing 1420 records...
>> Tue Dec 11 11:31:10 UTC 2012: apel-publisher - Published 1420 records to the APEL server.
>> Tue Dec 11 11:31:10 UTC 2012: apel-publisher - If filtering by VO, the number of records joined might differ from the number of records published
>> Tue Dec 11 11:31:10 UTC 2012: apel-publisher - ====================================
>> Tue Dec 11 11:31:10 UTC 2012: apel-publisher - Publishing Summary Data
>> Tue Dec 11 11:31:10 UTC 2012: apel-publisher - ====================================
>> Tue Dec 11 11:31:10 UTC 2012: apel-publisher - Data will be written to Sync Table: LcgRecordsSync_v2
>> Tue Dec 11 11:36:41 UTC 2012: apel-publisher - Publishing summary data into ActiveMQ Broker
>> Tue Dec 11 11:36:41 UTC 2012: apel-publisher - ------ APEL Publisher finished ------
>>
>>
>> But https://gridppnagios.physics.ox.ac.uk/nagios/cgi-bin/extinfo.cgi?type=2&host=lcgce2.shef.ac.uk&service=org.apel.APEL-Pub shows that last published 28 days ago: 2012-11-12
>>
>> I would appreciate your help very much.
>>
>> Elena
>> __________________________________________________
>> Dr Elena Korolkova
>> Email: [log in to unmask]
>> Tel.: +44 (0)114 2223553
>> Fax: +44 (0)114 2223555
>> Department of Physics and Astronomy
>> University of Sheffield
>> Sheffield, S3 7RH, United Kingdom
>
>
> --
> Steve Jones [log in to unmask]
> System Administrator office: 220
> High Energy Physics Division tel (int): 42334
> Oliver Lodge Laboratory tel (ext): +44 (0)151 794 2334
> University of Liverpool http://www.liv.ac.uk/physics/hep/
__________________________________________________
Dr Elena Korolkova
Email: [log in to unmask]
Tel.: +44 (0)114 2223553
Fax: +44 (0)114 2223555
Department of Physics and Astronomy
University of Sheffield
Sheffield, S3 7RH, United Kingdom
|