无法使用Symfony登录


Unable to Login with Symfony

我目前正在用Symfony VERSION = '2.5.10'做一个项目。在我们更改数据库并更新其实体之前,一切都很正常。我已经尝试了不同的方法,但仍然无法登录系统。每当我在prod或dev环境中运行时,都会出现以下错误:

由于系统问题,无法处理身份验证请求

我已经尝试手动清除缓存,甚至通过命令提示符,甚至尝试运行以下命令:

php app'console doctrine:schema:update --dump-sql

php app'console doctrine:schema:update --force

甚至尝试创建一个新用户使用这个:

php app'console fos:user:create testuser test@example.com p@ssw0rd

并成功保存在数据库中。

这是日志文件:

[2015-07-02 08:24:06] event.DEBUG: Notified event "kernel.response" to listener "Symfony'Component'HttpKernel'EventListener'ResponseListener::onKernelResponse". [] []
[2015-07-02 08:24:06] event.DEBUG: Notified event "kernel.response" to listener "Symfony'Component'Security'Http'RememberMe'ResponseListener::onKernelResponse". [] []
[2015-07-02 08:24:06] event.DEBUG: Notified event "kernel.response" to listener "Sensio'Bundle'FrameworkExtraBundle'EventListener'HttpCacheListener::onKernelResponse". [] []
[2015-07-02 08:24:06] event.DEBUG: Notified event "kernel.response" to listener "Symfony'Component'HttpKernel'EventListener'ProfilerListener::onKernelResponse". [] []
[2015-07-02 08:24:06] event.DEBUG: Notified event "kernel.response" to listener "Symfony'Bundle'WebProfilerBundle'EventListener'WebDebugToolbarListener::onKernelResponse". [] []
[2015-07-02 08:24:06] event.DEBUG: Notified event "kernel.response" to listener "Symfony'Component'HttpKernel'EventListener'SaveSessionListener::onKernelResponse". [] []
[2015-07-02 08:24:06] event.DEBUG: Notified event "kernel.response" to listener "Symfony'Component'HttpKernel'EventListener'StreamedResponseListener::onKernelResponse". [] []
[2015-07-02 08:24:06] event.DEBUG: Notified event "kernel.finish_request" to listener "Symfony'Component'HttpKernel'EventListener'LocaleListener::onKernelFinishRequest". [] []
[2015-07-02 08:24:06] event.DEBUG: Notified event "kernel.finish_request" to listener "Symfony'Component'HttpKernel'EventListener'RouterListener::onKernelFinishRequest". [] []
[2015-07-02 08:24:06] event.DEBUG: Notified event "kernel.finish_request" to listener "Symfony'Component'Security'Http'Firewall::onKernelFinishRequest". [] []
[2015-07-02 08:24:06] event.DEBUG: Notified event "kernel.terminate" to listener "Symfony'Bundle'SwiftmailerBundle'EventListener'EmailSenderListener::onTerminate". [] []
[2015-07-02 08:24:06] event.DEBUG: Notified event "kernel.terminate" to listener "Symfony'Component'HttpKernel'EventListener'ProfilerListener::onKernelTerminate". [] []
[2015-07-02 08:24:06] event.DEBUG: Notified event "kernel.response" to listener "Symfony'Component'HttpKernel'EventListener'ResponseListener::onKernelResponse". [] []
[2015-07-02 08:24:06] event.DEBUG: Notified event "kernel.response" to listener "Symfony'Component'Security'Http'RememberMe'ResponseListener::onKernelResponse". [] []
[2015-07-02 08:24:06] event.DEBUG: Notified event "kernel.response" to listener "Sensio'Bundle'FrameworkExtraBundle'EventListener'HttpCacheListener::onKernelResponse". [] []
[2015-07-02 08:24:06] event.DEBUG: Notified event "kernel.response" to listener "Symfony'Component'HttpKernel'EventListener'ProfilerListener::onKernelResponse". [] []
[2015-07-02 08:24:06] event.DEBUG: Notified event "kernel.response" to listener "Symfony'Bundle'WebProfilerBundle'EventListener'WebDebugToolbarListener::onKernelResponse". [] []
[2015-07-02 08:24:06] event.DEBUG: Notified event "kernel.response" to listener "Symfony'Component'HttpKernel'EventListener'SaveSessionListener::onKernelResponse". [] []
[2015-07-02 08:24:06] event.DEBUG: Notified event "kernel.response" to listener "Symfony'Component'HttpKernel'EventListener'StreamedResponseListener::onKernelResponse". [] []
[2015-07-02 08:24:06] event.DEBUG: Notified event "kernel.finish_request" to listener "Symfony'Component'HttpKernel'EventListener'LocaleListener::onKernelFinishRequest". [] []
[2015-07-02 08:24:06] event.DEBUG: Notified event "kernel.finish_request" to listener "Symfony'Component'HttpKernel'EventListener'RouterListener::onKernelFinishRequest". [] []
[2015-07-02 08:24:06] event.DEBUG: Notified event "kernel.finish_request" to listener "Symfony'Component'Security'Http'Firewall::onKernelFinishRequest". [] []
[2015-07-02 08:24:06] event.DEBUG: Notified event "kernel.response" to listener "Symfony'Component'HttpKernel'EventListener'ResponseListener::onKernelResponse". [] []
[2015-07-02 08:24:06] event.DEBUG: Notified event "kernel.response" to listener "Symfony'Component'Security'Http'RememberMe'ResponseListener::onKernelResponse". [] []
[2015-07-02 08:24:06] event.DEBUG: Notified event "kernel.response" to listener "Sensio'Bundle'FrameworkExtraBundle'EventListener'HttpCacheListener::onKernelResponse". [] []
[2015-07-02 08:24:06] event.DEBUG: Notified event "kernel.response" to listener "Symfony'Component'HttpKernel'EventListener'ProfilerListener::onKernelResponse". [] []
[2015-07-02 08:24:06] event.DEBUG: Notified event "kernel.response" to listener "Symfony'Bundle'WebProfilerBundle'EventListener'WebDebugToolbarListener::onKernelResponse". [] []
[2015-07-02 08:24:06] event.DEBUG: Notified event "kernel.terminate" to listener "Symfony'Bundle'SwiftmailerBundle'EventListener'EmailSenderListener::onTerminate". [] []
[2015-07-02 08:24:06] event.DEBUG: Notified event "kernel.response" to listener "Symfony'Component'HttpKernel'EventListener'SaveSessionListener::onKernelResponse". [] []
[2015-07-02 08:24:06] event.DEBUG: Notified event "kernel.terminate" to listener "Symfony'Component'HttpKernel'EventListener'ProfilerListener::onKernelTerminate". [] []
[2015-07-02 08:24:06] event.DEBUG: Notified event "kernel.response" to listener "Symfony'Component'HttpKernel'EventListener'StreamedResponseListener::onKernelResponse". [] []
[2015-07-02 08:24:06] event.DEBUG: Notified event "kernel.finish_request" to listener "Symfony'Component'HttpKernel'EventListener'LocaleListener::onKernelFinishRequest". [] []
[2015-07-02 08:24:06] event.DEBUG: Notified event "kernel.finish_request" to listener "Symfony'Component'HttpKernel'EventListener'RouterListener::onKernelFinishRequest". [] []
[2015-07-02 08:24:06] event.DEBUG: Notified event "kernel.finish_request" to listener "Symfony'Component'Security'Http'Firewall::onKernelFinishRequest". [] []
[2015-07-02 08:24:06] event.DEBUG: Notified event "kernel.terminate" to listener "Symfony'Bundle'SwiftmailerBundle'EventListener'EmailSenderListener::onTerminate". [] []
[2015-07-02 08:24:06] event.DEBUG: Notified event "kernel.terminate" to listener "Symfony'Component'HttpKernel'EventListener'ProfilerListener::onKernelTerminate". [] []
[2015-07-02 08:24:06] event.DEBUG: Notified event "kernel.response" to listener "Symfony'Component'HttpKernel'EventListener'ResponseListener::onKernelResponse". [] []
[2015-07-02 08:24:06] event.DEBUG: Notified event "kernel.response" to listener "Symfony'Component'Security'Http'RememberMe'ResponseListener::onKernelResponse". [] []
[2015-07-02 08:24:06] event.DEBUG: Notified event "kernel.response" to listener "Sensio'Bundle'FrameworkExtraBundle'EventListener'HttpCacheListener::onKernelResponse". [] []
[2015-07-02 08:24:06] event.DEBUG: Notified event "kernel.response" to listener "Symfony'Component'HttpKernel'EventListener'ProfilerListener::onKernelResponse". [] []
[2015-07-02 08:24:06] event.DEBUG: Notified event "kernel.response" to listener "Symfony'Bundle'WebProfilerBundle'EventListener'WebDebugToolbarListener::onKernelResponse". [] []
[2015-07-02 08:24:06] event.DEBUG: Notified event "kernel.response" to listener "Symfony'Component'HttpKernel'EventListener'SaveSessionListener::onKernelResponse". [] []
[2015-07-02 08:24:06] event.DEBUG: Notified event "kernel.response" to listener "Symfony'Component'HttpKernel'EventListener'StreamedResponseListener::onKernelResponse". [] []
[2015-07-02 08:24:06] event.DEBUG: Notified event "kernel.finish_request" to listener "Symfony'Component'HttpKernel'EventListener'LocaleListener::onKernelFinishRequest". [] []
[2015-07-02 08:24:06] event.DEBUG: Notified event "kernel.finish_request" to listener "Symfony'Component'HttpKernel'EventListener'RouterListener::onKernelFinishRequest". [] []
[2015-07-02 08:24:06] event.DEBUG: Notified event "kernel.finish_request" to listener "Symfony'Component'Security'Http'Firewall::onKernelFinishRequest". [] []
[2015-07-02 08:24:06] event.DEBUG: Notified event "kernel.terminate" to listener "Symfony'Bundle'SwiftmailerBundle'EventListener'EmailSenderListener::onTerminate". [] []
[2015-07-02 08:24:06] event.DEBUG: Notified event "kernel.terminate" to listener "Symfony'Component'HttpKernel'EventListener'ProfilerListener::onKernelTerminate". [] []
[2015-07-02 08:24:06] request.INFO: Matched route "_wdt" (parameters: "_controller": "web_profiler.controller.profiler:toolbarAction", "token": "d950df", "_route": "_wdt") [] []
[2015-07-02 08:24:06] event.DEBUG: Notified event "kernel.request" to listener "Symfony'Component'HttpKernel'EventListener'ErrorsLoggerListener::injectLogger". [] []
[2015-07-02 08:24:06] event.DEBUG: Notified event "kernel.request" to listener "Symfony'Component'HttpKernel'EventListener'ErrorsLoggerListener::injectLogger". [] []
[2015-07-02 08:24:06] event.DEBUG: Notified event "kernel.request" to listener "Symfony'Component'HttpKernel'EventListener'ErrorsLoggerListener::injectLogger". [] []
[2015-07-02 08:24:06] event.DEBUG: Notified event "kernel.request" to listener "Symfony'Component'HttpKernel'EventListener'DebugHandlersListener::configure". [] []
[2015-07-02 08:24:06] event.DEBUG: Notified event "kernel.request" to listener "Symfony'Component'HttpKernel'EventListener'ProfilerListener::onKernelRequest". [] []
[2015-07-02 08:24:06] event.DEBUG: Notified event "kernel.request" to listener "Symfony'Bundle'FrameworkBundle'EventListener'SessionListener::onKernelRequest". [] []
[2015-07-02 08:24:06] event.DEBUG: Notified event "kernel.request" to listener "Symfony'Component'HttpKernel'EventListener'FragmentListener::onKernelRequest". [] []
[2015-07-02 08:24:06] event.DEBUG: Notified event "kernel.request" to listener "Symfony'Component'HttpKernel'EventListener'RouterListener::onKernelRequest". [] []
[2015-07-02 08:24:06] event.DEBUG: Notified event "kernel.request" to listener "Symfony'Component'HttpKernel'EventListener'LocaleListener::onKernelRequest". [] []
[2015-07-02 08:24:06] event.DEBUG: Notified event "kernel.request" to listener "Symfony'Component'Security'Http'Firewall::onKernelRequest". [] []
[2015-07-02 08:24:06] event.DEBUG: Notified event "kernel.request" to listener "Symfony'Bundle'AsseticBundle'EventListener'RequestListener::onKernelRequest". [] []
[2015-07-02 08:24:06] event.DEBUG: Notified event "kernel.controller" to listener "Symfony'Bundle'FrameworkBundle'DataCollector'RouterDataCollector::onKernelController". [] []
[2015-07-02 08:24:06] event.DEBUG: Notified event "kernel.controller" to listener "Symfony'Component'HttpKernel'DataCollector'RequestDataCollector::onKernelController". [] []
[2015-07-02 08:24:06] event.DEBUG: Notified event "kernel.controller" to listener "Sensio'Bundle'FrameworkExtraBundle'EventListener'ControllerListener::onKernelController". [] []
[2015-07-02 08:24:06] event.DEBUG: Notified event "kernel.controller" to listener "Sensio'Bundle'FrameworkExtraBundle'EventListener'ParamConverterListener::onKernelController". [] []
[2015-07-02 08:24:06] event.DEBUG: Notified event "kernel.controller" to listener "Sensio'Bundle'FrameworkExtraBundle'EventListener'HttpCacheListener::onKernelController". [] []
[2015-07-02 08:24:06] event.DEBUG: Notified event "kernel.controller" to listener "Sensio'Bundle'FrameworkExtraBundle'EventListener'SecurityListener::onKernelController". [] []
[2015-07-02 08:24:06] event.DEBUG: Notified event "kernel.controller" to listener "Sensio'Bundle'FrameworkExtraBundle'EventListener'TemplateListener::onKernelController". [] []
[2015-07-02 08:24:06] event.DEBUG: Notified event "kernel.response" to listener "Symfony'Component'HttpKernel'EventListener'ResponseListener::onKernelResponse". [] []
[2015-07-02 08:24:06] event.DEBUG: Notified event "kernel.response" to listener "Symfony'Component'Security'Http'RememberMe'ResponseListener::onKernelResponse". [] []
[2015-07-02 08:24:06] event.DEBUG: Notified event "kernel.response" to listener "Sensio'Bundle'FrameworkExtraBundle'EventListener'HttpCacheListener::onKernelResponse". [] []
[2015-07-02 08:24:06] event.DEBUG: Notified event "kernel.response" to listener "Symfony'Component'HttpKernel'EventListener'ProfilerListener::onKernelResponse". [] []
[2015-07-02 08:24:06] event.DEBUG: Notified event "kernel.response" to listener "Symfony'Bundle'WebProfilerBundle'EventListener'WebDebugToolbarListener::onKernelResponse". [] []
[2015-07-02 08:24:06] event.DEBUG: Notified event "kernel.response" to listener "Symfony'Component'HttpKernel'EventListener'SaveSessionListener::onKernelResponse". [] []
[2015-07-02 08:24:06] event.DEBUG: Notified event "kernel.response" to listener "Symfony'Component'HttpKernel'EventListener'StreamedResponseListener::onKernelResponse". [] []
[2015-07-02 08:24:06] event.DEBUG: Notified event "kernel.finish_request" to listener "Symfony'Component'HttpKernel'EventListener'LocaleListener::onKernelFinishRequest". [] []
[2015-07-02 08:24:06] event.DEBUG: Notified event "kernel.finish_request" to listener "Symfony'Component'HttpKernel'EventListener'RouterListener::onKernelFinishRequest". [] []
[2015-07-02 08:24:06] event.DEBUG: Notified event "kernel.finish_request" to listener "Symfony'Component'Security'Http'Firewall::onKernelFinishRequest". [] []
[2015-07-02 08:24:06] event.DEBUG: Notified event "kernel.terminate" to listener "Symfony'Bundle'SwiftmailerBundle'EventListener'EmailSenderListener::onTerminate". [] []
[2015-07-02 08:24:06] event.DEBUG: Notified event "kernel.terminate" to listener "Symfony'Component'HttpKernel'EventListener'ProfilerListener::onKernelTerminate". [] []

你能告诉我我在做什么吗?谢谢

编辑:我尝试清除cookie并再次运行应用程序,在日志中发现了这一点:

[2015-07-03 04:27:34] request.INFO: Matched route "fos_user_security_check" (parameters: "_controller": "FOS'UserBundle'Controller'SecurityController::checkAction", "_route": "fos_user_security_check") [] []
[2015-07-03 04:27:34] doctrine.DEBUG: SELECT t0.username AS username1, t0.username_canonical AS username_canonical2, t0.email AS email3, t0.email_canonical AS email_canonical4, t0.enabled AS enabled5, t0.salt AS salt6, t0.password AS password7, t0.last_login AS last_login8, t0.locked AS locked9, t0.expired AS expired10, t0.expires_at AS expires_at11, t0.confirmation_token AS confirmation_token12, t0.password_requested_at AS password_requested_at13, t0.roles AS roles14, t0.credentials_expired AS credentials_expired15, t0.credentials_expire_at AS credentials_expire_at16, t0.ediUserId AS ediUserId17 FROM edi_user t0 WHERE t0.username_canonical = ? LIMIT 1 ["erosales"] []
[2015-07-03 04:27:34] security.INFO: Authentication request failed: An exception occurred while executing 'SELECT t0.username AS username1, t0.username_canonical AS username_canonical2, t0.email AS email3, t0.email_canonical AS email_canonical4, t0.enabled AS enabled5, t0.salt AS salt6, t0.password AS password7, t0.last_login AS last_login8, t0.locked AS locked9, t0.expired AS expired10, t0.expires_at AS expires_at11, t0.confirmation_token AS confirmation_token12, t0.password_requested_at AS password_requested_at13, t0.roles AS roles14, t0.credentials_expired AS credentials_expired15, t0.credentials_expire_at AS credentials_expire_at16, t0.ediUserId AS ediUserId17 FROM edi_user t0 WHERE t0.username_canonical = ? LIMIT 1' with params ["erosales"]: SQLSTATE[42S22]: Column not found: 1054 Unknown column 't0.ediUserId' in 'field list' [] []
[2015-07-03 04:27:34] security.DEBUG: Redirecting to /login [] []

我已经花了几个小时试图解决这个问题,但仍然做不到。我希望有人能帮我。谢谢

您的报表

一切都很好,直到我们更改了数据库

未知列"t0.ediUserId"

可能指向数据库中缺少的未执行的迁移。查看"migrations_version"表并进行比较。当然,只有在使用迁移捆绑包的情况下才会出现这种情况。

另一件事可能是ediUserId中的拼写错误。