For anyone struggling with IVMS -> MYSQL coennection. Your best bet would be to try Hikcentral instead. Has more options especially on type of data you can correct, support more databases including Postgres and to ice it all, the integration is very straight forward. The base license comes with access control feature installed.