Beginners issue
Version number of controlcenter
Version: 1.1.0
Postfix version
Version: mail_version = 3.3.0
Golang version
Installed via Docker
Docker version
Version: 20.10.1
Sqlite version
root@cloud2:~/lightmeterworkspace# for f in /root/lightmeterworkspace/*.db; do echo "Filename: $f"; sqlite3 "$f" '.dbinfo'; done
Filename: /root/lightmeterworkspace/auth.db
database page size: 4096
write format: 2
read format: 2
reserved bytes: 0
file change counter: 2
database page count: 5
freelist page count: 0
schema cookie: 3
schema format: 4
default cache size: 0
autovacuum top root: 0
incremental vacuum: 0
text encoding: 1 (utf8)
user version: 0
application id: 0
software version: 3033000
number of tables: 4
number of indexes: 0
number of triggers: 0
number of views: 0
schema size: 403
Filename: /root/lightmeterworkspace/insights.db
database page size: 4096
write format: 2
read format: 2
reserved bytes: 0
file change counter: 2
database page count: 9
freelist page count: 0
schema cookie: 7
schema format: 4
default cache size: 0
autovacuum top root: 0
incremental vacuum: 0
text encoding: 1 (utf8)
user version: 0
application id: 0
software version: 3033000
number of tables: 4
number of indexes: 4
number of triggers: 0
number of views: 0
schema size: 760
Filename: /root/lightmeterworkspace/logs.db
database page size: 4096
write format: 2
read format: 2
reserved bytes: 0
file change counter: 2
database page count: 846
freelist page count: 0
schema cookie: 3
schema format: 4
default cache size: 0
autovacuum top root: 0
incremental vacuum: 0
text encoding: 1 (utf8)
user version: 0
application id: 0
software version: 3033000
number of tables: 3
number of indexes: 1
number of triggers: 0
number of views: 0
schema size: 888
Filename: /root/lightmeterworkspace/master.db
database page size: 4096
write format: 2
read format: 2
reserved bytes: 0
file change counter: 2
database page count: 4
freelist page count: 0
schema cookie: 2
schema format: 4
default cache size: 0
autovacuum top root: 0
incremental vacuum: 0
text encoding: 1 (utf8)
user version: 0
application id: 0
software version: 3033000
number of tables: 3
number of indexes: 0
number of triggers: 0
number of views: 0
schema size: 334
Attach logs
Consider attaching relevant mail logs to this issue - you can safely remove private data from them (email addresses, hostnames, IPs, etc) using the [tools/batch_log_cleaner.sh
] script in this repository. That creates clean log copies without modifying your source logs.
Which Operating System and version are you using?
OS: Ubuntu
Version: 18.04.5 LTS
root@cloud2:~/lightmeterworkspace# uname -a Linux cloud2 4.15.0-128-generic #131-Ubuntu SMP Wed Dec 9 06:57:35 UTC 2020 x86_64 x86_64 x86_64 GNU/Linux
Description
I am a newbie to Lightmeter and couldn't figure out how to start troubleshooting.
Apparently I have configured lightmeter correctly as I see data being inserted into the db:
2020/12/29 17:58:38 db.go:163: Inserted 1 rows in a transaction
2020/12/29 18:10:08 db.go:163: Inserted 1 rows in a transaction
2020/12/29 18:51:51 dnschecker.go:116: Starting a new RBL scan on IP 138.201.184.237
2020/12/29 18:53:24 dnschecker.go:151: RBL scan finished in 1m32.276523826s
2020/12/29 20:10:16 db.go:163: Inserted 2 rows in a transaction
2020/12/29 20:10:24 db.go:163: Inserted 1 rows in a transaction
2020/12/29 20:16:46 db.go:163: Inserted 1 rows in a transaction
...
Unfortunately I do not see any insights in the web UI:
Where should I look first to troubleshoot? Thanks
Ciao, giggo