[Spacewalk-list] installation problem

[Galia Lisovskaya]

Problem was resolved, when i reinstall spacewalk at 1,5Gb RAM KVM
Virtual System,
and set locale LANG=en_US.utf8 (with ru_RU.utf8 i geted error
ORA-00604, but may be, I get this error because of the small amount of
RAM, not locale ru_RU.utf8 bug)

Thank's for attention.

>> 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