Whether the modified tables takes effect immediately

Question

Whether the modified tables takes effect immediately

moluzhui opened this issue 5 years ago · 3 comments

auth mysql has two tables including mqtt_user and mqtt_acl. My attempts to add new users took effect immediately, but the access and topic changes to the acl didn't seem to take effect immediately. Whether some fields of both tables need to be restarted by the emqx or reload plug-in, or whether the broker needs to be reconnected to make changes to the database take effect?

Answer 1 · 2019-11-19T06:05:11.000Z

Hi @moluzhui In the emqx.conf, we enable ACL cache by default:

enable_acl_cache = on

So, it can not works immediately after modified ACL rows

Answer 2 · 2019-11-19T11:09:55.000Z

So, if I set enable_acl_cache to off, does the modify table implementation take effect in time, or do I need to change some other configuration?

Answer 3 · 2019-11-21T14:56:38.000Z

No, Just turn off theenable_acl_cache option