Welcome to OCS Inventory NG community support, where you can ask questions and receive answers from other members of the community.

Please ask questions only in English or French.

Release 2.8 available

The official documentation can be found on http://wiki.ocsinventory-ng.org. Read it before asking your question.

Docker Container Stack Deployment: Issues with osinventory-db server.

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 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?

in OCS Inventory NG server for Unix by (120 points)

1 Answer

+1 vote
Same exactly problem! How did you solve?
by (160 points)
Powered by Question2Answer