Discover Top Posts Tagged with #database.yml

Missing database.yml file in a project using Rails 3

We'll I actually encountered this problem with missing database.yml file in a project using Rails 3 and my solution was to add a new file in config folder that is the database.yml

Here's how:

1. Understand the Error. In that first line, you can see this error

/Users/honeylyn/.rvm/gems/ruby-1.9.3-p194/gems/railties-3.2.8/lib/rails/application/configuration.rb:115:in `read': No such file or directory - /Users/honeylyn/WebApps/honee-adakite/config/database.yml (Errno::ENOENT)

So you know that your database.yml is missing as it said "No such file or directory'

2. Go to your text-editor and look for the config folder.

You might ask what should be added in the database.yml file

Here's an example of what I added on my database.yml file since I'm using sqlite3:

# SQLite version 3.x # gem install sqlite3 # # Ensure the SQLite 3 gem is defined in your Gemfile # gem 'sqlite3' development: adapter: sqlite3 database: db/development.sqlite3 pool: 5 timeout: 5000 # 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: adapter: sqlite3 database: db/test.sqlite3 pool: 5 timeout: 5000 production: adapter: sqlite3 database: db/production.sqlite3 pool: 5 timeout: 5000

#database.yml #rails #ruby #rails 3

Metasploit && PostgreSQL

Righto, so the other day I obliterated my postgre install, don't ask me why or how. It suffice to say it was gone. Add to the fact that metasploit has deprecated the db_driver command, only supporting postgre now, so the sqlite3 instance I had is no more. Oh and if at any point during this post you sit there thing, what the fuck is he on about, I'm writing it as I understand, which might not be correct.

Anyway, I installed postgress and setup a new user. I have constant issues with my Internet connection between home and campus (both going through the university connection, only one requires proxy auth). apt-get was failing and I hate constantly changing settings so I just downloaded and compiled from source.

wget <postgres URL> tar -xvf postgres-version && cd postgres-version ./configure make make install

Made a postgres user for metasploit, created a database and granted permissions to the metasploit user.

sudo -u postgres psql postgres-# create user msfuser with password 'somepassword'; postgres-# create database msfdb; postgres=# grant all privileges on database msfdb to msfuser;

I then fired up metasploit, connected to the db and thought everything was fine, but everytime I restarted my msfconsole session it would forget my db settings. mep.

Anyway, so did some digging in /opt/metasploit-X.X.X/config/

found the database.yml configuration and edited it to match the newly made database settings. Now everything is happy again and peace has been restored, no more msfconsole - n to keep it from crying...

#msfconsole #postgresql #metasploit #database.yml #configuration

undefined method `[]' for nil:NilClass

新建 mysql 資料庫時出現問題： $ rake db:create forum_test already exists rake aborted! undefined method `[]' for nil:NilClass 看得出 `test` 環境沒事，加 `RAILS_ENV=production` 測試也 OK，問題只出在 `development`。再三檢查 `database.yml` 才發現，原來是因為 development 前面，我多打了個 i： idevelopment: 題外話，`RAILS_ENV=production` 若是打成 `RAILS_ENV="production"` 也是不可以的 XD ## Reference * [ruby on rails 3 - rake undefined method `[]' for nil:NilClass - Stack Overflow](http://stackoverflow.com/questions/7623983/rake-undefined-method-for-nilnilclass)

#rails #db:create #database.yml #undefined method

can't convert Fixnum into String

執行 `rake db:create` 時，遭遇到這樣的錯誤訊息： can't convert Fixnum into String 原因是出在 database.yml 裡，設定 MySQL db 的密碼時，使用的是全是數字： password: 123456 在這情況下，YAML parser 就把它當作 `Fixnum` 了。避免這個問題，可以加上雙引號： password: "123456" ## Reference * [ruby on rails - Can't convert fixnum to string during rake db:create - Stack Overflow](http://stackoverflow.com/questions/3765834/cant-convert-fixnum-to-string-during-rake-dbcreate)

#rails #mysql #db:create #database.yml #rake #yaml

[hogehoge@ railstudy] vi config/database.yml 　password:_********* ←追加(最初に半角スペースを入れないと行けない)

http://bit.ly/oY1C8N

#Ruby #ruby on rails #programming #database.yml