Dear List, I'm currently figuring out a way to ease the Provisioning of Domains and Settings towards Baruwa.
Currently when I create a Domain trough Postfix.Admin a 2nd Insert is done into DSPAMs Database, same happens when I create a Users Mailbox. What I could gather from the DB so far to create a new Baruwa Domain would be the following: While creating a New Mailbox Admin: INSERT INTO `auth_user` (`id`, `username`, `first_name`, `last_name`, `email`, `password`, `is_staff`, `is_active`, `is_superuser`, `last_login`, `date_joined`) VALUES (1, '<login-name-of-admin>', '<first-name-of-admin>', '<last-name-of-admin>', '<email-of-admin>', 'sha1(password)', 1, 1, 1, '2011-01-05 17:00:05', '2011-01-05 17:00:05'), INSERT INTO `profiles` (`id`, `send_report`, `scan_mail`, `sa_high_score`, `sa_low_score`, `account_type`, `user_id`) VALUES (1, 1, 1, 5, 2, 3, <id-of-auth_user>), When adding the new Domain: INSERT INTO `user_addresses` (`id`, `address`, `enabled`, `user_id`, `address_type`, `load_balance`) VALUES [What does "load_balance" do btw?] (1, 'domain.com', 1, <id-of-auth_user>, 1, 1), INSERT INTO `mail_hosts` (`id`, `address`, `enabled`, `port`, `useraddress_id`) VALUES (1, 'ip.of.default.mailbox.host', 1, 25, <id-of-auth_user>), INSERT INTO `auth_hosts` (`id`, `address`, `protocol`, `port`, `enabled`, `split_address`, `useraddress_id`) VALUES (1, 'ip.of.mailbox.host', 2, 143, 1, 0, <id-of-auth_user>); I'm thinking of merging my Mailservers Database with Baruwa in Order to use foreign keys on Domain ID and Mailadmins, that way I could also auth the Mail/Baruwa Users from the same Database, its no big hassle to auth them trough imap but its still slower than the Database. Kind regards Christian Keil _______________________________________________ Baruwa mailing list [email protected] http://lists.baruwa.org/mailman/listinfo/baruwa
