How to connect to the database after setting up gitlab

In the process of building GitLab, the database is a necessary component. After the setup is completed, GitLab needs to be connected to the database for normal use. This article will introduce how to connect GitLab and the database to make your GitLab run smoothly.

1. Install the database

First you need to install the database. GitLab supports two databases: PostgreSQL and MySQL. Here, we take PostgreSQL as an example.

1. Install PostgreSQL

Install PostgreSQL via the following command:

sudo apt-get install -y postgresql postgresql-contrib libpq-dev

2. Create PostgreSQL user and database

Before creating the GitLab database, you need to create a user for connecting to the database. Create a user named "gitlab" using the following command:

sudo -u postgres psql -c "CREATE USER gitlab CREATEDB;"

This will create a user named "gitlab" and grant that user permission to create databases. Next, use the following command to create a database named "gitlabhq_production":

sudo -u postgres psql -c "CREATE DATABASE gitlabhq_production OWNER gitlab;"

2. Configure GitLab connection database

1. Configure database connection

Configure the GitLab connection database in the "production" section of the /etc/gitlab/gitlab.rb file. Open the file:

sudo vi /etc/gitlab/gitlab.rb

Find the following line of code, delete the comment character # and change it to true:

# postgresql['enable'] = false
postgresql['enable'] = true

After that, add the following code to the end of the file:

gitlab_rails['db_adapter'] = 'postgresql'
gitlab_rails['db_encoding'] = 'unicode'
gitlab_rails['db_database'] = 'gitlabhq_production'
gitlab_rails['db_username'] = 'gitlab'
gitlab_rails['db_password'] = 'password'
gitlab_rails['db_host'] = 'localhost'
gitlab_rails['db_port'] = '5432'

These configuration options tell GitLab how to connect to the PostgreSQL database.

2. Reconfigure GitLab

Execute the following command in the /etc/gitlab directory:

sudo gitlab-ctl reconfigure

This will make GitLab read /etc/gitlab/ configuration in the gitlab.rb file and make the appropriate changes.

3. Test whether GitLab is connected successfully

After completing the above steps, you can use the following command to test whether GitLab can successfully connect to the PostgreSQL database:

sudo gitlab-rake gitlab:check SANITIZE=true --trace

This command will check GitLab Configure and output the results to the console. If everything is fine, you will see the output "Database config exists? ... yes" and "Database is SQLite ... no". This indicates that GitLab successfully connected to the PostgreSQL database.

Summary

The above are all the steps on how to connect GitLab to the database. With these steps, you'll be able to get GitLab up and running smoothly and start using GitLab's collaboration and version control features.

The above is the detailed content of How to connect to the database after setting up gitlab. For more information, please follow other related articles on the PHP Chinese website!