gitlab查看用户id

最新推荐文章于 2025-03-21 11:37:49 发布

Aggressive_snail

最新推荐文章于 2025-03-21 11:37:49 发布

阅读量1w

点赞数 1

分类专栏： gitlab 文章标签： gitlab user id gitlab

本文链接：https://blog.csdn.net/Aggressive_snail/article/details/88422132

版权

gitlab 专栏收录该内容

1 篇文章

订阅专栏

本文介绍了两种查看GitLab用户ID的方法：一是通过GitLab API接口查询，例如使用URL `http://10.18.13.100:10080/api/v4/users?username=test101`；二是直接进入GitLab Docker容器并操作数据库来获取用户ID。

摘要生成于 C知道，由 DeepSeek-R1 满血版支持，前往体验 >

需求

需要查看gitlab用户的id

方法一

通过页面api查询
http://10.18.13.100:10080/api/v4/users?username=test101
在这里插入图片描述

方法二

进入gitlab数据库查询，gitlab是使用docker部署的，所以需要进入容器操作

root@10-18-13-100:~# docker ps | grep gitlab
9178130d2c2a        10.253.127.117:8080/gitlab/gitlab-ce:10.5.2-ce.0      "/.r/r /assets/wra..."   2 months ago        Up 2 months (healthy)                                                                          r-gitlab-gitlab-server-1-ca83b62b
root@10-18-13-100:~# 
root@10-18-13-100:~# 
root@10-18-13-100:~# docker exec -it  9178 bash
root@gitlab-gitlab-server-1:/#

操作数据库

root@gitlab-gitlab-server-1:/# gitlab-rails dbconsole
psql (9.6.5)
Type "help" for help.
## 列出数据库
gitlabhq_production=> \l 
                                         List of databases
        Name         |    Owner    | Encoding | Collate |  Ctype  |        Access privileges        
---------------------+-------------+----------+---------+---------+---------------------------------
 gitlabhq_production | gitlab      | UTF8     | C.UTF-8 | C.UTF-8 | 
 postgres            | gitlab-psql | UTF8     | C.UTF-8 | C.UTF-8 | 
 template0           | gitlab-psql | UTF8     | C.UTF-8 | C.UTF-8 | =c/"gitlab-psql"               +
                     |             |          |         |         | "gitlab-psql"=CTc/"gitlab-psql"
 template1           | gitlab-psql | UTF8     | C.UTF-8 | C.UTF-8 | =c/"gitlab-psql"               +
                     |             |          |         |         | "gitlab-psql"=CTc/"gitlab-psql"
(4 rows)

gitlabhq_production=> 
## 连接数据库
gitlabhq_production=> \c gitlabhq_production 
You are now connected to database "gitlabhq_production" as user "gitlab".
gitlabhq_production=> 
## 查找账户id
gitlabhq_production=> select id from users where name = 'test101';
 id 
----
 19
(1 row)