Skip to content
This repository was archived by the owner on Jan 23, 2026. It is now read-only.
This repository was archived by the owner on Jan 23, 2026. It is now read-only.

aci-endpoint-tracker MySql create table #196

@JMSrulez

Description

@JMSrulez

Hi experts,

In setup documentation for aci-endpoint-tracker, there is a display of mysql 5.6.22

I just install a new linux (Fed24) with 5.7.13
When starting aci-endpoint-tracker, it CREATE TABLE enpoints, with 2 TIMESTAMP fields and mysql pop an error.

To let it run, I had to modify : timestop TIMESTAMP DEFAULT NOW()

LIne 93 - aci-endpoint-tracker.py :
c.execute('''CREATE TABLE IF NOT EXISTS endpoints (
mac CHAR(18) NOT NULL,
ip CHAR(16),
tenant CHAR(100) NOT NULL,
app CHAR(100) NOT NULL,
epg CHAR(100) NOT NULL,
interface CHAR(100) NOT NULL,
timestart TIMESTAMP NOT NULL,
timestop TIMESTAMP DEFAULT NOW());''')

As I have no clue what is the usage of this timestop field, may be NOW() is not so good default value.
I also tested NULL as default value, it start to run and feed the data into table endpoint but crash later, in a second run.
If anyone can help, you are welcome.

BR, JM

Metadata

Metadata

Assignees

No one assigned

    Labels

    No labels
    No labels

    Type

    No type

    Projects

    No projects

    Milestone

    No milestone

    Relationships

    None yet

    Development

    No branches or pull requests

    Issue actions