Why Laravel uses wrong database file after setting environment?

Question

In bootstrap/start.php I have the following:

$env = $app->detectEnvironment(function()
{
    if($myenv = getenv('APPLICATION_ENV')):
        return $myenv;
    else:
        return 'local';
    endif;
});

Ok so I setup a local folder and put in a database.php file with my local connections.

Just to make sure its picking up the correct environment I put in the template: {{ App::environment(); }} which outputs local.

But when making a DB call its giving me error: Undefined index: DB1_HOST

My base (production) database.php file has:

'host'      => $_SERVER["DB1_HOST"],
'database'  => $_SERVER["DB1_NAME"],
'username'  => $_SERVER["DB1_USER"],
'password'  => $_SERVER["DB1_PASS"],

Why is it looking at the production database file?

yes correct. if i migrate and use env=local it picks that up! — Lee
– Lee, Commented Aug 15, 2013 at 19:54
Where are you making db calls? If in CLI, you need to specify --env=local. Also, considering making your default your local environment and specifying production specially, just so you don't default to production "by accident" ever (since that could, obviously, lead to terrible things happening). — fideloper
– fideloper, Commented Aug 15, 2013 at 20:10
Won't $myenv = getenv('APPLICATION_ENV') always be true? You're assigning the result of getenv to $myenv. — stephangroen
– stephangroen, Commented Jun 19, 2014 at 5:36
Not if 'APPLICATION_ENV' has not been set. Then it would be false and default to local. — F3CP
– F3CP, Commented Jun 20, 2014 at 4:54

Mahmood · Accepted Answer · 2016-05-03 10:21:17Z

2

Laravel also stores the config information in

bootstrap/cache/config.php

In some cases it's not updated which may result in wrong database information. Deleting the file should resolve the issue.

answered May 3, 2016 at 10:21

Mahmood

1,23710 silver badges11 bronze badges

Sign up to request clarification or add additional context in comments.

1 Comment

Amin.T Over a year ago

That was my problem, Thank you for posting the solution one year earlier :)

Valentin · Accepted Answer · 2014-06-19 19:24:43Z

1

If you are trying to use artisan in your terminal and you want to set the environment variable once and for all, you can do :

export APPLICATION_ENV=local

And check you current environment using php artisan env

answered Jun 19, 2014 at 19:24

Valentin

6021 gold badge4 silver badges15 bronze badges

Comments

Steven Henty · Accepted Answer · 2015-01-17 12:01:52Z

1

Production config files are loaded first and then merged with overrides from other environments. If the production file generates an error (e.g. undefined index) the config loading will bail early without loading the overrides. In the production config file, check the value is set before attempting to use it and the local config file will then load correctly.

answered Jan 17, 2015 at 12:01

Steven Henty

5363 silver badges7 bronze badges

Comments

Shivdhwaj Pandey · Accepted Answer · 2017-11-07 15:39:14Z

1

Clean the config cache as it may affect

php artisan config:cache

answered Nov 7, 2017 at 15:39

Shivdhwaj Pandey

1571 silver badge11 bronze badges

Collectives™ on Stack Overflow

Why Laravel uses wrong database file after setting environment?

4 Answers 4

1 Comment

Comments

Comments

Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

4 Answers 4

1 Comment

Comments

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related