[
https://issues.apache.org/jira/browse/HAWQ-1246?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=15794657#comment-15794657
]
Lili Ma commented on HAWQ-1246:
-------------------------------
Current Request ID is managed per session level, and now we print it out in
HAWQ master log.
```
2017-01-03 17:38:34.775632
CST,"malili","postgres",p54608,th2056364032,"[local]",,2017-01-03 17:38:30
CST,3586,con14,cmd2,seg-10000,,,x3586,sx1,"LOG","00000","Send JSON request to
Ranger: { ""requestId"": ""8"", ""user"": ""malili"", ""clientIp"":
""127.0.0.1"", ""context"": ""SELECT d.datname as \""Name\"",\n
pg_catalog.pg_get_userbyid(d.datdba) as \""Owner\"",\n
pg_catalog.pg_encoding_to_char(d.encoding) as \""Encoding\"",\n
pg_catalog.array_to_string(d.datacl, E'\\n') AS \""Access privileges\""\nFROM
pg_catalog.pg_database d\nWHERE d.datname <> 'hcatalog'\nORDER BY 1;"",
""access"": [ { ""resource"": { ""database"": ""postgres"", ""schema"":
""pg_catalog"", ""function"": ""pg_encoding_to_char"" }, ""privileges"": [
""EXECUTE"" ] } ] }",,,,,,"SELECT d.datname as ""Name"",
pg_catalog.pg_get_userbyid(d.datdba) as ""Owner"",
pg_catalog.pg_encoding_to_char(d.encoding) as ""Encoding"",
pg_catalog.array_to_string(d.datacl, E'\n') AS ""Access privileges""
FROM pg_catalog.pg_database d
WHERE d.datname <> 'hcatalog'
ORDER BY 1;",0,,"rangerrest.c",391,
```
Note that it's session level. We can use this information to detect what's a
query is composed of.
> Add generation of RequestID, ClientIP, queryContext(SQL Statement) in HAWQ ,
> and encapsulate these contents to JSON request to RPS
> ----------------------------------------------------------------------------------------------------------------------------------
>
> Key: HAWQ-1246
> URL: https://issues.apache.org/jira/browse/HAWQ-1246
> Project: Apache HAWQ
> Issue Type: Bug
> Components: Security
> Reporter: Xiang Sheng
> Assignee: Xiang Sheng
> Fix For: 2.2.0.0-incubating
>
>
> These informations should be generated and encapsulate them to the full json
> request.
> Currently they are hardcoded.
> {code}
> json_object *jreqid = json_object_new_string("1");
> json_object_object_add(jrequest, "requestId", jreqid);
> json_object *jclientip = json_object_new_string("123.0.0.21");
> json_object_object_add(jrequest, "clientIp", jclientip);
> json_object *jcontext = json_object_new_string("SELECT * FROM DDDDDDD");
> json_object_object_add(jrequest, "context", jcontext);
> {code}
--
This message was sent by Atlassian JIRA
(v6.3.4#6332)
