[Spacewalk-list] cannot register CentOS 5 system to my new spacewalk server

Andy Ingham andy.ingham at duke.edu
Thu Mar 8 18:17:01 UTC 2012 

Sabuj --

That's what I've got, so perhaps my problem is less an SSL one than an
issue with Taskomatic or jabberd (or something else!)


See below for the output in my /var/log/rhn/rhn_taskomatic_daemon.log file
upon issuing "/usr/sbin/spacewalk-service start" to start the spacewalk
service.

It is complaining about not being able to connect with the Oracle backend,
even though I've got the two files:

	/usr/lib/oracle/11.2/client64/network/admin/tnsnames.ora
		and
	/usr/lib/oracle/11.2/client64/network/admin/sqlnet.ora

that the

	sqlplus [db_user]/[db_pass]@[SERVICE_NAME]

commandline command requires for interactive db access

What am I missing?

Does sw not work with an external Oracle 11g instance?

Do I need other parameters set somewhere?


Andy

--------- trace from rhn_taskomatic_daemon.log file follows -------------

STATUS | wrapper  | 2012/03/08 12:32:06 | --> Wrapper Started as Daemon
STATUS | wrapper  | 2012/03/08 12:32:06 | Launching a JVM...
INFO   | jvm 1    | 2012/03/08 12:32:06 | Wrapper (Version 3.2.3)
http://wrapper.tanukisoftware.org
INFO   | jvm 1    | 2012/03/08 12:32:06 |   Copyright 1999-2006 Tanuki
Software, Inc.  All Rights Reserved.
INFO   | jvm 1    | 2012/03/08 12:32:06 |
INFO   | jvm 1    | 2012/03/08 12:32:08 |
org.quartz.SchedulerConfigException: Failure occured during job recovery.
[See nested exception: org.quartz.JobPersistenceException: Failed to
obtain DB connection from data source 'rhnDs':
org.apache.commons.dbcp.SQLNestedException: Cannot create
PoolableConnectionFactory (ORA-12154: TNS:could not resolve the connect
identifier specified
INFO   | jvm 1    | 2012/03/08 12:32:08 | ) [See nested exception:
org.apache.commons.dbcp.SQLNestedException: Cannot create
PoolableConnectionFactory (ORA-12154: TNS:could not resolve the connect
identifier specified
INFO   | jvm 1    | 2012/03/08 12:32:08 | )]]
INFO   | jvm 1    | 2012/03/08 12:32:08 | 	at
org.quartz.impl.jdbcjobstore.JobStoreSupport.initialize(JobStoreSupport.jav
a:607)
INFO   | jvm 1    | 2012/03/08 12:32:08 | 	at
org.quartz.impl.jdbcjobstore.JobStoreTX.initialize(JobStoreTX.java:56)
INFO   | jvm 1    | 2012/03/08 12:32:08 | 	at
org.quartz.impl.StdSchedulerFactory.instantiate(StdSchedulerFactory.java:12
69)
INFO   | jvm 1    | 2012/03/08 12:32:08 | 	at
org.quartz.impl.StdSchedulerFactory.getScheduler(StdSchedulerFactory.java:1
460)
INFO   | jvm 1    | 2012/03/08 12:32:08 | 	at
com.redhat.rhn.taskomatic.core.SchedulerKernel.<init>(SchedulerKernel.java:
119)
INFO   | jvm 1    | 2012/03/08 12:32:08 | 	at
com.redhat.rhn.taskomatic.core.TaskomaticDaemon.onStartup(TaskomaticDaemon.
java:98)
INFO   | jvm 1    | 2012/03/08 12:32:08 | 	at
com.redhat.rhn.taskomatic.core.BaseDaemon.startupWithOptions(BaseDaemon.jav
a:189)
INFO   | jvm 1    | 2012/03/08 12:32:08 | 	at
com.redhat.rhn.taskomatic.core.BaseDaemon.start(BaseDaemon.java:54)
INFO   | jvm 1    | 2012/03/08 12:32:08 | 	at
org.tanukisoftware.wrapper.WrapperManager$11.run(WrapperManager.java:2788)
INFO   | jvm 1    | 2012/03/08 12:32:08 | Caused by:
org.quartz.JobPersistenceException: Failed to obtain DB connection from
data source 'rhnDs': org.apache.commons.dbcp.SQLNestedException: Cannot
create PoolableConnectionFactory (ORA-12154: TNS:could not resolve the
connect identifier specified
INFO   | jvm 1    | 2012/03/08 12:32:08 | ) [See nested exception:
org.apache.commons.dbcp.SQLNestedException: Cannot create
PoolableConnectionFactory (ORA-12154: TNS:could not resolve the connect
identifier specified
INFO   | jvm 1    | 2012/03/08 12:32:08 | )]
INFO   | jvm 1    | 2012/03/08 12:32:08 | 	at
org.quartz.impl.jdbcjobstore.JobStoreSupport.getConnection(JobStoreSupport.
java:690)
INFO   | jvm 1    | 2012/03/08 12:32:08 | 	at
org.quartz.impl.jdbcjobstore.JobStoreTX.getNonManagedTXConnection(JobStoreT
X.java:69)
INFO   | jvm 1    | 2012/03/08 12:32:08 | 	at
org.quartz.impl.jdbcjobstore.JobStoreSupport.executeInNonManagedTXLock(JobS
toreSupport.java:3760)
INFO   | jvm 1    | 2012/03/08 12:32:08 | 	at
org.quartz.impl.jdbcjobstore.JobStoreSupport.executeInNonManagedTXLock(JobS
toreSupport.java:3725)
INFO   | jvm 1    | 2012/03/08 12:32:08 | 	at
org.quartz.impl.jdbcjobstore.JobStoreSupport.cleanVolatileTriggerAndJobs(Jo
bStoreSupport.java:747)
INFO   | jvm 1    | 2012/03/08 12:32:08 | 	at
org.quartz.impl.jdbcjobstore.JobStoreSupport.initialize(JobStoreSupport.jav
a:605)
INFO   | jvm 1    | 2012/03/08 12:32:08 | 	... 8 more
INFO   | jvm 1    | 2012/03/08 12:32:08 | Caused by:
org.apache.commons.dbcp.SQLNestedException: Cannot create
PoolableConnectionFactory (ORA-12154: TNS:could not resolve the connect
identifier specified
INFO   | jvm 1    | 2012/03/08 12:32:08 | )
INFO   | jvm 1    | 2012/03/08 12:32:08 | 	at
org.apache.commons.dbcp.BasicDataSource.createDataSource(BasicDataSource.ja
va:1225)
INFO   | jvm 1    | 2012/03/08 12:32:08 | 	at
org.apache.commons.dbcp.BasicDataSource.getConnection(BasicDataSource.java:
880)
INFO   | jvm 1    | 2012/03/08 12:32:08 | 	at
org.quartz.utils.PoolingConnectionProvider.getConnection(PoolingConnectionP
rovider.java:194)
INFO   | jvm 1    | 2012/03/08 12:32:08 | 	at
org.quartz.utils.DBConnectionManager.getConnection(DBConnectionManager.java
:109)
INFO   | jvm 1    | 2012/03/08 12:32:08 | 	at
org.quartz.impl.jdbcjobstore.JobStoreSupport.getConnection(JobStoreSupport.
java:687)
INFO   | jvm 1    | 2012/03/08 12:32:08 | 	... 13 more
INFO   | jvm 1    | 2012/03/08 12:32:08 | Caused by:
java.sql.SQLException: ORA-12154: TNS:could not resolve the connect
identifier specified
INFO   | jvm 1    | 2012/03/08 12:32:08 |
INFO   | jvm 1    | 2012/03/08 12:32:08 | 	at
oracle.jdbc.driver.T2CConnection.checkError(T2CConnection.java:759)
INFO   | jvm 1    | 2012/03/08 12:32:08 | 	at
oracle.jdbc.driver.T2CConnection.logon(T2CConnection.java:414)
INFO   | jvm 1    | 2012/03/08 12:32:08 | 	at
oracle.jdbc.driver.PhysicalConnection.<init>(PhysicalConnection.java:536)
INFO   | jvm 1    | 2012/03/08 12:32:08 | 	at
oracle.jdbc.driver.T2CConnection.<init>(T2CConnection.java:162)
INFO   | jvm 1    | 2012/03/08 12:32:08 | 	at
oracle.jdbc.driver.T2CDriverExtension.getConnection(T2CDriverExtension.java
:53)
INFO   | jvm 1    | 2012/03/08 12:32:08 | 	at
oracle.jdbc.driver.OracleDriver.connect(OracleDriver.java:521)
INFO   | jvm 1    | 2012/03/08 12:32:08 | 	at
org.apache.commons.dbcp.DriverConnectionFactory.createConnection(DriverConn
ectionFactory.java:38)
INFO   | jvm 1    | 2012/03/08 12:32:08 | 	at
org.apache.commons.dbcp.PoolableConnectionFactory.makeObject(PoolableConnec
tionFactory.java:294)
INFO   | jvm 1    | 2012/03/08 12:32:08 | 	at
org.apache.commons.dbcp.BasicDataSource.validateConnectionFactory(BasicData
Source.java:1247)
INFO   | jvm 1    | 2012/03/08 12:32:08 | 	at
org.apache.commons.dbcp.BasicDataSource.createDataSource(BasicDataSource.ja
va:1221)
INFO   | jvm 1    | 2012/03/08 12:32:08 | 	... 17 more
FATAL  | jvm 1    | 2012/03/08 12:32:08 | this.scheduler failed
java.lang.InstantiationException: this.scheduler failed
	at 
com.redhat.rhn.taskomatic.core.SchedulerKernel.<init>(SchedulerKernel.java:
137)
	at 
com.redhat.rhn.taskomatic.core.TaskomaticDaemon.onStartup(TaskomaticDaemon.
java:98)
	at 
com.redhat.rhn.taskomatic.core.BaseDaemon.startupWithOptions(BaseDaemon.jav
a:189)
	at com.redhat.rhn.taskomatic.core.BaseDaemon.start(BaseDaemon.java:54)
	at 
org.tanukisoftware.wrapper.WrapperManager$11.run(WrapperManager.java:2788)

STATUS | wrapper  | 2012/03/08 12:32:10 | <-- Wrapper Stopped




On 3/8/12 10:10 AM, "Sabuj Pattanayek" <sabujp at gmail.com> wrote:

Systems -> kickstart -> GPG & SSL Keys . There should be one called
RHN-ORG-TRUSTED-SSL-CERT or similar. The text that's in that entire
thing should be put in a file and specified as the file in the
--sslCACert=/path/to/file.crt argument

On Thu, Mar 8, 2012 at 8:04 AM, Andy Ingham <andy.ingham at duke.edu> wrote:
> Sabuj --
>
> Thanks for the info, but what I think I'm struggling with is exactly
>WHICH
> cert and key files, FROM where, concatenated in WHAT WAY and ultimately
> saved in WHICH directory (and on which host).
>
>
> As someone mentioned on the list previously, the info specific to SSL
> files for spacewalk is thin and with numerous files involved (and spread
> across both sw server and sw clients), I am far from confident that I've
> got what I'm supposed to have where I'm supposed to have it.
>
> Is there (client) setup documentation somewhere that I'm missing?
>
> Again, many thanks!
>
> Andy
>
>
> On 3/7/12 4:27 PM, "Sabuj Pattanayek" <sabujp at gmail.com> wrote:
>
>>        An error has occurred:
>>        up2date_client.up2dateErrors.SSLCertificateVerifyFailedError
>>        See /var/log/up2date for more information
>
> In my kickstart scripts the SSL cert from the server gets put into
> this file and it does this :
>
> cat > /tmp/ssl-key-1 <<'EOF'
> # HUGE SSL KEY HERE #
> .
> .
> .
> cat /tmp/ssl-key-* > /usr/share/rhn/RHN-ORG-TRUSTED-SSL-CERT
> perl -npe 's/RHNS-CA-CERT/RHN-ORG-TRUSTED-SSL-CERT/g' -i
> /etc/sysconfig/rhn/*
> .
> .
> rhnreg_ks --force --serverUrl=<yourServer>/XMLRPC
> --sslCACert=/usr/share/rhn/RHN-ORG-TRUSTED-SSL-CERT
> --activationkey=<your activation key>
>
> _______________________________________________
> Spacewalk-list mailing list
> Spacewalk-list at redhat.com
> https://www.redhat.com/mailman/listinfo/spacewalk-list
>
>
> _______________________________________________
> Spacewalk-list mailing list
> Spacewalk-list at redhat.com
> https://www.redhat.com/mailman/listinfo/spacewalk-list

_______________________________________________
Spacewalk-list mailing list
Spacewalk-list at redhat.com
https://www.redhat.com/mailman/listinfo/spacewalk-list

More information about the Spacewalk-list mailing list