[Spacewalk-list] Spacewalk Web Gui broken

Robert Hernandez herna175 at mail.chapman.edu
Mon Apr 26 21:08:29 UTC 2010


Hello,
I recently tried to update a managed config file on my spacewalk server.
Immediately after updating the config file the web gui became a blank page.
I tried restart the httpd service but no luck.  I tried looking through the
log files.  In /var/log/httpd/error_log I found:

Exception Handler Information
Traceback (most recent call last):
  File "/usr/share/rhn/server/
apacheHandler.py", line 72, in headerParserHandler
    rhnSQL.initDB()
  File "/usr/share/rhn/server/rhnSQL/__init__.py", line 98, in initDB
    __init__DB(backend, host, port, username, password, database)
  File "/usr/share/rhn/server/rhnSQL/__init__.py", line 59, in __init__DB
    __DB.check_connection()
  File "/usr/share/rhn/server/rhnSQL/driver_cx_Oracle.py", line 490, in
check_connection
    self.connect() # only allow one try
  File "/usr/share/rhn/server/rhnSQL/driver_cx_Oracle.py", line 386, in
connect
    raise apply(sql_base.SQLConnectError, err_args)
SQLConnectError: (12505, 'ORA-12505: TNS:listener does not currently know of
SID given in connect descriptor\n', 'XE', 'Connection_Connect(): server
attach')

Then I ran lsnrctl services:

LSNRCTL for Linux: Version 10.2.0.1.0 - Production on 23-APR-2010 14:50:34

Copyright (c) 1991, 2005, Oracle.  All rights reserved.

Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=IPC)(KEY=EXTPROC_FOR_XE)))
Services Summary...
Service "PLSExtProc" has 1 instance(s).
  Instance "PLSExtProc", status UNKNOWN, has 1 handler(s) for this
service...
    Handler(s):
      "DEDICATED" established:0 refused:0
         LOCAL SERVER
Service "XE" has 1 instance(s).
  Instance "XE", status READY, has 1 handler(s) for this service...
    Handler(s):
      "DEDICATED" established:109 refused:0 state:ready
         LOCAL SERVER
Service "XEXDB" has 1 instance(s).
  Instance "XE", status READY, has 1 handler(s) for this service...
    Handler(s):
      "D000" established:0 refused:0 current:0 max:972 state:ready
         DISPATCHER <machine: spacewalk.chapman.edu, pid: 17815>
         (ADDRESS=(PROTOCOL=tcp)(HOST=spacewalk.chapman.edu)(PORT=37104))
Service "XE_XPT" has 1 instance(s).
  Instance "XE", status READY, has 1 handler(s) for this service...
    Handler(s):
      "DEDICATED" established:109 refused:0 state:ready
         LOCAL SERVER
The command completed successfully

PLSExtProc status is UNKNOWN but I looked at listener.ora and tnsnames.ora
it seems to be configured properly.  Does the status UNKNOWN really matter
if it doesnt have any refused connections?

In /var/log/tomcat5/catalina.out had this error in:

SEVERE: Exception Processing ErrorPage[errorCode=500,
location=/WEB-INF/pages/co
mmon/errors/500.jsp]
javax.servlet.ServletException: javax.servlet.ServletException:
javax.servlet.js
p.JspException: Error writing to JSP file:
        at
org.apache.jasper.runtime.PageContextImpl.doHandlePageException(PageC
ontextImpl.java:846)
        at
org.apache.jasper.runtime.PageContextImpl.handlePageException(PageCon
textImpl.java:779)
        at
org.apache.jsp.WEB_002dINF.pages.common.errors._500_jsp._jspService(U
nknown Source)
        at
org.apache.jasper.runtime.HttpJspBase.service(HttpJspBase.java:98)
        at javax.servlet.http.HttpServlet.service(HttpServlet.java:803)
        at
org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(Appl
icationFilterChain.java:269)
        at
org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationF
ilterChain.java:188)
        at
org.apache.catalina.core.ApplicationDispatcher.invoke(ApplicationDisp
atcher.java:691)
        at
org.apache.catalina.core.ApplicationDispatcher.processRequest(Applica
tionDispatcher.java:471)
        at
org.apache.catalina.core.ApplicationDispatcher.doForward(ApplicationD
ispatcher.java:403)
        at
org.apache.catalina.core.ApplicationDispatcher.forward(ApplicationDis
patcher.java:301)
        at
org.apache.catalina.core.StandardHostValve.custom(StandardHostValve.j
ava:364)
        at
org.apache.catalina.core.StandardHostValve.status(StandardHostValve.j
ava:285)
        at
org.apache.catalina.core.StandardHostValve.throwable(StandardHostValv
e.java:229)
        at
org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.j
ava:135)
        at
org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.j
ava:117)
        at
org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineVal
ve.java:108)
        at
org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.jav
a:151)
        at
org.apache.jk.server.JkCoyoteHandler.invoke(JkCoyoteHandler.java:200)
        at
org.apache.jk.common.HandlerRequest.invoke(HandlerRequest.java:291)
        at org.apache.jk.common.ChannelSocket.invoke(ChannelSocket.java:775)
        at
org.apache.jk.common.ChannelSocket.processConnection(ChannelSocket.ja
va:704)
        at
org.apache.jk.common.ChannelSocket$SocketConnection.runIt(ChannelSock
et.java:897)
        at
org.apache.tomcat.util.threads.ThreadPool$ControlRunnable.run(ThreadP
ool.java:685)
        at java.lang.Thread.run(Thread.java:636)



I am not sure whats exactly making my spacewalk web gui to only show up as a
blank page.  Spacewalk just goes to rhn/login.do but its a blank page.  The
log files also show Apache configured -- resuming normal operation.  Has
anyone ever seen this?

Thanks for your time,
Robert
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://listman.redhat.com/archives/spacewalk-list/attachments/20100426/a2a1fc20/attachment.htm>


More information about the Spacewalk-list mailing list