After open the EVE - NG server today, the login page, found that can not login, doubt is the MySQL database, so please help to look at, thank you!
Below is relevant details:
Root @ Cisco_Lab: ~ # mysql - V
Mysql Ver 14.14 Distrib 5.7.21, for Linux (x86_64) using EditLine wrapper
Root @ Cisco_Lab: ~ # journalctl - xe
-- the Unit mysql. The service has finished shutting down.
Apr 18 01:58:57 Cisco_Lab systemd [1] : Starting MySQL Community Server...
Subject: Unit mysql. The service has begun the start - up
- Defined - By: systemd
- Support: http://lists.freedesktop.org/mailman/listinfo/systemd-devel
-
-- the Unit mysql. The service has begun starting up.
Apr 18 01:58:57 Cisco_Lab audit [19519] : AVC apparmor="DENIED" operation="open" profile="/usr/sbin/mysqld" name="/proc/19519/status" pid=19519 comm="mysql
Apr 18 01:58:57 Cisco_Lab audit [19519] : AVC apparmor="DENIED" operation="open" profile="/usr/sbin/mysqld" name="/sys/devices/system/node/" pid=19519 com
Apr 18 01:58:57 Cisco_Lab audit [19519] : AVC apparmor="DENIED" operation="open" profile="/usr/sbin/mysqld" name="/proc/19519/status" pid=19519 comm="mysql
Apr 18 01:58:57 Cisco_Lab kernel: audit: audit type=1400 (610) : 1587164337.399: apparmor="DENIED" operation="open" profile="/usr/sbin/mysqld" name="/proc/
Apr 18 01:58:57 Cisco_Lab kernel: audit: audit type=1400 (611) : 1587164337.399: apparmor="DENIED" operation="open" profile="/usr/sbin/mysqld" name="/sys/d
Apr 18 01:58:57 Cisco_Lab kernel: audit: audit type=1400 (612) : 1587164337.399: apparmor="DENIED" operation="open" profile="/usr/sbin/mysqld" name="/proc/
Apr 18 01:58:57 Cisco_Lab systemd [1] : mysql. Service: the Main process exited, code=exited, status=2/INVALIDARGUMENT
Apr 18 01:58:59 Cisco_Lab NTPD [3112] : the error resolving pool ubuntu.pool.ntp.org 3. : Temporary failure in the name resolution (3)
Apr 18 01:59:27 Cisco_Lab systemd [1] : Failed to start the MySQL Community Server.
Subject: Unit mysql. The service from the failed
- Defined - By: systemd
- Support: http://lists.freedesktop.org/mailman/listinfo/systemd-devel
-
-- the Unit mysql. The service has failed.
-
- The result is failed.
Apr 18 01:59:27 Cisco_Lab systemd [1] : mysql. Service: Unit rose failed state.
Apr 18 01:59:27 Cisco_Lab systemd [1] : mysql. Service: Failed with result 'exit - code.
Apr 18 01:59:27 Cisco_Lab systemd [1] : mysql. Service: service hold - off time is over, the scheduling restart.
Apr 18 01:59:27 Cisco_Lab systemd [1] : Stopped MySQL Community Server.
Subject: Unit mysql. The service has finished shutting down
- Defined - By: systemd
- Support: http://lists.freedesktop.org/mailman/listinfo/systemd-devel
-
-- the Unit mysql. The service has finished shutting down.
Apr 18 01:59:27 Cisco_Lab systemd [1] : Starting MySQL Community Server...
Subject: Unit mysql. The service has begun the start - up
- Defined - By: systemd
- Support: http://lists.freedesktop.org/mailman/listinfo/systemd-devel
-
-- the Unit mysql. The service has begun starting up.
Apr 18 01:59:27 Cisco_Lab audit [19712] : AVC apparmor="DENIED" operation="open" profile="/usr/sbin/mysqld" name="/proc/19712/status" pid=19712 comm="mysql
Apr 18 01:59:27 Cisco_Lab audit [19712] : AVC apparmor="DENIED" operation="open" profile="/usr/sbin/mysqld" name="/sys/devices/system/node/" pid=19712 com
Apr 18 01:59:27 Cisco_Lab audit [19712] : AVC apparmor="DENIED" operation="open" profile="/usr/sbin/mysqld" name="/proc/19712/status" pid=19712 comm="mysql
Apr 18 01:59:27 Cisco_Lab kernel: audit: audit type=1400 (613) : 1587164367.891: apparmor="DENIED" operation="open" profile="/usr/sbin/mysqld" name="/proc/
Apr 18 01:59:27 Cisco_Lab kernel: audit: audit type=1400 (614) : 1587164367.891: apparmor="DENIED" operation="open" profile="/usr/sbin/mysqld" name="/sys/d
Apr 18 01:59:27 Cisco_Lab kernel: audit: audit type=1400 (615) : 1587164367.891: apparmor="DENIED" operation="open" profile="/usr/sbin/mysqld" name="/proc/
Apr 18 01:59:28 Cisco_Lab systemd [1] : mysql. Service: the Main process exited, code=exited, status=2/INVALIDARGUMENT

Root @ Cisco_Lab: ~ #

CodePudding user response:

As local mysql service closed; Check your computer services try;

CodePudding user response:

reference 1st floor qq_18379499 response:

seems to be the local mysql service shut down; Check your computer services try;

Look at the mysql state, this is the mysql can't start,
The following is a state of mysql

 root @ Cisco_Lab: ~ # systemctl status mysql 
* the mysql service - mysql Community Server 
The Loaded: the Loaded (./lib/systemd/system/mysql service; Enabled. Vendor preset: enabled) 
Active: activating (start - post) (the Result: the exit - code) since Tue 2020-04-21 07:55:25 EEST; Line 8 s 
Process: 26609 ExecStart=/usr/sbin/mysqld (code=exited, status=2) 
Process: 26593 ExecStartPre=/usr/share/mysql/mysql - systemd - start the pre (code=exited, status=0/SUCCESS) 
The Main PID: 26609 (code=exited, status=2); : 26610 (mysql - systemd -s) 
Tasks: 2 
Memory: 3.1 M 
CPU: 334 ms 
nullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnull