Dotenv may not be loaded in time for loading of config/database.yml about dotenv

I had a similar issue where my password started with "#", turns out that commented out the password string and I kept on getting "no password supplied"...

[technicalpickles]

Also, I should note that this is Rails 3.2.11, and I was using dotenv successfully in this application previously, but only in config/initializers/*.rb.

[technicalpickles]

Disregard, had 0.4.0 locked, and updating to 0.5.0 fixed 😓

[bkeepers]

What version of dotenv are you using? I just pushed a new version last week that loads earlier in the bootstrap process, which should fix this issue.

[bkeepers]

haha, posted at the same time :P

Glad it's working!

[AquaGeek]

This doesn't seem to be working with Ruby 2.0.0-p0 and Rails 4.0.0.rc2. Using the same <%= raise ENV.inspect %> trick, none of my variables in my .env file show up.

[aurels]

I have the same problem with dotenv 0.9.0 and rails 3.2.14. Is it supposed to work with these versions ?

Thanks !

[bkeepers]

I'm quite certain it works for those versions. Can you post more details on what your .env file looks like and the behavior you're seeing?

[aurels]

Of course :

.env :

RAILS_ENV="staging"

MYSQL_HOST="xxxx" 
MYSQL_DATABASE="dddd"
MYSQL_USERNAME="uuuuu"
MYSQL_PASSWORD="ppppp"

config/database.yml :
<%= ENV['RAILS_ENV'] %>:
adapter: mysql2
host: <%= ENV['MYSQL_HOST'] %>
database: <%= ENV['MYSQL_DATABASE'] %>
username: <%= ENV['MYSQL_USERNAME'] %>
password: <%= ENV['MYSQL_PASSWORD'] %>
encoding: utf8
pool: 200

When doing a bundle exec rails console staging, I get a MySQL error (it cannot connect with default params).

According to the README, as I'm using Rails, I'm not supposed to do that anywhere :

require 'dotenv'
Dotenv.load

Right ?

[aurels]

Note : it fails in staging but not in development. It's probably a mistake on my side.

[aurels]

Nevermind, it works perfectly fine. There was a typo in my .env so the staging connection details where not loaded.

[bkeepers]

👍

[rewritten]

It does not work for me (Rails 2.3.17 app).

The only way to have .env loaded in time for the database, is to add at the end of config/preinitializer.rb:

# ... after Bundler magic

require 'dotenv'

ENV["RAILS_ENV"] ||= ENV["RACK_ENV"] || "development"
Dotenv.load ".env.#{ENV["RAILS_ENV"]}", '.env'

[bkeepers]

RAILS_ENV/RACKE_ENV must be specified outside of dotenv. It's a chicken and egg problem that is impossible for dotenv to solve.

[rewritten]

Even with RAILS_ENV already in env, the Railtie version of dotenv is not loading sooner than the database.yml parsing. The point (sorry for not being clear enough) is, what is the correct step to load the env files in rails 2.3, so database.yml has enough data?