Postgresql用户没有连接到数据库(NginxDjangoGunicorn) |
您所在的位置:网站首页 › 前端如何操作数据库 › Postgresql用户没有连接到数据库(NginxDjangoGunicorn) |
差不多一个月了,我一直在努力解决这个问题.每当我尝试在生产时访问我的Django Admin页面时,我都会收到以下错误: OperationalError at /admin/login/ FATAL: password authentication failed for user "vpusr" FATAL: password authentication failed for user "vpusr"我的production.py设置文件如下: DATABASES = { 'default': { 'ENGINE': 'django.db.backends.postgresql', 'NAME': 'vpdb', 'USER': 'vpusr', 'PASSWORD': os.environ["VP_DB_PASS"], 'HOST': 'localhost', } }注意:环境变量正常工作.即使我把普通密码硬编码在那里它也行不通. 以下是其所有者的数据库列表: List of databases Name | Owner | Encoding | Collate | Ctype | Access privileges -----------+----------+----------+-------------+-------------+----------------------- postgres | postgres | UTF8 | en_US.UTF-8 | en_US.UTF-8 | template0 | postgres | UTF8 | en_US.UTF-8 | en_US.UTF-8 | =c/postgres + | | | | | postgres=CTc/postgres template1 | postgres | UTF8 | en_US.UTF-8 | en_US.UTF-8 | =c/postgres + | | | | | postgres=CTc/postgres vpdb | vpusr | UTF8 | en_US.UTF-8 | en_US.UTF-8 | =Tc/vpusr + | | | | | vpusr=CTc/vpusr以下是用户列表: List of roles Role name | Attributes | Member of -----------+------------------------------------------------------------+----------- postgres | Superuser, Create role, Create DB, Replication, Bypass RLS | {} vpusr | Superuser, Create DB | {}正如您所看到的,我还尝试将超级用户和创建数据库的角色添加到vpusr,但这没有任何效果. 即使我尝试通过这样的终端连接,我得到同样的错误: sudo -u postgres psql -U vpusr vpdb我仍然得到错误: psql: FATAL: Peer authentication failed for user "vpusr" 当我执行此命令时: psql -U vpusr -h localhost vpdb我正确连接到psql作为vpusr. 还有一些注意事项:我确实删除了数据库,然后用户重新创建了它们.我确保密码是正确的.我在Digital Ocean的Ubuntu服务器上使用了Gunicorn,Nginx,Virtualenv,Django,Postgres. 提前感谢您花时间阅读并帮助我! 编辑: 我注意到我的应用程序迁移文件夹中没有迁移!可能是django或我的用户或postgres没有写文件的权限? 编辑:注意:我将用户更改为托尼 在我的postgres日志文件中发现以下错误: 2017-09-09 18:09:55 UTC [29909-2] LOG: received fast shutdown request 2017-09-09 18:09:55 UTC [29909-3] LOG: aborting any active transactions 2017-09-09 18:09:55 UTC [29914-2] LOG: autovacuum launcher shutting down 2017-09-09 18:09:55 UTC [29911-1] LOG: shutting down 2017-09-09 18:09:55 UTC [29911-2] LOG: database system is shut down 2017-09-09 18:09:56 UTC [2711-1] LOG: database system was shut down at 2017-09-09 18:09:55 UTC 2017-09-09 18:09:56 UTC [2711-2] LOG: MultiXact member wraparound protections are now enabled 2017-09-09 18:09:56 UTC [2710-1] LOG: database system is ready to accept connections 2017-09-09 18:09:56 UTC [2715-1] LOG: autovacuum launcher started 2017-09-09 18:09:57 UTC [2717-1] [unknown]@[unknown] LOG: incomplete startup packet 2017-09-09 18:10:17 UTC [2740-1] tony@vpdb LOG: provided user name (tony) and authenticated user name (postgres) do not match 2017-09-09 18:10:17 UTC [2740-2] tony@vpdb FATAL: Peer authentication failed for user "tony" 2017-09-09 18:10:17 UTC [2740-3] tony@vpdb DETAIL: Connection matched pg_hba.conf line 90: "local all all peer"编辑: pg_hba.conf文件: # Database administrative login by Unix domain socket local all postgres peer # TYPE DATABASE USER ADDRESS METHOD # "local" is for Unix domain socket connections only local all all peer # IPv4 local connections: host all all 127.0.0.1/32 password # IPv6 local connections: host all all ::1/128 md5 # Allow replication connections from localhost, by a user with the # replication privilege. #local replication postgres peer #host replication postgres 127.0.0.1/32 md5 #host replication postgres ::1/128 md5你能说出什么呢? |
今日新闻 |
推荐新闻 |
CopyRight 2018-2019 办公设备维修网 版权所有 豫ICP备15022753号-3 |