Cannot access through the WEB

[skaZska]

Trying to access WEB, its doesn't work (no reaction)
After apt upgrade to 2.0.3.95 (current 2.0.3-92) i get these messages:

Code: Select all

root@eve-ng:~# apt upgrade
Reading package lists... Done
Building dependency tree
Reading state information... Done
Calculating upgrade... Done
The following packages were automatically installed and are no longer required:
  linux-headers-4.4.0-128 linux-headers-4.4.0-128-generic linux-image-4.4.0-128-generic
Use 'apt autoremove' to remove them.
The following packages will be upgraded:
  eve-ng
1 upgraded, 0 newly installed, 0 to remove and 0 not upgraded.
1 not fully installed or removed.
Need to get 0 B/18.5 MB of archives.
After this operation, 1,573 kB of additional disk space will be used.
Do you want to continue? [Y/n] y
(Reading database ... 120438 files and directories currently installed.)
Preparing to unpack .../eve-ng_2.0.3-95_amd64.deb ...
Checking MySQL... failed
dpkg: error processing archive /var/cache/apt/archives/eve-ng_2.0.3-95_amd64.deb (--unpack):
 subprocess new pre-installation script returned error exit status 1
Errors were encountered while processing:
 /var/cache/apt/archives/eve-ng_2.0.3-95_amd64.deb
E: Sub-process /usr/bin/dpkg returned an error code (1)

After restart MySQL i have these messages:

Code: Select all

root@eve-ng:~# sudo service mysql restart
Job for mysql.service failed because the control process exited with error code. See "systemctl status mysql.service" and "journalctl -xe" for details.

Log of journalctl -xe says:

Code: Select all

root@eve-ng:~# journalctl -xe
-- Defined-By: systemd
-- Support: http://lists.freedesktop.org/mailman/listinfo/systemd-devel
--
-- Unit mysql.service has begun starting up.
Feb 16 20:14:25 eve-ng kernel: audit: type=1400 audit(1550340865.591:123): apparmor="DENIED" operation="open" profile="/usr/sbin/mysqld" name="/proc/28735/sta
Feb 16 20:14:25 eve-ng kernel: audit: type=1400 audit(1550340865.591:124): apparmor="DENIED" operation="open" profile="/usr/sbin/mysqld" name="/sys/devices/sy
Feb 16 20:14:25 eve-ng kernel: audit: type=1400 audit(1550340865.591:125): apparmor="DENIED" operation="open" profile="/usr/sbin/mysqld" name="/proc/28735/sta
Feb 16 20:14:25 eve-ng audit[28735]: AVC apparmor="DENIED" operation="open" profile="/usr/sbin/mysqld" name="/proc/28735/status" pid=28735 comm="mysqld" reque
Feb 16 20:14:25 eve-ng audit[28735]: AVC apparmor="DENIED" operation="open" profile="/usr/sbin/mysqld" name="/sys/devices/system/node/" pid=28735 comm="mysqld
Feb 16 20:14:25 eve-ng audit[28735]: AVC apparmor="DENIED" operation="open" profile="/usr/sbin/mysqld" name="/proc/28735/status" pid=28735 comm="mysqld" reque
Feb 16 20:14:26 eve-ng systemd[1]: mysql.service: Main process exited, code=exited, status=1/FAILURE
Feb 16 20:14:55 eve-ng systemd[1]: Failed to start MySQL Community Server.
-- Subject: Unit mysql.service has failed
-- Defined-By: systemd
-- Support: http://lists.freedesktop.org/mailman/listinfo/systemd-devel
--
-- Unit mysql.service has failed.
--
-- The result is failed.
Feb 16 20:14:55 eve-ng systemd[1]: mysql.service: Unit entered failed state.
Feb 16 20:14:55 eve-ng systemd[1]: mysql.service: Failed with result 'exit-code'.
Feb 16 20:14:55 eve-ng systemd[1]: mysql.service: Service hold-off time over, scheduling restart.
Feb 16 20:14:55 eve-ng systemd[1]: Stopped MySQL Community Server.
-- Subject: Unit mysql.service has finished shutting down
-- Defined-By: systemd
-- Support: http://lists.freedesktop.org/mailman/listinfo/systemd-devel
--
-- Unit mysql.service has finished shutting down.
Feb 16 20:14:55 eve-ng systemd[1]: Starting MySQL Community Server...
-- Subject: Unit mysql.service has begun start-up
-- Defined-By: systemd
-- Support: http://lists.freedesktop.org/mailman/listinfo/systemd-devel
--
-- Unit mysql.service has begun starting up.
Feb 16 20:14:55 eve-ng audit[28900]: AVC apparmor="DENIED" operation="open" profile="/usr/sbin/mysqld" name="/proc/28900/status" pid=28900 comm="mysqld" reque
Feb 16 20:14:55 eve-ng audit[28900]: AVC apparmor="DENIED" operation="open" profile="/usr/sbin/mysqld" name="/sys/devices/system/node/" pid=28900 comm="mysqld
Feb 16 20:14:55 eve-ng audit[28900]: AVC apparmor="DENIED" operation="open" profile="/usr/sbin/mysqld" name="/proc/28900/status" pid=28900 comm="mysqld" reque
Feb 16 20:14:55 eve-ng kernel: audit: type=1400 audit(1550340895.841:126): apparmor="DENIED" operation="open" profile="/usr/sbin/mysqld" name="/proc/28900/sta
Feb 16 20:14:55 eve-ng kernel: audit: type=1400 audit(1550340895.841:127): apparmor="DENIED" operation="open" profile="/usr/sbin/mysqld" name="/sys/devices/sy
Feb 16 20:14:55 eve-ng kernel: audit: type=1400 audit(1550340895.841:128): apparmor="DENIED" operation="open" profile="/usr/sbin/mysqld" name="/proc/28900/sta
Feb 16 20:14:56 eve-ng systemd[1]: mysql.service: Main process exited, code=exited, status=1/FAILURE
lines 2539-2579/2579 (END)

/etc/init.d/mysql status have these one:

Code: Select all

root@eve-ng:~# /etc/init.d/mysql status
* mysql.service - MySQL Community Server
   Loaded: loaded (/lib/systemd/system/mysql.service; enabled; vendor preset: enabled)
   Active: activating (start-post) (Result: exit-code) since Sat 2019-02-16 20:09:45 EET; 17s ago
  Process: 27136 ExecStart=/usr/sbin/mysqld (code=exited, status=1/FAILURE)
  Process: 27128 ExecStartPre=/usr/share/mysql/mysql-systemd-start pre (code=exited, status=0/SUCCESS)
 Main PID: 27136 (code=exited, status=1/FAILURE);         : 27137 (mysql-systemd-s)
   CGroup: /system.slice/mysql.service
           `-control
             |-27137 /bin/bash /usr/share/mysql/mysql-systemd-start post
             `-27227 sleep 1

Feb 16 20:09:45 eve-ng systemd[1]: Starting MySQL Community Server...
Feb 16 20:09:46 eve-ng systemd[1]: mysql.service: Main process exited, code=exited, status=1/FAILURE
Hint: Some lines were ellipsized, use -l to show in full.

So how can i fix this?

[Uldis (UD)]

first check if your HDD is not full mate
df -h

before upgrade always use
apt autoremove

if HDD is all right, then use:
unl_wrapper -a restoredb

this command will recovery SQL database
admin/eve
This command is introduced from community v 2.0.3-95 and Pro 2.0.4-107


Uldis

[skaZska]

first check if your HDD is not full mate
df -h

before upgrade always use
apt autoremove

if HDD is all right, then use:
unl_wrapper -a restoredb

this command will recovery SQL database
admin/eve
This command is introduced from community v 2.0.3-95 and Pro 2.0.4-107


Uldis

Disk space is not full:

Code: Select all

root@eve-ng:~# df -h
Filesystem                    Size  Used Avail Use% Mounted on
udev                          2.9G     0  2.9G   0% /dev
tmpfs                         597M   14M  584M   3% /run
/dev/mapper/eve--ng--vg-root   31G  6.5G   23G  22% /
tmpfs                         3.0G     0  3.0G   0% /dev/shm
tmpfs                         5.0M     0  5.0M   0% /run/lock
tmpfs                         3.0G     0  3.0G   0% /sys/fs/cgroup
/dev/sda1                     472M   83M  365M  19% /boot

Doesn't work, i was trying upgrade my system "apt get upgrade" still have this problem now with onother error:

Code: Select all

root@eve-ng:~# apt get upgrade
E: Invalid operation get
root@eve-ng:~# apt upgrade
Reading package lists... Done
Building dependency tree
Reading state information... Done
Calculating upgrade... Done
The following packages will be upgraded:
  eve-ng
1 upgraded, 0 newly installed, 0 to remove and 0 not upgraded.
1 not fully installed or removed.
Need to get 0 B/18.5 MB of archives.
After this operation, 1,573 kB of additional disk space will be used.
Do you want to continue? [Y/n] y
(Reading database ... 92461 files and directories currently installed.)
Preparing to unpack .../eve-ng_2.0.3-95_amd64.deb ...
Checking MySQL... failed
dpkg: error processing archive /var/cache/apt/archives/eve-ng_2.0.3-95_amd64.deb (--unpack):
 subprocess new pre-installation script returned error exit status 1

Progress: [ 22%] [#############.............................................]

[skaZska]

Nevermind, i will reinstall it, thanks!