Script to Fix Gerrit: LDAP floods log for gerrit-only users
We recently upgraded to Gerrit 2.7 and started to see lots of LDAP related errors in the logs. We tracked it down to this bug report: https://code.google.com/p/gerrit/issues/detail?id=1640.
I wrote a quick script to fix the issue and thought I'd share it.
read -s pwd
echo "SELECT external_id FROM account_external_ids WHERE external_id LIKE 'gerrit:%';" | mysql -h db.example.com -u gerrit -p${pwd} reviewdb | sed 's/^gerrit://' > usernames.txt
for u in $(< usernames.txt); do
if ! id $u > /dev/null 2>1; then
echo "DELETE FROM account_external_ids WHERE external_id = 'gerrit:$u' LIMIT 1;" | mysql -h db.example.com -u gerrit -p${pwd} reviewdb
fi;
done
I wrote a quick script to fix the issue and thought I'd share it.
read -s pwd
echo "SELECT external_id FROM account_external_ids WHERE external_id LIKE 'gerrit:%';" | mysql -h db.example.com -u gerrit -p${pwd} reviewdb | sed 's/^gerrit://' > usernames.txt
for u in $(< usernames.txt); do
if ! id $u > /dev/null 2>1; then
echo "DELETE FROM account_external_ids WHERE external_id = 'gerrit:$u' LIMIT 1;" | mysql -h db.example.com -u gerrit -p${pwd} reviewdb
fi;
done
Comments