You are viewing a plain text version of this content. The canonical link for it is here.
Posted to issues@trafodion.apache.org by "Alice Chen (JIRA)" <ji...@apache.org> on 2015/07/22 20:17:45 UTC
[jira] [Created] (TRAFODION-669) LP Bug: 1376835 - Initialize
authorization failing due to unique constraint error
Alice Chen created TRAFODION-669:
------------------------------------
Summary: LP Bug: 1376835 - Initialize authorization failing due to unique constraint error
Key: TRAFODION-669
URL: https://issues.apache.org/jira/browse/TRAFODION-669
Project: Apache Trafodion
Issue Type: Bug
Components: sql-security
Reporter: Paul Low
Assignee: Roberta Marton
Fix For: 0.9 (pre-incubation)
Error encountered when trying to enable authentication/authorization.
ERROR: Authorization has not been enabled, see /home/trafodion/traf_0930_hb98/logs/authEnable.log
Below is output log from running traf_authentication_setup --on
$ traf_authentication_setup --status
INFO: Start of security (authentication and authorization) script Tue Sep 30 11:25:06 PDT 2014.
INFO: *** Authentication Status ***
OpenLDAP authentication has been configured
Authentication is NOT ENABLED
INFO: End of security (authorization and authentication) script Tue Sep 30 11:25:06 PDT 2014.
$ traf_authentication_setup --on
INFO: Start of security (authentication and authorization) script Tue Sep 30 11:27:30 PDT 2014.
INFO: Using configuration file /home/trafodion/traf_0930_hb98/sql/scripts/.traf_authentication_config
INFO: Configuration file is valid
INFO: Configuration file has been propagated to nodes in the cluster
ERROR: Authorization has not been enabled, see /home/trafodion/traf_0930_hb98/logs/authEnable.log
Errors found, script terminated
$ more /home/trafodion/traf_0930_hb98/logs/authEnable.log
Trafodion Conversational Interface 0.9.0
(c) Copyright 2014 Hewlett-Packard Development Company, LP.
>> values (current_timestamp);
(EXPR)
--------------------------
2014-09-30 11:27:34.625354
--- 1 row(s) selected.
>> initialize authorization;
*** ERROR[8102] The operation is prevented by a unique constraint.
*** ERROR[1244] Authorization initialization failed.
--- SQL operation failed with errors.
>> get tables in schema privmgr_md;
--- SQL operation complete.
>> get users;
Users
=====
DB__ROOT
--- SQL operation complete.
>> get roles;
--- SQL operation complete.
>> get components;
*** ERROR[1222] Command not supported when authorization is not enabled.
--- SQL operation failed with errors.
>> exit;
End of MXCI Session
$
--
This message was sent by Atlassian JIRA
(v6.3.4#6332)