Hello
I have a problem with publishing after certificate renewal (email address was removed from CN). Now this problem is fixed by changing certificate CN in goc. I managed to publish a week after but after this I have a problem:
[root@lcg glite-apel-publisher]# 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=====
Mon Sep 23 12:30:15 BST 2013
Current versions of APEL RPMS:
glite-apel-core-2.0.14-5.sl5.noarch
glite-apel-yaim-1.0.2-4.sl5.noarch
emi-apel-1.0.0-0.sl5.noarch
glite-apel-publisher-2.0.16-1.sl5.noarch
Copying certificates from /etc/grid-security to the Java key store used by the APEL Publisher
Mon Sep 23 11:31:59 UTC 2013: 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=gap]
Mon Sep 23 11:31:59 UTC 2013: apel-publisher - ------ Starting the APEL Publisher ------
Mon Sep 23 11:31:59 UTC 2013: apel-publisher - **** APEL is examining the schema ****
Mon Sep 23 11:31:59 UTC 2013: apel-publisher - Checking the LcgRecords table
Mon Sep 23 11:31:59 UTC 2013: apel-publisher - The LcgRecords schema is up-to-date
Mon Sep 23 11:31:59 UTC 2013: apel-publisher - Checking the BlahdRecords table
Mon Sep 23 11:31:59 UTC 2013: apel-publisher - The BlahdRecords schema is up-to-date
Mon Sep 23 11:31:59 UTC 2013: apel-publisher - Checking the LcgProcessedFiles table
Mon Sep 23 11:31:59 UTC 2013: apel-publisher - The LcgProcessedFiles schema is up-to-date
Mon Sep 23 11:31:59 UTC 2013: apel-publisher - Checking the SpecRecords table for patch 28593
Mon Sep 23 11:31:59 UTC 2013: apel-publisher - Checking the SpecRecords table for patch 65723
Mon Sep 23 11:31:59 UTC 2013: apel-publisher - The SpecRecords schema is up-to-date
Mon Sep 23 11:31:59 UTC 2013: apel-publisher - Checking the GkRecords table
Mon Sep 23 11:31:59 UTC 2013: apel-publisher - The GkRecords schema is up-to-date
Mon Sep 23 11:31:59 UTC 2013: apel-publisher - Checking the MessageRecords table
Mon Sep 23 11:31:59 UTC 2013: apel-publisher - The MessageRecords schema is up-to-date
Mon Sep 23 11:31:59 UTC 2013: apel-publisher - **** Schema checks complete ****
Mon Sep 23 11:31:59 UTC 2013: apel-publisher - **** Running the APEL publisher in Republish Gap Mode ****
Mon Sep 23 11:31:59 UTC 2013: apel-publisher - Checking valid CPU spec data exists
Mon Sep 23 11:31:59 UTC 2013: apel-publisher - CPU spec values found
Mon Sep 23 11:33:12 UTC 2013: apel-publisher - Publishing 0 records...
Mon Sep 23 11:33:12 UTC 2013: apel-publisher - Publishing data into ActiveMQ Broker
Mon Sep 23 11:33:12 UTC 2013: apel-publisher - All UserDNs will be encrypted
Mon Sep 23 11:33:13 UTC 2013: apel-publisher - SecureRandom provider is SUN version 1.6
Mon Sep 23 11:33:13 UTC 2013: apel-publisher - Salting SecureRandom (SHA1PRNG) from /dev/urandom
KEY LOCATION =
Mon Sep 23 11:33:13 UTC 2013: apel-publisher - Updating MeasurementDate and MeasurementTime timestamp of Gap Data
Mon Sep 23 11:33:13 UTC 2013: apel-publisher - Total records published to Server with GAP Publisher:0
Mon Sep 23 11:33:13 UTC 2013: apel-publisher - ------ APEL Publisher finished ------
mysql> select Max(EventDate) from LcgRecords;
+----------------+
| Max(EventDate) |
+----------------+
| 2013-08-27 |
+----------------+
1 row in set (11.19 sec)
mysql> select Max(EventDate) from EventRecords;
+----------------+
| Max(EventDate) |
+----------------+
| 2013-08-27 |
+----------------+
1 row in set (1 min 38.47 sec)
mysql> select Max(ValidFrom) from BlahdRecords;
+----------------+
| Max(ValidFrom) |
+----------------+
| 2013-09-22 |
+----------------+
1 row in set (1 min 43.20 sec)
cat /etc/glite-apel-publisher/publisher-config-yaim.xml
<?xml version="1.0" encoding="UTF-8"?>
<ApelConfiguration enableDebugLogging="yes">
<SiteName>UKI-NORTHGRID-SHEF-HEP</SiteName>
<DBURL>jdbc:mysql://localhost:3306/accounting</DBURL>
<DBUsername>accounting</DBUsername>
<DBPassword>***</DBPassword>
<!-- Number of records selected each time
Modify this value if OutOfMemory error
appears in the Publisher
approx 150000 records per 512Mb memory -->
<Limit>100000</Limit>
<MaxInsertBatch>1000</MaxInsertBatch>
<!-- Timeout for waiting for consumer in milliseconds -->
<ConsumerTimeout>1800000</ConsumerTimeout>
<!-- Examine APEL Schema //-->
<DBProcessor inspectTables="yes"/>
<!--
Publisher Options
=================
publishGlobalUserName="yes" : encrypt UserDNs with a 1024-bit RSA key
: If "no", UserDNs are not published (default)
publicKeyLocation="/home/key/public.der" : if set, this external public key
will be used for encryption. Otherwise APEL
key will be used
<Republish>missing</Republish> : publish missing data only (default)
<Republish>missing</Republish> : publish ALL accounting data in the database
Gap Publisher : publish data in a specified interval
<Republish recordStart="2006-02-01" recordEnd="2006-04-25">gap</Republish>
-->
<JoinProcessor publishGlobalUserName="yes">
<Republish recordStart="2013-08-27" recordEnd="2013-09-07">gap</Republish>
<!--
VO Filtering:
include="include" : Only the VOs specified in VOList will be published
include="exclude" : All VOs except the ones specified in VOList will be published
include="all" : All VOs will be published. VOList will be ignored.
Enter one VO per <VO> tag
VO Mapping:
Map local unix groups to VOs if not using Blah Accounting Log files
<VOGroup>localgroup:VOName</VOGroup>
-->
<VOInclude include="all">
<!--VOList>
<VO>atlas</VO>
<VO>cms</VO>
</VOList-->
<!--VOMapping>
<VOGroup>atlprd:atlas</VOGroup>
<VOGroup>cmsprod:cms</VOGroup>
</VOMapping-->
</VOInclude>
</JoinProcessor>
</ApelConfiguration>
Your help is much appreciated.
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
|