search

UberEther / standalone-docker-sailpoint-iiq

A simple way to deploy SailPoint's IdentityIQ into a series of docker containers mimicking the core components of most development environments allowing organizations to get new development team members up on their baseline code in minutes.
https://uberether.com
GNU General Public License v3.0
45 stars 32 forks source link

mysql as root error #6

Closed mtcoffee closed 3 years ago

mtcoffee commented 3 years ago

The mysql container is complaining about running as root. I'll update if I get this working. https://developpaper.com/please-readsecurity-to-find-out-how-to-run-mysqld-as-root/

Run DB Script

2021-03-25T23:57:14.898808Z 0 [Warning] TIMESTAMP with implicit DEFAULT value is deprecated. Please use --explicit_defaults_for_timestamp server option (see documentation for more details). 2021-03-25T23:57:14.898848Z 0 [Warning] 'NO_AUTO_CREATE_USER' sql mode was not set. 2021-03-25T23:57:14.900163Z 0 [Note] mysqld (mysqld 5.7.33) starting as process 69 ... 2021-03-25T23:57:14.901113Z 0 [ERROR] Fatal error: Please read "Security" section of the manual to find out how to run mysqld as root!

2021-03-25T23:57:14.901131Z 0 [ERROR] Aborting

2021-03-25T23:57:14.901141Z 0 [Note] Binlog end 2021-03-25T23:57:14.902056Z 0 [Note] mysqld: Shutdown complete

volomatt commented 3 years ago

Unable to reproduce, can you provide the full output of this command from uedocker/ICAM-MYSQL

docker build --no-cache -t tmpmysql . && docker run -it tmpmysql

mtcoffee commented 3 years ago

Running on a fresh install of ubuntu 20.04

2021-03-26 17:23:56-04:00 [Note] [Entrypoint]: Entrypoint script for MySQL Server 5.7.33-1debian10 started. 2021-03-26 17:23:56-04:00 [Note] [Entrypoint]: Switching to dedicated user 'mysql' 2021-03-26 17:23:56-04:00 [Note] [Entrypoint]: Entrypoint script for MySQL Server 5.7.33-1debian10 started. 2021-03-26 17:23:56-04:00 [Note] [Entrypoint]: Initializing database files 2021-03-26T21:23:56.817010Z 0 [Warning] TIMESTAMP with implicit DEFAULT value is deprecated. Please use --explicit_defaults_for_timestamp server option (see documentation for more details). 2021-03-26T21:23:56.817051Z 0 [Warning] 'NO_AUTO_CREATE_USER' sql mode was not set. 2021-03-26T21:23:56.819013Z 0 [Warning] InnoDB: Using innodb_file_format is deprecated and the parameter may be removed in future releases. See http://dev.mysql.com/doc/refman/5.7/en/innodb-file-format.html 2021-03-26T21:23:56.819030Z 0 [Warning] InnoDB: Using innodb_file_format_max is deprecated and the parameter may be removed in future releases. See http://dev.mysql.com/doc/refman/5.7/en/innodb-file-format.html 2021-03-26T21:23:57.013250Z 0 [Warning] InnoDB: New log files created, LSN=45790 2021-03-26T21:23:57.041725Z 0 [Warning] InnoDB: Creating foreign key constraint system tables. 2021-03-26T21:23:57.095257Z 0 [Warning] No existing UUID has been found, so we assume that this is the first time that this server has been started. Generating a new UUID: 92db1d19-8e79-11eb-9d08-0242ac110002. 2021-03-26T21:23:57.096114Z 0 [Warning] Gtid table is not ready to be used. Table 'mysql.gtid_executed' cannot be opened. 2021-03-26T21:23:58.208905Z 0 [Warning] CA certificate ca.pem is self signed. 2021-03-26T21:23:58.393278Z 1 [Warning] root@localhost is created with an empty password ! Please consider switching off the --initialize-insecure option. 2021-03-26 17:23:59-04:00 [Note] [Entrypoint]: Database files initialized 2021-03-26 17:23:59-04:00 [Note] [Entrypoint]: Starting temporary server 2021-03-26 17:23:59-04:00 [Note] [Entrypoint]: Waiting for server startup 2021-03-26T21:24:00.134955Z 0 [Warning] TIMESTAMP with implicit DEFAULT value is deprecated. Please use --explicit_defaults_for_timestamp server option (see documentation for more details). 2021-03-26T21:24:00.135208Z 0 [Warning] 'NO_AUTO_CREATE_USER' sql mode was not set. 2021-03-26T21:24:00.136742Z 0 [Note] mysqld (mysqld 5.7.33) starting as process 75 ... 2021-03-26T21:24:00.139086Z 0 [Warning] InnoDB: Using innodb_file_format is deprecated and the parameter may be removed in future releases. See http://dev.mysql.com/doc/refman/5.7/en/innodb-file-format.html 2021-03-26T21:24:00.139107Z 0 [Warning] InnoDB: Using innodb_file_format_max is deprecated and the parameter may be removed in future releases. See http://dev.mysql.com/doc/refman/5.7/en/innodb-file-format.html 2021-03-26T21:24:00.139262Z 0 [Note] InnoDB: PUNCH HOLE support available 2021-03-26T21:24:00.139288Z 0 [Note] InnoDB: Mutexes and rw_locks use GCC atomic builtins 2021-03-26T21:24:00.139477Z 0 [Note] InnoDB: Uses event mutexes 2021-03-26T21:24:00.139687Z 0 [Note] InnoDB: GCC builtin __atomic_thread_fence() is used for memory barrier 2021-03-26T21:24:00.139796Z 0 [Note] InnoDB: Compressed tables use zlib 1.2.11 2021-03-26T21:24:00.139989Z 0 [Note] InnoDB: Using Linux native AIO 2021-03-26T21:24:00.140396Z 0 [Note] InnoDB: Number of pools: 1 2021-03-26T21:24:00.140588Z 0 [Note] InnoDB: Using CPU crc32 instructions 2021-03-26T21:24:00.141819Z 0 [Note] InnoDB: Initializing buffer pool, total size = 256M, instances = 1, chunk size = 128M 2021-03-26T21:24:00.154414Z 0 [Note] InnoDB: Completed initialization of buffer pool 2021-03-26T21:24:00.158123Z 0 [Note] InnoDB: If the mysqld execution user is authorized, page cleaner thread priority can be changed. See the man page of setpriority(). 2021-03-26T21:24:00.173308Z 0 [Note] InnoDB: Highest supported file format is Barracuda. 2021-03-26T21:24:00.184730Z 0 [Note] InnoDB: Creating shared tablespace for temporary tables 2021-03-26T21:24:00.184776Z 0 [Note] InnoDB: Setting file './ibtmp1' size to 12 MB. Physically writing the file full; Please wait ... 2021-03-26T21:24:00.199472Z 0 [Note] InnoDB: File './ibtmp1' size is now 12 MB. 2021-03-26T21:24:00.200141Z 0 [Note] InnoDB: 96 redo rollback segment(s) found. 96 redo rollback segment(s) are active. 2021-03-26T21:24:00.200152Z 0 [Note] InnoDB: 32 non-redo rollback segment(s) are active. 2021-03-26T21:24:00.200476Z 0 [Note] InnoDB: Waiting for purge to start 2021-03-26T21:24:00.250673Z 0 [Note] InnoDB: 5.7.33 started; log sequence number 2746831 2021-03-26T21:24:00.251045Z 0 [Note] InnoDB: Loading buffer pool(s) from /var/lib/mysql/ib_buffer_pool 2021-03-26T21:24:00.251447Z 0 [Note] Plugin 'FEDERATED' is disabled. 2021-03-26T21:24:00.252645Z 0 [Note] InnoDB: Buffer pool(s) load completed at 210326 17:24:00 2021-03-26T21:24:00.256572Z 0 [Note] Found ca.pem, server-cert.pem and server-key.pem in data directory. Trying to enable SSL support using them. 2021-03-26T21:24:00.256605Z 0 [Note] Skipping generation of SSL certificates as certificate files are present in data directory. 2021-03-26T21:24:00.257267Z 0 [Warning] CA certificate ca.pem is self signed. 2021-03-26T21:24:00.257388Z 0 [Note] Skipping generation of RSA key pair as key files are present in data directory. 2021-03-26T21:24:00.258315Z 0 [Warning] Insecure configuration for --pid-file: Location '/var/run/mysqld' in the path is accessible to all OS users. Consider choosing a different directory. 2021-03-26T21:24:00.262924Z 0 [Note] Failed to start slave threads for channel '' 2021-03-26T21:24:00.269238Z 0 [Note] Event Scheduler: Loaded 0 events 2021-03-26T21:24:00.269565Z 0 [Note] mysqld: ready for connections. Version: '5.7.33' socket: '/var/run/mysqld/mysqld.sock' port: 0 MySQL Community Server (GPL) 2021-03-26 17:24:00-04:00 [Note] [Entrypoint]: Temporary server started. Warning: Unable to load '/usr/share/zoneinfo/iso3166.tab' as time zone. Skipping it. Warning: Unable to load '/usr/share/zoneinfo/leap-seconds.list' as time zone. Skipping it. Warning: Unable to load '/usr/share/zoneinfo/zone.tab' as time zone. Skipping it. Warning: Unable to load '/usr/share/zoneinfo/zone1970.tab' as time zone. Skipping it.

2021-03-26 17:24:01-04:00 [Note] [Entrypoint]: Stopping temporary server 2021-03-26T21:24:01.933452Z 0 [Note] Giving 0 client threads a chance to die gracefully 2021-03-26T21:24:01.933471Z 0 [Note] Shutting down slave threads 2021-03-26T21:24:01.933475Z 0 [Note] Forcefully disconnecting 0 remaining clients 2021-03-26T21:24:01.933481Z 0 [Note] Event Scheduler: Purging the queue. 0 events 2021-03-26T21:24:01.933618Z 0 [Note] Binlog end 2021-03-26T21:24:01.934093Z 0 [Note] Shutting down plugin 'ngram' 2021-03-26T21:24:01.934178Z 0 [Note] Shutting down plugin 'partition' 2021-03-26T21:24:01.934192Z 0 [Note] Shutting down plugin 'BLACKHOLE' 2021-03-26T21:24:01.934202Z 0 [Note] Shutting down plugin 'ARCHIVE' 2021-03-26T21:24:01.934211Z 0 [Note] Shutting down plugin 'PERFORMANCE_SCHEMA' 2021-03-26T21:24:01.934288Z 0 [Note] Shutting down plugin 'MRG_MYISAM' 2021-03-26T21:24:01.934415Z 0 [Note] Shutting down plugin 'MyISAM' 2021-03-26T21:24:01.934492Z 0 [Note] Shutting down plugin 'INNODB_SYS_VIRTUAL' 2021-03-26T21:24:01.934570Z 0 [Note] Shutting down plugin 'INNODB_SYS_DATAFILES' 2021-03-26T21:24:01.934640Z 0 [Note] Shutting down plugin 'INNODB_SYS_TABLESPACES' 2021-03-26T21:24:01.934740Z 0 [Note] Shutting down plugin 'INNODB_SYS_FOREIGN_COLS' 2021-03-26T21:24:01.934811Z 0 [Note] Shutting down plugin 'INNODB_SYS_FOREIGN' 2021-03-26T21:24:01.934886Z 0 [Note] Shutting down plugin 'INNODB_SYS_FIELDS' 2021-03-26T21:24:01.934988Z 0 [Note] Shutting down plugin 'INNODB_SYS_COLUMNS' 2021-03-26T21:24:01.935026Z 0 [Note] Shutting down plugin 'INNODB_SYS_INDEXES' 2021-03-26T21:24:01.935127Z 0 [Note] Shutting down plugin 'INNODB_SYS_TABLESTATS' 2021-03-26T21:24:01.935203Z 0 [Note] Shutting down plugin 'INNODB_SYS_TABLES' 2021-03-26T21:24:01.935283Z 0 [Note] Shutting down plugin 'INNODB_FT_INDEX_TABLE' 2021-03-26T21:24:01.935381Z 0 [Note] Shutting down plugin 'INNODB_FT_INDEX_CACHE' 2021-03-26T21:24:01.935486Z 0 [Note] Shutting down plugin 'INNODB_FT_CONFIG' 2021-03-26T21:24:01.935557Z 0 [Note] Shutting down plugin 'INNODB_FT_BEING_DELETED' 2021-03-26T21:24:01.935664Z 0 [Note] Shutting down plugin 'INNODB_FT_DELETED' 2021-03-26T21:24:01.935743Z 0 [Note] Shutting down plugin 'INNODB_FT_DEFAULT_STOPWORD' 2021-03-26T21:24:01.935834Z 0 [Note] Shutting down plugin 'INNODB_METRICS' 2021-03-26T21:24:01.935914Z 0 [Note] Shutting down plugin 'INNODB_TEMP_TABLE_INFO' 2021-03-26T21:24:01.936006Z 0 [Note] Shutting down plugin 'INNODB_BUFFER_POOL_STATS' 2021-03-26T21:24:01.936079Z 0 [Note] Shutting down plugin 'INNODB_BUFFER_PAGE_LRU' 2021-03-26T21:24:01.936158Z 0 [Note] Shutting down plugin 'INNODB_BUFFER_PAGE' 2021-03-26T21:24:01.936256Z 0 [Note] Shutting down plugin 'INNODB_CMP_PER_INDEX_RESET' 2021-03-26T21:24:01.936347Z 0 [Note] Shutting down plugin 'INNODB_CMP_PER_INDEX' 2021-03-26T21:24:01.936435Z 0 [Note] Shutting down plugin 'INNODB_CMPMEM_RESET' 2021-03-26T21:24:01.936524Z 0 [Note] Shutting down plugin 'INNODB_CMPMEM' 2021-03-26T21:24:01.936603Z 0 [Note] Shutting down plugin 'INNODB_CMP_RESET' 2021-03-26T21:24:01.936693Z 0 [Note] Shutting down plugin 'INNODB_CMP' 2021-03-26T21:24:01.936773Z 0 [Note] Shutting down plugin 'INNODB_LOCK_WAITS' 2021-03-26T21:24:01.936863Z 0 [Note] Shutting down plugin 'INNODB_LOCKS' 2021-03-26T21:24:01.936943Z 0 [Note] Shutting down plugin 'INNODB_TRX' 2021-03-26T21:24:01.937034Z 0 [Note] Shutting down plugin 'InnoDB' 2021-03-26T21:24:01.937167Z 0 [Note] InnoDB: FTS optimize thread exiting. 2021-03-26T21:24:01.937292Z 0 [Note] InnoDB: Starting shutdown... 2021-03-26T21:24:02.037637Z 0 [Note] InnoDB: Dumping buffer pool(s) to /var/lib/mysql/ib_buffer_pool 2021-03-26T21:24:02.037963Z 0 [Note] InnoDB: Buffer pool(s) dump completed at 210326 17:24:02 2021-03-26T21:24:03.046528Z 0 [Note] InnoDB: Shutdown completed; log sequence number 12680716 2021-03-26T21:24:03.047843Z 0 [Note] InnoDB: Removed temporary tablespace data file: "ibtmp1" 2021-03-26T21:24:03.047984Z 0 [Note] Shutting down plugin 'MEMORY' 2021-03-26T21:24:03.048076Z 0 [Note] Shutting down plugin 'CSV' 2021-03-26T21:24:03.048163Z 0 [Note] Shutting down plugin 'sha256_password' 2021-03-26T21:24:03.048256Z 0 [Note] Shutting down plugin 'mysql_native_password' 2021-03-26T21:24:03.048463Z 0 [Note] Shutting down plugin 'binlog' 2021-03-26T21:24:03.049479Z 0 [Note] mysqld: Shutdown complete

2021-03-26 17:24:03-04:00 [Note] [Entrypoint]: Temporary server stopped

2021-03-26 17:24:03-04:00 [Note] [Entrypoint]: MySQL init process done. Ready for start up.

2021-03-26T21:24:04.126766Z 0 [Warning] TIMESTAMP with implicit DEFAULT value is deprecated. Please use --explicit_defaults_for_timestamp server option (see documentation for more details). 2021-03-26T21:24:04.126807Z 0 [Warning] 'NO_AUTO_CREATE_USER' sql mode was not set. 2021-03-26T21:24:04.127986Z 0 [Note] mysqld (mysqld 5.7.33) starting as process 1 ... 2021-03-26T21:24:04.129986Z 0 [Warning] InnoDB: Using innodb_file_format is deprecated and the parameter may be removed in future releases. See http://dev.mysql.com/doc/refman/5.7/en/innodb-file-format.html 2021-03-26T21:24:04.130115Z 0 [Warning] InnoDB: Using innodb_file_format_max is deprecated and the parameter may be removed in future releases. See http://dev.mysql.com/doc/refman/5.7/en/innodb-file-format.html 2021-03-26T21:24:04.130236Z 0 [Note] InnoDB: PUNCH HOLE support available 2021-03-26T21:24:04.130316Z 0 [Note] InnoDB: Mutexes and rw_locks use GCC atomic builtins 2021-03-26T21:24:04.130415Z 0 [Note] InnoDB: Uses event mutexes 2021-03-26T21:24:04.130463Z 0 [Note] InnoDB: GCC builtin __atomic_thread_fence() is used for memory barrier 2021-03-26T21:24:04.130575Z 0 [Note] InnoDB: Compressed tables use zlib 1.2.11 2021-03-26T21:24:04.130648Z 0 [Note] InnoDB: Using Linux native AIO 2021-03-26T21:24:04.130925Z 0 [Note] InnoDB: Number of pools: 1 2021-03-26T21:24:04.131118Z 0 [Note] InnoDB: Using CPU crc32 instructions 2021-03-26T21:24:04.132371Z 0 [Note] InnoDB: Initializing buffer pool, total size = 256M, instances = 1, chunk size = 128M 2021-03-26T21:24:04.144848Z 0 [Note] InnoDB: Completed initialization of buffer pool 2021-03-26T21:24:04.147762Z 0 [Note] InnoDB: If the mysqld execution user is authorized, page cleaner thread priority can be changed. See the man page of setpriority(). 2021-03-26T21:24:04.159303Z 0 [Note] InnoDB: Highest supported file format is Barracuda. 2021-03-26T21:24:04.166888Z 0 [Note] InnoDB: Creating shared tablespace for temporary tables 2021-03-26T21:24:04.167066Z 0 [Note] InnoDB: Setting file './ibtmp1' size to 12 MB. Physically writing the file full; Please wait ... 2021-03-26T21:24:04.180086Z 0 [Note] InnoDB: File './ibtmp1' size is now 12 MB. 2021-03-26T21:24:04.180632Z 0 [Note] InnoDB: 96 redo rollback segment(s) found. 96 redo rollback segment(s) are active. 2021-03-26T21:24:04.180739Z 0 [Note] InnoDB: 32 non-redo rollback segment(s) are active. 2021-03-26T21:24:04.180991Z 0 [Note] InnoDB: Waiting for purge to start 2021-03-26T21:24:04.231206Z 0 [Note] InnoDB: 5.7.33 started; log sequence number 12680716 2021-03-26T21:24:04.231615Z 0 [Note] InnoDB: Loading buffer pool(s) from /var/lib/mysql/ib_buffer_pool 2021-03-26T21:24:04.231806Z 0 [Note] Plugin 'FEDERATED' is disabled. 2021-03-26T21:24:04.235254Z 0 [Note] InnoDB: Buffer pool(s) load completed at 210326 17:24:04 2021-03-26T21:24:04.236308Z 0 [Note] Found ca.pem, server-cert.pem and server-key.pem in data directory. Trying to enable SSL support using them. 2021-03-26T21:24:04.236431Z 0 [Note] Skipping generation of SSL certificates as certificate files are present in data directory. 2021-03-26T21:24:04.237018Z 0 [Warning] CA certificate ca.pem is self signed. 2021-03-26T21:24:04.237248Z 0 [Note] Skipping generation of RSA key pair as key files are present in data directory. 2021-03-26T21:24:04.237822Z 0 [Note] Server hostname (bind-address): '*'; port: 3306 2021-03-26T21:24:04.238647Z 0 [Note] IPv6 is available. 2021-03-26T21:24:04.238784Z 0 [Note] - '::' resolves to '::'; 2021-03-26T21:24:04.238912Z 0 [Note] Server socket created on IP: '::'. 2021-03-26T21:24:04.239410Z 0 [Warning] Insecure configuration for --pid-file: Location '/var/run/mysqld' in the path is accessible to all OS users. Consider choosing a different directory. 2021-03-26T21:24:04.243773Z 0 [Note] Failed to start slave threads for channel '' 2021-03-26T21:24:04.248626Z 0 [Note] Event Scheduler: Loaded 0 events 2021-03-26T21:24:04.248877Z 0 [Note] mysqld: ready for connections. Version: '5.7.33' socket: '/var/run/mysqld/mysqld.sock' port: 3306 MySQL Community Server (GPL) 2021-03-26T21:24:10.508300Z 0 [Note] Giving 0 client threads a chance to die gracefully 2021-03-26T21:24:10.508326Z 0 [Note] Shutting down slave threads 2021-03-26T21:24:10.508333Z 0 [Note] Forcefully disconnecting 0 remaining clients 2021-03-26T21:24:10.508340Z 0 [Note] Event Scheduler: Purging the queue. 0 events 2021-03-26T21:24:10.508374Z 0 [Note] Binlog end 2021-03-26T21:24:10.508657Z 0 [Note] Shutting down plugin 'ngram' 2021-03-26T21:24:10.508668Z 0 [Note] Shutting down plugin 'partition' 2021-03-26T21:24:10.508674Z 0 [Note] Shutting down plugin 'BLACKHOLE' 2021-03-26T21:24:10.508680Z 0 [Note] Shutting down plugin 'ARCHIVE' 2021-03-26T21:24:10.508684Z 0 [Note] Shutting down plugin 'PERFORMANCE_SCHEMA' 2021-03-26T21:24:10.508703Z 0 [Note] Shutting down plugin 'MRG_MYISAM' 2021-03-26T21:24:10.508708Z 0 [Note] Shutting down plugin 'MyISAM' 2021-03-26T21:24:10.508715Z 0 [Note] Shutting down plugin 'INNODB_SYS_VIRTUAL' 2021-03-26T21:24:10.508721Z 0 [Note] Shutting down plugin 'INNODB_SYS_DATAFILES' 2021-03-26T21:24:10.508725Z 0 [Note] Shutting down plugin 'INNODB_SYS_TABLESPACES' 2021-03-26T21:24:10.508730Z 0 [Note] Shutting down plugin 'INNODB_SYS_FOREIGN_COLS' 2021-03-26T21:24:10.508734Z 0 [Note] Shutting down plugin 'INNODB_SYS_FOREIGN' 2021-03-26T21:24:10.508739Z 0 [Note] Shutting down plugin 'INNODB_SYS_FIELDS' 2021-03-26T21:24:10.508744Z 0 [Note] Shutting down plugin 'INNODB_SYS_COLUMNS' 2021-03-26T21:24:10.508748Z 0 [Note] Shutting down plugin 'INNODB_SYS_INDEXES' 2021-03-26T21:24:10.508753Z 0 [Note] Shutting down plugin 'INNODB_SYS_TABLESTATS' 2021-03-26T21:24:10.508757Z 0 [Note] Shutting down plugin 'INNODB_SYS_TABLES' 2021-03-26T21:24:10.508762Z 0 [Note] Shutting down plugin 'INNODB_FT_INDEX_TABLE' 2021-03-26T21:24:10.508766Z 0 [Note] Shutting down plugin 'INNODB_FT_INDEX_CACHE' 2021-03-26T21:24:10.508771Z 0 [Note] Shutting down plugin 'INNODB_FT_CONFIG' 2021-03-26T21:24:10.508775Z 0 [Note] Shutting down plugin 'INNODB_FT_BEING_DELETED' 2021-03-26T21:24:10.508780Z 0 [Note] Shutting down plugin 'INNODB_FT_DELETED' 2021-03-26T21:24:10.508784Z 0 [Note] Shutting down plugin 'INNODB_FT_DEFAULT_STOPWORD' 2021-03-26T21:24:10.508789Z 0 [Note] Shutting down plugin 'INNODB_METRICS' 2021-03-26T21:24:10.508793Z 0 [Note] Shutting down plugin 'INNODB_TEMP_TABLE_INFO' 2021-03-26T21:24:10.508798Z 0 [Note] Shutting down plugin 'INNODB_BUFFER_POOL_STATS' 2021-03-26T21:24:10.508802Z 0 [Note] Shutting down plugin 'INNODB_BUFFER_PAGE_LRU' 2021-03-26T21:24:10.508807Z 0 [Note] Shutting down plugin 'INNODB_BUFFER_PAGE' 2021-03-26T21:24:10.508811Z 0 [Note] Shutting down plugin 'INNODB_CMP_PER_INDEX_RESET' 2021-03-26T21:24:10.508816Z 0 [Note] Shutting down plugin 'INNODB_CMP_PER_INDEX' 2021-03-26T21:24:10.508821Z 0 [Note] Shutting down plugin 'INNODB_CMPMEM_RESET' 2021-03-26T21:24:10.508825Z 0 [Note] Shutting down plugin 'INNODB_CMPMEM' 2021-03-26T21:24:10.508830Z 0 [Note] Shutting down plugin 'INNODB_CMP_RESET' 2021-03-26T21:24:10.508834Z 0 [Note] Shutting down plugin 'INNODB_CMP' 2021-03-26T21:24:10.508839Z 0 [Note] Shutting down plugin 'INNODB_LOCK_WAITS' 2021-03-26T21:24:10.508843Z 0 [Note] Shutting down plugin 'INNODB_LOCKS' 2021-03-26T21:24:10.508848Z 0 [Note] Shutting down plugin 'INNODB_TRX' 2021-03-26T21:24:10.508852Z 0 [Note] Shutting down plugin 'InnoDB' 2021-03-26T21:24:10.508886Z 0 [Note] InnoDB: FTS optimize thread exiting. 2021-03-26T21:24:10.508945Z 0 [Note] InnoDB: Starting shutdown... 2021-03-26T21:24:10.609233Z 0 [Note] InnoDB: Dumping buffer pool(s) to /var/lib/mysql/ib_buffer_pool 2021-03-26T21:24:10.609436Z 0 [Note] InnoDB: Buffer pool(s) dump completed at 210326 17:24:10 2021-03-26T21:24:12.017519Z 0 [Note] InnoDB: Shutdown completed; log sequence number 12680744 2021-03-26T21:24:12.018890Z 0 [Note] InnoDB: Removed temporary tablespace data file: "ibtmp1" 2021-03-26T21:24:12.019045Z 0 [Note] Shutting down plugin 'MEMORY' 2021-03-26T21:24:12.019147Z 0 [Note] Shutting down plugin 'CSV' 2021-03-26T21:24:12.019266Z 0 [Note] Shutting down plugin 'sha256_password' 2021-03-26T21:24:12.019381Z 0 [Note] Shutting down plugin 'mysql_native_password' 2021-03-26T21:24:12.019597Z 0 [Note] Shutting down plugin 'binlog' 2021-03-26T21:24:12.020789Z 0 [Note] mysqld: Shutdown complete

mtcoffee commented 3 years ago

I was able to get the bootstrap to build with the following changes

to fix create script

sed -i 's/^DB_CONTAINER_NAME./DB_CONTAINER_NAME=$(docker ps --filter name=db -aq)/g' create.sh sed -i 's/^APP_CONTAINER_NAME./APP_CONTAINER_NAME=$(docker ps --filter name=app -aq)/g' create.sh

quick hack to address permissions on volumes dir

chmod -R 777 volumes

After this I was able to login to https://dev.icam.local/ue/login.jsf with spadmin/admin

NSammut commented 3 years ago

We want to maintain the docker-compose command to determine the container name in case there are any other containers that the filter will see in a user's docker environment. Using docker-compose keeps it to the specific stack where it can be isolated.

I managed to create an entirely new Ubuntu 20.04.02 VM in VirtualBox and didn't have any issues with permissions (or the above container name variable) as long as I ran the command with sudo (sudo ./bootstrap.sh build). Do you run into any of these issues when running the bootstrap with sudo?

mtcoffee commented 3 years ago

I ran the bootstrap via sudo and got the same result. I think the issue could be docker version. docker version returns 19.03.8

In my case when running docker-compose ps db | tail -n +3 | awk '{ print $1 }' it returns 2 values: ue_identityiq_db_1 mysqld

To get around the variable issue while still using docker compose, you could use docker-compose ps -q db which will return only the instance id.

The permissions issue is caused by the files on the volume mount not being write accessible to user id 1000. I can address this by setting the ownership chown -R 1000:1000 volumes

Here's my entire load routine. It's a bit kludgie but it works.

sudo apt install docker.io docker-compose git smbclient unzip openjdk-8-jdk  git-lfs -y

cd /opt
sudo git clone https://github.com/UberEther/standalone-docker-sailpoint-iiq.git

#copy files from windows share to needed directories
cd standalone-docker-sailpoint-iiq
sudo smbclient '//windowsserver/e$' -c 'lcd ssb/components/iiq8.1/base/ga; cd sailpoint; get identityiq-8.1.zip' -U administrator%password123
sudo smbclient '//windowsserver/e$' -c 'lcd ssb/components/iiq8.1/base/patch; cd sailpoint; get identityiq-8.1p2.jar' -U administrator%password123
sudo smbclient '//windowsserver/e$' -c 'lcd ssb/components/ssb-v6.1; cd sailpoint; get ssb-v6.1.zip' -U administrator%password123

#test
cd ssb
sudo ./build.sh

#####create containers###
cd ../uedocker/

#to fix create script
sudo sed -i 's/^DB_CONTAINER_NAME.*/DB_CONTAINER_NAME=$(docker-compose ps -q db)/g' create.sh
sudo sed -i 's/^APP_CONTAINER_NAME.*/APP_CONTAINER_NAME=$(docker-compose ps -q app)/g' create.sh

#permissions on volume
sudo chown -R 1000:1000 volumes

#load it up
sudo ./bootstrap.sh

#reminder
echo "###Remember to set your host file to 192.168.1.x dev.icam.local###"

#########to cleanup###################
#docker kill $(docker ps -q)
#docker container prune
#docker image prune --all
#or
#cd ../uedocker/
#docker-compose down
volomatt commented 3 years ago

We are pushing an update to resolve the docker-compose formatting - latest update should no longer require your sed modifications.

mtcoffee commented 3 years ago

Confirmed working. Thanks for creating this project!