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

[Vishal Patil]

Hi Eric,

I was also getting the same error , when checked through *netstat -tulpn*  I
noticed that port 8080 is used by Oracle listener , as default port for
tomcat is also 8080, I was facing similar issue. After manually changing
port for tomcat in server.xml t and restarting rhn-satellite worked for me..


Regards
Vishal

On Sat, Mar 6, 2010 at 2:06 AM, Eric <linux_4_u at yahoo.com> wrote:

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



-- 

Regards
Vishal
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://listman.redhat.com/archives/spacewalk-list/attachments/20100306/2082c5eb/attachment.htm>