SOLVED - Can't login with HTML5 console
Posted: Sun Oct 22, 2017 12:24 pm
Hello everybody.
As the title describes I can not log in when selecting HTML5 console. When I try to log in, web front end gives no error as if I didn't click on login button at all. API log shows this error:
Here is the referred portion of the code from api_authentication.php file:
Browser: Chrome 62.0.3202.62 (Tried with IE, same error)
EVE-NG version: 2.0.3-84
As the title describes I can not log in when selecting HTML5 console. When I try to log in, web front end gives no error as if I didn't click on login button at all. API log shows this error:
Code: Select all
PDOException: SQLSTATE[42S22]: Column not found: 1054 Unknown column 'password_date' in 'field list' in /opt/unetlab/html/includes/api_authentication.php:108
Stack trace:
#0 /opt/unetlab/html/includes/api_authentication.php(108): PDOStatement->execute()
#1 /opt/unetlab/html/api.php(121): apiLogin(Object(PDO), Object(PDO), Array, 'f2b71ccc-b0f8-4...')
#2 [internal function]: {closure}()
#3 /opt/unetlab/html/includes/Slim/Route.php(468): call_user_func_array(Object(Closure), Array)
#4 /opt/unetlab/html/includes/Slim/Slim.php(1357): Slim\Route->dispatch()
#5 /opt/unetlab/html/includes/Slim/Middleware/Flash.php(85): Slim\Slim->call()
#6 /opt/unetlab/html/includes/Slim/Middleware/MethodOverride.php(92): Slim\Middleware\Flash->call()
#7 /opt/unetlab/html/includes/Slim/Middleware/PrettyExceptions.php(67): Slim\Middleware\MethodOverride->call()
#8 /opt/unetlab/html/includes/Slim/Slim.php(1302): Slim\Middleware\PrettyExceptions->call()
#9 /opt/unetlab/html/api.php(1339): Slim\Slim->run()
#10 {main}Code: Select all
106 $query = "replace into guacamole_user(user_id,username, password_hash, password_date ) values ( ".($pod+1000)." , '".$username."', UNHEX(SHA2('unl',256) ), '".date("Y-m-d H:i:s")."');";
107 $statement = $html5_db -> prepare($query);
108 $statement -> execute();EVE-NG version: 2.0.3-84