Issue 3038: Gerrit administrator can not access H2 Database
Status:  Invalid
Owner: ----
Closed:  Nov 2014
Reported by gll72...@gmail.com, Nov 28, 2014
************************************************************
***** NOTE: THIS BUG TRACKER IS FOR GERRIT CODE REVIEW *****
***** DO NOT SUBMIT BUGS FOR CHROME, ANDROID, INTERNAL *****
***** ISSUES WITH YOUR COMPANY'S GERRIT SETUP, ETC.    *****
***** THOSE ISSUE BELONG IN DIFFERENT ISSUE TRACKERS!  *****
************************************************************

Affected Version: Gerrit-2.9.1

What steps will reproduce the problem?
1.Install Gerrit-2.9.1,using H2 database
2.Install Apache2 on Ubuntu 14.04
3.Crate the first user and access gerrit 24918 port via ssh

What is the expected output? What do you see instead?
I can access gerrit with command "ssh -p 29418 gongleilei@192.168.1.157".

But when I access H2 database with command "ssh -p 29418 gongleilei@192.168.1.157 gerrit gsql", I got fail.
The output message is "fatal: gongleilei does not have "Access Database" capability."

Please provide any additional information below.

the user "gongleilei" is an administrator, gerrit runs on an Ubuntu Server whose Ip is 192.168.1.57.

My Gerrit Server using configuration file "gerrit.config", please refer to the attach.

Thanks.

gerrit.config
369 bytes   Download
Nov 29, 2014
Project Member #1 edwin.ke...@gmail.com
By default Gerrit administrators cannot access the database directly. To enable this you must assign the Access Database global capability [1] on the All-Projects root project to the Administrators group.

[1] https://gerrit-review.googlesource.com/Documentation/access-control.html#capability_accessDatabase
Nov 30, 2014
Project Member #2 david.pu...@sonymobile.com
Works as designed.
Status: Invalid