I'm having the same problems with Jabber/OSA-dispatcher, although my Systems view in the web interface works.
============ [root]# /usr/sbin/rhn-satellite status router (pid 18237) is running... sm dead but subsys locked c2s dead but subsys locked s2s (pid 18291) is running... osa-dispatcher (pid 18305) is running... /etc/init.d/tomcat5 is already running (18828) httpd (pid 18845) is running... rhn-search is running (18896). cobblerd (pid 18920) is running... RHN Taskomatic is running (18945). ============ I can't execute remote commands however as I get an internal server error and the following exception e-mailed to me: ============ The following exception occurred while executing this request: POST /network/systems/ssm/provisioning/remote_command_conf.pxt HTTP/1.1 (from browser) /network/systems/ssm/provisioning/remote_command_conf.pxt (from Apache) Date: Sat Nov 20 19:38:49 2010 Headers: Accept: application/xml,application/xhtml+xml,text/html;q=0.9,text/plain;q=0.8,image/png,*/*;q=0.5 Accept-Encoding: gzip, deflate Accept-Language: en-us Connection: keep-alive Content-Length: 669 Content-Type: application/x-www-form-urlencoded Cookie: pxt-session-cookie=6248x0763165c334075d864f5c579be708818; __utma=253479006.211728884.1275232488.1289669700.1289671594.87; __utmz=253479006.1281047218.41.5.utmcsr=lindiskitschjewellery.co.uk|utmccn=(referral)|utmcmd=referral|utmcct=/page_1280314630323.html Host: linux.manage.freethought-internet.co.uk Origin: https://linux.manage.freethought-internet.co.uk Referer: https://linux.manage.freethought-internet.co.uk/network/systems/ssm/provisioning/remote_command_conf.pxt User-Agent: Mozilla/5.0 (Macintosh; U; Intel Mac OS X 10_6_5; en-us) AppleWebKit/533.18.1 (KHTML, like Gecko) Version/5.0.2 Safari/533.18.5 Form variables: alphabar_column => SERVER_NAME am_pm => PM day => 20 filter_value => first_lower => 1 first_upper => 25 formvars => hour formvars => hour formvars => hour formvars => hour formvars => hour formvars => hour formvars => hour formvars => hour formvars => hour formvars => hour formvars => hour group => root hour => 7 last_lower => 26 last_upper => 27 list_action_label_schedule_command => Schedule commands list_action_url_schedule_command => list_mode => ssm_remote_commandable lower => 1 minute => 38 month => 11 next_lower => 26 next_upper => 27 prev_filter_value => prev_lower => 1 prev_upper => 25 pxt:trap => rhn:system_list_cb script => #!/bin/sh /sbin/service osad restart timeout => 600 upper => 25 username => root year => 2010 User Information: User hostmaster (id 1, org_id 1) Error notes: (none) Initial Request: Yes Error message: Died at /usr/lib/perl5/vendor_perl/5.8.8/RHN/DB.pm line 545. ============ I've not had a chance to look into the cause of this any further yet, so can't be more help other than saying "me too" unfortunately. Edward Dore Freethought Internet ----- Original Message ----- From: "Benedetto Vassallo" <vassa...@unipa.it> To: spacewalk-list@redhat.com Sent: Monday, 22 November, 2010 1:57:42 PM 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 Spacewalk-list@redhat.com https://www.redhat.com/mailman/listinfo/spacewalk-list _______________________________________________ Spacewalk-list mailing list Spacewalk-list@redhat.com https://www.redhat.com/mailman/listinfo/spacewalk-list