Movatterモバイル変換

[0]ホーム
URL:

Skip to content

Navigation Menu

Sign in
Appearance settings

Search code, repositories, users, issues, pull requests...

Provide feedback

We read every piece of feedback, and take your input very seriously.

Saved searches

Use saved searches to filter your results more quickly

 Sign up
Appearance settings
This repository was archived by the owner on Dec 12, 2024. It is now read-only.
/devops-composePublic archive

Commit179105c

Browse files
authored
Remove database container (#7)
* Update docker-compose.yml* Update README.md* Update README.md* Rename postgres/create-database.sql to init-postgresql.sql* Delete Dockerfile* Update README.md* Update README.md
1 parente3e8f66 commit179105c

File tree

4 files changed

+19
-23
lines changed

4 files changed

+19
-23
lines changed

‎README.md‎

Lines changed: 16 additions & 8 deletions
Original file line numberDiff line numberDiff line change
@@ -11,7 +11,6 @@ A compose of following Docker containers:
1111
* SonarQube
1212
* Mattermost
1313
* ownCloud
14-
* PostgreSQL
1514
* LDAP
1615

1716

@@ -27,6 +26,14 @@ A *.example.com. 192.168.1.2.
2726

2827
If you do not have a domain, instead use the wildcard DNS service such as xip.io.
2928

29+
###DBMS
30+
31+
Create a PostgreSQL instance. It is recommended to use managed services such as Amazon RDS or Google Cloud SQL for maintenancebility reason. If we are not on cloud, we can add[a PostgreSQL container](https://hub.docker.com/_/postgres/) to the`docker-compose.yml`.
32+
33+
MySQL is also available and works well but[PostgreSQL is recommended for JIRA](https://confluence.atlassian.com/adminjiraserver074/supported-platforms-881683157.html).
34+
35+
Initialize databases and users with[`init-postgresql.sql`](/init-postgresql.sql).
36+
3037
###Instance
3138

3239
Docker Compose and enough swap space are required.
@@ -46,11 +53,12 @@ echo '/swapfile swap swap defaults 0 0' >> /etc/fstab
4653
Run containers. This may take a few minutes.
4754

4855
```bash
49-
#Custom domain
50-
echo'REVERSE_PROXY_DOMAIN_NAME=example.com'> .env
56+
#Database host
57+
echo'DATABASE_HOST=xxxxx.xxxxx.rds.amazonaws.com'>> .env
5158

52-
# Wildcard DNS
53-
echo'REVERSE_PROXY_DOMAIN_NAME=192.168.1.2.xip.io'> .env
59+
# Domain name
60+
echo'REVERSE_PROXY_DOMAIN_NAME=example.com'>> .env# using your DNS
61+
echo'REVERSE_PROXY_DOMAIN_NAME=192.168.1.2.xip.io'>> .env# using xip.io
5462

5563
docker-compose build
5664
docker-compose up -d
@@ -65,7 +73,7 @@ Open http://devops.example.com (concatenate `devops` and domain name).
6573

6674
Open Crowd and configure the database connection.
6775

68-
- Database server:`db`
76+
- Database server:Hostname of the database instance
6977
- Type: PostgreSQL
7078
- Database name:`crowd`
7179
- User:`crowd`
@@ -82,7 +90,7 @@ Add the LDAP directory.
8290

8391
Open JIRA and configure the database connection.
8492

85-
- Database server:`db`
93+
- Database server:Hostname of the database instance
8694
- Type: PostgreSQL
8795
- Database name:`jira`
8896
- User:`jira`
@@ -94,7 +102,7 @@ Add the Crowd server.
94102

95103
Open Confluence and configure the database connection.
96104

97-
- Database server:`db`
105+
- Database server:Hostname of the database instance
98106
- Type: PostgreSQL
99107
- Database name:`confluence`
100108
- User:`confluence`

‎docker-compose.yml‎

Lines changed: 3 additions & 13 deletions
Original file line numberDiff line numberDiff line change
@@ -43,7 +43,7 @@ services:
4343
gitbucket:
4444
image:f99aq8ove/gitbucket
4545
environment:
46-
GITBUCKET_DB_URL:jdbc:postgresql://db/gitbucket
46+
GITBUCKET_DB_URL:jdbc:postgresql://${DATABASE_HOST}/gitbucket
4747
GITBUCKET_DB_USER:gitbucket
4848
GITBUCKET_DB_PASSWORD:gitbucket
4949
volumes:
@@ -65,7 +65,7 @@ services:
6565
environment:
6666
-SONARQUBE_JDBC_USERNAME=sonarqube
6767
-SONARQUBE_JDBC_PASSWORD=sonarqube
68-
-SONARQUBE_JDBC_URL=jdbc:postgresql://db:5432/sonarqube
68+
-SONARQUBE_JDBC_URL=jdbc:postgresql://${DATABASE_HOST}:5432/sonarqube
6969
volumes:
7070
-sonarqube-conf:/opt/sonarqube/conf
7171
-sonarqube-data:/opt/sonarqube/data
@@ -76,7 +76,7 @@ services:
7676
image:mattermost/mattermost-prod-app:3.9.0
7777
environment:
7878
MATTERMOST_ENABLE_SSL:"true"
79-
DB_HOST:db
79+
DB_HOST:${DATABASE_HOST}
8080
MM_DBNAME:mattermost
8181
MM_USERNAME:mattermost
8282
MM_PASSWORD:mattermost
@@ -91,14 +91,6 @@ services:
9191
-owncloud-config:/var/www/html/config
9292
-owncloud-apps:/var/www/html/apps
9393

94-
db:
95-
build:postgres
96-
environment:
97-
POSTGRES_USER:postgres
98-
POSTGRES_PASSWORD:postgres
99-
volumes:
100-
-db-data:/var/lib/postgresql/data
101-
10294
ldap:
10395
image:osixia/openldap
10496
environment:
@@ -146,8 +138,6 @@ volumes:
146138
driver:local
147139
owncloud-apps:
148140
driver:local
149-
db-data:
150-
driver:local
151141
ldap-data:
152142
driver:local
153143
ldap-config:
File renamed without changes.

‎postgres/Dockerfile‎

Lines changed: 0 additions & 2 deletions
This file was deleted.

0 commit comments

Comments
 (0)
[8]ページ先頭
©2009-2025 Movatter.jp