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

[Milan Zazrivec]

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