Oracle Linux

[scottcupit]

I have a couple of Oracle Linux servers, version 5 & 6. Not sure if this is a supported OS.

Version 5.11
vFense has records for installed software, but does list updates that need to be installed. I have tried refreshing apps, but it never lists updates that are needed, though the agent runs the yum makecache process.

Version 6.6
vFense can install some packages on version 6, but not all of them. For several packages, it reports "File is missing uri." Screenshot attached. It does list all updates needed. These packages must be installed manually.

[linuxdynasty]

So this issue, is due to the fact that the download uri is not being sent properly from the agent to the server. Please check the agent logs and see if you can see any error/exception that relates to that.

Also on both agents, what does it return when you run the following in python.

>>> import platform
>>> platform.dist()
('Ubuntu', '14.04', 'trusty')

[scottcupit]

Thanks for your quick response!

This error is in the both sets of agent logs repeatedly:
DEBUG : 11/20/2014 12:00:00 AM : Added result / 50cb9c8b-e55f-44cd-abe7-09ee6a5d6cdd-agent to OpQueue.
DEBUG : 11/20/2014 12:00:00 AM : Sending message to server
DEBUG : 11/20/2014 12:00:00 AM : https://vfense.mellmo.lan/rvl/v1/a067e571-b329-4056-acef-46fbb99082e1/rv/results/install/apps/os
DEBUG : 11/20/2014 12:00:00 AM : Logging into server
DEBUG : 11/20/2014 12:00:00 AM : Login status code: 200
DEBUG : 11/20/2014 12:00:00 AM : Login server text:
DEBUG : 11/20/2014 12:00:00 AM : Url: https://vfense.mellmo.lan/rvl/v1/a067e571-b329-4056-acef-46fbb99082e1/rv/results/install/apps/os
DEBUG : 11/20/2014 12:00:00 AM : Status code: 404
DEBUG : 11/20/2014 12:00:00 AM : Server text: {
"invalid_id": "",
"uri": "/rvl/v1/a067e571-b329-4056-acef-46fbb99082e1/rv/results/install/apps/os",
"rv_status_code": 3303,
"http_method": "PUT",
"http_status": 404,
"message": "Invalid operation id",
"data": []
}

Here is the platform command output for Oracle Linux 5:
[root@resolinux5 logs]# python
Python 2.4.3 (#1, Jan 9 2013, 01:38:41)
[GCC 4.1.2 20080704 (Red Hat 4.1.2-54)] on linux2
Type "help", "copyright", "credits" or "license" for more information.

import platform
platform.dist()
('redhat', '5.11', 'Tikanga')

Here is the platform command output for Oracle Linux 6:
[root@resolinux6 logs]# python
Python 2.6.6 (r266:84292, Jan 22 2014, 01:49:05)
[GCC 4.4.7 20120313 (Red Hat 4.4.7-4)] on linux2
Type "help", "copyright", "credits" or "license" for more information.

import platform
platform.dist()
('redhat', '6.6', 'Santiago')

[linuxdynasty]

Thanks, now what is in the server logs, for the same time. Cause I see invalid operation id, which means the operation_id being sent back with the results is not a valid in the database.

[scottcupit]

Here are the logs from the server at that time.

rvapi_file.log:
^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^
2014-11-20 00:00:00 - rvapi - ERROR - Cannot perform merge on a non-object non-sequence null. in:
r.table('unique_applications').get(u'').merge(lambda var_723626: r.expr({'release_date': r.row['release_date'].to_epoch_time()}))
^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^
Traceback (most recent call last):
File "/usr/local/lib/python2.7/dist-packages/vFense/plugins/patching/_db.py", line 95, in fetch_app_data
.run(conn)
File "/usr/local/lib/python2.7/dist-packages/rethinkdb/ast.py", line 95, in run
return c._start(self, **global_optargs)
File "/usr/local/lib/python2.7/dist-packages/rethinkdb/net.py", line 238, in _start
return self._send_query(query, global_optargs)
File "/usr/local/lib/python2.7/dist-packages/rethinkdb/net.py", line 339, in _send_query
self._check_error_response(response, query.term)
File "/usr/local/lib/python2.7/dist-packages/rethinkdb/net.py", line 312, in _check_error_response
raise RqlRuntimeError(message, term, frames)
RqlRuntimeError: Cannot perform merge on a non-object non-sequence null. in:
r.table('unique_applications').get(u'').merge(lambda var_723626: r.expr({'release_date': r.row['release_date'].to_epoch_time()}))

rvlist_file.log:
2014-11-20 00:00:00 - rvlistener - INFO - {"apps_to_add": [], "success": "false", "error": "No updates found.", "operation_id": "353bf578-857a-4308-9dfd-bfe5d87085ae", "operation": "install_os_apps", "apps_to_delete": [], "app_id": "", "reboot_required": "false", "data": {"status": "", "description": "", "reboot_required": "no", "repo": "", "dependencies": [], "kb": "", "name": "", "support_url": "", "release_date": "", "vendor_severity": "", "install_date": "", "uninstallable": "yes", "file_data": [], "version": "", "vendor_name": ""}}
2014-11-20 00:00:00 - rvlistener - INFO - {'uri': '/rvl/v1/aef6c6cf-b2cd-4843-93c9-a35aa56aab8f/core/checkin', 'rv_status_code': 3003, 'http_method': 'GET', 'http_status': 200, 'message': u'admin - checkin succeeded for agent_id aef6c6cf-b2cd-4843-93c9-a35aa56aab8f', 'data': []}
2014-11-20 00:00:01 - rvlistener - INFO - {'uri': '/rvl/v1/269f2bc4-348a-4d8d-8c27-0910f4bde7e9/core/checkin', 'rv_status_code': 3003, 'http_method': 'GET', 'http_status': 200, 'message': u'admin - checkin succeeded for agent_id 269f2bc4-348a-4d8d-8c27-0910f4bde7e9', 'data': []}
2014-11-20 00:00:01 - rvlistener - INFO - {"apps_to_add": [], "success": "false", "error": "No updates found.", "operation_id": "4fed145b-2221-4700-a5fb-d3e72754edb1", "operation": "install_os_apps", "apps_to_delete": [], "app_id": "", "reboot_required": "false", "data": {"status": "", "description": "", "reboot_required": "no", "repo": "", "dependencies": [], "kb": "", "name": "", "support_url": "", "release_date": "", "vendor_severity": "", "install_date": "", "uninstallable": "yes", "file_data": [], "version": "", "vendor_name": ""}}
2014-11-20 00:00:01 - rvlistener - INFO - {"apps_to_add": [], "success": "false", "error": "No updates found.", "operation_id": "6070a2ad-a5ba-465e-b574-4a611288c4aa", "operation": "install_os_apps", "apps_to_delete": [], "app_id": "", "reboot_required": "false", "data": {"status": "", "description": "", "reboot_required": "no", "repo": "", "dependencies": [], "kb": "", "name": "", "support_url": "", "release_date": "", "vendor_severity": "", "install_date": "", "uninstallable": "yes", "file_data": [], "version": "", "vendor_name": ""}}
2014-11-20 00:00:01 - rvlistener - INFO - {"apps_to_add": [], "success": "false", "error": "No updates found.", "operation_id": "2ca4e176-3ec9-4dba-b9cd-7e6724ffb190", "operation": "install_os_apps", "apps_to_delete": [], "app_id": "", "reboot_required": "false", "data": {"status": "", "description": "", "reboot_required": "no", "repo": "", "dependencies": [], "kb": "", "name": "", "support_url": "", "release_date": "", "vendor_severity": "", "install_date": "", "uninstallable": "yes", "file_data": [], "version": "", "vendor_name": ""}}
2014-11-20 00:00:02 - rvlistener - INFO - {"apps_to_add": [], "success": "false", "error": "No updates found.", "operation_id": "0c809471-b5d6-4ad6-aeb1-8f0be0f7491b", "operation": "install_os_apps", "apps_to_delete": [], "app_id": "", "reboot_required": "false", "data": {"status": "", "description": "", "reboot_required": "no", "repo": "", "dependencies": [], "kb": "", "name": "", "support_url": "", "release_date": "", "vendor_severity": "", "install_date": "", "uninstallable": "yes", "file_data": [], "version": "", "vendor_name": ""}}
2014-11-20 00:00:02 - rvlistener - INFO - {"apps_to_add": [], "success": "false", "error": "No updates found.", "operation_id": "4fed145b-2221-4700-a5fb-d3e72754edb1", "operation": "install_os_apps", "apps_to_delete": [], "app_id": "", "reboot_required": "false", "data": {"status": "", "description": "", "reboot_required": "no", "repo": "", "dependencies": [], "kb": "", "name": "", "support_url": "", "release_date": "", "vendor_severity": "", "install_date": "", "uninstallable": "yes", "file_data": [], "version": "", "vendor_name": ""}}
2014-11-20 00:00:02 - rvlistener - INFO - {'uri': '/rvl/v1/83b4835a-42c8-4952-9312-cc971c28c8bd/core/checkin', 'rv_status_code': 3003, 'http_method': 'GET', 'http_status': 200, 'message': u'admin - checkin succeeded for agent_id 83b4835a-42c8-4952-9312-cc971c28c8bd', 'data': []}

rvweb_file.log:
2014-11-20 00:00:00 - rvweb - INFO - 200 POST /rvl/login (127.0.0.1) 10.1.210.55 10.1.210.55 python-requests/1.2.3 CPython/2.7.3 Linux/3.2.0-69-generic, 259.69ms
2014-11-20 00:00:00 - rvweb - ERROR - 404 PUT /rvl/v1/1046ba26-ed9e-46c9-9392-575ecbb7714c/rv/results/install/apps/os (127.0.0.1) 10.1.210.55 10.1.210.55 python-requests/1.2.3 CPython/2.7.3 Linux/3.2.0-69-generic, 14.07ms
2014-11-20 00:00:00 - rvweb - INFO - 200 POST /rvl/login (127.0.0.1) 10.1.20.147 10.1.20.147 python-requests/1.2.3 CPython/2.7.5 Linux/2.6.32-400.36.11.el6uek.x86_64, 251.27ms
2014-11-20 00:00:00 - rvweb - INFO - 200 GET /rvl/v1/aef6c6cf-b2cd-4843-93c9-a35aa56aab8f/core/checkin (127.0.0.1) 10.1.20.147 10.1.20.147 python-requests/1.2.3 CPython/2.7.5 Linux/2.6.32-400.36.11.el6uek.x86_64, 14.91ms
2014-11-20 00:00:01 - rvweb - INFO - 200 POST /rvl/login (127.0.0.1) 10.1.20.162 10.1.20.162 python-requests/1.2.3 CPython/2.7.3 Linux/3.2.0-35-generic, 264.48ms
2014-11-20 00:00:01 - rvweb - INFO - 200 GET /rvl/v1/269f2bc4-348a-4d8d-8c27-0910f4bde7e9/core/checkin (127.0.0.1) 10.1.20.162 10.1.20.162 python-requests/1.2.3 CPython/2.7.3 Linux/3.2.0-35-generic, 11.11ms
2014-11-20 00:00:01 - rvweb - INFO - 200 POST /rvl/login (127.0.0.1) 10.1.10.93 10.1.10.93 python-requests/1.2.3 CPython/2.7.3 Linux/3.2.0-54-generic, 253.26ms
2014-11-20 00:00:01 - rvweb - ERROR - 404 PUT /rvl/v1/0e5ab06e-f99c-4219-a062-8009a818ca34/rv/results/install/apps/os (127.0.0.1) 10.1.10.93 10.1.10.93 python-requests/1.2.3 CPython/2.7.3 Linux/3.2.0-54-generic, 14.37ms
2014-11-20 00:00:01 - rvweb - INFO - 200 POST /rvl/login (127.0.0.1) 10.1.20.166 10.1.20.166 python-requests/1.2.3 CPython/2.7.5 Linux/2.6.32-220.23.1.el6.x86_64, 256.17ms
2014-11-20 00:00:01 - rvweb - ERROR - 404 PUT /rvl/v1/6053320b-7874-4f16-a265-62d3bacf83a5/rv/results/install/apps/os (127.0.0.1) 10.1.20.166 10.1.20.166 python-requests/1.2.3 CPython/2.7.5 Linux/2.6.32-220.23.1.el6.x86_64, 18.00ms
2014-11-20 00:00:01 - rvweb - INFO - 200 POST /rvl/login (127.0.0.1) 10.1.20.180 10.1.20.180 python-requests/1.2.3 CPython/2.7.3 Linux/3.2.0-58-generic, 277.98ms
2014-11-20 00:00:01 - rvweb - ERROR - 404 PUT /rvl/v1/2a6c766c-ccb2-491c-a70c-36997dad822d/rv/results/install/apps/os (127.0.0.1) 10.1.20.180 10.1.20.180 python-requests/1.2.3 CPython/2.7.3 Linux/3.2.0-58-generic, 21.15ms
2014-11-20 00:00:02 - rvweb - INFO - 200 POST /rvl/login (127.0.0.1) 10.1.20.180 10.1.20.180 python-requests/1.2.3 CPython/2.7.3 Linux/3.2.0-58-generic, 262.19ms
2014-11-20 00:00:02 - rvweb - INFO - 200 POST /rvl/login (127.0.0.1) 10.1.10.98 10.1.10.98 python-requests/1.2.3 CPython/2.7.3 Linux/3.2.0-60-generic, 265.24ms
2014-11-20 00:00:02 - rvweb - ERROR - 404 PUT /rvl/v1/2a6c766c-ccb2-491c-a70c-36997dad822d/rv/results/install/apps/os (127.0.0.1) 10.1.20.180 10.1.20.180 python-requests/1.2.3 CPython/2.7.3 Linux/3.2.0-58-generic, 94.66ms