Hi, ive been using dbmail for a while and find it to be a excelent way of storing mails... im very happy with the application... Currently im developing a web interface to administer dbmail accounts and i was thinking of a feature that could be useful. i havent found anything in the docs about this so i thought id mail this list and see if anyone else know how to solve this.. The feature im talking about is mail groups... lets pretend we have a number of users... named something like john, dan, mike, jordan, lisa and kevin and they have there aliases set to <name>@somedomain.com what i want to do is to be able to create one or more groups that makes me able to add john jordan and kevin to that group and give them an alias, something like [EMAIL PROTECTED], and by mailing to that mail adress, those 3 will recieve a copy of the mail with headers intact. if this feature doesnt exist the best way i think to go about this is to patch dbmail-smtpd and have it perform the following logic when a mail arrives to dbmail-smtpd have it try to deliver it normaly first, tho ignoring the "catch all" alias. groups arent mailed that often so there wouldnt be much of a speed loss here, but if it cant find anyone to deliver to it would check the table groups CREATE TABLE groups ( group_id bigint(21) NOT NULL auto_increment, group_name varchar(150) default NULL, PRIMARY KEY (group_id), UNIQUE KEY group_id (group_id) ) TYPE=MyISAM;
and try to match the group name. the group_name column would be in the format [EMAIL PROTECTED] (or something like that?) If theres no match there dbmail-smtpd would deliver to the "catch all" alias (if any) but if dbmail-smtpd do find a match it should check a lookup table. CREATE TABLE group_user ( group_idnr bigint(21) default NULL, user_idnr bigint(21) default NULL ) TYPE=MyISAM; this table has only 2 fields, and this table is needed because you should be able to be in 1 or more groups at the same time, so this is the most storage efficient way to do it... after dbmail-smtpd has got the list of user_idnr that is members of that group it should deliver to those users as normal, without changing the to field... As i said before i dont know if theres any good way to do it in dbmail already, if so please let me know... if not im looking for someone that has the ability to create a patch for dbmail-smtpd. I have never coded C/C++ before thats why i need help on this. Im hoping for someone that thinks this is a good idea and want to help out. Thanks to the dbmail developers for a excelent application.
