Setup Database

Database types and setups

Setup database.yml file for development

To use a sqlite database you need to ensure the the sqlite gem is installed

bundle install sqlite

SQLite3 setup in the database.yml file. If this doesn’t exists, simply create it.

development:
adapter: sqlite3
database: db/[CHANGE TO YOUR OWN NAME FOR SECURITY REASONS].sqlite3

production:
adapter: sqlite3
database: db/[CHANGE TO YOUR OWN NAME FOR SECURITY REASONS].sqlite3

test:
adapter: sqlite3
database: db/[CHANGE TO YOUR OWN NAME FOR SECURITY REASONS].sqlite3

SSH Access required
Now we need to change the permission and file ownership of the new database files to make then writable.
Changing the permissions of the DB folder.

chmod 755 db
chown www-data db
chgrp www-data db

Now lets change the permission of the files. Repeat this for all the database files created for Development, Production and Test database files

cd db
chown www-data *.sqlite3
chgrp www-data *.sqlite3