[
https://issues.apache.org/jira/browse/TRAFODION-2171?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=15428595#comment-15428595
]
Roberta Marton commented on TRAFODION-2171:
-------------------------------------------
the script traf_authentication_setup when enabling security is failing in this
situation because of the "get users" command. The work around is to:
cd $MY_SQROOT/sql/scripts
vi traf_authentication_setup
Remove (or comment out --) “get users” from this list of commands below:
function enable_authorization
{
logLoc=$MY_SQROOT/logs
rm $logLoc/authEnable.log > /dev/null 2>&1
#gdb sqlci
sqlci >> "$logLoc/authEnable.log" 2>&1 <<eof
values (current_timestamp);
initialize authorization;
get tables in schema privmgr_md;
==> get users;
get roles;
get components;
exit;
eof
Similarly, the same is required if you need to disable security features:
function disable_authorization
{
logLoc=$MY_SQROOT/logs
rm $logLoc/authDisable.log > /dev/null 2>&1
sqlci >> "$logLoc/authDisable.log" 2>&1 <<eof
values (current_timestamp);
initialize authorization, drop;
get tables in schema privmgr_md;
==> get users;
get roles;
exit;
eof
> '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)
