Skip to content

Add a few columns to the dot1x feature #122

Description

@JorisFRST

New feature :

Add a column "Assigned VLAN" from : 1.3.6.1.4.1.9.9.656.1.4.1.1.22 (cafSessionVlanGroupName)
Add a column "Authorized by" from : .1.3.6.1.4.1.9.9.656.1.4.1.1.12 (cafSessionAuthorizedBy)

In our implementation we mostly use 802.1x to set the vlan or diver to a guest vlan.
Having this in the mac track view would be a good addition.

Activity

  1. jpobeda commented on Jan 5, 2020

    @jpobeda
    Contributor

    @JorisFRST , just out of curiosity, what do you get when walking those OIDs?

    I also assign VLANs from Radius and I only get either an empty STRING or Authentication Server.

    I've only contributed the dot1x/Snooping bit of this plugin, and I barely remember how it works but you should be able to see VLAN Id/Names values under the "MAC Address" tab.

    Since the data should be already collected It might be a matter of linking the Device/PortName on dot1x tab to Device/Port Number on MAC Address tab? Maybe?

    It was a bit complicated to get it do work since most of the MIBs were half implemented by Cisco and not very consistent across their own platforms. So I ended up grabbing OIDs from different MIBs that would work across all or most of the platforms. I believe the most complete one was the one used by ISE.......couldn't test it tho

  2. JorisFRST commented on Jan 6, 2020

    @JorisFRST
    ContributorAuthor

    On a stack of 3850's I get this response for the Vlan
    .1.3.6.1.4.1.9.9.656.1.4.1.1.22
    SNMPv2-SMI::enterprises.9.9.656.1.4.1.1.22.8.48.65.54.53.53.68.50.65.48.48.48.50.68.50.53.65.55.57.67.51.65.66.48.54 = STRING: "General_Access"

    Which is the correct assigned vlan name in radius for our environment.

    For the AuthorizedBy I get "Authentication Server."
    I think this is a field that would revert back to local or something similar. Have to do some more tests.

    On the 3850 also IP Information is "00 00 00 00" for every device (in the snmp walk)
    And the function never links the portname in the dot1x table. Not sure if this was already implemented.

    I can test against ISE and give you an output from snmpwalk ?

  3. TheWitness commented on Sep 16, 2020

    @TheWitness
    Member

    Pull request?

  4. jdcoats commented on Oct 20, 2020

    @jdcoats

    Add the assigned ACL too! @JorisFRST & @jpobeda to a fresh pull to test out todays changes. Thanks @TheWitness!

  5. JorisFRST commented on Oct 20, 2020

    @JorisFRST
    ContributorAuthor

    Todays changes fixed my display in the dot1x tab.
    Only one typo 'Authorization Succcess' instead of 'Authorization Success'

  6. JorisFRST commented on Oct 20, 2020

    @JorisFRST
    ContributorAuthor

    Also Port Name column is properly propagated now.

  7. TheWitness commented on Oct 20, 2020

    @TheWitness
    Member
    ALTER TABLE mac_track_dot1x MODIFY COLUMN port_name int(10) unsigned NOT NULL default '0';

    Likely change it to "ifIndex" at some point.

  8. jdcoats commented on Oct 20, 2020

    @jdcoats

    @TheWitness port_number not port_name?
    ALTER TABLE mac_track_dot1x MODIFY COLUMN port_number int(10) unsigned NOT NULL default '0';

  9. TheWitness commented on Oct 20, 2020

    @TheWitness
    Member

    Yea, port_name, which should be ifIndex, that will happen too. (at some point).

  10. jdcoats commented on Oct 20, 2020

    @jdcoats

    okay, I have no column port_name.

    MariaDB [cacti]> show columns from mac_track_dot1x;
    +--------------+------------------+------+-----+---------------------+-------+
    | Field        | Type             | Null | Key | Default             | Extra |
    +--------------+------------------+------+-----+---------------------+-------+
    | site_id      | int(10) unsigned | NO   | PRI | 0                   |       |
    | device_id    | int(10) unsigned | NO   | MUL | 0                   |       |
    | hostname     | varchar(40)      | NO   | MUL |                     |       |
    | device_name  | varchar(100)     | NO   |     |                     |       |
    | username     | varchar(100)     | NO   | MUL |                     |       |
    | domain       | int(10) unsigned | NO   |     | 0                   |       |
    | status       | int(10) unsigned | NO   |     | 0                   |       |
    | port_number  | int(10) unsigned | NO   | MUL | 0                   |       |
    | mac_address  | varchar(20)      | NO   | PRI |                     |       |
    | ip_address   | varchar(20)      | NO   | PRI |                     |       |
    | dns_hostname | varchar(200)     | YES  |     |                     |       |
    | scan_date    | timestamp        | NO   | PRI | 0000-00-00 00:00:00 |       |
    +--------------+------------------+------+-----+---------------------+-------+
    12 rows in set (0.001 sec)
    
  11. jdcoats commented on Oct 20, 2020

    @jdcoats

    I don't even see a create in mactrack.sql for mac_track_dot1x, Did someone pull it out and I just happen to have it left over from a previous version?

  12. TheWitness commented on Oct 20, 2020

    @TheWitness
    Member

    port_number.

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment

Metadata

Metadata

Assignees

No one assigned

    Projects

    No projects

      Milestone

      No milestone

      Relationships

      None yet

      Development

      No branches or pull requests

      Issue actions