Thanks for the heads-up on those documentation pieces!
In the local-lightning.log
file, I’m seeing a number of messages that relate to MySQL. For example, things like this:
mysqld: Could not create or access the registry key needed for the MySQL application
to log to the Windows EventLog. Run the application with sufficient
privileges once to create the key, add the key manually, or turn off
logging for that application.
2020-10-12T18:10:15.181160Z 0 [Warning] TIMESTAMP with implicit DEFAULT value is deprecated. Please use --explicit_defaults_for_timestamp server option (see documentation for more details).
2020-10-12T18:10:15.181327Z 0 [Note] --secure-file-priv is set to NULL. Operations related to importing and exporting data are disabled
2020-10-12T18:10:15.181731Z 0 [ERROR] Cannot open Windows EventLog; check privileges, or start server with --log_syslog=0
2020-10-12T18:10:15.181762Z 0 [Note] %%userDataPath%%\\lightning-services\\mysql-5.7.28+4\\bin\\win64\\bin\\mysqld.exe (mysqld 5.7.28) starting as process 22396 ...
2020-10-12T18:10:15.196131Z 0 [Note] InnoDB: Mutexes and rw_locks use Windows interlocked functions
2020-10-12T18:10:15.196167Z 0 [Note] InnoDB: Uses event mutexes
2020-10-12T18:10:15.196182Z 0 [Note] InnoDB: _mm_lfence() and _mm_sfence() are used for memory barrier
2020-10-12T18:10:15.196194Z 0 [Note] InnoDB: Compressed tables use zlib 1.2.11
2020-10-12T18:10:15.197491Z 0 [Note] InnoDB: Number of pools: 1
2020-10-12T18:10:15.197780Z 0 [Note] InnoDB: Not using CPU crc32 instructions
2020-10-12T18:10:15.203283Z 0 [Note] InnoDB: Initializing buffer pool, total size = 32M, instances = 1, chunk size = 32M
2020-10-12T18:10:15.207333Z 0 [Note] InnoDB: Completed initialization of buffer pool
2020-10-12T18:10:15.599971Z 0 [Note] InnoDB: Highest supported file format is Barracuda.
2020-10-12T18:10:15.605271Z 0 [Note] InnoDB: Log scan progressed past the checkpoint lsn 3476900
2020-10-12T18:10:15.605303Z 0 [Note] InnoDB: Doing recovery: scanned up to log sequence number 3476909
2020-10-12T18:10:15.605325Z 0 [Note] InnoDB: Database was not shutdown normally!
2020-10-12T18:10:15.605335Z 0 [Note] InnoDB: Starting crash recovery.
2020-10-12T18:10:16.038454Z 0 [Note] InnoDB: Removed temporary tablespace data file: "ibtmp1"
2020-10-12T18:10:16.038491Z 0 [Note] InnoDB: Creating shared tablespace for temporary tables
2020-10-12T18:10:16.041365Z 0 [Note] InnoDB: Setting file '.\\ibtmp1' size to 12 MB. Physically writing the file full; Please wait ...
2020-10-12T18:10:16.375100Z 0 [Note] InnoDB: File '.\\ibtmp1' size is now 12 MB.
2020-10-12T18:10:16.402930Z 0 [Note] InnoDB: 96 redo rollback segment(s) found. 96 redo rollback segment(s) are active.
2020-10-12T18:10:16.402966Z 0 [Note] InnoDB: 32 non-redo rollback segment(s) are active.
2020-10-12T18:10:16.403637Z 0 [Note] InnoDB: Waiting for purge to start
2020-10-12T18:10:16.457324Z 0 [Note] InnoDB: 5.7.28 started; log sequence number 3476909
2020-10-12T18:10:16.458416Z 0 [Note] Plugin 'FEDERATED' is disabled.
2020-10-12T18:10:16.460608Z 0 [Note] InnoDB: Loading buffer pool(s) from %%userDataPath%%\\run\\S23DJPIDe\\mysql\\data\\ib_buffer_pool
2020-10-12T18:10:16.533035Z 0 [Note] Found ca.pem, server-cert.pem and server-key.pem in data directory. Trying to enable SSL support using them.
2020-10-12T18:10:16.533079Z 0 [Note] Skipping generation of SSL certificates as certificate files are present in data directory.
2020-10-12T18:10:16.535732Z 0 [Warning] CA certificate ca.pem is self signed.
2020-10-12T18:10:16.536096Z 0 [Note] Skipping generation of RSA key pair as key files are present in data directory.
2020-10-12T18:10:16.536585Z 0 [Note] Server hostname (bind-address): '127.0.0.1'; port: 10004
2020-10-12T18:10:16.536903Z 0 [Note] - '127.0.0.1' resolves to '127.0.0.1';
2020-10-12T18:10:16.537016Z 0 [Note] Server socket created on IP: '127.0.0.1'.
2020-10-12T18:10:16.585533Z 0 [Note] InnoDB: Buffer pool(s) load completed at 201012 20:10:16
2020-10-12T18:10:16.641075Z 0 [Note] Event Scheduler: Loaded 0 events
2020-10-12T18:10:16.641324Z 0 [Note] %%userDataPath%%\\lightning-services\\mysql-5.7.28+4\\bin\\win64\\bin\\mysqld.exe: ready for connections.
I’m not 100% sure what it all means, but does this happen for every Apache site that you try to create? The part that mentions Cannot open Windows EventLog;
makes me think that there may be a permissions issue. Did you notice if there are system prompts opening correctly when creating the new site?