[Spacewalk-list] Re: Spacewalk-list Digest, Vol 15, Issue 10
Galia Lisovskaya
lists at shaggy-cat.ru
Wed Aug 12 21:50:52 UTC 2009
> you have to get the above part working. If you can't login with sqlplus
> and spacewalk/spacewalk at xe nothing in spacewalk is going to work.
>
> Go here:
>
> https://fedorahosted.org/spacewalk/wiki/OracleXeSetup
>
> Try the:
>
> "Create the spacewalk database user ś"
>
> step again.
I whrote incorrect information, password/access for spacewalk user is
correct, this access corectly as access with file
/etc/rhn/rhn.conf
in lines
db_user = spacewalk
db_password = XXXX
hibernate.connection.username=spacewalk
hibernate.connection.password=XXXX
Thank you for answer....
> Message: 4
> Date: Tue, 11 Aug 2009 02:36:01 +0400
> From: Galia Lisovskaya <lists at shaggy-cat.ru>
> Subject: [Spacewalk-list] installation problems
> To: spacewalk-list at redhat.com
> Message-ID:
> <c97c3940908101536u313a0170gd4b4b631181f0c87 at mail.gmail.com>
> Content-Type: text/plain; charset=ISO-8859-1
>
> 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
>
>
>
> ------------------------------
>
> Message: 5
> Date: Mon, 10 Aug 2009 16:46:44 -0700
> From: Mike McCune <mmccune at redhat.com>
> Subject: Re: [Spacewalk-list] installation problems
> To: spacewalk-list at redhat.com
> Message-ID: <4A80B164.6000009 at redhat.com>
> Content-Type: text/plain; charset=ISO-8859-1; format=flowed
>
> On 08/10/2009 03:36 PM, Galia Lisovskaya wrote:
>> 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:
> [snip]
>> 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:
>> ==========================
>
> you have to get the above part working. If you can't login with sqlplus
> and spacewalk/spacewalk at xe nothing in spacewalk is going to work.
>
> Go here:
>
> https://fedorahosted.org/spacewalk/wiki/OracleXeSetup
>
> Try the:
>
> "Create the spacewalk database user ś"
>
> step again.
>
> Mike
> --
> Mike McCune
> mmccune AT redhat.com
> Engineering | Portland, OR
> RHN Satellite | 650.254.4248
>
>
>
> ------------------------------
>
> Message: 6
> Date: Mon, 10 Aug 2009 20:39:48 -0400
> From: Justin Sherrill <jsherril at redhat.com>
> Subject: Re: [Spacewalk-list] Unknown Key in Cobbler Distro
> To: spacewalk-list at redhat.com
> Message-ID: <4A80BDD4.9080500 at redhat.com>
> Content-Type: text/plain; charset=ISO-8859-1
>
> Andy Speagle wrote:
>> On Mon, 2009-08-10 at 16:50 -0500, Mike McCune wrote:
>>> every kickstart profile in Spacewalk has a default activation key
>>> used
>>> with it, the 1st one you are seeing is the one associated with the
>>> profile, the 2nd is your custom key.
>>>
>>> Mike
>>
>> Hmmm... ok then. Any idea why I can't get the system registered using
>> the registration string in the kickstart, which includes both keys, ala:
>>
>> rhnreg_ks --serverUrl=https://<myserver>/XMLRPC
>> --sslCACert=/usr/share/rhn/RHN-ORG-TRUSTED-SSL-CERT
>> --activationkey=1-28ef2e19220231062d6ab036e00ddf38,1-037880d329934283fd3264f97aa33317
>>
>> The above string is what I see in my kickstart when I look at it via the
>> UI, however, if I look at the "cobbler.ks" file on the system after it
>> installs, the "other" activation key in the command above is completely
>> different... as if it's being generated randomly for each build. ala:
>>
>> rhnreg_ks --serverUrl=https://<myserver>/XMLRPC
>> --sslCACert=/usr/share/rhn/RHN-ORG-TRUSTED-SSL-CERT
>> --activationkey=1-037880d329934283fd3264f97aa33317,1-bc356b33a64a3b6c422a35a9bc019a7d
>>
>> Either way, I don't seem to be able to register until I remove the
>> "other" key and use just my chosen activation key.
>>
>> Any thoughts? I'm confused.
>>
>
> Can you try running the registration command that isn't working manually
> on a system?
>
> We might get an error message that tells us why it's not working.
>
> -Justin
>
>> Andy
>>
>>
>> ------------------------------------------------------------------------
>>
>> _______________________________________________
>> Spacewalk-list mailing list
>> Spacewalk-list at redhat.com
>> https://www.redhat.com/mailman/listinfo/spacewalk-list
>
>
> --
> Justin Sherrill, RHCA 1801 Varsity Drive.
> Software Engineer Raleigh, NC 27603
> Red Hat, Inc.
>
>
>
> ------------------------------
>
> Message: 7
> Date: Mon, 10 Aug 2009 22:11:46 -0700
> From: Mike McCune <mmccune at redhat.com>
> Subject: Re: [Spacewalk-list] Unknown Key in Cobbler Distro
> To: spacewalk-list at redhat.com
> Message-ID: <4A80FD92.4090107 at redhat.com>
> Content-Type: text/plain; charset=ISO-8859-1; format=flowed
>
> On 08/10/2009 05:39 PM, Justin Sherrill wrote:
>> Andy Speagle wrote:
>>> On Mon, 2009-08-10 at 16:50 -0500, Mike McCune wrote:
>>>> every kickstart profile in Spacewalk has a default activation key
>>>> used
>>>> with it, the 1st one you are seeing is the one associated with the
>>>> profile, the 2nd is your custom key.
>>>>
>>>> Mike
>>> Hmmm... ok then. Any idea why I can't get the system registered using
>>> the registration string in the kickstart, which includes both keys, ala:
>>>
>>> rhnreg_ks --serverUrl=https://<myserver>/XMLRPC
>>> --sslCACert=/usr/share/rhn/RHN-ORG-TRUSTED-SSL-CERT
>>> --activationkey=1-28ef2e19220231062d6ab036e00ddf38,1-037880d329934283fd3264f97aa33317
>>>
>>> The above string is what I see in my kickstart when I look at it via the
>>> UI, however, if I look at the "cobbler.ks" file on the system after it
>>> installs, the "other" activation key in the command above is completely
>>> different... as if it's being generated randomly for each build. ala:
>>>
>>> rhnreg_ks --serverUrl=https://<myserver>/XMLRPC
>>> --sslCACert=/usr/share/rhn/RHN-ORG-TRUSTED-SSL-CERT
>>> --activationkey=1-037880d329934283fd3264f97aa33317,1-bc356b33a64a3b6c422a35a9bc019a7d
>>>
>>> Either way, I don't seem to be able to register until I remove the
>>> "other" key and use just my chosen activation key.
>>>
>>> Any thoughts? I'm confused.
>>>
>>
>> Can you try running the registration command that isn't working manually
>> on a system?
>>
>> We might get an error message that tells us why it's not working.
>>
>> -Justin
>>
>
> Like Justin said, after the system finishes kickstarting try running:
>
> rhnreg_ks --serverUrl=https://<myserver>/XMLRPC
> --sslCACert=/usr/share/rhn/RHN-ORG-TRUSTED-SSL-CERT
> --activationkey=1-037880d329934283fd3264f97aa33317,1-bc356b33a64a3b6c422a35a9bc019a7d
>
> and let us know what error message you see
>
> Mike
> --
> Mike McCune
> mmccune AT redhat.com
> Engineering | Portland, OR
> RHN Satellite | 650.254.4248
>
>
>
> ------------------------------
>
> Message: 8
> Date: Tue, 11 Aug 2009 08:45:33 +0200
> From: Michael Mraka <michael.mraka at redhat.com>
> Subject: Re: [Spacewalk-list] RE: Spacewalk 0.6 RELEASED!
> To: spacewalk-list at redhat.com
> Message-ID: <20090811064533.GA3197 at magni.lab.eng.brq.redhat.com>
> Content-Type: text/plain; charset=iso-8859-2
>
> Rob Becker wrote:
> % I got the same with RHEL5.3. The system was registered with RHN, so I'm
> % kinda confused on why it didn't pull down the dependent files from
> % there.
>
> # yum resolvedep 'perl(Cache::FileCache)'
> Loaded plugins: rhnplugin, security
> epel | 2.3 kB 00:00
> primary.sqlite.bz2 | 2.4 MB 00:00
> 0:perl-Cache-Cache-1.05-1.el5.noarch
>
> # yum list perl-Cache-Cache
> Loaded plugins: rhnplugin, security
> Available Packages
> perl-Cache-Cache.noarch 1.05-1.el5
> epel
>
> Do you have EPEL repo enabled?
>
> % -Rob
> % On Mon, 2009-08-10 at 12:11 -0400, Jeff Moody wrote:
> % > When trying to do a clean install of Spacewalk 0.6 on a i386 fresh
> % > install of CentOS 5.3, I get the following:
> % >
> % > Error: Missing Dependency: perl(Cache::FileCache) is needed by package
> % > spacewalk-pxt-0.6.19-1.el5.noarch (spacewalk)
> % > Error: Missing Dependency: perl(Params::Validate) is needed by package
> % > spacewalk-base-0.6.19-1.el5.noarch (spacewalk)
> ...
>
> --
> Michael Mráka
> Satellite Engineering, Red Hat
>
>
>
> ------------------------------
>
> _______________________________________________
> Spacewalk-list mailing list
> Spacewalk-list at redhat.com
> https://www.redhat.com/mailman/listinfo/spacewalk-list
>
> End of Spacewalk-list Digest, Vol 15, Issue 10
> **********************************************
>
--
Best regards,
Galia Lisovskaya.
e-mail: inbox at shaggy-cat.ru
More information about the Spacewalk-list
mailing list