# MySQL. Versions 5.0+ are recommended. # # Install the MYSQL driver # gem install mysql2 # # Ensure the MySQL gem is defined in your Gemfile # gem 'mysql2' # # And be sure to use new-style password hashing: # http://dev.mysql.com/doc/refman/5.0/en/old-client.html # default: &default adapter: mysql2 encoding: utf8 pool: 5 username: root password: host: localhost # # UMLAUT: mysql db with mysql2 adapter strongly recommended for Umlaut, in both # production and development. sqlite3 has unclear semantics under threaded # concurrency which umlaut uses, and in many cases simply does not work. # # A higher pool size than ordinary is recommended because of umlaut's # use of concurrency. Perhaps as large as the number of services # you have configured to run in the same wave, plus another few. # # development: # adapter: mysql2 # host: # username: # password: # database: # pool: 15 development: <<: *default database: dummy_development # Warning: The database defined as "test" will be erased and # re-generated from your development database when you run "rake". # Do not set this db to the same as development or production. test: <<: *default database: dummy_test # As with config/secrets.yml, you never want to store sensitive information, # like your database password, in your source code. If your source code is # ever seen by anyone, they now have access to your database. # # Instead, provide the password as a unix environment variable when you boot # the app. Read http://guides.rubyonrails.org/configuring.html#configuring-a-database # for a full rundown on how to provide these environment variables in a # production deployment. # # On Heroku and other platform providers, you may have a full connection URL # available as an environment variable. For example: # # DATABASE_URL="mysql2://myuser:mypass@localhost/somedatabase" # # You can use this database configuration with: # # production: # url: <%= ENV['DATABASE_URL'] %> # production: <<: *default database: dummy_production username: dummy password: <%= ENV['DUMMY_DATABASE_PASSWORD'] %> # # UMLAUT: for the 'search' functions (A-Z title lookup) to work, you need # a direct database connection to the SFX database, under 'sfx_db' key. # You should manually set up a new read-only MySQL account in the SFX db # for this purpose, rather than use one of the full-access existing SFX # mysql accounts. # #sfx_db: # adapter: mysql2 # host: my_sfx_host.u.edu # port: 3310 # 3310 is defualt SFX embedded mysql port # database: sfxlcl41 # or other sfx instance db # username: # password: # pool: 5 # encoding: utf8 #