sh -c 'echo "deb https://apt.postgresql.org/pub/repos/apt $(lsb_release -cs)-pgdg main" > /etc/apt/sources.list.
d/pgdg.list'
wget --quiet -O - https://www.postgresql.org/media/keys/ACCC4CF8.asc | apt-key add -
apt install -y gnupg2
apt update
apt install postgresql-13 -y
su - postgres
psql -c "ALTER USER postgres WITH PASSWORD 'strong_password';"
sudo -u postgres psql
postgres=# create user low_code_user with password 'strong_password_specify_on_your_own';
postgres=# create database low_code_db with owner low_code_user ENCODING 'UTF8' LC_COLLATE 'en_US.UTF-8'
LC_CTYPE 'en_US.UTF-8';
postgres=# grant all privileges on database low_code_db to low_code_user;
\q
user@developer-pc:~$ scp ~/low_code_db.dmp root@SERVER_DB:~/dumps
pg_restore --host=localhost --username=low_code_user --format=custom --dbname=low_code_db --schema=public --no
owner low_code_db.dmp
vacuum analyze;
apt update
apt full-upgrade -y
apt install ca-certificates curl gnupg2 lsb-release
install -m 0755 -d /etc/apt/keyrings
curl -fsSL https://download.docker.com/linux/debian/gpg | sudo gpg --dearmor -o /etc/apt/keyrings/docker.gpg
echo \ "deb [arch="$(dpkg --print-architecture)" signed-by=/etc/apt/keyrings/docker.gpg] https://download.
docker.com/linux/debian \ $(lsb_release -cs) stable" | \ sudo tee /etc/apt/sources.list.d/docker.list > /dev
/null
apt update
apt install docker-ce docker-ce-cli containerd.io docker-buildx-plugin docker-compose-plugin
docker login -u <YOUR_USERNAME> -p <YOUR_PASSWORD> dockerhub.greendatasoft.ru
docker pull dockerhub.greendatasoft.ru/public/platform:latest
cd ~
mkdir redis
cd redis/
nano docker-compose.yml
# Copyright Broadcom, Inc. All Rights Reserved.
# SPDX-License-Identifier: APACHE-2.0
version: '2'
services:
redis01:
image: docker.io/bitnami/redis:latest
environment:
# ALLOW_EMPTY_PASSWORD is recommended only for development.
- ALLOW_EMPTY_PASSWORD=yes
- REDIS_DISABLE_COMMANDS=FLUSHDB,FLUSHALL
ports:
- '6378:6379'
volumes:
- 'redis01_data:/bitnami/redis/data'
docker compose up -d docker-compose.yml
docker run -p 6377:6379 --name redis02 -d redis redis-server --save 60 1 --loglevel warning
cd ~
mkdir -p apps/lowcode
cd apps/lowcode
touch app.yml
touch secret_variable.csv
touch docker-compose.yml
server:
# the port on which the application runs inside the docker container
port: 8080
spring:
profiles:
# active application profile
active: prod
datasource:
# jdbc database connection string (PostgreSQL)
url: jdbc:postgresql://localhost:5432/low_code_db
# username to connect to the database
username: low_code_user
# user password to connect to the database
password: <strong_password_specify_on_your_own>
# dialect (PostgreSQL)
jpa.properties.hibernate.dialect: org.hibernate.dialect.PostgreSQL9Dialect
greendata-core:
security:
# place to store secret variables
secretVariableFile: config/secret_variable.csv
# the address where users will log in to the system. Needed to correctly construct http-links, e.g. when
sending e-mails
url: 'https://<your_address>'
# optional if using https reverse proxy to make WebSocket work
allowedOrigins: '*'
http:
sessionStorage:
type: REDIS
redis:
#
address: redis://localhost:6378
# , 0
#database: 0
# ,
#password: password
cache:
remote:
type: REDIS
redis:
#
address: redis://localhost:6378
# , 0
#database: 0
# ,
#password: password
sip:
enabled: true
url: https://sipgateway.greendata.store
version: '3.9'
services:
lowcode:
# ,
restart: unless-stopped
#
image: dockerhub.greendatasoft.ru/public/platform:latest
environment:
JAVA_OPTS: '-Xmx8g -XX:-UseCompressedClassPointers'
RUN_ARGS: '--spring.config.additional-location=/app.yml'
# , - ( )
volumes:
- ./app.yml:/app.yml
- ./license.txt:/license.txt
- ./logs:/logs
- ./secret_variable.csv:/secret_variable.csv
#
container_name: lowcode
#
network_mode: 'host'
#
logging:
#
driver: none
docker compose up -d
docker start lowcode
docker stop lowcode
docker restart lowcode
curl http://localhost:8080/auth/login