Focuslab Master Config staging server not working

Question

I'm 100% this is user error on my part.

I'm using the focuslab master config set up to run locally, staging and live. The site works correctly on live and locally but staging I keep getting a database error.

Unable to connect to your database server using the provided settings.

Filename: core/EE_Config.php

Line Number: 207

After looking at this thread I added exit('here'); to config.stage.php but nothing happened. I've tested the database credentials in another script and the connections are working there. Am quite lost.

my config.env.php file has the following:

switch (strtolower($_SERVER['HTTP_HOST'])) {
    case 'domain.ca' :
        define('ENV', 'prod');
        define('ENV_FULL', 'Production');
        define('ENV_DEBUG', FALSE);
    break;

    case 'domaindev.com' :
        define('ENV', 'stage');
        define('ENV_FULL', 'Staging');
        define('ENV_DEBUG', FALSE);
    break;

    case 'localdomain.dev' :
        define('ENV', 'local');
        define('ENV_FULL', 'Local');
        define('ENV_DEBUG', TRUE);
    break;

    default :
        define('ENV', 'local');
        define('ENV_FULL', 'Local');
        define('ENV_DEBUG', TRUE);
    break;

The live site is at domain.com and staging is at subdomain.mysite.com

I can see the working site locally and on live (just deployed the master branch to live and to staging), but getting the database error on staging.

Please advise

Answer 1

I may just misunderstand your post but you have changed 'domaindev.com' to 'staging.mysite.com' haven't you?

Also try putting the staging db connection info in for the default/local environment (on your staging server) to see if it's just falling through to the default. Which would imply the domain isn't properly set.

Answer 2

1. Make sure the staging domain is correct in config.env.php
2. Make sure the staging config is in fact loaded (put a die("hello); at the top of your config.staging.php)
3. Verify that your site says "hello" on staging, which means it is actually loading the staging config.
4. Edit both index.php and admin.php and set $debug=1; in both.
5. Remove the die() you put in config.staging.php in step 2)
6. Load the website again, you should now get a PHP error (most likely in your config.staging.php file)

Fix the PHP error and you should be good to go :-)

(oh and you might want to set $debug=0; again in index/admin.php once everything is working)