[Spacewalk-list] OPENSCAP Audit not working after 2.1 upgrade

[Russell Duma]

You might also want to check iptables too.


Russell Duma 
IT Infrastructure Technical Lead | Retail Services
David Jones Limited
Level 9, 65 - 77 Market Street
Sydney, NSW 2000
Phone:9266-6995
Email:rduma at davidjones.com.au
http://www.davidjones.com.au/





From:   "Traxler, Jonathan" <jonathan.traxler at cubic.com>
To:     "spacewalk-list at redhat.com" <spacewalk-list at redhat.com>
Date:   29/05/2014 12:20 AM
Subject:        [Spacewalk-list] OPENSCAP Audit not working after 2.1 
upgrade
Sent by:        spacewalk-list-bounces at redhat.com



I have been using the openscap for scans, however now when I try to run 
them after upgrading to 2.1 I see the following error in the log 
 
Any ideas?  Did I miss something in the upgrade process?  Anyone running 
OPENSCAP scans with 2.1 successfully?
 
[Mon May 19 17:32:41 2014] [error] CONTEXT:  Error occurred on dblink 
connection
named "at_conn": could not execute command.
[Mon May 19 17:32:41 2014] [error] SQL statement "SELECT 
dblink_exec('at_conn',
  $1 , true)"
[Mon May 19 17:32:41 2014] [error] PL/pgSQL function "pg_dblink_exec" line 
7 at
PERFORM
[Mon May 19 17:32:41 2014] [error] SQL statement "SELECT  pg_dblink_exec( 
'inser
t into rhnXccdfProfile (id, identifier, title) values (' ||  $1  || ', ' 
|| coal
esce(quote_literal( $2 ), 'NULL') || ', ' || coalesce(quote_literal( $3 ), 
'NULL
') || ')' )"
[Mon May 19 17:32:41 2014] [error] PL/pgSQL function 
"lookup_xccdf_profile" line
12 at PERFORM
[Mon May 19 17:32:41 2014] [error]
[Mon May 19 17:32:41 2014] [error]
[Mon May 19 17:32:46 2014] [error] Spacewalk 13851 2014/05/19 17:32:46 
-05:00: (
'Unhandled exception', IntegrityError('new row for relation 
"rhnxccdfprofile" vi
olates check constraint "vn_rhnxccdfprofile_identifier"\\nCONTEXT:  Error 
occurr
ed on dblink connection named "at_conn": could not execute command.\\nSQL 
statem
ent "SELECT  dblink_exec(\\'at_conn\\',  $1 , true)"\\nPL/pgSQL function 
"pg_dbl
ink_exec" line 7 at PERFORM\\nSQL statement "SELECT  pg_dblink_exec( 
\\'insert i
nto rhnXccdfProfile (id, identifier, title) values (\\' ||  $1  || \\', 
\\' || c
oalesce(quote_literal( $2 ), \\'NULL\\') || \\', \\' || 
coalesce(quote_literal(
$3 ), \\'NULL\\') || \\')\\' )"\\nPL/pgSQL function "lookup_xccdf_profile" 
line
12 at PERFORM\\n',))
 
 


Jonathan Traxler
Sr. Systems Administrator
Cubic Transportation Systems, Inc.
Phone: +1 858 598 1122
Mobile: +1 858 774 6819
cts.cubic.com









 

Winner of the Best Smartcard Ticketing Service,
MasterCard Transport Ticketing Awards 2014
Winner, 2014 Australian Smart Infrastructure Award, Opal Card
Winner, Product Design, BritWeek Innovation Award 2014
 _______________________________________________
Spacewalk-list mailing list
Spacewalk-list at redhat.com
https://www.redhat.com/mailman/listinfo/spacewalk-list

-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://listman.redhat.com/archives/spacewalk-list/attachments/20140529/6324c6a6/attachment.htm>
-------------- next part --------------
A non-text attachment was scrubbed...
Name: not available
Type: image/png
Size: 19863 bytes
Desc: not available
URL: <http://listman.redhat.com/archives/spacewalk-list/attachments/20140529/6324c6a6/attachment.png>
-------------- next part --------------
A non-text attachment was scrubbed...
Name: not available
Type: image/png
Size: 3309 bytes
Desc: not available
URL: <http://listman.redhat.com/archives/spacewalk-list/attachments/20140529/6324c6a6/attachment-0001.png>
-------------- next part --------------
A non-text attachment was scrubbed...
Name: not available
Type: image/png
Size: 933 bytes
Desc: not available
URL: <http://listman.redhat.com/archives/spacewalk-list/attachments/20140529/6324c6a6/attachment-0002.png>
-------------- next part --------------
A non-text attachment was scrubbed...
Name: not available
Type: image/png
Size: 747 bytes
Desc: not available
URL: <http://listman.redhat.com/archives/spacewalk-list/attachments/20140529/6324c6a6/attachment-0003.png>
-------------- next part --------------
A non-text attachment was scrubbed...
Name: not available
Type: image/png
Size: 741 bytes
Desc: not available
URL: <http://listman.redhat.com/archives/spacewalk-list/attachments/20140529/6324c6a6/attachment-0004.png>
-------------- next part --------------
A non-text attachment was scrubbed...
Name: not available
Type: image/png
Size: 819 bytes
Desc: not available
URL: <http://listman.redhat.com/archives/spacewalk-list/attachments/20140529/6324c6a6/attachment-0005.png>
-------------- next part --------------
A non-text attachment was scrubbed...
Name: not available
Type: image/png
Size: 982 bytes
Desc: not available
URL: <http://listman.redhat.com/archives/spacewalk-list/attachments/20140529/6324c6a6/attachment-0006.png>