Cannot Sign Into EVE-NG Website

[bhjones0217]

I am running 5.0.1-144-PRO in a cluster with 1 Master and 2 Sat. This morning I cannot sign in. When I click "Sign In", nothing happens.

Tried on Firefox and Chrome.
Clear cookies and cache.
Restart the browser.
Restart the Server.

I can log into the master server and the Sats just fine via SSH.

I did a '/opt/unetlab/wrappers/unl_wrapper -a fixpermissions'

Cluster appears to be online from the 'unl_wrapper -a showcluster'

Cluster Status:
############################################
0 master Online ( Local )
1 Sat1 Online
2 Sat2 Online
############################################

Apache appears to be running from the 'eve-info' command.

--------------Apache-----------------------------
● apache2.service - The Apache HTTP Server
Loaded: loaded (/lib/systemd/system/apache2.service; enabled; vendor preset: enabled)
Active: active (running) since Wed 2024-06-12 08:27:48 MST; 25min ago

[mikepell]

Glad I found this as I am experiencing the same exact issue.

This started after installing updates:

Start-Date: 2024-06-11 20:12:35
Commandline: apt upgrade
Upgrade: mysql-server-8.0:amd64 (8.0.36-0ubuntu0.22.04.1, 8.0.37-0ubuntu0.22.04.3), mysql-client-8.0:amd64 (8.0.36-0ubuntu0.22.04.1, 8.0.37-0ubuntu0.22.04.3), libgif7:amd64 (5.1.9-2build2, 5.1.9-2ubuntu0.1), libtiff5:amd64 (4.3.0-6ubuntu0.8, 4.3.0-6ubuntu0.9), libmysqlclient21:amd64 (8.0.36-0ubuntu0.22.04.1, 8.0.37-0ubuntu0.22.04.3), mysql-server:amd64 (8.0.36-0ubuntu0.22.04.1, 8.0.37-0ubuntu0.22.04.3), mysql-server-core-8.0:amd64 (8.0.36-0ubuntu0.22.04.1, 8.0.37-0ubuntu0.22.04.3), mysql-client-core-8.0:amd64 (8.0.36-0ubuntu0.22.04.1, 8.0.37-0ubuntu0.22.04.3)
End-Date: 2024-06-11 20:13:47

[bhjones0217]

I haven't done any upgrades recently but I am running the same version of mysql.

mysql-client-8.0/focal-updates,focal-security,now 8.0.37-0ubuntu0.20.04.3 amd64 [installed,automatic]
mysql-client-core-8.0/focal-updates,focal-security,now 8.0.37-0ubuntu0.20.04.3 amd64 [installed,automatic]
mysql-client/focal-updates,focal-security 8.0.37-0ubuntu0.20.04.3 all
mysql-common/focal,now 5.8+1.0.5ubuntu2 all [installed,automatic]
mysql-router/focal-updates,focal-security 8.0.37-0ubuntu0.20.04.3 amd64
mysql-sandbox/focal 3.2.05-1 all
mysql-server-8.0/focal-updates,focal-security,now 8.0.37-0ubuntu0.20.04.3 amd64 [installed,automatic]
mysql-server-core-8.0/focal-updates,focal-security,now 8.0.37-0ubuntu0.20.04.3 amd64 [installed,automatic]
mysql-server/focal-updates,focal-security,now 8.0.37-0ubuntu0.20.04.3 all [installed,automatic]
mysql-source-8.0/focal-updates,focal-security 8.0.37-0ubuntu0.20.04.3 amd64
mysql-testsuite-8.0/focal-updates,focal-security 8.0.37-0ubuntu0.20.04.3 amd64
mysql-testsuite/focal-updates,focal-security 8.0.37-0ubuntu0.20.04.3 all

[rusty725]

come to our chat https://webchat.eve-ng.net and give me anydesk.

[mikepell]

After playing around with this, restoring backups, installing updates (including mysql), based on the error in /var/log/mysql/error.log, I dumped the databases and reimported.

This seems to have fixed it for me. YMMV so take all precautions.


mysqldump -u root -p --opt --all-databases --skip-lock-tables > alldb.sql
mysql -u root -p < alldb.sql

[bhjones0217]

Yes, Helpdesk connected via Anydesk and worked through the issue which was related to mysql. I am back in now. Thanks all.