E-SEC: PSACCESSLOG Shows LOGIPADDRESS As "UNKNOWN" or "JavaClient" (Doc ID 1334041.1)

Last updated on OCTOBER 19, 2015

Applies to:

PeopleSoft Enterprise PT PeopleTools - Version 8.50 and later
Information in this document applies to any platform.
***Checked for Relevance 28-01-2013***

Goal

Still have questions after reading this document? Please post a question to our community: PeopleTools Community


When does the LOGIPADDRESS in the PSACCESSLOG table show an entry of "Unknown" or "JavaClient? What causes this?

Also is there an enhancement request to resize the LOGIPADDRESS field of the PSACCESSLOG. This field contains the reverse DNS entry when available instead of the actual IP address. In a sample of the last 30 days of data approximately 27% of the values in that field are exactly 40 characters long which implies that a large number of those were truncated to fit in the field. Having the reverse DNS entry is nice but is subject to change and may not have a matching forward DNS entry.

Recommended enhancement

1. Create a second field for the Reverse DNS value when available. This field can be VARCHAR2(255) to accommodate most host names.
2. Store only the raw IP address in the LOGIPADDRESS field. 40 characters is sufficient to hold IPv4 and IPv6 addresses.



Solution

Sign In with your My Oracle Support account

Don't have a My Oracle Support account? Click to get started

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms