[#7721] - com_config - prevent wrong database settings
- Closed
- 1 Sep 2015
- Medium
- Build: staging
- Easy Test
- # 7721
- Diff
- alikon:patch-39
- Success Human Test Results: 9 Successful 0 Failed. Details
User tests: Successful: Unsuccessful:
Steps to reproduce the issue
in Administration : System -> Global configuration - Database setting
accidentally change for example the hostname from localhost to localost and save
Expected result
Some warning message
Actual result
Error displaying the error page: Application Instantiation Error: Could not connect to MySQL.
Now you are not able to login/access your site cause db settings are changed to the wrong settings.
After apply the pr
you got an error message and wrong configuration settings data are not saved
Votes
| Status | New | ⇒ | Pending |
joomla-cms-bot
- | Labels |
Added:
?
|
||
| Category | ⇒ | UI/UX |
| Easy | No | ⇒ | Yes |
maybe later we can expand this also (with a different PR) do the same for Mailing, Session & Caching (e.g. if we use redis memcache etc.).
This comment was created with the J!Tracker Application at issues.joomla.org/joomla-cms/7721.
yes for sure caching & session wrong settings should be prevented as well
as per #7659 (comment)
| Status | Pending | ⇒ | Ready to Commit |
Thanks for testing 
and this PR ;) If we get the CS PR merged we get this PR RTC ;)
This comment was created with the J!Tracker Application at issues.joomla.org/joomla-cms/7721.
| Labels |
Added:
?
|
||
@alikon Thanks for implementing! I tested with mysqli driver and everything works as expected. Then I selected pdomysql, saved and after that I change the Host followed by another save. Now I get this error:
Warning: PDO::__construct(): php_network_getaddresses: getaddrinfo failed: Der angegebene Host ist unbekannt. in C:\Program Files (x86)\Ampps\www\joomla34\libraries\joomla\database\driver\pdo.php on line 291
Error displaying the error page: Application Instantiation Error: Could not connect to PDO: SQLSTATE[HY000] [2002] php_network_getaddresses: getaddrinfo failed: Der angegebene Host ist unbekannt.
| Status | Ready to Commit | ⇒ | Pending |
| Labels |
Removed:
?
|
||
works good for me on my MAMP server tested with MySQLi. Like this feature verry much 
@test After applying the patch no more mysql error, instead it shows:
Error
Could not connect to database.
This comment was created with the J!Tracker Application at issues.joomla.org/joomla-cms/7721.
| Status | Pending | ⇒ | Ready to Commit |
Thanks Moving to RTC
This comment was created with the J!Tracker Application at issues.joomla.org/joomla-cms/7721.
| Labels |
Added:
?
|
||
works good for me
This comment was created with the J!Tracker Application at issues.joomla.org/joomla-cms/7721.
good Feature, works!
This comment was created with the J!Tracker Application at issues.joomla.org/joomla-cms/7721.
I've open the System -> Global Configuration page. And then on the Tab 'Servers' I changed the Host-Name to 'localhostn'. A Error appear with the following Text: "Could not connect to database."
This comment was created with the J!Tracker Application at issues.joomla.org/joomla-cms/7721.
| Milestone |
Added: |
||
| Milestone |
Removed: |
||
It works fine!
This comment was created with the J!Tracker Application at issues.joomla.org/joomla-cms/7721.
| Milestone |
Added: |
||
| Milestone |
Added: |
||
Tested, works for me.
Kubik-Rubik
- | Status | Ready to Commit | ⇒ | Closed |
| Closed_Date | 0000-00-00 00:00:00 | ⇒ | 2015-09-01 18:12:59 |
| Closed_By | ⇒ | Kubik-Rubik |
| Labels |
Removed:
?
|
||
kathastaden
-
Looks great. Thanks.
This comment was created with the J!Tracker Application at issues.joomla.org/joomla-cms/7721.