s-chb

SHOW TOPICS;
SHOW TABLES;
SHOW QUERIES;
SHOW STREAMS;

s-chb

docker exec -it ksqldb-cli ksql http://ksqldb-server:8088

s-chb

ALTER TABLE act_hi_taskinst  ADD COLUMN id INT NOT NULL DEFAULT 0 ;

s-chb

docker exec -it postgres psql -U camunda
SELECT * FROM act_hi_taskinst;

s-chb

docker stop $(docker ps -a -q) &&
docker rm $(docker ps -a -q) &&
docker-compose up -d

s-chb

wget -qO - https://packages.confluent.io/deb/4.0/archive.key | sudo apt-key add -
sudo add-apt-repository "deb [arch=amd64] https://packages.confluent.io/deb/4.0 stable main"
sudo apt-get update && sudo apt-get install confluent-platform-2.11

s-chb

export CONFLUENT_HOME=$HOME/confluent-platform/confluent-5.5.1
export PATH=$PATH:$CONFLUENT_HOME/bin

s-chb

confluent-hub install confluentinc/kafka-connect-jdbc:5.5.0
confluent-hub install jcustenborder/kafka-connect-spooldir:latest
confluent-hub install castorm/kafka-connect-http:0.7.6

s-chb

git clone https://github.com/confluentinc/cp-all-in-one
cd cp-all-in-one
git checkout 5.5.1-post
cd cp-all-in-one/

s-chb

Based on the docker's configuration, you can access the postgres camunda database as follows: 

1. Go to http://localhost:8080/h2/h2
2. Login with the following data:

    Saved Settings: Generic PostgreSQL
    Setting NAME: Generic PostgreSQL
    Driver Class: org.postgresql.Driver
    JDBC URL: jdbc:postgresql://postgres:5432/camunda
    User: camunda