<html xmlns:v="urn:schemas-microsoft-com:vml" xmlns:o="urn:schemas-microsoft-com:office:office" xmlns:w="urn:schemas-microsoft-com:office:word" xmlns:m="http://schemas.microsoft.com/office/2004/12/omml" xmlns="http://www.w3.org/TR/REC-html40"> <head> <meta http-equiv="Content-Type" content="text/html; charset=utf-8"> <meta name="Generator" content="Microsoft Word 14 (filtered medium)"> <style></style> </head> <body lang="DE" link="blue" vlink="purple"> <div class="WordSection1"> I’m also not a dba J but if you are able to login to Enterprise Manager you should be able to do the required steps via the gui.<o:p></o:p> <o:p> </o:p> <![if !supportLists]>- <![endif]>Login in with user SYS as sysdba<o:p></o:p> <![if !supportLists]>- <![endif]>Navigate to Security -> Users<o:p></o:p> <![if !supportLists]>- <![endif]>Mark the user and choose Actions -> Change Account<o:p></o:p> <![if !supportLists]>- <![endif]>Set new password and unlock the user in the dialogue<o:p></o:p> <o:p> </o:p> Regards,<o:p></o:p> Daniel<o:p></o:p> <o:p> </o:p> <div> <div style="border:none;border-top:solid #B5C4DF 1.0pt;padding:3.0pt 0cm 0cm 0cm"> Von: spacewalk-list-bounces@redhat.com [mailto:spacewalk-list-bounces@redhat.com] Im Auftrag von Robin Beardsley Gesendet: Freitag, 1. September 2017 14:08 An: spacewalk-list@redhat.com Betreff: Re: [Spacewalk-list] can't log in to web gui or run spacecmd<o:p></o:p> </div> </div> <o:p> </o:p> Thanks so much for your reply. I did all of the below command as sysdba. I then restarted spacewalk and the database. However I still can’t connect to the webgui or spacecmd.<o:p></o:p> <o:p> </o:p> In my Oracle Enterprise Manager (Express Edition) the spacewalk user shows as LOCKED(TIMED) and the SYSTEM user shows as EXPIRED(GRACE)<o:p></o:p> <o:p> </o:p> Any idea on how to fix this?<o:p></o:p> <o:p> </o:p> Thanks <o:p></o:p> <o:p> </o:p> <div> <div style="border:none;border-top:solid #E1E1E1 1.0pt;padding:3.0pt 0cm 0cm 0cm"> From: <a href="mailto:spacewalk-list-bounces@redhat.com">spacewalk-list-bounces@redhat.com</a> [<a href="mailto:spacewalk-list-bounces@redhat.com">mailto:spacewalk-list-bounces@redhat.com</a>] On Behalf Of Schindler, Daniel (STEAG Energy Services GmbH) Sent: Friday, September 1, 2017 4:09 AM To: <a href="mailto:spacewalk-list@redhat.com">spacewalk-list@redhat.com</a> Subject: Re: [Spacewalk-list] can't log in to web gui or run spacecmd<o:p></o:p> </div> </div> <o:p> </o:p> <o:p> </o:p> Hi Robin,<o:p></o:p> <o:p> </o:p> I assume you have a standalone database setup and you have access to the database. We ran into such problem about two weeks ago.<o:p></o:p> The problem was that the password for spacewalk db user was expired.<o:p></o:p> <o:p> </o:p> Here are the basic steps we performed:<o:p></o:p> [oracle@s01spw02 ~]$ sqlplus "/ as sysdba"<o:p></o:p> SQL> alter user <your_spacewalk_db_user> account unlock;<o:p></o:p> SQL> alter user <your_spacewalk_db_user> identified by newpa$$word;<o:p></o:p> SQL> alter profile DEFAULT limit PASSWORD_REUSE_TIME unlimited;<o:p></o:p> SQL> alter profile DEFAULT limit PASSWORD_LIFE_TIME unlimited;<o:p></o:p> <o:p> </o:p> I know this might be a security issue to disable password expiration in general. I will also write Oracle a service request to add this to their official documentation or at least provide different ways to adjust password expiration policies.<o:p></o:p> <o:p> </o:p> Regards,<o:p></o:p> Daniel<o:p></o:p> <o:p> </o:p> <div> <div style="border:none;border-top:solid #B5C4DF 1.0pt;padding:3.0pt 0cm 0cm 0cm"> Von: <a href="mailto:spacewalk-list-bounces@redhat.com">spacewalk-list-bounces@redhat.com</a> [<a href="mailto:spacewalk-list-bounces@redhat.com">mailto:spacewalk-list-bounces@redhat.com</a>] Im Auftrag von Robin Beardsley Gesendet: Donnerstag, 31. August 2017 21:04 An: <a href="mailto:spacewalk-list@redhat.com">spacewalk-list@redhat.com</a> Betreff: Re: [Spacewalk-list] can't log in to web gui or run spacecmd<o:p></o:p> </div> </div> <o:p> </o:p> No, c3p0 and cglib have not been updated. Currently they are at <o:p></o:p> <o:p> </o:p> <o:p> </o:p> [rbeards@oelsandbox ~]$ rpm -qa | grep c3p0<o:p></o:p> c3p0-0.9.1.2-2.jpp5.noarch<o:p></o:p> [rbeards@oelsandbox ~]$ rpm -qa | grep cglib<o:p></o:p> cglib-2.1.3-4.jpp5.noarch<o:p></o:p> <o:p></o:p> I noticed complaints in http errors logs about password expiration. If this is the real cause, does anyone know how to fix it? I have an oracle 12 database but I am not a dba.<o:p></o:p> <o:p> </o:p> [Thu Aug 31 14:39:08.592224 2017] [:error] [pid 34501] Spacewalk 34501 2017/08/31 14:39:08 -04:00: ("DATABASE CONNECTION TO 'spacewalk@//localhost/orcl.nedelta.com' LOST", "Exception information: 'NoneType' object has no attribute 'cursor'")<o:p></o:p> [Thu Aug 31 14:39:08.607568 2017] [:error] [pid 34501] Spacewalk 34501 2017/08/31 14:39:08 -04:00: ('Connection attempt failed', 28001, 'ORA-28001: the password has expired\\n')<o:p></o:p> [Thu Aug 31 14:39:37.653577 2017] [:error] [pid 33509] Spacewalk 33509 2017/08/31 14:39:37 -04:00: ('Connection attempt failed', 28001, 'ORA-28001: the password has expired\\n')<o:p></o:p> [Thu Aug 31 14:41:42.794240 2017] [:error] [pid 33516] Spacewalk 33516 2017/08/31 14:41:42 -04:00: ('Connection attempt failed', 28001, 'ORA-28001: the password has expired\\n')<o:p></o:p> [Thu Aug 31 14:41:57.138221 2017] [mpm_prefork:notice] [pid 33508] AH00170: caught SIGWINCH, shutting down gracefully<o:p></o:p> [Thu Aug 31 14:43:10.838257 2017] [suexec:notice] [pid 1719] AH01232: suEXEC mechanism enabled (wrapper: /usr/sbin/suexec)<o:p></o:p> [Thu Aug 31 14:43:10.848720 2017] [:notice] [pid 1719] ModSecurity for Apache/2.7.3 (<a href="http://www.modsecurity.org/">http://www.modsecurity.org/</a>) configured.<o:p></o:p> [Thu Aug 31 14:43:10.848731 2017] [:notice] [pid 1719] ModSecurity: APR compiled version="1.4.8"; loaded version="1.4.8"<o:p></o:p> [Thu Aug 31 14:43:10.848734 2017] [:notice] [pid 1719] ModSecurity: PCRE compiled version="8.32 "; loaded version="8.32 2012-11-30"<o:p></o:p> [Thu Aug 31 14:43:10.848736 2017] [:notice] [pid 1719] ModSecurity: LUA compiled version="Lua 5.1"<o:p></o:p> [Thu Aug 31 14:43:10.848737 2017] [:notice] [pid 1719] ModSecurity: LIBXML compiled version="2.9.1"<o:p></o:p> [Thu Aug 31 14:43:10.893313 2017] [auth_digest:notice] [pid 1719] AH01757: generating secret for digest authentication ...<o:p></o:p> [Thu Aug 31 14:43:10.893804 2017] [lbmethod_heartbeat:notice] [pid 1719] AH02282: No slotmem from mod_heartmonitor<o:p></o:p> [Thu Aug 31 14:43:10.914765 2017] [mpm_prefork:notice] [pid 1719] AH00163: Apache/2.4.6 () OpenSSL/1.0.2k-fips mod_wsgi/3.4 Python/2.7.5 configured -- resuming normal operations<o:p></o:p> [Thu Aug 31 14:43:10.914790 2017] [core:notice] [pid 1719] AH00094: Command line: '/usr/sbin/httpd -D FOREGROUND'<o:p></o:p> [Thu Aug 31 14:43:11.177830 2017] [proxy:error] [pid 1888] (111)Connection refused: AH00957: AJP: attempt to connect to 127.0.0.1:8009 (localhost) failed<o:p></o:p> [Thu Aug 31 14:43:11.177859 2017] [proxy:error] [pid 1888] AH00959: ap_proxy_connect_backend disabling worker for (localhost) for 60s<o:p></o:p> [Thu Aug 31 14:43:11.177879 2017] [proxy_ajp:error] [pid 1888] [client 127.0.0.1:36349] AH00896: failed to make connection to backend: localhost<o:p></o:p> [Thu Aug 31 14:44:05.825586 2017] [:error] [pid 1890] Spacewalk 1890 2017/08/31 14:44:05 -04:00: ('Connection attempt failed', 28001, 'ORA-28001: the password has expired\\n')<o:p></o:p> [Thu Aug 31 14:44:15.398432 2017] [:error] [pid 1895] Spacewalk 1895 2017/08/31 14:44:15 -04:00: ('Connection attempt failed', 28001, 'ORA-28001: the password has expired\\n')<o:p></o:p> [Thu Aug 31 14:44:41.161174 2017] [:error] [pid 1891] Spacewalk 1891 2017/08/31 14:44:41 -04:00: ('Connection attempt failed', 28001, 'ORA-28001: the password has expired\\n')<o:p></o:p> [Thu Aug 31 14:55:00.796406 2017] [:error] [pid 1895] Spacewalk 1895 2017/08/31 14:55:00 -04:00: ("DATABASE CONNECTION TO 'spacewalk@//localhost/orcl.nedelta.com' LOST", "Exception information: 'NoneType' object has no attribute 'cursor'")<o:p></o:p> [Thu Aug 31 14:55:00.814582 2017] [:error] [pid 1895] Spacewalk 1895 2017/08/31 14:55:00 -04:00: ('Connection attempt failed', 28001, 'ORA-28001: the password has expired\\n')<o:p></o:p> <o:p> </o:p> From: <a href="mailto:spacewalk-list-bounces@redhat.com">spacewalk-list-bounces@redhat.com</a> [<a href="mailto:spacewalk-list-bounces@redhat.com">mailto:spacewalk-list-bounces@redhat.com</a>] On Behalf Of Thomas Foster Sent: Thursday, August 31, 2017 1:53 PM To: <a href="mailto:spacewalk-list@redhat.com">spacewalk-list@redhat.com</a> Subject: Re: [Spacewalk-list] can't log in to web gui or run spacecmd<o:p></o:p> <o:p> </o:p> <div> Robin,<o:p></o:p> <div> <o:p> </o:p> </div> <div> Did it update c3p0 and cglib? If so that could be what's causing your server not to start. What version are you on?<o:p></o:p> </div> <div> <o:p> </o:p> </div> <div> Also check it out could help you identify the issue:<o:p></o:p> </div> <div> <a href="https://bugzilla.redhat.com/show_bug.cgi?id=1450906">https://bugzilla.redhat.com/show_bug.cgi?id=1450906</a><o:p></o:p> </div> </div> <div> <o:p> </o:p> <div> On Thu, Aug 31, 2017 at 1:25 PM, Robin Beardsley <<a href="mailto:RBeardsley@nedelta.com" target="_blank">RBeardsley@nedelta.com</a>> wrote:<o:p></o:p> <blockquote style="border:none;border-left:solid #CCCCCC 1.0pt;padding:0cm 0cm 0cm 6.0pt;margin-left:4.8pt;margin-top:5.0pt;margin-right:0cm;margin-bottom:5.0pt"> <div> <div> Today I tried to log in to my SW server and could not get in. I also tried to get in via spacecmd and could not get in.<o:p></o:p> This is from the rhn_taskomatic_daemon.log<o:p></o:p> <o:p></o:p> INFO | jvm 5 | 2017/08/31 12:43:15 | Wrapper (Version 3.2.3) <a href="http://wrapper.tanukisoftware.org" target="_blank">http://wrapper.tanukisoftware.org</a><o:p></o:p> INFO | jvm 5 | 2017/08/31 12:43:15 | Copyright 1999-2006 Tanuki Software, Inc. All Rights Reserved.<o:p></o:p> INFO | jvm 5 | 2017/08/31 12:43:15 |<o:p></o:p> ERROR | wrapper | 2017/08/31 12:43:44 | Startup failed: Timed out waiting for signal from JVM.<o:p></o:p> ERROR | wrapper | 2017/08/31 12:43:45 | JVM did not exit on request, terminated<o:p></o:p> INFO | wrapper | 2017/08/31 12:43:45 | JVM exited on its own while waiting to kill the application.<o:p></o:p> STATUS | wrapper | 2017/08/31 12:43:45 | JVM exited in response to signal SIGKILL (9).<o:p></o:p> FATAL | wrapper | 2017/08/31 12:43:45 | There were 5 failed launches in a row, each lasting less than 300 seconds. Giving up.<o:p></o:p> FATAL | wrapper | 2017/08/31 12:43:45 | There may be a configuration problem: please check the logs.<o:p></o:p> STATUS | wrapper | 2017/08/31 12:43:45 | <-- Wrapper Stopped<o:p></o:p> <o:p></o:p> <o:p></o:p> [root@oelsandbox rhn]# spacecmd<o:p></o:p> Welcome to spacecmd, a command-line interface to Spacewalk.<o:p></o:p> <o:p></o:p> Type: 'help' for a list of commands<o:p></o:p> 'help <cmd>' for command-specific help<o:p></o:p> 'quit' to quit<o:p></o:p> <o:p></o:p> Traceback (most recent call last):<o:p></o:p> File "/bin/spacecmd", line 166, in <module><o:p></o:p> if not shell.do_login(''):<o:p></o:p> File "/usr/lib/python2.7/site-packages/spacecmd/misc.py", line 284, in do_login<o:p></o:p> self.api_version = self.client.api.getVersion()<o:p></o:p> File "/usr/lib64/python2.7/xmlrpclib.py", line 1233, in __call__<o:p></o:p> return self.__send(self.__name, args)<o:p></o:p> File "/usr/lib64/python2.7/xmlrpclib.py", line 1587, in __request<o:p></o:p> verbose=self.__verbose<o:p></o:p> File "/usr/lib64/python2.7/xmlrpclib.py", line 1273, in request<o:p></o:p> return self.single_request(host, handler, request_body, verbose)<o:p></o:p> File "/usr/lib64/python2.7/xmlrpclib.py", line 1321, in single_request<o:p></o:p> response.msg,<o:p></o:p> xmlrpclib.ProtocolError: <ProtocolError for <a href="http://oelsandbox.nedelta.com/rpc/api" target="_blank">oelsandbox.nedelta.com/rpc/api</a>: 500 Internal Server Error><o:p></o:p> <o:p></o:p> Everything has been running fine up until today. I did a yum security update yesterday and the only update was a kernel update. I rebooted the server.<o:p></o:p> All spacewalk services were restarted and they all seem to be running.<o:p></o:p> <o:p></o:p> Tail of up2date log<o:p></o:p> <o:p></o:p> <o:p></o:p> [Wed Aug 30 10:52:31 2017] up2date Updating package profile<o:p></o:p> [Wed Aug 30 14:52:30 2017] up2date logging into up2date server<o:p></o:p> [Wed Aug 30 14:52:30 2017] up2date successfully retrieved authentication token from up2date server<o:p></o:p> [Wed Aug 30 18:52:30 2017] up2date logging into up2date server<o:p></o:p> [Wed Aug 30 18:52:30 2017] up2date successfully retrieved authentication token from up2date server<o:p></o:p> [Wed Aug 30 22:52:31 2017] up2date logging into up2date server<o:p></o:p> [Wed Aug 30 22:52:31 2017] up2date successfully retrieved authentication token from up2date server<o:p></o:p> [Thu Aug 31 02:52:31 2017] up2date logging into up2date server<o:p></o:p> [Thu Aug 31 02:52:31 2017] up2date successfully retrieved authentication token from up2date server<o:p></o:p> [Thu Aug 31 06:52:31 2017] up2date logging into up2date server<o:p></o:p> [Thu Aug 31 06:52:31 2017] up2date successfully retrieved authentication token from up2date server<o:p></o:p> [Thu Aug 31 12:32:52 2017] up2date logging into up2date server<o:p></o:p> [Thu Aug 31 12:32:53 2017] up2date A protocol error occurred: Internal Server Error , attempt #1,<o:p></o:p> [Thu Aug 31 12:35:25 2017] up2date logging into up2date server<o:p></o:p> [Thu Aug 31 12:35:32 2017] up2date A protocol error occurred: Internal Server Error , attempt #1,<o:p></o:p> [Thu Aug 31 12:35:48 2017] up2date logging into up2date server<o:p></o:p> [Thu Aug 31 12:36:18 2017] up2date A protocol error occurred: Internal Server Error , attempt #1,<o:p></o:p> [Thu Aug 31 12:48:08 2017] up2date logging into up2date server<o:p></o:p> [Thu Aug 31 12:48:38 2017] up2date A protocol error occurred: Internal Server Error , attempt #1,<o:p></o:p> [Thu Aug 31 12:55:08 2017] up2date logging into up2date server<o:p></o:p> [Thu Aug 31 12:55:35 2017] up2date A protocol error occurred: Internal Server Error , attempt #1,<o:p></o:p> <o:p></o:p> [root@oelsandbox log]# uname -r<o:p></o:p> 3.8.13-118.19.4.el7uek.x86_64<o:p></o:p> [root@oelsandbox log]# uptrack-uname -r<o:p></o:p> 3.8.13-118.19.4.el7uek.x86_64<o:p></o:p> <o:p></o:p> Does anyone have any idea what might be the cause of this?<o:p></o:p> <o:p></o:p> Thank you<o:p></o:p> <o:p></o:p> <o:p></o:p> <o:p></o:p> <o:p></o:p> <o:p></o:p> </div> </div> _______________________________________________ Spacewalk-list mailing list <a href="mailto:Spacewalk-list@redhat.com">Spacewalk-list@redhat.com</a> <a href="https://www.redhat.com/mailman/listinfo/spacewalk-list" target="_blank">https://www.redhat.com/mailman/listinfo/spacewalk-list</a><o:p></o:p> </blockquote> </div> <o:p> </o:p> </div> </div> </body> </html>