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