Romber

Too many years ago I had Armbian whis was based on Debian Jessie with MySql. And there I've created database with three tables ENGINE = InnoDB. When I download and rolled Armbian on Debian Buster based I note that MariaDb instead Mysql is on it. Now using MariaDb I can not make dump of my database. I found out here https://stackoverflow.com/questions/19926802/mariadb-crash-table-doesnt-exist-in-engine-cant-recover-tables that I can make dump with Mysql only

I've reinstalled chrony and problem went away! Thank all for attention

I've done armbianmonitor -U and got this output, maybe it help to resolve my problem https://www.dropbox.com/s/49m3f7w6h2lfujf/armbianmonitor.txt?dl=0

destructor@orangepiplus:~$ sudo ntpdate -vd pool.ntp.org 26 May 16:09:51 ntpdate[17774]: ntpdate 4.2.8p12@1.3728-o (1) Looking for host pool.ntp.org and service ntp 167.86.76.95 reversed to jonasled.de jonasled.de forward check lookup fail: Unknown error host found : 167.86.76.95 (jonasled.de) transmit(167.86.76.95) receive(167.86.76.95) transmit(212.83.179.156) receive(212.83.179.156) transmit(185.244.195.159) receive(185.244.195.159) transmit(108.61.56.35) receive(108.61.56.35) transmit(167.86.76.95) transmit(212.83.179.156) receive(212.83.179.156) transmit(185.244.195.159) receive(185.244.195.159) transmit(108.61.56.35) receive(108.61.56.35) transmit(167.86.76.95) transmit(212.83.179.156) transmit(185.244.195.159) receive(185.244.195.159) transmit(108.61.56.35) receive(108.61.56.35) transmit(167.86.76.95) transmit(212.83.179.156) transmit(185.244.195.159) receive(185.244.195.159) transmit(108.61.56.35) receive(108.61.56.35) server 167.86.76.95, port 123 stratum 2, precision -23, leap 00, trust 000 refid [237.17.204.95], root delay 0.013870, root dispersion 0.061859 transmitted 4, in filter 4 reference time: e27bd9db.ec609209 Fri, May 29 2020 21:58:35.923 originate timestamp: e27be072.e319e100 Fri, May 29 2020 22:26:42.887 transmit timestamp: e27793a5.b078107b Tue, May 26 2020 16:09:57.689 filter delay: 0.07034 0.00000 0.00000 0.00000 0.00000 0.00000 0.00000 0.00000 filter offset: 281811.1 0.000000 0.000000 0.000000 0.000000 0.000000 0.000000 0.000000 delay 0.07034, dispersion 56.00000 offset 281811.175392 server 212.83.179.156, port 123 stratum 2, precision -24, leap 00, trust 000 refid [35.192.231.136], root delay 0.008606, root dispersion 0.047073 transmitted 4, in filter 4 reference time: e27bd87d.a9d9bf50 Fri, May 29 2020 21:52:45.663 originate timestamp: e27be075.173b62e5 Fri, May 29 2020 22:26:45.090 transmit timestamp: e27793a5.e3aca77e Tue, May 26 2020 16:09:57.889 filter delay: 0.07707 0.07664 0.00000 0.00000 0.00000 0.00000 0.00000 0.00000 filter offset: 281811.1 281811.1 0.000000 0.000000 0.000000 0.000000 0.000000 0.000000 delay 0.07664, dispersion 24.00000 offset 281811.175878 server 185.244.195.159, port 123 stratum 3, precision -25, leap 00, trust 000 refid [80.237.128.149], root delay 0.022736, root dispersion 0.025070 transmitted 4, in filter 4 reference time: e27bde3d.b21e1ba7 Fri, May 29 2020 22:17:17.695 originate timestamp: e27be079.4937a2cc Fri, May 29 2020 22:26:49.286 transmit timestamp: e27793a6.16dd6640 Tue, May 26 2020 16:09:58.089 filter delay: 0.06255 0.06229 0.06241 0.06226 0.00000 0.00000 0.00000 0.00000 filter offset: 281811.1 281811.1 281811.1 281811.1 0.000000 0.000000 0.000000 0.000000 delay 0.06226, dispersion 0.00000 offset 281811.178343 server 108.61.56.35, port 123 stratum 2, precision -22, leap 00, trust 000 refid [198.30.92.2], root delay 0.023178, root dispersion 0.021896 transmitted 4, in filter 4 reference time: e27bdefd.9d69293c Fri, May 29 2020 22:20:29.614 originate timestamp: e27be079.89bbf28f Fri, May 29 2020 22:26:49.538 transmit timestamp: e27793a6.4a10719b Tue, May 26 2020 16:09:58.289 filter delay: 0.16010 0.15996 0.15985 0.15987 0.00000 0.00000 0.00000 0.00000 filter offset: 281811.1 281811.1 281811.1 281811.1 0.000000 0.000000 0.000000 0.000000 delay 0.15985, dispersion 0.00000 offset 281811.181579 26 May 16:09:59 ntpdate[17774]: step time server 167.86.76.95 offset 281811.175392 sec destructor@orangepiplus:~$

destructor@orangepiplus:~$ sudo apt install fping [sudo] password for destructor: Reading package lists... Done Building dependency tree Reading state information... Done fping is already the newest version (4.2-1). 0 upgraded, 0 newly installed, 0 to remove and 0 not upgraded.

You're wrong. I installed clean armbian image.

destructor@orangepiplus:~$ screenfetch _,met$$$$$gg. destructor@orangepiplus ,g$$$$$$$$$$$$$$$P. OS: Debian 10 buster ,g$$P"" """Y$$.". Kernel: armv7l Linux 5.4.35-sunxi ,$$P' `$$$. Uptime: 1m ',$$P ,ggs. `$$b: Packages: 963 `d$$' ,$P"' . $$$ Shell: 1583 $$P d$' , $$P CPU: ARMv7 rev 5 (v7l) @ 4x 1.368GHz $$: $$. - ,d$$' GPU: $$\; Y$b._ _,d$P' RAM: 169MiB / 2012MiB Y$$. `.`"Y$$$$P"' `$$b "-.__ `Y$$ `Y$$. `$$b. `Y$$b. `"Y$b._ `""""

sudo: ufw: command not found Ok, I've installed it. @orangepiplus:~$ sudo ufw reset Resetting all rules to installed defaults. This may disrupt existing ssh connections. Proceed with operation (y|n)? y Backing up 'user.rules' to '/etc/ufw/user.rules.20200522_144043' Backing up 'before.rules' to '/etc/ufw/before.rules.20200522_144043' Backing up 'after.rules' to '/etc/ufw/after.rules.20200522_144043' Backing up 'user6.rules' to '/etc/ufw/user6.rules.20200522_144043' Backing up 'before6.rules' to '/etc/ufw/before6.rules.20200522_144043' Backing up 'after6.rules' to '/etc/ufw/after6.rules.20200522_144043' @orangepiplus:~$ armbianmonitor -u Network/firewall problem detected. Not able to upload debug info. Please fix this or use "-U" instead and upload whole output manually What is next? I think that I more and more break my system

destructor@orangepiplus:~$ cat /etc/network/interfaces source /etc/network/interfaces.d/* # Network is managed by Network manager auto lo iface lo inet loopback All ping work :28:19 2020 from destructor@orangepiplus:~$ sudo ifconfig eth0: flags=4163<UP,BROADCAST,RUNNING,MULTICAST> mtu 1500 inet 192.168.0.104 netmask 255.255.255.0 broadcast 192.168.0.255 inet6 fe80::8e0:7c3e:c125:9a2a prefixlen 64 scopeid 0x20<link> ether 02:81:7d:85:f6:f7 txqueuelen 1000 (Ethernet) RX packets 117227 bytes 98206563 (93.6 MiB) RX errors 0 dropped 0 overruns 0 frame 0 TX packets 68716 bytes 8157760 (7.7 MiB) TX errors 0 dropped 0 overruns 0 carrier 0 collisions 0 device interrupt 32 lo: flags=73<UP,LOOPBACK,RUNNING> mtu 65536 inet 127.0.0.1 netmask 255.0.0.0 inet6 ::1 prefixlen 128 scopeid 0x10<host> loop txqueuelen 1000 (Local Loopback) RX packets 302 bytes 15100 (14.7 KiB) RX errors 0 dropped 0 overruns 0 frame 0 TX packets 302 bytes 15100 (14.7 KiB) TX errors 0 dropped 0 overruns 0 carrier 0 collisions 0 wlan0: flags=4099<UP,BROADCAST,MULTICAST> mtu 1500 ether e0:b9:4d:1e:8e:3f txqueuelen 1000 (Ethernet) RX packets 0 bytes 0 (0.0 RX errors 0 dropped 0 overruns 0 frame 0 TX packets 0 bytes 0 (0.0 TX errors 0 dropped 0 overruns 0 carrier 0 collisions 0 destructor@orangepiplus:~$ cat /etc/resolv.conf # Generated by NetworkManagernameserver 8.8.8.8 nameserver 192.168.0.1

Network is connected. ping Google.com is executing good. armbianmonitor -U shows very much text.

_,met$$$$$gg. @orangepiplus ,g$$$$$$$$$$$$$$$P. OS: Debian 10 buster ,g$$P"" """Y$$.". Kernel: armv7l Linux 5.4.35-sunxi ,$$P' `$$$. Uptime: 2d 28m ',$$P ,ggs. `$$b: Packages: 961 `d$$' ,$P"' . $$$ Shell: 21642 $$P d$' , $$P CPU: ARMv7 rev 5 (v7l) @ 4x 1.368GHz $$: $$. - ,d$$' GPU: $$\; Y$b._ _,d$P' RAM: 172MiB / 2012MiB Y$$. `.`"Y$$$$P"' `$$b "-.__ `Y$$ `Y$$. `$$b. `Y$$b. `"Y$b._ `"""" @orangepiplus:~$ armbianmonitor -u Network/firewall problem detected. Not able to upload debug info. Please fix this or use "-U" instead and upload whole output manually @orangepiplus:~$ systemctl status systemd-timesyncd.service ● systemd-timesyncd.service - Network Time Synchronization Loaded: loaded (/lib/systemd/system/systemd-timesyncd.service; enabled; vendor preset: enabled) Drop-In: /lib/systemd/system/systemd-timesyncd.service.d └─disable-with-time-daemon.conf Active: inactive (dead) Condition: start condition failed at Tue 2020-05-19 12:33:35 EEST; 24h ago Docs: man:systemd-timesyncd.service(8) May 18 12:56:57 orangepiplus systemd[1]: Condition check resulted in Network Time Synchronization being skipped. May 19 12:33:01 orangepiplus systemd[1]: Condition check resulted in Network Time Synchronization being skipped. May 19 12:33:35 orangepiplus systemd[1]: Condition check resulted in Network Time Synchronization being skipped. @orangepiplus:~$ timedatectl Local time: Wed 2020-05-20 13:26:14 EEST Universal time: Wed 2020-05-20 10:26:14 UTC RTC time: Thu 1970-01-08 15:09:11 Time zone: Europe/Kiev (EEST, +0300) System clock synchronized: no NTP service: inactive RTC in local TZ: no

destructor@orangepiplus:~$ armbianmonitor -u Network/firewall problem detected. Not able to upload debug info. Please fix this or use "-U" instead and upload whole output manually

I run this command I saw that my system clock is not synchronized. destructor@orangepiplus:~$ timedatectl Local time: Mon 2020-05-18 14:05:45 EEST Universal time: Mon 2020-05-18 11:05:45 UTC RTC time: Tue 1970-01-06 15:48:55 Time zone: Europe/Kiev (EEST, +0300) System clock synchronized: no NTP service: inactive RTC in local TZ: no So how can I active ntp server? I undestand that is common Linux OS question but when I installed Linux OS on PC devices it never disturb me because there it worked as default

I optimize system and remove unused process. So I don't use wi-fi and sound card. I see this process 642 ? Ss 0:10 /sbin/wpa_supplicant -u -s -O /run/wpa_supplicant how can I disable autostart it?

What is default password for root user in mysql? After instalation I removed apache2 and php.

Ha, I've rolled backup and tried again step by step. sources.list is changed but nothing for upgrade and dist-upgrade, screenfetch shows me that it still is jessie Reading package lists... Done destructor@orangepiplus:~$ sudo apt-get upgrade Reading package lists... Done Building dependency tree Reading state information... Done Calculating upgrade... Done 0 upgraded, 0 newly installed, 0 to remove and 0 not upgraded. destructor@orangepiplus:~$ sudo apt-get dist-upgrade Reading package lists... Done Building dependency tree Reading state information... Done Calculating upgrade... Done 0 upgraded, 0 newly installed, 0 to remove and 0 not upgraded. destructor@orangepiplus:~$ I don't understand, maybe you remove distrib

I want go to stretch and then to buster. I've done as you adviced but upgrade not was executed to end destructor@orangepiplus:~$ sudo apt-get upgrade [sudo] password for destructor: Sorry, try again. [sudo] password for destructor: Reading package lists... Done Building dependency tree Reading state information... Done Calculating upgrade... The following packages were automatically installed and are no longer required: libmono-corlib4.0-cil libperl4-corelibs-perl libtimedate-perl libxcb-shape0 python-support Use 'apt-get autoremove' to remove them. Done The following packages have been kept back: adwaita-icon-theme alsa-utils apt apt-transport-https apt-utils aptitude aptitude-common aspell bc bind9-host bluez bluez-tools build-essential cpp crda curl dmsetup dnsutils findutils g++ gcc glib-networking glib-networking-common glib-networking-services gnome-icon-theme gnupg gparted gtk-sharp3 gtk-sharp3-gapi init init-system-helpers initramfs-tools initscripts iptables iputils-ping isc-dhcp-client isc-dhcp-common libaspell15 libatk3.0-cil libatomic1 libc-bin libc-dev-bin libc6 libc6-dev libcairo1.10-cil libcairo2 libcloog-isl4 libcryptsetup4 libcups2 libcurl3 libcurl3-gnutls libdbd-mysql-perl libdbi-perl libdevmapper1.02.1 libdigest-sha-perl libenchant1c2a libfpm-helper0 libfreetype6 libgcc1 libgd3 libgdiplus libgdk-pixbuf2.0-0 libgdk-pixbuf2.0-common libgdk3.0-cil libgdk3.0-cil-dev libgfortran3 libgio3.0-cil libgio3.0-cil-dev libgl1-mesa-dri libglib3.0-cil libglib3.0-cil-dev libgnomecanvas2-0 libgnomecanvas2-common libgnomevfs2-0 libgnomevfs2-common libgnutls-openssl27 libgomp1 libgtk-3-0 libgtk-3-bin libgtk3.0-cil libgtk3.0-cil-dev libharfbuzz-icu0 libimlib2 libjavascriptcoregtk-1.0-0 libldap-2.4-2 liblircclient0 libllvm3.8 liblocale-gettext-perl libnm-glib4 libnm-util2 libpam-systemd libpango3.0-cil libparted-fs-resize0 libparted2 libproc-processtable-perl libpython-stdlib libpython2.7-minimal libpython2.7-stdlib libpython3-stdlib librtmp1 libsqlite3-0 libssl-dev libstdc++6 libsystemd0 libterm-readkey-perl libtext-charwidth-perl libtext-iconv-perl libubsan0 libudev1 libwebkitgtk-1.0-0 libxml-libxml-perl libxml2 lirc locales lsb-release lshw lxappearance-obconf lxde lxde-core lxpanel lxpanel-data lxrandr lxsession menu mono-fastcgi-server mono-fastcgi-server4 mono-xsp4 mono-xsp4-base monodevelop network-manager nginx-common nginx-full ntfs-3g ntp openbox openssh-client openssh-server openssh-sftp-server openssl parted perl perl-base procps python python-minimal python2.7 python2.7-minimal python3 python3-apt python3-dbus python3-gi python3-minimal python3-software-properties rsyslog software-properties-common sqlite3 sysbench systemd sysv-rc sysvinit-utils testdisk udev util-linux vim vim-common vim-runtime vim-tiny wget wpasupplicant 0 upgraded, 0 newly installed, 0 to remove and 169 not upgraded. 3 not fully installed or removed. After this operation, 0 B of additional disk space will be used. Do you want to continue? [Y/n] Setting up keyboard-configuration (1.164) ... /var/lib/dpkg/info/keyboard-configuration.config: 1: eval: Syntax error: Unterminated quoted string dpkg: error processing package keyboard-configuration (--configure): subprocess installed post-installation script returned error exit status 2 dpkg: dependency problems prevent configuration of console-setup-linux: console-setup-linux depends on keyboard-configuration (= 1.164); however: Package keyboard-configuration is not configured yet. dpkg: error processing package console-setup-linux (--configure): dependency problems - leaving unconfigured dpkg: dependency problems prevent configuration of console-setup: console-setup depends on console-setup-linux | console-setup-freebsd | hurd; however: Package console-setup-linux is not configured yet. Package console-setup-freebsd is not installed. Package hurd is not installed. console-setup depends on keyboard-configuration (= 1.164); however: Package keyboard-configuration is not configured yet. dpkg: error processing package console-setup (--configure): dependency problems - leaving unconfigured Errors were encountered while processing: keyboard-configuration console-setup-linux console-setup E: Sub-process /usr/bin/dpkg returned an error code (1) destructor@orangepiplus:~$

I've tried as you adviced but nothing hapened. destructor@orangepiplus:~$ sudo apt-get update Hit http://security.debian.org jessie/updates InRelease Ign http://httpredir.debian.org jessie InRelease Hit http://download.mono-project.com wheezy InRelease Hit http://httpredir.debian.org jessie Release.gpg Hit http://httpredir.debian.org jessie Release Get:1 http://security.debian.org jessie/updates/main Sources [451 kB] Get:2 http://download.mono-project.com wheezy/main armhf Packages [60,5 kB] Get:3 http://httpredir.debian.org jessie/main Sources [9 169 kB] Get:4 http://security.debian.org jessie/updates/contrib Sources [1 298 B] Get:5 http://apt.armbian.com jessie InRelease [178 B] Ign http://apt.armbian.com jessie InRelease Get:6 http://security.debian.org jessie/updates/non-free Sources [1 794 B] Get:7 http://security.debian.org jessie/updates/main armhf Packages [946 kB] Get:8 http://apt.armbian.com jessie Release.gpg [178 B] Ign http://apt.armbian.com jessie Release.gpg Get:9 http://apt.armbian.com jessie Release [178 B] Ign http://apt.armbian.com jessie Release Get:10 http://security.debian.org jessie/updates/contrib armhf Packages [994 B] Get:11 http://apt.armbian.com jessie/main armhf Packages/DiffIndex [178 B] Ign http://apt.armbian.com jessie/main armhf Packages/DiffIndex Get:12 http://security.debian.org jessie/updates/non-free armhf Packages [4 393 B] Get:13 http://apt.armbian.com jessie/utils armhf Packages/DiffIndex [178 B] Ign http://apt.armbian.com jessie/utils armhf Packages/DiffIndex Get:14 http://apt.armbian.com jessie/jessie-desktop armhf Packages/DiffIndex [178 B] Ign http://apt.armbian.com jessie/jessie-desktop armhf Packages/DiffIndex Get:15 http://apt.armbian.com jessie/main armhf Packages [178 B] Get:16 http://apt.armbian.com jessie/utils armhf Packages [178 B] Get:17 http://apt.armbian.com jessie/jessie-desktop armhf Packages [178 B] Get:18 http://apt.armbian.com jessie/main armhf Packages [178 B] Get:19 http://apt.armbian.com jessie/utils armhf Packages [178 B] Get:20 http://apt.armbian.com jessie/jessie-desktop armhf Packages [178 B] Get:21 http://apt.armbian.com jessie/main armhf Packages [178 B] Get:22 http://apt.armbian.com jessie/utils armhf Packages [178 B] Get:23 http://apt.armbian.com jessie/jessie-desktop armhf Packages [178 B] Get:24 http://apt.armbian.com jessie/main armhf Packages [178 B] Get:25 http://apt.armbian.com jessie/utils armhf Packages [178 B] Get:26 http://apt.armbian.com jessie/jessie-desktop armhf Packages [178 B] Get:27 http://apt.armbian.com jessie/main armhf Packages [178 B] Err http://apt.armbian.com jessie/main armhf Packages HttpError404 Get:28 http://apt.armbian.com jessie/utils armhf Packages [178 B] Err http://apt.armbian.com jessie/utils armhf Packages HttpError404 Get:29 http://apt.armbian.com jessie/jessie-desktop armhf Packages [178 B] Err http://apt.armbian.com jessie/jessie-desktop armhf Packages HttpError404 Get:30 http://httpredir.debian.org jessie/contrib Sources [58,9 kB] Get:31 http://httpredir.debian.org jessie/non-free Sources [119 kB] Get:32 http://httpredir.debian.org jessie/main armhf Packages [8 898 kB] Get:33 http://httpredir.debian.org jessie/contrib armhf Packages [44,3 kB] Get:34 http://httpredir.debian.org jessie/non-free armhf Packages [74,9 kB] Fetched 19,8 MB in 16s (1 199 kB/s) W: Failed to fetch http://apt.armbian.com/dists/jessie/main/binary-armhf/Packages HttpError404 W: Failed to fetch http://apt.armbian.com/dists/jessie/utils/binary-armhf/Packages HttpError404 W: Failed to fetch http://apt.armbian.com/dists/jessie/jessie-desktop/binary-armhf/Packages HttpError404 E: Some index files failed to download. They have been ignored, or old ones used instead. destructor@orangepiplus:~$ sudo apt-get upgrade Reading package lists... Done Building dependency tree Reading state information... Done Calculating upgrade... Done The following packages have been kept back: libgdiplus 0 upgraded, 0 newly installed, 0 to remove and 1 not upgraded. destructor@orangepiplus:~$ sudo apt-get dist-upgrade Reading package lists... Done Building dependency tree Reading state information... Done Calculating upgrade... Done 0 upgraded, 0 newly installed, 0 to remove and 0 not upgraded. destructor@orangepiplus:~$