Daniel, can you submit a GGUS ticket please although I believe the
solution has been sent to this list previously.

I think the BC_PROVIDER variable needs to point to Bouncy Castle which
is somewhere else in 3.1. Which Batch system are you running? 

John

> -----Original Message-----
> From: LHC Computer Grid - Rollout 
> [mailto:[log in to unmask]] On Behalf Of Daniel Lorenz
> Sent: 19 December 2007 08:56
> To: [log in to unmask]
> Subject: [LCG-ROLLOUT] APEL problem
> 
> Hello,
> 
> since the upgrade of the CE (gcn54.hep.physik.uni-siegen.de) 
> to SLC4 / glite
> 3.1 no accounting data is published by our site. Before the 
> MON - Box was hosted by the the same host like the CE, during 
> the upgrade the MON was migrated to another host (gcn51) und 
> runs still with SLC3.
> 
> On the MON I found the appended entry in the logs. I have no 
> experience with APEL. Does somebody know how to solve this problem?
> 
> Regards,
> Daniel Lorenz
> 
> Wed Dec 19 00:35:01 UTC 2007: apel-pbs-log-parser - Read-in 
> configuration: 
> [quiet, c, e, recursiveEventFiles, g, recursiveGKFiles, b, 
> recursiveBlahdFiles] [DBPassword=****, site=UNI-SIEGEN-HEP, 
> pbslog=/var/spool/pbs/server_priv/accounting,
> GIIS=gcn54.hep.physik.uni-siegen.de, 
> CEhost=[gcn54.hep.physik.uni-siegen.de,
> gcn54.hep.physik.uni-siegen.de], blahdlogPrefix=blahp.log, 
> gklog=/var/log, 
> DBURL=jdbc:mysql://gcn54.hep.physik.uni-siegen.de:3306/accounting,
> DBUsername=accounting, mslog=/var/log, timeZone=UTC, 
> blahdlog=/var/log/glite/accounting]
> Wed Dec 19 00:35:01 UTC 2007: apel-pbs-log-parser - ------ 
> Starting the apel application ------ Wed Dec 19 00:35:01 UTC 
> 2007: apel-pbs-log-parser - program aborted
> org.glite.apel.core.ApelException: Unable to setup a database 
> connection: 
> Communications link failure due to underlying exception: 
> 
> ** BEGIN NESTED EXCEPTION ** 
> 
> java.net.SocketException
> MESSAGE: java.net.ConnectException: Connection refused
> 
> STACKTRACE:
> 
> java.net.SocketException: java.net.ConnectException: 
> Connection refused
> 	at
> com.mysql.jdbc.StandardSocketFactory.connect(StandardSocketFac
> tory.java:151)
> 	at com.mysql.jdbc.MysqlIO.<init>(MysqlIO.java:280)
> 	at com.mysql.jdbc.Connection.createNewIO(Connection.java:1774)
> 	at com.mysql.jdbc.Connection.<init>(Connection.java:437)
> 	at 
> com.mysql.jdbc.NonRegisteringDriver.connect(NonRegisteringDriv
> er.java:268)
> 	at java.sql.DriverManager.getConnection(DriverManager.java:512)
> 	at java.sql.DriverManager.getConnection(DriverManager.java:171)
> 	at org.glite.apel.core.db.MySQLImpl.<init>(MySQLImpl.java:83)
> 	at 
> org.glite.apel.core.processor.SpecProcessor.<init>(SpecProcess
> or.java:93)
> 	at 
> org.glite.apel.pbs.ApelLogParser.runSpecProcessor(ApelLogParse
> r.java:102)
> 	at org.glite.apel.pbs.ApelLogParser.run(ApelLogParser.java:77)
> 	at org.glite.apel.pbs.ApelLogParser.main(ApelLogParser.java:283)
> 
> 
> ** END NESTED EXCEPTION **
> 
> 
> 	at org.glite.apel.core.db.MySQLImpl.<init>(MySQLImpl.java:86)
> 	at 
> org.glite.apel.core.processor.SpecProcessor.<init>(SpecProcess
> or.java:93)
> 	at 
> org.glite.apel.pbs.ApelLogParser.runSpecProcessor(ApelLogParse
> r.java:102)
> 	at org.glite.apel.pbs.ApelLogParser.run(ApelLogParser.java:77)
> 	at org.glite.apel.pbs.ApelLogParser.main(ApelLogParser.java:283)
> BC_PROVIDER is not set, using default location
> ... /opt/glite/share/glite-security-trustmanager/bcprov-jdk14-122.jar
> Wed Dec 19 01:10:01 UTC 2007: apel-publisher - Read-in configuration: 
> [logenabled, p, inspectTables, j] [DBUsername=accounting, 
> DBURL=jdbc:mysql://gcn51.hep.physik.uni-siegen.de:3306/accounting, 
> DBPassword=****, site=UNI-SIEGEN-HEP, republish=missing]
> Wed Dec 19 01:10:01 UTC 2007: apel-publisher - ------ 
> Starting the apel 
> application ------
> Wed Dec 19 01:10:01 UTC 2007: apel-publisher - **** APEL is 
> examining the 
> schema ****
> Wed Dec 19 01:10:01 UTC 2007: apel-publisher - Checking the 
> LcgRecords table
> Wed Dec 19 01:10:01 UTC 2007: apel-publisher - The LcgRecords 
> schema is 
> up-to-date 
> Wed Dec 19 01:10:01 UTC 2007: apel-publisher - Checking the 
> BlahdRecords table
> Wed Dec 19 01:10:01 UTC 2007: apel-publisher - The 
> BlahdRecords schema is 
> up-to-date 
> Wed Dec 19 01:10:01 UTC 2007: apel-publisher - Checking the 
> LcgProcessedFiles 
> table
> Wed Dec 19 01:10:01 UTC 2007: apel-publisher - The 
> LcgProcessedFiles schema is 
> up-to-date 
> Wed Dec 19 01:10:01 UTC 2007: apel-publisher - Checking the 
> SpecRecords table
> Wed Dec 19 01:10:01 UTC 2007: apel-publisher - The 
> SpecRecords schema is 
> up-to-date 
> Wed Dec 19 01:10:01 UTC 2007: apel-publisher - Checking the 
> GkRecords table
> Wed Dec 19 01:10:01 UTC 2007: apel-publisher - The GkRecords 
> schema is 
> up-to-date 
> Wed Dec 19 01:10:01 UTC 2007: apel-publisher - Checking the 
> MessageRecords 
> table
> Wed Dec 19 01:10:01 UTC 2007: apel-publisher - The 
> MessageRecords schema is 
> up-to-date 
> Wed Dec 19 01:10:01 UTC 2007: apel-publisher - **** Schema 
> checks complete 
> ****
> Wed Dec 19 01:10:01 UTC 2007: apel-publisher - Optimising 
> table: EventRecords
> Wed Dec 19 01:10:02 UTC 2007: apel-publisher - Optimising 
> table: GkRecords
> Wed Dec 19 01:10:02 UTC 2007: apel-publisher - Optimising table: 
> MessageRecords
> Wed Dec 19 01:10:02 UTC 2007: apel-publisher - Optimising 
> table: SpecRecords
> Wed Dec 19 01:10:02 UTC 2007: apel-publisher - Optimising 
> table: LcgRecords
> Wed Dec 19 01:10:02 UTC 2007: apel-publisher - Optimising 
> table: BlahdRecords
> Wed Dec 19 01:10:02 UTC 2007: apel-publisher - **** Combining 
> tables and 
> republishing in LcgRecords ****
> Wed Dec 19 01:10:02 UTC 2007: apel-publisher - Checking valid 
> CPU spec data 
> exists
> Wed Dec 19 01:10:02 UTC 2007: apel-publisher - CPU spec values found
> Wed Dec 19 01:10:02 UTC 2007: apel-publisher - Creating a new 
> Primary Producer
> Wed Dec 19 01:10:06 UTC 2007: apel-publisher -  
> ====================================
> Wed Dec 19 01:10:06 UTC 2007: apel-publisher -     
> Synchronisation data check       
> Wed Dec 19 01:10:06 UTC 2007: apel-publisher -  
> ====================================
> Wed Dec 19 01:10:06 UTC 2007: apel-publisher - Finding all 
> records in local 
> database since the last successful publish timestamp : 
> 2007-12-18 12:45:19
> Wed Dec 19 01:10:06 UTC 2007: apel-publisher - Record/s found: 1756
> Wed Dec 19 01:10:06 UTC 2007: apel-publisher - Checking 
> Archiver is Online
> Wed Dec 19 01:10:06 UTC 2007: apel-publisher - Creating a 
> Resilient Consumer
> Wed Dec 19 01:10:06 UTC 2007: apel-publisher - Starting 
> Resilient Consumer
> Wed Dec 19 01:10:19 UTC 2007: apel-publisher - Closing 
> Resilient Consumer
> Wed Dec 19 01:10:19 UTC 2007: apel-publisher - Archiver Alive
> Wed Dec 19 01:10:19 UTC 2007: apel-publisher - Archiver 
> Record Count: Record/s 
> found site UNI-SIEGEN-HEP : 1756
> Wed Dec 19 01:10:19 UTC 2007: apel-publisher - GOC Archiver 
> and local db 
> match-up, updating the RepublishInfo table
> Wed Dec 19 01:10:19 UTC 2007: apel-publisher - Rows deleted from 
> RepublishInfo: 1
> Wed Dec 19 01:10:19 UTC 2007: apel-publisher -  
> ====================================
> Wed Dec 19 01:10:19 UTC 2007: apel-publisher -  Completed 
> Synchronisation data 
> check
> Wed Dec 19 01:10:19 UTC 2007: apel-publisher -  
> ====================================
> Wed Dec 19 01:10:19 UTC 2007: apel-publisher -  Publisher Mode = Apel 
> Publisher (Default)
> Wed Dec 19 01:10:19 UTC 2007: apel-publisher - Building 
> account records via 
> the new Accounting Log File
> Wed Dec 19 01:10:19 UTC 2007: apel-publisher - NB: Record 
> Counts may be zero 
> if Patch #898 is not active on this CE
> Wed Dec 19 01:10:19 UTC 2007: apel-publisher - Stitching together all 
> accounting records
> Wed Dec 19 01:10:19 UTC 2007: apel-publisher - Stitching completed
> Wed Dec 19 01:10:19 UTC 2007: apel-publisher - Storing 
> accounting data into 
> local database
> Wed Dec 19 01:10:19 UTC 2007: apel-publisher - Number of 
> Joined accounting 
> records: 33
> Wed Dec 19 01:10:19 UTC 2007: apel-publisher - Build complete
> Wed Dec 19 01:10:19 UTC 2007: apel-publisher - Building 
> account records via GK 
> Logs
> Wed Dec 19 01:10:19 UTC 2007: apel-publisher - NB: Record 
> Counts may be zero 
> if Patch #898 is active on this CE
> Wed Dec 19 01:10:19 UTC 2007: apel-publisher - Stitching together all 
> accounting records
> Wed Dec 19 01:10:20 UTC 2007: apel-publisher - Stitching completed
> Wed Dec 19 01:10:20 UTC 2007: apel-publisher - No accounting 
> data to store
> Wed Dec 19 01:10:20 UTC 2007: apel-publisher - Number of 
> Joined accounting 
> records: 0
> Wed Dec 19 01:10:20 UTC 2007: apel-publisher - Build complete
> Wed Dec 19 01:10:20 UTC 2007: apel-publisher - Publishing 
> data into rgma
> Wed Dec 19 01:10:20 UTC 2007: apel-publisher - Publishing 
> Records to GOC (via 
> Accounting Log): 33
> Wed Dec 19 01:10:20 UTC 2007: apel-publisher - Publishing 
> data into rgma
> Wed Dec 19 01:10:20 UTC 2007: apel-publisher - Publishing 
> Records to GOC (via 
> GK Log):  0
> Wed Dec 19 01:10:20 UTC 2007: apel-publisher - **** Join 
> processing complete 
> ****
> Wed Dec 19 01:10:20 UTC 2007: apel-publisher -  
> ====================================
> Wed Dec 19 01:10:20 UTC 2007: apel-publisher -       
> Publishing Summary Data        
> Wed Dec 19 01:10:20 UTC 2007: apel-publisher -  
> ====================================
> Wed Dec 19 01:10:20 UTC 2007: apel-publisher - Data will be 
> written to RGMA 
> Table : LcgRecordsSync_v2
> Wed Dec 19 01:10:20 UTC 2007: apel-publisher - Creating a new 
> Primary Producer
> Wed Dec 19 01:10:22 UTC 2007: apel-publisher - Publishing 
> summary data into 
> rgma
> Wed Dec 19 01:10:22 UTC 2007: apel-publisher - ------ 
> Processing finished 
> ------
>