Built and deployed OCSinventory server and db docker containers by cloning https://github.com/OCSInventory-NG/OCSInventory-Server.
I changed the default root and ocs passwords in: docker-compose.yml and ran: sh setup.sh
ocsinventory-server as far as I can tell is working.
ocsinventory-db refuses the passwords defined in docker-compose.yml:
From docker host:
$ docker exec -it ocsinventory-db mysql -uroot -p
Enter password: <copied/pasted root password from docker-compose.yml>
ERROR 1045 (28000): Access denied for user 'root'@'localhost' (using password: YES)
$ docker exec -it ocsinventory-db mysql -uocs -p
Enter password: <copied/pasted ocs password from docker-compose.yml>
ERROR 1045 (28000): Access denied for user 'ocs'@'localhost' (using password: YES)
$ docker logs ocsinventory-db
2017-05-02T07:14:45.857852Z 0 [Warning] TIMESTAMP with implicit DEFAULT value is deprecated. Please use --explicit_defaults_for_timestamp server option (see documentation for more details).
2017-05-02T07:14:45.860873Z 0 [Note] mysqld (mysqld 5.7.18) starting as process 1 ...
2017-05-02T07:14:45.865287Z 0 [Note] InnoDB: PUNCH HOLE support available
2017-05-02T07:14:45.865361Z 0 [Note] InnoDB: Mutexes and rw_locks use GCC atomic builtins
2017-05-02T07:14:45.865367Z 0 [Note] InnoDB: Uses event mutexes
2017-05-02T07:14:45.865370Z 0 [Note] InnoDB: GCC builtin __atomic_thread_fence() is used for memory barrier
2017-05-02T07:14:45.865373Z 0 [Note] InnoDB: Compressed tables use zlib 1.2.3
2017-05-02T07:14:45.865376Z 0 [Note] InnoDB: Using Linux native AIO
2017-05-02T07:14:45.865846Z 0 [Note] InnoDB: Number of pools: 1
2017-05-02T07:14:45.866079Z 0 [Note] InnoDB: Using CPU crc32 instructions
2017-05-02T07:14:45.869596Z 0 [Note] InnoDB: Initializing buffer pool, total size = 128M, instances = 1, chunk size = 128M
2017-05-02T07:14:45.882667Z 0 [Note] InnoDB: Completed initialization of buffer pool
2017-05-02T07:14:45.885792Z 0 [Note] InnoDB: If the mysqld execution user is authorized, page cleaner thread priority can be changed. See the man page of setpriority().
2017-05-02T07:14:45.900591Z 0 [Note] InnoDB: Highest supported file format is Barracuda.
2017-05-02T07:14:45.928628Z 0 [Note] InnoDB: Creating shared tablespace for temporary tables
2017-05-02T07:14:45.928728Z 0 [Note] InnoDB: Setting file './ibtmp1' size to 12 MB. Physically writing the file full; Please wait ...
2017-05-02T07:14:46.050479Z 0 [Note] InnoDB: File './ibtmp1' size is now 12 MB.
2017-05-02T07:14:46.051799Z 0 [Note] InnoDB: 96 redo rollback segment(s) found. 96 redo rollback segment(s) are active.
2017-05-02T07:14:46.051812Z 0 [Note] InnoDB: 32 non-redo rollback segment(s) are active.
2017-05-02T07:14:46.052101Z 0 [Note] InnoDB: Waiting for purge to start
2017-05-02T07:14:46.102685Z 0 [Note] InnoDB: 5.7.18 started; log sequence number 12920473
2017-05-02T07:14:46.103264Z 0 [Note] InnoDB: Loading buffer pool(s) from /var/lib/mysql/ib_buffer_pool
2017-05-02T07:14:46.104217Z 0 [Note] Plugin 'FEDERATED' is disabled.
2017-05-02T07:14:46.111938Z 0 [Note] InnoDB: Buffer pool(s) load completed at 170502 7:14:46
2017-05-02T07:14:46.112786Z 0 [Note] Found ca.pem, server-cert.pem and server-key.pem in data directory. Trying to enable SSL support using them.
2017-05-02T07:14:46.113204Z 0 [Warning] CA certificate ca.pem is self signed.
2017-05-02T07:14:46.115956Z 0 [Note] Server hostname (bind-address): '*'; port: 3306
2017-05-02T07:14:46.116052Z 0 [Note] IPv6 is available.
2017-05-02T07:14:46.116060Z 0 [Note] - '::' resolves to '::';
2017-05-02T07:14:46.116077Z 0 [Note] Server socket created on IP: '::'.
2017-05-02T07:14:46.180232Z 0 [Note] Event Scheduler: Loaded 0 events
2017-05-02T07:14:46.180730Z 0 [Note] mysqld: ready for connections.
Version: '5.7.18' socket: '/var/run/mysqld/mysqld.sock' port: 3306 MySQL Community Server (GPL)
2017-05-02T07:14:46.180742Z 0 [Note] Executing 'SELECT * FROM INFORMATION_SCHEMA.TABLES;' to get a list of tables using the deprecated partition engine. You may use the startup option '--disable-partition-engine-check' to skip this check.
2017-05-02T07:14:46.180745Z 0 [Note] Beginning of list of non-natively partitioned tables
2017-05-02T07:14:46.210410Z 0 [Note] End of list of non-natively partitioned tables
2017-05-02T07:16:31.283652Z 3 [Note] Access denied for user 'root'@'localhost' (using password: YES)
2017-05-02T07:25:26.914955Z 4 [Note] Access denied for user 'ocs'@'ocsinventory-server.ocsinventorydockerstack_default' (using password: YES)
2017-05-02T07:41:19.637730Z 5 [Note] Access denied for user 'ocs'@'localhost' (using password: YES)
2017-05-02T08:00:19.598549Z 6 [Note] Access denied for user 'root'@'localhost' (using password: YES)
$ docker logs ocsinventory-server
AH00558: apache2: Could not reliably determine the server's fully qualified domain name, using 172.18.0.3. Set the 'ServerName' directive globally to suppress this message
$ docker images | grep 'ocs\|mysql'
mysql 5.7 9e64176cd8a2 7 days ago 407 MB
ocsinventory/ocsinventory-docker-image latest 5691548a221e 6 weeks ago 406 MB
Can anyone assist in identifying the root cause of the issue with the ocsinventory containers, and resolve it?
