[
https://issues.apache.org/jira/browse/TRAFODION-2171?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=15428562#comment-15428562
]
Roberta Marton commented on TRAFODION-2171:
-------------------------------------------
When "get users" is requested, the following statement is executed:
select distinct auth_db_name
from %s.\"%s\".%s
where auth_type = '%s'
order by 1;
When the statement is executed, the "%s" values are substituted with the actual
values. The code setting up the auth_type to “U” is in a local variable. When
the substitution is made, the local variable is out of scope. We have just
gotten lucky up until now because the local variable still has the correct
value. With the new compiler that comes with Centos 7, the memory for the local
variable is now being used for something else. This unexpected value is
causing the invalid character error.
> 'get users' returned invalid character error when trying to turn on security
> on centos7.x
> -----------------------------------------------------------------------------------------
>
> Key: TRAFODION-2171
> URL: https://issues.apache.org/jira/browse/TRAFODION-2171
> Project: Apache Trafodion
> Issue Type: Bug
> Components: sql-security
> Environment: OS -- Centos7.2
> esgynDB -- poc build 20160808_1715 based on R2.1
> Reporter: Gao, Rui-Xian
> Assignee: Roberta Marton
>
> 'get users' returned invalid character error on centos7.1 and centos7.2,
> so failed to turn security on.
> >>get users;
> *** ERROR[2109] Invalid Character error converting SQL statement from
> character set UTF8 to character set UCS2 (character position 76, byte offset
> 76).
> *** ERROR[8822] The statement was not prepared.
> --- SQL operation failed with errors
> 'select from TRAFODION."_MD_".AUTHS' can return data normally.
> 'get roles' works fine.
> 'get users for roles' works fine.
--
This message was sent by Atlassian JIRA
(v6.3.4#6332)
