Database configuration¶

Where is the DB?!

By default, Foreman will use sqlite3 as a database, its configuration can be found at

config/database.yml

By default, the database can be found at the db subdirectory.
Foreman is a rails application, therefor, anything that is supported under RAILS (sqlite, mysql, postsql, oracle etc) can be used.

I want to use MySQL¶

edit your config/database.yml and modify:

production:
  adapter: mysql
  database: puppet
  username: puppet
  password: password
  host: localhost
  socket: "/var/run/mysqld/mysqld.sock" 

afterwards you would need to re populate your database, simply execute extras/dbmigrate script.

I want to switch from SQLite to Mysql and maintain my data¶

I found this article that may help you out

http://blog.heroku.com/archives/2007/11/23/yamldb_for_databaseindependent_data_dumps/