[1/2] incubator-trafodion git commit: [TRAFODION-2479] pyinstaller - firewall status should not block the installation process

2017-02-15 Thread svarnau 
Repository: incubator-trafodion
Updated Branches:
  refs/heads/master cc13c6cc5 -> 60fcb5457


[TRAFODION-2479] pyinstaller - firewall status should not block the 
installation process


Project: http://git-wip-us.apache.org/repos/asf/incubator-trafodion/repo
Commit: 
http://git-wip-us.apache.org/repos/asf/incubator-trafodion/commit/5b86a062
Tree: http://git-wip-us.apache.org/repos/asf/incubator-trafodion/tree/5b86a062
Diff: http://git-wip-us.apache.org/repos/asf/incubator-trafodion/diff/5b86a062

Branch: refs/heads/master
Commit: 5b86a0625913f1b811915e370053a08673e75550
Parents: 554cd32
Author: Eason 
Authored: Mon Feb 13 11:18:26 2017 +0800
Committer: Eason 
Committed: Mon Feb 13 11:18:26 2017 +0800

--
 install/python-installer/db_install.py | 4 ++--
 install/python-installer/scripts/traf_setup.py | 2 +-
 2 files changed, 3 insertions(+), 3 deletions(-)
--


http://git-wip-us.apache.org/repos/asf/incubator-trafodion/blob/5b86a062/install/python-installer/db_install.py
--
diff --git a/install/python-installer/db_install.py 
b/install/python-installer/db_install.py
index ffdb0b0..26a4ee7 100755
--- a/install/python-installer/db_install.py
+++ b/install/python-installer/db_install.py
@@ -42,7 +42,7 @@ except ImportError:
 from scripts import wrapper
 from scripts.common import DEF_PORT_FILE, DBCFG_FILE, USER_PROMPT_FILE, 
DBCFG_TMP_FILE, \
INSTALLER_LOC, Remote, Version, ParseHttp, 
ParseInI, ParseJson, \
-   http_start, http_stop, format_output, err_m, 
expNumRe, run_cmd
+   http_start, http_stop, format_output, err_m, 
expNumRe, run_cmd, info
 
 # init global cfgs for user input
 cfgs = defaultdict(str)
@@ -454,7 +454,7 @@ def user_input(options, prompt_mode=True, pwd=''):
 if content_dict['linux'] == 'N/A':
 log_err('Unsupported Linux version')
 if content_dict['firewall_status'] == 'Running':
-log_err('Firewall should be stopped')
+info('Firewall is running, please make sure the ports used by 
Trafodion are open')
 if content_dict['traf_status'] == 'Running':
 log_err('Trafodion process is found, please stop it first')
 if content_dict['hbase'] == 'N/A':

http://git-wip-us.apache.org/repos/asf/incubator-trafodion/blob/5b86a062/install/python-installer/scripts/traf_setup.py
--
diff --git a/install/python-installer/scripts/traf_setup.py 
b/install/python-installer/scripts/traf_setup.py
index a35ab93..c0b090c 100755
--- a/install/python-installer/scripts/traf_setup.py
+++ b/install/python-installer/scripts/traf_setup.py
@@ -32,7 +32,7 @@ from common import err, cmd_output, run_cmd
 def run():
 dbcfgs = json.loads(dbcfgs_json)
 
-HOME_DIR = cmd_output('cat /etc/default/useradd |grep HOME |cut -d "=" -f 
2').strip()
+HOME_DIR = cmd_output('sudo cat /etc/default/useradd |grep HOME |cut -d 
"=" -f 2').strip()
 if dbcfgs.has_key('home_dir'):
 HOME_DIR = dbcfgs['home_dir']

[2/2] incubator-trafodion git commit: Merge [TRAFODION-2479] PR-955 pyinstaller - firewall status

2017-02-15 Thread svarnau 
Merge [TRAFODION-2479] PR-955 pyinstaller - firewall status


Project: http://git-wip-us.apache.org/repos/asf/incubator-trafodion/repo
Commit: 
http://git-wip-us.apache.org/repos/asf/incubator-trafodion/commit/60fcb545
Tree: http://git-wip-us.apache.org/repos/asf/incubator-trafodion/tree/60fcb545
Diff: http://git-wip-us.apache.org/repos/asf/incubator-trafodion/diff/60fcb545

Branch: refs/heads/master
Commit: 60fcb5457445bc430828321bf8f5703e9dc1a8bb
Parents: cc13c6c 5b86a06
Author: Steve Varnau 
Authored: Thu Feb 16 00:17:07 2017 +
Committer: Steve Varnau 
Committed: Thu Feb 16 00:17:07 2017 +

--
 install/python-installer/db_install.py | 4 ++--
 install/python-installer/scripts/traf_setup.py | 2 +-
 2 files changed, 3 insertions(+), 3 deletions(-)
--

[2/2] incubator-trafodion git commit: Merge [TRAFODION-2441] and others pr-957 various fixes for native Hive tables and privileges

2017-02-15 Thread rmarton 
Merge [TRAFODION-2441] and others pr-957 various fixes for native Hive tables 
and privileges


Project: http://git-wip-us.apache.org/repos/asf/incubator-trafodion/repo
Commit: 
http://git-wip-us.apache.org/repos/asf/incubator-trafodion/commit/cc13c6cc
Tree: http://git-wip-us.apache.org/repos/asf/incubator-trafodion/tree/cc13c6cc
Diff: http://git-wip-us.apache.org/repos/asf/incubator-trafodion/diff/cc13c6cc

Branch: refs/heads/master
Commit: cc13c6cc56d1f0725fdf90803808b2aeb1f4f5f2
Parents: f6f4402 db14e39
Author: Roberta Marton 
Authored: Wed Feb 15 15:49:14 2017 +
Committer: Roberta Marton 
Committed: Wed Feb 15 15:49:14 2017 +

--
 core/sql/bin/SqlciErrors.txt  |   4 +-
 core/sql/common/ComUser.cpp   |  27 +++
 core/sql/common/ComUser.h |   2 +
 core/sql/optimizer/BindRelExpr.cpp|  12 +--
 core/sql/optimizer/NATable.cpp|  20 +++--
 core/sql/optimizer/RelExeUtil.cpp |  30 +++
 core/sql/regress/privs1/EXPECTED141   | Bin 100853 -> 102260 bytes
 core/sql/regress/privs1/TEST123   |   2 +-
 core/sql/regress/privs1/TEST141   |  10 ++-
 core/sql/regress/privs2/EXPECTED144   | Bin 59409 -> 59453 bytes
 core/sql/sqlcomp/CmpDescribe.cpp  |   9 ++-
 core/sql/sqlcomp/CmpSeabaseDDLauth.cpp| 103 ++--
 core/sql/sqlcomp/CmpSeabaseDDLauth.h  |   1 +
 core/sql/sqlcomp/CmpSeabaseDDLcommon.cpp  |  55 -
 core/sql/sqlcomp/CmpSeabaseDDLroutine.cpp |  18 +
 core/sql/sqlcomp/CmpSeabaseDDLschema.cpp  |  33 +---
 core/sql/sqlcomp/CmpSeabaseDDLtable.cpp   |  74 +
 core/sql/sqlcomp/CmpSeabaseDDLupgrade.cpp |   7 ++
 core/sql/sqlcomp/PrivMgr.cpp  |  10 +--
 core/sql/sqlcomp/PrivMgr.h|   5 +-
 core/sql/sqlcomp/PrivMgrCommands.cpp  |  65 +--
 core/sql/sqlcomp/PrivMgrCommands.h|   6 ++
 core/sql/sqlcomp/PrivMgrPrivileges.cpp|  26 --
 core/sql/sqlcomp/PrivMgrPrivileges.h  |   4 +-
 core/sql/sqlcomp/PrivMgrRoles.cpp | 106 +
 core/sql/ustat/hs_globals.cpp |   2 +-
 26 files changed, 517 insertions(+), 114 deletions(-)
--


http://git-wip-us.apache.org/repos/asf/incubator-trafodion/blob/cc13c6cc/core/sql/optimizer/BindRelExpr.cpp
--

http://git-wip-us.apache.org/repos/asf/incubator-trafodion/blob/cc13c6cc/core/sql/optimizer/NATable.cpp
--

http://git-wip-us.apache.org/repos/asf/incubator-trafodion/blob/cc13c6cc/core/sql/sqlcomp/CmpSeabaseDDLtable.cpp
--

[1/2] incubator-trafodion git commit: TRAFODION-2441 user has only select privilege on a table can do ... TRAFODION-2409 support privilege control(column privileges) for hive tables TRAFODION-2423 any

2017-02-15 Thread rmarton 
Repository: incubator-trafodion
Updated Branches:
  refs/heads/master f6f4402b5 -> cc13c6cc5


TRAFODION-2441 user has only select privilege on a table can do ...
TRAFODION-2409 support privilege control(column privileges) for hive tables
TRAFODION-2423 any user can perform 'initialize trafodion, drop'
TRAFODION-2435 Any user can perform TRUNCATE on native Hive tables.
TRAFODION-2463 Hive: Any user can do update statistics for hive tables

Fixed issues found while testing privileges with native Hive.

TRAFODION-2441:
  changed code that initializes owner privileges for views.

TRAFODION-2409:
  returning error message 1328 during attempt to grant unsupported column level
  privilege on hive table.

TRAFODION 2423:
  added privilege checks for all initialize commands, error 1017 is returned if
  not DB__ROOT

TRAFODION-2435:
  Returning error 1051 if TRUNCATE is attempted on a hive table where the
  current user has no privilege

TRAFODION-2463:
  Privilege checks added for Hive table during update statistics


Project: http://git-wip-us.apache.org/repos/asf/incubator-trafodion/repo
Commit: 
http://git-wip-us.apache.org/repos/asf/incubator-trafodion/commit/db14e392
Tree: http://git-wip-us.apache.org/repos/asf/incubator-trafodion/tree/db14e392
Diff: http://git-wip-us.apache.org/repos/asf/incubator-trafodion/diff/db14e392

Branch: refs/heads/master
Commit: db14e3922cb2d0722d0885f5c248cac2af2b904d
Parents: 60c0c42
Author: Roberta Marton 
Authored: Mon Feb 13 23:20:54 2017 +
Committer: Roberta Marton 
Committed: Mon Feb 13 23:20:54 2017 +

--
 core/sql/bin/SqlciErrors.txt  |   4 +-
 core/sql/common/ComUser.cpp   |  27 +++
 core/sql/common/ComUser.h |   2 +
 core/sql/optimizer/BindRelExpr.cpp|  12 +--
 core/sql/optimizer/NATable.cpp|  20 +++--
 core/sql/optimizer/RelExeUtil.cpp |  30 +++
 core/sql/regress/privs1/EXPECTED141   | Bin 100853 -> 102260 bytes
 core/sql/regress/privs1/TEST123   |   2 +-
 core/sql/regress/privs1/TEST141   |  10 ++-
 core/sql/regress/privs2/EXPECTED144   | Bin 59409 -> 59453 bytes
 core/sql/sqlcomp/CmpDescribe.cpp  |   9 ++-
 core/sql/sqlcomp/CmpSeabaseDDLauth.cpp| 103 ++--
 core/sql/sqlcomp/CmpSeabaseDDLauth.h  |   1 +
 core/sql/sqlcomp/CmpSeabaseDDLcommon.cpp  |  55 -
 core/sql/sqlcomp/CmpSeabaseDDLroutine.cpp |  18 +
 core/sql/sqlcomp/CmpSeabaseDDLschema.cpp  |  33 +---
 core/sql/sqlcomp/CmpSeabaseDDLtable.cpp   |  74 +
 core/sql/sqlcomp/CmpSeabaseDDLupgrade.cpp |   7 ++
 core/sql/sqlcomp/PrivMgr.cpp  |  10 +--
 core/sql/sqlcomp/PrivMgr.h|   5 +-
 core/sql/sqlcomp/PrivMgrCommands.cpp  |  65 +--
 core/sql/sqlcomp/PrivMgrCommands.h|   6 ++
 core/sql/sqlcomp/PrivMgrPrivileges.cpp|  26 --
 core/sql/sqlcomp/PrivMgrPrivileges.h  |   4 +-
 core/sql/sqlcomp/PrivMgrRoles.cpp | 106 +
 core/sql/ustat/hs_globals.cpp |   2 +-
 26 files changed, 517 insertions(+), 114 deletions(-)
--


http://git-wip-us.apache.org/repos/asf/incubator-trafodion/blob/db14e392/core/sql/bin/SqlciErrors.txt
--
diff --git a/core/sql/bin/SqlciErrors.txt b/core/sql/bin/SqlciErrors.txt
index 8afa052..fe99787 100644
--- a/core/sql/bin/SqlciErrors.txt
+++ b/core/sql/bin/SqlciErrors.txt
@@ -222,8 +222,8 @@
 1224 Z 9 BEGINNER MAJOR DBADMIN An invalid data type was specified for 
routine parameter $0~String0.
 1225 Z 9 BEGINNER MAJOR DBADMIN Mixing EXECUTE privilege with other 
privileges is not allowed.
 1226 Z 9 BEGINNER MAJOR DBADMIN No valid combination of privileges was 
specified.
-1227 Z 9 BEGINNER MAJOR DBADMIN Cannot unregister user.  User has been 
granted privileges.
-1228 Z 9 BEGINNER MAJOR DBADMIN Cannot drop role.  Role has been 
granted privileges.
+1227 Z 9 BEGINNER MAJOR DBADMIN Cannot unregister user.  User 
$0~String0 has been granted privileges on $1~String1.
+1228 Z 9 BEGINNER MAJOR DBADMIN Cannot drop role.  Role $0~String0 has 
been granted privileges on $1~String1.
 1229 Z 9 BEGINNER MAJOR DBADMIN The $0~string0 option is not supported.
 1230 Z 9 BEGINNER MAJOR DBADMIN Object owner must be the schema owner 
in private schemas.
 1231 Z 9 BEGINNER MAJOR DBADMIN User-defined routine $0~String0 could 
not be created.

http://git-wip-us.apache.org/repos/asf/incubator-trafodion/blob/db14e392/core/sql/common/ComUser.cpp
--
diff --git a/core/sql/common/ComUser.cpp b/core/sql/common/ComUser.cpp
index 7e7d7ca..925c5eb 100644
---