On 05 Jan 2011, at 6:13 PM, Christian Keil wrote: > > > 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'),
You need a salted SHA1 i do not think mysql's SHA1 implementation supports that you may have to write a custom function. > > 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), Its a flag to indicate how to handle deliveries to the final destination if they domain has more than one destination server. 1 = Load balance between destination servers 0 = Only try lower servers if the first fails > > INSERT INTO `mail_hosts` (`id`, `address`, `enabled`, `port`, > `useraddress_id`) VALUES > (1, 'ip.of.default.mailbox.host', 1, 25, <id-of-auth_user>), No that maps to id-of-domain-name (user_addresses) > > 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>); No that maps to id-of-domain-name (user_addresses) > > -- Baruwa - www.baruwa.org _______________________________________________ Baruwa mailing list [email protected] http://lists.baruwa.org/mailman/listinfo/baruwa
