I can no longer use web services with Local

Support
1

I got a “Local detected invalid Docker Machine TLS certificates and is fixing them now” error that I could never resolve so I downloaded the latest version (5.0.7+1117) of Local. I have macOS 10.14.6. I rebuilt my dev sites and now I can’t access remote web services.

Is there anything I need to do to enable them? I get “Fatal error: uncaught SoapFault exception: [WSDL] SOAP-ERROR: Parsing WSDL: Couldn’t load from … failed to load external entity …”. The code still works on my production Flywheel site.

2

Hey @SteveBee, out of curiosity, what version of Local were you running before 5.0.7?

Can you please provide your local-lightning.log file (older versions would be local-by-flywheel.log`)?

See this Community Forum post for instructions on how to do so > How do I retrieve Local’s Log?

3

Hey, thanks for the response. I was using Local 3.3.0 before updating.

Here is the log file:

{“thread”:“main”,“class”:“SiteProvisionerService”,“message”:“Creating site folders…”,“level”:“info”,“timestamp”:“2019-12-02T20:19:41.847Z”}
{“thread”:“main”,“class”:“SiteProvisionerService”,“message”:“Copying service config templates…”,“level”:“info”,“timestamp”:“2019-12-02T20:19:41.852Z”}
{“thread”:“main”,“class”:“ConfigTemplatesService”,“message”:“Compiling service configs…”,“level”:“info”,“timestamp”:“2019-12-02T20:19:41.897Z”}
{“thread”:“main”,“class”:“ConfigTemplatesService”,“message”:“Adding MySQL config…”,“level”:“info”,“timestamp”:“2019-12-02T20:19:41.897Z”}
{“thread”:“main”,“class”:“ConfigTemplatesService”,“message”:“Adding PHP config…”,“level”:“info”,“timestamp”:“2019-12-02T20:19:41.921Z”}
{“thread”:“main”,“class”:“ConfigTemplatesService”,“message”:“Adding Nginx config…”,“level”:“info”,“timestamp”:“2019-12-02T20:19:41.938Z”}
{“thread”:“main”,“class”:“SiteProvisionerService”,“message”:“Initializing MySQL datadir…”,“level”:“info”,“timestamp”:“2019-12-02T20:19:41.964Z”}
{“thread”:“main”,“class”:“ConfigTemplatesService”,“message”:“Compiling service configs…”,“level”:“info”,“timestamp”:“2019-12-02T20:19:45.060Z”}
{“thread”:“main”,“class”:“ConfigTemplatesService”,“message”:“Adding MySQL config…”,“level”:“info”,“timestamp”:“2019-12-02T20:19:45.060Z”}
{“thread”:“main”,“class”:“ConfigTemplatesService”,“message”:“Adding PHP config…”,“level”:“info”,“timestamp”:“2019-12-02T20:19:45.067Z”}
{“thread”:“main”,“class”:“ConfigTemplatesService”,“message”:“Adding Nginx config…”,“level”:“info”,“timestamp”:“2019-12-02T20:19:45.080Z”}
{“thread”:“main”,“class”:“Process”,“process”:“mysql”,“level”:“warn”,“message”:“2019-12-02T20:19:45.295790Z 0 [System] [MY-010116] [Server] /Applications/Local by Flywheel.app/Contents/Resources/extraResources/site-binaries/mysql-8.0.15/bin/mysqld (mysqld 8.0.15) starting as process 19893”,“timestamp”:“2019-12-02T20:19:45.737Z”}
{“thread”:“main”,“class”:“Process”,“process”:“mysql”,“level”:“warn”,“message”:“2019-12-02T20:19:45.297444Z 0 [Warning] [MY-010159] [Server] Setting lower_case_table_names=2 because file system for /Users/stevebowden/Library/Application Support/Local/run/2USW8PWUf/mysql-raw-data/ is case insensitive”,“timestamp”:“2019-12-02T20:19:45.737Z”}
{“thread”:“main”,“class”:“Process”,“process”:“mysql”,“level”:“warn”,“message”:“2019-12-02T20:19:45.723639Z 0 [Warning] [MY-010068] [Server] CA certificate ca.pem is self signed.”,“timestamp”:“2019-12-02T20:19:45.737Z”}
{“thread”:“main”,“class”:“Process”,“process”:“mysql”,“level”:“warn”,“message”:“2019-12-02T20:19:45.736806Z 0 [System] [MY-010931] [Server] /Applications/Local by Flywheel.app/Contents/Resources/extraResources/site-binaries/mysql-8.0.15/bin/mysqld: ready for connections. Version: ‘8.0.15’ socket: ‘/Users/stevebowden/Library/Application Support/Local/run/2USW8PWUf/mysqld.sock’ port: 10003 MySQL Community Server - GPL.”,“timestamp”:“2019-12-02T20:19:45.737Z”}
{“thread”:“main”,“class”:“HostsFileService”,“level”:“info”,“message”:“Updating hosts with”,“timestamp”:“2019-12-02T20:19:45.916Z”}
{“thread”:“main”,“class”:“SiteProvisionerService”,“message”:“Setting up MySQL user…”,“level”:“info”,“timestamp”:“2019-12-02T20:19:48.431Z”}
{“thread”:“main”,“class”:“SiteProvisionerService”,“message”:“Creating MySQL database…”,“level”:“info”,“timestamp”:“2019-12-02T20:19:48.486Z”}
{“thread”:“main”,“class”:“WordPressInstaller”,“message”:“Init WordPressInstaller”,“level”:“info”,“timestamp”:“2019-12-02T20:19:48.503Z”}
{“thread”:“main”,“class”:“WordPressInstaller”,“message”:“Starting standardInstall()”,“level”:“info”,“timestamp”:“2019-12-02T20:19:48.504Z”}
{“thread”:“main”,“class”:“WordPressInstaller”,“message”:“maybeGetLatestVersion()”,“level”:“info”,“timestamp”:“2019-12-02T20:19:48.504Z”}
{“thread”:“main”,“class”:“WordPressInstaller”,“latestOfflineWpVersion”:null,“level”:“info”,“message”:“Latest offline version info”,“timestamp”:“2019-12-02T20:19:48.504Z”}
{“thread”:“main”,“class”:“WordPressInstaller”,“version”:“5.3”,“download”:“https://downloads.wordpress.org/release/wordpress-5.3.tar.gz",“level”:“info”,“message”:"Latest version info”,“timestamp”:“2019-12-02T20:19:48.622Z”}
{“thread”:“main”,“class”:“WordPressInstaller”,“level”:“info”,“message”:“download()”,“timestamp”:“2019-12-02T20:19:48.622Z”}
{“thread”:“main”,“class”:“WordPressInstaller”,“level”:“info”,“message”:“Attempting to download WordPress”,“timestamp”:“2019-12-02T20:19:48.622Z”}
{“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”:“2019-12-02T20:19:51.847Z”}
{“thread”:“main”,“class”:“WordPressInstaller”,“message”:“Configuring wp-config.php”,“level”:“info”,“timestamp”:“2019-12-02T20:20:06.302Z”}
{“thread”:“main”,“class”:“WordPressInstaller”,“message”:“Installing WordPress”,“level”:“info”,“timestamp”:“2019-12-02T20:20:06.642Z”}
{“thread”:“main”,“class”:“WordPressInstaller”,“message”:“Deleting Akismet and Hello Dolly”,“level”:“info”,“timestamp”:“2019-12-02T20:20:07.602Z”}
{“thread”:“main”,“class”:“WordPressInstaller”,“message”:“Writing salts to wp-config.php”,“level”:“info”,“timestamp”:“2019-12-02T20:20:08.214Z”}
{“thread”:“main”,“class”:“Process”,“process”:“nginx”,“pid”:19890,“level”:“info”,“message”:“Killing process”,“timestamp”:“2019-12-02T20:23:21.762Z”}
{“thread”:“main”,“class”:“Process”,“process”:“phpFpm”,“pid”:19891,“level”:“info”,“message”:“Killing process”,“timestamp”:“2019-12-02T20:23:21.763Z”}
{“thread”:“main”,“class”:“Process”,“process”:“mysql”,“pid”:19893,“level”:“info”,“message”:“Killing process”,“timestamp”:“2019-12-02T20:23:21.763Z”}
{“thread”:“main”,“class”:“Process”,“process”:“mailhog”,“pid”:19894,“level”:“info”,“message”:“Killing process”,“timestamp”:“2019-12-02T20:23:21.763Z”}
{“thread”:“main”,“class”:“Process”,“process”:“nginx”,“pid”:19923,“level”:“info”,“message”:“Killing process”,“timestamp”:“2019-12-02T20:23:21.763Z”}
{“thread”:“main”,“class”:“ConfigTemplatesService”,“message”:“Compiling service configs…”,“level”:“info”,“timestamp”:“2019-12-02T20:24:59.991Z”}
{“thread”:“main”,“class”:“ConfigTemplatesService”,“message”:“Adding MySQL config…”,“level”:“info”,“timestamp”:“2019-12-02T20:24:59.992Z”}
{“thread”:“main”,“class”:“ConfigTemplatesService”,“message”:“Adding PHP config…”,“level”:“info”,“timestamp”:“2019-12-02T20:25:00.010Z”}
{“thread”:“main”,“class”:“ConfigTemplatesService”,“message”:“Adding Nginx config…”,“level”:“info”,“timestamp”:“2019-12-02T20:25:00.028Z”}
{“thread”:“main”,“class”:“Process”,“process”:“mysql”,“level”:“warn”,“message”:“2019-12-02T20:25:00.211220Z 0 [System] [MY-010116] [Server] /Applications/Local by Flywheel.app/Contents/Resources/extraResources/site-binaries/mysql-8.0.15/bin/mysqld (mysqld 8.0.15) starting as process 20096”,“timestamp”:“2019-12-02T20:25:00.534Z”}
{“thread”:“main”,“class”:“Process”,“process”:“mysql”,“level”:“warn”,“message”:“2019-12-02T20:25:00.216332Z 0 [Warning] [MY-010159] [Server] Setting lower_case_table_names=2 because file system for /Users/stevebowden/Library/Application Support/Local/run/2USW8PWUf/mysql-raw-data/ is case insensitive”,“timestamp”:“2019-12-02T20:25:00.534Z”}
{“thread”:“main”,“class”:“Process”,“process”:“mysql”,“level”:“warn”,“message”:“2019-12-02T20:25:00.521578Z 0 [Warning] [MY-010068] [Server] CA certificate ca.pem is self signed.”,“timestamp”:“2019-12-02T20:25:00.535Z”}
{“thread”:“main”,“class”:“Process”,“process”:“mysql”,“level”:“warn”,“message”:“2019-12-02T20:25:00.534527Z 0 [System] [MY-010931] [Server] /Applications/Local by Flywheel.app/Contents/Resources/extraResources/site-binaries/mysql-8.0.15/bin/mysqld: ready for connections. Version: ‘8.0.15’ socket: ‘/Users/stevebowden/Library/Application Support/Local/run/2USW8PWUf/mysqld.sock’ port: 10003 MySQL Community Server - GPL.”,“timestamp”:“2019-12-02T20:25:00.535Z”}
{“thread”:“main”,“class”:“WordPressInstaller”,“message”:“Init WordPressInstaller”,“level”:“info”,“timestamp”:“2019-12-02T20:27:52.246Z”}
{“thread”:“main”,“class”:“WordPressInstaller”,“message”:“wp-config.php exists”,“level”:“info”,“timestamp”:“2019-12-02T20:27:52.246Z”}
{“thread”:“main”,“class”:“WordPressInstaller”,“message”:“Salts already in wp-config.php”,“level”:“info”,“timestamp”:“2019-12-02T20:27:52.247Z”}
{“thread”:“main”,“class”:“ImporterConnectV2”,“message”:“Importing SQL with mysql source”,“level”:“info”,“timestamp”:“2019-12-02T20:27:52.247Z”}
{“thread”:“main”,“class”:“ImporterConnectV2”,“level”:“info”,“message”:“Importing /Users/stevebowden/Local Sites/devbeanrtorg/app/public/.connect-pull.sql”,“timestamp”:“2019-12-02T20:27:52.428Z”}
{“thread”:“main”,“class”:“ImporterConnectV2”,“level”:“info”,“message”:“Updated wp-config.php.”,“timestamp”:“2019-12-02T20:27:52.981Z”}
{“thread”:“main”,“class”:“Process”,“process”:“nginx”,“pid”:20119,“level”:“info”,“message”:“Killing process”,“timestamp”:“2019-12-02T20:27:53.110Z”}
{“thread”:“main”,“class”:“SearchReplacerWPDatabaseDomain”,“level”:“info”,“message”:“Changing database domain for 2USW8PWUf”,“timestamp”:“2019-12-02T20:27:53.120Z”}
{“thread”:“main”,“class”:“SiteProvisionerService”,“message”:“Creating site folders…”,“level”:“info”,“timestamp”:“2019-12-02T21:22:06.099Z”}
{“thread”:“main”,“class”:“SiteProvisionerService”,“message”:“Copying service config templates…”,“level”:“info”,“timestamp”:“2019-12-02T21:22:06.102Z”}
{“thread”:“main”,“class”:“ConfigTemplatesService”,“message”:“Compiling service configs…”,“level”:“info”,“timestamp”:“2019-12-02T21:22:06.152Z”}
{“thread”:“main”,“class”:“ConfigTemplatesService”,“message”:“Adding MySQL config…”,“level”:“info”,“timestamp”:“2019-12-02T21:22:06.152Z”}
{“thread”:“main”,“class”:“ConfigTemplatesService”,“message”:“Adding PHP config…”,“level”:“info”,“timestamp”:“2019-12-02T21:22:06.161Z”}
{“thread”:“main”,“class”:“ConfigTemplatesService”,“message”:“Adding Nginx config…”,“level”:“info”,“timestamp”:“2019-12-02T21:22:06.175Z”}
{“thread”:“main”,“class”:“SiteProvisionerService”,“message”:“Initializing MySQL datadir…”,“level”:“info”,“timestamp”:“2019-12-02T21:22:06.200Z”}
{“thread”:“main”,“class”:“ConfigTemplatesService”,“message”:“Compiling service configs…”,“level”:“info”,“timestamp”:“2019-12-02T21:22:09.626Z”}
{“thread”:“main”,“class”:“ConfigTemplatesService”,“message”:“Adding MySQL config…”,“level”:“info”,“timestamp”:“2019-12-02T21:22:09.626Z”}
{“thread”:“main”,“class”:“ConfigTemplatesService”,“message”:“Adding PHP config…”,“level”:“info”,“timestamp”:“2019-12-02T21:22:09.634Z”}
{“thread”:“main”,“class”:“ConfigTemplatesService”,“message”:“Adding Nginx config…”,“level”:“info”,“timestamp”:“2019-12-02T21:22:09.645Z”}
{“thread”:“main”,“class”:“Process”,“process”:“mysql”,“level”:“warn”,“message”:“2019-12-02T21:22:09.811818Z 0 [System] [MY-010116] [Server] /Applications/Local by Flywheel.app/Contents/Resources/extraResources/site-binaries/mysql-8.0.15/bin/mysqld (mysqld 8.0.15) starting as process 21143”,“timestamp”:“2019-12-02T21:22:10.276Z”}
{“thread”:“main”,“class”:“Process”,“process”:“mysql”,“level”:“warn”,“message”:“2019-12-02T21:22:09.813582Z 0 [Warning] [MY-010159] [Server] Setting lower_case_table_names=2 because file system for /Users/stevebowden/Library/Application Support/Local/run/yspEhSFPX/mysql-raw-data/ is case insensitive”,“timestamp”:“2019-12-02T21:22:10.277Z”}
{“thread”:“main”,“class”:“Process”,“process”:“mysql”,“level”:“warn”,“message”:“2019-12-02T21:22:10.264395Z 0 [Warning] [MY-010068] [Server] CA certificate ca.pem is self signed.”,“timestamp”:“2019-12-02T21:22:10.277Z”}
{“thread”:“main”,“class”:“Process”,“process”:“mysql”,“level”:“warn”,“message”:“2019-12-02T21:22:10.276753Z 0 [System] [MY-010931] [Server] /Applications/Local by Flywheel.app/Contents/Resources/extraResources/site-binaries/mysql-8.0.15/bin/mysqld: ready for connections. Version: ‘8.0.15’ socket: ‘/Users/stevebowden/Library/Application Support/Local/run/yspEhSFPX/mysqld.sock’ port: 10007 MySQL Community Server - GPL.”,“timestamp”:“2019-12-02T21:22:10.277Z”}
{“thread”:“main”,“class”:“HostsFileService”,“level”:“info”,“message”:“Updating hosts with”,“timestamp”:“2019-12-02T21:22:10.444Z”}
{“thread”:“main”,“class”:“Process”,“process”:“nginx”,“pid”:20368,“level”:“info”,“message”:“Killing process”,“timestamp”:“2019-12-02T21:22:11.721Z”}
{“thread”:“main”,“class”:“SiteProvisionerService”,“message”:“Setting up MySQL user…”,“level”:“info”,“timestamp”:“2019-12-02T21:22:11.728Z”}
{“thread”:“main”,“class”:“SiteProvisionerService”,“message”:“Creating MySQL database…”,“level”:“info”,“timestamp”:“2019-12-02T21:22:11.804Z”}
{“thread”:“main”,“class”:“WordPressInstaller”,“message”:“Init WordPressInstaller”,“level”:“info”,“timestamp”:“2019-12-02T21:22:11.821Z”}
{“thread”:“main”,“class”:“WordPressInstaller”,“message”:“Starting standardInstall()”,“level”:“info”,“timestamp”:“2019-12-02T21:22:11.821Z”}
{“thread”:“main”,“class”:“WordPressInstaller”,“message”:“maybeGetLatestVersion()”,“level”:“info”,“timestamp”:“2019-12-02T21:22:11.821Z”}
{“thread”:“main”,“class”:“WordPressInstaller”,“latestOfflineWpVersion”:“5.3”,“level”:“info”,“message”:“Latest offline version info”,“timestamp”:“2019-12-02T21:22:11.822Z”}
{“thread”:“main”,“class”:“WordPressInstaller”,“version”:“5.3”,“download”:“https://downloads.wordpress.org/release/wordpress-5.3.tar.gz",“level”:“info”,“message”:"Latest version info”,“timestamp”:“2019-12-02T21:22:11.916Z”}
{“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”:“2019-12-02T21:22:16.009Z”}
{“thread”:“main”,“class”:“WordPressInstaller”,“message”:“Configuring wp-config.php”,“level”:“info”,“timestamp”:“2019-12-02T21:22:16.140Z”}
{“thread”:“main”,“class”:“WordPressInstaller”,“message”:“Installing WordPress”,“level”:“info”,“timestamp”:“2019-12-02T21:22:16.485Z”}
{“thread”:“main”,“class”:“WordPressInstaller”,“message”:“Deleting Akismet and Hello Dolly”,“level”:“info”,“timestamp”:“2019-12-02T21:22:17.459Z”}
{“thread”:“main”,“class”:“WordPressInstaller”,“message”:“Writing salts to wp-config.php”,“level”:“info”,“timestamp”:“2019-12-02T21:22:18.015Z”}
{“thread”:“main”,“class”:“WordPressInstaller”,“message”:“Init WordPressInstaller”,“level”:“info”,“timestamp”:“2019-12-02T21:38:25.942Z”}
{“thread”:“main”,“class”:“WordPressInstaller”,“message”:“wp-config.php exists”,“level”:“info”,“timestamp”:“2019-12-02T21:38:25.942Z”}
{“thread”:“main”,“class”:“WordPressInstaller”,“message”:“Salts already in wp-config.php”,“level”:“info”,“timestamp”:“2019-12-02T21:38:25.943Z”}
{“thread”:“main”,“class”:“ImporterConnectV2”,“message”:“Importing SQL with mysql source”,“level”:“info”,“timestamp”:“2019-12-02T21:38:25.943Z”}
{“thread”:“main”,“class”:“ImporterConnectV2”,“level”:“info”,“message”:“Importing /Users/stevebowden/Local Sites/devaarcorg/app/public/.connect-pull.sql”,“timestamp”:“2019-12-02T21:38:27.562Z”}
{“thread”:“main”,“class”:“ImporterConnectV2”,“level”:“info”,“message”:“Updated wp-config.php.”,“timestamp”:“2019-12-02T21:38:42.042Z”}
{“thread”:“main”,“class”:“Process”,“process”:“nginx”,“pid”:21185,“level”:“info”,“message”:“Killing process”,“timestamp”:“2019-12-02T21:38:42.198Z”}
{“thread”:“main”,“class”:“SearchReplacerWPDatabaseDomain”,“level”:“info”,“message”:“Changing database domain for yspEhSFPX”,“timestamp”:“2019-12-02T21:38:42.209Z”}
{“thread”:“renderer”,“component”:“SiteInfoEnvironmentPHP”,“level”:“info”,“message”:"Writing PHP info file: ",“timestamp”:“2019-12-02T21:50:22.088Z”}
{“thread”:“renderer”,“component”:“SiteInfoEnvironmentPHP”,“level”:“info”,“message”:"Writing PHP info file: ",“timestamp”:“2019-12-02T22:19:52.551Z”}
{“thread”:“renderer”,“component”:“SiteInfoEnvironmentPHP”,“level”:“info”,“message”:"Writing PHP info file: ",“timestamp”:“2019-12-02T22:21:42.127Z”}

4

Well, the good news is that there doesn’t appear to be anything standing out in the log here. The bad news is…there doesn’t seem to be anything standing out in the log.

The current betas of Local don’t offer custom environments and run slightly different versions of PHP and MySQL than your Flywheel site would (PHP 7.3.2 and MySQL 8.0.15). Is it possible that there is something at the site level that is incompatible with a newer version of PHP or MySQL?

Could you attach the site level logs (found in the site/logs/ folder)? Also, attaching is probably a little cleaner (and easier to work with for others) than copy/pasting here but you won’t be able to do that from an email reply.

5

I think this is the correct file.error.log (22.0 KB)

6

After tinkering with this all day, I tried file_get_contents() with the WSDL and I get these errors:

Warning: file_get_contents(): SSL operation failed with code 1. OpenSSL Error messages: error:1416F086:SSL routines:tls_process_server_certificate:certificate verify failed

Warning: file_get_contents(): Failed to enable crypto

Warning: file_get_contents(https://xxxx/DataAccess.asmx?WSDL): failed to open stream: operation failed

So I used a different WSDL and I didn’t get any errors, just a description of the WSDL. Something must have changed with the web service between Friday evening and Monday morning. I don’t think this has to do with having to rebuild my dev sites with a newer version of Local.