这是我的database.yml文件的外观(显然还有相关的测试和生产条目)
development: adapter: postgresql encoding: unicode database: dbname_dev pool: 5 username: username password: tehpass
psql -U username dbname_dev
但是在创建这个新的rails项目并运行之后
rails g controller ComingSoon index
当我去本地主机时,我收到以下消息:3000 / come_soon(尽管双重和三重检查登录凭据)
fe_sendauth: no password supplied
解决方法
database.yml的:
connection: &connection adapter: postgresql encoding: unicode pool: 5 username: username password: tehpass development: <<: *connection database: dbname_development test: <<: *connection database: dbname_test production: <<: *connection database: dbname_production
如果这不适合您,那么安装过程中可能会出现问题.
参观这个blog,希望这可以帮助你.
编辑
错误案例:
e_sendauth: no password supplied fe_sendauth: no password supplied
这种情况发生在库存的Ubuntu安装下,由于pg_hba.conf中的权限默认是太限制性的.要允许rails连接,只需更改pg_hba.conf的底部,就好像这样.
# TYPE DATABASE USER CIDR-ADDRESS METHOD # "local" is for Unix domain socket connections only local all all trust # IPv4 local connections: host all all 127.0.0.1/32 trust # IPv6 local connections: host all all ::1/128 trust
让我知道这是否有帮助?