Hi,
Yes I think it is the case. I can see the creamdb username and password
I specified in my site-info.def in the
/usr/share/tomcat5/conf/Catalina/localhost/ce-cream.xml and the error
messages are referring to connection problems:
23 Aug 2010 17:56:32,517 INFO org.glite.ce.cream.ws.CREAM2Service
(CREAM2Service.java:295) - (main) Found HTTP Tomcat port = 8443
23 Aug 2010 17:56:32,521 INFO org.glite.ce.cream.ws.CREAM2Service
(CREAM2Service.java:348) - (main) CREAM URL:
https://helena.esc.rl.ac.uk:8443/ce-cream/services/CREAM2
23 Aug 2010 17:56:32,952 ERROR org.glite.ce.common.db.DatasourceManager
(DatasourceManager.java:106) - (main) Cannot create
PoolableConnectionFactory (Error during query: Unexpected Exception:
java.io.CharConversionException message given: null
Nested Stack Trace:
** BEGIN NESTED EXCEPTION **
java.io.CharConversionException
STACKTRACE:
java.io.CharConversionException
at gnu.gcj.convert.Input_iconv.read(libgcj.so.7rh)
at java.lang.String.init(libgcj.so.7rh)
at java.lang.String.<init>(libgcj.so.7rh)
at
com.mysql.jdbc.SingleByteCharsetConverter.<init>(SingleByteCharsetConver
ter.java:153)
at
com.mysql.jdbc.SingleByteCharsetConverter.initCharset(SingleByteCharsetC
onverter.java:108)
at
com.mysql.jdbc.SingleByteCharsetConverter.getInstance(SingleByteCharsetC
onverter.java:86)
at
com.mysql.jdbc.Connection.getCharsetConverter(Connection.java:3505)
at com.mysql.jdbc.StringUtils.getBytes(StringUtils.java:615)
at com.mysql.jdbc.Buffer.writeStringNoNull(Buffer.java:655)
at com.mysql.jdbc.MysqlIO.sqlQueryDirect(MysqlIO.java:1686)
at com.mysql.jdbc.Connection.execSQL(Connection.java:3277)
at
com.mysql.jdbc.Connection.configureClientCharacterSet(Connection.java:25
25)
at
com.mysql.jdbc.Connection.initializePropsFromServer(Connection.java:4139
)
at com.mysql.jdbc.Connection.createNewIO(Connection.java:2789)
at com.mysql.jdbc.Connection.<init>(Connection.java:1555)
at
com.mysql.jdbc.NonRegisteringDriver.connect(NonRegisteringDriver.java:28
5)
at
org.apache.commons.dbcp.DriverConnectionFactory.createConnection(jakarta
-commons-dbcp-1.2.1.jar.so)
at
org.apache.commons.dbcp.PoolableConnectionFactory.makeObject(jakarta-com
mons-dbcp-1.2.1.jar.so)
at
org.apache.commons.dbcp.BasicDataSource.validateConnectionFactory(jakart
a-commons-dbcp-1.2.1.jar.so)
at
org.apache.commons.dbcp.BasicDataSource.createDataSource(jakarta-commons
-dbcp-1.2.1.jar.so)
at
org.apache.commons.dbcp.BasicDataSource.getConnection(jakarta-commons-db
cp-1.2.1.jar.so)
In my /usr/share/tomcat5/conf/tomcat5.conf file the JAVA_HOME variable
is set as:
JAVA_HOME=/usr/lib/jvm/jre-1.6.0-openjdk.x86_64. Is the openjdk version
OK or should it be set to jre-1.60 (the sun jre).
Regards
Gokop
-----Original Message-----
From: LHC Computer Grid - Rollout [mailto:[log in to unmask]] On
Behalf Of Massimo Sgaravatto - INFN Padova
Sent: 23 August 2010 22:06
To: [log in to unmask]
Subject: Re: [LCG-ROLLOUT] glite-ce-job-submit error
It looks like you are having problem accessing the mysql dbs (creamdb
and
delegationdb)
These dbs should be accessible using the user and password specified in
the file /usr/share/tomcat5/conf/Catalina/localhost/ce-cream.xml
Can you verify that this is the case ?
Cheers, Massimo
On Mon, 23 Aug 2010, Gokop Goteng wrote:
> Hi Massimo,
>
> I am using the instructions at
>
http://igrelease.forge.cnaf.infn.it/doku.php?id=doc:guides:devel:install
> -cream32 (for CREAM CE installation 3.5 sl5) from the cream website to
> do the installation. I am not using the epel repository as it is not
in
> my /etc/yum.repos.d/. I ran a yum update for glite-yaim-cream-ce and
the
> problem of /opt/glite/var/glite-lb-logd.pid: Permission denied was
> solved.
>
>
> I think I am running the latest version of cream:
>
> Checking versions of relevant RPMs ...
> glite-ce-cream-1.12.3-1
> glite-ce-ce-plugin-1.12.1-20
> glite-ce-cream-utils-1.0.1-1.sl5
> glite-ce-monitor-1.12.2-5
> glite-ce-blahp-1.14.2-7.sl5
> glite-ce-job-plugin-1.12.1-20
> glite-yaim-cream-ce-4.1.0-14
> glite-CREAM-3.2.7-2.sl5
>
>
> But tomcat does not seem to be listening on port 8443 again:
>
> [root@helena site-info.def-dir]# netstat -anpt|awk '/LISTEN.*java/
> {print $4}'
> 127.0.0.1:8005
> 0.0.0.0:5001
>
> Viewing /opt/glite/var/log/glite-ce-cream.log I could see the error:
>
>
> 23 Aug 2010 15:34:17,905 ERROR org.glite.ce.cream.ws.CREAM2Service
> (CREAM2Service.java:319) - (main) Error: cannot retrieve the creamdb
> database version from the database (Requested version is 2.4) because
> either the database isn't reachable or the database version isn't
> correct.
> 23 Aug 2010 15:34:17,911 ERROR org.glite.ce.cream.ws.StartUpManager
> (StartUpManager.java:75) - (main) CREAM initialization error: Error:
> cannot retrieve the creamdb database version from the database
> (Requested version is 2.4) because either the database isn't reachable
> or the database version isn't correct.
> java.lang.InstantiationException: Error: cannot retrieve the creamdb
> database version from the database (Requested version is 2.4) because
> either the database isn't reachable or the database version isn't
> correct.
> at
>
org.glite.ce.cream.ws.CREAM2Service.checkDBVersion(CREAM2Service.java:32
> 0)
> at org.glite.ce.cream.ws.CREAM2Service.init(CREAM2Service.java:387)
> at
>
org.glite.ce.cream.ws.StartUpManager.contextInitialized(StartUpManager.j
> ava:69)
> at
>
org.apache.catalina.core.StandardContext.listenerStart(catalina-5.5.23.j
> ar.so)
> at
> org.apache.catalina.core.StandardContext.start(catalina-5.5.23.jar.so)
> at
>
org.apache.catalina.core.ContainerBase.addChildInternal(catalina-5.5.23.
> jar.so)
> at
>
org.apache.catalina.core.ContainerBase.addChild(catalina-5.5.23.jar.so)
> at
> org.apache.catalina.core.StandardHost.addChild(catalina-5.5.23.jar.so)
> at
>
org.apache.catalina.startup.HostConfig.deployWAR(catalina-5.5.23.jar.so)
> at
>
org.apache.catalina.startup.HostConfig.deployWARs(catalina-5.5.23.jar.so
> )
> at
>
org.apache.catalina.startup.HostConfig.deployApps(catalina-5.5.23.jar.so
> )
> at
> org.apache.catalina.startup.HostConfig.start(catalina-5.5.23.jar.so)
> at
>
org.apache.catalina.startup.HostConfig.lifecycleEvent(catalina-5.5.23.ja
> r.so)
> at
>
org.apache.catalina.util.LifecycleSupport.fireLifecycleEvent(catalina-5.
> 5.23.jar.so)
> at
> org.apache.catalina.core.ContainerBase.start(catalina-5.5.23.jar.so)
> at
> org.apache.catalina.core.StandardHost.start(catalina-5.5.23.jar.so)
> at
> org.apache.catalina.core.ContainerBase.start(catalina-5.5.23.jar.so)
> at
> org.apache.catalina.core.StandardEngine.start(catalina-5.5.23.jar.so)
> at
> org.apache.catalina.core.StandardService.start(catalina-5.5.23.jar.so)
> at
> org.apache.catalina.core.StandardServer.start(catalina-5.5.23.jar.so)
> at
org.apache.catalina.startup.Catalina.start(catalina-5.5.23.jar.so)
> at java.lang.reflect.Method.invoke(libgcj.so.7rh)
> at org.apache.catalina.startup.Bootstrap.start(bootstrap.jar.so)
> at org.apache.catalina.startup.Bootstrap.main(bootstrap.jar.so)
>
>
> Regards
> Gokop
> -----Original Message-----
> From: LHC Computer Grid - Rollout [mailto:[log in to unmask]]
On
> Behalf Of Massimo Sgaravatto - INFN Padova
> Sent: 21 August 2010 07:38
> To: [log in to unmask]
> Subject: Re: [LCG-ROLLOUT] glite-ce-job-submit error
>
> On Fri, 20 Aug 2010, Gokop Goteng wrote:
>
>> Hi,
>>
>> I have the permission denied error when configuring cream:
>>
>> [32024] Send messages also to inter-logger... [yes]
>> [32024] Messages will be stored with the filename prefix
>> "/var/glite/log/dglogd.log".
>> [32024] Server running with certificate:
>>
>
/C=UK/O=eScience/OU=CLRC/L=RAL/CN=helena.esc.rl.ac.uk/emailAddress=gokop
>> [log in to unmask]
>> [32024] Listening on port 9002
>> /opt/glite/var/glite-lb-logd.pid: Permission denied
>>
>
>
> It looks like you are using a new LB locallogger with an old
> yaim-cream-ce
> which doesn't have the fix for this issue:
>
> https://savannah.cern.ch/bugs/?70058
>
>
> But using the official repos you shouldn't have seen this issue, since
> this combination (new lb logger with old yaim-cream-ce was never
> released
> in production)
>
>>
>> And also in the
>> "/usr/share/tomcat5/logs/glite-security-trustmanager.log" file I can
>> see:
>>
>> tomcat [main]: 2010-08-20T12:10:09.149+0100 FATAL
>> trustmanager.ContextWrapper - Internal error: while reading
> credentials
>> SunX509
>>
>> Could it be that the host certificate is not in the correct format as
>> CREAM wants it? I know that bug #58515 for voms certificate is
because
>> of the "Email=" in the voms certificate and I guess is been corrected
>> now.
>
>
> Are you using the latest version of the CREAM CE ?
> Did you disable/delete the epel repo ?
> Was the util-java rpm taken by the glite repo ? The one available in
the
>
> epel repo must not be used in the CREAM CE
>
> Cheers, Massimo
>
>>
>>
>> Regards
>> Gokop
>>
>>
>>
>> -----Original Message-----
>> From: LHC Computer Grid - Rollout [mailto:[log in to unmask]]
> On
>> Behalf Of Maarten Litmaath
>> Sent: 18 August 2010 18:31
>> To: [log in to unmask]
>> Subject: Re: [LCG-ROLLOUT] glite-ce-job-submit error
>>
>> Hi Gokop,
>>
>>> I tried to change the "port" attribute at "<Server port="8005"
>>> shutdown="SHUTDOWN">" in the tomcat config file "
>>> /usr/share/tomcat5/conf/server.xml " to port="8443" and open port
> 8443
>>
>> Please do not edit such configuration files manually: there is no
need
>> and it will give you problems. See below.
>>
>>> in my iptables and then restarted tomcat. Now tomcat is listening to
>>> port 8443, however I cannot telnet on the port as shown below:
>>>
>>> [root@helena ~]# vim /usr/share/tomcat5/conf/server.xml
>>> [root@helena ~]# netstat -anp|awk '/LISTEN.*java/ {print $4}'
>>> 0.0.0.0:5001
>>> 127.0.0.1:8443
>>> [root@helena ~]# telnet helena.esc.rl.ac.uk 8443
>>> Trying 130.246.140.231...
>>> telnet: connect to address 130.246.140.231: Connection refused
>>
>> Exactly: that port is only listened to on localhost (127.0.0.1),
>> because it is for shutting tomcat down!
>>
>> The quickest way out of this mess may well be to reinstall the
machine
>> with the correct rpms as a CREAM CE _only_ and rerun YAIM as
> documented.
>>
>
> \\\|///
> \\ ~ ~ //
> (/ @ @ /)
> -------oOOo-(_)-oOOo----------------------------------
> Massimo Sgaravatto
> INFN Sezione di Padova
> Via Marzolo, 8
> 35131 Padova - Italy
> Tel: ++39 0498275908 Fax: ++39 0498275952
> oooO E-mail: massimo.sgaravatto [at] pd.infn.it
> ( ) Oooo Home page: http://www.pd.infn.it/~sgaravat
> --------\ (----( )----------------------------------
> \_) ) /
> (_/
>
\\\|///
\\ ~ ~ //
(/ @ @ /)
-------oOOo-(_)-oOOo----------------------------------
Massimo Sgaravatto
INFN Sezione di Padova
Via Marzolo, 8
35131 Padova - Italy
Tel: ++39 0498275908 Fax: ++39 0498275952
oooO E-mail: massimo.sgaravatto [at] pd.infn.it
( ) Oooo Home page: http://www.pd.infn.it/~sgaravat
--------\ (----( )----------------------------------
\_) ) /
(_/
|