Uhm, my response was an answer not a question :) -----Original Message----- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of M. J. [Mike] OBrien Sent: 14 December 2005 19:33 To: DBMail mailinglist Subject: [Dbmail] Question (newsletter - Virtual - Virtusertable - ACLs)
Simon Gray >> I wonder, if i want to send a news letter, this is an example > is just send an email telling that the server will be in mainteinence in > day X at hour Y how can i send an email to all dbmail users? Does it has > anything to do with the user "everyone" that is in dbmail-users How can i > do it? Hi Simon Gray; The simple requirement you refer to is a function of ALL popular MTAs. In the case of a DBMail system both the MTA and MDA have built-in capability to do what you want - DBMail does it better! 1) Using DBMAIL: ------------------------------ For small business operations I always create an alias in DBMail for each new user called [EMAIL PROTECTED] and then send newsletters to user systemnews. In the case of one larger corporate property I give accounting dept an extra alias called finance.news; human resources an extra alias called hr.news and so on. We have over 30 newsletter categories. All I do is send the pertinent newsletter to one account and DbMail does a great job of delivery. For things like employee/HR structures I create aliases for people appointed to the "Christmas Committe" or "Silver Anniversary" committee etc... you get the picture. I use http://DBMA.ca to add / remove single/wholesale aliases etc. The newsletter editors, committee chairman etc send one newsletter to their assigned 'special' username and Dbmail delivers the required copies. *Nice*. DBMail is completely awesome for this kind of thing. (Another way to do this is to add an alias to every account for a sub-domain like "newsletter.maindoman.tld") and then use DBMA with one click of a button (http://dbma.ca/screenshots/screenshot19.htm) to add a 'newsletter alias' for every member of any or all account groups.) Or.. Using DBMAIL ACLs (much more sophisticated, modern and polite!!) You need to understand ACLs. So your users to a small extent. If you are not IMAP people, forget this. Under the _Public_ folder, create a folder called "News" and give the 'newsletter message' to anybody under that folder. If all your users are using Outlook Express, it sucks for shared folders. It works but it sucks. Read here to see how to make it (force it) work http://library.mobrien.com/dbmailadministrator/demo/dbmailadministrator/ DBMA_help.htm#acl This link will also teach you about ACLs. Or, 2) Using MTA: --------------------------- Create a virtual table row that sends any mail for @somedomain.tld to [EMAIL PROTECTED] The virtualtable is called "virtual" in postfix, "virtusertable" in sendmail etc. In sendmail you must rebuild your host.blah.mc to a host.blah.cf etc. In Postfix check your main.cf to see how you read your virtual table. In any case you *only* change the 'virtual' table and postfix will catch up. There is a huge performance penalty on a live production server if you do "postfix reload".. best... Mike ----- Original Message ----- From: "Simon Gray" <[EMAIL PROTECTED]> To: "DBMail mailinglist" <[email protected]> Sent: Wednesday, December 14, 2005 12:09 PM Subject: RE: [Dbmail] Question Hi Jorge, >I wonder, if i want to send a news letter, this is an example is just send an >email telling that the server will be in mainteinence in day X at hour Y, how >can i send an email to all dbmail users? >Does it has anything to do with the user "everyone" that is in dbmail-users? >How can i do it? Run a script to output all the email addresses and for each one send an email to? Should be easily handled with a perl or php script (or whatever your preferred scripting language is). Generate the email. Connect to database, get list of users with an address. For each user send the email to. I'd suggest you limit your testing to just you to begin with, otherwise you could unintentionally send a bad email out to all your users (which I'm sure they wouldn't be very happy with). HTH S ------------------------------------------------------------------------ -------- > _______________________________________________ > Dbmail mailing list > [email protected] > https://mailman.fastxs.nl/mailman/listinfo/dbmail > _______________________________________________ Dbmail mailing list [email protected] https://mailman.fastxs.nl/mailman/listinfo/dbmail
