[Spacewalk-list] Spacewalk upgrade 0.5 -> 0.6 fails at schema upgrade

[Milan Zazrivec]

On Wednesday 19 August 2009 10:29:02 Ade wrote:
> 2009/8/19 Milan Zazrivec <mzazrivec at redhat.com>:
> > On Wednesday 19 August 2009 10:07:31 Ade wrote:
> >> 2009/8/18 Milan Zazrivec <mzazrivec at redhat.com>:
> >> > On Tuesday 18 August 2009 10:59:13 Ade wrote:
> >> >> Ive been running Spacewalk 0.5 on a Centos 5.3 system for a while now
> >> >> and I (yesterday) attempted an upgrade. I realised that I hadnt
> >> >> updated the .repo file and so I did this and attempted the upgrade
> >> >> again
> >> >>
> >> >> It fails at the schema upgrade part, with the following error and
> >> >> doesnt put any log file in the directory mentioned
> >> >>
> >> >> Heres the output
> >> >>
> >> >>
> >> >> # /usr/bin/spacewalk-schema-upgrade
> >> >> Schema upgrade: [spacewalk-schema-0.5.20-1.el5] ->
> >> >> [spacewalk-schema-0.6.22-1.el5]
> >> >> Searching for upgrade path: [spacewalk-schema-0.5.20-1] ->
> >> >> [spacewalk-schema-0.6.22-1]
> >> >> Searching for upgrade path: [spacewalk-schema-0.5.20] ->
> >> >> [spacewalk-schema-0.6.22]
> >> >> Searching for upgrade path: [spacewalk-schema-0.5] ->
> >> >> [spacewalk-schema-0.6] The path: [spacewalk-schema-0.5] ->
> >> >> [spacewalk-schema-0.6]
> >> >> Planing to run sqlplus with
> >> >> [/var/log/spacewalk/schema-upgrade/20090817-155010-script.sql]
> >> >> Hit Enter to continue or Ctrl+C to interrupt:
> >> >> Executing sqlplus, the logs are in
> >> >> /var/log/spacewalk/schema-upgrade/20090817-155010-*.
> >> >> O/S Message: Permission denied
> >> >
> >> > Are you running with selinux enforcing? If so, what does
> >> >
> >> > # ls -ldZ /var/log/spacewalk/schema-upgrade
> >> >
> >> > tell you? Normally it should give you:
> >> >
> >> > # ls -ldZ /var/log/spacewalk/schema-upgrade
> >> > drwxr-xr-x  root root
> >> > user_u:object_r:oracle_sqlplus_log_t /var/log/spacewalk/schema-upgrade
> >> >
> >> > -MZ
> >>
> >> Hi Milan
> >>
> >> Yes I am running with SELinux enforcing - here is the output. It looks
> >> different to what you expected
> >>
> >> # ls -ldZ /var/log/spacewalk/schema-upgrade
> >> drwxr-xr-x  root root root:object_r:var_log_t
> >> /var/log/spacewalk/schema-upgrade
> >
> > Try running:
> >
> > # restorecon -vR /var/log/spacewalk/schema-upgrade
> >
> > and then:
> >
> > # ls -ldZ /var/log/spacewalk/schema-upgrade
> >
> > Now (hopefully) the context should look good and you can
> > do the schema upgrade now.
> >
> > -Milan
>
> I tried it, but it didnt seem to work :-s
>
> [root at spacewalk ~]# restorecon -vR /var/log/spacewalk/schema-upgrade
> [root at spacewalk ~]# ls -ldZ /var/log/spacewalk/schema-upgrade
> drwxr-xr-x  root root root:object_r:var_log_t
> /var/log/spacewalk/schema-upgrade

Perhaps you're missing some of the selinux rpms. Can you please post
output from:

# rpm -qa|grep selinux

-Milan