[Spacewalk-list] Need help -- No idea what to do here

[Justin Edmands]

I would venture to say that you may have a corrupted database. Do you
have a backup of your DB from a previous day, week, month?
Best practices would say:
-/var/lib/pgsql(or oracles location) gets its own partition
-Monitoring/alerting for partitions when hitting 80-90% (monitoring
scout or use Nagios plugins)
-Nightly DB backups (a single backup for mine is 10GB)


Anyways...search around for information on how to do some DB
troubleshooting. The password stuff may be the issue, but unlikely as
it is not a common issue among other spacewalk instances.

If it's a virtual system, clone it first and then start doing the
things that involve messing with the database.

On Thu, Sep 18, 2014 at 6:52 PM, Amitakhya Phukan
<aphukan at fedoraproject.org> wrote:
> Hi all,
>
> Today I found that my Spacewalk server was not accessible. I tried
> restarting spacewalk-service and also oracle-xe. Then I found my / and /var
> were 100% utilized. Increased the space in them. Still no effect. Below is
> what I see when I start my spacewalk service. I understand that password has
> expired but I am unable to change it. Please help !!!!
>
>
> ====================Out put of starting spacewalk=============
>
> Starting osa-dispatcher: Spacewalk 7380 2014/09/18 15:31:16 -05:00:
> ('Connection attempt failed'                       , 28001, 'ORA-28001: the
> password has expired\n')
>
> Spacewalk 7380 2014/09/18 15:31:16 -05:00: ('Error caught:',)
>
> Spacewalk 7380 2014/09/18 15:31:16 -05:00: ('Traceback (most recent call
> last):\n  File "/usr/sh                       are/rhn/osad/jabber_lib.py",
> line 117, in main\n    self.setup_config(config)\n  File "/usr/shar
> e/rhn/osad/osa_dispatcher.py", line 112, in setup_config\n
> rhnSQL.initDB()\n  File "/usr/lib/
> python2.6/site-packages/spacewalk/server/rhnSQL/__init__.py", line 117, in
> initDB\n    raise e\n                       SQLConnectError: (28001,
> \'ORA-28001: the password has expired\\n\', \'spacewalk@//localhost/XE\
> ', \'Connection_Connect(): begin session\')\n',)
>
>                                                            [  OK  ]
>
> Starting Monitoring ...
>
> 2014-09-18 15:31:16 InstallSoftwareConfig:      !! DBI
> connect('//localhost/XE','spacewalk',...)                        failed:
> ORA-28001: the password has expired (DBD ERROR: OCISessionBegin) at
> /usr/share/perl5/ve                       ndor_perl/RHN/DBI.pm line 76
>
>
>
>         Starting InstallSoftwareConfig ...  [ FAIL ]
>
> 2014-09-18 15:31:16 InstallSoftwareConfig: WARNING: STARTED BUT *NOT*
> RUNNING
>
> 2014-09-18 15:31:16 InstallSoftwareConfig: ERRORS ENCOUNTERED DURING LAST
> ACTION:
>
> 2014-09-18 15:31:16 InstallSoftwareConfig:      !! DBI
> connect('//localhost/XE','spacewalk',...)                        failed:
> ORA-28001: the password has expired (DBD ERROR: OCISessionBegin) at
> /usr/share/perl5/ve                       ndor_perl/RHN/DBI.pm line 76
>
>
>
> 2014-09-18 15:31:16 Monitoring:         !! Monitoring configuration load
> failed
>
> 2014-09-18 15:31:16 Monitoring:         !! Monitoring configuration not
> loaded - not starting MO                       C functions!
>
> [ FAIL ]
>
> 2014-09-18 15:31:16 Monitoring: WARNING: STARTED BUT *NOT* RUNNING
>
> 2014-09-18 15:31:16 Monitoring: ERRORS ENCOUNTERED DURING LAST ACTION:
>
> 2014-09-18 15:31:16 Monitoring:         !! Monitoring configuration load
> failed
>
> 2014-09-18 15:31:16 Monitoring:         !! Monitoring configuration not
> loaded - not starting MO                       C functions!
>
> Starting MonitoringScout ...
>
> 2014-09-18 15:31:16 InstallSoftwareConfig: WARNING: STARTED BUT *NOT*
> RUNNING
>
> 2014-09-18 15:31:16 InstallSoftwareConfig: ERRORS ENCOUNTERED DURING LAST
> ACTION:
>
> 2014-09-18 15:31:16 InstallSoftwareConfig:      !! DBI
> connect('//localhost/XE','spacewalk',...)                        failed:
> ORA-28001: the password has expired (DBD ERROR: OCISessionBegin) at
> /usr/share/perl5/ve                       ndor_perl/RHN/DBI.pm line 76
>
> ==========================================================
>
> --
> Best regards,
> Amitakhya Phukan
>
> _______________________________________________
> Spacewalk-list mailing list
> Spacewalk-list at redhat.com
> https://www.redhat.com/mailman/listinfo/spacewalk-list