Project

General

Profile

Gerrit » History » Version 128

Hoernchen, 07/04/2023 04:48 PM

1 110 fixeria
h1. Contributing using Gerrit
2 99 fixeria
3 1 zecke
{{>toc}}
4 11 laforge
5 117 laforge
At [[OpenBSC:OsmoDevCon2016]] we discussed problems with our past contribution / patch submission process using mails on the mailing list as well as patchwork.  The result was that we wanted to give Gerrit a try for some time and see if it helps us to have a better process.  We were (and still are) quite happy with it, and over time most Osmocom projects have migrated to using gerrit.
6 1 zecke
7 10 laforge
Gerrit is a review tool that integrates nicely with git and ssh. You can find general information about Gerrit at https://www.gerritcodereview.com/
8 1 zecke
9 10 laforge
The advantages of Gerrit are:
10
* patch submission status is automatically tracked, also with several revisions for a patch set.
11
* patches are build-tested (and possibly even further tested) by jenkins before they are applied
12 108 stsp
* patch submissions not via git send-email but direcly from git
13 10 laforge
14
h2. Osmocom Subprojects using Gerrit
15
16 73 laforge
The majority of Osmocom sub-projects have chosen to use Gerrit for patch review.  In order to check if a given program uses Gerrit, please check the auto-generated list at https://gerrit.osmocom.org/#/admin/projects/
17 1 zecke
18 75 laforge
If the project is listed there, then it uses Gerrit.   If the project is not listed there, please send patches by e-mail to the respective project [[Mailing_Lists]] instead.
19 30 neels
20 1 zecke
h2. Configuring Gerrit/Account
21
22 109 stsp
You will need to sign up at https://gerrit.osmocom.org/login/. If you have an Osmocom Redmine account you can use https://osmocom.org/openid as OpenID provider.
23 1 zecke
24 109 stsp
* first sign in on https://osmocom.org. Do this before logging into gerrit (the redmine login process loses the gerrit login data and you'd have to do the same thing twice if not logged in on osmocom.org already).
25 55 neels
* go to https://gerrit.osmocom.org and click the "Sign in" link.
26 68 neels
* click the "Sign in with Osmocom":https://gerrit.osmocom.org/login/%23%2Fq%2Fstatus%3Aopen?id=https://osmocom.org/openid link (can be bookmarked). -- This is the same as entering https://osmocom.org/openid as OpenID provider and hitting the "Sign in" button.
27 61 neels
28 109 stsp
*careful:* enter 'https' to ensure that your openid credentials are passed on encrypted.
29 68 neels
*pitfall:* if you're logged in on 'projects.osmocom.org' (including the 'projects.' part), you should also use the openid provider: https://projects.osmocom.org/openid; the 'projects.' part may be omitted, what's important is that redmine login and OpenID URLs match. Also, decide for one of those URLs once, because when picking a different OpenID URL next time, you will create a new user instead of logging in as yourself.
30 61 neels
*note:* gerrit will create a distinct user for each openid URL you pass. If you logged in successfully but your user seems to have lost permissions, you may have created an evil twin user: contact us on the mailing list so we can fix it in the user database.
31 54 neels
32
If you have no Osmocom redmine account, you can simply create one online at the "Register" link in the upper right corner.
33 10 laforge
Even without an existing or new redmine account, you should also be able to use any other OpenID provider to authenticate against gerrit (untested).
34
35
After the initial sign-up you will need to:
36 1 zecke
37 109 stsp
* Pick a username (cannot be changed)
38 1 zecke
* Add your public ssh key(s)
39
* Add email addresses you intend to use as author/comitter
40 30 neels
41
If you would like to push private branches to the Gerrit repository, you also need to be added to the "known users" group.
42
Please send a short requesting email to openbsc@lists.osmocom.org.
43 1 zecke
44
h2. Setting up Gerrit for commits and pushing
45
46 33 neels
*Note:* it is easiest to work with gerrit when gerrit is the only remote in your git clone.
47 119 laforge
When you clone from gitea.osmocom.org and add the gerrit remote, git will have two remotes,
48 36 neels
so when you first checkout a branch you have to supply the remote explicitly (cumbersome).
49 119 laforge
The gerrit repositories and gitea.osmocom.org are constantly synced, so it is sufficient
50 34 neels
to clone from gerrit only.
51 33 neels
52
h3. Simplest: new clone
53
54 35 neels
* Create a new clone from gerrit
55 1 zecke
56 121 fixeria
<pre><code class="shell">
57 1 zecke
git clone ssh://$USERNAME@gerrit.osmocom.org:29418/$PROJECT.git
58 121 fixeria
</code></pre>
59
60
* Fetch the commit hook that adds Change-Id to each commit to uniquely identify a commit
61
62
<pre><code class="shell">
63
# Option a) using scp
64 1 zecke
scp -P 29418 $USERNAME@gerrit.osmocom.org:hooks/commit-msg $PROJECT/.git/hooks/
65 121 fixeria
66
# Option b) using curl
67
curl -o $PROJECT/.git/hooks/commit-msg https://gerrit.osmocom.org/tools/hooks/commit-msg
68
chmod +x $PROJECT/.git/hooks/commit-msg
69
</code></pre>
70 33 neels
71
h3. SSH config
72
73
In '~/.ssh/config', add these lines:
74
<pre>
75 52 neels
Host go
76 33 neels
Hostname gerrit.osmocom.org
77
Port 29418
78
User $USERNAME
79
</pre>
80 52 neels
('go' means gerrit.osmocom, replace with your favorite shortcut name,
81 33 neels
replace '$USERNAME' with your user name as used on the gerrit website)
82
83
Then you can shorten above commands to
84 1 zecke
<pre>
85 52 neels
git clone ssh://go/$PROJECT.git
86 51 neels
cd $PROJECT
87
scp go:hooks/commit-msg .git/hooks/
88 33 neels
</pre>
89
90 1 zecke
h3. Committer must match
91 46 neels
92 1 zecke
Your email address on gerrit and the email address git places in your
93 46 neels
commits must match, or you will get rejected with an error message like
94 108 stsp
"invalid committer". You can add email addresses on the gerrit web UI.
95 47 neels
96 1 zecke
h3. Add gerrit to an existing clone
97
98
* Add the remote to be able to fetch and push to gerrit
99
100 122 fixeria
<pre><code class="shell">
101 1 zecke
USERNAME=gerrit_user_name
102
PROJECT=$(basename $PWD)
103
git remote add gerrit ssh://$USERNAME@gerrit.osmocom.org:29418/$PROJECT.git
104 122 fixeria
</code></pre>
105
106
* Fetch the commit hook that adds Change-Id to each commit to uniquely identify a commit
107
108
<pre><code class="shell">
109
# Option a) using scp
110 1 zecke
scp -P 29418 $USERNAME@gerrit.osmocom.org:hooks/commit-msg .git/hooks/
111 122 fixeria
112
# Option b) using curl
113
curl -o .git/hooks/commit-msg https://gerrit.osmocom.org/tools/hooks/commit-msg
114
chmod +x .git/hooks/commit-msg
115
</code></pre>
116
117 1 zecke
118
h2. Push for review
119
120
Prerequisites:
121
122
* your user on gerrit has an SSH public key
123
* your patch is committed in your local clone
124
* the commit log message has a Change-Id (see 'commit-msg' hook above, and 'Tips and Tricks' below to add a Change-Id to a commit that lacks one.)
125
126
<pre>
127 115 neels
git push $REMOTE $GITHASH:refs/for/$BRANCH%topic=$TOPIC
128 1 zecke
</pre>
129
130
$REMOTE: from above instructions, that's either 'origin' (cloned from gerrit) or 'gerrit' (if you added a second remote).
131
$GITHASH: the committed patch to push, typically you're on your branch and simply push 'HEAD'.
132
$BRANCH: you will typically intend a patch to go to 'master'.
133 115 neels
%topic=$TOPIC: an optional name you may choose.
134 1 zecke
135 128 Hoernchen
Pushing as WIP _with a topic_ does *NOT* work like that, you need to do:
136
<pre>
137
git push $REMOTE $GITHASH:refs/for/$BRANCH%wip -o topic=$TOPIC
138
</pre>
139
140 109 stsp
For example, check out the revision or branch that you want to submit for review,
141 1 zecke
i.e. the one where your patch or several patches are committed on top of the current master, then:
142
143
If you cloned directly from gerrit:
144
145
<pre>
146
git push origin HEAD:refs/for/master
147
</pre>
148
149
If you added 'gerrit' as a second remote to an existing clone:
150
151
<pre>
152
git push gerrit HEAD:refs/for/master
153
</pre>
154
155
You can optionally add a topic name with
156
157
<pre>
158 115 neels
git push origin HEAD:refs/for/master%topic=my_topic
159 1 zecke
</pre>
160
161 102 stsp
h2. Voting Rules for merging a patch to master
162 7 neels
163 124 laforge
High-level goal: Two people _other than the patch author/owner_ should have given positive review ("Review +1") _and_ the patch must pass automatic build/lint validation ("Verified: +1").
164
165 103 stsp
Please follow these voting rules:
166 44 neels
167 102 stsp
h3. Code Review ("CR")
168 77 neels
169 102 stsp
* Please review patches by others.
170
* Do not vote for your own patches (exceptions below).
171
* Before merging, each patch should receive at least two reviews that approve merging.
172 77 neels
173 123 laforge
When voting, please follow this social contract (written from the point of a _reviewer_):
174 77 neels
175 102 stsp
* When you approve, vote CR +1.
176 123 laforge
* If there already is someone else's CR +1, you *as a reviewer, not as the author/owner* may also choose to vote CR +2.
177 102 stsp
* If the patch owner sees two or more CR +1, the patch owner may apply to self a CR +2.
178
* Once there is at least one CR +2 and one CR +1 vote, a patch may be merged ("Submit" button), except:
179
** If there are two -1 votes, you should not merge, instead clarify the reason and try to fix it.
180
** If there is a single -1 vote, you may still merge the patch, if you are sure that the opinion of the -1 vote does not carry.
181
* Give the benefit of the doubt to the -1 vote, do not lightheartedly overrule.
182
* If there is a CR -2 vote, the patch will likely never pass review, it marks a fundamental flaw.
183
* Merging a patch ("Submit" button) may be done by a reviewer or by the patch owner,
184
  But if there is any negative vote, rather leave merging up to the patch owner.
185
* If you remove a +1 vote, try to make sure that there are no other CR +2 votes left alone
186
  (to prevent accidental "Submit including parents"). If needed, ping other reviewer / admin on IRC.
187
  But try to vote +1 only when you're sure, hence this situation should be rare.
188
* To prevent merging of your own patch before some issue is resolved, consider marking it Work In Progress.
189
190 104 stsp
h3. Exceptions for Trivial / Urgent Patches
191 102 stsp
192
A patch may receive a direct +2 when:
193
194
* it is very trivial, like a typo fix in a comment or log string, so that it is not worth wasting review time on.
195
* it reverts an earlier change that broke the master builds.
196
197
In these cases, the patch submitter may decide to +2 to self, after careful consideration. This should be rare.
198
199
h3. Verification ("V")
200
201
* For most projects, jenkins takes care of voting V +1 automatically.
202
* If you have actually tried out a patch and verified that it works, you may vote V +1.
203
* A patch owner may vote V +1 to self in a project that has no Jenkins verification job.
204
205
h3. Rationale
206
207
Gerrit allows merging a patch as soon as a CR +2 vote and a V +1 vote are in.
208
For quite some time, we had CR +2 permissions for only very few gatekeeper reviewers.
209
The result was that non-gatekeepers' votes seemed to not matter.
210
211
To encourage more peer review that actually has an effect, we would like to sum up +1 votes.
212
We have tried to apply a summing of votes in Gerrit with automatic enforcing
213
( https://gerrit-review.googlesource.com/Documentation/prolog-cookbook.html#_example_13_1_1_2_code_review )
214
but this had numerous quirks, particularly the issues summary shows wildly mismatching voting status.
215
216
The solution is to agree on a social contract: everyone gets +2 permissions,
217
but you shall only use it when it makes sense. Thanks!
218
219 84 neels
h2. Manage private branches
220 1 zecke
221 84 neels
Use a sub-directory with your name to group your own branches, please.
222 1 zecke
*Note* that you must be a member of the "known users" group, see above.
223
224 119 laforge
To share / backup local branches to gitea.osmocom.org, without starting a code review process on gerrit.osmocom.org, just push them as usual to gerrit.
225 84 neels
226
* Note that the git repository must be cloned from the gerrit SSH URL -- all pushing goes to gerrit ("pushurl" as described below also works).
227 119 laforge
* All private branches are automatically synced to gitea.osmocom.org in a matter of minutes.
228 1 zecke
* Private branches do not kick off patch sets for review, they are just branches. To kick off review for all patches on your branch, you'd use a 'refs/for/master' URL, as shown in the example below.
229 116 neels
230
*Pitfall*: always include both your name and a topic in a branch name, right from the start. If you first create a branch named "fred", creating branches named "fred/topic" later will cause conflicts in the .git admin tree, because first "fred" was a file, and then becomes a directory. Even if you fix it in your local repository, *all* other git repositories, including those on the build servers, may need manual action to become usable again. One solution is to push a deletion of "fred" and then "git fetch --purge" everywhere else.
231 84 neels
232
The typical transcript for "Fred" developing feature "Kazoo" looks like this:
233
234 1 zecke
<pre>
235 127 neels
# First, set up ~/.ssh/config so that 'go' points at gerrit.osmocom.org.
236
# Then:
237
git clone ssh://go/sandbox
238 84 neels
239 127 neels
cd sandbox
240
# create local branch
241
git checkout -b fred/kazoo
242 84 neels
243
$EDITOR
244
git add kazoo.c
245
git commit -m "implement kazoo"
246
247
# just invoke 'git push' and git tells you how to create the branch once-off:
248 1 zecke
git push
249 126 neels
|fatal: The current branch kazoo has no upstream branch.
250 84 neels
|To push the current branch and set the remote as upstream, use
251
|
252
|    git push --set-upstream origin fred/kazoo
253 1 zecke
254 84 neels
git push --set-upstream origin fred/kazoo
255 119 laforge
# Now the branch exists on gerrit, very soon will also exist on gitea.osmocom.org
256 84 neels
257
# Further tweaks
258
$EDITOR
259
git add kazoo.h
260
git commit --amend
261
262
# You are free to force-push private branches
263
git push -f
264
265
# origin/master has changed? Rebase onto the latest.
266 1 zecke
git fetch
267 84 neels
git rebase -i origin/master
268
# resolve conflicts...
269
git push -f
270
271 127 neels
# Feature is ready, submit the entire branch to Gerrit code review
272 84 neels
git push origin HEAD:refs/for/master/kazoo
273 39 neels
</pre>
274 7 neels
275 48 ahuemer
h2. List changesets in gerrit
276 2 zecke
277 12 msuraev
<pre>
278 17 neels
git ls-remote gerrit changes/*
279 1 zecke
</pre>
280 80 neels
281
h1. Tips and Tricks
282
283
h2. A commit lacks a Change-Id
284
285
once you added the commit hook as above, just re-edit the commit log message, e.g. with
286
287
<pre>
288
git commit --amend
289
</pre>
290
291
or by
292
293
<pre>
294
git rebase -i
295
</pre>
296
297
and in the upcoming editor replacing 'pick' with 'r' in front of the commit to edit.
298 74 neels
299
No need to change the commit log if you don't want to, just exit the editor and the commit hook will add a Change-Id.
300 79 neels
301 87 msuraev
h2. Ignore WIP patches
302
303
Using following operators in "search" field of web UI allows to ignore Work-in-progress changes:
304
<pre>
305
status:open AND -is:wip
306
</pre>
307
308 119 laforge
h2. Fetch fast from gitea.osmocom.org, push to gerrit
309 79 neels
310 1 zecke
Gerrit has moved to a faster host, so this should no longer be necessary. Anyway...
311 74 neels
312 109 stsp
Adding a second remote forces you to explicitly pass the remote on the command line ("origin").
313
It is possible to have only one remote for convenience, with different push and pull URLs:
314 79 neels
315 74 neels
<pre>
316 119 laforge
git remote set-url origin https://gitea.osmocom.org/$ORG/$PROJECT
317 74 neels
git remote set-url --push origin ssh://$USERNAME@gerrit.osmocom.org:29418/$PROJECT
318
</pre>
319 79 neels
320 74 neels
With above .ssh config you can also use the shorter ssh:// URL:
321
<pre>
322 79 neels
git remote set-url --push origin ssh://go/$PROJECT
323 74 neels
</pre>
324
325
The resulting .git/config in libosmocore would look something like:
326
<pre>
327
[remote "origin"]
328 119 laforge
        url = https://gitea.osmocom.org/osmocom/libosmocore
329 74 neels
        pushurl = ssh://go/libosmocore
330
        fetch = +refs/heads/*:refs/remotes/origin/*
331
</pre>
332 17 neels
333 119 laforge
Now you're fetching from gitea.osmocom.org, which is lightning fast, while pushing patches will still go to gerrit as usual.
334 17 neels
335 45 neels
h2. Throw-away branch
336 13 neels
337 56 neels
If you need to adjust and re-submit patches, it may be handy to create a throw-away branch ("R D" in magit-gerrit in emacs for example),
338
make your changes/amendments and then send patch(es) back to gerrit while removing temporary branch automatically with "git review -f".
339
340
h2. Fetch a patch from gerrit
341
342
This script (I called it @P@) makes fetching a patch set from gerrit a breeze:
343
<pre>
344
#!/bin/sh
345
# fetch gerrit patch into new branch named like the patch number.
346
#
347
# Usage: go to a git clone and pass a patch number:
348
#
349
#   cd openbsc
350
#   P 973
351
# or
352
#   P 973/2
353
#
354
# Will create new local branches '973_4' (if 4 is the latest patch set)
355
# or '973_2', respectively.
356
357
patch="$1"
358
359
if [ -z "$patch" ]; then
360
  echo "Usage: P 1234[/5]"
361
  exit 1
362
fi
363
364
if [ -z "$(echo "$patch" | grep '/')" ]; then
365
  patch="/$patch/"
366
fi
367
368
if [ -z "$(echo "$patch" | grep '^/')" ]; then
369
  patch="/$patch"
370
fi
371
372 112 neels
remote="$(git remote get-url --push origin)"
373
374
last_set="$(git ls-remote "$remote" "changes/*" | grep "$patch" | sed 's#.*/\([^/]*\)$#\1 &#' | sort -n | tail -n 1)"
375 56 neels
if [ -z "$last_set" ]; then
376
  echo "Not found: $patch"
377
  exit 1
378
fi
379
380
change_name="$(echo "$last_set" | sed 's/.*\(refs.*\)/\1/')"
381
branch_name="$(echo "$change_name" | sed 's#refs/changes/../\([0-9]*\)/\([0-9]*\)#\1_\2#')"
382 1 zecke
383 56 neels
set -x
384 112 neels
git fetch "$remote" "$change_name"
385 25 neels
git co -b "$branch_name" FETCH_HEAD
386 13 neels
</pre>
387 1 zecke
388 58 neels
h2. Re-submit a Branch with Amended Commits
389
390 22 neels
On a feature branch, one typically has numerous commits that depend on their preceding commits.
391 58 neels
Often, some of the branch commits need to be amended for fixes. You can re-submit changes to
392
patches on your branch by pushing in the same way that you first submitted the branch.
393
394 29 neels
Note: if you modify the Change-Ids in the commit logs, your push would open entirely new
395 58 neels
review entries and you would have to abandon your previous submission. Comments on the first
396
submission are "lost" and you cannot diff between patch sets.
397 29 neels
398 26 neels
399 1 zecke
h2. Re-submit Previously Abandoned Changes
400
401
You have to edit the Change-Ids, on a branch that would be every single commit log message.
402
403
<pre>
404
cd openbsc
405
git co my-branch
406
git rebase -i master
407
# replace all 'pick' with 'r' (or 'reword'), exit your editor
408
# git presents each commit log message for editing
409
</pre>
410
411 78 neels
h2. 502 Bad Gateway
412
413
When getting a "Bad Gateway" error message upon trying to login on gerrit, you probably just need to restart your web browser. The reason is not clear.
414
415 120 fixeria
h2. scp fails with "subsystem request failed on channel 0"
416
417
Most likely, you're using a very recent OpenSSH release (9.0 - check https://www.openssh.com/txt/release-9.0 43 for more info), which changes the scp program to use the SFTP protocol under the hood.
418
419
<pre>
420
$ scp -P 29418 gerrit.osmocom.org:hooks/commit-msg .git/hooks/
421
subsystem request failed on channel 0
422
scp: Connection closed
423
</pre>
424
425
To work around the problem on the client side, use the new @-O@ (that is an uppercase letter "o") switch when invoking scp, which will cause it to fall back to the legacy behavior.
426
427
<pre>
428
$ scp -O -P 29418 gerrit.osmocom.org:hooks/commit-msg .git/hooks/
429
commit-msg                                              100% 2174     9.5KB/s   00:00
430
</pre>
431 78 neels
432
h2. Commit hook: Always put Change-Id at the bottom of the log message
433
434
The commit-msg hook places a Change-Id tag in the footer, often above other tags like 'Depends:' or 'Related:'. Since the Change-Id is an implementation detail for Gerrit, I personally prefer it always placed right at the bottom. This simple edit changes the commit-msg hook to add Change-Id at the bottom unconditionally:
435
436
<pre>
437
cd $PROJECT
438
sed -i 's/if (unprinted /if (0 \&\& unprinted /' .git/hooks/commit-msg
439
</pre>
440
441
The goal is to disable the condition in line 163 with an 'if (0...':
442
443
<pre>
444
                        if (0 && unprinted && match(tolower(footer[line]), changeIdAfter) != 1) {
445
                                unprinted = 0
446
                                print "Change-Id: I'"$id"'"
447
                        }
448 60 neels
</pre>
449 16 neels
450 13 neels
Then the Change-Id will be placed by line 170 instead.
451 16 neels
452
h1. Reasons for Particular Configuration
453
454 13 neels
h2. Rebase if necessary
455
456
There are different merge strategies that Gerrit performs to accept patches.
457
Each project can be configured to a specific merge strategy, but unfortunately you can't
458
decide on a strategy per patch submission.
459
460
It seems that the "Merge if Necessary" strategy is best supported, but it creates non-linear
461
history with numerous merge commits that are usually not at all necessary.
462
463
Instead, the "Cherry Pick" strategy puts each patch onto current master's HEAD to create
464 1 zecke
linear history. However, this will cause merge failures as soon as one patch depends on
465 13 neels
another submitted patch, as typical for a feature branch submission.
466
467 1 zecke
So we prefer the "Rebase if Necessary" strategy, which always tries to apply your patches to
468 13 neels
the current master HEAD, in sequence with the previous patches on the same branch.
469
470
h2. Private Branches: Create a new change for every commit...
471 16 neels
472 13 neels
Say you have an extensive feature in development, and you want to keep it on the
473
upstream git repository to a) keep it safe and b) collaborate with other devs on it.
474
So, of course, you have regularly pushed to refs/heads/yoyodyne/feature.
475
476
Since you have the gerrit commit hook installed, your feature branch already has
477
Change-Id tags in all commit log messages.
478
479
Now your feature is complete and you would like to submit it to master.
480 16 neels
Alas, Gerrit refuses to accept your patch submission for master, because it
481
knows the Change-Ids are also on a different branch.
482
483
Gerrit by default enforces that a Change-Id must be unique across all branches,
484
so that each submission for review is separate for each branch. Instead, we
485 13 neels
want to handle Change-Ids per-branch, so that you can have the same change
486 16 neels
submitted to different branches, as separate patch submissions, without having
487
to cosmetically adjust the Change-Id.
488 13 neels
489 20 neels
Solution: set the option 
490 14 neels
_Create a new change for every commit not in the target branch_ to _TRUE_
491
492
h2. Allow content merges
493
494
By default, gerrit compares patches only by the files' paths. If two paths are the same,
495
it immediately shows them as conflicts (path conflicts).
496
497 23 neels
In software development, a conflict usually means an actual content conflict, so if the
498 14 neels
edits are in two entirely separate places in the file, we don't consider this a conflict.
499
500 32 neels
By setting _Allow content merges_ to _TRUE_ in the git project config, we tell Gerrit to
501
perform text merges of the submitted patches and only complain about actual content
502
conflicts, in the usual software engineering sense.
503 72 laforge
504
h1. Admin
505
506
h2. Adding a new repository
507
508 113 osmith
1. create the repository in the Gerrit UI, inherit from "All-Projects"
509 119 laforge
2. a) project does not exist on gitea.osmocom.org:
510
* create an empty git repository using gitea on https://gitea.osmocom.org/
511 113 osmith
512 119 laforge
2. b) project exists on https://gitea.osmocom.org:
513
* explicitly add gerrit as a second remote and push all branches/tags from gitea.osmocom.org to gerrit.
514 113 osmith
515
3. configure a jenkins build testing job for this project (see gerrit-verifications.yml in osmo-ci.git/jobs)
516 92 osmith
517 72 laforge
518 32 neels
git replication to gerrit.osmocom.org is enabled automatically, nothing to be done here.  In case of doubt, try
519
@ssh -p 29418 gerrit.osmocom.org replication start --all --wait@
520
521 125 laforge
522
h2. Deleting a repository
523
524
@ssh -p 29418 gerrit.osmocom.org delete-project delete --yes-really-delete NAME@
525
526
527 32 neels
h2. Adding users to groups
528
529
Normally, the gerrit UI auto-completes a user name in the edit field. It has happened
530
though that an existing user is not auto-completed, as if it didn't exist. In that case,
531
find out the user ID (seven digit number like 1000123) and just enter that.
532
533
The user ID can be found on the user's "Settings" page, or in the database (s.b.).
534
535
h2. Querying the database directly
536
537
If your user has permission to access the database, you can place SQL queries using the
538 71 neels
'gerrit gsql' commands over ssh:
539
540 1 zecke
<pre>
541 53 neels
ssh go "gerrit gsql -c \"show tables\""
542
ssh go "gerrit gsql -c \"select full_name,account_id from accounts\""
543 1 zecke
</pre>
544
545 71 neels
(see ~/.ssh/config above for the 'go' shortcut)
546
547 62 neels
This seems to be the MySQL dialect.
548
549
The "...\"...\"" quoting allows including single-quotes in the SQL statements.
550
551
h2. Fix evil twin users
552
553 111 laforge
If differing openid URLs have lead to evil twin users shadowing the same email address just without the permissions, we end up with duplicate users showing up in the UI, e.g. when you want to add somebody as a reviewer.
554 1 zecke
555 111 laforge
In past gerrit vesions based on ReviewDB, one could use SQL statements to manipulate the database. However, gerrit has migrated to NoteDB, and hence this access is no longer possible.
556 1 zecke
557 111 laforge
You can find information on how to manipulate users using the REST API at
558
* https://charm.cs.illinois.edu/gerrit/Documentation/rest-api-accounts.html#account-endpoints
559
* https://charm.cs.illinois.edu/gerrit/Documentation/rest-api.html
560 1 zecke
561 111 laforge
You can get a list of identities for one given e-mail address (e.g. @pmaier@sysmocom.de@) using
562
563
 curl 'https://gerrit.osmocom.org/accounts/?q=pmaier@sysmocom.de'
564
565
which would give you a result like this:
566
<pre>
567
[
568
  {
569
    "_account_id": 1000028
570
  },
571
  {
572
    "_account_id": 1000140
573
  }
574
]
575 62 neels
</pre>
576 111 laforge
577
578
And subsequetly check which of the identities you want to keep or remove:
579
580
 curl --user http_user:http_pass  'https://gerrit.osmocom.org/a/accounts/1000028/external.ids'
581
curl --user http_user:http_pass  'https://gerrit.osmocom.org/a/accounts/1000140/external.ids'
582
583
The "intended" ones typically have https://osmocom.org/openid URLs, while the unintended/dupliacte ones have http (not https) or use www.osmocom.org or projects.osmocom.org instead.
584
585
Once you have found the duplicate (in this case 100140), you can deactivate the duplicate using 
586
587
 curl --user http_user:http_pass -X DELETE 'https://gerrit.osmocom.org/a/accounts/1000140/active'
Add picture from clipboard (Maximum size: 48.8 MB)