[Spacewalk-list] installation problems

[Galia Lisovskaya]

Hi all,

I get some problems when I install Spacewalk on test KVM virtual macine.
I was try install it in last week, before Spacewalk 6 released.
I every get one problem:

http://fpaste.org/56g2/
(Tomcat failed to start properly or the installer ran out of tries.
Please check /var/log/tomcat5/catalina.out for errors.)

I try install Spacewalk 5, Spacewalk 6, use CentOS 5.3 and Fedora10. I
use Anaconda's kikstart file for base RedHat system installations, use
FQDN Local name (in LAN's DNS server, spacewalk2.local is my test
Spacewalk server)

Before Spacewalk, i did'nt have skill for Tomcat and Oracle (but have
skill for RedHat/CentOS, FreeBSD servers for High Load LAMP, for MTA,
and overs, don't full dump :))

In /var/log/tomcat5/catalina.out is errors:

WARNING: com.mchange.v2.resourcepool.BasicResourcePool$AcquireTask at 14bc4e6
-- Acquisition Attempt Failed!!! Clearing pending acquires. While
trying to acquire a needed new resource, we failed to succeed more
than the maximum number of allowed acquisition attempts (30).

I make fore howto

https://fedorahosted.org/spacewalk/wiki/OracleXeSetup

"In order to avoid these two problems we need to increase the max
processes in Oracle and to"
Some sql commands, but, problem not resolved,

Some overs errors:

2009-08-11 09:20:57,174 [main] WARN  org.hibernate.cfg.SettingsFactory
- Could not obtain connection metadata
java.sql.SQLException: Connections could not be acquired from the
underlying database!

Caused by: com.mchange.v2.resourcepool.CannotAcquireResourceException:
A ResourcePool could not acquire a resource from its primary factory o
r source.

WARNING: com.mchange.v2.resourcepool.BasicResourcePool$AcquireTask at d1a1ab
-- Acquisition Attempt Failed!!! Clearing pending acquires. While t
rying to acquire a needed new resource, we failed to succeed more than
the maximum number of allowed acquisition attempts (30).
11.08.2009 9:21:32 com.mchange.v2.resourcepool.BasicResourcePool$AcquireTask run
WARNING: com.mchange.v2.resourcepool.BasicResourcePool$AcquireTask at 16dc3e6
-- Acquisition Attempt Failed!!! Clearing pending acquires. While
trying to acquire a needed new resource, we failed to succeed more
than the maximum number of allowed acquisition attempts (30).
2009-08-11 09:21:32,313 [main] WARN
org.hibernate.util.JDBCExceptionReporter - SQL Error: 0, SQLState:
null
2009-08-11 09:21:32,313 [main] ERROR
org.hibernate.util.JDBCExceptionReporter - Connections could not be
acquired from the underlying databas
e!
2009-08-11 09:21:32,313 [main] ERROR
com.redhat.rhn.manager.satellite.UpgradeCommand - Problem upgrading!
com.redhat.rhn.common.hibernate.HibernateRuntimeException: couldn't open session

WARNING: com.mchange.v2.resourcepool.BasicResourcePool$AcquireTask at 1f01b29
-- Acquisition Attempt Failed!!! Clearing pending acquires. While
trying to acquire a needed new resource, we failed to succeed more
than the maximum number of allowed acquisition attempts (30).
2009-08-11 09:22:06,807 [TP-Processor3] WARN
org.hibernate.util.JDBCExceptionReporter - SQL Error: 0, SQLState:
null
2009-08-11 09:22:06,808 [TP-Processor3] ERROR
org.hibernate.util.JDBCExceptionReporter - Connections could not be
acquired from the underlyin
g database!
2009-08-11 09:22:06,808 [TP-Processor3] ERROR
com.redhat.rhn.frontend.servlets.SessionFilter - Error during
transaction. Rolling back
com.redhat.rhn.common.hibernate.HibernateRuntimeException: couldn't open session

Now, after installation, SQL-user spacewalk don't have access to
Oracle database:

=======================
[root at spacewalk2 ~]# sqlplus spacewalk/spacewalk at xe

SQL*Plus: Release 10.2.0.4.0 - Production on Tue Aug 11 10:22:14 2009

Copyright (c) 1982, 2007, Oracle.  All Rights Reserved.

ERROR:
ORA-01017: invalid username/password; logon denied


Enter user-name:
==========================

Before i run  spacewalk-setup --disconnected this user may have
connection for database. User sys now work (as before installation):


[root at spacewalk2 ~]# sqlplus 'sys at xe as sysdba'

SQL*Plus: Release 10.2.0.4.0 - Production on Tue Aug 11 10:23:25 2009

Copyright (c) 1982, 2007, Oracle.  All Rights Reserved.

Enter password:

Connected to:
Oracle Database 10g Express Edition Release 10.2.0.1.0 - Production

SQL> Disconnected from Oracle Database 10g Express Edition Release
10.2.0.1.0 - Production
[root at spacewalk2 ~]#

Web-managment for Oracle database work also.

Where i'm wrong?

Thanks for all answers and sorry for my bad English :)

-- 
Best regards,
Galia Lisovskaya.
e-mail: inbox at shaggy-cat.ru