postgresql - DreamFactory 2授权错误

Question

我已经从 GitHub 安装了 DF2，并将 postgresql 作为数据库。安装过程中没有错误消息。然后我使用管理员的电子邮件/密码进入 DF。没问题，我可以看到管理员用户的个人资料。但是我在 apache2 日志中收到以下错误:

[Thu Nov 12 22:54:12.941506 2015] [:error] [pid 2886] [client 37.204.150.51:50852] REST Exception #401 > Invalid credentials supplied., referer: http://needgeo.com/dreamfactory/dist/index.html

[Thu Nov 12 22:54:13.904079 2015] [:error] [pid 2886] [client 37.204.150.51:50852] REST Exception #404 > Record not found, referer: http://needgeo.com/dreamfactory/dist/index.html

在 dreamfactory.log 中:

[2015-11-12 19:53:47] local.ALERT: Could not get cors config from DB - SQLSTATE[42883]: Undefined function: 7 ERROR:  operator does not exist: boolean = integer
LINE 1: select * from "cors_config" where enabled = 1
                                                  ^
HINT:  No operator matches the given name and argument type(s). You might need to add explicit type casts. (SQL: select * from "cors_config" where enabled = 1)  
[2015-11-12 19:53:47] local.ALERT: Could not get cors config from DB - SQLSTATE[42883]: Undefined function: 7 ERROR:  operator does not exist: boolean = integer
LINE 1: select * from "cors_config" where enabled = 1
                                                  ^
HINT:  No operator matches the given name and argument type(s). You might need to add explicit type casts. (SQL: select * from "cors_config" where enabled = 1)  
[2015-11-12 19:53:48] local.DEBUG: Resource event: system.environment.get.pre_process  
[2015-11-12 19:53:48] local.DEBUG: Resource event: system.environment.get.post_process  
[2015-11-12 19:53:48] local.ALERT: Could not get cors config from DB - SQLSTATE[42883]: Undefined function: 7 ERROR:  operator does not exist: boolean = integer
LINE 1: select * from "cors_config" where enabled = 1
                                                  ^
HINT:  No operator matches the given name and argument type(s). You might need to add explicit type casts. (SQL: select * from "cors_config" where enabled = 1)  
[2015-11-12 19:53:48] local.DEBUG: Resource event: system.environment.get.pre_process  
[2015-11-12 19:53:48] local.DEBUG: Resource event: system.environment.get.post_process  
[2015-11-12 19:54:12] local.ALERT: Could not get cors config from DB - SQLSTATE[42883]: Undefined function: 7 ERROR:  operator does not exist: boolean = integer
LINE 1: select * from "cors_config" where enabled = 1
                                                  ^
HINT:  No operator matches the given name and argument type(s). You might need to add explicit type casts. (SQL: select * from "cors_config" where enabled = 1)  
[2015-11-12 19:54:12] local.DEBUG: Resource event: user.session.post.pre_process  
[2015-11-12 19:54:12] local.ALERT: Could not get cors config from DB - SQLSTATE[42883]: Undefined function: 7 ERROR:  operator does not exist: boolean = integer
LINE 1: select * from "cors_config" where enabled = 1
                                                  ^
HINT:  No operator matches the given name and argument type(s). You might need to add explicit type casts. (SQL: select * from "cors_config" where enabled = 1)  
[2015-11-12 19:54:12] local.DEBUG: Resource event: system.admin.session.post.pre_process  
[2015-11-12 19:54:13] local.DEBUG: Resource event: system.admin.session.post.post_process  
[2015-11-12 19:54:13] local.ALERT: Could not get cors config from DB - SQLSTATE[42883]: Undefined function: 7 ERROR:  operator does not exist: boolean = integer
LINE 1: select * from "cors_config" where enabled = 1
                                                  ^
HINT:  No operator matches the given name and argument type(s). You might need to add explicit type casts. (SQL: select * from "cors_config" where enabled = 1)  
[2015-11-12 19:54:13] local.DEBUG: Resource event: user.custom.get.pre_process  
[2015-11-12 19:54:13] local.ALERT: Could not get cors config from DB - SQLSTATE[42883]: Undefined function: 7 ERROR:  operator does not exist: boolean = integer
LINE 1: select * from "cors_config" where enabled = 1
                                                  ^
HINT:  No operator matches the given name and argument type(s). You might need to add explicit type casts. (SQL: select * from "cors_config" where enabled = 1)  
[2015-11-12 19:54:14] local.ALERT: Could not get cors config from DB - SQLSTATE[42883]: Undefined function: 7 ERROR:  operator does not exist: boolean = integer
LINE 1: select * from "cors_config" where enabled = 1
                                                  ^
HINT:  No operator matches the given name and argument type(s). You might need to add explicit type casts. (SQL: select * from "cors_config" where enabled = 1)  
[2015-11-12 19:54:14] local.ALERT: Could not get cors config from DB - SQLSTATE[42883]: Undefined function: 7 ERROR:  operator does not exist: boolean = integer
LINE 1: select * from "cors_config" where enabled = 1
                                                  ^
HINT:  No operator matches the given name and argument type(s). You might need to add explicit type casts. (SQL: select * from "cors_config" where enabled = 1)  
[2015-11-12 19:54:14] local.ALERT: Could not get cors config from DB - SQLSTATE[42883]: Undefined function: 7 ERROR:  operator does not exist: boolean = integer
LINE 1: select * from "cors_config" where enabled = 1
                                                  ^
HINT:  No operator matches the given name and argument type(s). You might need to add explicit type casts. (SQL: select * from "cors_config" where enabled = 1)  
[2015-11-12 19:54:14] local.ALERT: Could not get cors config from DB - SQLSTATE[42883]: Undefined function: 7 ERROR:  operator does not exist: boolean = integer
LINE 1: select * from "cors_config" where enabled = 1
                                                  ^
HINT:  No operator matches the given name and argument type(s). You might need to add explicit type casts. (SQL: select * from "cors_config" where enabled = 1)  
[2015-11-12 19:54:14] local.ALERT: Could not get cors config from DB - SQLSTATE[42883]: Undefined function: 7 ERROR:  operator does not exist: boolean = integer
LINE 1: select * from "cors_config" where enabled = 1
                                                  ^
HINT:  No operator matches the given name and argument type(s). You might need to add explicit type casts. (SQL: select * from "cors_config" where enabled = 1)  
[2015-11-12 19:54:14] local.DEBUG: Service event: system.get.pre_process  
[2015-11-12 19:54:14] local.DEBUG: Resource event: system.app.get.pre_process  
[2015-11-12 19:54:14] local.DEBUG: Service event: system.get.post_process  
[2015-11-12 19:54:14] local.DEBUG: Resource event: system.service_type.get.pre_process  
[2015-11-12 19:54:14] local.DEBUG: Resource event: system.config.get.pre_process  
[2015-11-12 19:54:14] local.DEBUG: Resource event: system.service.get.pre_process  
[2015-11-12 19:54:14] local.DEBUG: Resource event: system.environment.get.pre_process  
[2015-11-12 19:54:14] local.ALERT: Could not get cors config from DB - SQLSTATE[42883]: Undefined function: 7 ERROR:  operator does not exist: boolean = integer
LINE 1: select * from "cors_config" where enabled = 1
                                                  ^
HINT:  No operator matches the given name and argument type(s). You might need to add explicit type casts. (SQL: select * from "cors_config" where enabled = 1)  
[2015-11-12 19:54:14] local.DEBUG: Resource event: system.environment.get.post_process  
[2015-11-12 19:54:14] local.DEBUG: Resource event: system.role.get.pre_process  
[2015-11-12 19:54:14] local.ALERT: Could not get cors config from DB - SQLSTATE[42883]: Undefined function: 7 ERROR:  operator does not exist: boolean = integer
LINE 1: select * from "cors_config" where enabled = 1
                                                  ^
HINT:  No operator matches the given name and argument type(s). You might need to add explicit type casts. (SQL: select * from "cors_config" where enabled = 1)  
[2015-11-12 19:54:14] local.DEBUG: Resource event: system.admin.get.pre_process  
[2015-11-12 19:54:14] local.DEBUG: Resource event: system.config.get.post_process  
[2015-11-12 19:54:14] local.ALERT: Could not get cors config from DB - SQLSTATE[42883]: Undefined function: 7 ERROR:  operator does not exist: boolean = integer
LINE 1: select * from "cors_config" where enabled = 1
                                                  ^
HINT:  No operator matches the given name and argument type(s). You might need to add explicit type casts. (SQL: select * from "cors_config" where enabled = 1)  
[2015-11-12 19:54:14] local.DEBUG: Resource event: system.user.get.pre_process  
[2015-11-12 19:54:15] local.DEBUG: Resource event: system.role.get.post_process  
[2015-11-12 19:54:15] local.ALERT: Could not get cors config from DB - SQLSTATE[42883]: Undefined function: 7 ERROR:  operator does not exist: boolean = integer
LINE 1: select * from "cors_config" where enabled = 1
                                                  ^
HINT:  No operator matches the given name and argument type(s). You might need to add explicit type casts. (SQL: select * from "cors_config" where enabled = 1)  
[2015-11-12 19:54:15] local.DEBUG: Resource event: system.email_template.get.pre_process  
[2015-11-12 19:54:15] local.DEBUG: Resource event: system.service.get.post_process  
[2015-11-12 19:54:15] local.DEBUG: Resource event: system.app.get.post_process  
[2015-11-12 19:54:15] local.ALERT: Could not get cors config from DB - SQLSTATE[42883]: Undefined function: 7 ERROR:  operator does not exist: boolean = integer
LINE 1: select * from "cors_config" where enabled = 1
                                                  ^
HINT:  No operator matches the given name and argument type(s). You might need to add explicit type casts. (SQL: select * from "cors_config" where enabled = 1)  
[2015-11-12 19:54:15] local.DEBUG: Resource event: system.lookup.get.pre_process  
[2015-11-12 19:54:15] local.ALERT: Could not get cors config from DB - SQLSTATE[42883]: Undefined function: 7 ERROR:  operator does not exist: boolean = integer
LINE 1: select * from "cors_config" where enabled = 1
                                                  ^
HINT:  No operator matches the given name and argument type(s). You might need to add explicit type casts. (SQL: select * from "cors_config" where enabled = 1)  
[2015-11-12 19:54:15] local.ALERT: Could not get cors config from DB - SQLSTATE[42883]: Undefined function: 7 ERROR:  operator does not exist: boolean = integer
LINE 1: select * from "cors_config" where enabled = 1
                                                  ^
HINT:  No operator matches the given name and argument type(s). You might need to add explicit type casts. (SQL: select * from "cors_config" where enabled = 1)  
[2015-11-12 19:54:15] local.DEBUG: Resource event: system.email_template.get.post_process  
[2015-11-12 19:54:15] local.DEBUG: Resource event: system.cors.get.pre_process  
[2015-11-12 19:54:15] local.DEBUG: Resource event: system.app_group.get.pre_process  
[2015-11-12 19:54:15] local.ALERT: Could not get cors config from DB - SQLSTATE[42883]: Undefined function: 7 ERROR:  operator does not exist: boolean = integer
LINE 1: select * from "cors_config" where enabled = 1
                                                  ^
HINT:  No operator matches the given name and argument type(s). You might need to add explicit type casts. (SQL: select * from "cors_config" where enabled = 1)  
[2015-11-12 19:54:15] local.ALERT: Could not get cors config from DB - SQLSTATE[42883]: Undefined function: 7 ERROR:  operator does not exist: boolean = integer
LINE 1: select * from "cors_config" where enabled = 1
                                                  ^
HINT:  No operator matches the given name and argument type(s). You might need to add explicit type casts. (SQL: select * from "cors_config" where enabled = 1)  
[2015-11-12 19:54:15] local.DEBUG: Resource event: system.event.get.pre_process  
[2015-11-12 19:54:16] local.DEBUG: Resource event: system.event.get.post_process  
[2015-11-12 19:54:16] local.DEBUG: Resource event: system.script_type.get.pre_process  
[2015-11-12 19:54:16] local.DEBUG: Resource event: system.lookup.get.post_process  
[2015-11-12 19:54:16] local.DEBUG: Resource event: system.cors.get.post_process  
[2015-11-12 19:54:16] local.DEBUG: Resource event: system.app_group.get.post_process  
[2015-11-12 19:54:16] local.DEBUG: Resource event: system.script_type.get.post_process  
[2015-11-12 19:54:22] local.DEBUG: Resource event: system.service_type.get.post_process

如果我按刷新按钮，它会再次将我发送到登录页面。如果我更改配置文件中的某些内容并按更新，则什么也没有发生。下一次访问配置文件显示旧数据。

可能是什么原因？谢谢!

Answer 1

看来，我的问题介于我为用户使用的 PostgreSQL 数据库和 DF2 实例之间。我检查了我的 PostgreSQL 日志并发现:

2015-11-13 14:54:37 MSK STATEMENT:  select * from "cors_config" where enabled = 1
2015-11-13 14:54:38 MSK ERROR:  operator does not exist: boolean = integer at character 43
2015-11-13 14:54:38 MSK HINT:  No operator matches the given name and argument type(s). You might need to add explicit type casts.

当然这不是解决方案，但一旦我迁移回 MySql 数据库用户存储，它就开始工作了。