[Spacewalk-list] OPENSCAP Audit not working after 2.1 upgrade
Traxler, Jonathan
jonathan.traxler at cubic.com
Mon Jun 2 21:31:33 UTC 2014
Ok got everything working now... changed out profiles and added flags to the command options.
Not sure why I needed the additional flags, but all is well
Thank you everyone who posted suggestions
--Jon
From: Traxler, Jonathan
Sent: Monday, June 02, 2014 11:24 AM
To: 'spacewalk-list at redhat.com'
Subject: RE: OPENSCAP Audit not working after 2.1 upgrade
Just an update
I removed the NON NULL / constraints from IDENTIFIER and TITLE in RHNXCCDPROFILE and my OSCAP scan seems to now be running
I am not sure if there is any negative impact from that...
--Jon
From: Traxler, Jonathan
Sent: Monday, June 02, 2014 10:24 AM
To: 'spacewalk-list at redhat.com'
Subject: RE: OPENSCAP Audit not working after 2.1 upgrade
I have completely reinstalled my spacewalk fresh and even changed to an oracle backend.
I am still having issues posting a SCAP Scan
Both my older install and my fresh install seem to complain about
[Mon Jun 02 09:54:09 2014] [error] SQLError: (1400, 'ORA-01400: cannot insert NULL into ("SPACEWALK"."RHNXCCDFPROFILE"."IDENTIFIER")\\nORA-06512<file:///\\nORA-06512>: at "SPACEWALK.INSERT_XCCDF_PROFILE", line 8\\nORA-06512: at "SPACEWALK.LOOKUP_XCCDF_PROFILE", line 14\\nORA-01403: no data found\\n', "insert into rhnXccdfTestresult( id, server_id, action_scap_id, benchmark_id, profile_id, identifier, start_time, end_time, errors) values ( sequence_nextval('rhn_xccdf_tresult_id_seq'), :server_id, (select ras.id from rhnActionScap ras where ras.action_id = :action_id), lookup_xccdf_benchmark(:bench_id, :bench_version), lookup_xccdf_profile(:profile_id, :profile_title), :identifier, TO_TIMESTAMP(:start_time, 'YYYY-MM-DD HH24:MI:SS'), TO_TIMESTAMP(:end_time, 'YYYY-MM-DD HH24:MI:SS'), empty_blob() ) returning errors into :errors_blob")
[Mon Jun 02 09:54:09 2014] [error]
A NULL in RHNXCCDPROFILE
Do I have to add something to my oscap parameter?
Any help would be greatly appreciated
--Jon
From: Traxler, Jonathan
Sent: Thursday, May 29, 2014 3:28 PM
To: 'spacewalk-list at redhat.com'
Subject: RE: OPENSCAP Audit not working after 2.1 upgrade
Russell-
Double checked the client + server
SELINUX is off
IPTables is off
One note it appears to work on one box and posts fine
[root at ctac-dns-lnx1 ~]# rpm -qa | grep spacewalk
spacewalk-client-repo-2.0-3.el6.noarch
spacewalk-oscap-0.0.22-1.el6.noarch
[root at ctac-dns-lnx1 ~]#
Not working on the box with the following and throws the traceback errors
spacewalk-oscap-0.0.23-1.el6.noarch
spacewalk-client-repo-2.1-2.el6.noarch
One interesting note:
I can run
/usr/bin/oscap xccdf eval --results /tmp/tmpw_qvEX /etc/com.redhat.rhsa-all.xccdf.xml
On both boxes locally and get the same results...
Thanks,
Jon
From: Traxler, Jonathan
Sent: Wednesday, May 28, 2014 3:46 PM
To: 'spacewalk-list at redhat.com'
Subject: RE: OPENSCAP Audit not working after 2.1 upgrade
Little more info any help would be greatly appreciated
Exception reported from cta-spacewalk
Time: Wed May 28 15:36:06 2014
Exception type <type 'exceptions.OverflowError'>
Exception while handling function queue.get
Request object information:
URI: /XMLRPC
Remote Host: ctae-pal2.ventra.local
Server Name: cta-spacewalk.ventra.local:80
Headers passed in:
Accept-Encoding: identity
CONTENT_LENGTH: 2695
CONTENT_TYPE: text/xml
DOCUMENT_ROOT: /var/www/html
GATEWAY_INTERFACE: CGI/1.1
HTTP_ACCEPT_ENCODING: identity
HTTP_HOST: cta-spacewalk.ventra.local
HTTP_USER_AGENT: rhn.rpclib.py/2.5.69-1.el6
HTTP_X_CLIENT_VERSION: 1
HTTP_X_INFO: RPC Processor (C) Red Hat, Inc (version 2.5.69-1.el6)
HTTP_X_RHN_CLIENT_CAPABILITY:
osad.ping(1)=1,scap.xccdf_eval(1)=1,packages.verify(1)=1,packages.extended_profile(2)=1,osad.rhn_check(1)=1,configfiles.base64_enc(1)=1,reboot.reboot(1)=1,configfiles.deploy(1)=1,caneatCheese(1)=1,packages.rollBack(1)=1,configfiles.mtime_upload(1)=1,configfiles.diff(1)=1,packages.update(2)=2,script.run(1)=1,configfiles.upload(1)=1,packages.runTransaction(1)=1,osad.ping(1)=1,scap.xccdf_eval(1)=1,packages.verify(1)=1,packages.extended_profile(2)=1,osad.rhn_check(1)=1,configfiles.base64_enc(1)=1,reboot.reboot(1)=1,configfiles.deploy(1)=1,caneatCheese(1)=1,packages.rollBack(1)=1,configfiles.mtime_upload(1)=1,configfiles.diff(1)=1,packages.update(2)=2,script.run(1)=1,configfiles.upload(1)=1,packages.runTransaction(1)=1
HTTP_X_RHN_TRANSPORT_CAPABILITY: follow-redirects=3
HTTP_X_TRANSPORT_INFO: Extended Capabilities Transport (C) Red Hat, Inc (version
2.5.69-1.el6)
HTTP_X_UP2DATE_VERSION: 2.1.16-1.el6
Host: cta-spacewalk.ventra.local
PATH_INFO:
QUERY_STRING:
REMOTE_ADDR: 192.168.50.59
REMOTE_PORT: 47091
REQUEST_METHOD: POST
REQUEST_URI: /XMLRPC
SCRIPT_FILENAME: /usr/share/rhn/wsgi/xmlrpc.py
SCRIPT_NAME: /XMLRPC
SCRIPT_URI: http://cta-spacewalk.ventra.local/XMLRPC
SCRIPT_URL: /XMLRPC
SERVER_ADDR: 192.168.50.172
SERVER_ADMIN: root at localhost
SERVER_NAME: cta-spacewalk.ventra.local
SERVER_PORT: 80
SERVER_PROTOCOL: HTTP/1.1
SERVER_SIGNATURE: <address>Apache Server at cta-spacewalk.ventra.local Port
80</address>
SERVER_SOFTWARE: Apache
User-Agent: rhn.rpclib.py/2.5.69-1.el6
X-Client-Version: 1
X-Info: RPC Processor (C) Red Hat, Inc (version 2.5.69-1.el6)
X-RHN-Client-Capability:
osad.ping(1)=1,scap.xccdf_eval(1)=1,packages.verify(1)=1,packages.extended_profile(2)=1,osad.rhn_check(1)=1,configfiles.base64_enc(1)=1,reboot.reboot(1)=1,configfiles.deploy(1)=1,caneatCheese(1)=1,packages.rollBack(1)=1,configfiles.mtime_upload(1)=1,configfiles.diff(1)=1,packages.update(2)=2,script.run(1)=1,configfiles.upload(1)=1,packages.runTransaction(1)=1,osad.ping(1)=1,scap.xccdf_eval(1)=1,packages.verify(1)=1,packages.extended_profile(2)=1,osad.rhn_check(1)=1,configfiles.base64_enc(1)=1,reboot.reboot(1)=1,configfiles.deploy(1)=1,caneatCheese(1)=1,packages.rollBack(1)=1,configfiles.mtime_upload(1)=1,configfiles.diff(1)=1,packages.update(2)=2,script.run(1)=1,configfiles.upload(1)=1,packages.runTransaction(1)=1
X-RHN-Transport-Capability: follow-redirects=3
X-Transport-Info: Extended Capabilities Transport (C) Red Hat, Inc (version
2.5.69-1.el6)
X-Up2Date-Version: 2.1.16-1.el6
mod_ssl.is_https: <built-in method ssl_is_https of mod_wsgi.Adapter object at
0x7fda95b59030>
mod_ssl.var_lookup: <built-in method ssl_var_lookup of mod_wsgi.Adapter object at
0x7fda95b59030>
mod_wsgi.application_group: cta-spacewalk.ventra.local|/xmlrpc
mod_wsgi.callable_object: application
mod_wsgi.handler_script:
mod_wsgi.input_chunked: 0
mod_wsgi.listener_host:
mod_wsgi.listener_port: 80
mod_wsgi.process_group:
mod_wsgi.request_handler: wsgi-script
mod_wsgi.script_reloading: 1
mod_wsgi.version: (3, 2)
wsgi.errors: <mod_wsgi.Log object at 0x7fda95905f30>
wsgi.file_wrapper: <built-in method file_wrapper of mod_wsgi.Adapter object at
0x7fda95b59030>
wsgi.input: <mod_wsgi.Input object at 0x7fda95905f70>
wsgi.multiprocess: True
wsgi.multithread: False
wsgi.run_once: False
wsgi.url_scheme: http
wsgi.version: (1, 1)
Exception Handler Information
Traceback (most recent call last):
File "/usr/lib/python2.6/site-packages/spacewalk/server/apacheRequest.py", line
123, in call_function
response = apply(func, params)
File "/usr/share/rhn/server/handlers/xmlrpc/queue.py", line 330, in get
ret = self.__getV2(action)
File "/usr/share/rhn/server/handlers/xmlrpc/queue.py", line 95, in __getV2
xmlblob = xmlrpclib.dumps(result, methodname=action['method'])
File "/usr/lib64/python2.6/xmlrpclib.py", line 1132, in dumps
data = m.dumps(params)
File "/usr/lib64/python2.6/xmlrpclib.py", line 677, in dumps
dump(v, write)
File "/usr/lib64/python2.6/xmlrpclib.py", line 699, in __dump
f(self, value, write)
File "/usr/lib64/python2.6/xmlrpclib.py", line 780, in dump_struct
dump(v, write)
File "/usr/lib64/python2.6/xmlrpclib.py", line 699, in __dump
f(self, value, write)
File "/usr/lib64/python2.6/xmlrpclib.py", line 710, in dump_int
raise OverflowError, "int exceeds XML-RPC limits"
OverflowError: int exceeds XML-RPC limits
Local variables by frame
Frame dump_int in /usr/lib64/python2.6/xmlrpclib.py at line 710
write = <type 'builtin_function_or_method'> <built-in method append
of list object at 0x7fdaaf6a0b90>
self = <type 'instance'> <xmlrpclib.Marshaller instance at
0x7fdaaf633248>
value = <type 'int'> 4097152201
Frame __dump in /usr/lib64/python2.6/xmlrpclib.py at line 699
write = <type 'builtin_function_or_method'> <built-in method append
of list object at 0x7fdaaf6a0b90>
self = <type 'instance'> <xmlrpclib.Marshaller instance at
0x7fdaaf633248>
value = <type 'int'> 4097152201
f = <type 'function'> <function dump_int at 0x7fdaaf08acf8>
Frame dump_struct in /usr/lib64/python2.6/xmlrpclib.py at line 780
dump = <type 'instancemethod'> <bound method Marshaller.__dump of
<xmlrpclib.Marshaller instance at 0x7fdaaf633248>>
i = <type 'int'> 140577222352960
k = <type 'str'> file_size
v = <type 'int'> 4097152201
value = <type 'dict'> {'path': '/etc/com.redhat.rhsa-all.xccdf.xml',
'params': 'Profile id="RHEL6-Default"', 'id': 2392, 'file_size':
4097152201}
write = <type 'builtin_function_or_method'> <built-in method append
of list object at 0x7fdaaf6a0b90>
escape = <type 'function'> <function escape at 0x7fdaaf081a28>
self = <type 'instance'> <xmlrpclib.Marshaller instance at
0x7fdaaf633248>
Frame __dump in /usr/lib64/python2.6/xmlrpclib.py at line 699
write = <type 'builtin_function_or_method'> <built-in method append
of list object at 0x7fdaaf6a0b90>
self = <type 'instance'> <xmlrpclib.Marshaller instance at
0x7fdaaf633248>
value = <type 'dict'> {'path': '/etc/com.redhat.rhsa-all.xccdf.xml',
'params': 'Profile id="RHEL6-Default"', 'id': 2392, 'file_size':
4097152201}
f = <type 'function'> <function dump_struct at 0x7fdaaf08e0c8>
Frame dumps in /usr/lib64/python2.6/xmlrpclib.py at line 677
dump = <type 'instancemethod'> <bound method Marshaller.__dump of
<xmlrpclib.Marshaller instance at 0x7fdaaf633248>>
self = <type 'instance'> <xmlrpclib.Marshaller instance at
0x7fdaaf633248>
write = <type 'builtin_function_or_method'> <built-in method append
of list object at 0x7fdaaf6a0b90>
values = <type 'tuple'> ({'path':
'/etc/com.redhat.rhsa-all.xccdf.xml', 'params': 'Profile
id="RHEL6-Default"', 'id': 2392, 'file_size': 4097152201},)
v = <type 'dict'> {'path': '/etc/com.redhat.rhsa-all.xccdf.xml',
'params': 'Profile id="RHEL6-Default"', 'id': 2392, 'file_size':
4097152201}
out = <type 'list'> ['<params>\n', '<param>\n',
'<value><struct>\n', '<member>\n', '<name>path</name>\n',
'<value><string>', '/etc/com.redhat.rhsa-all.xccdf.xml',
'</string></value>\n', '</member>\n', '<member>\n',
'<name>params</name>\n', '<value><string>', 'Profile
id="RHEL6-Default"', '</string></value>\n', '</member>\n',
'<member>\n', '<name>id</name>\n', '<value><int>', '2392',
'</int></value>\n', '</member>\n', '<member>\n',
'<name>file_size</name>\n']
Frame dumps in /usr/lib64/python2.6/xmlrpclib.py at line 1132
methodname = <type 'str'> scap.xccdf_eval
encoding = <type 'str'> utf-8
m = <type 'instance'> <xmlrpclib.Marshaller instance at
0x7fdaaf633248>
methodresponse = <type 'NoneType'> None
allow_none = <type 'int'> 0
params = <type 'tuple'> ({'path':
'/etc/com.redhat.rhsa-all.xccdf.xml', 'params': 'Profile
id="RHEL6-Default"', 'id': 2392, 'file_size': 4097152201},)
Frame __getV2 in /usr/share/rhn/server/handlers/xmlrpc/queue.py at line 95
action = <type 'dict'> {'id': 2392, 'method': 'scap.xccdf_eval',
'version': 2, 'remaining_tries': 10, 'unlocked_only': 'Y',
'prerequisite': None}
self = <type 'instance'> <server.handlers.xmlrpc.queue.Queue
instance at 0x7fdaaf323e18>
result = <type 'tuple'> ({'path':
'/etc/com.redhat.rhsa-all.xccdf.xml', 'params': 'Profile
id="RHEL6-Default"', 'id': 2392, 'file_size': 4097152201},)
dry_run = <type 'int'> 0
method = <type 'function'> <function xccdf_eval at 0x7fdaaf6abd70>
Frame get in /usr/share/rhn/server/handlers/xmlrpc/queue.py at line 351
status = <type 'dict'> {'uname': ['Linux', 'ctae-pal2',
'2.6.32-431.17.1.el6.x86_64', '#1 SMP Wed May 7 23:32:49 UTC 2014',
'x86_64'], 'uptime': [17483, 34395]}
h = <type 'instance'>
<spacewalk.server.rhnSQL.driver_postgresql.Cursor instance at
0x7fdaaf6332d8>
self = <type 'instance'> <server.handlers.xmlrpc.queue.Queue
instance at 0x7fdaaf323e18>
ret = <type 'dict'> {}
version = <type 'int'> 2
system_id = <type 'str'> <?xml version="1.0"?>
<params>
<param>
<value><struct>
<member>
<name>username</name>
<value><string>admin</string></value>
</member>
<member>
<name>operating_system</name>
<value><string>centos-release</string></value>
</member>
<member>
<name>description</name>
<value><string>Initial Registration Parameters:
OS: centos-release
Release: 6
CPU Arch: x86_64</string></value>
</member>
<member>
<name>checksum</name>
<value><string>ba2e95beeaa6ad6af199d4b351ce0549</string></value>
</member>
<member>
<name>profile_name</name>
<value><string>ctae-pal2</string></value>
</member>
<member>
<name>system_id</name>
<value><string>ID-1000010045</string></value>
</member>
<member>
<name>architecture</name>
<value><string>x86_64</string></value>
</member>
<member>
<name>os_release</name>
<value><string>6</string></value>
</member>
<member>
<name>fields</name>
<value><array><data>
<value><string>system_id</string></value>
<value><string>os_release</string></value>
<value><string>operating_system</string></value>
<value><string>architecture</string></value>
<value><string>username</string></value>
<value><string>type</string></value>
</data></array></value>
</member>
<member>
<name>type</name>
<value><string>REAL</string></value>
</member>
</struct></value>
</param>
</params>
should_execute = <type 'int'> 0
action = <type 'dict'> {'id': 2392, 'method': 'scap.xccdf_eval',
'version': 2, 'remaining_tries': 10, 'unlocked_only': 'Y',
'prerequisite': None}
server_locked = <type 'int'> 0
action_id = <type 'int'> 2392
Frame call_function in
/usr/lib/python2.6/site-packages/spacewalk/server/apacheRequest.py at line 176
e = <type 'exceptions.OverflowError'> int exceeds XML-RPC limits
self = <type 'instance'> <spacewalk.server.apacheRequest.apachePOST
instance at 0x7fda95903050>
force_rollback = <type 'int'> 1
params = <type 'tuple'> ('<?xml
version="1.0"?>\n<params>\n<param>\n<value><struct>\n<member>\n<name>username</name>\n<value><string>admin</string></value>\n</member>\n<member>\n<name>operating_system</name>\n<value><string>centos-release</string></value>\n</member>\n<member>\n<name>description</name>\n<value><string>Initial
Registration Parameters:\nOS: centos-release\nRelease: 6\nCPU Arch:
x86_64</string></value>\n</member>\n<member>\n<name>checksum</name>\n<value><string>ba2e95beeaa6ad6af199d4b351ce0549</string></value>\n</member>\n<member>\n<name>profile_name</name>\n<value><string>ctae-pal2</string></value>\n</member>\n<member>\n<name>system_id</name>\n<value><string>ID-1000010045</string></value>\n</member>\n<member>\n<name>architecture</name>\n<value><string>x86_64</string></value>\n</member>\n<member>\n<name>os_release</name>\n<value><string>6</string></value>\n</member>\n<member>\n<name>fields</name>\n<value><array><data>\n<value><string>system_id</str
ing></value>\n<value><string>os_release</string></value>\n<value><string>operating_system</string></value>\n<value><string>architecture</string></value>\n<value><string>username</string></value>\n<value><string>type</string></value>\n</data></array></value>\n</member>\n<member>\n<name>type</name>\n<value><string>REAL</string></value>\n</member>\n</struct></value>\n</param>\n</params>\n',
2, {'uname': ['Linux', 'ctae-pal2', '2.6.32-431.17.1.el6.x86_64', '#1 SMP Wed May 7
23:32:49 UTC 2014', 'x86_64'], 'uptime': [17483, 34395]})
func = <type 'instancemethod'> <bound method Queue.get of
<server.handlers.xmlrpc.queue.Queue instance at 0x7fdaaf323e18>>
method = <type 'unicode'> queue.get
Frame process in /usr/lib/python2.6/site-packages/spacewalk/server/apacheRequest.py
at line 487
fd = <type 'instance'> <cStringIO.StringO object at 0x7fdaaeef8960>
_body = <type 'str'> <?xml version='1.0'?>
<methodCall>
<methodName>queue.get</methodName>
<params>
<param>
<value><string><?xml version="1.0"?>
<params>
<param>
<value><struct>
<member>
<name>username</name>
<value><string>admin</string></value>
</member>
<member>
<name>operating_system</name>
<value><string>centos-release</string></value>
</member>
<member>
<name>description</name>
<value><string>Initial Registration Parameters:
OS: centos-release
Release: 6
CPU Arch: x86_64</string></value>
</member>
<member>
<name>checksum</name>
<value><string>ba2e95beeaa6ad6af199d4b351ce0549</string></value>
</member>
<member>
<name>profile_name</name>
<value><string>ctae-pal2</string></value>
</member>
<member>
<name>system_id</name>
<value><string>ID-1000010045</string></value>
</member>
<member>
<name>architecture</name>
<value><string>x86_64</string></value>
</member>
<member>
<name>os_release</name>
<value><string>6</string></value>
</member>
<member>
<name>fields</name>
<value><array><data>
<value><string>system_id</string></value>
<value><string>os_release</string></value>
<value><string>operating_system</string></value>
<value><string>architecture</string></value>
<value><string>username</string></value>
<value><string>type</string></value>
</data></array></value>
</member>
<member>
<name>type</name>
<value><string>REAL</string></value>
</member>
</struct></value>
</param>
</params>
</string></value>
</param>
<param>
<value><int>2</int></value>
</param>
<param>
<value><struct>
<member>
<name>uname</name>
<value><array><data>
<value><string>Linux</string></value>
<value><string>ctae-pal2</string></value>
<value><string>2.6.32-431.17.1.el6.x86_64</string></value>
<value><string>#1 SMP Wed May 7 23:32:49 UTC 2014</string></value>
<value><string>x86_64</string></value>
</data></array></value>
</member>
<member>
<name>uptime</name>
<value><array><data>
<value><int>17483</int></value>
<value><int>34395</int></value>
</data></array></value>
</member>
</struct></value>
</param>
</params>
</methodCall>
params = <type 'tuple'> ('<?xml
version="1.0"?>\n<params>\n<param>\n<value><struct>\n<member>\n<name>username</name>\n<value><string>admin</string></value>\n</member>\n<member>\n<name>operating_system</name>\n<value><string>centos-release</string></value>\n</member>\n<member>\n<name>description</name>\n<value><string>Initial
Registration Parameters:\nOS: centos-release\nRelease: 6\nCPU Arch:
x86_64</string></value>\n</member>\n<member>\n<name>checksum</name>\n<value><string>ba2e95beeaa6ad6af199d4b351ce0549</string></value>\n</member>\n<member>\n<name>profile_name</name>\n<value><string>ctae-pal2</string></value>\n</member>\n<member>\n<name>system_id</name>\n<value><string>ID-1000010045</string></value>\n</member>\n<member>\n<name>architecture</name>\n<value><string>x86_64</string></value>\n</member>\n<member>\n<name>os_release</name>\n<value><string>6</string></value>\n</member>\n<member>\n<name>fields</name>\n<value><array><data>\n<value><string>system_id</str
ing></value>\n<value><string>os_release</string></value>\n<value><string>operating_system</string></value>\n<value><string>architecture</string></value>\n<value><string>username</string></value>\n<value><string>type</string></value>\n</data></array></value>\n</member>\n<member>\n<name>type</name>\n<value><string>REAL</string></value>\n</member>\n</struct></value>\n</param>\n</params>\n',
2, {'uname': ['Linux', 'ctae-pal2', '2.6.32-431.17.1.el6.x86_64', '#1 SMP Wed May 7
23:32:49 UTC 2014', 'x86_64'], 'uptime': [17483, 34395]})
method = <type 'unicode'> queue.get
self = <type 'instance'> <spacewalk.server.apacheRequest.apachePOST
instance at 0x7fda95903050>
Frame handler in /usr/lib/python2.6/site-packages/spacewalk/server/apacheHandler.py
at line 196
h = <type 'instance'>
<spacewalk.server.rhnSQL.driver_postgresql.Cursor instance at
0x7fdaaee24050>
self = <type 'instance'>
<spacewalk.server.apacheHandler.apacheHandler instance at
0x7fdaaf15f368>
req = <type 'instance'> <wsgi.wsgiRequest.WsgiRequest instance at
0x7fdaaee17dd0>
ret = <type 'int'> 0
templateStrings = <type 'dict'> {'email_account_info': '\nAccount
Information:\n Your Spacewalk login: <login />\n Your Spacewalk
email address: <email-address />', 'email_footer': '--the Spacewalk Team',
'hostname': 'cta-spacewalk.ventra.local'}
row = <type 'NoneType'> None
Frame handle in /usr/share/rhn/wsgi/wsgiHandler.py at line 45
replacements = <type 'dict'> {'Xml': 'XML', 'Actualuri': 'ActualURI',
'Md5Sum': 'MD5sum', '_': '-', 'Rhn': 'RHN'}
component_type = <type 'str'> server.xmlrpc
start_response = <type 'builtin_function_or_method'> <built-in method
start_response of mod_wsgi.Adapter object at 0x7fda95b59030>
k = <type 'str'> Rhn
req = <type 'instance'> <wsgi.wsgiRequest.WsgiRequest instance at
0x7fdaaee17dd0>
parseServ = <type 'instancemethod'> <bound method
apacheHandler.headerParserHandler of
<spacewalk.server.apacheHandler.apacheHandler instance at
0x7fdaaf15f368>>
ret = <type 'int'> 0
server = <type 'str'> xmlrpc
environ = <type 'dict'> {'mod_wsgi.listener_port': '80',
'mod_ssl.var_lookup': <built-in method ssl_var_lookup of
mod_wsgi.Adapter object at 0x7fda95b59030>, 'X-RHN-Client-Capability':
'osad.ping(1)=1,scap.xccdf_eval(1)=1,packages.verify(1)=1,packages.extended_profile(2)=1,osad.rhn_check(1)=1,configfiles.base64_enc(1)=1,reboot.reboot(1)=1,configfiles.deploy(1)=1,caneatCheese(1)=1,packages.rollBack(1)=1,configfiles.mtime_upload(1)=1,configfiles.diff(1)=1,packages.update(2)=2,script.run(1)=1,configfiles.upload(1)=1,packages.runTransaction(1)=1,osad.ping(1)=1,scap.xccdf_eval(1)=1,packages.verify(1)=1,packages.extended_profile(2)=1,osad.rhn_check(1)=1,configfiles.base64_enc(1)=1,reboot.reboot(1)=1,configfiles.deploy(1)=1,caneatCheese(1)=1,packages.rollBack(1)=1,configfiles.mtime_upload(1)=1,configfiles.diff(1)=1,packages.update(2)=2,script.run(1)=1,configfiles.upload(1)=1,packages.runTransaction(1)=1',
'SERVER_SOFTWARE': 'Apache', 'SCRIPT_NAME': '/XMLRPC', 'HTTP_X_T
RANSPORT_INFO': 'Extended Capabilities Transport (C) Red Hat, Inc (version
2.5.69-1.el6)', 'mod_wsgi.handler_script': '', 'SERVER_SIGNATURE': '<address>Apache
Server at cta-spacewalk.ventra.local Port 80</address>\n', 'REQUEST_METHOD':
'POST', 'PATH_INFO': '', 'SERVER_PROTOCOL': 'HTTP/1.1', 'QUERY_STRING': '',
'X-Info': 'RPC Processor (C) Red Hat, Inc (version 2.5.69-1.el6)',
'CONTENT_LENGTH': '2695', 'HTTP_USER_AGENT': 'rhn.rpclib.py/2.5.69-1.el6',
'HTTP_X_UP2DATE_VERSION': '2.1.16-1.el6', 'SERVER_NAME':
'cta-spacewalk.ventra.local', 'REMOTE_ADDR': '192.168.50.59',
'mod_wsgi.request_handler': 'wsgi-script', 'User-Agent':
'rhn.rpclib.py/2.5.69-1.el6', 'wsgi.url_scheme': 'http', 'Host':
'cta-spacewalk.ventra.local', 'X-RHN-Transport-Capability': 'follow-redirects=3',
'mod_wsgi.callable_object': 'application', 'SERVER_PORT': '80',
'wsgi.multiprocess': True, 'mod_wsgi.input_chunked': '0', 'SERVER_ADDR':
'192.168.50.172', 'DOCUMENT_ROOT': '/var/www/html', 'mod_wsgi.process_group
': '', 'Accept-Encoding': 'identity', 'HTTP_X_RHN_CLIENT_CAPABILITY':
'osad.ping(1)=1,scap.xccdf_eval(1)=1,packages.verify(1)=1,packages.extended_profile(2)=1,osad.rhn_check(1)=1,configfiles.base64_enc(1)=1,reboot.reboot(1)=1,configfiles.deploy(1)=1,caneatCheese(1)=1,packages.rollBack(1)=1,configfiles.mtime_upload(1)=1,configfiles.diff(1)=1,packages.update(2)=2,script.run(1)=1,configfiles.upload(1)=1,packages.runTransaction(1)=1,osad.ping(1)=1,scap.xccdf_eval(1)=1,packages.verify(1)=1,packages.extended_profile(2)=1,osad.rhn_check(1)=1,configfiles.base64_enc(1)=1,reboot.reboot(1)=1,configfiles.deploy(1)=1,caneatCheese(1)=1,packages.rollBack(1)=1,configfiles.mtime_upload(1)=1,configfiles.diff(1)=1,packages.update(2)=2,script.run(1)=1,configfiles.upload(1)=1,packages.runTransaction(1)=1',
'SCRIPT_FILENAME': '/usr/share/rhn/wsgi/xmlrpc.py', 'SERVER_ADMIN':
'root at localhost', 'X-Up2Date-Version': '2.1.16-1.el6', 'X-Transport-Info':
'Extended Capabilities Transport (C) Red Hat, Inc
(version 2.5.69-1.el6)', 'SCRIPT_URI': 'http://cta-spacewalk.ventra.local/XMLRPC'<http://cta-spacewalk.ventra.local/XMLRPC%27>,
'HTTP_X_CLIENT_VERSION': '1', 'wsgi.input': <mod_wsgi.Input object at
0x7fda95905f70>, 'HTTP_HOST': 'cta-spacewalk.ventra.local', 'SCRIPT_URL':
'/XMLRPC', 'wsgi.multithread': False, 'REQUEST_URI': '/XMLRPC',
'X-Client-Version': '1', 'wsgi.version': (1, 1), 'GATEWAY_INTERFACE': 'CGI/1.1',
'wsgi.run_once': False, 'wsgi.errors': <mod_wsgi.Log object at 0x7fda95905f30>,
'REMOTE_PORT': '47091', 'mod_wsgi.listener_host': '', 'mod_wsgi.version': (3, 2),
'HTTP_X_RHN_TRANSPORT_CAPABILITY': 'follow-redirects=3', 'mod_ssl.is_https':
<built-in method ssl_is_https of mod_wsgi.Adapter object at 0x7fda95b59030>,
'CONTENT_TYPE': 'text/xml', 'mod_wsgi.application_group':
'cta-spacewalk.ventra.local|/xmlrpc', 'mod_wsgi.script_reloading': '1',
'wsgi.file_wrapper': <built-in method file_wrapper of mod_wsgi.Adapter object at
0x7fda95b59030>, 'HTTP_ACCEPT_ENCODING': 'identity', 'HTTP_X_INFO': 'RPC Processor
(C) Re
d Hat, Inc (version 2.5.69-1.el6)'}
key = <type 'str'> HTTP_X_INFO
v = <type 'str'> RHN
servertype = <type 'str'> spacewalk.server.apacheServer
new_key = <type 'str'> X-Info
appServ = <type 'instancemethod'> <bound method apacheHandler.handler
of <spacewalk.server.apacheHandler.apacheHandler instance at
0x7fdaaf15f368>>
Frame application in /usr/share/rhn/wsgi/xmlrpc.py at line 22
start_response = <type 'builtin_function_or_method'> <built-in method
start_response of mod_wsgi.Adapter object at 0x7fda95b59030>
environ = <type 'dict'> {'mod_wsgi.listener_port': '80',
'mod_ssl.var_lookup': <built-in method ssl_var_lookup of
mod_wsgi.Adapter object at 0x7fda95b59030>, 'X-RHN-Client-Capability':
'osad.ping(1)=1,scap.xccdf_eval(1)=1,packages.verify(1)=1,packages.extended_profile(2)=1,osad.rhn_check(1)=1,configfiles.base64_enc(1)=1,reboot.reboot(1)=1,configfiles.deploy(1)=1,caneatCheese(1)=1,packages.rollBack(1)=1,configfiles.mtime_upload(1)=1,configfiles.diff(1)=1,packages.update(2)=2,script.run(1)=1,configfiles.upload(1)=1,packages.runTransaction(1)=1,osad.ping(1)=1,scap.xccdf_eval(1)=1,packages.verify(1)=1,packages.extended_profile(2)=1,osad.rhn_check(1)=1,configfiles.base64_enc(1)=1,reboot.reboot(1)=1,configfiles.deploy(1)=1,caneatCheese(1)=1,packages.rollBack(1)=1,configfiles.mtime_upload(1)=1,configfiles.diff(1)=1,packages.update(2)=2,script.run(1)=1,configfiles.upload(1)=1,packages.runTransaction(1)=1',
'SERVER_SOFTWARE': 'Apache', 'SCRIPT_NAME': '/XMLRPC', 'HTTP_X_T
RANSPORT_INFO': 'Extended Capabilities Transport (C) Red Hat, Inc (version
2.5.69-1.el6)', 'mod_wsgi.handler_script': '', 'SERVER_SIGNATURE': '<address>Apache
Server at cta-spacewalk.ventra.local Port 80</address>\n', 'REQUEST_METHOD':
'POST', 'PATH_INFO': '', 'SERVER_PROTOCOL': 'HTTP/1.1', 'QUERY_STRING': '',
'X-Info': 'RPC Processor (C) Red Hat, Inc (version 2.5.69-1.el6)',
'CONTENT_LENGTH': '2695', 'HTTP_USER_AGENT': 'rhn.rpclib.py/2.5.69-1.el6',
'HTTP_X_UP2DATE_VERSION': '2.1.16-1.el6', 'SERVER_NAME':
'cta-spacewalk.ventra.local', 'REMOTE_ADDR': '192.168.50.59',
'mod_wsgi.request_handler': 'wsgi-script', 'User-Agent':
'rhn.rpclib.py/2.5.69-1.el6', 'wsgi.url_scheme': 'http', 'Host':
'cta-spacewalk.ventra.local', 'X-RHN-Transport-Capability': 'follow-redirects=3',
'mod_wsgi.callable_object': 'application', 'SERVER_PORT': '80',
'wsgi.multiprocess': True, 'mod_wsgi.input_chunked': '0', 'SERVER_ADDR':
'192.168.50.172', 'DOCUMENT_ROOT': '/var/www/html', 'mod_wsgi.process_group
': '', 'Accept-Encoding': 'identity', 'HTTP_X_RHN_CLIENT_CAPABILITY':
'osad.ping(1)=1,scap.xccdf_eval(1)=1,packages.verify(1)=1,packages.extended_profile(2)=1,osad.rhn_check(1)=1,configfiles.base64_enc(1)=1,reboot.reboot(1)=1,configfiles.deploy(1)=1,caneatCheese(1)=1,packages.rollBack(1)=1,configfiles.mtime_upload(1)=1,configfiles.diff(1)=1,packages.update(2)=2,script.run(1)=1,configfiles.upload(1)=1,packages.runTransaction(1)=1,osad.ping(1)=1,scap.xccdf_eval(1)=1,packages.verify(1)=1,packages.extended_profile(2)=1,osad.rhn_check(1)=1,configfiles.base64_enc(1)=1,reboot.reboot(1)=1,configfiles.deploy(1)=1,caneatCheese(1)=1,packages.rollBack(1)=1,configfiles.mtime_upload(1)=1,configfiles.diff(1)=1,packages.update(2)=2,script.run(1)=1,configfiles.upload(1)=1,packages.runTransaction(1)=1',
'SCRIPT_FILENAME': '/usr/share/rhn/wsgi/xmlrpc.py', 'SERVER_ADMIN':
'root at localhost', 'X-Up2Date-Version': '2.1.16-1.el6', 'X-Transport-Info':
'Extended Capabilities Transport (C) Red Hat, Inc
(version 2.5.69-1.el6)', 'SCRIPT_URI': 'http://cta-spacewalk.ventra.local/XMLRPC'<http://cta-spacewalk.ventra.local/XMLRPC%27>,
'HTTP_X_CLIENT_VERSION': '1', 'wsgi.input': <mod_wsgi.Input object at
0x7fda95905f70>, 'HTTP_HOST': 'cta-spacewalk.ventra.local', 'SCRIPT_URL':
'/XMLRPC', 'wsgi.multithread': False, 'REQUEST_URI': '/XMLRPC',
'X-Client-Version': '1', 'wsgi.version': (1, 1), 'GATEWAY_INTERFACE': 'CGI/1.1',
'wsgi.run_once': False, 'wsgi.errors': <mod_wsgi.Log object at 0x7fda95905f30>,
'REMOTE_PORT': '47091', 'mod_wsgi.listener_host': '', 'mod_wsgi.version': (3, 2),
'HTTP_X_RHN_TRANSPORT_CAPABILITY': 'follow-redirects=3', 'mod_ssl.is_https':
<built-in method ssl_is_https of mod_wsgi.Adapter object at 0x7fda95b59030>,
'CONTENT_TYPE': 'text/xml', 'mod_wsgi.application_group':
'cta-spacewalk.ventra.local|/xmlrpc', 'mod_wsgi.script_reloading': '1',
'wsgi.file_wrapper': <built-in method file_wrapper of mod_wsgi.Adapter object at
0x7fda95b59030>, 'HTTP_ACCEPT_ENCODING': 'identity', 'HTTP_X_INFO': 'RPC Processor
(C) Re
d Hat, Inc (version 2.5.69-1.el6)'}
Environment for PID=2332 on exception:
CONSOLETYPE = vt
LANG = C
LANGSH_SOURCED = 1
PATH = /sbin:/usr/sbin:/bin:/usr/bin
PREVLEVEL = N
PWD = /
RUNLEVEL = 3
SHLVL = 3
TERM = linux
UPSTART_EVENTS = runlevel
UPSTART_INSTANCE =
UPSTART_JOB = rc
_ = /usr/sbin/httpd
previous = N
runlevel = 3
From: Traxler, Jonathan
Sent: Wednesday, May 28, 2014 9:16 AM
To: 'spacewalk-list at redhat.com'
Subject: OPENSCAP Audit not working after 2.1 upgrade
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\\<file:///\\'at_conn\>', $1 , true)"\\nPL/pgSQL function <file:///\\nPL\pgSQL%20function%20> "pg_dbl
ink_exec" line 7 at PERFORM\\nSQL statement "SELECT pg_dblink_exec( \\'insert<file:///\\'insert> i
nto rhnXccdfProfile (id, identifier, title) values (\\' || $1 || \\', \\' || c
oalesce(quote_literal( $2 ), \\'NULL\\<file:///\\'NULL\>') || \\', \\' || coalesce(quote_literal(
$3 ), \\'NULL\\<file:///\\'NULL\>') || \\')\\' )"\\nPL/pgSQL function <file:///\\nPL\pgSQL%20function%20> "lookup_xccdf_profile" line
12 at PERFORM\\n',))
[Cubic Transportation Systems]<http://cts.cubic.com/>
Jonathan Traxler
Sr. Systems Administrator
Cubic Transportation Systems, Inc.
Phone: +1 858 598 1122
Mobile: +1 858 774 6819
cts.cubic.com<http://cts.cubic.com/>
[NextCity]<http://www.youtube.com/watch?v=qhd6XYP2DBE&feature=related>
[RSS]<http://cts.cubic.com/Publications/CubicBlog.aspx>
[Facebook]<https://www.facebook.com/CubicTransportationSystems>
[Twitter]<https://twitter.com/CubicTS>
[LinkedIn]<http://www.linkedin.com/company/cubic>
[YouTube]<http://www.youtube.com/user/CubicTS>
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
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://listman.redhat.com/archives/spacewalk-list/attachments/20140602/09ebd0f9/attachment.htm>
-------------- next part --------------
A non-text attachment was scrubbed...
Name: image001.png
Type: image/png
Size: 19863 bytes
Desc: image001.png
URL: <http://listman.redhat.com/archives/spacewalk-list/attachments/20140602/09ebd0f9/attachment.png>
-------------- next part --------------
A non-text attachment was scrubbed...
Name: image002.png
Type: image/png
Size: 3309 bytes
Desc: image002.png
URL: <http://listman.redhat.com/archives/spacewalk-list/attachments/20140602/09ebd0f9/attachment-0001.png>
-------------- next part --------------
A non-text attachment was scrubbed...
Name: image003.png
Type: image/png
Size: 933 bytes
Desc: image003.png
URL: <http://listman.redhat.com/archives/spacewalk-list/attachments/20140602/09ebd0f9/attachment-0002.png>
-------------- next part --------------
A non-text attachment was scrubbed...
Name: image004.png
Type: image/png
Size: 747 bytes
Desc: image004.png
URL: <http://listman.redhat.com/archives/spacewalk-list/attachments/20140602/09ebd0f9/attachment-0003.png>
-------------- next part --------------
A non-text attachment was scrubbed...
Name: image005.png
Type: image/png
Size: 741 bytes
Desc: image005.png
URL: <http://listman.redhat.com/archives/spacewalk-list/attachments/20140602/09ebd0f9/attachment-0004.png>
-------------- next part --------------
A non-text attachment was scrubbed...
Name: image006.png
Type: image/png
Size: 819 bytes
Desc: image006.png
URL: <http://listman.redhat.com/archives/spacewalk-list/attachments/20140602/09ebd0f9/attachment-0005.png>
-------------- next part --------------
A non-text attachment was scrubbed...
Name: image007.png
Type: image/png
Size: 982 bytes
Desc: image007.png
URL: <http://listman.redhat.com/archives/spacewalk-list/attachments/20140602/09ebd0f9/attachment-0006.png>
More information about the Spacewalk-list
mailing list