Level 1
Is the DATABASE_URL set when you run heroku config? If not, you probably need to run heroku pg:promote HEROKU_POSTGRESQL_RED replacing red with whatever color your database has according to Heroku.
Mar 9, 2015
8
Level 13
environment variable in laravel4.2
Recently I deploy my app on Heroku by following tutorial https://mattstauffer.co/blog/installing-a-laravel-app-on-heroku but when I try to making table or anything locally it saying
{"error":{"type":"ErrorException","message":"Undefined index: host","file":"C:\\lamp\\www\\heraku\\app\\config\\database.php","line":69}}
I try to check my environment same error
databse setting in database.php
'pgsql' => array(
'driver' => 'pgsql',
'host' => parse_url(getenv("DATABASE_URL"))["host"],
'database' => substr(parse_url(getenv("DATABASE_URL"))["path"], 1),
'username' => parse_url(getenv("DATABASE_URL"))["user"],
'password' => parse_url(getenv("DATABASE_URL"))["pass"],
'charset' => 'utf8',
'prefix' => '',
'schema' => 'public',
),
Level 13
I did it , and when I migrate my table "heroku run php /app/artisan migrate" Ican but problem is that when I try to do anything locally It not allow same error
Level 1
Yes. This is because you need to create a file named .env in your project root, specifying the environment variables, including DATABASE_URL
This could look something like
APP_DEBUG=true
DATABASE_URL=your database url
Level 13
same problem
Level 1
Post some dumps of your environment files (of course with your passwords and such hidden)
Level 13
APP_ENV=local APP_DEBUG=true APP_KEY=secret
DATABASE_URL=something
Level 1
Are these seperated by a new line? Also, please hide your passwords =)
Level 13
yes
Please or to participate in this conversation.