Installation problem (Server error)

Hi - hoping you can help. I’ve used Composer to install a fresh copy of 4.8.0. I’ve then created a database and user with the necessary permissions. I’ve then created a .env file with the connection credentials. I assumed I could then navigate to the /public folder to begin the installation process, but I simply get a server error. No more info than that, that I can see, even though dev mode is on. PHP error log doesn’t show anything. Any ideas please?

If you have command line access, try running the following in the web root:

./vendor/bin/sake dev/build

Alternatively, try a similar thing from your browser: http://example.com/dev/build?flush (obviously you’ll need the address of your site in there)

Hi @Tim, thanks very much for replying. Using command line access, I ran the build command and although the output indicated the database build had worked successfully, it didn’t help with the overall problem (the same server error message appeared when attempting to navigate to the site using the browser). However, running the build command from the browser has had a more positive effect… I still get the server error message but at least I can see the simple theme. Here’s what it now looks like: https://bmsdchosting2.net/ Any other advice please??

Do you have the site in dev mode? You can set it in your .env file with SS_ENVIRONMENT_TYPE=dev

If that doesn’t show any useful debugging info, the next port of call will be the server logs.

Hi again, yes I do and it doesn’t show anything useful. Sorry to be a nuisance, I really appreciate the support you’re providing, but … the server logs … are they found within the “logs” folder just above the public_html folder? I can see a log for each day, in gz format. When I extract the latest one, the one for today, I can’t see any useful info in the file… unless it IS useful but I’m not understanding it

This is what I found in public_html/php_errorlog:

[06-Aug-2021 12:52:13 UTC] PHP Warning: mysqli::real_connect(): (HY000/1045): Access denied for user ‘umemtykllq1xy’@‘localhost’ (using password: YES) in /home/customer/www/bmsdchosting2.net/public_html/example/vendor/silverstripe/framework/src/ORM/Connect/MySQLiConnector.php on line 113

This is what I found in public_html/public/php_errorlog:

[06-Aug-2021 12:50:20 UTC] PHP Warning: mysqli::real_connect(): (HY000/1045): Access denied for user ‘umemtykllq1xy’@‘localhost’ (using password: YES) in /home/customer/www/bmsdchosting2.net/public_html/example/vendor/silverstripe/framework/src/ORM/Connect/MySQLiConnector.php on line 113
[06-Aug-2021 12:51:00 UTC] PHP Warning: mysqli::real_connect(): (HY000/1045): Access denied for user ‘umemtykllq1xy’@‘localhost’ (using password: YES) in /home/customer/www/bmsdchosting2.net/public_html/example/vendor/silverstripe/framework/src/ORM/Connect/MySQLiConnector.php on line 113
[06-Aug-2021 12:51:00 UTC] PHP Warning: mysqli::real_connect(): (HY000/1045): Access denied for user ‘umemtykllq1xy’@‘localhost’ (using password: YES) in /home/customer/www/bmsdchosting2.net/public_html/example/vendor/silverstripe/framework/src/ORM/Connect/MySQLiConnector.php on line 113
[06-Aug-2021 12:52:01 UTC] PHP Warning: mysqli::real_connect(): (HY000/1045): Access denied for user ‘umemtykllq1xy’@‘localhost’ (using password: YES) in /home/customer/www/bmsdchosting2.net/public_html/example/vendor/silverstripe/framework/src/ORM/Connect/MySQLiConnector.php on line 113

And this is what I found in logs by unzipping the gz file with yesterday’s date:

EXTERNAL EMAIL: Don’t click any links or open attachments unless you trust the sender and know the content is safe. Click here for more information or help from Suffolk IT

192.71.44.44 bmsdchosting2.net - [08/Aug/2021:04:54:56 +0000] “GET /robots.txt HTTP/1.1” 301 162 “-” “Mozilla/5.0 (Macintosh; Intel Mac OS X 10_13_6) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/91.0.4472.114 Safari/537.36” | - | - - 0.000 - 0 NC:000000 UP:-

192.36.70.176 bmsdchosting2.net - [08/Aug/2021:04:54:57 +0000] “GET /robots.txt HTTP/1.1” 500 3714 http://bmsdchosting2.net/robots.txt “Mozilla/5.0 (Macintosh; Intel Mac OS X 10_13_6) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/91.0.4472.114 Safari/537.36” | TLSv1.3 | 0.225 0.225 0.226 MISS 0 NC:000000 UP:SKIP_CACHE_EXPIRED

192.71.225.127 bmsdchosting2.net - [08/Aug/2021:04:54:57 +0000] “GET /humans.txt HTTP/1.1” 301 162 “-” “Mozilla/5.0 (Macintosh; Intel Mac OS X 10_13_6) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/91.0.4472.114 Safari/537.36” | - | - - 0.000 - 0 NC:000000 UP:-

192.71.103.173 bmsdchosting2.net - [08/Aug/2021:04:54:57 +0000] “GET /humans.txt HTTP/1.1” 500 3714 http://bmsdchosting2.net/humans.txt “Mozilla/5.0 (Macintosh; Intel Mac OS X 10_13_6) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/91.0.4472.114 Safari/537.36” | TLSv1.3 | 0.094 0.094 0.095 MISS 0 NC:000000 UP:SKIP_CACHE_EXPIRED

192.71.42.108 bmsdchosting2.net - [08/Aug/2021:04:54:58 +0000] “GET /ads.txt HTTP/1.1” 301 162 “-” “Mozilla/5.0 (Macintosh; Intel Mac OS X 10_13_6) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/91.0.4472.114 Safari/537.36” | - | - - 0.000 - 0 NC:000000 UP:-

192.36.248.249 bmsdchosting2.net - [08/Aug/2021:04:54:58 +0000] “GET /ads.txt HTTP/1.1” 500 3714 http://bmsdchosting2.net/ads.txt “Mozilla/5.0 (Macintosh; Intel Mac OS X 10_13_6) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/91.0.4472.114 Safari/537.36” | TLSv1.3 | 0.101 0.101 0.103 MISS 0 NC:000000 UP:SKIP_CACHE_EXPIRED

192.71.42.108 bmsdchosting2.net - [08/Aug/2021:04:54:58 +0000] “GET / HTTP/1.1” 301 162 “-” “Mozilla/5.0 (Macintosh; Intel Mac OS X 10_13_6) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/91.0.4472.114 Safari/537.36” | - | - - 0.000 - 0 NC:000000 UP:-

192.71.3.26 bmsdchosting2.net - [08/Aug/2021:04:54:59 +0000] “GET / HTTP/1.1” 500 3714 http://bmsdchosting2.net/ “Mozilla/5.0 (Macintosh; Intel Mac OS X 10_13_6) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/91.0.4472.114 Safari/537.36” | TLSv1.3 | 0.093 0.093 0.094 EXPIRED 0 NC:000000 UP:SKIP_CACHE_EXPIRED

52.11.55.27 bmsdchosting2.net - [08/Aug/2021:05:31:47 +0000] “GET / HTTP/1.1” 301 162 “-” “Mozilla/5.0 (Windows NT 10.0; Win64; x64)AppleWebKit/537.36 (KHTML, like Gecko) Chrome/66.0.3359.181 Safari/537.36” | - | - - 0.000 - 0 NC:000000 UP:-

52.11.55.27 bmsdchosting2.net - [08/Aug/2021:05:31:48 +0000] “GET / HTTP/1.1” 500 3714 “-” “Mozilla/5.0 (Windows NT 10.0; Win64; x64)AppleWebKit/537.36 (KHTML, like Gecko) Chrome/66.0.3359.181 Safari/537.36” | TLSv1.3 | 0.229 0.229 0.230 EXPIRED 0 NC:000000 UP:SKIP_CACHE_EXPIRED

54.212.43.38 bmsdchosting2.net - [08/Aug/2021:05:39:55 +0000] “GET / HTTP/1.1” 301 162 “-” “Mozilla/5.0 (X11; Linux x86_64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/83.0.4103.97 Safari/537.36” | - | - - 0.000 - 0 NC:000000 UP:-

54.212.43.38 bmsdchosting2.net - [08/Aug/2021:05:39:56 +0000] “GET / HTTP/1.1” 500 3714 “-” “Mozilla/5.0 (X11; Linux x86_64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/83.0.4103.97 Safari/537.36” | TLSv1.3 | 0.097 0.097 0.099 EXPIRED 0 NC:000000 UP:SKIP_CACHE_EXPIRED

34.212.22.154 bmsdchosting2.net - [08/Aug/2021:05:53:13 +0000] “GET / HTTP/1.1” 500 3714 “-” “Mozilla/5.0 (X11; Linux x86_64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/83.0.4103.97 Safari/537.36” | TLSv1.3 | 0.236 0.236 0.236 EXPIRED 0 NC:000000 UP:SKIP_CACHE_EXPIRED

54.74.190.228 bmsdchosting2.net - [08/Aug/2021:09:10:51 +0000] “GET / HTTP/1.1” 301 162 “-” “Mozilla/5.0 (Macintosh; Intel Mac OS X 10.15; rv:81.0) Gecko/20100101 Firefox/81.0” | - | - - 0.000 - 0 NC:000000 UP:-

54.74.190.228 bmsdchosting2.net - [08/Aug/2021:09:10:51 +0000] “GET / HTTP/1.1” 500 3714 http://35.214.105.93 “Mozilla/5.0 (Macintosh; Intel Mac OS X 10.15; rv:81.0) Gecko/20100101 Firefox/81.0” | TLSv1.3 | 0.262 0.262 0.263 EXPIRED 0 NC:000000 UP:SKIP_CACHE_EXPIRED

58.53.128.88 www.bmsdchosting2.net - [08/Aug/2021:12:53:02 +0000] “GET / HTTP/1.1” 301 162 “-” “GRequests/0.10” | - | - - 0.000 - 0 NC:000000 UP:-

58.53.128.88 www.bmsdchosting2.net - [08/Aug/2021:12:53:05 +0000] “GET / HTTP/1.1” 500 3714 http://www.bmsdchosting2.net “GRequests/0.10” | TLSv1.3 | 0.229 0.229 0.229 MISS 0 NC:000000 UP:SKIP_CACHE_EXPIRED

81.88.52.142 bmsdchosting2.net - [08/Aug/2021:16:47:02 +0000] “GET /wp-login.php HTTP/1.1” 301 162 “-” “Mozilla/5.0 (X11; Ubuntu; Linux x86_64; rv:62.0) Gecko/20100101 Firefox/62.0” | - | - - 0.000 - 0 NC:010000 UP:-

185.254.31.122 www.bmsdchosting2.net - [08/Aug/2021:17:39:18 +0000] “GET /.env HTTP/1.1” 403 16369 “-” “Mozilla/5.0 (X11; Linux x86_64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/81.0.4044.129 Safari/537.36” | TLSv1.3 | 0.016 0.016 0.016 MISS 0 NC:000000 UP:SKIP_CACHE_EXPIRED

212.90.39.68 bmsdchosting2.net - [08/Aug/2021:20:54:55 +0000] “GET / HTTP/1.1” 301 162 “-” “Mozilla/4.0 (compatible; MSIE 6.0; Windows NT 5.1; SV1)” | - | - - 0.000 - 0 NC:000000 UP:-

212.90.39.68 bmsdchosting2.net - [08/Aug/2021:20:55:05 +0000] “GET / HTTP/1.1” 301 162 “-” “Mozilla/4.0 (compatible; MSIE 6.0; Windows NT 5.1; SV1)” | - | - - 0.000 - 0 NC:000000 UP:-

212.90.39.68 bmsdchosting2.net - [08/Aug/2021:20:55:08 +0000] “GET / HTTP/1.1” 301 162 “-” “Mozilla/4.0 (compatible; MSIE 6.0; Windows NT 5.1; SV1)” | - | - - 0.000 - 0 NC:000000 UP:-

76.72.172.166 bmsdchosting2.net - [08/Aug/2021:23:55:08 +0000] “” 400 0 “-” “-” | TLSv1.3 | - - 0.000 - 0 NC:000000 UP:-

178.128.53.104 bmsdchosting2.net - [08/Aug/2021:23:57:50 +0000] “GET / HTTP/1.1” 301 162 “-” “Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/78.0.3904.108 Safari/537.36” | - | - - 0.000 - 0 NC:000000 UP:-

178.128.53.104 bmsdchosting2.net - [08/Aug/2021:23:57:50 +0000] “GET / HTTP/1.1” 200 88 “-” “Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/78.0.3904.108 Safari/537.36” | TLSv1.2 | - - 0.000 - 0 NC:000000 UP:-

178.128.53.104 bmsdchosting2.net - [08/Aug/2021:23:57:51 +0000] “GET //wp-includes/wlwmanifest.xml HTTP/1.1” 200 88 “-” “Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/78.0.3904.108 Safari/537.36” | TLSv1.2 | - - 0.168 - 0 NC:000000 UP:-

178.128.53.104 bmsdchosting2.net - [08/Aug/2021:23:57:51 +0000] “GET //xmlrpc.php?rsd HTTP/1.1” 200 88 “-” “Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/78.0.3904.108 Safari/537.36” | TLSv1.2 | - - 0.170 - 0 NC:050000 UP:-

178.128.53.104 bmsdchosting2.net - [08/Aug/2021:23:57:51 +0000] “GET / HTTP/1.1” 200 88 “-” “Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/78.0.3904.108 Safari/537.36” | TLSv1.2 | - - 0.171 - 0 NC:000000 UP:-

178.128.53.104 bmsdchosting2.net - [08/Aug/2021:23:57:51 +0000] “GET //blog/wp-includes/wlwmanifest.xml HTTP/1.1” 200 88 “-” “Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/78.0.3904.108 Safari/537.36” | TLSv1.2 | - - 0.168 - 0 NC:000000 UP:-

178.128.53.104 bmsdchosting2.net - [08/Aug/2021:23:57:51 +0000] “GET //web/wp-includes/wlwmanifest.xml HTTP/1.1” 200 88 “-” “Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/78.0.3904.108 Safari/537.36” | TLSv1.2 | - - 0.168 - 0 NC:000000 UP:-

178.128.53.104 bmsdchosting2.net - [08/Aug/2021:23:57:51 +0000] “GET //wordpress/wp-includes/wlwmanifest.xml HTTP/1.1” 200 88 “-” “Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/78.0.3904.108 Safari/537.36” | TLSv1.2 | - - 0.171 - 0 NC:000000 UP:-

178.128.53.104 bmsdchosting2.net - [08/Aug/2021:23:57:52 +0000] “GET //website/wp-includes/wlwmanifest.xml HTTP/1.1” 200 88 “-” “Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/78.0.3904.108 Safari/537.36” | TLSv1.2 | - - 0.168 - 0 NC:000000 UP:-

178.128.53.104 bmsdchosting2.net - [08/Aug/2021:23:57:52 +0000] “GET //wp/wp-includes/wlwmanifest.xml HTTP/1.1” 200 88 “-” “Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/78.0.3904.108 Safari/537.36” | TLSv1.2 | - - 0.185 - 0 NC:000000 UP:-

178.128.53.104 bmsdchosting2.net - [08/Aug/2021:23:57:52 +0000] “GET //news/wp-includes/wlwmanifest.xml HTTP/1.1” 200 88 “-” “Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/78.0.3904.108 Safari/537.36” | TLSv1.2 | - - 0.170 - 0 NC:000000 UP:-

178.128.53.104 bmsdchosting2.net - [08/Aug/2021:23:57:52 +0000] “GET //2018/wp-includes/wlwmanifest.xml HTTP/1.1” 200 88 “-” “Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/78.0.3904.108 Safari/537.36” | TLSv1.2 | - - 0.169 - 0 NC:000000 UP:-

178.128.53.104 bmsdchosting2.net - [08/Aug/2021:23:57:52 +0000] “GET //2019/wp-includes/wlwmanifest.xml HTTP/1.1” 200 88 “-” “Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/78.0.3904.108 Safari/537.36” | TLSv1.2 | - - 0.168 - 0 NC:000000 UP:-

178.128.53.104 bmsdchosting2.net - [08/Aug/2021:23:57:52 +0000] “GET //shop/wp-includes/wlwmanifest.xml HTTP/1.1” 200 88 “-” “Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/78.0.3904.108 Safari/537.36” | TLSv1.2 | - - 0.170 - 0 NC:000000 UP:-

178.128.53.104 bmsdchosting2.net - [08/Aug/2021:23:57:53 +0000] “GET //wp1/wp-includes/wlwmanifest.xml HTTP/1.1” 200 88 “-” “Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/78.0.3904.108 Safari/537.36” | TLSv1.2 | - - 0.183 - 0 NC:000000 UP:-

178.128.53.104 bmsdchosting2.net - [08/Aug/2021:23:57:53 +0000] “GET //test/wp-includes/wlwmanifest.xml HTTP/1.1” 200 88 “-” “Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/78.0.3904.108 Safari/537.36” | TLSv1.2 | - - 0.171 - 0 NC:000000 UP:-

178.128.53.104 bmsdchosting2.net - [08/Aug/2021:23:57:53 +0000] “GET //media/wp-includes/wlwmanifest.xml HTTP/1.1” 200 88 “-” “Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/78.0.3904.108 Safari/537.36” | TLSv1.2 | - - 0.170 - 0 NC:000000 UP:-

178.128.53.104 bmsdchosting2.net - [08/Aug/2021:23:57:53 +0000] “GET //wp2/wp-includes/wlwmanifest.xml HTTP/1.1” 200 88 “-” “Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/78.0.3904.108 Safari/537.36” | TLSv1.2 | - - 0.169 - 0 NC:000000 UP:-

178.128.53.104 bmsdchosting2.net - [08/Aug/2021:23:57:53 +0000] “GET //site/wp-includes/wlwmanifest.xml HTTP/1.1” 200 88 “-” “Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/78.0.3904.108 Safari/537.36” | TLSv1.2 | - - 0.170 - 0 NC:000000 UP:-

178.128.53.104 bmsdchosting2.net - [08/Aug/2021:23:57:54 +0000] “GET //cms/wp-includes/wlwmanifest.xml HTTP/1.1” 200 88 “-” “Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/78.0.3904.108 Safari/537.36” | TLSv1.2 | - - 0.195 - 0 NC:000000 UP:-

178.128.53.104 bmsdchosting2.net - [08/Aug/2021:23:57:54 +0000] “GET //sito/wp-includes/wlwmanifest.xml HTTP/1.1” 200 88 “-” “Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/78.0.3904.108 Safari/537.36” | TLSv1.2 | - - 0.168 - 0 NC:000000 UP:-

178.128.53.104 bmsdchosting2.net - [08/Aug/2021:23:57:54 +0000] “” 400 0 “-” “-” | TLSv1.2 | - - 0.167 - 0 NC:000000 UP:-

207.46.13.6 bmsdchosting2.net - [09/Aug/2021:01:11:29 +0000] “GET /robots.txt HTTP/1.1” 301 162 “-” “Mozilla/5.0 (compatible; bingbot/2.0; +http://www.bing.com/bingbot.htm)” | - | - - 0.000 - 0 NC:000000 UP:-

207.46.13.6 bmsdchosting2.net - [09/Aug/2021:01:11:30 +0000] “GET /robots.txt HTTP/2.0” 500 3714 “-” “Mozilla/5.0 (compatible; bingbot/2.0; +http://www.bing.com/bingbot.htm)” | TLSv1.2 | 0.259 0.259 0.260 MISS 0 NC:000000 UP:SKIP_CACHE_EXPIRED

40.77.167.10 bmsdchosting2.net - [09/Aug/2021:01:11:39 +0000] “GET / HTTP/1.1” 301 162 “-” “Mozilla/5.0 (compatible; bingbot/2.0; +http://www.bing.com/bingbot.htm)” | - | - - 0.000 - 0 NC:000000 UP:-

Figured it out. The version of PHP was too high. I reduced from 7.4 to 7.3 and now everything is fine. It’s funny because I thought I’d tried that a few days ago but maybe something else was wrong at that time. :slight_smile:

Curious… the error logs suggest a permissions issue with the database user. Silverstripe 4 will run quite happily on PHP7.4, so something a bit odd is going on!

Glad you’re up and running though