[Spacewalk-list] spacewalk/rhn/Login.do is blank

[Eric]

*Bump* I am probably missing something obvious in this output, but my eyes just don't want to see it.

I had the DBA add the following to the database:
>From https://fedorahosted.org/spacewalk/wiki/OracleXeSetup#AdditionalOracleconfiguration .

SQL> alter system set processes = 400 scope=spfile; 
SQL> alter system set "_optimizer_filter_pred_pullup"=false scope=spfile; 
SQL> alter system set "_optimizer_cost_based_transformation"=off scope=spfile; 

Restart the database.

This did not resolve my issue.
Regards,

-Eric



----- Original Message ----
From: Eric <linux_4_u at yahoo.com>
To: Spacewalk List <spacewalk-list at redhat.com>
Sent: Fri, March 5, 2010 2:36:56 PM
Subject: [Spacewalk-list] spacewalk/rhn/Login.do is blank

I am trying login to Spacewalk through the webUI and the https://spw.mydomain.local/rhn/Login.do is blank.

I am able to get the Oracle Database on the Spacewalk server through sqlplus spacewalk/[password]@rhnsat .
The Oracle database is 11g RAC.

I believe that the issue I am having is related to tomcat errors I am seeing. I will gladly post more logs/info upon request.
In /var/log/tomcat5/catalina.out I am seeing the following warning:

    WARNING: com.mchange.v2.resourcepool.BasicResourcePool$AcquireTask at 4bb369 -- 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).
2010-03-04 15:07:48,840 [main] WARN  org.hibernate.cfg.SettingsFactory - Could not obtain connection metadata
java.sql.SQLException: Connections could not be acquired from the underlying database!
        at com.mchange.v2.sql.SqlUtils.toSQLException(SqlUtils.java:104)
        at com.mchange.v2.c3p0.impl.C3P0PooledConnectionPool.checkoutPooledConnection(C3P0PooledConnectionPool.java:236)
        at com.mchange.v2.c3p0.PoolBackedDataSource.getConnection(PoolBackedDataSource.java:94)
        at org.hibernate.connection.C3P0ConnectionProvider.getConnection(C3P0ConnectionProvider.java:56)
        at org.hibernate.cfg.SettingsFactory.buildSettings(SettingsFactory.java:84)
        at org.hibernate.cfg.Configuration.buildSettings(Configuration.java:2009)
        at org.hibernate.cfg.Configuration.buildSessionFactory(Configuration.java:1292)
        at com.redhat.rhn.common.hibernate.ConnectionManager.createSessionFactory(ConnectionManager.java:173)
        at com.redhat.rhn.common.hibernate.ConnectionManager.initialize(ConnectionManager.java:119)
        at com.redhat.rhn.common.hibernate.HibernateFactory.createSessionFactory(HibernateFactory.java:94)
        at com.redhat.rhn.webapp.RhnServletListener.startHibernate(RhnServletListener.java:89)
        at com.redhat.rhn.webapp.RhnServletListener.contextInitialized(RhnServletListener.java:111)
        at org.apache.catalina.core.StandardContext.listenerStart(StandardContext.java:3764)
        at org.apache.catalina.core.StandardContext.start(StandardContext.java:4212)
        at org.apache.catalina.core.ContainerBase.addChildInternal(ContainerBase.java:760)
        at org.apache.catalina.core.ContainerBase.addChild(ContainerBase.java:740)
        at org.apache.catalina.core.StandardHost.addChild(StandardHost.java:544)
        at org.apache.catalina.startup.HostConfig.deployDescriptor(HostConfig.java:626)
        at org.apache.catalina.startup.HostConfig.deployDescriptors(HostConfig.java:553)
        at org.apache.catalina.startup.HostConfig.deployApps(HostConfig.java:488)
        at org.apache.catalina.startup.HostConfig.start(HostConfig.java:1138)
        at org.apache.catalina.startup.HostConfig.lifecycleEvent(HostConfig.java:311)
        at org.apache.catalina.util.LifecycleSupport.fireLifecycleEvent(LifecycleSupport.java:120)
        at org.apache.catalina.core.ContainerBase.start(ContainerBase.java:1022)
        at org.apache.catalina.core.StandardHost.start(StandardHost.java:736)
        at org.apache.catalina.core.ContainerBase.start(ContainerBase.java:1014)
        at org.apache.catalina.core.StandardEngine.start(StandardEngine.java:443)
        at org.apache.catalina.core.StandardService.start(StandardService.java:448)
        at org.apache.catalina.core.StandardServer.start(StandardServer.java:700)
        at org.apache.catalina.startup.Catalina.start(Catalina.java:552)
        at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
        at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:57)
        at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
        at java.lang.reflect.Method.invoke(Method.java:616)
        at org.apache.catalina.startup.Bootstrap.start(Bootstrap.java:295)
        at org.apache.catalina.startup.Bootstrap.main(Bootstrap.java:433)
Caused by: com.mchange.v2.resourcepool.CannotAcquireResourceException: A ResourcePool could not acquire a resource from its primary factory or source.
        at com.mchange.v2.resourcepool.BasicResourcePool.awaitAcquire(BasicResourcePool.java:970)
        at com.mchange.v2.resourcepool.BasicResourcePool.checkoutResource(BasicResourcePool.java:208)
        at com.mchange.v2.c3p0.impl.C3P0PooledConnectionPool.checkoutPooledConnection(C3P0PooledConnectionPool.java:232)
        ... 34 more

It seems to be related to https://fedorahosted.org/spacewalk/wiki/OracleXeSetup#AdditionalOracleconfiguration , but I had our DBA apply those configuration changes to the database.

-Eric


      

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