Please describe the issue you're having
If you accept the answer, please mark the topic as [SOLVED] by clicking the tick.

Moderators: RussH, cptr13

Forum rules: Just please remember to play nicely once you walk through the door. You can disagree with us, or any other commenters in this forum, but respect our space and keep your comments directed to the topic at hand.
By jetheurer
#4654
Folks,

I've downloaded the git repo, cd docker/ and run docker-compose up in an attempt to see a local version of OpenCATS.

I'm hitting errors in the marid_db:

```
liz@lizs-MacBook-Pro OpenCATS (master) $ cd docker/
liz@lizs-MacBook-Pro docker (master) $ docker-compose build
opencatsdata uses an image, skipping
php uses an image, skipping
opencats uses an image, skipping
opencatsdb uses an image, skipping
phpmyadmin uses an image, skipping
liz@lizs-MacBook-Pro docker (master) $ docker-compose up
Creating network "docker_default" with the default driver
Pulling opencatsdata (busybox:)...
latest: Pulling from library/busybox
bdbbaa22dec6: Pull complete
Digest: sha256:6915be4043561d64e0ab0f8f098dc2ac48e077fe23f488ac24b665166898115a
Status: Downloaded newer image for busybox:latest
Pulling php (opencats/php:5.6.27-fpm-alpine)...
5.6.27-fpm-alpine: Pulling from opencats/php
3690ec4760f9: Pull complete
67654b7bd8a6: Pull complete
b6c453327105: Pull complete
481e68959c15: Pull complete
35a81aac8d86: Pull complete
447081b2c4e0: Pull complete
565c21387a1b: Pull complete
54238a021d49: Pull complete
5b5a6c6c8406: Pull complete
6c307924132e: Pull complete
c6a225e35253: Pull complete
ba3dbab454e8: Pull complete
d3acd398b662: Pull complete
4243eb4599ac: Pull complete
d1de734a8fc8: Pull complete
e1f78bf8496b: Pull complete
Digest: sha256:2ce44a00c499691ff86a12debe074487a02593b94846638175cd010a6d32d60a
Status: Downloaded newer image for opencats/php:5.6.27-fpm-alpine
Pulling opencats (prooph/nginx:www)...
www: Pulling from prooph/nginx
9d48c3bd43c5: Pull complete
13bf8394c846: Pull complete
69672a100295: Pull complete
4b57b41163fe: Pull complete
Digest: sha256:43ebf7de649b41ebd05eddd3fb271b74e59ae4131b765535c328a2b21e28e89b
Status: Downloaded newer image for prooph/nginx:www
Pulling opencatsdb (mariadb:)...
latest: Pulling from library/mariadb
5c939e3a4d10: Pull complete
c63719cdbe7a: Pull complete
19a861ea6baf: Pull complete
651c9d2d6c4f: Pull complete
077e14009561: Pull complete
5f038f59a326: Pull complete
1b0216466f21: Pull complete
1b0570aa273a: Pull complete
07d05628c2aa: Pull complete
8f2f7d8e5cbd: Pull complete
fbf3ad7b2eec: Pull complete
22080b3a46be: Pull complete
8021ad8acbef: Pull complete
0b1f06407ccd: Pull complete
Digest: sha256:6f80d059050b80fd8bd951323f6e4a7dde36d62e355cf01b92d26c34d3f702f6
Status: Downloaded newer image for mariadb:latest
Pulling phpmyadmin (phpmyadmin/phpmyadmin:)...
latest: Pulling from phpmyadmin/phpmyadmin
8ec398bc0356: Already exists
85cf4fc86478: Pull complete
970dadf4ccb6: Pull complete
8c04561117a4: Pull complete
d6b7434b63a2: Pull complete
83d8859e9744: Pull complete
9c3d824d0ad5: Pull complete
0ff2f3c2c8ab: Pull complete
f7a2cdcb0840: Pull complete
fe8c2411b50b: Pull complete
aa0cb4375001: Pull complete
96198bf1ad68: Pull complete
5fe54d7827f9: Pull complete
b14701794f98: Pull complete
017ea991a64c: Pull complete
b9fac930b192: Pull complete
1807d0d7270b: Pull complete
5fe7c1ba6fbd: Pull complete
Digest: sha256:2eccbe375bffb5ddd9cf63a4544c9a48a78b1a8138b728cb0af1e0d4937a340a
Status: Downloaded newer image for phpmyadmin/phpmyadmin:latest
Creating opencats_mariadb ... done
Creating opencats_data ... done
Creating opencats_web ... done
Creating opencats_php ... done
Creating opencats_phpmyadmin ... done
Attaching to opencats_data, opencats_mariadb, opencats_php, opencats_web, opencats_phpmyadmin
opencats_php | [06-Feb-2020 17:07:39] NOTICE: fpm is running, pid 1
opencats_mariadb | 2020-02-06 17:07:38+00:00 [Note] [Entrypoint]: Entrypoint script for MySQL Server 1:10.4.12+maria~bionic started.
opencats_php | [06-Feb-2020 17:07:39] NOTICE: ready to handle connections
opencats_mariadb | 2020-02-06 17:07:38+00:00 [Note] [Entrypoint]: Switching to dedicated user 'mysql'
opencats_mariadb | 2020-02-06 17:07:38+00:00 [Note] [Entrypoint]: Entrypoint script for MySQL Server 1:10.4.12+maria~bionic started.
opencats_phpmyadmin | phpMyAdmin not found in /var/www/html - copying now...
opencats_data exited with code 0
opencats_mariadb | 2020-02-06 17:07:39+00:00 [Note] [Entrypoint]: Initializing database files
opencats_phpmyadmin | Complete! phpMyAdmin has been successfully copied to /var/www/html
opencats_phpmyadmin | AH00558: apache2: Could not reliably determine the server's fully qualified domain name, using 172.18.0.5. Set the 'ServerName' directive globally to suppress this message
opencats_phpmyadmin | AH00558: apache2: Could not reliably determine the server's fully qualified domain name, using 172.18.0.5. Set the 'ServerName' directive globally to suppress this message
opencats_phpmyadmin | [Thu Feb 06 17:07:39.654212 2020] [mpm_prefork:notice] [pid 1] AH00163: Apache/2.4.38 (Debian) PHP/7.4.1 configured -- resuming normal operations
opencats_phpmyadmin | [Thu Feb 06 17:07:39.654305 2020] [core:notice] [pid 1] AH00094: Command line: 'apache2 -D FOREGROUND'
opencats_mariadb |
opencats_mariadb |
opencats_mariadb | PLEASE REMEMBER TO SET A PASSWORD FOR THE MariaDB root USER !
opencats_mariadb | To do so, start the server, then issue the following commands:
opencats_mariadb |
opencats_mariadb | '/usr/bin/mysqladmin' -u root password 'new-password'
opencats_mariadb | '/usr/bin/mysqladmin' -u root -h password 'new-password'
opencats_mariadb |
opencats_mariadb | Alternatively you can run:
opencats_mariadb | '/usr/bin/mysql_secure_installation'
opencats_mariadb |
opencats_mariadb | which will also give you the option of removing the test
opencats_mariadb | databases and anonymous user created by default. This is
opencats_mariadb | strongly recommended for production servers.
opencats_mariadb |
opencats_mariadb | See the MariaDB Knowledgebase at http://mariadb.com/kb or the
opencats_mariadb | MySQL manual for more instructions.
opencats_mariadb |
opencats_mariadb | Please report any problems at http://mariadb.org/jira
opencats_mariadb |
opencats_mariadb | The latest information about MariaDB is available at http://mariadb.org/.
opencats_mariadb | You can find additional information about the MySQL part at:
opencats_mariadb | http://dev.mysql.com
opencats_mariadb | Consider joining MariaDB's strong and vibrant community:
opencats_mariadb | https://mariadb.org/get-involved/
opencats_mariadb |
opencats_mariadb | 2020-02-06 17:07:52+00:00 [Note] [Entrypoint]: Database files initialized
opencats_mariadb | 2020-02-06 17:07:52+00:00 [Note] [Entrypoint]: Starting temporary server
opencats_mariadb | 2020-02-06 17:07:52+00:00 [Note] [Entrypoint]: Waiting for server startup
opencats_mariadb | 2020-02-06 17:07:52 0 [Note] mysqld (mysqld 10.4.12-MariaDB-1:10.4.12+maria~bionic) starting as process 123 ...
opencats_mariadb | 2020-02-06 17:07:52 0 [Note] InnoDB: Using Linux native AIO
opencats_mariadb | 2020-02-06 17:07:52 0 [Note] InnoDB: Mutexes and rw_locks use GCC atomic builtins
opencats_mariadb | 2020-02-06 17:07:52 0 [Note] InnoDB: Uses event mutexes
opencats_mariadb | 2020-02-06 17:07:52 0 [Note] InnoDB: Compressed tables use zlib 1.2.11
opencats_mariadb | 2020-02-06 17:07:52 0 [Note] InnoDB: Number of pools: 1
opencats_mariadb | 2020-02-06 17:07:52 0 [Note] InnoDB: Using SSE2 crc32 instructions
opencats_mariadb | 2020-02-06 17:07:52 0 [Note] mysqld: O_TMPFILE is not supported on /tmp (disabling future attempts)
opencats_mariadb | 2020-02-06 17:07:52 0 [Note] InnoDB: Initializing buffer pool, total size = 256M, instances = 1, chunk size = 128M
opencats_mariadb | 2020-02-06 17:07:52 0 [Note] InnoDB: Completed initialization of buffer pool
opencats_mariadb | 2020-02-06 17:07:52 0 [Note] InnoDB: If the mysqld execution user is authorized, page cleaner thread priority can be changed. See the man page of setpriority().
opencats_mariadb | 2020-02-06 17:07:52 0 [Note] InnoDB: 128 out of 128 rollback segments are active.
opencats_mariadb | 2020-02-06 17:07:52 0 [Note] InnoDB: Creating shared tablespace for temporary tables
opencats_mariadb | 2020-02-06 17:07:52 0 [Note] InnoDB: Setting file './ibtmp1' size to 12 MB. Physically writing the file full; Please wait ...
opencats_mariadb | 2020-02-06 17:07:53 0 [Note] InnoDB: File './ibtmp1' size is now 12 MB.
opencats_mariadb | 2020-02-06 17:07:53 0 [Note] InnoDB: 10.4.12 started; log sequence number 60972; transaction id 21
opencats_mariadb | 2020-02-06 17:07:53 0 [Note] Plugin 'FEEDBACK' is disabled.
opencats_mariadb | 2020-02-06 17:07:53 0 [Note] InnoDB: Loading buffer pool(s) from /var/lib/mysql/ib_buffer_pool
opencats_mariadb | 2020-02-06 17:07:53 0 [Note] InnoDB: Buffer pool(s) load completed at 200206 17:07:53
opencats_mariadb | 2020-02-06 17:07:53 0 [Warning] 'user' entry 'root@58953ea0ceab' ignored in --skip-name-resolve mode.
opencats_mariadb | 2020-02-06 17:07:53 0 [Warning] 'user' entry '@58953ea0ceab' ignored in --skip-name-resolve mode.
opencats_mariadb | 2020-02-06 17:07:53 0 [Warning] 'proxies_priv' entry '@% root@58953ea0ceab' ignored in --skip-name-resolve mode.
opencats_mariadb | 2020-02-06 17:07:53 0 [Note] Reading of all Master_info entries succeeded
opencats_mariadb | 2020-02-06 17:07:53 0 [Note] Added new Master_info '' to hash table
opencats_mariadb | 2020-02-06 17:07:53 0 [Note] mysqld: ready for connections.
opencats_mariadb | Version: '10.4.12-MariaDB-1:10.4.12+maria~bionic' socket: '/var/run/mysqld/mysqld.sock' port: 0 mariadb.org binary distribution
opencats_mariadb | 2020-02-06 17:07:54+00:00 [Note] [Entrypoint]: Temporary server started.
opencats_mariadb | Warning: Unable to load '/usr/share/zoneinfo/leap-seconds.list' as time zone. Skipping it.
opencats_mariadb | 2020-02-06 17:08:02 10 [Warning] 'proxies_priv' entry '@% root@58953ea0ceab' ignored in --skip-name-resolve mode.
opencats_mariadb | 2020-02-06 17:08:02+00:00 [Note] [Entrypoint]: Creating database cats
opencats_mariadb | 2020-02-06 17:08:02+00:00 [Note] [Entrypoint]: Creating user dev
opencats_mariadb | 2020-02-06 17:08:02+00:00 [Note] [Entrypoint]: Giving user dev access to schema cats
opencats_mariadb | 2020-02-06 17:08:02 14 [Warning] 'proxies_priv' entry '@% root@58953ea0ceab' ignored in --skip-name-resolve mode.
opencats_mariadb |
opencats_mariadb | 2020-02-06 17:08:02+00:00 [Note] [Entrypoint]: /usr/local/bin/docker-entrypoint.sh: running /docker-entrypoint-initdb.d/securityTests.sql
opencats_mariadb | ERROR 1146 (42S02) at line 2: Table 'cats.user' doesn't exist
opencats_mariadb exited with code 1
```

It's essential to keep these synchronized to ensur[…]

Export part in Job Order order search

Same problem as mine. Maybe you're right, I'll che[…]

The error message you're encountering indicates th[…]

Errors restoring mysqldump backup

doesnot work for me