讲解Gitlab 如何查看数据库,如何修改gitlab账户信息
如何查看gitlab数据库
gitlab 数据库配置位置
1
| $gitlabRoot/gitlab-rails/etc/database.yml
|
1
| cat /var/opt/gitlab/gitlab-rails/etc/database.yml
|
一般为下面情况
1 2 3 4 5 6 7 8 9 10 11 12 13 14
| production: adapter: postgresql encoding: unicode collation: database: gitlabhq_production //数据库名 pool: 10 username: 'gitlab' //用户名 password: host: '/var/opt/gitlab/postgresql' //主机 port: 5432 socket: sslmode: sslrootcert: sslca:
|
查看/etc/passwd文件里边gitlab对应的系统用户
1 2 3 4 5 6
| [root@localhost ~]# cat /etc/passwd root:x:0:0:root:/root:/bin/bash gitlab-www:x:496:493::/var/opt/gitlab/nginx:/bin/false git:x:495:492::/var/opt/gitlab:/bin/sh gitlab-redis:x:494:491::/var/opt/gitlab/redis:/bin/false gitlab-psql:x:493:490::/var/opt/gitlab/postgresql:/bin/sh //gitlab的postgresql用户
|
根据上面的配置信息登陆postgresql数据库
1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45 46 47 48 49 50 51 52 53 54 55 56 57 58 59 60 61 62 63 64 65 66 67 68 69 70 71 72 73 74 75 76 77 78 79 80 81 82 83 84
| [root@localhost ~]# su - gitlab-psql //登陆用户 -sh-4.1$ psql -h /var/opt/gitlab/postgresql -d gitlabhq_production 连接到gitlabhq_production库 psql (9.2.18) Type "help" for help. gitlabhq_production=# \h 查看帮助命令 Available help: ABORT CREATE FUNCTION DROP TABLE ALTER AGGREGATE CREATE GROUP DROP TABLESPACE ALTER COLLATION CREATE INDEX DROP TEXT SEARCH CONFIGURATION ALTER CONVERSION CREATE LANGUAGE DROP TEXT SEARCH DICTIONARY ALTER DATABASE CREATE OPERATOR DROP TEXT SEARCH PARSER ALTER DEFAULT PRIVILEGES CREATE OPERATOR CLASS DROP TEXT SEARCH TEMPLATE ALTER DOMAIN CREATE OPERATOR FAMILY DROP TRIGGER ALTER EXTENSION CREATE ROLE DROP TYPE …………………………………………………………………………………………………………………… gitlabhq_production-# \l //查看数据库 List of databases Name | Owner | Encoding | Collate | Ctype | Access privileges ---------------------+-------------+----------+-------------+-------------+--------------------------------- gitlabhq_production | gitlab | UTF8 | en_US.UTF-8 | en_US.UTF-8 | postgres | gitlab-psql | UTF8 | en_US.UTF-8 | en_US.UTF-8 | template0 | gitlab-psql | UTF8 | en_US.UTF-8 | en_US.UTF-8 | =c/"gitlab-psql" + | | | | | "gitlab-psql"=CTc/"gitlab-psql" template1 | gitlab-psql | UTF8 | en_US.UTF-8 | en_US.UTF-8 | =c/"gitlab-psql" + | | | | | "gitlab-psql"=CTc/"gitlab-psql" (4 rows) gitlabhq_production-# \dt //查看多表 List of relations Schema | Name | Type | Owner --------+--------------------------------------+-------+-------- public | abuse_reports | table | gitlab public | appearances | table | gitlab public | application_settings | table | gitlab public | audit_events | table | gitlab public | award_emoji | table | gitlab public | boards | table | gitlab public | broadcast_messages | table | gitlab …………………………………………………………………………………………………………………… gitlabhq_production-# \d abuse_reports //查看单表 Table "public.abuse_reports" Column | Type | Modifiers --------------+-----------------------------+------------------------------------------------------------ id | integer | not null default nextval('abuse_reports_id_seq'::regclass) reporter_id | integer | user_id | integer | message | text | created_at | timestamp without time zone | updated_at | timestamp without time zone | message_html | text | Indexes: "abuse_reports_pkey" PRIMARY KEY, btree (id) gitlabhq_production-# \di //查看索引 List of relations Schema | Name | Type | Owner | Table --------+-----------------------------------------------------------------+-------+--------+-------------------------------- ------ public | abuse_reports_pkey | index | gitlab | abuse_reports public | appearances_pkey | index | gitlab | appearances public | application_settings_pkey | index | gitlab | application_settings public | audit_events_pkey | index | gitlab | audit_events public | award_emoji_pkey | index | gitlab | award_emoji public | boards_pkey | index | gitlab | boards public | broadcast_messages_pkey | index | gitlab | broadcast_messages public | chat_names_pkey | index | gitlab | chat_names public | ci_application_settings_pkey | index | gitlab | ci_application_settings public | ci_builds_pkey | index | gitlab | ci_builds public | ci_commits_pkey | index | gitlab | ci_commits ……………………………………………………………………………………………………………………………………………… gitlabhq_production=# SELECT spcname FROM pg_tablespace; //查看所有表空间 spcname ------------ pg_default pg_global (2 rows) gitlabhq_production-# \q //退出psql -sh-4.1$ exit //退出登录用户 logout
|
强制找回GitLab账户密码的方法
首先登录GitLab后台服务器,并且切换至git用户,
登录GitLab的Rails控制台(GitLab使用RoR语言开发),
1
| gitlab-rails console production
|
接下来使用user = User.where(id: 1).first,定位到id=1的用户,就是超级管理员,
修改其他用户,只需要知道用户的ID就好
1
| user = User.where(id: 1).first
|
接下来为这个用户设置password,
1
| user.password = "xxxxxx"
|
保存设置,可以猜出此时会触发一个邮件发送的JOB,告知所做变更,
GitLab 学习系列