I need to add about 800 users to dbmail and I have an MS Access mdb with user, domain and password.
I am expecting to just do an SQL insert to dbmail_users table in postgresql and then do an SQL insert to dbmail_aliases table, using the user_idnr from dbmail_users as the deliver_to column in dbmail_aliases. I would like to use plain text as the encryption_type. Some existing records have '' for encryption_type column in dbmail_users. Is this the right way to represent plain text as the encryption_type choice? I assume the client_idnr column of dbmail_users table is for the "group" - and that I can set it to 1 for now. Has anyone else done this type of mass user import, any tips or warnings, something I'm not thinking of? I have not been able to find related info in the archives or googling. I have been using an early version of dbmail 2 for about 3 months on a few domains. I upgraded to the latest 2.01 "testing" debian package today and am ready to expand our usage of dbmail with the additional users today. Thank you, - April
