How to configure Debian SNMP to be seen by The Dude?

Question

MySQL

I must say right away that there is no experience with snmp.
I added a package to Mikrotik, and it became a dude server.
I connected another Mikrotik to dude - the flight is normal!
But I can't connect to Debian monitoring.

What has been done:
1) installed packages: snmp snmpd libsnmp-dev
2) Changed access in /etc/snmp/snmpd.conf: agentAddress udp:161,udp6:[::1]:161
3) Restarted the service

What I got:

snmpwalk -v2c -c public localhost

iso.3.6.1.2.1.1.1.0 = STRING: "Linux Web 4.9.0-11-amd64 #1 SMP Debian 4.9.189-3+deb9u1 (2019-09-20) x86_64"
iso.3.6.1.2.1.1.2.0 = OID: iso.3.6.1.4.1.8072.3.2.10
iso.3.6.1.2.1.1.3.0 = Timeticks: (39196) 0:06:31.96
iso.3.6.1.2.1.1.4.0 = STRING: "Me "
iso.3.6.1.2.1.1.5.0 = STRING: "Web"
iso.3.6.1.2.1.1.6.0 = STRING: "Sitting on the Dock of the Bay"
iso.3.6.1.2.1.1.7.0 = INTEGER: 72
iso.3.6.1.2.1.1.8.0 = Timeticks: (0) 0:00:00.00
iso.3.6.1.2.1.1.9.1.2.1 = OID: iso.3.6.1.6.3.11.3.1.1
iso.3.6.1.2.1.1.9.1.2.2 = OID: iso.3.6.1.6.3.15.2.1.1
iso.3.6.1.2.1.1.9.1.2.3 = OID: iso.3.6.1.6.3.10.3.1.1
iso.3.6.1.2.1.1.9.1.2.4 = OID: iso.3.6.1.6.3.1
iso.3.6.1.2.1.1.9.1.2.5 = OID: iso.3.6.1.6.3.16.2.2.1
iso.3.6.1.2.1.1.9.1.2.6 = OID: iso.3.6.1.2.1.49
iso.3.6.1.2.1.1.9.1.2.7 = OID: iso.3.6.1.2.1.4
iso.3.6.1.2.1.1.9.1.2.8 = OID: iso.3.6.1.2.1.50
iso.3.6.1.2.1.1.9.1.2.9 = OID: iso.3.6.1.6.3.13.3.1.3
iso.3.6.1.2.1.1.9.1.2.10 = OID: iso.3.6.1.2.1.92

ss -alnp | grep snmp | grep 161

udp UNCONN 0 0 *:161 *:* users:(("snmpd",pid=113803,fd=10))
udp UNCONN 0 0 ::1:161 :::* users:(("snmpd",pid=113803,fd=12))

In dude I get:



I.e. the data seems to be visible, but in the snmp tabs it is empty.

Answer 1

use LEFT JOIN - it will allow you to take all records from the left table, and from the right - only those for which there were suitable ones in the left. Those. you get in the selection all records from EVENTS, of which some of the records in the "access" column will have NULL.
explanation of join differences with pictures: www.skillz.ru/dev/php/article-Obyasnenie_SQL_obedi...

Answer 2

Exactly the same problem. Failed to cope?