Answers.Body: <p>Sorry for leaving this open for so long. I just simply did a rollback from a previous date and went on from there. Never did figure out what the issue was other than at the time I was at GoDaddy and they were a nightmare. I now run my own cloud based servers and have not had issues since then.</p>
  
Answers.ContentLicense: CC BY-SA 4.0
Answers.CreationDate: 2022-05-05T20:05:54.497Z
Answers.Text: thx for tidying up
Answers.UserDisplayName: petednz - fuzion
Answers.ContentLicense: CC BY-SA 4.0
Answers.CreationDate: 2022-05-05T17:22:18.117Z
Answers.LastActivityDate: 2022-05-05T17:22:18.117Z
Answers.UserDisplayName: Paul Williams
Answers.Body: <p>Your DB connection specifies <code>mysql://</code>, and you are using PHP7.2. <a href="http://php.net/manual/en/mysql.requirements.php" rel="noreferrer">The MySQL extension was deprecated in PHP 5.5 and removed in PHP 7.0.</a></p>
  
  <p>Try switching the two DB connect strings in <code>civicrm.settings.php</code> to use <code>mysqli://</code> instead of <code>mysql://</code> and see if that resolves the issue.</p>
  
  <p>I would also remove any other changes (eg the addition of port :3306), to eliminate issues caused by other attempts to fix things.</p>
  
  <p>If this resolves it, the cause was the migration from a PHP5 server to a PHP7 server, not an upgrade to CiviCRM 5.9.1.</p>
  
Answers.ContentLicense: CC BY-SA 4.0
Answers.CreationDate: 2019-01-19T03:51:29.900Z
Answers.Text: Thank you! I will try that when I get back in an hour or so! Would make some sense as I was using the old civicrm.settings.php file as I had to bring it up from 4.7.29 to 5.9.1 in a series of upgrades. The machine would probably not know to modify the settings. Thanks again and I will let you know!
Answers.UserDisplayName: Paul Williams
Answers.ContentLicense: CC BY-SA 4.0
Answers.CreationDate: 2019-01-19T02:16:39.647Z
Answers.LastActivityDate: 2019-01-19T02:21:41.663Z
Answers.LastEditDate: 2019-01-19T02:21:41.663Z
Answers.UserDisplayName: Chris Burgess
Answers.Body: <p>Since you have access to a terminal,  Do you have the wp-cli tool?   If so, can you login, go to the civicrm directory (really anywhere under the webroot) and run <code>wp cv sql-conf</code>   see if the output matches what you are looking at.  Then run <code>wp cv sql-cli</code>  and see if it logs you in to the correct database?   </p>
  
  <p>I would also search to see if there are any other civicrm.settings.php files.   It could be you have more than one and that is the issue</p>
  
Answers.ContentLicense: CC BY-SA 4.0
Answers.CreationDate: 2019-01-18T23:14:16.910Z
Answers.Text: Thank you for the QUICK reply! Give me a minute and I will report back.
Answers.UserDisplayName: Paul Williams
Answers.ContentLicense: CC BY-SA 4.0
Answers.CreationDate: 2019-01-18T23:43:35.477Z
Answers.Text: Give me a few minutes. When I went in via the Terminal in the cPanel it gave me a bash error. No idea what/why as they do have WP-CLI. I am downloading Putty now.
Answers.UserDisplayName: Paul Williams
Answers.ContentLicense: CC BY-SA 4.0
Answers.CreationDate: 2019-01-19T00:37:46.837Z
Answers.Text: So, on the first round I had to nix the "wp" prefix with wp-cli and everything looked Kosher except it is saying mysqli and my DSN info is mysql. There is no info on the socket. It is the WRONG database. On the next entry it opened me into MariaDB. It logs me into the proper nomenclature; however, I vaguely recall that on my old provider we did not have MariaDB. And it is NOT the right database.
Answers.UserDisplayName: Paul Williams
Answers.ContentLicense: CC BY-SA 4.0
Answers.CreationDate: 2019-01-19T01:04:16.620Z
Answers.Text: I may have found the issue. While the civicrm.settings.php was correct, the wp-config.php file was pointing wrong. My guess is that WP takes priority and sets the stage for what database will be in control. And I may be wrong. I will know in about an hour.
Answers.UserDisplayName: Paul Williams
Answers.ContentLicense: CC BY-SA 4.0
Answers.CreationDate: 2019-01-19T01:30:21.253Z
Answers.Text: So, is there a way to use WP-CLI to simply assign the proper database? Thanks!
Answers.UserDisplayName: Paul Williams
Answers.ContentLicense: CC BY-SA 4.0
Answers.CreationDate: 2019-01-20T01:36:09.743Z
Answers.Text: I am having the entire website reinstalled and will report back on here if I find out something that assists as I am convinced that this is probably a common issue. Thanks to all whom have taken the time to report in here as these were all GREAT suggestions! It may have been that I simply had not couched all of the issues properly.
Answers.UserDisplayName: Paul Williams
Answers.ContentLicense: CC BY-SA 4.0
Answers.CreationDate: 2019-01-18T23:12:23.350Z
Answers.LastActivityDate: 2019-01-18T23:12:23.350Z
Answers.UserDisplayName: Kevin Cristiano
Body: <p>CiviCRM 5.9.1 WordPress 5.0.3 PHP 7.2</p>
  
  <p>Upgraded after migration between servers from 4.7.29 w/o issue. When I went inside the CiviCRM it asked me to redo everything like a new install. I went to the MySQL tables and all of my data is there; however, it is not "read" by the CiviCRM. I even added the :3306 to localhost in the civicrm.settings.php and am simply stumped. I have verified that the database info in the DSN section is identical to the database itself. I am running on Business Cloud so I have access to cPanel, phpMyadmin, and terminal. There are NO entries in the error log file. Server runs LightSpeed; however, I have added comments addressing it for WordFence. </p>
  
  <p>The two images show that there are Contacts in the DB (along with everything else) and that the CiviCRM instance does not find anything other than what I filled out. I have also taken a screenshot of the civicrm.settings.php to show that it is set to access my database and one of the database settings itself.</p>
  
  <p><strong>ANY</strong> help is <strong>GREATLY</strong> appreciated as I have tried for over a week to set up an account with Mattermost and it still <em>will not</em> send me an email link.</p>
  
  <p><a href="https://i.sstatic.net/3xmey.png" rel="nofollow noreferrer"><img src="https://i.sstatic.net/3xmey.png" alt="Image of Database"></a><a href="https://i.sstatic.net/r6ZrT.png" rel="nofollow noreferrer"><img src="https://i.sstatic.net/r6ZrT.png" alt="Contacts"></a><a href="https://i.sstatic.net/YouV3.png" rel="nofollow noreferrer"><img src="https://i.sstatic.net/YouV3.png" alt="CiviCRM Settings Example"></a><a href="https://i.sstatic.net/pWhQH.png" rel="nofollow noreferrer"><img src="https://i.sstatic.net/pWhQH.png" alt="DB Info"></a></p>
  
Comments.ContentLicense: CC BY-SA 4.0
Comments.CreationDate: 2019-01-19T23:07:48.830Z
Comments.Text: Re Mattermost, might be worth reporting that via a comment on https://civicrm.stackexchange.com/questions/24647/forgotten-mattermost-password-not-getting-reset-emails - I'll ping @bgm in Mattermost. Sorry you're having trouble!
Comments.UserDisplayName: Chris Burgess
Tags: <wordpress><upgrade><database>
Title: CiviCRM 5.9.1 Cannot Read Database Information
ThreadText: # CiviCRM 5.9.1 Cannot Read Database Information
  
  (Asked by: username_0 on 2019-01-18)
  
  CiviCRM 5.9.1 WordPress 5.0.3 PHP 7.2
  
  Upgraded after migration between servers from 4.7.29 w/o issue. When I went inside the CiviCRM it asked me to redo everything like a new install. I went to the MySQL tables and all of my data is there; however, it is not "read" by the CiviCRM. I even added the :3306 to localhost in the civicrm.settings.php and am simply stumped. I have verified that the database info in the DSN section is identical to the database itself. I am running on Business Cloud so I have access to cPanel, phpMyadmin, and terminal. There are NO entries in the error log file. Server runs LightSpeed; however, I have added comments addressing it for WordFence.
  
  The two images show that there are Contacts in the DB (along with everything else) and that the CiviCRM instance does not find anything other than what I filled out. I have also taken a screenshot of the civicrm.settings.php to show that it is set to access my database and one of the database settings itself.
  
  **ANY** help is **GREATLY** appreciated as I have tried for over a week to set up an account with Mattermost and it still *will not* send me an email link.
  
  [![Image of Database](https://i.sstatic.net/3xmey.png)](https://i.sstatic.net/3xmey.png)[![Contacts](https://i.sstatic.net/r6ZrT.png)](https://i.sstatic.net/r6ZrT.png)[![CiviCRM Settings Example](https://i.sstatic.net/YouV3.png)](https://i.sstatic.net/YouV3.png)[![DB Info](https://i.sstatic.net/pWhQH.png)](https://i.sstatic.net/pWhQH.png)
  
  **Tags:** wordpress, upgrade, database
  
  > **Comments:**
  > **username_1**: Re Mattermost, might be worth reporting that via a comment on https://civicrm.stackexchange.com/questions/24647/forgotten-mattermost-password-not-getting-reset-emails - I'll ping @bgm in Mattermost. Sorry you're having trouble!  
  
  ---
  
  ## 3 answers
  
  ### Answer by username_0 on 2022-05-05. Score: 0 | Accepted answer
  
  Sorry for leaving this open for so long. I just simply did a rollback from a previous date and went on from there. Never did figure out what the issue was other than at the time I was at GoDaddy and they were a nightmare. I now run my own cloud based servers and have not had issues since then.
  
  > **Comments:**
  > **username_2**: thx for tidying up  
  
  ---
  
  ### Answer by username_1 on 2019-01-19. Score: 6
  
  Your DB connection specifies `mysql://`, and you are using PHP7.2. [The MySQL extension was deprecated in PHP 5.5 and removed in PHP 7.0.](http://php.net/manual/en/mysql.requirements.php)
  
  Try switching the two DB connect strings in `civicrm.settings.php` to use `mysqli://` instead of `mysql://` and see if that resolves the issue.
  
  I would also remove any other changes (eg the addition of port :3306), to eliminate issues caused by other attempts to fix things.
  
  If this resolves it, the cause was the migration from a PHP5 server to a PHP7 server, not an upgrade to CiviCRM 5.9.1.
  
  > **Comments:**
  > **username_0**: Thank you! I will try that when I get back in an hour or so! Would make some sense as I was using the old civicrm.settings.php file as I had to bring it up from 4.7.29 to 5.9.1 in a series of upgrades. The machine would probably not know to modify the settings. Thanks again and I will let you know!  
  
  ---
  
  ### Answer by username_3 on 2019-01-18. Score: 1
  
  Since you have access to a terminal, Do you have the wp-cli tool? If so, can you login, go to the civicrm directory (really anywhere under the webroot) and run `wp cv sql-conf` see if the output matches what you are looking at. Then run `wp cv sql-cli` and see if it logs you in to the correct database?
  
  I would also search to see if there are any other civicrm.settings.php files. It could be you have more than one and that is the issue
  
  > **Comments:**
  > **username_0**: Thank you for the QUICK reply! Give me a minute and I will report back.  
  > **username_0**: Give me a few minutes. When I went in via the Terminal in the cPanel it gave me a bash error. No idea what/why as they do have WP-CLI. I am downloading Putty now.  
  > **username_0**: So, on the first round I had to nix the "wp" prefix with wp-cli and everything looked Kosher except it is saying mysqli and my DSN info is mysql. There is no info on the socket. It is the WRONG database. On the next entry it opened me into MariaDB. It logs me into the proper nomenclature; however, I vaguely recall that on my old provider we did not have MariaDB. And it is NOT the right database.  
  > **username_0**: I may have found the issue. While the civicrm.settings.php was correct, the wp-config.php file was pointing wrong. My guess is that WP takes priority and sets the stage for what database will be in control. And I may be wrong. I will know in about an hour.  
  > **username_0**: So, is there a way to use WP-CLI to simply assign the proper database? Thanks!  
  > **username_0**: I am having the entire website reinstalled and will report back on here if I find out something that assists as I am convinced that this is probably a common issue. Thanks to all whom have taken the time to report in here as these were all GREAT suggestions! It may have been that I simply had not couched all of the issues properly.  
  
  ---
  
  