Answers.Body: <p>+1 for the xkcd reference.</p>
  <p>There's some work being done on SSL but for the &quot;server exists&quot; error this is a known issue for azure. See <a href="https://lab.civicrm.org/dev/core/-/issues/1206" rel="nofollow noreferrer">https://lab.civicrm.org/dev/core/-/issues/1206</a></p>
  <p>Briefly, just comment out the body of the check it mentions and instead make it always return TRUE: <a href="https://github.com/civicrm/civicrm-core/blob/5.16.2/install/index.php#L1036" rel="nofollow noreferrer">https://github.com/civicrm/civicrm-core/blob/5.16.2/install/index.php#L1036</a></p>
  
Answers.ContentLicense: CC BY-SA 4.0
Answers.CreationDate: 2020-07-28T20:03:53.287Z
Answers.Text: This did the trick, thanks @Demerit
Answers.UserDisplayName: DEVIANT
Answers.ContentLicense: CC BY-SA 4.0
Answers.CreationDate: 2020-07-28T03:15:07.940Z
Answers.LastActivityDate: 2020-07-28T03:43:30.427Z
Answers.LastEditDate: 2020-07-28T03:43:30.427Z
Answers.UserDisplayName: Demerit
Body: <p>Good evening, I'm new here and trying to get CiviCRM installed for the first time (volunteer sysadmin for a non-profit).</p>
  <p>I think I have gone through all of the steps to troubleshoot but I suspect I am missing something.</p>
  <p>Relevant Versions:</p>
  <ul>
  <li>CiviCRM - 5.27.3</li>
  <li>WordPress - 5.4.2 (Multi-Site enabled but only primary site exists)</li>
  <li>Azure MySQL instance - 5.7.29-log</li>
  <li>Linux (Separate from MySQL) - &quot;Ubuntu 18.04.4 LTS&quot;</li>
  <li>PHP - PHP 7.2.24-0ubuntu0.18.04.6 (cli) (built: May 26 2020 13:09:11) ( NTS )</li>
  <li>NGINX - nginx/1.14.0 (Ubuntu)</li>
  </ul>
  <p>Attempted adjustments:</p>
  <ol>
  <li>Initially ran into SSL issues (Had MySQL set to SSL Enforce) Found some requests to adjust CiviCRM to accommodate this but in the meantime turned off enforcement to try and get the install to work. (This got me to the error below, all other changes listed have had no impact)</li>
  <li>Ran as admin user</li>
  <li>Updated MySQL config options (Timeouts, Innodb, max sizes, etc.)</li>
  <li>Updated php.ini settings (timeouts, reconnect, etc.)</li>
  <li>Repaired/Optimized Wordpress DB</li>
  <li>Manually ran in civicrm.mysql to create tables</li>
  <li>Followed XKCD Flowchart (<a href="https://xkcd.com/627/" rel="nofollow noreferrer">https://xkcd.com/627/</a>) regarding &quot;MySQL Server has gone away&quot;</li>
  <li>Searched for install logs to try and find what was causing the error (failed to locate)</li>
  <li>Ended up here, the results from the check seem to contradict (connection works well for all things EXCEPT knowing if the server is there)</li>
  </ol>
  <p>Thanks for any ideas/direction.</p>
  <p><a href="https://i.sstatic.net/uocqu.png" rel="nofollow noreferrer"><img src="https://i.sstatic.net/uocqu.png" alt="Conflicting Details?" /></a></p>
  
Tags: <wordpress><installation><mysql><nginx><mysql-5.7>
Title: New Install "MYSql Server Has Gone Away"
ThreadText: # New Install "MYSql Server Has Gone Away"
  
  (Asked by: username_0 on 2020-07-28)
  
  Good evening, I'm new here and trying to get CiviCRM installed for the first time (volunteer sysadmin for a non-profit).
  
  I think I have gone through all of the steps to troubleshoot but I suspect I am missing something.
  
  Relevant Versions:
  
  * CiviCRM - 5.27.3
  * WordPress - 5.4.2 (Multi-Site enabled but only primary site exists)
  * Azure MySQL instance - 5.7.29-log
  * Linux (Separate from MySQL) - "Ubuntu 18.04.4 LTS"
  * PHP - PHP 7.2.24-0ubuntu0.18.04.6 (cli) (built: May 26 2020 13:09:11) ( NTS )
  * NGINX - nginx/1.14.0 (Ubuntu)
  
  Attempted adjustments:
  
  1. Initially ran into SSL issues (Had MySQL set to SSL Enforce) Found some requests to adjust CiviCRM to accommodate this but in the meantime turned off enforcement to try and get the install to work. (This got me to the error below, all other changes listed have had no impact)
  2. Ran as admin user
  3. Updated MySQL config options (Timeouts, Innodb, max sizes, etc.)
  4. Updated php.ini settings (timeouts, reconnect, etc.)
  5. Repaired/Optimized Wordpress DB
  6. Manually ran in civicrm.mysql to create tables
  7. Followed XKCD Flowchart (<https://xkcd.com/627/>) regarding "MySQL Server has gone away"
  8. Searched for install logs to try and find what was causing the error (failed to locate)
  9. Ended up here, the results from the check seem to contradict (connection works well for all things EXCEPT knowing if the server is there)
  
  Thanks for any ideas/direction.
  
  [![Conflicting Details?](https://i.sstatic.net/uocqu.png)](https://i.sstatic.net/uocqu.png)
  
  **Tags:** wordpress, installation, mysql, nginx, mysql-5.7
  
  
  ---
  
  ## 1 answers
  
  ### Answer by username_1 on 2020-07-28. Score: 3 | Accepted answer
  
  +1 for the xkcd reference.
  
  There's some work being done on SSL but for the "server exists" error this is a known issue for azure. See <https://lab.civicrm.org/dev/core/-/issues/1206>
  
  Briefly, just comment out the body of the check it mentions and instead make it always return TRUE: <https://github.com/civicrm/civicrm-core/blob/5.16.2/install/index.php#L1036>
  
  > **Comments:**
  > **username_0**: This did the trick, thanks @username_1  
  
  ---
  
  