OPGELOST! Dankzij een zeer snel antwoord op mijn vraag op REDDIT, kwam ik uiteindelijk uit bij Synology Forum.
Lees even hoeveel moeite er toen (2017) door Synology Support werd besteed aan deze issue. Waarom heeft support mij niet gewezen op deze post en bijdrage van het Synology Support Team zelf. Echte ongelofelijk dommig weer van Synologyhttps://community.synology.com/enu/forum/17/post/103211Hieronder de door mij toegepaste commands in macOS Terminal.
Last login: Sat Sep 18 19:28:51 on ttys000
MACPRO51:~ ******$ ssh user@192.168.1.125
user@192.168.1.125's password:
user@DS1812:~$ sudo -i
Password:
root@DS1812:~# cd /var/log/synolog
root@DS1812:/var/log/synolog# dir
total 10180
drwxr-x--- 2 system log 4096 Sep 18 20:17 .
drwxr-xr-x 22 root root 12288 Sep 18 19:53 ..
lrwxrwxrwx 1 root root 37 Apr 8 14:32 .AFPXFERDB -> /volume1/@database/synolog/.AFPXFERDB
lrwxrwxrwx 1 root root 39 Apr 8 14:32 .DSMFMXFERDB -> /volume1/@database/synolog/.DSMFMXFERDB
lrwxrwxrwx 1 root root 37 Apr 8 14:32 .FTPXFERDB -> /volume1/@database/synolog/.FTPXFERDB
lrwxrwxrwx 1 root root 37 Apr 8 14:32 .SMBXFERDB -> /volume1/@database/synolog/.SMBXFERDB
-rw-r--r-- 1 root root 2663424 Sep 18 20:17 .SYNOACCOUNTDB
-rw-r----- 1 system log 1155 Dec 14 2016 synobackup.log
-rw-rw---- 1 system log 1300480 Sep 18 19:38 .SYNOCONNDB
-rw-rw---- 1 system log 32768 Sep 18 20:16 .SYNOCONNDB-shm
-rw-rw---- 1 system log 3176 Sep 18 20:16 .SYNOCONNDB-wal
-rw-r----- 1 system log 1048681 Dec 25 2015 synoconn.log.0
-rw-r--r-- 1 system log 12288 Jan 11 2021 .SYNODISKDB
-rw-rw-rw- 1 root root 3072 Sep 18 20:00 .SYNODISKHEALTHDB
-rw-r--r-- 1 system log 929792 Sep 18 04:50 .SYNODISKTESTDB
-rw-rw---- 1 system log 19627 Sep 15 18:11 synodockerwebapi.log
-rw-r----- 1 system log 13107 Jun 20 2017 synoindex.log
-rw-r--r-- 1 root root 2048 Sep 13 2018 .SYNOISCSIDB
-rw-rw---- 1 system log 4096 Sep 18 14:30 .SYNONETBKPDB
-rw-rw---- 1 system log 53599 Sep 18 13:48 synoresourcemonitor.log
-rw-rw---- 1 system log 621568 Sep 18 19:38 .SYNOSYSDB
-rw-r----- 1 system log 1111333 Jun 3 2017 synosys.log.0
-rw-r--r-- 1 system log 2521088 Jun 26 2017 .SYNOSYSLOGDB
lrwxrwxrwx 1 root root 38 Apr 8 14:32 .TFTPXFERDB -> /volume1/@database/synolog/.TFTPXFERDB
lrwxrwxrwx 1 root root 40 Apr 8 14:32 .WEBDAVXFERDB -> /volume1/@database/synolog/.WEBDAVXFERDB
root@DS1812:/var/log/synolog# stop syslog-acc
syslog-acc stop/waiting
root@DS1812:/var/log/synolog# sqlite3 /var/log/synolog/.SYNOACCOUNTDB "select device from histogram"
("U7PG2,*****,v3.9.19.8123")
("US8P150,*****,v3.9.19.8123")
("US8P60,*****,v3.7.29.5446")
("US8P60,*****,v3.9.19.8123")
("US8P60,*****,v3.9.19.8123")
("US8P60,*****,v3.9.19.8123")
192
192.168.1.1
192.168.1.125
192.168.1.14
192.168.1.16
192.168.1.20
192.168.1.26
192.168.1.27
192.168.1.3
192.168.1.4
192.168.1.5
192.168.1.55
192.168.1.6
192.168.1.7
192.168.1.8
192.168.1.9
192.168.178.1
192.168.2.100
192.168.2.12
192.168.2.13
192.168.2.200
192.168.2.9
DS1812
MACPRO31
MACPRO31.local
MACPRO51
MACPRO51.local
MZ-iPhone4.local
UAP-AC-PRO-LIVROOM.guest.local
UAP-AC-PRO-LIVROOM.localdomain
UAP-AC-PRO-LVNGRM.local
US-8-POE4-60W-BDRM
US-8-POE4-60W-LVNG
US-8-POE4-60W-LVNG-RM
US-8-POE4-60W-LVNGRM
US-8-POE4-60W-LVNGRM.local
US-8-POE4-60W-MSTRBDRM
US-8-POE4-60W-MSTRBDRM.local
US-8-POE4-60W-UTL
US-8-POE4-60W-UTL-RM
US-8-POE4-60W-UTLRM
US-8-POE4-60W-UTLRM.local
US-8-POE4-60W.localdomain
US-8-POE8-150W-STD
US-8-POE8-150W-STD.local
US-8-POE8-150W-STUDIO.localdomain
USG-3P
USG-3P-UTL
USG-3P-UTL-RM
USG-3P-UTLRM
USG-3P-UTLROOM
macpro31
macpro31.home
macpro51
macpro51.home
root@DS1812:/var/log/synolog# sqlite3 /var/log/synolog/.SYNOACCOUNTDB "delete from histogram where device ='USG-3P'"
root@DS1812:/var/log/synolog# sqlite3 /var/log/synolog/.SYNOACCOUNTDB "select device from histogram"
("U7PG2,*****,v3.9.19.8123")
("US8P150,*****,v3.9.19.8123")
("US8P60,*****,v3.7.29.5446")
("US8P60,*****,v3.9.19.8123")
("US8P60,*****,v3.9.19.8123")
("US8P60,*****,v3.9.19.8123")
192
192.168.1.1
192.168.1.125
192.168.1.14
192.168.1.16
192.168.1.20
192.168.1.26
192.168.1.27
192.168.1.3
192.168.1.4
192.168.1.5
192.168.1.55
192.168.1.6
192.168.1.7
192.168.1.8
192.168.1.9
192.168.178.1
192.168.2.100
192.168.2.12
192.168.2.13
192.168.2.200
192.168.2.9
DS1812
MACPRO31
MACPRO31.local
MACPRO51
MACPRO51.local
MZ-iPhone4.local
UAP-AC-PRO-LIVROOM.guest.local
UAP-AC-PRO-LIVROOM.localdomain
UAP-AC-PRO-LVNGRM.local
US-8-POE4-60W-BDRM
US-8-POE4-60W-LVNG
US-8-POE4-60W-LVNG-RM
US-8-POE4-60W-LVNGRM
US-8-POE4-60W-LVNGRM.local
US-8-POE4-60W-MSTRBDRM
US-8-POE4-60W-MSTRBDRM.local
US-8-POE4-60W-UTL
US-8-POE4-60W-UTL-RM
US-8-POE4-60W-UTLRM
US-8-POE4-60W-UTLRM.local
US-8-POE4-60W.localdomain
US-8-POE8-150W-STD
US-8-POE8-150W-STD.local
US-8-POE8-150W-STUDIO.localdomain
USG-3P-UTL
USG-3P-UTL-RM
USG-3P-UTLRM
USG-3P-UTLROOM
macpro31
macpro31.home
macpro51
macpro51.home
root@DS1812:/var/log/synolog# sqlite3 /var/log/synolog/.SYNOACCOUNTDB "delete from histogram where device ='USG-3P-UTL-RM'"
root@DS1812:/var/log/synolog# sqlite3 /var/log/synolog/.SYNOACCOUNTDB "delete from histogram where device ='USG-3P-UTLRM'"
root@DS1812:/var/log/synolog# sqlite3 /var/log/synolog/.SYNOACCOUNTDB "delete from histogram where device ='USG-3P-UTLROOM'"
root@DS1812:/var/log/synolog# sqlite3 /var/log/synolog/.SYNOACCOUNTDB "delete from histogram where device ='US-8-POE8-150W-STUDIO.localdomain'"
root@DS1812:/var/log/synolog# start syslog-acc
syslog-acc start/running, process 27541
root@DS1812:/var/log/synolog#
Als laatste dan nog de syslog server weer opstarten:
restart syslog-acc
Dus ik ben nog wel even bezig met copy-paste, maar wel een happy camper!
Bedankt weer voor jullie input en geduld om me te helpen met al mijn Log Centre problemen.
EDIT-21:56 | Nu blijkt dat ik inderdaad ook de "("U7PG2,*****,v3.9.19.8123")" regels niet kan verwijderen.
root@DS1812:/var/log/synolog# sqlite3 /var/log/synolog/.SYNOACCOUNTDB "select device from histogram"
("U7PG2,*****,v3.9.19.8123")
("US8P150,*****,v3.9.19.8123")
("US8P60,*****,v3.7.29.5446")
("US8P60,*****,v3.9.19.8123")
("US8P60,*****,v3.9.19.8123")
("US8P60,*****,v3.9.19.8123")
192.168.1.7
DS1812
MACPRO31
MACPRO51
US-8-POE4-60W-BDRM
US-8-POE4-60W-LVNG
US-8-POE4-60W-UTL
US-8-POE8-150W-STD
USG-3P-UTL
root@DS1812:/var/log/synolog#
EDIT-22:01 | Onderstaand de commands in macOS Terminal deze laatste regels te verwijderen. STOP eerst weer de syslog
root@DS1812:/var/log/synolog# stop syslog-acc
syslog-acc stop/waiting
root@DS1812:/var/log/synolog# sqlite3 .SYNOACCOUNTDB
SQLite version 3.10.2 2016-01-20 15:27:19
Enter ".help" for usage hints.
sqlite> SELECT device FROM histogram;
("U7PG2,*****,v3.9.19.8123")
("US8P150,*****,v3.9.19.8123")
("US8P60,*****,v3.7.29.5446")
("US8P60,*****,v3.9.19.8123")
("US8P60,*****,v3.9.19.8123")
("US8P60,*****,v3.9.19.8123")
192.168.1.7
DS1812
MACPRO31
MACPRO51
US-8-POE4-60W-BDRM
US-8-POE4-60W-LVNG
US-8-POE4-60W-UTL
US-8-POE8-150W-STD
USG-3P-UTL
sqlite> DELETE FROM histogram WHERE device = '("U7PG2,*****,v3.9.19.8123")';
sqlite> DELETE FROM histogram WHERE device = '("US8P150,*****,v3.9.19.8123")';
sqlite> DELETE FROM histogram WHERE device = '("US8P60,*****,v3.7.29.5446")';
sqlite> DELETE FROM histogram WHERE device = '("US8P60,*****,v3.9.19.8123")';
sqlite> DELETE FROM histogram WHERE device = '("US8P60,*****,v3.9.19.8123")';
sqlite> DELETE FROM histogram WHERE device = '("US8P60,*****,v3.9.19.8123")';
sqlite> .exit
root@DS1812:/var/log/synolog# sqlite3 /var/log/synolog/.SYNOACCOUNTDB "select device from histogram"
192.168.1.7
DS1812
MACPRO31
MACPRO51
US-8-POE4-60W-BDRM
US-8-POE4-60W-LVNG
US-8-POE4-60W-UTL
US-8-POE8-150W-STD
USG-3P-UTL
root@DS1812:/var/log/synolog# start syslog-acc
syslog-acc start/running, process 28953
root@DS1812:/var/log/synolog#
En nu is mijn Log Centre weer helemaal lean & clean...
Nu ga ik nog wel even kijken hoe ik die 192.168.1.7 om kan zetten naar de UniFi hostname.