[ 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)