[Spacewalk-list] Manual db schema upgrade 0.4 to 0.5

[Milan Zazrivec]

On Tuesday 07 April 2009 15:49:10 Jan-Frode Myklebust wrote:
> On Tue, Apr 07, 2009 at 01:59:22PM +0200, Milan Zazrivec wrote:
> > The wiki page you are referring to should be the final version for
> > 0.4 -> 0.5 upgrades.
>
> Great, thanks!
>
> I just upgraded our RHEL5/x86_64 server, with spacewalk 0.4, and the
> database on an external Oracle cluster. A couple of minor issues:
>
> 	o oracle-lib-compat wrongly assume that we're running v10.2.0.4 of
> 	  the oracle client packages, and broke /usr/share/java/ojdbc14.jar
> 	  and /usr/bin/sqlplus for us. So I had to manually point these at
> 	  v10.2.0.3.
>
> 	o the /usr/bin/spacewalk-schema-upgrade was first blocked by selinux:
>
> 	type=AVC msg=audit(1239108979.586:424345): avc:  denied  { read } for 
> pid=17000 comm="sqlplus"
> path="/var/log/spacewalk/schema-upgrade/20090407-145611-script.sql"
> dev=dm-2 ino=691803 scontext=user_u:system_r:oracle_sqlplus_t:s0
> tcontext=user_u:object_r:var_log_t:s0 tclass=file
>
> 	 but I fixed that by temporarily running selinux permissive.

Thank you for this feedback, I updated the upgrade docs to say to switch
to selinux permissive for the schema upgrade step.

Regards
Milan