问DreamFactory 2授权错误
EN

Stack Overflow用户

提问于 2015-11-12 20:51:02

回答 1查看 138关注 0票数 2

我已经用postgresql作为DB安装了来自GitHub的GitHub。在安装过程中没有错误消息。然后，我使用管理员的电子邮件/密码输入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

如果我按下刷新按钮，它会再次将我发送到登录页面。如果我在配置文件中更改了什么并按更新，那么什么都不会发生。下一次访问配置文件显示旧数据。

可能是什么原因？谢谢!

postgresql

Stack Overflow用户

回答已采纳

发布于 2015-11-13 12:48:00

似乎，我的问题介于我为用户使用的PostgreSQL db和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 db用户存储时，它就开始工作了。

票数 0

查看全部 1 条回答

页面原文内容由Stack Overflow提供。腾讯云小微IT领域专用引擎提供翻译支持

原文链接：

https://stackoverflow.com/questions/33681090

复制

相似问题

问DreamFactory 2授权错误
EN

Stack Overflow用户

社区

活动

圈层

关于

腾讯云开发者

热门产品

热门推荐

更多推荐

问DreamFactory 2授权错误EN

Stack Overflow用户

社区

活动

圈层

关于

腾讯云开发者

热门产品

热门推荐

更多推荐

问DreamFactory 2授权错误
EN