I've now tried doing this and have finally managed to get it to work. A couple of things:
You need to run postmap on all of the tables that you create. That is missing from the documentation.
The password that you need to use is, confusingly, *not* the 'mail password' that kpasswd.freebsd.org gives you (what is that for?). It would be good to clarify that...