I seem to be suffering from a similar issue after a 1.1 -> 1.2 upgrade. The OSAD / Jabber issue is present, but I don’t get any 500 errors on the webapp. I do remember on my initial (1.1) setup I had the same error. I had to modify an SSL related setting regarding jabber, but it seems to be missing from my documentation. If I can resolve the issue ill post back :)
D -----Original Message----- From: [email protected] [mailto:[email protected]] On Behalf Of Benedetto Vassallo Sent: 22 November 2010 13:58 To: [email protected] Subject: [Spacewalk-list] Problems after 1.1 -> 1.2 upgrade Hello list, I upgraded my spacewalk server from v1.1 to v1.2 following the instructions at https://fedorahosted.org/spacewalk/wiki/HowToUpgrade and when issuing the command /usr/sbin/rhn-satellite start I have a notice about osa dispatcher doesn't work: [r...@spacewalk ~]# /usr/sbin/rhn-satellite start Starting spacewalk services... Initializing jabberd processes ... Starting router: [ OK ] Starting sm: [ OK ] Starting c2s: [ OK ] Starting s2s: [ OK ] Starting osa-dispatcher: RHN 13752 2010/11/22 14:40:54 +02:00: ('Traceback (most recent call last):\n File "/usr/share/rhn/osad/jabber_lib.py", line 254, in setup_connection\n c = self._get_jabber_client(js)\n File "/usr/share/rhn/osad/jabber_lib.py", line 311, in _get_jabber_client\n c.connect()\n File "/usr/share/rhn/osad/jabber_lib.py", line 568, in connect\n jabber.Client.connect(self)\n File "/usr/lib/python2.4/site-packages/jabber/xmlstream.py", line 464, in connect\n else: self._sock.connect((self._hostIP, self._port))\n File "<string>", line 1, in connect\nerror: (111, \'Connection refused\')\n',) [ OK ] Starting tomcat5: [ OK ] Starting httpd: [ OK ] Starting Monitoring ... Starting InstallSoftwareConfig ... [ OK ] Starting GenerateNotifConfig ... [ OK ] Starting NotifEscalator ... [ OK ] Starting NotifLauncher ... [ OK ] Starting Notifier ... [ OK ] Starting AckProcessor ... [ OK ] Starting TSDBLocalQueue ... [ OK ] [ OK ] Starting MonitoringScout ... Starting NPBootstrap ... [ OK ] Starting SputLite ... [ OK ] Starting Dequeuer ... [ OK ] Starting Dispatcher ... [ OK ] [ OK ] Starting rhn-search... Starting cobbler daemon: SERVING! [ OK ] Starting RHN Taskomatic... Done. When I issue the command /usr/sbin/rhn-satellite status I see sm and c2s are dead: [r...@spacewalk ~]# rhn-satellite status router (pid 13668) is running... sm dead but subsys locked c2s dead but subsys locked s2s (pid 13740) is running... osa-dispatcher (pid 13753) is running... /etc/init.d/tomcat5 is already running (14290) httpd (pid 14322) is running... 2010-11-22 14:45:23 Monitoring: ----------- InstallSoftwareConfig STATUS --------------- 2010-11-22 14:45:23 Monitoring: ----------- GenerateNotifConfig STATUS --------------- 2010-11-22 14:45:24 Monitoring: ----------- NotifEscalator STATUS --------------- 2010-11-22 14:45:25 Monitoring: ----------- NotifLauncher STATUS --------------- 2010-11-22 14:45:25 Monitoring: ----------- Notifier STATUS --------------- 2010-11-22 14:45:26 Monitoring: ----------- AckProcessor STATUS --------------- 2010-11-22 14:45:26 Monitoring: ----------- TSDBLocalQueue STATUS --------------- 2010-11-22 14:45:33 MonitoringScout: ----------- InstallSoftwareConfig STATUS --------------- 2010-11-22 14:45:33 MonitoringScout: ----------- NPBootstrap STATUS --------------- 2010-11-22 14:45:33 MonitoringScout: ----------- SputLite STATUS --------------- 2010-11-22 14:45:34 MonitoringScout: ----------- Dequeuer STATUS --------------- 2010-11-22 14:45:34 MonitoringScout: ----------- Dispatcher STATUS --------------- rhn-search is running (14655). cobblerd (pid 14870) is running... RHN Taskomatic is running (14970). When I access via web-ui and click on systems I got an Internal server error and the web traceback is this: The following exception occurred while executing this request: GET /rhn/systems/Overview.do Date:11/22/10 2:42:39 PM CET Headers: host: spacewalk.unipa.it connection: Keep-Alive user-agent: Mozilla/5.0 (X11; U; Linux x86_64; it-IT) AppleWebKit/533.3 (KHTML, like Gecko) rekonq Safari/533.3 referer: https://spacewalk.unipa.it/rhn/YourRhn.do accept: text/html, image/jpeg;q=0.9, image/png;q=0.9, text/*;q=0.9, image/*;q=0.9, */*;q=0.8 accept-encoding: x-gzip, x-deflate, gzip, deflate accept-charset: utf-8, utf-8;q=0.5, *;q=0.5 accept-language: it,en-US;q=0.9,en;q=0.8, it, en_US cookie: JSESSIONID=1D1EBD88EC5A1E976E161D6A29C445E3; auth_key=ed590246a70526015b020467ed2cde33; imp_key=875ac27d19e3728f52dc508c89fc0d31; Horde=15lel28htelpa4qf3n7k14n3k3; default_imp_view=dimp; pxt-session-cookie=16148xdeb0792bfcdf8121f73dafd8adb2ba51 Request: Local Name = spacewalk.unipa.it Server Name = spacewalk.unipa.it Requested Session Id came from Cookie Requested Session Valid = true Session = org.apache.catalina.session.standardsessionfac...@1757322[session=standardsession[1d1ebd88ec5a1e976e161d6a29c445e3]] Protocol = https Request Locale = en_US Request Character Encoding = UTF-8 Attribute Names = rhnActiveLang, pageList, javax.servlet.jsp.jstl.fmt.timeZone.request, legends, scCrit, javax.servlet.error.servlet_name, javax.servlet.request.key_size, javax.servlet.request.ssl_session, scMod, org.apache.struts.action.MESSAGE, javax.servlet.error.message, list_1680466951_rhn_set, javax.servlet.request.cipher_suite, parentUrl, javax.servlet.error.request_uri, scBug, groups, org.apache.struts.action.MODULE, scImp, javax.servlet.error.status_code, list_1680466951_selected_amt, scLow, scEhn, requestedUri, session, __sitemesh__filterapplied, javax.servlet.error.exception, org.apache.struts.action.mapping.instance, User Information: User vassallo (id 2, org_id 2) Exception: java.sql.SQLException: ORA-01427: single-row subquery returns more than one row at oracle.jdbc.driver.DatabaseError.throwSqlException(DatabaseError.java:112) at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:331) at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:288) at oracle.jdbc.driver.T4C8Oall.receive(T4C8Oall.java:745) at oracle.jdbc.driver.T4CPreparedStatement.doOall8(T4CPreparedStatement.java:219) at oracle.jdbc.driver.T4CPreparedStatement.executeForRows(T4CPreparedStatement.java:970) at oracle.jdbc.driver.OracleStatement.executeMaybeDescribe(OracleStatement.java:1072) at oracle.jdbc.driver.T4CPreparedStatement.executeMaybeDescribe(T4CPreparedStatement.java:854) at oracle.jdbc.driver.OracleStatement.doExecuteWithTimeout(OracleStatement.java:1154) at oracle.jdbc.driver.OraclePreparedStatement.executeInternal(OraclePreparedStatement.java:3370) at oracle.jdbc.driver.OraclePreparedStatement.execute(OraclePreparedStatement.java:3476) at com.mchange.v2.c3p0.impl.NewProxyPreparedStatement.execute(NewProxyPreparedStatement.java:651) at com.redhat.rhn.common.db.NamedPreparedStatement.execute(NamedPreparedStatement.java:138) at com.redhat.rhn.common.db.datasource.CachedStatement.execute(CachedStatement.java:455) at com.redhat.rhn.common.db.datasource.CachedStatement.executeElaboratorBatch(CachedStatement.java:371) at com.redhat.rhn.common.db.datasource.CachedStatement.executeElaboratorBatch(CachedStatement.java:406) at com.redhat.rhn.common.db.datasource.CachedStatement.executeElaborator(CachedStatement.java:352) at com.redhat.rhn.common.db.datasource.SelectMode.elaborate(SelectMode.java:163) at com.redhat.rhn.common.db.datasource.ModeElaborator.elaborate(ModeElaborator.java:48) at com.redhat.rhn.frontend.taglibs.list.decorators.ElaborationDecorator.elaborateContents(ElaborationDecorator.java:57) at com.redhat.rhn.frontend.taglibs.list.decorators.ElaborationDecorator.setCurrentList(ElaborationDecorator.java:37) at com.redhat.rhn.frontend.taglibs.list.ListTag.doAfterBody(ListTag.java:466) at org.apache.jsp.WEB_002dINF.pages.systems.overview_jsp._jspx_meth_rl_005flist_005f0(Unknown Source) at org.apache.jsp.WEB_002dINF.pages.systems.overview_jsp._jspx_meth_c_005fif_005f0(Unknown Source) at org.apache.jsp.WEB_002dINF.pages.systems.overview_jsp._jspx_meth_rl_005flistset_005f0(Unknown Source) at org.apache.jsp.WEB_002dINF.pages.systems.overview_jsp._jspService(Unknown 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(ApplicationFilterChain.java:269) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:188) at org.apache.catalina.core.ApplicationDispatcher.invoke(ApplicationDispatcher.java:691) at org.apache.catalina.core.ApplicationDispatcher.processRequest(ApplicationDispatcher.java:469) at org.apache.catalina.core.ApplicationDispatcher.doForward(ApplicationDispatcher.java:403) at org.apache.catalina.core.ApplicationDispatcher.forward(ApplicationDispatcher.java:301) at org.apache.struts.action.RequestProcessor.doForward(RequestProcessor.java:1085) at org.apache.struts.action.RequestProcessor.processForwardConfig(RequestProcessor.java:398) at org.apache.struts.action.RequestProcessor.process(RequestProcessor.java:241) at com.redhat.rhn.frontend.struts.RhnRequestProcessor.process(RhnRequestProcessor.java:82) at org.apache.struts.action.ActionServlet.process(ActionServlet.java:1196) at org.apache.struts.action.ActionServlet.doGet(ActionServlet.java:414) at javax.servlet.http.HttpServlet.service(HttpServlet.java:690) at javax.servlet.http.HttpServlet.service(HttpServlet.java:803) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:269) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:188) at com.redhat.rhn.frontend.servlets.AuthFilter.doFilter(AuthFilter.java:101) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:215) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:188) at com.opensymphony.module.sitemesh.filter.PageFilter.parsePage(PageFilter.java:142) at com.opensymphony.module.sitemesh.filter.PageFilter.doFilter(PageFilter.java:58) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:215) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:188) at com.redhat.rhn.frontend.servlets.LocalizedEnvironmentFilter.doFilter(LocalizedEnvironmentFilter.java:67) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:215) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:188) at com.redhat.rhn.frontend.servlets.EnvironmentFilter.doFilter(EnvironmentFilter.java:108) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:215) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:188) at com.redhat.rhn.frontend.servlets.SessionFilter.doFilter(SessionFilter.java:55) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:215) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:188) at com.redhat.rhn.frontend.servlets.SetCharacterEncodingFilter.doFilter(SetCharacterEncodingFilter.java:97) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:215) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:188) at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:210) at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:172) at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:127) at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:117) at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:108) at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java: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.java:704) at org.apache.jk.common.ChannelSocket$SocketConnection.runIt(ChannelSocket.java:897) at org.apache.tomcat.util.threads.ThreadPool$ControlRunnable.run(ThreadPool.java:685) at java.lang.Thread.run(Thread.java:636) What I can do? Thanks -- Benedetto Vassallo Sistema Informativo di Ateneo Settore Gestione Reti Hardware e Software U.O. Sviluppo e manutenzione dei sistemi Università degli studi di Palermo Red Hat Certified Engineer Certificate Number: 804007793324656 Phone: +3909123860056 Fax: +390916529124 ------------------------------------------------------------------------- This message was sent using the University of Palermo web mail interface. _______________________________________________ Spacewalk-list mailing list [email protected] https://www.redhat.com/mailman/listinfo/spacewalk-list Any opinions expressed in this email are those of the author and not necessarily those of Petrotechnics. If you are not the intended recipient of this email, please delete it and notify the sender. For quality assurance purposes, Petrotechnics may monitor incoming business communications. All email and attachments are scanned and free from viruses, although recipients are advised in accordance with best practise to confirm this for themselves. _______________________________________________ Spacewalk-list mailing list [email protected] https://www.redhat.com/mailman/listinfo/spacewalk-list
