Error cant open log

Oops, the file is called DESKTOP-FBF6RQE-bin.index in my computer and was found under the data folder where mysql stores the database.

I emptied the content of this index file and mysql is running again. I don’t understand why or whether it actually was the reason. This was what I found in that file, which looks a lot like a log file so I wasn’t expecting to see an effect:

.DESKTOP-FBF6RQE-bin.000001
.DESKTOP-FBF6RQE-bin.000002
.DESKTOP-FBF6RQE-bin.000003
.DESKTOP-FBF6RQE-bin.000004
.DESKTOP-FBF6RQE-bin.000005
.DESKTOP-FBF6RQE-bin.000006
.DESKTOP-FBF6RQE-bin.000007
2017-11-06T17:59:54.541193Z 0 [Note] Plugin 'FEDERATED' is disabled.
2017-11-06T17:59:54.568351Z 1 [Note] InnoDB: Mutexes and rw_locks use Windows interlocked functions
2017-11-06T17:59:54.569146Z 1 [Note] InnoDB: Uses event mutexes
2017-11-06T17:59:54.569631Z 1 [Note] InnoDB: _mm_lfence() and _mm_sfence() are used for memory barrier
2017-11-06T17:59:54.570530Z 1 [Note] InnoDB: Compressed tables use zlib 1.2.11
2017-11-06T17:59:54.575411Z 1 [Note] InnoDB: Number of pools: 1
2017-11-06T17:59:54.578906Z 1 [Note] InnoDB: Using CPU crc32 instructions
2017-11-06T17:59:54.583104Z 1 [Note] InnoDB: Initializing buffer pool, total size = 128M, instances = 1, chunk size = 128M
2017-11-06T17:59:54.596966Z 1 [Note] InnoDB: Completed initialization of buffer pool
2017-11-06T17:59:54.632081Z 1 [Note] InnoDB: The log sequence number 15225091 in the system tablespace does not match the log sequence number 16647247 in the ib_logfiles!
2017-11-06T17:59:54.632584Z 1 [Note] InnoDB: Database was not shutdown normally!
2017-11-06T17:59:54.632812Z 1 [Note] InnoDB: Starting crash recovery.
2017-11-06T17:59:54.641979Z 1 [Note] InnoDB: Using 'tablespaces.open.1' max LSN: 16286950
2017-11-06T17:59:54.646957Z 1 [Note] InnoDB: Doing recovery: scanned up to log sequence number 16647247
2017-11-06T17:59:54.655170Z 1 [Note] InnoDB: Applying a batch of 0 redo log records ...
2017-11-06T17:59:54.655443Z 1 [Note] InnoDB: Apply batch completed!
2017-11-06T17:59:54.655934Z 1 [Note] InnoDB: Last MySQL binlog file position 0 49567, file name DESKTOP-FBF6RQE-bin.000007
2017-11-06T17:59:54.774590Z 1 [Note] InnoDB: Opened 2 existing undo tablespaces.
2017-11-06T17:59:54.889740Z 1 [Note] InnoDB: Removed temporary tablespace data file: "ibtmp1"
2017-11-06T17:59:54.890052Z 1 [Note] InnoDB: Creating shared tablespace for temporary tables
2017-11-06T17:59:54.890506Z 1 [Note] InnoDB: Setting file '.ibtmp1' size to 12 MB. Physically writing the file full; Please wait ...
2017-11-06T17:59:54.918638Z 1 [Note] InnoDB: File '.ibtmp1' size is now 12 MB.
2017-11-06T17:59:54.930557Z 1 [Note] InnoDB: Created 128 and tracked 128 new rollback segment(s) in the temporary tablespace. 128 are now active.
2017-11-06T17:59:54.931664Z 1 [Note] InnoDB: 8.0.3 started; log sequence number 16647247
2017-11-06T17:59:55.104098Z 0 [Note] InnoDB: Loading buffer pool(s) from D:ProgramFilesmysql-8.0.3-rc-winx64dataib_buffer_pool
2017-11-06T17:59:55.112864Z 0 [Note] InnoDB: Buffer pool(s) load completed at 171106 18:59:55
2017-11-06T17:59:55.125772Z 1 [Note] Found data dictionary with version 1
2017-11-06T17:59:55.158741Z 0 [Note] Recovering after a crash using DESKTOP-FBF6RQE-bin
2017-11-06T17:59:55.161192Z 0 [Note] Starting crash recovery...
2017-11-06T17:59:55.161700Z 0 [Note] Crash recovery finished.
2017-11-06T17:59:55.167187Z 0 [Note] InnoDB: DDL log recovery : begin
2017-11-06T17:59:55.167744Z 0 [Note] InnoDB: DDL log recovery : end
.DESKTOP-FBF6RQE-bin.000008
2017-11-11T09:26:35.045541Z 0 [Note] Plugin 'FEDERATED' is disabled.
2017-11-11T09:26:35.056583Z 1 [Note] InnoDB: Mutexes and rw_locks use Windows interlocked functions
2017-11-11T09:26:35.056920Z 1 [Note] InnoDB: Uses event mutexes
2017-11-11T09:26:35.057170Z 1 [Note] InnoDB: _mm_lfence() and _mm_sfence() are used for memory barrier
2017-11-11T09:26:35.057635Z 1 [Note] InnoDB: Compressed tables use zlib 1.2.11
2017-11-11T09:26:35.058767Z 1 [Note] InnoDB: Number of pools: 1
2017-11-11T09:26:35.059330Z 1 [Note] InnoDB: Using CPU crc32 instructions
2017-11-11T09:26:35.062500Z 1 [Note] InnoDB: Initializing buffer pool, total size = 128M, instances = 1, chunk size = 128M
2017-11-11T09:26:35.072049Z 1 [Note] InnoDB: Completed initialization of buffer pool
2017-11-11T09:26:35.102431Z 1 [Note] InnoDB: The log sequence number 15225091 in the system tablespace does not match the log sequence number 16692836 in the ib_logfiles!
2017-11-11T09:26:35.102971Z 1 [Note] InnoDB: Database was not shutdown normally!
2017-11-11T09:26:35.103263Z 1 [Note] InnoDB: Starting crash recovery.
2017-11-11T09:26:35.112811Z 1 [Note] InnoDB: Using 'tablespaces.open.1' max LSN: 16674515
2017-11-11T09:26:35.117119Z 1 [Note] InnoDB: Doing recovery: scanned up to log sequence number 16692836
2017-11-11T09:26:35.120889Z 1 [Note] InnoDB: Applying a batch of 0 redo log records ...
2017-11-11T09:26:35.121187Z 1 [Note] InnoDB: Apply batch completed!
2017-11-11T09:26:35.121696Z 1 [Note] InnoDB: Last MySQL binlog file position 0 5073, file name DESKTOP-FBF6RQE-bin.000008
2017-11-11T09:26:35.240881Z 1 [Note] InnoDB: Opened 2 existing undo tablespaces.
2017-11-11T09:26:35.371010Z 1 [Note] InnoDB: Removed temporary tablespace data file: "ibtmp1"
2017-11-11T09:26:35.371324Z 1 [Note] InnoDB: Creating shared tablespace for temporary tables
2017-11-11T09:26:35.371763Z 1 [Note] InnoDB: Setting file '.ibtmp1' size to 12 MB. Physically writing the file full; Please wait ...
2017-11-11T09:26:35.400748Z 1 [Note] InnoDB: File '.ibtmp1' size is now 12 MB.
2017-11-11T09:26:35.417187Z 1 [Note] InnoDB: Created 128 and tracked 128 new rollback segment(s) in the temporary tablespace. 128 are now active.
2017-11-11T09:26:35.418663Z 1 [Note] InnoDB: 8.0.3 started; log sequence number 16692836
2017-11-11T09:26:35.562126Z 0 [Note] InnoDB: Loading buffer pool(s) from D:ProgramFilesmysql-8.0.3-rc-winx64dataib_buffer_pool
2017-11-11T09:26:35.567929Z 0 [Note] InnoDB: Buffer pool(s) load completed at 171111 10:26:35
2017-11-11T09:26:35.578991Z 1 [Note] Found data dictionary with version 1
2017-11-11T09:26:35.614146Z 0 [Note] Recovering after a crash using DESKTOP-FBF6RQE-bin
2017-11-11T09:26:35.614545Z 0 [Note] Starting crash recovery...
2017-11-11T09:26:35.614842Z 0 [Note] Crash recovery finished.
2017-11-11T09:26:35.621462Z 0 [Note] InnoDB: DDL log recovery : begin
2017-11-11T09:26:35.622032Z 0 [Note] InnoDB: DDL log recovery : end
.DESKTOP-FBF6RQE-bin.000009
2017-11-11T09:26:35.649708Z 0 [Warning] You have not provided a mandatory server-id. Servers in a replication topology must have unique server-ids. Please refer to the proper server start-up parameters documentation.
mysqld: File '2017-11-11T09:26:35.622032Z 0 [Note] InnoDB: DDL log recovery : end' not found (Errcode: 13 - Permission denied)
2017-11-11T09:26:35.652612Z 0 [ERROR] Failed to open log (file '2017-11-11T09:26:35.622032Z 0 [Note] InnoDB: DDL log recovery : end', errno 13)
2017-11-11T09:26:35.653021Z 0 [ERROR] Could not open log file
mysqld: File '2017-11-11T09:26:35.621462Z 0 [Note] InnoDB: DDL log recovery : begin' not found (Errcode: 13 - Permission denied)
2017-11-11T09:26:35.653227Z 0 [ERROR] Failed to open log (file '2017-11-11T09:26:35.621462Z 0 [Note] InnoDB: DDL log recovery : begin', errno 13)
2017-11-11T09:26:35.653707Z 0 [ERROR] Could not open log file
mysqld: File '2017-11-11T09:26:35.614842Z 0 [Note] Crash recovery finished.' not found (Errcode: 13 - Permission denied)
2017-11-11T09:26:35.653925Z 0 [ERROR] Failed to open log (file '2017-11-11T09:26:35.614842Z 0 [Note] Crash recovery finished.', errno 13)
2017-11-11T09:26:35.654308Z 0 [ERROR] Could not open log file
mysqld: File '2017-11-11T09:26:35.614545Z 0 [Note] Starting crash recovery...' not found (Errcode: 13 - Permission denied)
2017-11-11T09:26:35.654515Z 0 [ERROR] Failed to open log (file '2017-11-11T09:26:35.614545Z 0 [Note] Starting crash recovery...', errno 13)
2017-11-11T09:26:35.654902Z 0 [ERROR] Could not open log file
mysqld: File '2017-11-11T09:26:35.614146Z 0 [Note] Recovering after a crash using DESKTOP-FBF6RQE-bin' not found (Errcode: 13 - Permission denied)
2017-11-11T09:26:35.655106Z 0 [ERROR] Failed to open log (file '2017-11-11T09:26:35.614146Z 0 [Note] Recovering after a crash using DESKTOP-FBF6RQE-bin', errno 13)
2017-11-11T09:26:35.655603Z 0 [ERROR] Could not open log file
mysqld: File '2017-11-11T09:26:35.578991Z 1 [Note] Found data dictionary with version 1' not found (Errcode: 13 - Permission denied)
2017-11-11T09:26:35.655856Z 0 [ERROR] Failed to open log (file '2017-11-11T09:26:35.578991Z 1 [Note] Found data dictionary with version 1', errno 13)
2017-11-11T09:26:35.656293Z 0 [ERROR] Could not open log file
mysqld: File '2017-11-11T09:26:35.567929Z 0 [Note] InnoDB: Buffer pool(s) load completed at 171111 10:26:35' not found (Errcode: 13 - Permission denied)
2017-11-11T09:26:35.656541Z 0 [ERROR] Failed to open log (file '2017-11-11T09:26:35.567929Z 0 [Note] InnoDB: Buffer pool(s) load completed at 171111 10:26:35', errno 13)
2017-11-11T09:26:35.657052Z 0 [ERROR] Could not open log file
mysqld: File '2017-11-11T09:26:35.562126Z 0 [Note] InnoDB: Loading buffer pool(s) from D:ProgramFilesmysql-8.0.3-rc-winx64dataib_buffer_pool' not found (Errcode: 2 - No such file or directory)
2017-11-11T09:26:35.657323Z 0 [ERROR] Failed to open log (file '2017-11-11T09:26:35.562126Z 0 [Note] InnoDB: Loading buffer pool(s) from D:ProgramFilesmysql-8.0.3-rc-winx64dataib_buffer_pool', errno 2)
2017-11-11T09:26:35.657917Z 0 [ERROR] Could not open log file
mysqld: File '2017-11-11T09:26:35.418663Z 1 [Note] InnoDB: 8.0.3 started; log sequence number 16692836' not found (Errcode: 13 - Permission denied)
2017-11-11T09:26:35.658126Z 0 [ERROR] Failed to open log (file '2017-11-11T09:26:35.418663Z 1 [Note] InnoDB: 8.0.3 started; log sequence number 16692836', errno 13)
2017-11-11T09:26:35.658615Z 0 [ERROR] Could not open log file
mysqld: File '2017-11-11T09:26:35.417187Z 1 [Note] InnoDB: Created 128 and tracked 128 new rollback segment(s) in the temporary tablespace. 128 are now active.' not found (Errcode: 13 - Permission denied)
2017-11-11T09:26:35.658836Z 0 [ERROR] Failed to open log (file '2017-11-11T09:26:35.417187Z 1 [Note] InnoDB: Created 128 and tracked 128 new rollback segment(s) in the temporary tablespace. 128 are now active.', errno 13)
2017-11-11T09:26:35.659467Z 0 [ERROR] Could not open log file
mysqld: File '2017-11-11T09:26:35.400748Z 1 [Note] InnoDB: File '.ibtmp1' size is now 12 MB.' not found (Errcode: 2 - No such file or directory)
2017-11-11T09:26:35.659704Z 0 [ERROR] Failed to open log (file '2017-11-11T09:26:35.400748Z 1 [Note] InnoDB: File '.ibtmp1' size is now 12 MB.', errno 2)
2017-11-11T09:26:35.660132Z 0 [ERROR] Could not open log file
mysqld: File '2017-11-11T09:26:35.371763Z 1 [Note] InnoDB: Setting file '.ibtmp1' size to 12 MB. Physically writing the file full; Please wait ...' not found (Errcode: 2 - No such file or directory)
2017-11-11T09:26:35.660357Z 0 [ERROR] Failed to open log (file '2017-11-11T09:26:35.371763Z 1 [Note] InnoDB: Setting file '.ibtmp1' size to 12 MB. Physically writing the file full; Please wait ...', errno 2)
2017-11-11T09:26:35.660959Z 0 [ERROR] Could not open log file
mysqld: File '2017-11-11T09:26:35.371324Z 1 [Note] InnoDB: Creating shared tablespace for temporary tables' not found (Errcode: 13 - Permission denied)
2017-11-11T09:26:35.661167Z 0 [ERROR] Failed to open log (file '2017-11-11T09:26:35.371324Z 1 [Note] InnoDB: Creating shared tablespace for temporary tables', errno 13)
2017-11-11T09:26:35.661661Z 0 [ERROR] Could not open log file
mysqld: File '2017-11-11T09:26:35.371010Z 1 [Note] InnoDB: Removed temporary tablespace data file: "ibtmp1"' not found (Errcode: 13 - Permission denied)
2017-11-11T09:26:35.661865Z 0 [ERROR] Failed to open log (file '2017-11-11T09:26:35.371010Z 1 [Note] InnoDB: Removed temporary tablespace data file: "ibtmp1"', errno 13)
2017-11-11T09:26:35.662333Z 0 [ERROR] Could not open log file
mysqld: File '2017-11-11T09:26:35.240881Z 1 [Note] InnoDB: Opened 2 existing undo tablespaces.' not found (Errcode: 13 - Permission denied)
2017-11-11T09:26:35.662556Z 0 [ERROR] Failed to open log (file '2017-11-11T09:26:35.240881Z 1 [Note] InnoDB: Opened 2 existing undo tablespaces.', errno 13)
2017-11-11T09:26:35.663015Z 0 [ERROR] Could not open log file
mysqld: File '2017-11-11T09:26:35.121696Z 1 [Note] InnoDB: Last MySQL binlog file position 0 5073, file name DESKTOP-FBF6RQE-bin.000008' not found (Errcode: 13 - Permission denied)
2017-11-11T09:26:35.663262Z 0 [ERROR] Failed to open log (file '2017-11-11T09:26:35.121696Z 1 [Note] InnoDB: Last MySQL binlog file position 0 5073, file name DESKTOP-FBF6RQE-bin.000008', errno 13)
2017-11-11T09:26:35.663834Z 0 [ERROR] Could not open log file
mysqld: File '2017-11-11T09:26:35.121187Z 1 [Note] InnoDB: Apply batch completed!' not found (Errcode: 13 - Permission denied)
2017-11-11T09:26:35.664039Z 0 [ERROR] Failed to open log (file '2017-11-11T09:26:35.121187Z 1 [Note] InnoDB: Apply batch completed!', errno 13)
2017-11-11T09:26:35.664438Z 0 [ERROR] Could not open log file
mysqld: File '2017-11-11T09:26:35.120889Z 1 [Note] InnoDB: Applying a batch of 0 redo log records ...' not found (Errcode: 13 - Permission denied)
2017-11-11T09:26:35.664646Z 0 [ERROR] Failed to open log (file '2017-11-11T09:26:35.120889Z 1 [Note] InnoDB: Applying a batch of 0 redo log records ...', errno 13)
2017-11-11T09:26:35.665143Z 0 [ERROR] Could not open log file
mysqld: File '2017-11-11T09:26:35.117119Z 1 [Note] InnoDB: Doing recovery: scanned up to log sequence number 16692836' not found (Errcode: 13 - Permission denied)
2017-11-11T09:26:35.665347Z 0 [ERROR] Failed to open log (file '2017-11-11T09:26:35.117119Z 1 [Note] InnoDB: Doing recovery: scanned up to log sequence number 16692836', errno 13)
2017-11-11T09:26:35.665872Z 0 [ERROR] Could not open log file
mysqld: File '2017-11-11T09:26:35.112811Z 1 [Note] InnoDB: Using 'tablespaces.open.1' max LSN: 16674515' not found (Errcode: 13 - Permission denied)
2017-11-11T09:26:35.666101Z 0 [ERROR] Failed to open log (file '2017-11-11T09:26:35.112811Z 1 [Note] InnoDB: Using 'tablespaces.open.1' max LSN: 16674515', errno 13)
2017-11-11T09:26:35.666562Z 0 [ERROR] Could not open log file
mysqld: File '2017-11-11T09:26:35.103263Z 1 [Note] InnoDB: Starting crash recovery.' not found (Errcode: 13 - Permission denied)
2017-11-11T09:26:35.666766Z 0 [ERROR] Failed to open log (file '2017-11-11T09:26:35.103263Z 1 [Note] InnoDB: Starting crash recovery.', errno 13)
2017-11-11T09:26:35.667191Z 0 [ERROR] Could not open log file
mysqld: File '2017-11-11T09:26:35.102971Z 1 [Note] InnoDB: Database was not shutdown normally!' not found (Errcode: 13 - Permission denied)
2017-11-11T09:26:35.667397Z 0 [ERROR] Failed to open log (file '2017-11-11T09:26:35.102971Z 1 [Note] InnoDB: Database was not shutdown normally!', errno 13)
2017-11-11T09:26:35.667832Z 0 [ERROR] Could not open log file
mysqld: File '2017-11-11T09:26:35.102431Z 1 [Note] InnoDB: The log sequence number 15225091 in the system tablespace does not match the log sequence number 16692836 in the ib_logfiles!' not found (Errcode: 13 - Permission denied)
2017-11-11T09:26:35.668041Z 0 [ERROR] Failed to open log (file '2017-11-11T09:26:35.102431Z 1 [Note] InnoDB: The log sequence number 15225091 in the system tablespace does not match the log sequence number 16692836 in the ib_logfiles!', errno 13)
2017-11-11T09:26:35.668749Z 0 [ERROR] Could not open log file
mysqld: File '2017-11-11T09:26:35.072049Z 1 [Note] InnoDB: Completed initialization of buffer pool' not found (Errcode: 13 - Permission denied)
2017-11-11T09:26:35.668957Z 0 [ERROR] Failed to open log (file '2017-11-11T09:26:35.072049Z 1 [Note] InnoDB: Completed initialization of buffer pool', errno 13)
2017-11-11T09:26:35.669403Z 0 [ERROR] Could not open log file
mysqld: File '2017-11-11T09:26:35.062500Z 1 [Note] InnoDB: Initializing buffer pool, total size = 128M, instances = 1, chunk size = 128M' not found (Errcode: 13 - Permission denied)
2017-11-11T09:26:35.669612Z 0 [ERROR] Failed to open log (file '2017-11-11T09:26:35.062500Z 1 [Note] InnoDB: Initializing buffer pool, total size = 128M, instances = 1, chunk size = 128M', errno 13)
2017-11-11T09:26:35.670158Z 0 [ERROR] Could not open log file
mysqld: File '2017-11-11T09:26:35.059330Z 1 [Note] InnoDB: Using CPU crc32 instructions' not found (Errcode: 13 - Permission denied)
2017-11-11T09:26:35.670360Z 0 [ERROR] Failed to open log (file '2017-11-11T09:26:35.059330Z 1 [Note] InnoDB: Using CPU crc32 instructions', errno 13)
2017-11-11T09:26:35.670794Z 0 [ERROR] Could not open log file
mysqld: File '2017-11-11T09:26:35.058767Z 1 [Note] InnoDB: Number of pools: 1' not found (Errcode: 13 - Permission denied)
2017-11-11T09:26:35.670998Z 0 [ERROR] Failed to open log (file '2017-11-11T09:26:35.058767Z 1 [Note] InnoDB: Number of pools: 1', errno 13)
2017-11-11T09:26:35.671387Z 0 [ERROR] Could not open log file
mysqld: File '2017-11-11T09:26:35.057635Z 1 [Note] InnoDB: Compressed tables use zlib 1.2.11' not found (Errcode: 13 - Permission denied)
2017-11-11T09:26:35.671619Z 0 [ERROR] Failed to open log (file '2017-11-11T09:26:35.057635Z 1 [Note] InnoDB: Compressed tables use zlib 1.2.11', errno 13)
2017-11-11T09:26:35.672046Z 0 [ERROR] Could not open log file
mysqld: File '2017-11-11T09:26:35.057170Z 1 [Note] InnoDB: _mm_lfence() and _mm_sfence() are used for memory barrier' not found (Errcode: 13 - Permission denied)
2017-11-11T09:26:35.672251Z 0 [ERROR] Failed to open log (file '2017-11-11T09:26:35.057170Z 1 [Note] InnoDB: _mm_lfence() and _mm_sfence() are used for memory barrier', errno 13)
2017-11-11T09:26:35.672786Z 0 [ERROR] Could not open log file
mysqld: File '2017-11-11T09:26:35.056920Z 1 [Note] InnoDB: Uses event mutexes' not found (Errcode: 13 - Permission denied)
2017-11-11T09:26:35.673023Z 0 [ERROR] Failed to open log (file '2017-11-11T09:26:35.056920Z 1 [Note] InnoDB: Uses event mutexes', errno 13)
2017-11-11T09:26:35.673502Z 0 [ERROR] Could not open log file
mysqld: File '2017-11-11T09:26:35.056583Z 1 [Note] InnoDB: Mutexes and rw_locks use Windows interlocked functions' not found (Errcode: 13 - Permission denied)
2017-11-11T09:26:35.673716Z 0 [ERROR] Failed to open log (file '2017-11-11T09:26:35.056583Z 1 [Note] InnoDB: Mutexes and rw_locks use Windows interlocked functions', errno 13)
2017-11-11T09:26:35.674201Z 0 [ERROR] Could not open log file
mysqld: File '2017-11-11T09:26:35.045541Z 0 [Note] Plugin 'FEDERATED' is disabled.' not found (Errcode: 13 - Permission denied)
2017-11-11T09:26:35.674407Z 0 [ERROR] Failed to open log (file '2017-11-11T09:26:35.045541Z 0 [Note] Plugin 'FEDERATED' is disabled.', errno 13)
2017-11-11T09:26:35.674845Z 0 [ERROR] Could not open log file
2017-11-11T09:26:35.681224Z 0 [Warning] Failed to set up SSL because of the following SSL library error: SSL context is not usable without certificate and private key
2017-11-11T09:26:35.681793Z 0 [Note] RSA private key file not found: D:ProgramFilesmysql-8.0.3-rc-winx64data\private_key.pem. Some authentication plugins will not work.
2017-11-11T09:26:35.682297Z 0 [Note] RSA public key file not found: D:ProgramFilesmysql-8.0.3-rc-winx64data\public_key.pem. Some authentication plugins will not work.
2017-11-11T09:26:35.688653Z 0 [Note] Server hostname (bind-address): '*'; port: 3306
2017-11-11T09:26:35.689168Z 0 [Note] IPv6 is available.
2017-11-11T09:26:35.689387Z 0 [Note]   - '::' resolves to '::';
2017-11-11T09:26:35.689632Z 0 [Note] Server socket created on IP: '::'.
2017-11-11T09:26:35.730516Z 4 [Note] Event Scheduler: scheduler thread started with id 4
2017-11-11T09:26:35.730787Z 0 [Note] D:ProgramFilesmysql-8.0.3-rc-winx64binmysqld.exe: ready for connections. Version: '8.0.3-rc-log'  socket: ''  port: 3306  MySQL Community Server (GPL)
2017-11-12T16:09:13.321752Z 0 [Note] Plugin 'FEDERATED' is disabled.
2017-11-12T16:09:13.327276Z 1 [Note] InnoDB: Mutexes and rw_locks use Windows interlocked functions
2017-11-12T16:09:13.327587Z 1 [Note] InnoDB: Uses event mutexes
2017-11-12T16:09:13.327769Z 1 [Note] InnoDB: _mm_lfence() and _mm_sfence() are used for memory barrier
2017-11-12T16:09:13.328054Z 1 [Note] InnoDB: Compressed tables use zlib 1.2.11
2017-11-12T16:09:13.328580Z 1 [Note] InnoDB: Number of pools: 1
2017-11-12T16:09:13.328865Z 1 [Note] InnoDB: Using CPU crc32 instructions
2017-11-12T16:09:13.331962Z 1 [Note] InnoDB: Initializing buffer pool, total size = 128M, instances = 1, chunk size = 128M
2017-11-12T16:09:13.342562Z 1 [Note] InnoDB: Completed initialization of buffer pool
2017-11-12T16:09:13.357255Z 1 [Note] InnoDB: Using 'tablespaces.open.1' max LSN: 16739055
2017-11-12T16:09:13.361358Z 1 [Note] InnoDB: Applying a batch of 0 redo log records ...
2017-11-12T16:09:13.361631Z 1 [Note] InnoDB: Apply batch completed!
2017-11-12T16:09:13.369632Z 1 [Note] InnoDB: Opened 2 existing undo tablespaces.
2017-11-12T16:09:13.497034Z 1 [Note] InnoDB: Creating shared tablespace for temporary tables
2017-11-12T16:09:13.497544Z 1 [Note] InnoDB: Setting file '.ibtmp1' size to 12 MB. Physically writing the file full; Please wait ...
2017-11-12T16:09:13.524418Z 1 [Note] InnoDB: File '.ibtmp1' size is now 12 MB.
2017-11-12T16:09:13.535690Z 1 [Note] InnoDB: Created 128 and tracked 128 new rollback segment(s) in the temporary tablespace. 128 are now active.
2017-11-12T16:09:13.536818Z 1 [Note] InnoDB: 8.0.3 started; log sequence number 16766170
2017-11-12T16:09:13.631459Z 0 [Note] InnoDB: Loading buffer pool(s) from D:ProgramFilesmysql-8.0.3-rc-winx64dataib_buffer_pool
2017-11-12T16:09:13.632940Z 0 [Note] InnoDB: Buffer pool(s) load completed at 171112 17:09:13
2017-11-12T16:09:13.650952Z 1 [Note] Found data dictionary with version 1
mysqld: File '2017-11-11T09:26:35.730787Z 0 [Note] D:ProgramFilesmysql-8.0.3-rc-winx64binmysqld.exe: ready for connections. Version: '8.0.3-rc-log'  socket: ''  port: 3306  MySQL Community Server (GPL)' not found (Errcode: 13 - Permission denied)
2017-11-12T16:09:13.677325Z 0 [ERROR] Failed to open log (file '2017-11-11T09:26:35.730787Z 0 [Note] D:ProgramFilesmysql-8.0.3-rc-winx64binmysqld.exe: ready for connections. Version: '8.0.3-rc-log'  socket: ''  port: 3306  MySQL Community Server (GPL)', errno 13)
2017-11-12T16:09:13.678104Z 0 [ERROR] Could not open log file
2017-11-12T16:09:13.678282Z 0 [ERROR] Can't init tc log
2017-11-12T16:09:13.678442Z 0 [ERROR] Aborting
2017-11-12T16:09:13.678643Z 0 [Note] InnoDB: FTS optimize thread exiting.
2017-11-12T16:09:13.679389Z 0 [Note] Binlog end
2017-11-12T16:10:30.147427Z 0 [Note] Plugin 'FEDERATED' is disabled.
2017-11-12T16:10:30.153362Z 1 [Note] InnoDB: Mutexes and rw_locks use Windows interlocked functions
2017-11-12T16:10:30.153890Z 1 [Note] InnoDB: Uses event mutexes
2017-11-12T16:10:30.154257Z 1 [Note] InnoDB: _mm_lfence() and _mm_sfence() are used for memory barrier
2017-11-12T16:10:30.154768Z 1 [Note] InnoDB: Compressed tables use zlib 1.2.11
2017-11-12T16:10:30.155720Z 1 [Note] InnoDB: Number of pools: 1
2017-11-12T16:10:30.156585Z 1 [Note] InnoDB: Using CPU crc32 instructions
2017-11-12T16:10:30.162241Z 1 [Note] InnoDB: Initializing buffer pool, total size = 128M, instances = 1, chunk size = 128M
2017-11-12T16:10:30.173293Z 1 [Note] InnoDB: Completed initialization of buffer pool
2017-11-12T16:10:30.198754Z 1 [Note] InnoDB: Using 'tablespaces.open.2' max LSN: 16766189
2017-11-12T16:10:30.203195Z 1 [Note] InnoDB: Applying a batch of 0 redo log records ...
2017-11-12T16:10:30.203485Z 1 [Note] InnoDB: Apply batch completed!
2017-11-12T16:10:30.211017Z 1 [Note] InnoDB: Opened 2 existing undo tablespaces.
2017-11-12T16:10:30.346852Z 1 [Note] InnoDB: Creating shared tablespace for temporary tables
2017-11-12T16:10:30.347381Z 1 [Note] InnoDB: Setting file '.ibtmp1' size to 12 MB. Physically writing the file full; Please wait ...
2017-11-12T16:10:30.376752Z 1 [Note] InnoDB: File '.ibtmp1' size is now 12 MB.
2017-11-12T16:10:30.388120Z 1 [Note] InnoDB: Created 128 and tracked 128 new rollback segment(s) in the temporary tablespace. 128 are now active.
2017-11-12T16:10:30.389122Z 1 [Note] InnoDB: 8.0.3 started; log sequence number 16794174
2017-11-12T16:10:30.494659Z 0 [Note] InnoDB: Loading buffer pool(s) from D:ProgramFilesmysql-8.0.3-rc-winx64dataib_buffer_pool
2017-11-12T16:10:30.495981Z 0 [Note] InnoDB: Buffer pool(s) load completed at 171112 17:10:30
2017-11-12T16:10:30.511094Z 1 [Note] Found data dictionary with version 1
mysqld: File '2017-11-12T16:09:13.679389Z 0 [Note] Binlog end' not found (Errcode: 13 - Permission denied)
2017-11-12T16:10:30.536218Z 0 [ERROR] Failed to open log (file '2017-11-12T16:09:13.679389Z 0 [Note] Binlog end', errno 13)
2017-11-12T16:10:30.536677Z 0 [ERROR] Could not open log file
2017-11-12T16:10:30.536873Z 0 [ERROR] Can't init tc log
2017-11-12T16:10:30.537050Z 0 [ERROR] Aborting
2017-11-12T16:10:30.537232Z 0 [Note] InnoDB: FTS optimize thread exiting.
2017-11-12T16:10:30.538030Z 0 [Note] Binlog end
2017-11-12T16:13:20.723327Z 0 [Note] Plugin 'FEDERATED' is disabled.
2017-11-12T16:13:20.726715Z 1 [Note] InnoDB: Mutexes and rw_locks use Windows interlocked functions
2017-11-12T16:13:20.727050Z 1 [Note] InnoDB: Uses event mutexes
2017-11-12T16:13:20.727255Z 1 [Note] InnoDB: _mm_lfence() and _mm_sfence() are used for memory barrier
2017-11-12T16:13:20.727566Z 1 [Note] InnoDB: Compressed tables use zlib 1.2.11
2017-11-12T16:13:20.728253Z 1 [Note] InnoDB: Number of pools: 1
2017-11-12T16:13:20.728858Z 1 [Note] InnoDB: Using CPU crc32 instructions
2017-11-12T16:13:20.733263Z 1 [Note] InnoDB: Initializing buffer pool, total size = 128M, instances = 1, chunk size = 128M
2017-11-12T16:13:20.744173Z 1 [Note] InnoDB: Completed initialization of buffer pool
2017-11-12T16:13:20.759094Z 1 [Note] InnoDB: Using 'tablespaces.open.2' max LSN: 16821327
2017-11-12T16:13:20.763132Z 1 [Note] InnoDB: Applying a batch of 0 redo log records ...
2017-11-12T16:13:20.763398Z 1 [Note] InnoDB: Apply batch completed!
2017-11-12T16:13:20.771518Z 1 [Note] InnoDB: Opened 2 existing undo tablespaces.
2017-11-12T16:13:20.898543Z 1 [Note] InnoDB: Creating shared tablespace for temporary tables
2017-11-12T16:13:20.899066Z 1 [Note] InnoDB: Setting file '.ibtmp1' size to 12 MB. Physically writing the file full; Please wait ...
2017-11-12T16:13:20.927231Z 1 [Note] InnoDB: File '.ibtmp1' size is now 12 MB.
2017-11-12T16:13:20.938469Z 1 [Note] InnoDB: Created 128 and tracked 128 new rollback segment(s) in the temporary tablespace. 128 are now active.
2017-11-12T16:13:20.939685Z 1 [Note] InnoDB: 8.0.3 started; log sequence number 16849296
2017-11-12T16:13:21.038115Z 0 [Note] InnoDB: Loading buffer pool(s) from D:ProgramFilesmysql-8.0.3-rc-winx64dataib_buffer_pool
2017-11-12T16:13:21.039792Z 0 [Note] InnoDB: Buffer pool(s) load completed at 171112 17:13:21
2017-11-12T16:13:21.058281Z 1 [Note] Found data dictionary with version 1
mysqld: File '2017-11-12T16:10:30.538030Z 0 [Note] Binlog end' not found (Errcode: 13 - Permission denied)
2017-11-12T16:13:21.083974Z 0 [ERROR] Failed to open log (file '2017-11-12T16:10:30.538030Z 0 [Note] Binlog end', errno 13)
2017-11-12T16:13:21.084329Z 0 [ERROR] Could not open log file
2017-11-12T16:13:21.084507Z 0 [ERROR] Can't init tc log
2017-11-12T16:13:21.084669Z 0 [ERROR] Aborting
2017-11-12T16:13:21.084858Z 0 [Note] InnoDB: FTS optimize thread exiting.
2017-11-12T16:13:21.085592Z 0 [Note] Binlog end

The error

I installed Elasticsearch on CentOS using rpm and am encountering this error when I try to start it via systemctl start elasticsearch:

Feb 20 21:08:34 server.cberdata.org systemd[1]: Started Elasticsearch.
Feb 20 21:08:34 server.cberdata.org elasticsearch[4226]: OpenJDK 64-Bit Server VM warning: Cannot open file /var/log/elasticsearch/gc.log due to Permission denied
Feb 20 21:08:51 server.cberdata.org systemd[1]: elasticsearch.service: main process exited, code=exited, status=78/n/a
Feb 20 21:08:51 server.cberdata.org systemd[1]: Unit elasticsearch.service entered failed state.
Feb 20 21:08:51 server.cberdata.org systemd[1]: elasticsearch.service failed.

Notably: Cannot open file /var/log/elasticsearch/gc.log due to Permission denied

Permissions

Permissions for /var:

drwxr-xr-x  21 root root  4096 Feb 11 19:10 var

Permissions for /var/log:

drwxrwxr--  12 root  root   4096 Feb 20 21:00 log

Permissions for /var/log/elasticsearch:

drwxrwxrwx  2 elasticsearch elasticsearch        4096 Feb 20 20:56 elasticsearch

Permissions for /var/log/elasticsearch/gc.log
(which I manually created to see if that would help, but doing so had no effect on the error):

-rwxrwxrwx  1 elasticsearch elasticsearch      0 Feb 20 20:56 gc.log

Setting /var/log permissions to drwxrwxrwx appears to fix the problem, but I’m hesitant to do that because it seems insecure and it results in these new errors:

/etc/cron.daily/logrotate:
error: skipping "/var/log/exim_mainlog" because parent directory has insecure permissions (It's world writable or writable by group which is not "root") Set "su" directive in config file to tell logrotate which user/group should be used for rotation.

Am I correct that systemctl / systemd is running this service as the elasticsearch user? If it’s doing that, how can the owner of the file and its directory, with apparent read/write/execute permissions, not have permission to open that file?

If I comment out the UpdateLogFile line from /etc/clamav/freshclam.conf like so…

#UpdateLogFile /var/log/clamav/freshclam.log

…then I am able to run sudo freshclam no problem:

/etc/clamav$ sudo freshclam ClamAV update process started at Mon Feb 
6 00:17:07 2017 main.cvd is up to date (version: 57, sigs: 4218790,
f-level: 60, builder: amishhammer) daily.cld is up to date (version:
23009, sigs: 1509149, f-level: 63, builder: neo) bytecode.cld is up to
date (version: 290, sigs: 55, f-level: 63, builder: neo)

However, if I uncomment the UpdateLogFile line in freshclam.conf and run sudo freshclam, I get this:

/etc/clamav$ sudo freshclam 
ERROR: Can't open /var/log/clamav/freshclam.log in append mode (check permissions!).
ERROR: Problem with internal logger (UpdateLogFile = /var/log/clamav/freshclam.log).

Here are the permissions on /var/log:

drwxrwxrwx  1 root root     9 Feb  3  2016 log

Here are the permissions on /var/log/clamav:

drwxr-xr-x  2 clamav    clamav    4096 Feb  5 22:18 clamav

And here are the permissions on /var/log/clamav/freshclam.log:

-rw-r-----  1 clamav adm       0 Feb  5 22:18 freshclam.log

I spent all day trying solutions mentioned in various forums with no luck.

Here is the version of Ubuntu server I am running:

Description:    Ubuntu 14.04.5 LTS

And the engine version of clamav:

Engine version: 0.99.2

Could someone help me?

Stopping the clamav-daemon does not help:

/var/log$ sudo /etc/init.d/clamav-daemon stop 

* Stopping ClamAV daemon clamd        
[ OK ]  /var/log$ sudo freshclam
ERROR: Can't open /var/log/clamav/freshclam.log in append mode (check
permissions!). ERROR: Problem with internal logger (UpdateLogFile =
/var/log/clamav/freshclam.log).

The output of sudo lsof | grep clam is nothing:

/var/log$ sudo lsof | grep clam
/var/log$

It appears that nothing has a lock on /var/log/clamav/freshclam.log

Here is the output of sudo service --status-all | grep clamav, not including the lines that had question marks and were unrelated to clamav:

$ sudo service --status-all | grep clamav 
[ - ] clamav-daemon
[ - ] clamav-freshclam
$

Same Can't open /var/log/clamav/freshclam.log in append mode (check permissions!) error when I try to run clamav-daemon:

$ sudo service clamav-daemon start
 * Starting ClamAV daemon clamd
ERROR: Can't open /var/log/clamav/clamav.log in append mode (check permissions!).
ERROR: Can't initialize the internal logger
$

UPDATE: purging and reinstalling clamav, clamav-freshclam and clamav-daemon did not resolve the issue. I still get the same error:

$ sudo freshclam
ERROR: Can't open /var/log/clamav/freshclam.log in append mode (check permissions!).
ERROR: Problem with internal logger (UpdateLogFile = /var/log/clamav/freshclam.log).
$

UPDATE 2: I did a sudo reboot, stopped clamav-freshclam, made sure sudo lsof | grep clam returned nothing and that the output of sudo service --status-all | grep clamav still only had minus symbols next to clamav and clamav-daemon. Ran sudo freshclam again, and same error as above (again).

Перестали обновляться базы ClamAV по крону с ошибкой:

/etc/cron.daily/freshclam:

ERROR: Problem with internal logger
(UpdateLogFile = /var/log/clamav/freshclam.log).

ERROR: Can’t open
/var/log/clamav/freshclam.log in append mode (check permissions!).

После небольшой проверки выяснилось, что по умолчанию freshclam работает от имени пользователя «clamav», а непосредственно антивирус работает от имени пользователя «clam», ему же и принадлежат права на запись в директорию и в файлы:

/var/log/clamav/

/var/log/clamav/freshclam.log

/var/lib/clamav/

При этом в самом скрипте /etc/cron.daily/freshclam есть строка:

chown clam.clam «$LOG_FILE»

а сам он следующего содержания:

#!/bin/sh

### A simple update script for the clamav virus database.
### This could as well be replaced by a SysV script.

### fix log file if needed
LOG_FILE=»/var/log/clamav/freshclam.log»
if [ ! -f «$LOG_FILE» ]; then
    touch «$LOG_FILE»
    chmod 644 «$LOG_FILE»
    chown clam.clam «$LOG_FILE»
fi

/usr/bin/freshclam
    —quiet
    —datadir=»/var/lib/clamav»
    —log=»$LOG_FILE»

Откуда такое расхождение, выяснять лично я не стал. Так вот тут два варианта:

Вариант 1:

Изменить в файле /etc/freshclam.conf строку

DatabaseOwner clamav

на

DatabaseOwner clam

Вариант 2:

Изменить /etc/cron.daily/freshclam, добавив в него строку:

—datadir=»/var/lib/clamav»

Как конечный результат для второго варианта:

….

….

….

/usr/bin/freshclam
    —quiet
    —user=clam
    —datadir=»/var/lib/clamav»
    —log=»$LOG_FILE»

После этого обновление заработало.

I have a simple LAMP stack on CentOS setup. Apache is setup with vhosts and each developer has their web files inside their user folder. The directory structure is like so (for the user test):

/home/test
|_ apache
   |_ domain1.com
      |_ backups
      |_ conf
         |_ vhost.conf
      |_ logs
         |_ errors.log
         |_ images.log
         |_ web.log
      |_ private
      |_ public

The vhost config is in the vhost.conf file. The log files in logs don’t exist when the config is first setup, and this throws an error with apache when I run service httpd restart:

(13)Permission denied: httpd: could not open error log file /home/test/apache/domain1.com/logs/error.log.
Unable to open logs

I tried running httpd -X as root and it created the log files (with root ownership/group). I thought it would be a case of making sure that the files are there, with group set as apache and writeable (so I don’t have to make the whole directory belong to apache group and writeable), but this confuses me:

[root@dev logs]# ls -al
total 16
drwxr-xr-x. 2 test developers 4096 Apr 18 21:02 .
drwxr-xr-x. 8 test developers 4096 Apr 18 20:25 ..
-rw-r--r--. 1 test developers 1818 Apr 18 21:02 error.log
-rw-r--r--. 1 test developers   14 Apr 18 20:25 .gitignore
-rw-r--r--. 1 test developers    0 Apr 18 20:54 image.log
[root@dev logs]# service httpd restart
Stopping httpd:                                            [  OK  ]
Starting httpd:                                            [FAILED]
[root@dev logs]# touch web.log
[root@dev logs]# chown test:developers web.log
[root@dev logs]# service httpd restart
Stopping httpd:                                            [FAILED]
Starting httpd:                                            [  OK  ]

I’m confused because apache runs as user apache and shouldn’t have write access on the logs, should it? In fact, I can even do this:

[root@dev logs]# rm -f ./*.log
[root@dev logs]# touch {error.log,image.log,web.log}
[root@dev logs]# ls -al
total 12
drwxr-xr-x. 2 test developers 4096 Apr 18 21:10 .
drwxr-xr-x. 8 test developers 4096 Apr 18 20:25 ..
-rw-r--r--. 1 root root          0 Apr 18 21:10 error.log
-rw-r--r--. 1 test developers   14 Apr 18 20:25 .gitignore
-rw-r--r--. 1 root root          0 Apr 18 21:10 image.log
-rw-r--r--. 1 root root          0 Apr 18 21:10 web.log
[root@dev logs]# service httpd restart
Stopping httpd:                                            [  OK  ]
Starting httpd:                                            [  OK  ]

I now have log files owned by root and it still starts up — and it writes to them too — if I tail web.log and browse to that page the logs start showing up.

I’m obviously not quite grasping something here, so what am I missing? I would prefer not to have to create the log files manually and allow apache to do that itself, but regardless, I’d just like to understand why this is happening — especially when I get round to allowing PHP to mess with files.

Update

As requested, here is what I see in audit.log when I try start apache when the logfiles don’t exist:

type=AVC msg=audit(1397906748.752:49390): avc:  denied  { write } for  pid=19433 comm="httpd" name="logs" dev=md2 ino=7210204 scontext=unconfined_u:system_r:httpd_t:s0 tcontext=unconfined_u:object_r:user_home_t:s0 tclass=dir
type=SYSCALL msg=audit(1397906748.752:49390): arch=c000003e syscall=2 success=no exit=-13 a0=7f9bb740e598 a1=80441 a2=1b6 a3=752e6f632e74756f items=0 ppid=19432 pid=19433 auid=0 uid=0 gid=0 euid=0 suid=0 fsuid=0 egid=0 sgid=0 fsgid=0 tty=pts1 ses=128 comm="httpd" exe="/usr/sbin/httpd" subj=unconfined_u:system_r:httpd_t:s0 key=(null)

When running with the logs existing nothing else is added to the log. The Permission denied: httpd: could not ... error was from the general log.