Local version 5.6.9+4617 Mac OS 10.13.6
When attempting to add a new site Local hangs on “Starting up Site Services”.
+1 here on High Sierra, since yesterday I cannot add a new site. I’ve downgraded to the previous stable version (5.6.8), but still did not solve the issue. local-lightning.log (325.7 KB) [local-lightning.log|attachment]
I downgraded to 5.6.8 as well but didn’t solve it. My existing sites work OK just can’t create new one or clone one either.
Same here.
Is there any fix for this?
Thanks
up: Adding screen
Still no luck after forcing the update to 5.6.10! 
Not found a solution yet.
I have exactly the same problem on High Sierra 10.13.6. Local Version 5.6.10+4674
Can’t create new local sites any more. I get exactly the same error message jonimad7 posted.
On top of this I can’t import sites either! Here’s a screenshot:
I too have been having this issue on Mac High Sierra.
A work around for this issue is to create your site as usual. And then when it crashes / hangs, create another ‘dummy’ site. Call this whatever you want and enter some temp password etc… When you hit create this will force Local to finish your first site, and now this new dummy site will hang / crash. You can then delete the dummy site.
A weird work around but it works for me.
2 Likes
Hat tip for @owenwestlake , your work around just nailed it! Lets move on for now and wait for the update with a hotfix for this issue.
Best regards,
Andre
1 Like
Excellent, thanks owenwestlake that worked!
Hi there!
I encountered a problem! As shown in an attached picture, no matter what options I choose during a new website adding, it is stuck on “Installing WordPress” and throughs error message after some quite a long time (see attached picture). When I quit the program, and open it again and start the website, it is starting, but the website is not accessible (obviously).
This same issue was with the 5.6.8 version.
I deleted all the websites I had, uninstalled Local completely using these steps: https://localwp.com/help-docs/how-do-i-uninstall-local-on-macos/, then I downloaded the latest version again and installed it, and the same issue still remains.
P.S. I checked, Local has “Full Disk Access” permission. I’m working on macOS 10.15.6 with the latest updates installed. I’m attaching the logs also.
local-lightning.log (108.3 KB)
Hey @hovhanneshovakimyan –
This is definitely odd since I’m not seeing any errors within Local.
I know you mentioned installing 4.6.8 – can you try going to 5.6.6 and let me know if that allows you to create sites?
One other thing to clarify – since Local appears to be having trouble connecting to the database, have you installed MySQL manually on the computer? For example, using something like brew?
Hey @ben.turner ! Sorry, 4.6.8 was a typo, I corrected it to 5.6.8
Yes, I have installed a few things using brew - Azure CLI tools and Kubernetes recently. Also I have installed Docker using a standard .dmg installation.
Whoops – all good, I read it as 5.6.8 
Can you try the 5.6.6 version to see if that helps?
In the above screenshot, it mentions PHP 7.4.1 – When troubleshooting this, have you tried using a custom environment with a different version of PHP?
I tried 5.6.6 version, but still the same result. Different options/versions for PHP, Apache/NGINX, and MYSQL doesn’t change it also.
After trying those different things, there might be more details in the Local log. Can you provide an updated version of the Local log so that we can see any errors that are there?
One other thing to consider: do you have any antivirus software installed?
Also tried with disabled antivirus software, with no luck.
Here is the latest log file after manipulating with 5.6.6 version:
local-lightning.log (163.7 KB)
There’s definitely some odd things happening within the Local log!
{"thread":"main","service":{},"serviceBinVersion":{},"message":"Setting up MySQL user...","level":"info","timestamp":"2020-08-11T17:25:44.256Z"}
{"thread":"main","class":"Process","process":"mysql","level":"warn","message":"2020-08-11T17:25:44.291171Z 0 [Warning] TIMESTAMP with implicit DEFAULT value is deprecated. Please use --explicit_defaults_for_timestamp server option (see documentation for more details).","timestamp":"2020-08-11T17:25:44.293Z"}
{"thread":"main","class":"Process","process":"mysql","level":"warn","message":"2020-08-11T17:25:44.291697Z 0 [Note] --secure-file-priv is set to NULL. Operations related to importing and exporting data are disabled","timestamp":"2020-08-11T17:25:44.294Z"}
{"thread":"main","class":"Process","process":"mysql","level":"warn","message":"2020-08-11T17:25:44.291763Z 0 [Note] %%userDataPath%%/lightning-services/mysql-5.7.28+4/bin/darwin/bin/mysqld (mysqld 5.7.28) starting as process 6444 ...","timestamp":"2020-08-11T17:25:44.294Z"}
{"thread":"main","class":"Process","process":"mysql","level":"warn","message":"2020-08-11T17:25:44.291856Z 0 [ERROR] Can't find error-message file '/usr/local/mysql/share/errmsg.sys'. Check error-message file location and 'lc-messages-dir' configuration directive.","timestamp":"2020-08-11T17:25:44.294Z"}
Those lines mention that MySQL can’t find the error message file at /usr/local/mysql/share/errmsg.sys – the thing is, that’s not where the MySQL error log for the Local site would be.
Do you have any other MySQL tools installed? Maybe there’s a file in your home folder at
~/my.conf
Judging from the attached picture I do not have MySQL installed. Also, I didn’t find any *.conf file at my home directory.
P.S. Is the latest (not the old VirtualBox based one) Local’s architecture publicly available?
That’s interesting that there isn’t mysql available at the prompt. I wonder if there are any mysql processes at all?
Can you run this command which will show all of the running processes that have 'mysql" in their name:
ps aux | grep mysql