I can not setting up a site with custom Settings

Support
1

I can not setting up a site with custom Settings.
Setting up a site with preferred settings works.
Running 6.1.5+5536 on:
Microsoft Windows 10 Pro / 10.0.19043 Build 19043
Log file:
{“thread”:“main”,“class”:“SiteProvisionerService”,“message”:“Creating site folders…”,“level”:“info”,“timestamp”:“2021-11-20T08:00:19.056Z”}
{“thread”:“main”,“class”:“SiteProvisionerService”,“message”:“Copying service config templates…”,“level”:“info”,“timestamp”:“2021-11-20T08:00:19.067Z”}
{“thread”:“main”,“class”:“ConfigTemplatesService”,“message”:“Compiling service configs…”,“level”:“info”,“timestamp”:“2021-11-20T08:00:19.133Z”}
{“thread”:“main”,“service”:{},“serviceBinVersion”:{},“dataPath”:“C:/Users/gerd/AppData/Roaming/Local/run/cptR9gCTM/mysql/data”,“level”:“info”,“message”:“Initializing MySQL datadir…”,“timestamp”:“2021-11-20T08:00:19.259Z”}
{“thread”:“main”,“class”:“ConfigTemplatesService”,“message”:“Compiling service configs…”,“level”:“info”,“timestamp”:“2021-11-20T08:01:27.238Z”}
{“thread”:“main”,“class”:“Process”,“process”:“mysql”,“level”:“warn”,“message”:“mysqld: Could not create or access the registry key needed for the MySQL application”,“timestamp”:“2021-11-20T08:01:27.565Z”}
{“thread”:“main”,“class”:“Process”,“process”:“mysql”,“level”:“warn”,“message”:“to log to the Windows EventLog. Run the application with sufficient”,“timestamp”:“2021-11-20T08:01:27.565Z”}
{“thread”:“main”,“class”:“Process”,“process”:“mysql”,“level”:“warn”,“message”:“privileges once to create the key, add the key manually, or turn off”,“timestamp”:“2021-11-20T08:01:27.566Z”}
{“thread”:“main”,“class”:“Process”,“process”:“mysql”,“level”:“warn”,“message”:“logging for that application.”,“timestamp”:“2021-11-20T08:01:27.567Z”}
{“thread”:“main”,“class”:“Process”,“process”:“mysql”,“level”:“warn”,“message”:“2021-11-20T08:01:27.544569Z 0 [Warning] TIMESTAMP with implicit DEFAULT value is deprecated. Please use --explicit_defaults_for_timestamp server option (see documentation for more details).”,“timestamp”:“2021-11-20T08:01:27.577Z”}
{“thread”:“main”,“class”:“Process”,“process”:“mysql”,“level”:“warn”,“message”:“2021-11-20T08:01:27.545597Z 0 [Note] --secure-file-priv is set to NULL. Operations related to importing and exporting data are disabled”,“timestamp”:“2021-11-20T08:01:27.577Z”}
{“thread”:“main”,“class”:“Process”,“process”:“mysql”,“level”:“warn”,“message”:“2021-11-20T08:01:27.564007Z 0 [ERROR] Cannot open Windows EventLog; check privileges, or start server with --log_syslog=0”,“timestamp”:“2021-11-20T08:01:27.578Z”}
{“thread”:“main”,“class”:“Process”,“process”:“mysql”,“level”:“warn”,“message”:“2021-11-20T08:01:27.566802Z 0 [Note] %%userDataPath%%\lightning-services\mysql-5.7.28+4\bin\win64\bin\mysqld.exe (mysqld 5.7.28) starting as process 11236 …”,“timestamp”:“2021-11-20T08:01:27.579Z”}
{“thread”:“main”,“class”:“Process”,“process”:“mysql”,“level”:“warn”,“message”:“2021-11-20T08:01:27.567236Z 0 [ERROR] Can’t find error-message file ‘%%userDataPath%%\lightning-services\mysql-5.7.28+4\bin\win64\share\errmsg.sys’. Check error-message file location and ‘lc-messages-dir’ configuration directive.”,“timestamp”:“2021-11-20T08:01:27.580Z”}
{“thread”:“main”,“class”:“Process”,“process”:“mysql”,“level”:“warn”,“message”:“2021-11-20T08:01:27.577908Z 0 [Note] InnoDB: Mutexes and rw_locks use Windows interlocked functions”,“timestamp”:“2021-11-20T08:01:27.581Z”}
{“thread”:“main”,“class”:“Process”,“process”:“mysql”,“level”:“warn”,“message”:“2021-11-20T08:01:27.577943Z 0 [Note] InnoDB: Uses event mutexes”,“timestamp”:“2021-11-20T08:01:27.582Z”}
{“thread”:“main”,“class”:“Process”,“process”:“mysql”,“level”:“warn”,“message”:“2021-11-20T08:01:27.577959Z 0 [Note] InnoDB: _mm_lfence() and _mm_sfence() are used for memory barrier”,“timestamp”:“2021-11-20T08:01:27.583Z”}
{“thread”:“main”,“class”:“Process”,“process”:“mysql”,“level”:“warn”,“message”:“2021-11-20T08:01:27.577977Z 0 [Note] InnoDB: Compressed tables use zlib 1.2.11”,“timestamp”:“2021-11-20T08:01:27.584Z”}
{“thread”:“main”,“class”:“Process”,“process”:“mysql”,“level”:“warn”,“message”:“2021-11-20T08:01:27.578734Z 0 [Note] InnoDB: Number of pools: 1”,“timestamp”:“2021-11-20T08:01:27.585Z”}
{“thread”:“main”,“class”:“Process”,“process”:“mysql”,“level”:“warn”,“message”:“2021-11-20T08:01:27.579010Z 0 [Note] InnoDB: Not using CPU crc32 instructions”,“timestamp”:“2021-11-20T08:01:27.585Z”}
{“thread”:“main”,“class”:“Process”,“process”:“mysql”,“level”:“warn”,“message”:“2021-11-20T08:01:27.594745Z 0 [Note] InnoDB: Initializing buffer pool, total size = 32M, instances = 1, chunk size = 32M”,“timestamp”:“2021-11-20T08:01:27.595Z”}
{“thread”:“main”,“class”:“Process”,“process”:“mysql”,“level”:“warn”,“message”:“2021-11-20T08:01:27.598724Z 0 [Note] InnoDB: Completed initialization of buffer pool”,“timestamp”:“2021-11-20T08:01:27.599Z”}
{“thread”:“main”,“service”:{},“serviceBinVersion”:{},“message”:“Setting up MySQL user…”,“level”:“info”,“timestamp”:“2021-11-20T08:01:27.721Z”}
{“thread”:“main”,“class”:“Process”,“process”:“mysql”,“level”:“warn”,“message”:“2021-11-20T08:01:27.725978Z 0 [Note] InnoDB: Highest supported file format is Barracuda.”,“timestamp”:“2021-11-20T08:01:27.726Z”}
{“thread”:“main”,“class”:“Process”,“process”:“mysql”,“level”:“warn”,“message”:“2021-11-20T08:01:27.990446Z 0 [Note] InnoDB: Creating shared tablespace for temporary tables”,“timestamp”:“2021-11-20T08:01:27.991Z”}
{“thread”:“main”,“class”:“Process”,“process”:“mysql”,“level”:“warn”,“message”:“2021-11-20T08:01:27.991700Z 0 [Note] InnoDB: Setting file ‘.\ibtmp1’ size to 12 MB. Physically writing the file full; Please wait …”,“timestamp”:“2021-11-20T08:01:27.992Z”}
{“thread”:“main”,“class”:“Process”,“process”:“mysql”,“level”:“warn”,“message”:“2021-11-20T08:01:28.036579Z 0 [Note] InnoDB: File ‘.\ibtmp1’ size is now 12 MB.”,“timestamp”:“2021-11-20T08:01:28.037Z”}
{“thread”:“main”,“class”:“Process”,“process”:“mysql”,“level”:“warn”,“message”:“2021-11-20T08:01:28.046032Z 0 [Note] InnoDB: 96 redo rollback segment(s) found. 96 redo rollback segment(s) are active.”,“timestamp”:“2021-11-20T08:01:28.047Z”}
{“thread”:“main”,“class”:“Process”,“process”:“mysql”,“level”:“warn”,“message”:“2021-11-20T08:01:28.046057Z 0 [Note] InnoDB: 32 non-redo rollback segment(s) are active.”,“timestamp”:“2021-11-20T08:01:28.047Z”}
{“thread”:“main”,“class”:“Process”,“process”:“mysql”,“level”:“warn”,“message”:“2021-11-20T08:01:28.047199Z 0 [Note] InnoDB: 5.7.28 started; log sequence number 2628896”,“timestamp”:“2021-11-20T08:01:28.049Z”}
{“thread”:“main”,“class”:“Process”,“process”:“mysql”,“level”:“warn”,“message”:“2021-11-20T08:01:28.047650Z 0 [Note] InnoDB: Loading buffer pool(s) from %%userDataPath%%\run\cptR9gCTM\mysql\data\ib_buffer_pool”,“timestamp”:“2021-11-20T08:01:28.050Z”}
{“thread”:“main”,“class”:“Process”,“process”:“mysql”,“level”:“warn”,“message”:“2021-11-20T08:01:28.047820Z 0 [Note] Plugin ‘FEDERATED’ is disabled.”,“timestamp”:“2021-11-20T08:01:28.051Z”}
{“thread”:“main”,“class”:“Process”,“process”:“mysql”,“level”:“warn”,“message”:“2021-11-20T08:01:28.075193Z 0 [Note] InnoDB: Buffer pool(s) load completed at 211120 9:01:28”,“timestamp”:“2021-11-20T08:01:28.076Z”}
{“thread”:“main”,“class”:“Process”,“process”:“mysql”,“level”:“warn”,“message”:“2021-11-20T08:01:28.089421Z 0 [Note] Found ca.pem, server-cert.pem and server-key.pem in data directory. Trying to enable SSL support using them.”,“timestamp”:“2021-11-20T08:01:28.090Z”}
{“thread”:“main”,“class”:“Process”,“process”:“mysql”,“level”:“warn”,“message”:“2021-11-20T08:01:28.089452Z 0 [Note] Skipping generation of SSL certificates as certificate files are present in data directory.”,“timestamp”:“2021-11-20T08:01:28.090Z”}
{“thread”:“main”,“class”:“Process”,“process”:“mysql”,“level”:“warn”,“message”:“2021-11-20T08:01:28.093787Z 0 [Warning] CA certificate ca.pem is self signed.”,“timestamp”:“2021-11-20T08:01:28.094Z”}
{“thread”:“main”,“class”:“Process”,“process”:“mysql”,“level”:“warn”,“message”:“2021-11-20T08:01:28.095856Z 0 [Note] Skipping generation of RSA key pair as key files are present in data directory.”,“timestamp”:“2021-11-20T08:01:28.096Z”}
{“thread”:“main”,“class”:“Process”,“process”:“mysql”,“level”:“warn”,“message”:“2021-11-20T08:01:28.096750Z 0 [Note] Server hostname (bind-address): ‘127.0.0.1’; port: 10004”,“timestamp”:“2021-11-20T08:01:28.097Z”}
{“thread”:“main”,“class”:“Process”,“process”:“mysql”,“level”:“warn”,“message”:“2021-11-20T08:01:28.099915Z 0 [Note] - ‘127.0.0.1’ resolves to ‘127.0.0.1’;”,“timestamp”:“2021-11-20T08:01:28.100Z”}
{“thread”:“main”,“class”:“Process”,“process”:“mysql”,“level”:“warn”,“message”:“2021-11-20T08:01:28.100208Z 0 [Note] Server socket created on IP: ‘127.0.0.1’.”,“timestamp”:“2021-11-20T08:01:28.102Z”}
{“thread”:“main”,“class”:“HostsFileService”,“level”:“info”,“message”:“Updating hosts with”,“timestamp”:“2021-11-20T08:01:28.268Z”}
{“thread”:“main”,“class”:“Process”,“process”:“mysql”,“level”:“warn”,“message”:“2021-11-20T08:01:28.279229Z 0 [Note] Event Scheduler: Loaded 0 events”,“timestamp”:“2021-11-20T08:01:28.306Z”}
{“thread”:“main”,“class”:“Process”,“process”:“mysql”,“level”:“warn”,“message”:“2021-11-20T08:01:28.279603Z 0 [Note] “,“timestamp”:“2021-11-20T08:01:28.307Z”}
{“thread”:“main”,“class”:“HostsFileService”,“stdout”:“Updating hosts file at C:\WINDOWS\System32\drivers\etc\hosts\nUpdated hosts file at C:\WINDOWS\System32\drivers\etc\hosts\n”,“stderr”:””,“level”:“info”,“message”:“Updated hosts.”,“timestamp”:“2021-11-20T08:01:34.422Z”}
{“thread”:“main”,“service”:{},“serviceBinVersion”:{},“stack”:“Error: spawn %%userDataPath%%\lightning-services\mysql-5.7.28+4\bin\win64\bin\mysqladmin.exe ENOENT\n at Process.ChildProcess._handle.onexit (internal/child_process.js:269:19)\n at onErrorNT (internal/child_process.js:465:16)\n at processTicksAndRejections (internal/process/task_queues.js:80:21)”,“level”:“error”,“message”:“Database did not respond to ping after 15 tries.”,“timestamp”:“2021-11-20T08:01:35.795Z”}
{“thread”:“main”,“class”:“Process”,“process”:“mailhog”,“pid”:11532,“level”:“info”,“message”:“Killing process”,“timestamp”:“2021-11-20T08:01:35.798Z”}
{“thread”:“main”,“class”:“Process”,“process”:“phpCgi”,“pid”:18676,“level”:“info”,“message”:“Killing process”,“timestamp”:“2021-11-20T08:01:35.829Z”}
{“thread”:“main”,“class”:“Process”,“process”:“phpCgi”,“pid”:11704,“level”:“info”,“message”:“Killing process”,“timestamp”:“2021-11-20T08:01:35.872Z”}
{“thread”:“main”,“class”:“Process”,“process”:“mysql”,“pid”:11236,“level”:“info”,“message”:“Killing process”,“timestamp”:“2021-11-20T08:01:35.918Z”}
{“thread”:“main”,“class”:“Process”,“process”:“httpd”,“pid”:10876,“level”:“info”,“message”:“Killing process”,“timestamp”:“2021-11-20T08:01:35.962Z”}
{“thread”:“main”,“class”:“Process”,“process”:“nodejs”,“pid”:12524,“level”:“info”,“message”:“Killing process”,“timestamp”:“2021-11-20T08:01:36.008Z”}
{“thread”:“main”,“class”:“SiteProvisionerService”,“stack”:“Error: spawn %%userDataPath%%\lightning-services\mysql-5.7.28+4\bin\win64\bin\mysqladmin.exe ENOENT\n at Process.ChildProcess._handle.onexit (internal/child_process.js:269:19)\n at onErrorNT (internal/child_process.js:465:16)\n at processTicksAndRejections (internal/process/task_queues.js:80:21)”,“level”:“error”,“message”:“Unable to provision site.”,“timestamp”:“2021-11-20T08:01:36.050Z”}
{“thread”:“main”,“reason”:{“errno”:-4058,“code”:“ENOENT”,“syscall”:“spawn %%userDataPath%%\lightning-services\mysql-5.7.28+4\bin\win64\bin\mysqladmin.exe”,“path”:"%%userDataPath%%\lightning-services\mysql-5.7.28+4\bin\win64\bin\mysqladmin.exe",“spawnargs”:["–password=",“ping”],“cmd”:"%%userDataPath%%\lightning-services\mysql-5.7.28+4\bin\win64\bin\mysqladmin.exe --password= ping"},“p”:{},“level”:“warn”,“message”:“Unhandled Rejection.”,“timestamp”:“2021-11-20T08:01:38.076Z”}
{“thread”:“main”,“class”:“DeleteSiteService”,“message”:“Deleting %%userDataPath%%\run\cptR9gCTM”,“level”:“info”,“timestamp”:“2021-11-20T08:01:38.099Z”}
{“thread”:“main”,“class”:“HostsFileService”,“level”:“info”,“message”:“Updating hosts with”,“timestamp”:“2021-11-20T08:02:01.164Z”}
{“thread”:“main”,“class”:“HostsFileService”,“stdout”:“Updating hosts file at C:\WINDOWS\System32\drivers\etc\hosts\nUpdated hosts file at C:\WINDOWS\System32\drivers\etc\hosts\n”,“stderr”:"",“level”:“info”,“message”:“Updated hosts.”,“timestamp”:“2021-11-20T08:02:04.684Z”}

2

Installed local 6.1.7 +5610 - still the same problem.
Any help?

3

Done.I uninstalled everything, deleted remaining files and folders and reinstalled Local. Perfect!

4

This topic was automatically closed 90 days after the last reply. New replies are no longer allowed.