Rails database password as environment variables

Question

This works:

production:
  adapter: mysql2
  encoding: utf8
  host: localhost
  database: myapp
  username: myapp
  password: jksdfUIJsdf

Then on terminal touch tmp/restart.txt.

This does not work:

production:
  adapter: mysql2
  encoding: utf8
  host: localhost
  database: myapp
  username: myapp
  password: <%= ENV['MYAPP_DATABASE_PASSWORD'] %>

Then on terminal

export MYAPP_DATABASE_PASSWORD=jksdfUIJsdf
touch tmp/restart.txt

So if I set the password as plaintext in database.yml file then my application works properly but if I set the password as environment variable with export command, then my application does not work because it gives error password missing. I am using mysql database. How to solve this?

What happens if you do 'puts ENV['MYAPP_DATABASE_PASSWORD']' in the rails console? — DanSingerman
– DanSingerman, Commented Apr 13, 2018 at 10:17

David Moles · Accepted Answer · 2019-10-24 18:23:49Z

2

When you touch tmp/restart.txt, you're not starting a new Rails server, you're just telling the existing server to reload itself. The existing server will still have the environment it started with, and will never see any environment variables you set after that time.

answered Oct 24, 2019 at 18:23

David Moles

51.7k30 gold badges152 silver badges249 bronze badges

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

Comments

Abhilash Reddy · Accepted Answer · 2018-04-13 10:17:51Z

0

For Rails app configuration, I use figaro gem.

Add the below line to your Gemfile and do bundle.

gem "figaro"

After that run the below command:

bundle exec figaro install

This will create config/application.yml and also will add it to the .gitignore file.

Now inside config/application.yml enter the credentials.

# config/application.yml

MYAPP_DATABASE_PASSWORD: "2954"

Visit the Github page for more info.

answered Apr 13, 2018 at 10:17

Abhilash Reddy

1,5491 gold badge13 silver badges24 bronze badges

Collectives™ on Stack Overflow

Rails database password as environment variables

2 Answers 2

Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related