[Spacewalk-list] Modification of spacewalk-service script

[Jan Pazdziora]

On Thu, Nov 03, 2011 at 08:40:58AM +0100, Pierre Casenove wrote:
> Hello all,
> I was initially working on this issue :
> https://www.redhat.com/archives/spacewalk-list/2011-August/msg00052.html
> osa-dispatcher, on my SW 1.5 with postgresql installation, was complaining
> that it couldn't connect to jabberd... and then reconnected 10 seconds
> later.
> Working on it, I found this at the beginning of the script:
> if [ -x /etc/init.d/oracle ]; then
>    DB_SERVICE="oracle"
> fi
> 
> So, spacewalk-service does not start postgresql but only oracle...
> I modified this to also control postgresql.... and as postgresql starts
> between jabberd and osa-dispatcher, the message doesn't shows up anymore.
> Of course, if the db is not local... the message will show up I guess.
> 
> Anyway, here is a patch for spacewalk-service to control postgresql if it
> is running on localhost.
> 
> --- /root/spacewalk-service.orig        2011-11-03 07:26:36.235829360 +0000
> +++ /usr/sbin/spacewalk-service 2011-11-03 07:39:39.465795746 +0000
> @@ -22,6 +22,8 @@
> 
>  if [ -x /etc/init.d/oracle ]; then
>     DB_SERVICE="oracle"
> +elif [ -x /etc/init.d/postgresql ]; then
> +   DB_SERVICE="postgresql"
>  fi
> 
>  if [ -x /etc/init.d/tomcat5 ]; then
> 
> Hope this helps,

Nack, we do not want to start/stop the PostgreSQL server, as we do
not start/stop the Oracle XE server either.

See

	https://www.redhat.com/archives/spacewalk-list/2010-October/msg00032.html

for discussion.

-- 
Jan Pazdziora
Principal Software Engineer, Satellite Engineering, Red Hat