Issue:
Unable to login via HTML5 console on EVE-NG's Web GUI after upgrade to EVE-NG 2.0.3-86 or when in HTML5 console, disconnect button gets you into a guacamole login page and can’t get any sessions in HTML5.
Solution:
This is a typical corrupt Guacamole SQL database issue; whether happened randomly or even during/after eve upgrade process, there are two very simple proposed solutions for this problem:
Rana Tauqeer.
Unable to login via HTML5 console on EVE-NG's Web GUI after upgrade to EVE-NG 2.0.3-86 or when in HTML5 console, disconnect button gets you into a guacamole login page and can’t get any sessions in HTML5.
Solution:
This is a typical corrupt Guacamole SQL database issue; whether happened randomly or even during/after eve upgrade process, there are two very simple proposed solutions for this problem:
- Logout/Login from/into eve to be able to open html console again.
or - Issue the following command on eve-ng vm:
#cat /opt/unetlab/schema/guacamole-update.sql | mysql -u root --password=eve-ng guacdb
and than login/logout from/into eve.
Rana Tauqeer.
this isn't working for me. I only get an error about a duplicate username column
ReplyDeleteI have the same issue with duplicate username. Are you fix it ?
DeleteI had the same issue, noticed numerous columns were missing from tables and an entire table was missing.
ReplyDeleteLook at catalina.out, you might see something like this:
10:56:02.164 [http-nio-127.0.0.1-8080-exec-7] ERROR o.a.g.rest.RESTExceptionWrapper - Unexpected internal error:
### Error querying database. Cause: com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException: Table 'guacdb.guacamole_user_history' doesn't exist
### The error may exist in org/apache/guacamole/auth/jdbc/user/UserMapper.xml
### The error may involve defaultParameterMap
### The error occurred while setting parameters
### SQL: SELECT guacamole_user.user_id, guacamole_user.username, password_hash, password_salt, password_date, disabled, expired, access_window_start, access_window_end, valid_from, valid_until, timezone, full_name, email_address, organization, organizational_role, MAX(start_date) AS last_active FROM guacamole_user LEFT JOIN guacamole_user_history ON guacamole_user_history.user_id = guacamole_user.user_id WHERE guacamole_user.username = ? GROUP BY guacamole_user.user_id
### Cause: com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException: Table 'guacdb.guacamole_user_history' doesn't exist
I fixed it by altering the guac database and adding the missing table, as well as a number of missing columns in different tables. That fixed it for me
Here's what I changed if it helps
https://pastebin.com/8wZecrrX
Thanks, now it is working.
DeleteCan confirm, this worked for me. To add the extra steps for those not mysql literate like me:
DeleteGet an SSH shell open to your EVE machine, logged in as root.
#mysql -u root -p
Enter eve-ng as the password at the prompt.
mysql> use guacdb;
Follow on with the steps in Scott's pastebin link. There are a few steps duplicated; this will throw and error but won't hurt.
Brilliant! Thanks James and Scott. WOrked for me. NOw able to login to HTML5
ReplyDeletedear friends its not working for me. EVE-NG kindly help me.
ReplyDeleteHello
ReplyDeleteMy laptop sudden shut down while my EVE-NG and vmware were running . Then when I start the laptop and again try to Run EVE-NG .EVE-NG stuck at web log in .I put correct user name and password and hit enter but nothing is happening by pressing enter.
then i try
/opt/unetlab/wrappers/unl_wrapper -a restoredb
but it show me like that
root@eve-ng:~/opt/unetlab/wrappers/unl_wrapper -a restoredb
Usage: /opt/unetlab/wrappers/unl_wrapper -a
-a Action can be:
- delete: delete a lab file even if it's not valid
requires -T, -F
- export: export a runnign-config to a file
requires -T, -F, -D is optional
- fixpermissions: fix file/dir permissions
- platform: print the hardware platform
- start: start one or all nodes
requires -T, -F, -D is optional
- stop: stop one or all nodes
requires -T, -F, -D is optional
- wipe: wipe one or all nodes
requires -T, -F, -D is optional
Options:
-F Lab file
-T Tenant ID
-D Device ID (if not used, all devices will be impacted)
Sep 06 17:29:05 Sep 06 17:29:05 ERROR: Flag -a is not valid (9).
any body plz help.
same problem, did u find any solution plz !
DeleteHello wajib,
Deletei m facing the same issue ,please share the solution if u had found..thanks
i am unable to login on eve-ng. what should i do?
ReplyDeleteI am not able to login my community eve-ng on my bare metal server via http, but i am able to login via SSH. any idea?
ReplyDeleteI also have the same problem
DeleteThis fixed my issue:
ReplyDeleteecho "drop database guacdb ;" | mysql --password=eve-ng mysql ; apt install --reinstall eve-ng-pro-guacamole
That didn't work for me:
ReplyDeleteroot@eve-ng:~# echo "drop database guacdb ;" | mysql --password=eve-ng mysql ; apt install --reinstall eve-ng-pro-guacamole
mysql: [Warning] Using a password on the command line interface can be insecure.
Reading package lists... Done
Building dependency tree
Reading state information... Done
Reinstallation of eve-ng-pro-guacamole is not possible, it cannot be downloaded.
0 upgraded, 0 newly installed, 0 to remove and 0 not upgraded.
root@eve-ng:~#
Unable To Login Via Html5 Console On Eve-Ng ~ Rana Tauqeer'S Notebook >>>>> Download Now
ReplyDelete>>>>> Download Full
Unable To Login Via Html5 Console On Eve-Ng ~ Rana Tauqeer'S Notebook >>>>> Download LINK
>>>>> Download Now
Unable To Login Via Html5 Console On Eve-Ng ~ Rana Tauqeer'S Notebook >>>>> Download Full
>>>>> Download LINK