To configure your database, you will need to edit the config/database.yml file.

The defaults are set to use MySQL, but Wagn has been well tested in PostgreSQL (including full-text search), and there are rumors that it functions properly in SQLite.

This is a standard Ruby-on-Rails setup, so if you encounter problems with database configuration and can't find answers here, considering broadening your search beyond "wagn database installation" to "rails database installation".

Engine-Specific help:

MySQL

If you are running mysql and rake complains about not being able to find your mysql.sock file, you will need to add "socket: " to each of the database definitions

database.yml example development section

• view
  • refresh
  • page ↵
  • type: Basic ↵
• advanced
  • rules
    • The card "database.yml example development section"
    • All "+database.yml example development section" cards
  • related
    • children
    • mates
  • referred to by
    • all
    • links
    • inclusions
  • refers to
    • all
    • links
    • inclusions
  • editors
    • all editors
    • creator: John Abbe ↵
    • last editor: John Abbe ↵

development: adapter: mysql socket: /var/mysql/mysql.sock database: wagn_development username: wagn password: hi_im_a_password_right_up_in_here host: localhost   test: adapter: mysql socket: /var/mysql/mysql.sock database: wagn_test username: wagn password: woo_hoo_password ...

PostgreSQL

Postgres hints: you may have to mess with authentication config in pg_hba.conf to connect. Default configs have local identity based setting for authentication, and none for remote.

become 'postgres' user (typically the root user for postgresql):
createuser -d wagn-db-user -P

(enter db user pw twice)

createdb -O wagn-db-user name-of-database