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/
|