Answered 500 Error after moving server

- 228 Posts
christianhanvey Reply #1, 11 years, 8 months ago

After moving a site to new server, I had the dreaded '500 Error' when trying to re-run setup.
I could not get to the setup/index.php?action=summary page without this error happening.
I'd followed the rtfm page on moving server closely, and checked all the usual things - enough memory for php, emptied the cache folder, permissions for files, turned of furls, removed .htaccess...

Read on to find the answer to my problem

MODX 2.2.4
PHP 5.3.3
APACHE 2.2.15
MYSQL 5.1.61

This question has been answered by christianhanvey. See the first response.
[ed. note: christianhanvey last edited this post 11 years, 8 months ago.]
discuss.answer
- 228 Posts
christianhanvey Reply #2, 11 years, 8 months ago
In the core/cache/setup/logs/error_log file was a message about connecting to mysql:
```
Can't connect to MySQL server through socket '/var/mysql/mysql.sock'
```
My new server had a remote host, not a local one - and although I had already updated all db host, user, password connection details at the top of the /core/config/config.inc.php file, there was one line that also needed updating:
```
$database_dsn = 'mysql:host=mydbhostname.com;dbname=mydbname;charset=utf8';
```
As soon as I had updated the host part of this line, everything came up rosy.
[ed. note: christianhanvey last edited this post 11 years, 8 months ago.]