Mysqld doesn't start

Support
,
1

What issue or error are you experiencing?

when trying to create a site, I get the “unable to provision” error. the local mysqld won’t launch, and the process repeatedly shuts down.

What steps can be taken to replicate the issue? Feel free to include screenshots, videos, etc

System Details

  • Local Version: 7.1…2

  • Operating System (OS) and OS version:
    Arch Linux ( up to date)

Local Logs

Attach your Local Logs here (Help Doc - Retrieving Local’s Log)
The zipfile thta local creates is empty! but I think I’ve found the relevant section in the messages when launched from a terminal:

10/6/2023, 8:42:05 AM [info] [main] SiteProvisionerService: Copying service config templates...
10/6/2023, 8:42:06 AM [info] [main] ConfigTemplatesService: Compiling service configs...
10/6/2023, 8:42:06 AM [info] [main] undefined: Initializing MySQL datadir... -- {"service":{},"serviceBinVersion":{},"dataPath":"%%site.runData%%/mysql/data"}
10/6/2023, 8:42:10 AM [info] [main] ConfigTemplatesService: Compiling service configs...
10/6/2023, 8:42:11 AM [warn] [main] Process: 2023-10-06T12:42:11.180071Z 0 [System] [MY-010116] [Server] %%resourcesPath%%/lightning-services/mysql-8.0.16+6/bin/linux/bin/mysqld (mysqld 8.0.16) starting as process 1257773 -- {"process":"mysql"}
10/6/2023, 8:42:11 AM [warn] [main] Process: 2023-10-06T12:42:11.181672Z 0 [Warning] [MY-013243] [Server] --character-set-server: The character set UTF8MB3 is deprecated and will be removed in a future release. Please consider using UTF8MB4 instead. -- {"process":"mysql"}
10/6/2023, 8:42:11 AM [warn] [main] Process: 2023-10-06T12:42:11.645438Z 0 [Warning] [MY-010068] [Server] CA certificate ca.pem is self signed. -- {"process":"mysql"}
10/6/2023, 8:42:11 AM [warn] [main] Process: 2023-10-06T12:42:11.645618Z 0 [ERROR] [MY-010262] [Server] Can't start server: Bind on TCP/IP port: Cannot assign requested address -- {"process":"mysql"}
10/6/2023, 8:42:11 AM [warn] [main] Process: 2023-10-06T12:42:11.645621Z 0 [ERROR] [MY-010257] [Server] Do you already have another mysqld server running on port: 10009 ? -- {"process":"mysql"}
10/6/2023, 8:42:13 AM [warn] [main] Process: 2023-10-06T12:42:11.645764Z 0 [ERROR] [MY-010119] [Server] Aborting -- {"process":"mysql"}
10/6/2023, 8:42:13 AM [warn] [main] Process: 2023-10-06T12:42:13.372049Z 0 [System] [MY-010910] [Server] %%resourcesPath%%/lightning-services/mysql-8.0.16+6/bin/linux/bin/mysqld: Shutdown complete (mysqld 8.0.16)  MySQL Community Server - GPL. -- {"process":"mysql"}
10/6/2023, 8:42:14 AM [warn] [main] Process: 2023-10-06T12:42:14.070012Z 0 [System] [MY-010116] [Server] %%resourcesPath%%/lightning-services/mysql-8.0.16+6/bin/linux/bin/mysqld (mysqld 8.0.16) starting as process 1257834 -- {"process":"mysql"}
10/6/2023, 8:42:14 AM [warn] [main] Process: 2023-10-06T12:42:14.075242Z 0 [Warning] [MY-013243] [Server] --character-set-server: The character set UTF8MB3 is deprecated and will be removed in a future release. Please consider using UTF8MB4 instead. -- {"process":"mysql"}
10/6/2023, 8:42:14 AM [warn] [main] Process: 2023-10-06T12:42:14.464901Z 0 [Warning] [MY-010068] [Server] CA certificate ca.pem is self signed. -- {"process":"mysql"}
10/6/2023, 8:42:14 AM [warn] [main] Process: 2023-10-06T12:42:14.465055Z 0 [ERROR] [MY-010262] [Server] Can't start server: Bind on TCP/IP port: Cannot assign requested address -- {"process":"mysql"}
10/6/2023, 8:42:14 AM [warn] [main] Process: 2023-10-06T12:42:14.465058Z 0 [ERROR] [MY-010257] [Server] Do you already have another mysqld server running on port: 10009 ? -- {"process":"mysql"}
10/6/2023, 8:42:15 AM [warn] [main] Process: 2023-10-06T12:42:14.465191Z 0 [ERROR] [MY-010119] [Server] Aborting -- {"process":"mysql"}
10/6/2023, 8:42:15 AM [warn] [main] Process: 2023-10-06T12:42:15.782228Z 0 [System] [MY-010910] [Server] %%resourcesPath%%/lightning-services/mysql-8.0.16+6/bin/linux/bin/mysqld: Shutdown complete (mysqld 8.0.16)  MySQL Community Server - GPL. -- {"process":"mysql"}
10/6/2023, 8:42:16 AM [warn] [main] Process: 2023-10-06T12:42:16.460034Z 0 [System] [MY-010116] [Server] %%resourcesPath%%/lightning-services/mysql-8.0.16+6/bin/linux/bin/mysqld (mysqld 8.0.16) starting as process 1257871 -- {"process":"mysql"}
10/6/2023, 8:42:16 AM [warn] [main] Process: 2023-10-06T12:42:16.465338Z 0 [Warning] [MY-013243] [Server] --character-set-server: The character set UTF8MB3 is deprecated and will be removed in a future release. Please consider using UTF8MB4 instead. -- {"process":"mysql"}

Security Reminder
Local does a pretty good job of scrubbing private info from the logs and the errors it produces, however there’s always the possibility that something private can come through. Because these are public forums, always review the screenshots you are sharing to make sure there isn’t private info like passwords being displayed.

thanks all!

2

Hi @titaniumbones

Some things you could check:

  • See if any antivirus, security, or firewall applications could be blocking Local

  • If you have other Developer Apps like MAMP, XAMPP, or Docker for example installed that could be port-blocking

  • If changing your Router Mode allows you to proceed: Preferences>Advanced>Router Mode>Localhost

3

thanks @Nick-B !

  • no firewall running right now
  • docker’s installed but not running
  • hmm I think Router mode is a non-linux thing (anyway, I don’t see it in Gnome). I can run various other applications on localhost & easily access their webservers on arbitrary ports.

is there a trick somewhere that would let me get more verbose messages about the mysql startup failure?

4

If you click on the Download Local Logs button in the Support Tab of the app that should generate a zip with all of your logging in it. I’m not sure if that’s what you did previously I see you mentioned not seeing much in your logs beforehand.

Was Local working normally for you until an update or something or was this your first attempt at getting it started? Are you on version 7.1.2 or 7.2.1?

If you’re still on 7.1, you might try doing a big refresh and updating to the latest release.

  • Export any sites that you have on Local and save them to a folder somewhere on your computer.

  • Fully uninstall Local from your computer.

  • Install the latest version of Local on this link.

  • Once installed, please restart the computer.

  • When the computer is restarted and turned on, close any applications that automatically run in the background (AntiVirus, Firewall, and other Developer applications included).

  • Check and see if the issue still persists. If so, please provide us with an updated log. Retrieving Local’s Log File

Keep us posted and we’d be happy to help further!

5

this time the log files were produced, they’re attached below. thanks.

Was Local working normally for you until an update or something or was this your first attempt at getting it started? Are you on version 7.1.2 or 7.2.1?

If you’re still on 7.1, you might try doing a big refresh and updating to the latest release.

  • removed ~/.config/Local and ~/Local Sites
  • upgraded to 7.2.1, issue seems to be persisting
    ran http-server -p 10009 and http-server -p 10004 with no difficulty, so I don’t htink there’s anything blocking the prots. And I can start the system mariadb with no problems, though I don’t know if that information really helps.

logs:

{"thread":"main","message":"Finished maybeCopyBundledServices in 1.894s","level":"info","timestamp":"2023-10-06T13:22:36.432Z"}
{"thread":"main","class":"AddonLoaderService","level":"info","message":"Loading Add-on: %%userDataPath%%/lightning-services/mailhog-1.0.0+3/lib/main.js","timestamp":"2023-10-06T13:22:36.435Z"}
{"thread":"main","class":"AddonLoaderService","level":"info","message":"Successfully Loaded Add-on: %%userDataPath%%/lightning-services/mailhog-1.0.0+3/lib/main.js","timestamp":"2023-10-06T13:22:36.437Z"}
{"thread":"main","class":"AddonLoaderService","level":"info","message":"Loading Add-on: %%userDataPath%%/lightning-services/mariadb-10.4.10+4/lib/main.js","timestamp":"2023-10-06T13:22:36.438Z"}
{"thread":"main","class":"AddonLoaderService","level":"info","message":"Successfully Loaded Add-on: %%userDataPath%%/lightning-services/mariadb-10.4.10+4/lib/main.js","timestamp":"2023-10-06T13:22:36.463Z"}
{"thread":"main","class":"AddonLoaderService","level":"info","message":"Loading Add-on: %%userDataPath%%/lightning-services/mysql-8.0.16+6/lib/main.js","timestamp":"2023-10-06T13:22:36.464Z"}
{"thread":"main","class":"AddonLoaderService","level":"info","message":"Successfully Loaded Add-on: %%userDataPath%%/lightning-services/mysql-8.0.16+6/lib/main.js","timestamp":"2023-10-06T13:22:36.498Z"}
{"thread":"main","class":"AddonLoaderService","level":"info","message":"Loading Add-on: %%userDataPath%%/lightning-services/nginx-1.16.0+6/lib/main.js","timestamp":"2023-10-06T13:22:36.501Z"}
{"thread":"main","class":"AddonLoaderService","level":"info","message":"Successfully Loaded Add-on: %%userDataPath%%/lightning-services/nginx-1.16.0+6/lib/main.js","timestamp":"2023-10-06T13:22:36.539Z"}
{"thread":"main","class":"AddonLoaderService","level":"info","message":"Loading Add-on: %%userDataPath%%/lightning-services/php-8.1.23+0/lib/main.js","timestamp":"2023-10-06T13:22:36.542Z"}
{"thread":"main","class":"AddonLoaderService","level":"info","message":"Successfully Loaded Add-on: %%userDataPath%%/lightning-services/php-8.1.23+0/lib/main.js","timestamp":"2023-10-06T13:22:36.587Z"}
{"thread":"main","class":"AddonLoaderService","message":"Add-on does not have \"productName\" specified in package.json: %%appPath%%/node_modules/@getflywheel/local-components/package.json","level":"info","timestamp":"2023-10-06T13:22:36.592Z"}
{"thread":"main","class":"AddonLoaderService","message":"Add-on does not have \"productName\" specified in package.json: %%appPath%%/node_modules/@getflywheel/localcert/package.json","level":"info","timestamp":"2023-10-06T13:22:36.594Z"}
{"thread":"main","class":"AddonLoaderService","message":"Add-on does not have \"productName\" specified in package.json: %%appPath%%/node_modules/@getflywheel/localtunnel/package.json","level":"info","timestamp":"2023-10-06T13:22:36.596Z"}
{"thread":"main","class":"AddonLoaderService","message":"Add-on does not have \"main\" or \"renderer\" specified in package.json: %%appPath%%/node_modules/@getflywheel/replacestream/package.json","level":"info","timestamp":"2023-10-06T13:22:36.598Z"}
{"thread":"main","name":"DeprecationWarning","code":"DEP0128","level":"info","message":"Warning:Invalid 'main' field in '%%appPath%%/node_modules/ssh-key-to-pem/package.json' of 'lib/index.js'. Please either fix that or report it to the module author","stack":"DeprecationWarning: Invalid 'main' field in '%%appPath%%/node_modules/ssh-key-to-pem/package.json' of 'lib/index.js'. Please either fix that or report it to the module author\n    at tryPackage (node:internal/modules/cjs/loader:371:15)\n    at Module._findPath (node:internal/modules/cjs/loader:573:18)\n    at Module._resolveFilename (node:internal/modules/cjs/loader:926:27)\n    at n._resolveFilename (node:electron/js2c/browser_init:249:1105)\n    at Module._resolveFilename (%%appPath%%/node_modules/module-alias/index.js:49:29)\n    at Module._load (node:internal/modules/cjs/loader:785:27)\n    at c._load (node:electron/js2c/asar_bundle:5:13339)\n    at Module.require (node:internal/modules/cjs/loader:1012:19)\n    at require (node:internal/modules/cjs/helpers:102:18)\n    at Object.<anonymous> (%%appPath%%/main/capi/SSHKeyService.js:1:670)","timestamp":"2023-10-06T13:22:36.612Z"}
{"thread":"main","class":"GraphQLService","message":"GraphQL server ready at http://127.0.0.1:4000/graphql","level":"verbose","timestamp":"2023-10-06T13:22:36.749Z"}
{"thread":"main","class":"GraphQLService","message":"GraphQL subscriptions ready at ws://127.0.0.1:4000/graphql","level":"verbose","timestamp":"2023-10-06T13:22:36.749Z"}
{"localVersion":"7.2.1+6433","osPlatform":"linux","osRelease":"6.5.3-arch1-1","osArch":"x64","windowsEdition":null,"linuxEdition":null,"level":"warn","message":"Electron Event ready","timestamp":"2023-10-06T13:22:36.906Z"}
{"thread":"main","class":"Updater","level":"info","message":"Checking for updates for: linux-x64-production","timestamp":"2023-10-06T13:22:58.549Z"}
{"thread":"main","class":"Updater","release":null,"level":"debug","message":"Check for updates result","timestamp":"2023-10-06T13:22:59.360Z"}
{"message":"Electron Event second-instance","level":"info","timestamp":"2023-10-06T13:23:34.761Z"}
{"thread":"main","message":"Finished maybeCopyBundledServices in 0.002s","level":"info","timestamp":"2023-10-06T13:23:34.790Z"}
{"thread":"main","class":"AddonLoaderService","level":"info","message":"Loading Add-on: %%userDataPath%%/lightning-services/mailhog-1.0.0+3/lib/main.js","timestamp":"2023-10-06T13:23:34.796Z"}
{"thread":"main","class":"AddonLoaderService","level":"info","message":"Successfully Loaded Add-on: %%userDataPath%%/lightning-services/mailhog-1.0.0+3/lib/main.js","timestamp":"2023-10-06T13:23:34.799Z"}
{"thread":"main","class":"AddonLoaderService","level":"info","message":"Loading Add-on: %%userDataPath%%/lightning-services/mariadb-10.4.10+4/lib/main.js","timestamp":"2023-10-06T13:23:34.801Z"}
{"thread":"main","class":"AddonLoaderService","level":"info","message":"Successfully Loaded Add-on: %%userDataPath%%/lightning-services/mariadb-10.4.10+4/lib/main.js","timestamp":"2023-10-06T13:23:34.833Z"}
{"thread":"main","class":"AddonLoaderService","level":"info","message":"Loading Add-on: %%userDataPath%%/lightning-services/mysql-8.0.16+6/lib/main.js","timestamp":"2023-10-06T13:23:34.835Z"}
{"thread":"main","class":"AddonLoaderService","level":"info","message":"Successfully Loaded Add-on: %%userDataPath%%/lightning-services/mysql-8.0.16+6/lib/main.js","timestamp":"2023-10-06T13:23:34.866Z"}
{"thread":"main","class":"AddonLoaderService","level":"info","message":"Loading Add-on: %%userDataPath%%/lightning-services/nginx-1.16.0+6/lib/main.js","timestamp":"2023-10-06T13:23:34.871Z"}
{"thread":"main","class":"AddonLoaderService","level":"info","message":"Successfully Loaded Add-on: %%userDataPath%%/lightning-services/nginx-1.16.0+6/lib/main.js","timestamp":"2023-10-06T13:23:34.893Z"}
{"thread":"main","class":"AddonLoaderService","level":"info","message":"Loading Add-on: %%userDataPath%%/lightning-services/php-8.1.23+0/lib/main.js","timestamp":"2023-10-06T13:23:34.894Z"}
{"thread":"main","class":"AddonLoaderService","level":"info","message":"Successfully Loaded Add-on: %%userDataPath%%/lightning-services/php-8.1.23+0/lib/main.js","timestamp":"2023-10-06T13:23:34.913Z"}
{"thread":"main","class":"AddonLoaderService","message":"Add-on does not have \"productName\" specified in package.json: %%appPath%%/node_modules/@getflywheel/local-components/package.json","level":"info","timestamp":"2023-10-06T13:23:34.915Z"}
{"thread":"main","class":"AddonLoaderService","message":"Add-on does not have \"productName\" specified in package.json: %%appPath%%/node_modules/@getflywheel/localcert/package.json","level":"info","timestamp":"2023-10-06T13:23:34.917Z"}
{"thread":"main","class":"AddonLoaderService","message":"Add-on does not have \"productName\" specified in package.json: %%appPath%%/node_modules/@getflywheel/localtunnel/package.json","level":"info","timestamp":"2023-10-06T13:23:34.918Z"}
{"thread":"main","class":"AddonLoaderService","message":"Add-on does not have \"main\" or \"renderer\" specified in package.json: %%appPath%%/node_modules/@getflywheel/replacestream/package.json","level":"info","timestamp":"2023-10-06T13:23:34.919Z"}
{"thread":"main","name":"DeprecationWarning","code":"DEP0128","level":"info","message":"Warning:Invalid 'main' field in '%%appPath%%/node_modules/ssh-key-to-pem/package.json' of 'lib/index.js'. Please either fix that or report it to the module author","stack":"DeprecationWarning: Invalid 'main' field in '%%appPath%%/node_modules/ssh-key-to-pem/package.json' of 'lib/index.js'. Please either fix that or report it to the module author\n    at tryPackage (node:internal/modules/cjs/loader:371:15)\n    at Module._findPath (node:internal/modules/cjs/loader:573:18)\n    at Module._resolveFilename (node:internal/modules/cjs/loader:926:27)\n    at n._resolveFilename (node:electron/js2c/browser_init:249:1105)\n    at Module._resolveFilename (%%appPath%%/node_modules/module-alias/index.js:49:29)\n    at Module._load (node:internal/modules/cjs/loader:785:27)\n    at c._load (node:electron/js2c/asar_bundle:5:13339)\n    at Module.require (node:internal/modules/cjs/loader:1012:19)\n    at require (node:internal/modules/cjs/helpers:102:18)\n    at Object.<anonymous> (%%appPath%%/main/capi/SSHKeyService.js:1:670)","timestamp":"2023-10-06T13:23:34.925Z"}
{"thread":"main","class":"GraphQLService","message":"GraphQL server ready at http://127.0.0.1:46471/graphql","level":"verbose","timestamp":"2023-10-06T13:23:35.008Z"}
{"thread":"main","class":"GraphQLService","message":"GraphQL subscriptions ready at ws://127.0.0.1:46471/graphql","level":"verbose","timestamp":"2023-10-06T13:23:35.008Z"}
{"localVersion":"7.2.1+6433","osPlatform":"linux","osRelease":"6.5.3-arch1-1","osArch":"x64","windowsEdition":null,"linuxEdition":{"os":"linux","dist":"Arch Linux","release":"\"rolling\""},"level":"warn","message":"Electron Event ready","timestamp":"2023-10-06T13:23:35.098Z"}
{"thread":"main","class":"Updater","level":"info","message":"Checking for updates for: linux-x64-production","timestamp":"2023-10-06T13:23:35.151Z"}
{"thread":"main","class":"SiteProvisionerService","message":"Creating site folders...","level":"info","timestamp":"2023-10-06T13:25:06.282Z"}
{"thread":"main","class":"SiteProvisionerService","message":"Copying service config templates...","level":"info","timestamp":"2023-10-06T13:25:06.287Z"}
{"thread":"main","class":"ConfigTemplatesService","message":"Compiling service configs...","level":"info","timestamp":"2023-10-06T13:25:06.340Z"}
{"thread":"main","service":{},"serviceBinVersion":{},"dataPath":"%%site.runData%%/mysql/data","level":"info","message":"Initializing MySQL datadir...","timestamp":"2023-10-06T13:25:06.663Z"}
{"thread":"main","class":"ConfigTemplatesService","message":"Compiling service configs...","level":"info","timestamp":"2023-10-06T13:25:12.963Z"}
{"thread":"main","class":"Process","process":"mailhog","pid":1277278,"level":"verbose","message":"Spawned","timestamp":"2023-10-06T13:25:13.078Z"}
{"thread":"main","class":"Process","process":"phpFpm","pid":1277283,"level":"verbose","message":"Spawned","timestamp":"2023-10-06T13:25:13.106Z"}
{"thread":"main","class":"Process","process":"nginx","pid":1277285,"level":"verbose","message":"Spawned","timestamp":"2023-10-06T13:25:13.125Z"}
{"thread":"main","class":"Process","process":"mysql","pid":1277286,"level":"verbose","message":"Spawned","timestamp":"2023-10-06T13:25:13.145Z"}
{"thread":"main","class":"Process","process":"mysql","level":"warn","message":"2023-10-06T13:25:13.281494Z 0 [System] [MY-010116] [Server] %%userDataPath%%/lightning-services/mysql-8.0.16+6/bin/linux/bin/mysqld (mysqld 8.0.16) starting as process 1277286","timestamp":"2023-10-06T13:25:13.875Z"}
{"thread":"main","class":"Process","process":"mysql","level":"warn","message":"2023-10-06T13:25:13.283788Z 0 [Warning] [MY-013243] [Server] --character-set-server: The character set UTF8MB3 is deprecated and will be removed in a future release. Please consider using UTF8MB4 instead.","timestamp":"2023-10-06T13:25:13.875Z"}
{"thread":"main","class":"Process","process":"mysql","level":"warn","message":"2023-10-06T13:25:13.873801Z 0 [Warning] [MY-010068] [Server] CA certificate ca.pem is self signed.","timestamp":"2023-10-06T13:25:13.876Z"}
{"thread":"main","class":"Process","process":"mysql","level":"warn","message":"2023-10-06T13:25:13.874014Z 0 [ERROR] [MY-010262] [Server] Can't start server: Bind on TCP/IP port: Cannot assign requested address","timestamp":"2023-10-06T13:25:13.876Z"}
{"thread":"main","class":"Process","process":"mysql","level":"warn","message":"2023-10-06T13:25:13.874016Z 0 [ERROR] [MY-010257] [Server] Do you already have another mysqld server running on port: 10004 ?","timestamp":"2023-10-06T13:25:13.877Z"}
{"thread":"main","class":"Process","process":"mysql","level":"warn","message":"2023-10-06T13:25:13.874201Z 0 [ERROR] [MY-010119] [Server] Aborting","timestamp":"2023-10-06T13:25:15.502Z"}
{"thread":"main","class":"Process","process":"mysql","level":"warn","message":"2023-10-06T13:25:15.501281Z 0 [System] [MY-010910] [Server] %%userDataPath%%/lightning-services/mysql-8.0.16+6/bin/linux/bin/mysqld: Shutdown complete (mysqld 8.0.16)  MySQL Community Server - GPL.","timestamp":"2023-10-06T13:25:15.503Z"}
{"thread":"main","class":"Process","process":"mysql","code":1,"signal":null,"level":"verbose","message":"PID: 1277286 closed with","timestamp":"2023-10-06T13:25:15.558Z"}
{"thread":"main","class":"Process","process":"mysql","pid":1277331,"level":"verbose","message":"Spawned","timestamp":"2023-10-06T13:25:16.072Z"}
{"thread":"main","class":"Process","process":"mysql","level":"warn","message":"2023-10-06T13:25:16.190207Z 0 [System] [MY-010116] [Server] %%userDataPath%%/lightning-services/mysql-8.0.16+6/bin/linux/bin/mysqld (mysqld 8.0.16) starting as process 1277331","timestamp":"2023-10-06T13:25:16.645Z"}
{"thread":"main","class":"Process","process":"mysql","level":"warn","message":"2023-10-06T13:25:16.191233Z 0 [Warning] [MY-013243] [Server] --character-set-server: The character set UTF8MB3 is deprecated and will be removed in a future release. Please consider using UTF8MB4 instead.","timestamp":"2023-10-06T13:25:16.646Z"}
{"thread":"main","class":"Process","process":"mysql","level":"warn","message":"2023-10-06T13:25:16.643766Z 0 [Warning] [MY-010068] [Server] CA certificate ca.pem is self signed.","timestamp":"2023-10-06T13:25:16.647Z"}
{"thread":"main","class":"Process","process":"mysql","level":"warn","message":"2023-10-06T13:25:16.644043Z 0 [ERROR] [MY-010262] [Server] Can't start server: Bind on TCP/IP port: Cannot assign requested address","timestamp":"2023-10-06T13:25:16.648Z"}
{"thread":"main","class":"Process","process":"mysql","level":"warn","message":"2023-10-06T13:25:16.644048Z 0 [ERROR] [MY-010257] [Server] Do you already have another mysqld server running on port: 10004 ?","timestamp":"2023-10-06T13:25:16.648Z"}
{"thread":"main","class":"Process","process":"mysql","level":"warn","message":"2023-10-06T13:25:16.644378Z 0 [ERROR] [MY-010119] [Server] Aborting","timestamp":"2023-10-06T13:25:18.392Z"}
{"thread":"main","class":"Process","process":"mysql","level":"warn","message":"2023-10-06T13:25:18.389574Z 0 [System] [MY-010910] [Server] %%userDataPath%%/lightning-services/mysql-8.0.16+6/bin/linux/bin/mysqld: Shutdown complete (mysqld 8.0.16)  MySQL Community Server - GPL.","timestamp":"2023-10-06T13:25:18.393Z"}
{"thread":"main","class":"Process","process":"mysql","code":1,"signal":null,"level":"verbose","message":"PID: 1277331 closed with","timestamp":"2023-10-06T13:25:18.448Z"}
{"thread":"main","class":"Process","process":"mysql","pid":1277370,"level":"verbose","message":"Spawned","timestamp":"2023-10-06T13:25:18.960Z"}
{"thread":"main","class":"Process","process":"mysql","level":"warn","message":"2023-10-06T13:25:19.080978Z 0 [System] [MY-010116] [Server] %%userDataPath%%/lightning-services/mysql-8.0.16+6/bin/linux/bin/mysqld (mysqld 8.0.16) starting as process 1277370","timestamp":"2023-10-06T13:25:19.570Z"}
{"thread":"main","class":"Process","process":"mysql","level":"warn","message":"2023-10-06T13:25:19.082437Z 0 [Warning] [MY-013243] [Server] --character-set-server: The character set UTF8MB3 is deprecated and will be removed in a future release. Please consider using UTF8MB4 instead.","timestamp":"2023-10-06T13:25:19.570Z"}
{"thread":"main","class":"Process","process":"mysql","level":"warn","message":"2023-10-06T13:25:19.568703Z 0 [Warning] [MY-010068] [Server] CA certificate ca.pem is self signed.","timestamp":"2023-10-06T13:25:19.571Z"}
{"thread":"main","class":"Process","process":"mysql","level":"warn","message":"2023-10-06T13:25:19.569008Z 0 [ERROR] [MY-010262] [Server] Can't start server: Bind on TCP/IP port: Cannot assign requested address","timestamp":"2023-10-06T13:25:19.571Z"}
{"thread":"main","class":"Process","process":"mysql","level":"warn","message":"2023-10-06T13:25:19.569011Z 0 [ERROR] [MY-010257] [Server] Do you already have another mysqld server running on port: 10004 ?","timestamp":"2023-10-06T13:25:19.571Z"}
{"thread":"main","class":"Process","process":"mysql","level":"warn","message":"2023-10-06T13:25:19.569361Z 0 [ERROR] [MY-010119] [Server] Aborting","timestamp":"2023-10-06T13:25:21.299Z"}
{"thread":"main","class":"Process","process":"mysql","level":"warn","message":"2023-10-06T13:25:21.297964Z 0 [System] [MY-010910] [Server] %%userDataPath%%/lightning-services/mysql-8.0.16+6/bin/linux/bin/mysqld: Shutdown complete (mysqld 8.0.16)  MySQL Community Server - GPL.","timestamp":"2023-10-06T13:25:21.300Z"}
{"thread":"main","service":{},"serviceBinVersion":{},"stack":"Error: Command failed: %%userDataPath%%/lightning-services/mysql-8.0.16+6/bin/linux/bin/mysqladmin ping\n\u0007mysqladmin: connect to server at 'localhost' failed\nerror: 'Can't connect to local MySQL server through socket '%%site.runData%%/mysql/mysqld.sock' (2)'\nCheck that mysqld is running and that the socket: '%%site.runData%%/mysql/mysqld.sock' exists!\n\n    at ChildProcess.exithandler (node:child_process:407:12)\n    at ChildProcess.emit (node:events:527:28)\n    at ChildProcess.emit (node:domain:475:12)\n    at maybeClose (node:internal/child_process:1092:16)\n    at Socket.<anonymous> (node:internal/child_process:451:11)\n    at Socket.emit (node:events:527:28)\n    at Socket.emit (node:domain:475:12)\n    at Pipe.<anonymous> (node:net:709:12)","level":"error","message":"Database did NOT respond to ping after 15 tries.","timestamp":"2023-10-06T13:25:21.342Z"}
{"thread":"main","class":"SiteProcessManagerService","stack":"Error: Command failed: %%userDataPath%%/lightning-services/mysql-8.0.16+6/bin/linux/bin/mysqladmin ping\n\u0007mysqladmin: connect to server at 'localhost' failed\nerror: 'Can't connect to local MySQL server through socket '%%site.runData%%/mysql/mysqld.sock' (2)'\nCheck that mysqld is running and that the socket: '%%site.runData%%/mysql/mysqld.sock' exists!\n\n    at ChildProcess.exithandler (node:child_process:407:12)\n    at ChildProcess.emit (node:events:527:28)\n    at ChildProcess.emit (node:domain:475:12)\n    at maybeClose (node:internal/child_process:1092:16)\n    at Socket.<anonymous> (node:internal/child_process:451:11)\n    at Socket.emit (node:events:527:28)\n    at Socket.emit (node:domain:475:12)\n    at Pipe.<anonymous> (node:net:709:12)","level":"error","message":"Unable to start site.","timestamp":"2023-10-06T13:25:21.343Z"}
{"thread":"main","class":"Process","process":"mailhog","pid":1277278,"level":"info","message":"Killing process","timestamp":"2023-10-06T13:25:31.991Z"}
{"thread":"main","class":"Process","process":"phpFpm","pid":1277283,"level":"info","message":"Killing process","timestamp":"2023-10-06T13:25:32.003Z"}
{"thread":"main","class":"Process","process":"nginx","pid":1277285,"level":"info","message":"Killing process","timestamp":"2023-10-06T13:25:32.030Z"}
{"thread":"main","class":"Process","process":"mysql","pid":1277370,"level":"info","message":"Killing process","timestamp":"2023-10-06T13:25:32.049Z"}
{"thread":"main","class":"SiteProvisionerService","stack":"Error: Command failed: %%userDataPath%%/lightning-services/mysql-8.0.16+6/bin/linux/bin/mysqladmin ping\n\u0007mysqladmin: connect to server at 'localhost' failed\nerror: 'Can't connect to local MySQL server through socket '%%site.runData%%/mysql/mysqld.sock' (2)'\nCheck that mysqld is running and that the socket: '%%site.runData%%/mysql/mysqld.sock' exists!\n\n    at ChildProcess.exithandler (node:child_process:407:12)\n    at ChildProcess.emit (node:events:527:28)\n    at ChildProcess.emit (node:domain:475:12)\n    at maybeClose (node:internal/child_process:1092:16)\n    at Socket.<anonymous> (node:internal/child_process:451:11)\n    at Socket.emit (node:events:527:28)\n    at Socket.emit (node:domain:475:12)\n    at Pipe.<anonymous> (node:net:709:12)","level":"error","message":"Unable to provision site.","timestamp":"2023-10-06T13:25:32.070Z"}
{"thread":"main","reason":{"code":1,"killed":false,"signal":null,"cmd":"%%userDataPath%%/lightning-services/mysql-8.0.16+6/bin/linux/bin/mysqladmin ping"},"p":{},"eventId":"8e9d26990881431fad72c11d21ecfede","level":"warn","message":"Unhandled Rejection.","timestamp":"2023-10-06T13:25:34.982Z"}
{"thread":"main","name":"UnhandledPromiseRejectionWarning","level":"info","message":"Warning:Error: Command failed: %%userDataPath%%/lightning-services/mysql-8.0.16+6/bin/linux/bin/mysqladmin ping\n\u0007mysqladmin: connect to server at 'localhost' failed\nerror: 'Can't connect to local MySQL server through socket '%%site.runData%%/mysql/mysqld.sock' (2)'\nCheck that mysqld is running and that the socket: '%%site.runData%%/mysql/mysqld.sock' exists!\n\n    at ChildProcess.exithandler (node:child_process:407:12)\n    at ChildProcess.emit (node:events:527:28)\n    at ChildProcess.emit (node:domain:475:12)\n    at maybeClose (node:internal/child_process:1092:16)\n    at Socket.<anonymous> (node:internal/child_process:451:11)\n    at Socket.emit (node:events:527:28)\n    at Socket.emit (node:domain:475:12)\n    at Pipe.<anonymous> (node:net:709:12)","stack":"UnhandledPromiseRejectionWarning: Error: Command failed: %%userDataPath%%/lightning-services/mysql-8.0.16+6/bin/linux/bin/mysqladmin ping\n\u0007mysqladmin: connect to server at 'localhost' failed\nerror: 'Can't connect to local MySQL server through socket '%%site.runData%%/mysql/mysqld.sock' (2)'\nCheck that mysqld is running and that the socket: '%%site.runData%%/mysql/mysqld.sock' exists!\n\n    at ChildProcess.exithandler (node:child_process:407:12)\n    at ChildProcess.emit (node:events:527:28)\n    at ChildProcess.emit (node:domain:475:12)\n    at maybeClose (node:internal/child_process:1092:16)\n    at Socket.<anonymous> (node:internal/child_process:451:11)\n    at Socket.emit (node:events:527:28)\n    at Socket.emit (node:domain:475:12)\n    at Pipe.<anonymous> (node:net:709:12)\n    at emitUnhandledRejectionWarning (node:internal/process/promises:191:15)\n    at processPromiseRejections (node:internal/process/promises:270:11)\n    at process.processTicksAndRejections (node:internal/process/task_queues:97:32)","timestamp":"2023-10-06T13:25:34.985Z"}
{"thread":"main","level":"info","message":"Warning:Unhandled promise rejection. This error originated either by throwing inside of an async function without a catch block, or by rejecting a promise which was not handled with .catch(). To terminate the node process on unhandled promise rejection, use the CLI flag `--unhandled-rejections=strict` (see https://nodejs.org/api/cli.html#cli_unhandled_rejections_mode). (rejection id: 3)","stack":"Error: Command failed: %%userDataPath%%/lightning-services/mysql-8.0.16+6/bin/linux/bin/mysqladmin ping\n\u0007mysqladmin: connect to server at 'localhost' failed\nerror: 'Can't connect to local MySQL server through socket '%%site.runData%%/mysql/mysqld.sock' (2)'\nCheck that mysqld is running and that the socket: '%%site.runData%%/mysql/mysqld.sock' exists!\n\n    at ChildProcess.exithandler (node:child_process:407:12)\n    at ChildProcess.emit (node:events:527:28)\n    at ChildProcess.emit (node:domain:475:12)\n    at maybeClose (node:internal/child_process:1092:16)\n    at Socket.<anonymous> (node:internal/child_process:451:11)\n    at Socket.emit (node:events:527:28)\n    at Socket.emit (node:domain:475:12)\n    at Pipe.<anonymous> (node:net:709:12)","timestamp":"2023-10-06T13:25:34.986Z"}
{"thread":"main","class":"Process","process":"mailhog","code":null,"signal":"SIGINT","level":"verbose","message":"PID: 1277278 closed with","timestamp":"2023-10-06T13:25:34.988Z"}
{"thread":"main","class":"Process","process":"phpFpm","code":0,"signal":null,"level":"verbose","message":"PID: 1277283 closed with","timestamp":"2023-10-06T13:25:34.988Z"}
{"thread":"main","class":"Process","process":"nginx","code":0,"signal":null,"level":"verbose","message":"PID: 1277285 closed with","timestamp":"2023-10-06T13:25:34.988Z"}
{"thread":"main","class":"Process","process":"mysql","code":1,"signal":null,"level":"verbose","message":"PID: 1277370 closed with","timestamp":"2023-10-06T13:25:34.988Z"}
{"thread":"main","class":"DeleteSiteService","level":"debug","message":"Trashing","timestamp":"2023-10-06T13:25:34.990Z"}
{"thread":"main","class":"DeleteSiteService","level":"debug","message":"Trashed","timestamp":"2023-10-06T13:25:35.053Z"}
{"thread":"main","class":"DeleteSiteService","message":"Deleting %%site.runData%%","level":"info","timestamp":"2023-10-06T13:25:35.054Z"}
{"thread":"main","class":"HostsFileService","sites":{},"level":"debug","message":"maybeUpdate","timestamp":"2023-10-06T13:25:35.871Z"}
{"thread":"main","class":"HostsFileService","level":"debug","message":"Updating hosts","timestamp":"2023-10-06T13:25:35.872Z"}
{"thread":"main","class":"HostsFileService","level":"info","message":"Updating hosts with","timestamp":"2023-10-06T13:25:35.893Z"}
{"thread":"main","class":"HostsFileService","updateCommand":"/opt/Local/local","updateCommandArgs":["%%appPath%%/main/dns/workers/updateHostsFileWorker.js"],"level":"debug","message":"Updating hosts with command","timestamp":"2023-10-06T13:25:35.893Z"}
{"thread":"main","class":"HostsFileService","stdout":"Updating hosts file at  /etc/hosts\nUpdated hosts file at  /etc/hosts\n","stderr":"","level":"info","message":"Updated hosts.","timestamp":"2023-10-06T13:25:45.074Z"}
{"message":"Electron Event quit","level":"info","timestamp":"2023-10-06T13:30:33.753Z"}
{"thread":"main","message":"Finished maybeCopyBundledServices in 0.001s","level":"info","timestamp":"2023-10-06T14:06:19.402Z"}
{"thread":"main","class":"AddonLoaderService","level":"info","message":"Loading Add-on: %%userDataPath%%/lightning-services/mailhog-1.0.0+3/lib/main.js","timestamp":"2023-10-06T14:06:19.405Z"}
{"thread":"main","class":"AddonLoaderService","level":"info","message":"Successfully Loaded Add-on: %%userDataPath%%/lightning-services/mailhog-1.0.0+3/lib/main.js","timestamp":"2023-10-06T14:06:19.407Z"}
{"thread":"main","class":"AddonLoaderService","level":"info","message":"Loading Add-on: %%userDataPath%%/lightning-services/mariadb-10.4.10+4/lib/main.js","timestamp":"2023-10-06T14:06:19.408Z"}
{"thread":"main","class":"AddonLoaderService","level":"info","message":"Successfully Loaded Add-on: %%userDataPath%%/lightning-services/mariadb-10.4.10+4/lib/main.js","timestamp":"2023-10-06T14:06:19.439Z"}
{"thread":"main","class":"AddonLoaderService","level":"info","message":"Loading Add-on: %%userDataPath%%/lightning-services/mysql-8.0.16+6/lib/main.js","timestamp":"2023-10-06T14:06:19.440Z"}
{"thread":"main","class":"AddonLoaderService","level":"info","message":"Successfully Loaded Add-on: %%userDataPath%%/lightning-services/mysql-8.0.16+6/lib/main.js","timestamp":"2023-10-06T14:06:19.470Z"}
{"thread":"main","class":"AddonLoaderService","level":"info","message":"Loading Add-on: %%userDataPath%%/lightning-services/nginx-1.16.0+6/lib/main.js","timestamp":"2023-10-06T14:06:19.471Z"}
{"thread":"main","class":"AddonLoaderService","level":"info","message":"Successfully Loaded Add-on: %%userDataPath%%/lightning-services/nginx-1.16.0+6/lib/main.js","timestamp":"2023-10-06T14:06:19.503Z"}
{"thread":"main","class":"AddonLoaderService","level":"info","message":"Loading Add-on: %%userDataPath%%/lightning-services/php-8.1.23+0/lib/main.js","timestamp":"2023-10-06T14:06:19.505Z"}
{"thread":"main","class":"AddonLoaderService","level":"info","message":"Successfully Loaded Add-on: %%userDataPath%%/lightning-services/php-8.1.23+0/lib/main.js","timestamp":"2023-10-06T14:06:19.547Z"}
{"thread":"main","class":"AddonLoaderService","message":"Add-on does not have \"productName\" specified in package.json: %%appPath%%/node_modules/@getflywheel/local-components/package.json","level":"info","timestamp":"2023-10-06T14:06:19.548Z"}
{"thread":"main","class":"AddonLoaderService","message":"Add-on does not have \"productName\" specified in package.json: %%appPath%%/node_modules/@getflywheel/localcert/package.json","level":"info","timestamp":"2023-10-06T14:06:19.549Z"}
{"thread":"main","class":"AddonLoaderService","message":"Add-on does not have \"productName\" specified in package.json: %%appPath%%/node_modules/@getflywheel/localtunnel/package.json","level":"info","timestamp":"2023-10-06T14:06:19.550Z"}
{"thread":"main","class":"AddonLoaderService","message":"Add-on does not have \"main\" or \"renderer\" specified in package.json: %%appPath%%/node_modules/@getflywheel/replacestream/package.json","level":"info","timestamp":"2023-10-06T14:06:19.551Z"}
{"thread":"main","name":"DeprecationWarning","code":"DEP0128","level":"info","message":"Warning:Invalid 'main' field in '%%appPath%%/node_modules/ssh-key-to-pem/package.json' of 'lib/index.js'. Please either fix that or report it to the module author","stack":"DeprecationWarning: Invalid 'main' field in '%%appPath%%/node_modules/ssh-key-to-pem/package.json' of 'lib/index.js'. Please either fix that or report it to the module author\n    at tryPackage (node:internal/modules/cjs/loader:371:15)\n    at Module._findPath (node:internal/modules/cjs/loader:573:18)\n    at Module._resolveFilename (node:internal/modules/cjs/loader:926:27)\n    at n._resolveFilename (node:electron/js2c/browser_init:249:1105)\n    at Module._resolveFilename (%%appPath%%/node_modules/module-alias/index.js:49:29)\n    at Module._load (node:internal/modules/cjs/loader:785:27)\n    at c._load (node:electron/js2c/asar_bundle:5:13339)\n    at Module.require (node:internal/modules/cjs/loader:1012:19)\n    at require (node:internal/modules/cjs/helpers:102:18)\n    at Object.<anonymous> (%%appPath%%/main/capi/SSHKeyService.js:1:670)","timestamp":"2023-10-06T14:06:19.562Z"}
{"thread":"main","class":"GraphQLService","message":"GraphQL server ready at http://127.0.0.1:4000/graphql","level":"verbose","timestamp":"2023-10-06T14:06:19.663Z"}
{"thread":"main","class":"GraphQLService","message":"GraphQL subscriptions ready at ws://127.0.0.1:4000/graphql","level":"verbose","timestamp":"2023-10-06T14:06:19.663Z"}
{"localVersion":"7.2.1+6433","osPlatform":"linux","osRelease":"6.5.3-arch1-1","osArch":"x64","windowsEdition":null,"linuxEdition":{"os":"linux","dist":"Arch Linux","release":"\"rolling\""},"level":"warn","message":"Electron Event ready","timestamp":"2023-10-06T14:06:19.786Z"}
{"thread":"main","class":"Updater","level":"info","message":"Checking for updates for: linux-x64-production","timestamp":"2023-10-06T14:06:19.851Z"}
{"thread":"main","class":"Updater","release":null,"level":"debug","message":"Check for updates result","timestamp":"2023-10-06T14:06:20.727Z"}
{"thread":"main","class":"SupportService","message":"Successfully packed logs","level":"info","timestamp":"2023-10-06T14:06:59.189Z"}
6

hmm I think Router mode is a non-linux thing (anyway, I don’t see it in Gnome). I can run various other applications on localhost & easily access their webservers on arbitrary ports.

Within your Local App, not on your machine, if you go to Preferences>Advanced do you see a Router Mode setting there?

Was Local working normally for you until an update or something or was this your first attempt at getting it started? Are you on version 7.1.2 or 7.2.1?

Checking back on this. Did Local work for you previously and then stop after an update or was this your first time spinning it up?

7

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