Amazon S3
Background
Built in Amazon S3 dashboards and consoles to gain deep-level insights on your Elastic S3 buckets access logs. DBAs, IT Admins, Sys Admins and DevOps – with rich premium visualizations like dashboards, widgets and consoles XpoLog S3 features.
The application is aimed to run on access logs of the S3 bucket itself, if enabled (click on the logging of the bucket to enable it and see the path where log data will be written to):
Steps
- Add Log Data In XpoLog, When adding a log to XpoLog you can now set a Log Type (logtype). For AWS S3 set the following logtypes:
- AWS
- S3
- access
- The S3 access log usually is placed in a 'logs' directory within the bucket if the logging is enabled. The files name structure: <DATE>-<UNIQUE_ID> - in XpoLog it should be represented as {date,yyyy-MM-dd-HH-mm-ss}-{string}
It is required to configure a S3 account for XpoLog to connect and read the required data from the S3 bucket. - Once all required information is set click next and edit the log pattern, this step is crucial to the accuracy and deployment of the AWS S3 App. Use the following conversion table to build the XpoLog pattern out of the access log format.
Example
The AWS S3 access log format is:
Bucket Owner Bucket Time Remote IP Requester Request ID Operation Key Request-URI HTTP status Error Code Bytes Sent Object Size Total Time Turn-Around Time Referrer User-Agent Version Id
In XpoLog this pattern will be translated into:
{text:Bucket Owner - Canonical ID,ftype=usercanonicalID} {text:Bucket,ftype=bucket} [{date:Date,dd/MMM/yyyy:HH:mm:ss Z}] {geoip:Client IP,ftype=remoteip} {text:Requester - Canonical ID,ftype=requestercanonicalid} {text:Request ID,ftype=requestid} {text:Operation,ftype=operation} {text:key,ftype=key} "{choice:Method,ftype=reqmethod;,GET;POST;HEAD} {url:URL,paramsFtype=querystring;ftype=requrl;paramsName=Query;,} {string:reqprotocol,ftype=reqprotocol;,}" {number:ResponseStatus,ftype=respstatus} {text:Error Code,ftype=errorcode} {number:Bytes Sent,ftype=bytesent} {text:Object Size,ftype=objectsize} {number:ResponseTimeMilliSecs,ftype=processrequestmilli} {text:Turn Around Time,ftype=turnaroundtime} "{string:RefererQuery,ftype=refererquery;,}{regexp:Referer,ftype=referer;refName=RefererQuery,^([\w-]+://[^?]+|/[^?]+)}" "{string:User-Agent,ftype=useragent;,}" {text:Version ID,ftype=versionid}
for more information see below:
AWS S3 Access Log Format Conversion Table
| Field Name | Description | XpoLog Pattern | XpoLog ftype |
|---|---|---|---|
Bucket Owner | The canonical user ID of the owner of the source bucket | {text:Bucket Owner - Canonical ID,ftype=usercanonicalID} | usercanonicalID |
Bucket | The name of the bucket that the request was processed against. If the system receives a malformed request and cannot determine the bucket, the request will not appear in any server access log | {text:Bucket,ftype=bucket} | bucket |
Time | The time at which the request was received | [{date:Time,dd/MMM/yyyy:HH:mm:ss z}] | |
Remote IP | The apparent Internet address of the requester. Intermediate proxies and firewalls might obscure the actual address of the machine making the request | {geoip:Client IP,ftype=remoteip} | remoteip |
Requester | The canonical user ID of the requester, or the string "Anonymous" for unauthenticated requests. If the requester was an IAM user, this field will return the requester's IAM user name along with the AWS root account that the IAM user belongs to. This identifier is the same one used for access control purposes | {text:Requester - Canonical ID,ftype=requestercanonicalid} | requestercanonicalid |
Request ID | The request ID is a string generated by Amazon S3 to uniquely identify each request | {text:Request ID,ftype=requestid} | requestid |
Operation | The operation listed here is declared as | {text:Operation,ftype=operation} | operation |
Key | The "key" part of the request, URL encoded, or "-" if the operation does not take a key parameter. | {text:key,ftype=key} | key |
| Request-URI | The Request-URI part of the HTTP request message. | "{choice:Method,ftype=reqmethod;,GET;POST;HEAD} {url:URL,paramsFtype=querystring;ftype=requrl;paramsName=Query;,} {string:reqprotocol,ftype=reqprotocol;,}" | method querystring requrl reqprotocol |
HTTP Status | The numeric HTTP status code of the | {number:ResponseStatus,ftype=respstatus} | respstatus |
Error Code | The Amazon S3 Error Code, of the | {text:Error Code,ftype=errorcode} | errorcode |
Bytes Sent | The number of response bytes sent, excluding HTTP protocol overhead, or "-" if zero | {number:Bytes Sent,ftype=bytesent} | bytesent |
Object Size | The total size of the object in question | {text:Object Size,ftype=objectsize} | objectsize |
| Total Time | The number of milliseconds the request was in flight from the server's perspective. This value is measured from the time your request is received to the time that the last byte of the response is sent. Measurements made from the client's perspective might be longer due to network latency | {number:ResponseTimeMilliSecs,ftype=processrequestmilli} | processrequestmilli |
Turn-Around Time | The number of milliseconds that Amazon S3 spent processing your request. This value is measured from the time the last byte of your request was received until the time the first byte of the response was sent | {text:Turn Around Time,ftype=turnaroundtime} | turnaroundtime |
Referrer | The value of the HTTP Referrer header, if present. HTTP user-agents (e.g. browsers) typically set this header to the URL of the linking or embedding page when making a request | "{string:RefererQuery,ftype=refererquery;,}{regexp:Referer,ftype=referer;refName=RefererQuery,^([\w-]+://[^?]+|/[^?]+)}" | refererquery reerer |
User-Agent | The value of the HTTP User-Agent header | "{string:User-Agent,ftype=useragent;,}" | useragent |
Version ID | The version ID of the object being copied or "-" if the x-amz-copy-source header didn’t specify a | {text:Version ID,ftype=versionid} | versionid |