How to launch cattr via docker compose #142

x4IPx · 2023-05-19T11:28:04Z

x4IPx
May 19, 2023

Can't run cattr via docker compose .

 $docker version
Client: Docker Engine - Community
 Version:           24.0.0
 API version:       1.43
 Go version:        go1.20.4
 Git commit:        98fdcd7
 Built:             Mon May 15 18:49:22 2023
 OS/Arch:           linux/amd64
 Context:           default

Server: Docker Engine - Community
 Engine:
  Version:          24.0.0
  API version:      1.43 (minimum version 1.12)
  Go version:       go1.20.4
  Git commit:       1331b8c
  Built:            Mon May 15 18:49:22 2023
  OS/Arch:          linux/amd64
  Experimental:     false
 containerd:
  Version:          1.6.21
  GitCommit:        3dce8eb055cbb6872793272b4f20ed16117344f8
 runc:
  Version:          1.1.7
  GitCommit:        v1.1.7-0-g860f061
 docker-init:
  Version:          0.19.0
  GitCommit:        de40ad0

$docker-compose version
docker-compose version 1.29.2, build unknown
docker-py version: 5.0.3
CPython version: 3.10.6
OpenSSL version: OpenSSL 3.0.2 15 Mar 2022

$docker compose version
Docker Compose version v2.18.0

I use the chapter "Getting started" : https://docs.cattr.app/#/en/getting-started/

wget https://git.amazingcat.net/cattr/core/docker/-/releases/permalink/latest/downloads/installer -O cattr.sh
bash cattr.sh

On request Full URL to backend (API) application (example: http://cattr.acme.corp/):
I write

http://cattr.acme.corp/

As a result I get an error

In Connection.php line 760:

SQLSTATE[42S02]: Base table or view not found: 1146 Table 'cattr.role' doesn't exist (SQL: select * from `role` where (`id` = 1) and `role`.`deleted_at` is null limit 1)


In Exception.php line 18:

SQLSTATE[42S02]: Base table or view not found: 1146 Table 'cattr.role' doesn't exist


In PDOStatement.php line 117:

SQLSTATE[42S02]: Base table or view not found: 1146 Table 'cattr.role' doesn't exist

Answered by DanilShapilov

Jul 11, 2023

Please see this answer #111 (comment)

View full answer

x4IPx · 2023-05-19T11:34:42Z

x4IPx
May 19, 2023
Author

In general, I want to prepare a working docker-compose.yml that can be quickly launched.
For example, now I am using a 2 year old solution: https://hub.docker.com/r/amazingcat/cattr

0 replies

Ibrar-Akhtar · 2023-06-07T11:29:10Z

Ibrar-Akhtar
Jun 7, 2023

@x4IPx Hi, I'm not very familiar with docker, Can you help me with the given issue:
I have run docker compose up -d in the root directory but no container started running. The only thing I got was a single image there and I was not able to run that image.
Thanks!

0 replies

x4IPx · 2023-06-19T12:59:54Z

x4IPx
Jun 19, 2023
Author

@x4IPx Hi, I'm not very familiar with docker, Can you help me with the given issue: I have run docker compose up -d in the root directory but no container started running. The only thing I got was a single image there and I was not able to run that image. Thanks!

Hello.
Unfortunately, I myself can not run cattr through docker compose

0 replies

Ibrar-Akhtar · 2023-06-19T13:20:31Z

Ibrar-Akhtar
Jun 19, 2023

@x4IPx Hi, I'm not very familiar with docker, Can you help me with the given issue: I have run docker compose up -d in the root directory but no container started running. The only thing I got was a single image there and I was not able to run that image. Thanks!

Hello. Unfortunately, I myself can not run cattr through docker compose

ok thanks for your response.
I hope cattr team will make it workable in the future.
@amazing-cat I have spent weeks for making cattr-setup and deployment with docker but got no luck. I was having a situation like bad-fixes.

0 replies

x4IPx · 2023-06-19T14:33:53Z

x4IPx
Jun 19, 2023
Author

ok thanks for your response. I hope cattr team will make it workable in the future. @amazing-cat I have spent weeks for making cattr-setup and deployment with docker but got no luck. I was having a situation like bad-fixes.

You can try to run docker-compose.yml

version: "3.3"
services:
  cattr:
    image: amazingcat/cattr
    restart: always
    ports:
      - "80:80"
    volumes:
      - cattr-db:/var/lib/mysql
      - cattr-config:/app/backend/bootstrap/cache
      - cattr-screenshots:/app/backend/storage/app/uploads/screenshots
      - cattr-ssl:/etc/letsencrypt
    environment:
     FRONTEND_DOMAIN: cattr.test1.lan
     ADMIN_MAIL: you@yourdomen.ru
     FRONTEND_APP_URL: http://cattr.test1.lan
     HTTPS: "false"
     MAIL_FROM_ADDRESS: cattr@yourdomen.ru
volumes:
 cattr-db:
 cattr-config:
 cattr-screenshots:
 cattr-ssl:

But this is a very old but stable version : https://hub.docker.com/r/amazingcat/cattr/tags
Only client Cattr 2.6.6 works with this version

0 replies

DanilShapilov · 2023-07-11T11:40:20Z

DanilShapilov
Jul 11, 2023
Maintainer

Please see this answer #111 (comment)

0 replies

x4IPx · 2023-07-12T09:59:52Z

x4IPx
Jul 12, 2023
Author

git clone https://github.com/cattr-app/server-application.git
cd server-application
docker compose -f docker-compose2.yml up  -d

docker-compose2.yml

version: '3.9'

services:
    app:
        build: .
        depends_on:
            db:
                condition: service_healthy

        ports:
            - 80:80
    db:
        image: percona:latest
        environment:
            - MYSQL_DATABASE=cattr
            - MYSQL_ROOT_PASSWORD=password
        cap_add:
            - SYS_NICE
        volumes:
            - database:/var/lib/mysql
        healthcheck:
            test: ['CMD', 'mysqladmin', 'ping', '-h', 'localhost', '--password=password', '-u', 'root']
            timeout: 20s
            retries: 10

volumes:
    database: {}

I get an error when starting

docker ps
CONTAINER ID   IMAGE                    COMMAND                  CREATED         STATUS                   PORTS                               NAMES
a151ddbd0c8f   server-application-app   "/init"                  5 minutes ago   Up 4 minutes             0.0.0.0:80->80/tcp, :::80->80/tcp   server-application-app-1
af76cc6258e0   percona:latest           "/docker-entrypoint.…"   20 hours ago    Up 5 minutes (healthy)   3306/tcp                            server-application-db-1

curl http://192.168.77.34/
<html>
<head><title>502 Bad Gateway</title></head>
<body>
<center><h1>502 Bad Gateway</h1></center>
<hr><center>nginx</center>
</body>
</html>

docker logs server-application-app-1

  2019_03_26_113406_add_user_last_time_usage_view ................... 5ms DONE
  2019_04_26_084335_make_description_nullable ..................... 163ms DONE
  2019_04_26_112522_add_comment_to_task ........................... 524ms DONE
  2019_05_28_125455_remove_firstname_and_lastname ................. 404ms DONE
  2019_07_22_120600_drop_relations_users_table ..................... 16ms DONE
  2019_08_08_142801_add_change_password_to_user ................... 279ms DONE
  2019_08_12_091905_create_gitlab_projects_relations_table ........ 272ms DONE
  2019_08_12_091921_create_gitlab_tasks_relations_table ........... 255ms DONE
  2019_09_04_050531_add_multiply_roles .......................... 1,212ms DONE
  2019_09_24_054346_fix_project_report_view ......................... 3ms DONE
  2019_10_15_092422_drop_level_column_from_users .................. 235ms DONE
  2019_10_24_024043_add_is_administrator_column_to_users_table .... 105ms DONE
  2019_10_25_084958_add_is_manual_to_time_intervals ............... 286ms DONE
  2019_10_31_132937_add_foreign_key_to_tokens ..................... 461ms DONE
  2019_11_29_071129_add_role_to_users
All roles set to users.
........................... 1,010ms DONE
  2019_12_11_095546_add_issue_iid_column ........................... 92ms DONE
  2019_12_12_063757_create_gitlab_intervals ........................ 61ms DONE
  2019_12_14_000001_create_personal_access_tokens_table ........... 283ms DONE
  2019_12_16_140349_add_index_to_role_table ........................ 76ms DONE
  2019_12_19_094440_fix_for_project_report_view ..................... 3ms DONE
  2019_12_20_023630_add_entity_type_entity_name_index_to_properties_table  25ms DONE
  2019_12_20_050918_add_index_to_deleted_at_to_screenshots_table ... 24ms DONE
  2019_12_20_073840_fix_project_report .............................. 3ms DONE
  2019_12_24_013902_add_foreign_key_and_index_to_tasks_table ...... 950ms DONE
  2020_01_14_061358_fixes_for_roles ................................. 1ms DONE
  2020_01_15_110213_add_user_language_column ...................... 302ms DONE
  2020_01_31_101101_add_role_to_user_role ........................... 1ms DONE
  2020_02_04_080909_fix_user_roles .................................. 1ms DONE
  2020_02_06_080530_add_user_permissions ............................ 0ms DONE
  2020_02_10_092114_drop_index_on_deleted_at ...................... 157ms DONE
  2020_02_12_081847_add_intervals_bulk_edit_rule_to_managers ........ 0ms DONE
  2020_02_12_134247_recreate_roles .................................. 0ms DONE
  2020_02_18_104344_fix_recreate_roles .............................. 0ms DONE
  2020_02_18_121448_add_task_edit_rule_to_users ..................... 1ms DONE
  2020_03_10_065430_add_user_type ................................. 102ms DONE
  2020_03_21_064304_create_jobs_table ............................. 190ms DONE
  2020_03_21_071658_create_failed_jobs_table ...................... 144ms DONE
  2020_03_24_064952_add_project_source ............................ 221ms DONE
  2020_05_06_054551_add_invitation_sent_column_to_users ........... 110ms DONE
  2020_05_19_121037_rename_registration_table ...................... 76ms DONE
  2020_05_20_055253_add_role_id_to_invitations .................... 408ms DONE
  2020_05_27_041722_create_settings_table ......................... 158ms DONE
  2020_05_27_081013_migrate_company_settings_from_properties_to_settings_table  0ms DONE
  2020_05_28_090350_migrate_settings_from_properties_table .......... 0ms DONE
  2020_06_01_104535_migrate_redmine_settings_from_properties_table .. 1ms DONE
  2020_07_07_145309_change_users_table ............................ 239ms DONE
  2020_07_08_073438_drop_time_durations_cache ..................... 100ms DONE
  2020_07_08_132148_add_activity_columns_to_time_intervals_table .. 534ms DONE
  2020_07_15_074343_drop_tokens_table ............................. 112ms DONE
  2020_07_15_094948_user_auth_nonce ............................... 268ms DONE
s6-rc: fatal: timed out
s6-sudoc: fatal: unable to get exit status from server: Operation timed out
time="2023-07-12T09:43:00Z" level=info msg=starting iteration=0 job.command="php /app/artisan schedule:run" job.position=0 job.schedule="* * * * *"
time="2023-07-12T09:43:00Z" level=info channel=stdout iteration=0 job.command="php /app/artisan schedule:run" job.position=0 job.schedule="* * * * *"
time="2023-07-12T09:43:00Z" level=info msg="  2023-07-12 09:43:00 Running [Callback] ............................ 1ms FAIL" channel=stdout iteration=0 job.command="php /app/artisan schedule:run" job.position=0 job.schedule="* * * * *"
time="2023-07-12T09:43:00Z" level=info channel=stdout iteration=0 job.command="php /app/artisan schedule:run" job.position=0 job.schedule="* * * * *"
time="2023-07-12T09:43:00Z" level=info msg="job succeeded" iteration=0 job.command="php /app/artisan schedule:run" job.position=0 job.schedule="* * * * *"

docker logs server-application-db-1

2023-07-12T09:41:55.770019Z 0 [Note] Shutting down plugin 'XTRADB_READ_VIEW'
2023-07-12T09:41:55.770041Z 0 [Note] Shutting down plugin 'InnoDB'
2023-07-12T09:41:55.770102Z 0 [Note] InnoDB: FTS optimize thread exiting.
2023-07-12T09:41:55.770189Z 0 [Note] InnoDB: Starting shutdown...
2023-07-12T09:41:55.870806Z 0 [Note] InnoDB: Dumping buffer pool(s) to /var/lib/mysql/ib_buffer_pool
2023-07-12T09:41:55.871059Z 0 [Note] InnoDB: Buffer pool(s) dump completed at 230712  9:41:55
2023-07-12T09:41:56.971984Z 0 [Note] InnoDB: Waiting for page_cleaner to finish flushing of buffer pool
2023-07-12T09:41:57.989861Z 0 [Note] InnoDB: Shutdown completed; log sequence number 12338774
2023-07-12T09:41:57.990798Z 0 [Note] InnoDB: Removed temporary tablespace data file: "ibtmp1"
2023-07-12T09:41:57.990845Z 0 [Note] Shutting down plugin 'MEMORY'
2023-07-12T09:41:57.990873Z 0 [Note] Shutting down plugin 'CSV'
2023-07-12T09:41:57.990922Z 0 [Note] Shutting down plugin 'PERFORMANCE_SCHEMA'
2023-07-12T09:41:57.990978Z 0 [Note] Shutting down plugin 'sha256_password'
2023-07-12T09:41:57.991013Z 0 [Note] Shutting down plugin 'mysql_native_password'
2023-07-12T09:41:57.991146Z 0 [Note] Shutting down plugin 'binlog'
2023-07-12T09:41:57.991954Z 0 [Note] mysqld: Shutdown complete


MySQL init process done. Ready for start up.

2023-07-12T09:41:58.180000Z 0 [Warning] TIMESTAMP with implicit DEFAULT value is deprecated. Please use --explicit_defaults_for_timestamp server option (see documentation for more details).
2023-07-12T09:41:58.180830Z 0 [Note] mysqld (mysqld 5.7.35-38) starting as process 1 ...
2023-07-12T09:41:58.182657Z 0 [Note] InnoDB: PUNCH HOLE support available
2023-07-12T09:41:58.182723Z 0 [Note] InnoDB: Mutexes and rw_locks use GCC atomic builtins
2023-07-12T09:41:58.182763Z 0 [Note] InnoDB: Uses event mutexes
2023-07-12T09:41:58.182799Z 0 [Note] InnoDB: GCC builtin __atomic_thread_fence() is used for memory barrier
2023-07-12T09:41:58.182824Z 0 [Note] InnoDB: Compressed tables use zlib 1.2.11
2023-07-12T09:41:58.182858Z 0 [Note] InnoDB: Using Linux native AIO
2023-07-12T09:41:58.183024Z 0 [Note] InnoDB: Number of pools: 1
2023-07-12T09:41:58.183137Z 0 [Note] InnoDB: Using CPU crc32 instructions
2023-07-12T09:41:58.184014Z 0 [Note] InnoDB: Initializing buffer pool, total size = 128M, instances = 1, chunk size = 128M
2023-07-12T09:41:58.186358Z 0 [Note] InnoDB: Completed initialization of buffer pool
2023-07-12T09:41:58.187451Z 0 [Note] InnoDB: If the mysqld execution user is authorized, page cleaner thread priority can be changed. See the man page of setpriority().
2023-07-12T09:41:58.198319Z 0 [Note] InnoDB: Crash recovery did not find the parallel doublewrite buffer at /var/lib/mysql/xb_doublewrite
2023-07-12T09:41:58.198752Z 0 [Note] InnoDB: Highest supported file format is Barracuda.
2023-07-12T09:41:58.255413Z 0 [Note] InnoDB: Created parallel doublewrite buffer at /var/lib/mysql/xb_doublewrite, size 3932160 bytes
2023-07-12T09:41:58.257973Z 0 [Note] InnoDB: Creating shared tablespace for temporary tables
2023-07-12T09:41:58.258100Z 0 [Note] InnoDB: Setting file './ibtmp1' size to 12 MB. Physically writing the file full; Please wait ...
2023-07-12T09:41:58.267469Z 0 [Note] InnoDB: File './ibtmp1' size is now 12 MB.
2023-07-12T09:41:58.268020Z 0 [Note] InnoDB: 96 redo rollback segment(s) found. 96 redo rollback segment(s) are active.
2023-07-12T09:41:58.268076Z 0 [Note] InnoDB: 32 non-redo rollback segment(s) are active.
2023-07-12T09:41:58.268290Z 0 [Note] InnoDB: Waiting for purge to start
2023-07-12T09:41:58.318633Z 0 [Note] InnoDB: Percona XtraDB (http://www.percona.com) 5.7.35-38 started; log sequence number 12338774
2023-07-12T09:41:58.319002Z 0 [Note] Plugin 'FEDERATED' is disabled.
2023-07-12T09:41:58.322256Z 0 [Note] Found ca.pem, server-cert.pem and server-key.pem in data directory. Trying to enable SSL support using them.
2023-07-12T09:41:58.322326Z 0 [Note] Skipping generation of SSL certificates as certificate files are present in data directory.
2023-07-12T09:41:58.322364Z 0 [Warning] A deprecated TLS version TLSv1 is enabled. Please use TLSv1.2 or higher.
2023-07-12T09:41:58.322393Z 0 [Warning] A deprecated TLS version TLSv1.1 is enabled. Please use TLSv1.2 or higher.
2023-07-12T09:41:58.322807Z 0 [Warning] CA certificate ca.pem is self signed.
2023-07-12T09:41:58.322870Z 0 [Note] Skipping generation of RSA key pair as key files are present in data directory.
2023-07-12T09:41:58.323146Z 0 [Note] Server hostname (bind-address): '*'; port: 3306
2023-07-12T09:41:58.323219Z 0 [Note] IPv6 is available.
2023-07-12T09:41:58.323257Z 0 [Note]   - '::' resolves to '::';
2023-07-12T09:41:58.323293Z 0 [Note] Server socket created on IP: '::'.
2023-07-12T09:41:58.323462Z 0 [Note] InnoDB: Loading buffer pool(s) from /var/lib/mysql/ib_buffer_pool
2023-07-12T09:41:58.325260Z 0 [Note] InnoDB: Buffer pool(s) load completed at 230712  9:41:58
2023-07-12T09:41:58.329951Z 0 [Note] Event Scheduler: Loaded 0 events
2023-07-12T09:41:58.330116Z 0 [Note] mysqld: ready for connections.
Version: '5.7.35-38'  socket: '/var/lib/mysql/mysql.sock'  port: 3306  Percona Server (GPL), Release 38, Revision 3692a61

0 replies

DanilShapilov · 2023-07-12T10:56:26Z

DanilShapilov
Jul 12, 2023
Maintainer

@x4IPx error with s6-rc: fatal: timed out was fixed about a month ago, looks like you need to clear some docker cache
UPD: here are the fix c659ceb

0 replies

Provide feedback

Saved searches

Use saved searches to filter your results more quickly

Cattr

How to launch cattr via docker compose #142

{{title}}

{{editor}}'s edit

{{editor}}'s edit

Replies: 8 comments

{{title}}

{{title}}

{{title}}

{{title}}

{{title}}

{{editor}}'s edit

{{editor}}'s edit

{{title}}

{{title}}

{{editor}}'s edit

{{editor}}'s edit

{{title}}

{{editor}}'s edit

{{editor}}'s edit

Select a reply

Cattr

How to launch cattr via docker compose #142

x4IPx May 19, 2023

Replies: 8 comments

x4IPx May 19, 2023 Author

Ibrar-Akhtar Jun 7, 2023

x4IPx Jun 19, 2023 Author

Ibrar-Akhtar Jun 19, 2023

x4IPx Jun 19, 2023 Author

DanilShapilov Jul 11, 2023 Maintainer

x4IPx Jul 12, 2023 Author

DanilShapilov Jul 12, 2023 Maintainer

x4IPx
May 19, 2023

x4IPx
May 19, 2023
Author

Ibrar-Akhtar
Jun 7, 2023

x4IPx
Jun 19, 2023
Author

Ibrar-Akhtar
Jun 19, 2023

x4IPx
Jun 19, 2023
Author

DanilShapilov
Jul 11, 2023
Maintainer

x4IPx
Jul 12, 2023
Author

DanilShapilov
Jul 12, 2023
Maintainer