php - Unable to Login with Symfony -


i'm doing project symfony version = '2.5.10'. everything's working fine until changed our database , update entities. tried different ways yet still can't log in system. whenever run on either prod or dev environment, gives me error:

authentication request not processed due system problem

i tried clearing cache manually or through command prompt, tried running these commands:

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

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

and tried creating new user using this:

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

and saved in database.

here's log file:

[2015-07-02 08:24:06] event.debug: notified event "kernel.response" listener "symfony\component\httpkernel\eventlistener\responselistener::onkernelresponse". [] [] [2015-07-02 08:24:06] event.debug: notified event "kernel.response" listener "symfony\component\security\http\rememberme\responselistener::onkernelresponse". [] [] [2015-07-02 08:24:06] event.debug: notified event "kernel.response" listener "sensio\bundle\frameworkextrabundle\eventlistener\httpcachelistener::onkernelresponse". [] [] [2015-07-02 08:24:06] event.debug: notified event "kernel.response" listener "symfony\component\httpkernel\eventlistener\profilerlistener::onkernelresponse". [] [] [2015-07-02 08:24:06] event.debug: notified event "kernel.response" listener "symfony\bundle\webprofilerbundle\eventlistener\webdebugtoolbarlistener::onkernelresponse". [] [] [2015-07-02 08:24:06] event.debug: notified event "kernel.response" listener "symfony\component\httpkernel\eventlistener\savesessionlistener::onkernelresponse". [] [] [2015-07-02 08:24:06] event.debug: notified event "kernel.response" listener "symfony\component\httpkernel\eventlistener\streamedresponselistener::onkernelresponse". [] [] [2015-07-02 08:24:06] event.debug: notified event "kernel.finish_request" listener "symfony\component\httpkernel\eventlistener\localelistener::onkernelfinishrequest". [] [] [2015-07-02 08:24:06] event.debug: notified event "kernel.finish_request" listener "symfony\component\httpkernel\eventlistener\routerlistener::onkernelfinishrequest". [] [] [2015-07-02 08:24:06] event.debug: notified event "kernel.finish_request" listener "symfony\component\security\http\firewall::onkernelfinishrequest". [] [] [2015-07-02 08:24:06] event.debug: notified event "kernel.terminate" listener "symfony\bundle\swiftmailerbundle\eventlistener\emailsenderlistener::onterminate". [] [] [2015-07-02 08:24:06] event.debug: notified event "kernel.terminate" listener "symfony\component\httpkernel\eventlistener\profilerlistener::onkernelterminate". [] [] [2015-07-02 08:24:06] event.debug: notified event "kernel.response" listener "symfony\component\httpkernel\eventlistener\responselistener::onkernelresponse". [] [] [2015-07-02 08:24:06] event.debug: notified event "kernel.response" listener "symfony\component\security\http\rememberme\responselistener::onkernelresponse". [] [] [2015-07-02 08:24:06] event.debug: notified event "kernel.response" listener "sensio\bundle\frameworkextrabundle\eventlistener\httpcachelistener::onkernelresponse". [] [] [2015-07-02 08:24:06] event.debug: notified event "kernel.response" listener "symfony\component\httpkernel\eventlistener\profilerlistener::onkernelresponse". [] [] [2015-07-02 08:24:06] event.debug: notified event "kernel.response" listener "symfony\bundle\webprofilerbundle\eventlistener\webdebugtoolbarlistener::onkernelresponse". [] [] [2015-07-02 08:24:06] event.debug: notified event "kernel.response" listener "symfony\component\httpkernel\eventlistener\savesessionlistener::onkernelresponse". [] [] [2015-07-02 08:24:06] event.debug: notified event "kernel.response" listener "symfony\component\httpkernel\eventlistener\streamedresponselistener::onkernelresponse". [] [] [2015-07-02 08:24:06] event.debug: notified event "kernel.finish_request" listener "symfony\component\httpkernel\eventlistener\localelistener::onkernelfinishrequest". [] [] [2015-07-02 08:24:06] event.debug: notified event "kernel.finish_request" listener "symfony\component\httpkernel\eventlistener\routerlistener::onkernelfinishrequest". [] [] [2015-07-02 08:24:06] event.debug: notified event "kernel.finish_request" listener "symfony\component\security\http\firewall::onkernelfinishrequest". [] [] [2015-07-02 08:24:06] event.debug: notified event "kernel.response" listener "symfony\component\httpkernel\eventlistener\responselistener::onkernelresponse". [] [] [2015-07-02 08:24:06] event.debug: notified event "kernel.response" listener "symfony\component\security\http\rememberme\responselistener::onkernelresponse". [] [] [2015-07-02 08:24:06] event.debug: notified event "kernel.response" listener "sensio\bundle\frameworkextrabundle\eventlistener\httpcachelistener::onkernelresponse". [] [] [2015-07-02 08:24:06] event.debug: notified event "kernel.response" listener "symfony\component\httpkernel\eventlistener\profilerlistener::onkernelresponse". [] [] [2015-07-02 08:24:06] event.debug: notified event "kernel.response" listener "symfony\bundle\webprofilerbundle\eventlistener\webdebugtoolbarlistener::onkernelresponse". [] [] [2015-07-02 08:24:06] event.debug: notified event "kernel.terminate" listener "symfony\bundle\swiftmailerbundle\eventlistener\emailsenderlistener::onterminate". [] [] [2015-07-02 08:24:06] event.debug: notified event "kernel.response" listener "symfony\component\httpkernel\eventlistener\savesessionlistener::onkernelresponse". [] [] [2015-07-02 08:24:06] event.debug: notified event "kernel.terminate" listener "symfony\component\httpkernel\eventlistener\profilerlistener::onkernelterminate". [] [] [2015-07-02 08:24:06] event.debug: notified event "kernel.response" listener "symfony\component\httpkernel\eventlistener\streamedresponselistener::onkernelresponse". [] [] [2015-07-02 08:24:06] event.debug: notified event "kernel.finish_request" listener "symfony\component\httpkernel\eventlistener\localelistener::onkernelfinishrequest". [] [] [2015-07-02 08:24:06] event.debug: notified event "kernel.finish_request" listener "symfony\component\httpkernel\eventlistener\routerlistener::onkernelfinishrequest". [] [] [2015-07-02 08:24:06] event.debug: notified event "kernel.finish_request" listener "symfony\component\security\http\firewall::onkernelfinishrequest". [] [] [2015-07-02 08:24:06] event.debug: notified event "kernel.terminate" listener "symfony\bundle\swiftmailerbundle\eventlistener\emailsenderlistener::onterminate". [] [] [2015-07-02 08:24:06] event.debug: notified event "kernel.terminate" listener "symfony\component\httpkernel\eventlistener\profilerlistener::onkernelterminate". [] [] [2015-07-02 08:24:06] event.debug: notified event "kernel.response" listener "symfony\component\httpkernel\eventlistener\responselistener::onkernelresponse". [] [] [2015-07-02 08:24:06] event.debug: notified event "kernel.response" listener "symfony\component\security\http\rememberme\responselistener::onkernelresponse". [] [] [2015-07-02 08:24:06] event.debug: notified event "kernel.response" listener "sensio\bundle\frameworkextrabundle\eventlistener\httpcachelistener::onkernelresponse". [] [] [2015-07-02 08:24:06] event.debug: notified event "kernel.response" listener "symfony\component\httpkernel\eventlistener\profilerlistener::onkernelresponse". [] [] [2015-07-02 08:24:06] event.debug: notified event "kernel.response" listener "symfony\bundle\webprofilerbundle\eventlistener\webdebugtoolbarlistener::onkernelresponse". [] [] [2015-07-02 08:24:06] event.debug: notified event "kernel.response" listener "symfony\component\httpkernel\eventlistener\savesessionlistener::onkernelresponse". [] [] [2015-07-02 08:24:06] event.debug: notified event "kernel.response" listener "symfony\component\httpkernel\eventlistener\streamedresponselistener::onkernelresponse". [] [] [2015-07-02 08:24:06] event.debug: notified event "kernel.finish_request" listener "symfony\component\httpkernel\eventlistener\localelistener::onkernelfinishrequest". [] [] [2015-07-02 08:24:06] event.debug: notified event "kernel.finish_request" listener "symfony\component\httpkernel\eventlistener\routerlistener::onkernelfinishrequest". [] [] [2015-07-02 08:24:06] event.debug: notified event "kernel.finish_request" listener "symfony\component\security\http\firewall::onkernelfinishrequest". [] [] [2015-07-02 08:24:06] event.debug: notified event "kernel.terminate" listener "symfony\bundle\swiftmailerbundle\eventlistener\emailsenderlistener::onterminate". [] [] [2015-07-02 08:24:06] event.debug: notified event "kernel.terminate" 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" listener "symfony\component\httpkernel\eventlistener\errorsloggerlistener::injectlogger". [] [] [2015-07-02 08:24:06] event.debug: notified event "kernel.request" listener "symfony\component\httpkernel\eventlistener\errorsloggerlistener::injectlogger". [] [] [2015-07-02 08:24:06] event.debug: notified event "kernel.request" listener "symfony\component\httpkernel\eventlistener\errorsloggerlistener::injectlogger". [] [] [2015-07-02 08:24:06] event.debug: notified event "kernel.request" listener "symfony\component\httpkernel\eventlistener\debughandlerslistener::configure". [] [] [2015-07-02 08:24:06] event.debug: notified event "kernel.request" listener "symfony\component\httpkernel\eventlistener\profilerlistener::onkernelrequest". [] [] [2015-07-02 08:24:06] event.debug: notified event "kernel.request" listener "symfony\bundle\frameworkbundle\eventlistener\sessionlistener::onkernelrequest". [] [] [2015-07-02 08:24:06] event.debug: notified event "kernel.request" listener "symfony\component\httpkernel\eventlistener\fragmentlistener::onkernelrequest". [] [] [2015-07-02 08:24:06] event.debug: notified event "kernel.request" listener "symfony\component\httpkernel\eventlistener\routerlistener::onkernelrequest". [] [] [2015-07-02 08:24:06] event.debug: notified event "kernel.request" listener "symfony\component\httpkernel\eventlistener\localelistener::onkernelrequest". [] [] [2015-07-02 08:24:06] event.debug: notified event "kernel.request" listener "symfony\component\security\http\firewall::onkernelrequest". [] [] [2015-07-02 08:24:06] event.debug: notified event "kernel.request" listener "symfony\bundle\asseticbundle\eventlistener\requestlistener::onkernelrequest". [] [] [2015-07-02 08:24:06] event.debug: notified event "kernel.controller" listener "symfony\bundle\frameworkbundle\datacollector\routerdatacollector::onkernelcontroller". [] [] [2015-07-02 08:24:06] event.debug: notified event "kernel.controller" listener "symfony\component\httpkernel\datacollector\requestdatacollector::onkernelcontroller". [] [] [2015-07-02 08:24:06] event.debug: notified event "kernel.controller" listener "sensio\bundle\frameworkextrabundle\eventlistener\controllerlistener::onkernelcontroller". [] [] [2015-07-02 08:24:06] event.debug: notified event "kernel.controller" listener "sensio\bundle\frameworkextrabundle\eventlistener\paramconverterlistener::onkernelcontroller". [] [] [2015-07-02 08:24:06] event.debug: notified event "kernel.controller" listener "sensio\bundle\frameworkextrabundle\eventlistener\httpcachelistener::onkernelcontroller". [] [] [2015-07-02 08:24:06] event.debug: notified event "kernel.controller" listener "sensio\bundle\frameworkextrabundle\eventlistener\securitylistener::onkernelcontroller". [] [] [2015-07-02 08:24:06] event.debug: notified event "kernel.controller" listener "sensio\bundle\frameworkextrabundle\eventlistener\templatelistener::onkernelcontroller". [] [] [2015-07-02 08:24:06] event.debug: notified event "kernel.response" listener "symfony\component\httpkernel\eventlistener\responselistener::onkernelresponse". [] [] [2015-07-02 08:24:06] event.debug: notified event "kernel.response" listener "symfony\component\security\http\rememberme\responselistener::onkernelresponse". [] [] [2015-07-02 08:24:06] event.debug: notified event "kernel.response" listener "sensio\bundle\frameworkextrabundle\eventlistener\httpcachelistener::onkernelresponse". [] [] [2015-07-02 08:24:06] event.debug: notified event "kernel.response" listener "symfony\component\httpkernel\eventlistener\profilerlistener::onkernelresponse". [] [] [2015-07-02 08:24:06] event.debug: notified event "kernel.response" listener "symfony\bundle\webprofilerbundle\eventlistener\webdebugtoolbarlistener::onkernelresponse". [] [] [2015-07-02 08:24:06] event.debug: notified event "kernel.response" listener "symfony\component\httpkernel\eventlistener\savesessionlistener::onkernelresponse". [] [] [2015-07-02 08:24:06] event.debug: notified event "kernel.response" listener "symfony\component\httpkernel\eventlistener\streamedresponselistener::onkernelresponse". [] [] [2015-07-02 08:24:06] event.debug: notified event "kernel.finish_request" listener "symfony\component\httpkernel\eventlistener\localelistener::onkernelfinishrequest". [] [] [2015-07-02 08:24:06] event.debug: notified event "kernel.finish_request" listener "symfony\component\httpkernel\eventlistener\routerlistener::onkernelfinishrequest". [] [] [2015-07-02 08:24:06] event.debug: notified event "kernel.finish_request" listener "symfony\component\security\http\firewall::onkernelfinishrequest". [] [] [2015-07-02 08:24:06] event.debug: notified event "kernel.terminate" listener "symfony\bundle\swiftmailerbundle\eventlistener\emailsenderlistener::onterminate". [] [] [2015-07-02 08:24:06] event.debug: notified event "kernel.terminate" listener "symfony\component\httpkernel\eventlistener\profilerlistener::onkernelterminate". [] [] 

could please tell me what's wrong i'm doing? thanks.

edit: tried clearing cookies , run application again , found on logs:

[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 username1, t0.username_canonical username_canonical2, t0.email email3, t0.email_canonical email_canonical4, t0.enabled enabled5, t0.salt salt6, t0.password password7, t0.last_login last_login8, t0.locked locked9, t0.expired expired10, t0.expires_at expires_at11, t0.confirmation_token confirmation_token12, t0.password_requested_at password_requested_at13, t0.roles roles14, t0.credentials_expired credentials_expired15, t0.credentials_expire_at credentials_expire_at16, t0.ediuserid ediuserid17 edi_user t0 t0.username_canonical = ? limit 1 ["erosales"] [] [2015-07-03 04:27:34] security.info: authentication request failed: exception occurred while executing 'select t0.username username1, t0.username_canonical username_canonical2, t0.email email3, t0.email_canonical email_canonical4, t0.enabled enabled5, t0.salt salt6, t0.password password7, t0.last_login last_login8, t0.locked locked9, t0.expired expired10, t0.expires_at expires_at11, t0.confirmation_token confirmation_token12, t0.password_requested_at password_requested_at13, t0.roles roles14, t0.credentials_expired credentials_expired15, t0.credentials_expire_at credentials_expire_at16, t0.ediuserid ediuserid17 edi_user t0 t0.username_canonical = ? limit 1' params ["erosales"]: sqlstate[42s22]: column not found: 1054 unknown column 't0.ediuserid' in 'field list' [] [] [2015-07-03 04:27:34] security.debug: redirecting /login [] [] 

i rendered couple of hours trying fix still can't. hope can me. thanks

your statement

everything's working fine until changed our database

and

unknown column 't0.ediuserid'

may point not executed migration missing in db. have @ "migrations_version" table , compare. of course if using migrations bundle.

the other thing might typo in here ediuserid.


Comments

Popular posts from this blog

Android : Making Listview full screen -

javascript - Parse JSON from the body of the POST -

javascript - Chrome Extension: Interacting with iframe embedded within popup -