Hello all I created this docker service file with Traefik V2 to depl

Thank you guys for your fast replies. As recommended by <a class="user-mention notrans

<a class="user-mention notranslate" data-hovercard-type="user" data-hovercard-url="/us

I tried with http://ip/ampache/ , <a hr

Stuck mysqld_safe Starting mysqld daemon,about ampache/ampache-docker

Comments (18)

lachlan-00 commented on June 26, 2024 1

I don't usually use compose but i think if you take off the volume for it it should use the default image folder? i'll double check that before closing.

      - /home/pi/ampache/sites-enabled:/etc/apache2/sites-enabled

from ampache-docker.

lachlan-00 commented on June 26, 2024 1

what i'll do is update the repo so the folders already exist and then it can be run right from git without further effort

from ampache-docker.

lachlan-00 commented on June 26, 2024

Someone else got this as well yesterday. I'd try deleting the container and trying again.

I haven't seen something reproducible yet that makes sense

from ampache-docker.

kuzi-moto commented on June 26, 2024

This is super odd... I'll try to see if I can reproduce as well.

from ampache-docker.

YasserAntonio commented on June 26, 2024

Thank you guys for your fast replies. As recommended by @lachlan-00 I deleted the container and I even deleted all the config , mysql and sitemap folder. Since those are mounted via nfs I checked all rights/perms and chmod -R 777 them to be sur it's all ok. I also made a random python script to read, write and execute on and from them and it works so no way it could come from a permission issue.

Her his the first launch after those edits :

Creating service ampache_music_center
ampache_music_center.1.z1w1ytwkmjjw@Pidie    | => An empty or uninitialized MySQL volume is detected in /var/lib/mysql
ampache_music_center.1.z1w1ytwkmjjw@Pidie    | => Installing MySQL ...
ampache_music_center.1.z1w1ytwkmjjw@Pidie    | => Done!
ampache_music_center.1.z1w1ytwkmjjw@Pidie    | => Waiting for confirmation of MySQL service startup
ampache_music_center.1.z1w1ytwkmjjw@Pidie    | => Waiting for confirmation of MySQL service startup
ampache_music_center.1.z1w1ytwkmjjw@Pidie    | => Creating MySQL admin user with random password
ampache_music_center.1.z1w1ytwkmjjw@Pidie    | => Done!
ampache_music_center.1.z1w1ytwkmjjw@Pidie    | ========================================================================
ampache_music_center.1.z1w1ytwkmjjw@Pidie    | You can now connect to this MySQL Server using:
ampache_music_center.1.z1w1ytwkmjjw@Pidie    | 
ampache_music_center.1.z1w1ytwkmjjw@Pidie    |     mysql -uadmin -py7VTWmv3BGkc -h<host> -P<port>
ampache_music_center.1.z1w1ytwkmjjw@Pidie    | 
ampache_music_center.1.z1w1ytwkmjjw@Pidie    | Please remember to change the above password as soon as possible!
ampache_music_center.1.z1w1ytwkmjjw@Pidie    | MySQL user 'root' has no password but only allows local connections
ampache_music_center.1.z1w1ytwkmjjw@Pidie    | ========================================================================
ampache_music_center.1.z1w1ytwkmjjw@Pidie    |  * Starting Apache httpd web server apache2
ampache_music_center.1.z1w1ytwkmjjw@Pidie    |  * 
ampache_music_center.1.z1w1ytwkmjjw@Pidie    | Establishing watches...
ampache_music_center.1.z1w1ytwkmjjw@Pidie    | Finished establishing watches, now collecting statistics.
ampache_music_center.1.z1w1ytwkmjjw@Pidie    | 2020-08-07T11:51:17.263800Z mysqld_safe Logging to syslog.
ampache_music_center.1.z1w1ytwkmjjw@Pidie    | 2020-08-07T11:51:17.295965Z mysqld_safe Logging to '/var/log/mysql/error.log'.
ampache_music_center.1.z1w1ytwkmjjw@Pidie    | 2020-08-07T11:51:17.458398Z mysqld_safe Starting mysqld daemon with databases from /var/lib/mysql

it stucked again, and here it the logs of the second launch:

Creating service ampache_music_center
ampache_music_center.1.gsx0lzwdrk7l@Pidie    | => Using an existing volume of MySQL
ampache_music_center.1.gsx0lzwdrk7l@Pidie    |  * Starting Apache httpd web server apache2
ampache_music_center.1.gsx0lzwdrk7l@Pidie    |  * 
ampache_music_center.1.gsx0lzwdrk7l@Pidie    | Establishing watches...
ampache_music_center.1.gsx0lzwdrk7l@Pidie    | Finished establishing watches, now collecting statistics.
ampache_music_center.1.gsx0lzwdrk7l@Pidie    | 2020-08-07T11:56:09.264165Z mysqld_safe Logging to syslog.
ampache_music_center.1.gsx0lzwdrk7l@Pidie    | 2020-08-07T11:56:09.276483Z mysqld_safe Logging to '/var/log/mysql/error.log'.
ampache_music_center.1.gsx0lzwdrk7l@Pidie    | 2020-08-07T11:56:09.350805Z mysqld_safe Starting mysqld daemon with databases from /var/lib/mysql

which it's still stuck.

I looked into var/log/mysql/error.log:

root@ampache:/# cat var/log/mysql/error.log
2020-08-06T07:46:14.853887Z 0 [Warning] TIMESTAMP with implicit DEFAULT value is deprecated. Please use --explicit_defaults_for_timestamp server option (see documentation for more details).
2020-08-06T07:46:14.982543Z 0 [ERROR] InnoDB: Linux Native AIO interface is not supported on this platform. Please check your OS documentation and install appropriate binary of InnoDB.
2020-08-06T07:46:14.986390Z 0 [Warning] InnoDB: Linux Native AIO disabled.
2020-08-06T07:46:17.812076Z 0 [Warning] InnoDB: New log files created, LSN=45790
2020-08-06T07:46:18.615672Z 0 [Warning] InnoDB: Creating foreign key constraint system tables.
2020-08-06T07:46:19.118060Z 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: ea2fbef7-d7b8-11ea-8614-0242ac110002.
2020-08-06T07:46:19.194043Z 0 [Warning] Gtid table is not ready to be used. Table 'mysql.gtid_executed' cannot be opened.
2020-08-06T07:46:29.830551Z 0 [Warning] CA certificate ca.pem is self signed.
2020-08-06T07:46:33.866630Z 1 [Warning] root@localhost is created with an empty password ! Please consider switching off the --initialize-insecure option.
2020-08-06T07:47:15.725650Z 0 [Warning] TIMESTAMP with implicit DEFAULT value is deprecated. Please use --explicit_defaults_for_timestamp server option (see documentation for more details).
2020-08-06T07:47:15.742419Z 0 [Note] /usr/sbin/mysqld (mysqld 5.7.31-0ubuntu0.18.04.1) starting as process 27147 ...
2020-08-06T07:47:15.850933Z 0 [Note] InnoDB: PUNCH HOLE support available
2020-08-06T07:47:15.854823Z 0 [Note] InnoDB: Mutexes and rw_locks use GCC atomic builtins
2020-08-06T07:47:15.855049Z 0 [Note] InnoDB: Uses event mutexes
2020-08-06T07:47:15.855245Z 0 [Note] InnoDB: GCC builtin __atomic_thread_fence() is used for memory barrier
2020-08-06T07:47:15.855390Z 0 [Note] InnoDB: Compressed tables use zlib 1.2.11
2020-08-06T07:47:15.855571Z 0 [Note] InnoDB: Using Linux native AIO
2020-08-06T07:47:15.869976Z 0 [Note] InnoDB: Number of pools: 1
2020-08-06T07:47:15.876399Z 0 [Note] InnoDB: Not using CPU crc32 instructions
2020-08-06T07:47:15.881601Z 0 [ERROR] InnoDB: Linux Native AIO interface is not supported on this platform. Please check your OS documentation and install appropriate binary of InnoDB.
2020-08-06T07:47:15.882103Z 0 [Note] InnoDB: You can disable Linux Native AIO by setting innodb_use_native_aio = 0 in my.cnf
2020-08-06T07:47:15.882459Z 0 [Warning] InnoDB: Linux Native AIO disabled.
2020-08-06T07:47:15.891457Z 0 [Note] InnoDB: Initializing buffer pool, total size = 128M, instances = 1, chunk size = 128M
2020-08-06T07:47:15.985775Z 0 [Note] InnoDB: Completed initialization of buffer pool
2020-08-06T07:47:16.045237Z 0 [Note] InnoDB: If the mysqld execution user is authorized, page cleaner thread priority can be changed. See the man page of setpriority().
2020-08-06T07:47:16.086822Z 0 [Note] InnoDB: Highest supported file format is Barracuda.
2020-08-06T07:47:16.290457Z 0 [Note] InnoDB: Creating shared tablespace for temporary tables
2020-08-06T07:47:16.291967Z 0 [Note] InnoDB: Setting file './ibtmp1' size to 12 MB. Physically writing the file full; Please wait ...
2020-08-06T07:47:16.498066Z 0 [Note] InnoDB: File './ibtmp1' size is now 12 MB.
2020-08-06T07:47:16.513036Z 0 [Note] InnoDB: 96 redo rollback segment(s) found. 96 redo rollback segment(s) are active.
2020-08-06T07:47:16.513255Z 0 [Note] InnoDB: 32 non-redo rollback segment(s) are active.
2020-08-06T07:47:16.551480Z 0 [Note] InnoDB: Waiting for purge to start
2020-08-06T07:47:16.603753Z 0 [Note] InnoDB: 5.7.31 started; log sequence number 2723820
2020-08-06T07:47:16.619142Z 0 [Note] InnoDB: Loading buffer pool(s) from /var/lib/mysql/ib_buffer_pool
2020-08-06T07:47:16.638652Z 0 [Note] Plugin 'FEDERATED' is disabled.
2020-08-06T07:47:16.649232Z 0 [Note] InnoDB: Buffer pool(s) load completed at 200806  7:47:16
2020-08-06T07:47:16.772378Z 0 [Note] Found ca.pem, server-cert.pem and server-key.pem in data directory. Trying to enable SSL support using them.
2020-08-06T07:47:16.772555Z 0 [Note] Skipping generation of SSL certificates as certificate files are present in data directory.
2020-08-06T07:47:16.814089Z 0 [Warning] CA certificate ca.pem is self signed.
2020-08-06T07:47:16.817605Z 0 [Note] Skipping generation of RSA key pair as key files are present in data directory.
2020-08-06T07:47:16.957017Z 0 [Warning] Insecure configuration for --pid-file: Location '/tmp' in the path is accessible to all OS users. Consider choosing a different directory.
2020-08-06T07:47:17.106656Z 0 [Note] Event Scheduler: Loaded 0 events
2020-08-06T07:47:17.118668Z 0 [Note] /usr/sbin/mysqld: ready for connections.
Version: '5.7.31-0ubuntu0.18.04.1'  socket: '/tmp/tmp.ir4CtmKxu5/mysqld.sock'  port: 0  (Ubuntu)
2020-08-06T07:47:17.719391Z 0 [Note] Giving 0 client threads a chance to die gracefully
2020-08-06T07:47:17.719647Z 0 [Note] Shutting down slave threads
2020-08-06T07:47:17.719836Z 0 [Note] Forcefully disconnecting 0 remaining clients
2020-08-06T07:47:17.720309Z 0 [Note] Event Scheduler: Purging the queue. 0 events
2020-08-06T07:47:17.721565Z 0 [Note] Binlog end
2020-08-06T07:47:17.746870Z 0 [Note] Shutting down plugin 'auth_socket'
2020-08-06T07:47:17.747138Z 0 [Note] Shutting down plugin 'ngram'
2020-08-06T07:47:17.747162Z 0 [Note] Shutting down plugin 'partition'
2020-08-06T07:47:17.747295Z 0 [Note] Shutting down plugin 'BLACKHOLE'
2020-08-06T07:47:17.747377Z 0 [Note] Shutting down plugin 'ARCHIVE'
2020-08-06T07:47:17.747402Z 0 [Note] Shutting down plugin 'PERFORMANCE_SCHEMA'
2020-08-06T07:47:17.748085Z 0 [Note] Shutting down plugin 'MRG_MYISAM'
2020-08-06T07:47:17.748161Z 0 [Note] Shutting down plugin 'MyISAM'
2020-08-06T07:47:17.748636Z 0 [Note] Shutting down plugin 'INNODB_SYS_VIRTUAL'
2020-08-06T07:47:17.748721Z 0 [Note] Shutting down plugin 'INNODB_SYS_DATAFILES'
2020-08-06T07:47:17.748746Z 0 [Note] Shutting down plugin 'INNODB_SYS_TABLESPACES'
2020-08-06T07:47:17.748768Z 0 [Note] Shutting down plugin 'INNODB_SYS_FOREIGN_COLS'
2020-08-06T07:47:17.748790Z 0 [Note] Shutting down plugin 'INNODB_SYS_FOREIGN'
2020-08-06T07:47:17.748811Z 0 [Note] Shutting down plugin 'INNODB_SYS_FIELDS'
2020-08-06T07:47:17.748833Z 0 [Note] Shutting down plugin 'INNODB_SYS_COLUMNS'
2020-08-06T07:47:17.748855Z 0 [Note] Shutting down plugin 'INNODB_SYS_INDEXES'
2020-08-06T07:47:17.748877Z 0 [Note] Shutting down plugin 'INNODB_SYS_TABLESTATS'
2020-08-06T07:47:17.748898Z 0 [Note] Shutting down plugin 'INNODB_SYS_TABLES'
2020-08-06T07:47:17.748920Z 0 [Note] Shutting down plugin 'INNODB_FT_INDEX_TABLE'
2020-08-06T07:47:17.748941Z 0 [Note] Shutting down plugin 'INNODB_FT_INDEX_CACHE'
2020-08-06T07:47:17.748963Z 0 [Note] Shutting down plugin 'INNODB_FT_CONFIG'
2020-08-06T07:47:17.748984Z 0 [Note] Shutting down plugin 'INNODB_FT_BEING_DELETED'
2020-08-06T07:47:17.749005Z 0 [Note] Shutting down plugin 'INNODB_FT_DELETED'
2020-08-06T07:47:17.749027Z 0 [Note] Shutting down plugin 'INNODB_FT_DEFAULT_STOPWORD'
2020-08-06T07:47:17.749048Z 0 [Note] Shutting down plugin 'INNODB_METRICS'
2020-08-06T07:47:17.749070Z 0 [Note] Shutting down plugin 'INNODB_TEMP_TABLE_INFO'
2020-08-06T07:47:17.749091Z 0 [Note] Shutting down plugin 'INNODB_BUFFER_POOL_STATS'
2020-08-06T07:47:17.749112Z 0 [Note] Shutting down plugin 'INNODB_BUFFER_PAGE_LRU'
2020-08-06T07:47:17.749133Z 0 [Note] Shutting down plugin 'INNODB_BUFFER_PAGE'
2020-08-06T07:47:17.749154Z 0 [Note] Shutting down plugin 'INNODB_CMP_PER_INDEX_RESET'
2020-08-06T07:47:17.749176Z 0 [Note] Shutting down plugin 'INNODB_CMP_PER_INDEX'
2020-08-06T07:47:17.749197Z 0 [Note] Shutting down plugin 'INNODB_CMPMEM_RESET'
2020-08-06T07:47:17.749219Z 0 [Note] Shutting down plugin 'INNODB_CMPMEM'
2020-08-06T07:47:17.749240Z 0 [Note] Shutting down plugin 'INNODB_CMP_RESET'
2020-08-06T07:47:17.749261Z 0 [Note] Shutting down plugin 'INNODB_CMP'
2020-08-06T07:47:17.749282Z 0 [Note] Shutting down plugin 'INNODB_LOCK_WAITS'
2020-08-06T07:47:17.749303Z 0 [Note] Shutting down plugin 'INNODB_LOCKS'
2020-08-06T07:47:17.749325Z 0 [Note] Shutting down plugin 'INNODB_TRX'
2020-08-06T07:47:17.749346Z 0 [Note] Shutting down plugin 'InnoDB'
2020-08-06T07:47:17.755305Z 0 [Note] InnoDB: FTS optimize thread exiting.
2020-08-06T07:47:17.762586Z 0 [Note] InnoDB: Starting shutdown...
2020-08-06T07:47:17.864222Z 0 [Note] InnoDB: Dumping buffer pool(s) to /var/lib/mysql/ib_buffer_pool
2020-08-06T07:47:17.865976Z 0 [Note] InnoDB: Buffer pool(s) dump completed at 200806  7:47:17
2020-08-06T07:47:19.140799Z 0 [Note] InnoDB: Shutdown completed; log sequence number 2724041
2020-08-06T07:47:19.143879Z 0 [Note] InnoDB: Removed temporary tablespace data file: "ibtmp1"
2020-08-06T07:47:19.144189Z 0 [Note] Shutting down plugin 'MEMORY'
2020-08-06T07:47:19.144365Z 0 [Note] Shutting down plugin 'CSV'
2020-08-06T07:47:19.144444Z 0 [Note] Shutting down plugin 'sha256_password'
2020-08-06T07:47:19.144467Z 0 [Note] Shutting down plugin 'mysql_native_password'
2020-08-06T07:47:19.147664Z 0 [Note] Shutting down plugin 'binlog'
2020-08-06T07:47:19.155789Z 0 [Note] /usr/sbin/mysqld: Shutdown complete

2020-08-06T07:47:19.848300Z 0 [Warning] TIMESTAMP with implicit DEFAULT value is deprecated. Please use --explicit_defaults_for_timestamp server option (see documentation for more details).
2020-08-06T07:47:19.866262Z 0 [Note] /usr/sbin/mysqld (mysqld 5.7.31-0ubuntu0.18.04.1) starting as process 27226 ...
2020-08-06T07:47:19.967595Z 0 [Note] InnoDB: PUNCH HOLE support available
2020-08-06T07:47:19.971329Z 0 [Note] InnoDB: Mutexes and rw_locks use GCC atomic builtins
2020-08-06T07:47:19.971574Z 0 [Note] InnoDB: Uses event mutexes
2020-08-06T07:47:19.971824Z 0 [Note] InnoDB: GCC builtin __atomic_thread_fence() is used for memory barrier
2020-08-06T07:47:19.971968Z 0 [Note] InnoDB: Compressed tables use zlib 1.2.11
2020-08-06T07:47:19.972136Z 0 [Note] InnoDB: Using Linux native AIO
2020-08-06T07:47:19.986963Z 0 [Note] InnoDB: Number of pools: 1
2020-08-06T07:47:19.992624Z 0 [Note] InnoDB: Not using CPU crc32 instructions
2020-08-06T07:47:19.997722Z 0 [ERROR] InnoDB: Linux Native AIO interface is not supported on this platform. Please check your OS documentation and install appropriate binary of InnoDB.
2020-08-06T07:47:19.998196Z 0 [Note] InnoDB: You can disable Linux Native AIO by setting innodb_use_native_aio = 0 in my.cnf
2020-08-06T07:47:19.998523Z 0 [Warning] InnoDB: Linux Native AIO disabled.
2020-08-06T07:47:20.007353Z 0 [Note] InnoDB: Initializing buffer pool, total size = 128M, instances = 1, chunk size = 128M
2020-08-06T07:47:20.104703Z 0 [Note] InnoDB: Completed initialization of buffer pool
2020-08-06T07:47:20.161840Z 0 [Note] InnoDB: If the mysqld execution user is authorized, page cleaner thread priority can be changed. See the man page of setpriority().
2020-08-06T07:47:20.210986Z 0 [Note] InnoDB: Highest supported file format is Barracuda.
2020-08-06T07:47:20.365629Z 0 [Note] InnoDB: Creating shared tablespace for temporary tables
2020-08-06T07:47:20.367238Z 0 [Note] InnoDB: Setting file './ibtmp1' size to 12 MB. Physically writing the file full; Please wait ...
2020-08-06T07:47:20.630415Z 0 [Note] InnoDB: File './ibtmp1' size is now 12 MB.
2020-08-06T07:47:20.645855Z 0 [Note] InnoDB: 96 redo rollback segment(s) found. 96 redo rollback segment(s) are active.
2020-08-06T07:47:20.646269Z 0 [Note] InnoDB: 32 non-redo rollback segment(s) are active.
2020-08-06T07:47:20.699500Z 0 [Note] InnoDB: 5.7.31 started; log sequence number 2724041
2020-08-06T07:47:20.718211Z 0 [Note] InnoDB: Loading buffer pool(s) from /var/lib/mysql/ib_buffer_pool
2020-08-06T07:47:20.730403Z 0 [Note] Plugin 'FEDERATED' is disabled.
2020-08-06T07:47:20.755529Z 0 [Note] InnoDB: Buffer pool(s) load completed at 200806  7:47:20
2020-08-06T07:47:20.868801Z 0 [Note] Found ca.pem, server-cert.pem and server-key.pem in data directory. Trying to enable SSL support using them.
2020-08-06T07:47:20.868971Z 0 [Note] Skipping generation of SSL certificates as certificate files are present in data directory.
2020-08-06T07:47:20.909244Z 0 [Warning] CA certificate ca.pem is self signed.
2020-08-06T07:47:20.912714Z 0 [Note] Skipping generation of RSA key pair as key files are present in data directory.
2020-08-06T07:47:20.918091Z 0 [Note] Server hostname (bind-address): '127.0.0.1'; port: 3306
2020-08-06T07:47:20.919872Z 0 [Note]   - '127.0.0.1' resolves to '127.0.0.1';
2020-08-06T07:47:20.921003Z 0 [Note] Server socket created on IP: '127.0.0.1'.
2020-08-06T07:47:20.986763Z 0 [Warning] Insecure configuration for --pid-file: Location '/tmp' in the path is accessible to all OS users. Consider choosing a different directory.
2020-08-06T07:47:21.111376Z 0 [Note] Event Scheduler: Loaded 0 events
2020-08-06T07:47:21.116986Z 0 [Note] Execution of init_file '/var/lib/mysql-files/tmp.T3ozzVXm7o' started.
2020-08-06T07:47:21.151121Z 0 [Note] Execution of init_file '/var/lib/mysql-files/tmp.T3ozzVXm7o' ended.
2020-08-06T07:47:21.158307Z 0 [Note] /usr/sbin/mysqld: ready for connections.
Version: '5.7.31-0ubuntu0.18.04.1'  socket: '/tmp/tmp.5C0NiAhhMZ/mysqld.sock'  port: 3306  (Ubuntu)
2020-08-06T07:47:21.160080Z 0 [Note] Giving 0 client threads a chance to die gracefully
2020-08-06T07:47:21.160318Z 0 [Note] Shutting down slave threads
2020-08-06T07:47:21.160500Z 0 [Note] Forcefully disconnecting 0 remaining clients
2020-08-06T07:47:21.160980Z 0 [Note] Event Scheduler: Purging the queue. 0 events
2020-08-06T07:47:21.164837Z 0 [Note] Binlog end
2020-08-06T07:47:21.174137Z 0 [Note] Shutting down plugin 'auth_socket'
2020-08-06T07:47:21.174578Z 0 [Note] Shutting down plugin 'ngram'
2020-08-06T07:47:21.174613Z 0 [Note] Shutting down plugin 'partition'
2020-08-06T07:47:21.174907Z 0 [Note] Shutting down plugin 'BLACKHOLE'
2020-08-06T07:47:21.175279Z 0 [Note] Shutting down plugin 'ARCHIVE'
2020-08-06T07:47:21.175314Z 0 [Note] Shutting down plugin 'PERFORMANCE_SCHEMA'
2020-08-06T07:47:21.176039Z 0 [Note] Shutting down plugin 'MRG_MYISAM'
2020-08-06T07:47:21.176146Z 0 [Note] Shutting down plugin 'MyISAM'
2020-08-06T07:47:21.176648Z 0 [Note] Shutting down plugin 'INNODB_SYS_VIRTUAL'
2020-08-06T07:47:21.176747Z 0 [Note] Shutting down plugin 'INNODB_SYS_DATAFILES'
2020-08-06T07:47:21.176771Z 0 [Note] Shutting down plugin 'INNODB_SYS_TABLESPACES'
2020-08-06T07:47:21.176792Z 0 [Note] Shutting down plugin 'INNODB_SYS_FOREIGN_COLS'
2020-08-06T07:47:21.176813Z 0 [Note] Shutting down plugin 'INNODB_SYS_FOREIGN'
2020-08-06T07:47:21.176834Z 0 [Note] Shutting down plugin 'INNODB_SYS_FIELDS'
2020-08-06T07:47:21.176854Z 0 [Note] Shutting down plugin 'INNODB_SYS_COLUMNS'
2020-08-06T07:47:21.176875Z 0 [Note] Shutting down plugin 'INNODB_SYS_INDEXES'
2020-08-06T07:47:21.176895Z 0 [Note] Shutting down plugin 'INNODB_SYS_TABLESTATS'
2020-08-06T07:47:21.176916Z 0 [Note] Shutting down plugin 'INNODB_SYS_TABLES'
2020-08-06T07:47:21.176937Z 0 [Note] Shutting down plugin 'INNODB_FT_INDEX_TABLE'
2020-08-06T07:47:21.176956Z 0 [Note] Shutting down plugin 'INNODB_FT_INDEX_CACHE'
2020-08-06T07:47:21.176977Z 0 [Note] Shutting down plugin 'INNODB_FT_CONFIG'
2020-08-06T07:47:21.176998Z 0 [Note] Shutting down plugin 'INNODB_FT_BEING_DELETED'
2020-08-06T07:47:21.177018Z 0 [Note] Shutting down plugin 'INNODB_FT_DELETED'
2020-08-06T07:47:21.177039Z 0 [Note] Shutting down plugin 'INNODB_FT_DEFAULT_STOPWORD'
2020-08-06T07:47:21.177060Z 0 [Note] Shutting down plugin 'INNODB_METRICS'
2020-08-06T07:47:21.177080Z 0 [Note] Shutting down plugin 'INNODB_TEMP_TABLE_INFO'
2020-08-06T07:47:21.177100Z 0 [Note] Shutting down plugin 'INNODB_BUFFER_POOL_STATS'
2020-08-06T07:47:21.177120Z 0 [Note] Shutting down plugin 'INNODB_BUFFER_PAGE_LRU'
2020-08-06T07:47:21.177141Z 0 [Note] Shutting down plugin 'INNODB_BUFFER_PAGE'
2020-08-06T07:47:21.177162Z 0 [Note] Shutting down plugin 'INNODB_CMP_PER_INDEX_RESET'
2020-08-06T07:47:21.177182Z 0 [Note] Shutting down plugin 'INNODB_CMP_PER_INDEX'
2020-08-06T07:47:21.177203Z 0 [Note] Shutting down plugin 'INNODB_CMPMEM_RESET'
2020-08-06T07:47:21.177223Z 0 [Note] Shutting down plugin 'INNODB_CMPMEM'
2020-08-06T07:47:21.177244Z 0 [Note] Shutting down plugin 'INNODB_CMP_RESET'
2020-08-06T07:47:21.177263Z 0 [Note] Shutting down plugin 'INNODB_CMP'
2020-08-06T07:47:21.177282Z 0 [Note] Shutting down plugin 'INNODB_LOCK_WAITS'
2020-08-06T07:47:21.177300Z 0 [Note] Shutting down plugin 'INNODB_LOCKS'
2020-08-06T07:47:21.177333Z 0 [Note] Shutting down plugin 'INNODB_TRX'
2020-08-06T07:47:21.177354Z 0 [Note] Shutting down plugin 'InnoDB'
2020-08-06T07:47:21.178996Z 0 [Note] InnoDB: FTS optimize thread exiting.
2020-08-06T07:47:21.180641Z 0 [Note] InnoDB: Starting shutdown...
2020-08-06T07:47:21.282293Z 0 [Note] InnoDB: Dumping buffer pool(s) to /var/lib/mysql/ib_buffer_pool
2020-08-06T07:47:21.283913Z 0 [Note] InnoDB: Buffer pool(s) dump completed at 200806  7:47:21
2020-08-06T07:47:22.626486Z 0 [Note] InnoDB: Shutdown completed; log sequence number 2724060
2020-08-06T07:47:22.629530Z 0 [Note] InnoDB: Removed temporary tablespace data file: "ibtmp1"
2020-08-06T07:47:22.629836Z 0 [Note] Shutting down plugin 'MEMORY'
2020-08-06T07:47:22.630032Z 0 [Note] Shutting down plugin 'CSV'
2020-08-06T07:47:22.630122Z 0 [Note] Shutting down plugin 'sha256_password'
2020-08-06T07:47:22.630146Z 0 [Note] Shutting down plugin 'mysql_native_password'
2020-08-06T07:47:22.633149Z 0 [Note] Shutting down plugin 'binlog'
2020-08-06T07:47:22.640490Z 0 [Note] /usr/sbin/mysqld: Shutdown complete

2020-08-07T11:56:10.202634Z 0 [Warning] TIMESTAMP with implicit DEFAULT value is deprecated. Please use --explicit_defaults_for_timestamp server option (see documentation for more details).
2020-08-07T11:56:10.223309Z 0 [Note] /usr/sbin/mysqld (mysqld 5.7.31-0ubuntu0.18.04.1) starting as process 381 ...
2020-08-07T11:56:10.280667Z 0 [Note] InnoDB: PUNCH HOLE support available
2020-08-07T11:56:10.281048Z 0 [Note] InnoDB: Mutexes and rw_locks use GCC atomic builtins
2020-08-07T11:56:10.281238Z 0 [Note] InnoDB: Uses event mutexes
2020-08-07T11:56:10.281419Z 0 [Note] InnoDB: GCC builtin __atomic_thread_fence() is used for memory barrier
2020-08-07T11:56:10.281595Z 0 [Note] InnoDB: Compressed tables use zlib 1.2.11
2020-08-07T11:56:10.281771Z 0 [Note] InnoDB: Using Linux native AIO
2020-08-07T11:56:10.283563Z 0 [Note] InnoDB: Number of pools: 1
2020-08-07T11:56:10.284453Z 0 [Note] InnoDB: Not using CPU crc32 instructions
2020-08-07T11:56:10.297385Z 0 [Note] InnoDB: Initializing buffer pool, total size = 128M, instances = 1, chunk size = 128M
2020-08-07T11:56:10.380317Z 0 [Note] InnoDB: Completed initialization of buffer pool
2020-08-07T11:56:10.400747Z 0 [Note] InnoDB: If the mysqld execution user is authorized, page cleaner thread priority can be changed. See the man page of setpriority().
2020-08-07T11:56:10.412237Z 0 [ERROR] InnoDB: Unable to lock ./ibdata1 error: 11
2020-08-07T11:56:10.412742Z 0 [Note] InnoDB: Check that you do not already have another mysqld process using the same InnoDB data or log files.
2020-08-07T11:56:10.412982Z 0 [Note] InnoDB: Retrying to lock the first data file
2020-08-07T11:56:11.752291Z 0 [Note] InnoDB: Highest supported file format is Barracuda.
2020-08-07T11:56:11.771743Z 0 [Note] InnoDB: Log scan progressed past the checkpoint lsn 2719941
2020-08-07T11:56:11.772100Z 0 [Note] InnoDB: Doing recovery: scanned up to log sequence number 2719950
2020-08-07T11:56:11.772327Z 0 [Note] InnoDB: Database was not shutdown normally!
2020-08-07T11:56:11.772533Z 0 [Note] InnoDB: Starting crash recovery.
2020-08-07T11:56:13.063600Z 0 [Note] InnoDB: Removed temporary tablespace data file: "ibtmp1"
2020-08-07T11:56:13.063971Z 0 [Note] InnoDB: Creating shared tablespace for temporary tables
2020-08-07T11:56:13.068820Z 0 [Note] InnoDB: Setting file './ibtmp1' size to 12 MB. Physically writing the file full; Please wait ...
2020-08-07T11:56:14.235971Z 0 [Note] InnoDB: File './ibtmp1' size is now 12 MB.
2020-08-07T11:56:14.244871Z 0 [Note] InnoDB: 96 redo rollback segment(s) found. 96 redo rollback segment(s) are active.
2020-08-07T11:56:14.245184Z 0 [Note] InnoDB: 32 non-redo rollback segment(s) are active.
2020-08-07T11:56:14.249940Z 0 [Note] InnoDB: 5.7.31 started; log sequence number 2719950
2020-08-07T11:56:14.251815Z 0 [Note] InnoDB: Loading buffer pool(s) from /var/lib/mysql/ib_buffer_pool
2020-08-07T11:56:14.252260Z 0 [Note] Plugin 'FEDERATED' is disabled.
2020-08-07T11:56:14.784682Z 0 [Note] Found ca.pem, server-cert.pem and server-key.pem in data directory. Trying to enable SSL support using them.
2020-08-07T11:56:14.785056Z 0 [Note] Skipping generation of SSL certificates as certificate files are present in data directory.
2020-08-07T11:56:14.801136Z 0 [Warning] CA certificate ca.pem is self signed.
2020-08-07T11:56:14.801776Z 0 [Note] Skipping generation of RSA key pair as key files are present in data directory.
2020-08-07T11:56:14.805804Z 0 [Note] Server hostname (bind-address): '127.0.0.1'; port: 3306
2020-08-07T11:56:14.806086Z 0 [Note]   - '127.0.0.1' resolves to '127.0.0.1';
2020-08-07T11:56:14.806696Z 0 [Note] Server socket created on IP: '127.0.0.1'.
2020-08-07T11:56:14.947509Z 0 [Note] InnoDB: Buffer pool(s) load completed at 200807 11:56:14
2020-08-07T11:56:15.204393Z 0 [Note] Event Scheduler: Loaded 0 events
2020-08-07T11:56:15.205555Z 0 [Note] /usr/sbin/mysqld: ready for connections.
Version: '5.7.31-0ubuntu0.18.04.1'  socket: '/var/run/mysqld/mysqld.sock'  port: 3306  (Ubuntu)

if it might help. Do you think that creating a default user in the dckerfile might be a good shot ? : https://stackoverflow.com/questions/46087411/get-stuck-in-mysqld-safe-starting-mysqld-daemon-with-databases-from-usr-local-m

from ampache-docker.

YasserAntonio commented on June 26, 2024

@lachlan-00 by any chance did you succeed to reproduce this issue ? I can share more if needed.

from ampache-docker.

lachlan-00 commented on June 26, 2024

I haven't been able to reproduce but I've also split out MySQL from the base image.

You can use the tag ampache/ampache:nosql to skip this and roll in a MySQL server yourself

from ampache-docker.

YasserAntonio commented on June 26, 2024

@lachlan-00 I'm stuck with the error page while trying to reach the install.php page :
Not Found
The requested URL was not found on this server.
Apache/2.4.38 (Debian) Server at ampache.ln Port 80

apache2 error logs show this :

root@ampache:/# cat var/log/apache2/error.log 
[Tue Sep 01 14:28:36.504598 2020] [mpm_prefork:notice] [pid 15] AH00163: Apache/2.4.38 (Debian) configured -- resuming normal operations
[Tue Sep 01 14:28:36.504860 2020] [core:notice] [pid 15] AH00094: Command line: '/usr/sbin/apache2 -D FOREGROUND'

while I use ampache/ampache:nosql, here is it container's logs :

ampache_music_center.1.06jcz6ath81m@Pidie    | 2020-09-01 14:28:35,004 INFO Set uid to user 0 succeeded
ampache_music_center.1.06jcz6ath81m@Pidie    | 2020-09-01 14:28:35,022 INFO supervisord started with pid 1
ampache_music_center.1.06jcz6ath81m@Pidie    | 2020-09-01 14:28:36,030 INFO spawned: 'cron' with pid 9
ampache_music_center.1.06jcz6ath81m@Pidie    | 2020-09-01 14:28:36,041 INFO spawned: 'inotifywatch' with pid 10
ampache_music_center.1.06jcz6ath81m@Pidie    | 2020-09-01 14:28:36,049 INFO spawned: 'apache2' with pid 11
ampache_music_center.1.06jcz6ath81m@Pidie    | 2020-09-01 14:28:37,077 INFO success: cron entered RUNNING state, process has stayed up for > than 1 seconds (startsecs)
ampache_music_center.1.06jcz6ath81m@Pidie    | 2020-09-01 14:28:37,077 INFO success: inotifywatch entered RUNNING state, process has stayed up for > than 1 seconds (startsecs)
ampache_music_center.1.06jcz6ath81m@Pidie    | 2020-09-01 14:28:37,078 INFO success: apache2 entered RUNNING state, process has stayed up for > than 1 seconds (startsecs)

for the mysql server I used : biarms/mysql 5.7.30-beta-travis which generated those logs :

ampache_db.1.l6f7ujst1kco@Polymatheia    | 2020-09-01 16:24:13+02:00 [Note] [Entrypoint]: Entrypoint script for MySQL Server  started.
ampache_db.1.l6f7ujst1kco@Polymatheia    | 2020-09-01 16:24:14+02:00 [Note] [Entrypoint]: Switching to dedicated user 'mysql'
ampache_db.1.l6f7ujst1kco@Polymatheia    | 2020-09-01 16:24:14+02:00 [Note] [Entrypoint]: Entrypoint script for MySQL Server  started.
ampache_db.1.l6f7ujst1kco@Polymatheia    | 2020-09-01T14:24:15.298124Z 0 [Warning] TIMESTAMP with implicit DEFAULT value is deprecated. Please use --explicit_defaults_for_timestamp server option (see documentation for more details).
ampache_db.1.l6f7ujst1kco@Polymatheia    | 2020-09-01T14:24:15.314766Z 0 [Note] mysqld (mysqld 5.7.30-0ubuntu0.18.04.1) starting as process 1 ...
ampache_db.1.l6f7ujst1kco@Polymatheia    | 2020-09-01T14:24:15.367508Z 0 [Note] InnoDB: PUNCH HOLE support available
ampache_db.1.l6f7ujst1kco@Polymatheia    | 2020-09-01T14:24:15.367938Z 0 [Note] InnoDB: Mutexes and rw_locks use GCC atomic builtins
ampache_db.1.l6f7ujst1kco@Polymatheia    | 2020-09-01T14:24:15.368087Z 0 [Note] InnoDB: Uses event mutexes
ampache_db.1.l6f7ujst1kco@Polymatheia    | 2020-09-01T14:24:15.368257Z 0 [Note] InnoDB: GCC builtin __atomic_thread_fence() is used for memory barrier
ampache_db.1.l6f7ujst1kco@Polymatheia    | 2020-09-01T14:24:15.368391Z 0 [Note] InnoDB: Compressed tables use zlib 1.2.11
ampache_db.1.l6f7ujst1kco@Polymatheia    | 2020-09-01T14:24:15.368524Z 0 [Note] InnoDB: Using Linux native AIO
ampache_db.1.l6f7ujst1kco@Polymatheia    | 2020-09-01T14:24:15.371809Z 0 [Note] InnoDB: Number of pools: 1
ampache_db.1.l6f7ujst1kco@Polymatheia    | 2020-09-01T14:24:15.372874Z 0 [Note] InnoDB: Not using CPU crc32 instructions
ampache_db.1.l6f7ujst1kco@Polymatheia    | 2020-09-01T14:24:15.383213Z 0 [Note] InnoDB: Initializing buffer pool, total size = 128M, instances = 1, chunk size = 128M
ampache_db.1.l6f7ujst1kco@Polymatheia    | 2020-09-01T14:24:15.468232Z 0 [Note] InnoDB: Completed initialization of buffer pool
ampache_db.1.l6f7ujst1kco@Polymatheia    | 2020-09-01T14:24:15.476735Z 0 [Note] InnoDB: If the mysqld execution user is authorized, page cleaner thread priority can be changed. See the man page of setpriority().
ampache_db.1.l6f7ujst1kco@Polymatheia    | 2020-09-01T14:24:16.038750Z 0 [Note] InnoDB: Highest supported file format is Barracuda.
ampache_db.1.l6f7ujst1kco@Polymatheia    | 2020-09-01T14:24:16.058317Z 0 [Note] InnoDB: Log scan progressed past the checkpoint lsn 12502072
ampache_db.1.l6f7ujst1kco@Polymatheia    | 2020-09-01T14:24:16.058802Z 0 [Note] InnoDB: Doing recovery: scanned up to log sequence number 12502081
ampache_db.1.l6f7ujst1kco@Polymatheia    | 2020-09-01T14:24:16.059013Z 0 [Note] InnoDB: Database was not shutdown normally!
ampache_db.1.l6f7ujst1kco@Polymatheia    | 2020-09-01T14:24:16.059221Z 0 [Note] InnoDB: Starting crash recovery.
ampache_db.1.l6f7ujst1kco@Polymatheia    | 2020-09-01T14:24:17.940423Z 0 [Note] InnoDB: Removed temporary tablespace data file: "ibtmp1"
ampache_db.1.l6f7ujst1kco@Polymatheia    | 2020-09-01T14:24:17.940569Z 0 [Note] InnoDB: Creating shared tablespace for temporary tables
ampache_db.1.l6f7ujst1kco@Polymatheia    | 2020-09-01T14:24:17.945408Z 0 [Note] InnoDB: Setting file './ibtmp1' size to 12 MB. Physically writing the file full; Please wait ...
ampache_db.1.l6f7ujst1kco@Polymatheia    | 2020-09-01T14:24:19.084060Z 0 [Note] InnoDB: File './ibtmp1' size is now 12 MB.
ampache_db.1.l6f7ujst1kco@Polymatheia    | 2020-09-01T14:24:19.095036Z 0 [Note] InnoDB: 96 redo rollback segment(s) found. 96 redo rollback segment(s) are active.
ampache_db.1.l6f7ujst1kco@Polymatheia    | 2020-09-01T14:24:19.095135Z 0 [Note] InnoDB: 32 non-redo rollback segment(s) are active.
ampache_db.1.l6f7ujst1kco@Polymatheia    | 2020-09-01T14:24:19.099006Z 0 [Note] InnoDB: 5.7.30 started; log sequence number 12502081
ampache_db.1.l6f7ujst1kco@Polymatheia    | 2020-09-01T14:24:19.102267Z 0 [Note] InnoDB: Loading buffer pool(s) from /var/lib/mysql/ib_buffer_pool
ampache_db.1.l6f7ujst1kco@Polymatheia    | 2020-09-01T14:24:19.102843Z 0 [Note] Plugin 'FEDERATED' is disabled.
ampache_db.1.l6f7ujst1kco@Polymatheia    | 2020-09-01T14:24:19.224246Z 0 [Note] Found ca.pem, server-cert.pem and server-key.pem in data directory. Trying to enable SSL support using them.
ampache_db.1.l6f7ujst1kco@Polymatheia    | 2020-09-01T14:24:19.224328Z 0 [Note] Skipping generation of SSL certificates as certificate files are present in data directory.
ampache_db.1.l6f7ujst1kco@Polymatheia    | 2020-09-01T14:24:19.371504Z 0 [Warning] CA certificate ca.pem is self signed.
ampache_db.1.l6f7ujst1kco@Polymatheia    | 2020-09-01T14:24:19.372596Z 0 [Note] Skipping generation of RSA key pair as key files are present in data directory.
ampache_db.1.l6f7ujst1kco@Polymatheia    | 2020-09-01T14:24:19.441746Z 0 [Note] Server hostname (bind-address): '*'; port: 3306
ampache_db.1.l6f7ujst1kco@Polymatheia    | 2020-09-01T14:24:19.442313Z 0 [Note] IPv6 is available.
ampache_db.1.l6f7ujst1kco@Polymatheia    | 2020-09-01T14:24:19.442417Z 0 [Note]   - '::' resolves to '::';
ampache_db.1.l6f7ujst1kco@Polymatheia    | 2020-09-01T14:24:19.442839Z 0 [Note] Server socket created on IP: '::'.
ampache_db.1.l6f7ujst1kco@Polymatheia    | 2020-09-01T14:24:19.475635Z 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.
ampache_db.1.l6f7ujst1kco@Polymatheia    | 2020-09-01T14:24:19.534338Z 0 [Note] InnoDB: Buffer pool(s) load completed at 200901 16:24:19
ampache_db.1.l6f7ujst1kco@Polymatheia    | 2020-09-01T14:24:19.732414Z 0 [Note] Failed to start slave threads for channel ''
ampache_db.1.l6f7ujst1kco@Polymatheia    | 2020-09-01T14:24:20.208443Z 0 [Note] Event Scheduler: Loaded 0 events
ampache_db.1.l6f7ujst1kco@Polymatheia    | 2020-09-01T14:24:20.215527Z 0 [Note] mysqld: ready for connections.
ampache_db.1.l6f7ujst1kco@Polymatheia    | Version: '5.7.30-0ubuntu0.18.04.1'  socket: '/var/run/mysqld/mysqld.sock'  port: 3306  (Ubuntu)

any idea how to handle this ?

from ampache-docker.

YasserAntonio commented on June 26, 2024

I tried with http://ip/ampache/, http://ip/ampache/install.php and http://ip/install.php (dont know which is the good one) but all gaved me 404 not found. I tried it without traefik (verify if it was a reverse proxy issue) in a simple docker compose but still I get the same error code and logs

from ampache-docker.

lachlan-00 commented on June 26, 2024

What's your run command? if you run 80:80 then it will just be the default.

The default from the readme is http://IPADDRESS/

If you want a custom port use the first port in the run command
8080:80 (http://IPADDRESS:8080)

The logs look like it's running fine.

from ampache-docker.

YasserAntonio commented on June 26, 2024

Here ie the docker-compose I used:

version: "3"

services:
  music_center:
    restart: unless-stopped
    image: ampache/ampache:nosql
    volumes:
      - /home/pi/ampache/mysql:/var/lib/mysql
      - /home/pi/ampache/config:/var/www/config
      - /home/pi/ampache/sites-enabled:/etc/apache2/sites-enabled
      - /home/pi/musics:/media
    ports:
      - 8081:80

here is the page result on http://http://192.168.1.5:8081/ :

Not Found
The requested URL was not found on this server.

Apache/2.4.38 (Debian) Server at 192.168.1.5 Port 8081

what m'i missing ? It' on an armv7 by the way

from ampache-docker.

lachlan-00 commented on June 26, 2024

I ran with docker-compose and get the same issue. i'll log into the container and have a look

from ampache-docker.

lachlan-00 commented on June 26, 2024

do you have 001-ampache.conf in your enabled sites folder (/home/pi/ampache/sites-enabled)

I had the same issue but that's because i created the config and not the data volumes.

on your pi

cp ./001-ampache.conf /home/pi/ampache/sites-enabled/

then restart the container

from ampache-docker.

YasserAntonio commented on June 26, 2024

yes , here is it content :

 root@cda4dad6308b:/# cat ./etc/apache2/sites-available/001-ampache.conf
DocumentRoot /var/www/
<Directory /var/www/>
    Options Indexes FollowSymLinks MultiViews
    AllowOverride All
    Order allow,deny
    Allow from all
   SetEnvIf Authorization "(.*)" HTTP_AUTHORIZATION=$1
</Directory>

I chmoded it to 777 just to be sure but still with the same issue. Why did you had to copy it ? Mine was already in the site-available folder

from ampache-docker.

YasserAntonio commented on June 26, 2024

Ok i confused site-enable with site-available. I copied , restarted the container and now it works. Wondering if it's possible to make an image with the conf already available in the site enabled ? Thanks for your help ! You can close this issue

from ampache-docker.

YasserAntonio commented on June 26, 2024

yes I did this to avoid having to add it again. Thanks for your help !

from ampache-docker.

lachlan-00 commented on June 26, 2024

great, can confirm too. glad we got there

from ampache-docker.

YasserAntonio commented on June 26, 2024

If it's faisable , rebuild the image with the conf already in site enabled would avoid having to use a volume. Or if it's going to be systematically needed maybe it should be added to documentation for next people going to use it. An issue could be created in this sens, what do you think ?

from ampache-docker.

Stuck mysqld_safe Starting mysqld daemon about ampache-docker HOT 18 CLOSED

Comments (18)

Related Issues (20)

Recommend Projects

React

Vue.js

Typescript

TensorFlow

Django

Laravel

D3

Recommend Topics

javascript

web

server

Machine learning

Visualization

Game

Recommend Org

Facebook

Microsoft

Google

Alibaba

D3

Tencent