Re: [Spacewalk-list] Oracle 12/ 18 Database Support

[Avi Miller]

Hey Richard,

> On 2 May 2019, at 7:01 pm, Richard  wrote:
> 
> My DBA tells me we are running in Oracle 11.2.0 compatibility mode (Database 
> Upgrade Guide).  Is there any reason we should not move to Oracle 18.6.0 
> compatibility ?

None that I can think of. 

Our plan is to complete testing of Spacewalk 2.9 with the latest Oracle Instant 
Client 18c (which is available from yum.oracle.com with no click-through 
license any more[1]) and then push the spec file changes to shift to this 
client upstream. The updated Instant Client will work with all DB versions from 
11gR2 all the way up to 19c.

However, I don’t have an ETA on the completion of this testing yet. Our suite 
has to run across three database versions with the server on two major versions 
of the distro and two architectures for one of those versions, so it can take 
weeks to complete. :)

Thanks,
Avi

[1] 
http://yum.oracle.com/repo/OracleLinux/OL7/oracle/instantclient/x86_64/index.html


--
Avi Miller | Senior Manager | +61 (03) 8616-3496
Oracle Linux and VM Product Management
417 St Kilda Road, Melbourne VIC 3004 Australia


___
Spacewalk-list mailing list
Spacewalk-list@redhat.com
https://www.redhat.com/mailman/listinfo/spacewalk-list

Re: [Spacewalk-list] Mail Notifications

[Gerald Vogt]

On 02.05.19 16:16, p.cook...@bham.ac.uk wrote:

Good afternoon

I have *Spacewalk 2.8* installed on a *RHEL 7.6* system with *Postfix* 
configured to use our *own mail relay*. If I send an email test, from 
the command line, to my personal email box I receive the email 
straightaway. However, I’m not receiving email Notifications, from 
Spacewalk, even though they are checked in the Users’ Preferences screen.


I can see the following type of errors in */var/log/maillog* (hostname 
etc made anonymous):


May  2 14:34:50  postfix/smtp[45681]: 422EAE2C60: 
to=@, relay=[]:25, delay=409786, 
delays=409781/0.03/5/0.02, dsn=4.0.0, status=deferred (host relay=name>[] said: 451 Temporary local problem - please try later 
(in reply to RCPT TO command))


Your relay says that there is a temporary local problem on your relay. 
First place to look is into the mail logs on your relay and find out 
what problem it is. Until you know the problem it's pretty pointless to 
guess what it might be and what might fix the problem.


Is there some Spacewalk configuration that needs to be done to enable it 
to utilise Postfix perhaps? As an example I’ve seen some references to 
*web.default_mail_from*, in */etc/rhn/rhn.conf*, but I’m not sure what 
it actually needs to be set to.


You should know what your mail relay needs to process the email. So you 
should know what you need to set.


So find out what the problem is on your mail relay and then you most 
likely know what's wrong or missing. Then you have to either fix your 
relay or spacewalk or both, depending on what it is...


Cheers,

Gerald



Regards

Philip Cookson

Linux Administrator

IT Services

ERI Building

Edgbaston

Birmingham

B15 2TT

Tel: 0121 414 4731

Email: p.cook...@bham.ac.uk


___
Spacewalk-list mailing list
Spacewalk-list@redhat.com
https://www.redhat.com/mailman/listinfo/spacewalk-list



___
Spacewalk-list mailing list
Spacewalk-list@redhat.com
https://www.redhat.com/mailman/listinfo/spacewalk-list

Re: [Spacewalk-list] Mail Notifications

[Graeme Fowler]

The error message you detail looks to me very much like an Exim response, not 
Postfix; your system looks to be accepting the locally-generated mail but the 
mail relay is struggling with it.

If you’re not sending from a fully-qualified, verifiable sender address within 
your own institution’s email namespace(s) then you might well find the relay 
won’t accept the messages – although the 451 error implies that there’s 
something the relay can’t process rather than something it rejects on.

At Loughborough we set default_mail_from to be 
root@hostname.domain – so something like:

default_mail_from = 
r...@dev-spacewalk-instance.birmingham.ac.uk

(noting that the hostname/domain must resolve in your DNS!)

Graeme

From:  on behalf of "p.cook...@bham.ac.uk" 

Reply-To: "spacewalk-list@redhat.com" 
Date: Thursday, 2 May 2019 at 15:19
To: "spacewalk-list@redhat.com" 
Subject: [Spacewalk-list] Mail Notifications

Good afternoon

I have Spacewalk 2.8 installed on a RHEL 7.6 system with Postfix configured to 
use our own mail relay. If I send an email test, from the command line, to my 
personal email box I receive the email straightaway. However, I’m not receiving 
email Notifications, from Spacewalk, even though they are checked in the Users’ 
Preferences screen.

I can see the following type of errors in /var/log/maillog (hostname etc made 
anonymous):

May  2 14:34:50  postfix/smtp[45681]: 422EAE2C60: 
to=@, relay=[]:25, delay=409786, 
delays=409781/0.03/5/0.02, dsn=4.0.0, status=deferred (host relay=[] said: 451 Temporary local problem - please try later (in 
reply to RCPT TO command))

Is there some Spacewalk configuration that needs to be done to enable it to 
utilise Postfix perhaps? As an example I’ve seen some references to 
web.default_mail_from, in /etc/rhn/rhn.conf, but I’m not sure what it actually 
needs to be set to.

Regards

Philip Cookson
Linux Administrator
IT Services
ERI Building
Edgbaston
Birmingham
B15 2TT

Tel: 0121 414 4731
Email: p.cook...@bham.ac.uk

___
Spacewalk-list mailing list
Spacewalk-list@redhat.com
https://www.redhat.com/mailman/listinfo/spacewalk-list

[Spacewalk-list] Mail Notifications

[p.cook...@bham.ac.uk]

Good afternoon

I have Spacewalk 2.8 installed on a RHEL 7.6 system with Postfix configured to 
use our own mail relay. If I send an email test, from the command line, to my 
personal email box I receive the email straightaway. However, I'm not receiving 
email Notifications, from Spacewalk, even though they are checked in the Users' 
Preferences screen.

I can see the following type of errors in /var/log/maillog (hostname etc made 
anonymous):

May  2 14:34:50  postfix/smtp[45681]: 422EAE2C60: 
to=@, relay=[]:25, delay=409786, 
delays=409781/0.03/5/0.02, dsn=4.0.0, status=deferred (host relay=[] said: 451 Temporary local problem - please try later (in 
reply to RCPT TO command))

Is there some Spacewalk configuration that needs to be done to enable it to 
utilise Postfix perhaps? As an example I've seen some references to 
web.default_mail_from, in /etc/rhn/rhn.conf, but I'm not sure what it actually 
needs to be set to.

Regards

Philip Cookson
Linux Administrator
IT Services
ERI Building
Edgbaston
Birmingham
B15 2TT

Tel: 0121 414 4731
Email: p.cook...@bham.ac.uk

___
Spacewalk-list mailing list
Spacewalk-list@redhat.com
https://www.redhat.com/mailman/listinfo/spacewalk-list

Re: [Spacewalk-list] Oracle 12/ 18 Database Support

[Richard]

   Hi Avi,
On Wednesday, April 24, 2019, 9:46:47 PM GMT+1, Avi Miller 
 wrote:  
> Spacewalk works fine with Oracle Database 11, 12, 18 and 19. Our upcoming 
> release of Spacewalk 2.9 is planned to be rebased (for want of a better word) 
> to the Oracle 18c Instant Client as well. 

> In the interim, the 11gR2 Instant Client that is required by the upstream 
> Spacewalk RPMs will connect just fine to newer database versions.

> Let me know if you have any issues.


Just a quick update in case this is of use.  This morning we upgraded our 
database from 11.2.0.4 to Oracle 18.0.6.  We continue to run Spacewalk 2.8, but 
will upgrade to Spacewalk 2.9 shortly.

We had ORACLE_HOME defined in a couple of places which needed adjusting to 
point to the new Oracle release location:

/root/.bash_profile
/etc/sysconfig/osa-dispatcher
/etc/rhn/cluster.ini

After correcting these entries, Spacewalk started successfully.
My DBA tells me we are running in Oracle 11.2.0 compatibility mode (Database 
Upgrade Guide).  Is there any reason we should not move to Oracle 18.6.0 
compatibility ?
Richard.


| 
| 
|  | 
Database Upgrade Guide

If new features are incompatible with your earlier release, then Database 
compatibility can cause issues.
 |

 |

 |




  ___
Spacewalk-list mailing list
Spacewalk-list@redhat.com
https://www.redhat.com/mailman/listinfo/spacewalk-list