List Info

Thread: Question (newsletter - Virtual - Virtusertable - ACLs)




Question (newsletter - Virtual - Virtusertable - ACLs)
user name
2005-12-14 19:33:00
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 systemnewsthedomain.tld 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://db
ma.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.h
tm#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 
*somedomain.tld

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" <SimonGidentrica.com>
To: "DBMail mailinglist" <dbmaildbmail.org>
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
> Dbmaildbmail.org
> htt
ps://mailman.fastxs.nl/mailman/listinfo/dbmail
> 

_______________________________________________
Dbmail mailing list
Dbmaildbmail.org
htt
ps://mailman.fastxs.nl/mailman/listinfo/dbmail
[1]

about | contact  Other archives ( Real Estate discussion Medical topics )