When I attempt to set up 2 factor authentication for a user,
- the secret code changes every time a failed code is put in which is odd. Usually that stays the same with most apps.
- It goes straight to “Whoops, looks like something went wrong.” when I do use a valid code.
Details: I use a program called winauth to handle most MFA codes in addition to my phone and it works great. (You never know when your phone is going to break). I’ve included some details from laravel log below about this issue.
[2017-12-17 06:34:38] production.ERROR: Illuminate\Database\QueryException [42S22] : /var/www/html/ninja/vendor/laravel/framework/src/Illuminate/Database/Connection.php [Line 770] => SQLSTATE[42S22]: Column not found: 1054 Unknown column ‘google_2fa_secret’ in ‘field list’ (SQL: update users set updated_at = 2017-12-17 06:34:38, google_2fa_secret = eyJpdiI6IkpKV2REWnNLbUtRSU4yYnZ4V2tsdHc9PSIsInZhbHVlIjoiSElsMXBxZWJpc05rSnhVd2xMSzNvbFhhOEVxcXJBR0JMOVpWZ3JJbkdKbz0iLCJtYWMiOiI4NWYxYjNiMGU1MjViODg0MzllYzMwZTg0YmN2RjYjk1Mzc4ZjNmOTkyMjVhZTBkYTRiNzFjYWY5In0= where id = 1) {“context”:“PHP”,“user_id”:1,“account_id”:1,“user_name”:“Mister Tester”,“method”:“POST”,“url”:“http://site.com/settings/enable_two_factor",“previous”:“http://site.com/settings/enable_two_factor”,“user_agent”:"Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/63.0.3239.84 Safari/537.36”,“ip”:“10.1.1.9”,“count”:17,“is_console”:“no”,“is_api”:“no”,“db_server”:“mysql”} []