The Mosquitto Go Auth Plugin information is now incorrect. The method for installing the plugin has recently changed; IMO, the user should be directed to follow the instructions on the plugin's git repo instead of reproducing the same here.
Additionally, the SQL statements the user is instructed to put in the configuration file (mosquitto-go-auth.conf) are now incorrect. You must substitute the "username" field with "email". E.g.: select password_hash from "user" where username = $1 and is_active = true limit 1 becomes select password_hash from "user" where email = $1 and is_active = true limit 1