Re: [Dbmail] Postfix + dbMail + smtp auth
You can do that just telling saslauthd to look for the db and tables and fields that you specify - Original Message - From: Dave Williams To: dbmail@dbmail.org Sent: Wednesday, January 25, 2006 2:29 PM Subject: [Dbmail] Postfix + dbMail + smtp auth I have dbmail working great with postfix-mysql to check for aliases using your instructions on setting up sql-recipients.cf and adding the following to mail.cf : Local_recipient_maps=mysql:/etc/postfix/sql-recipients.cf My question: It seems like there should be a similar way to do smtp authentication. But every example that I can google requires pam-mysql and SASL/SMTP-AUTH. Is there an easier way to have postfix directly query dbmail? Thanks, Dave -- ___ Dbmail mailing list Dbmail@dbmail.org https://mailman.fastxs.nl/mailman/listinfo/dbmail
Re: [Dbmail] announce: dbmail-2.0.8
Hi Paul, Should i upgrade from 2.0.7 to 2.0.8 ? :P Jorge - Original Message - From: "Paul J Stevens" <[EMAIL PROTECTED]> To: "DBMail mailinglist" Sent: Wednesday, January 25, 2006 3:55 PM Subject: [Dbmail] announce: dbmail-2.0.8 -BEGIN PGP SIGNED MESSAGE- Hash: SHA1 Dbmail 2.0.8 released This is mostly a bugfix release with some minor additional features. * added ON UPDATE CASCADE to create_table files * do not close database connection on startup (closes: #271) * change dbmail_messageblks.messageblk from longtext to longblob in mysql create scripts * fix incorrect quoting in quoted_string_out (closes: #204) * added CHILDREN capability * enable QUOTA in CAPABILITY - -- Paul Stevens paul at nfg.nl NET FACILITIES GROUP GPG/PGP: 1024D/11F8CD31 The Netherlandshttp://www.nfg.nl -BEGIN PGP SIGNATURE- Version: GnuPG v1.4.2 (GNU/Linux) Comment: Using GnuPG with Thunderbird - http://enigmail.mozdev.org iD8DBQFD159w8iITvBH4zTERAhFqAJsHnJFUzm9Ek3Bmu+qbZqaqT/90zQCgt1XL hmEQlVzCdd7FlN3yawSOTTg= =oYJx -END PGP SIGNATURE- ___ Dbmail mailing list Dbmail@dbmail.org https://mailman.fastxs.nl/mailman/listinfo/dbmail
[Dbmail] announce: dbmail-2.0.8
-BEGIN PGP SIGNED MESSAGE- Hash: SHA1 Dbmail 2.0.8 released This is mostly a bugfix release with some minor additional features. * added ON UPDATE CASCADE to create_table files * do not close database connection on startup (closes: #271) * change dbmail_messageblks.messageblk from longtext to longblob in mysql create scripts * fix incorrect quoting in quoted_string_out (closes: #204) * added CHILDREN capability * enable QUOTA in CAPABILITY - -- Paul Stevens paul at nfg.nl NET FACILITIES GROUP GPG/PGP: 1024D/11F8CD31 The Netherlandshttp://www.nfg.nl -BEGIN PGP SIGNATURE- Version: GnuPG v1.4.2 (GNU/Linux) Comment: Using GnuPG with Thunderbird - http://enigmail.mozdev.org iD8DBQFD159w8iITvBH4zTERAhFqAJsHnJFUzm9Ek3Bmu+qbZqaqT/90zQCgt1XL hmEQlVzCdd7FlN3yawSOTTg= =oYJx -END PGP SIGNATURE-
[Dbmail] Postfix + dbMail + smtp auth
I have dbmail working great with postfix-mysql to check for aliases using your instructions on setting up sql-recipients.cf and adding the following to mail.cf : Local_recipient_maps=mysql:/etc/postfix/sql-recipients.cf My question: It seems like there should be a similar way to do smtp authentication. But every example that I can google requires pam-mysql and SASL/SMTP-AUTH. Is there an easier way to have postfix directly query dbmail? Thanks, Dave
Re: [Dbmail] dbmail.m4 for dbmail-lmtp
Never mind, I've attached the one I created.
Include it in sendmail.mc with:
MAILER('dbmail-lmtp')
and mailertable:
mydomaindbmail-lmtp:[my_lmtp_host]
default port is 24, if it should differ you must edit the m4 file.
Kind regards,
Marc Dirix
On Wed, Jan 25, 2006 at 02:21:55PM +0100, Marc Dirix wrote:
> Can someone help me out creating a dbmail.m4 file
> which provides dbmail-lmtp to sendmail?
>
> As descibed here:
> http://www.dbmail.org/dokuwiki/doku.php?id=sendmail_howto
>
> I want to use a different server running dbmail as sendmail, and have
> sendmail communicate directly to its lmtp socket.
>
> Kind regards,
>
> Marc
> ___
> Dbmail mailing list
> Dbmail@dbmail.org
> https://mailman.fastxs.nl/mailman/listinfo/dbmail
PUSHDIVERT(-1)
# 2003 Chrysalink Systems
# Send feedback to [EMAIL PROTECTED]
# 2006 Marc Dirix (dbmail-lmtp)
# Send feedback to [EMAIL PROTECTED]
ifdef(`DBMAIL_MAILER_PATH',,
`ifdef(`DBMAIL_PATH',
`define(`DBMAIL_MAILER_PATH', DBMAIL_PATH)',
`define(`DBMAIL_MAILER_PATH', [IPC])')')
_DEFIFNOT(`DBMAIL_MAILER_FLAGS', `AhmXz5@/:|')
ifdef(`DBMAIL_MAILER_ARGS',,
`define(`DBMAIL_MAILER_ARGS', `TCP $h 24')')
POPDIVERT
##*##
### DBMAIL Mailer specification ###
##*##
VERSIONID(`$Id: dbmail.m4,v 8.23 2005/01/25 14:48:51 dirix Exp $')
Mdbmail-lmtp, P=DBMAIL_MAILER_PATH, F=_MODMF_(CONCAT(`DFM',
DBMAIL_MAILER_FLAGS), `DBMAIL'), S=EnvFromSMTP/HdrFromSMTP,
R=EnvToSMTP/HdrFromSMTP,
ifdef(`DBMAIL_MAILER_MAX', `M=DBMAIL_MAILER_MAX,
')T=DNS/RFC822/X-Unix,
A=DBMAIL_MAILER_ARGS
[Dbmail] dbmail.m4 for dbmail-lmtp
Can someone help me out creating a dbmail.m4 file which provides dbmail-lmtp to sendmail? As descibed here: http://www.dbmail.org/dokuwiki/doku.php?id=sendmail_howto I want to use a different server running dbmail as sendmail, and have sendmail communicate directly to its lmtp socket. Kind regards, Marc
Re: [Dbmail] using dbmail
> 1. how i can setup the MUA like outlook or MS outlook? > because outlook ask for password before access the dbmail server. In Outlook or Outlook express you need to setup a new mail account, and point it to the server running dbmail. Here you select the protcol you want to use, pop3 or imap. You use the username and password you setup in the dbmail with dbmail-users. That should be all to it > > 2. can i send mail to user in dbmail using linux command MAIL from the > dbmail server itself if yes please tell me how. > regards. I run sendmail from the commandline like I normally do. dbmail-smtp should also work, however you can only send emails to the user which are in your dbmail system. echo "message" |dbmail-smtp -u user -m mailbox Kind regards, Marc
Re: [Dbmail] using dbmail
Hi Marc,
I did all you mentioed before that and i can add users to dbmail but the
problem is:
1. how i can setup the MUA like outlook or MS outlook?
because outlook ask for password before access the dbmail server.
2. can i send mail to user in dbmail using linux command MAIL from the
dbmail server itself if yes please tell me how.
regards.
Khalid
From: Marc Dirix <[EMAIL PROTECTED]>
Reply-To: [EMAIL PROTECTED],DBMail mailinglist
To: DBMail mailinglist
Subject: Re: [Dbmail] using dbmail
Date: Tue, 24 Jan 2006 11:24:29 +0100
There is an dbmailer.m4.
http://www.helgrim.com/dbmaildocs/files/dbmail.m4
You can put this in your /usr/share/sendmail/cf/mailer
and include in sendmail.mc :
MAILER('dbmail')
In mailertable you can add something like:
mydomaindbmail:mydomain
Or remove the MAILER('local') completely.
Secondly you can use the dbmailer-lsmtp
which is acts as a "local" smtp server to which you can forward the
mail.
Kind regards,
Marc Dirix
On Tue, Jan 24, 2006 at 10:07:35AM +, khalid hussein wrote:
> Hi all,
> i installed dbmail, but i don't know how i can use it, i can add new
user
> but i don't khnow how i can send mail to this user either using mail
> command line or from other MUA, i use sendmail+pop3 for my mail server
and
> is running well, please help me if there any additional configuration
for
> configuration files for the old mail server, and how i can use dbmail
> server for domains the host with running dbmail part of this domains.
> thanks
>
>
> ___
> Dbmail mailing list
> Dbmail@dbmail.org
> https://mailman.fastxs.nl/mailman/listinfo/dbmail
___
Dbmail mailing list
Dbmail@dbmail.org
https://mailman.fastxs.nl/mailman/listinfo/dbmail
Re: [Dbmail] using dbmail
> Do you mean lmtp as in dbmail-lmtp? Yes.
Re: [Dbmail] Warnings when closing in on quota?
Tommi Lätti wrote: > M. J. [Mike] OBrien wrote: > >> Hi Tommi: >> MUA solution. DBMail IMAPD supports RFC 2087 IMAP quotas. A >> script should not be hard to do but would be super expensive on large >> systems to maintain a real time polling of quotas. That's why the >> protocol sets out methods for doing this from the MUA so that it is >> done per-user on an as-needed query/response from the MUA to the server. > > > AFAIK dbmail doesn't really support quota (doesn't do any calculations > per box) but still reports the capability. Thunderbird shows the quota > when you take properties from you inbox (works with cyrus) but when > connecting to dbmail, it just says 'quota not supported' I just tested by adding QUOTA to the CAPABILITY string in imap4.h, and now tb will happily show quota usage. Dbmail does not support the SETQUOTA command, but other than that quota support is complete, albeit limited to a single quotaroot "". Adding SETQUOTA seems to me like a security problem: why use quota when users can override there own quota? Perhaps someone can tell me how cyrus does this. -- Paul Stevens paul at nfg.nl NET FACILITIES GROUP GPG/PGP: 1024D/11F8CD31 The Netherlandshttp://www.nfg.nl
Re: [Dbmail] Warnings when closing in on quota?
M. J. [Mike] OBrien wrote: Hi Tommi: MUA solution. DBMail IMAPD supports RFC 2087 IMAP quotas. A script should not be hard to do but would be super expensive on large systems to maintain a real time polling of quotas. That's why the protocol sets out methods for doing this from the MUA so that it is done per-user on an as-needed query/response from the MUA to the server. AFAIK dbmail doesn't really support quota (doesn't do any calculations per box) but still reports the capability. Thunderbird shows the quota when you take properties from you inbox (works with cyrus) but when connecting to dbmail, it just says 'quota not supported' In my experience, users usually know when they are aproaching excessive storage because for one thing, their account is sluggish. When Thunderbird has 17000 headers to display, the user knows things are getting FULL.. :o) Yeah but my customers are not the sharpest knifes in the box so a couple of times already they've run into their quota and then wonder why they're not receiving any mail. Until their customer calls them that the mail bounced with message 'your mailbox is full' Perhaps you imagine something like GMAIL or HOTMAIL's slide-bar indicators of how much mail is in storage vs quota. That would be a nice desktop MUA feature. I have written proprietary front ends (web mail) and socially engineered communications systems which have used a 'quota report' just as does the Yahoo and Hotmail GUIs. I can well see why it is not a popular feature for mail clients. Not really. I'm not such a huge fan of webmail. I do give it out for those challenged people taking vacation in Bahamas and want to check their mail from the nearest internet cafe... DbMailAdministrator http://www.dbma.ca enables Administrators to spot over-quota users in a heartbeat and then send the user a message or freeze the account. Is this a new feature? :) I'm running v2.3.3 on that server... should I read the docs? -- br, Tommi
Re: [Dbmail] Warnings when closing in on quota?
Hi Tommi: MUA solution. DBMail IMAPD supports RFC 2087 IMAP quotas. A script should not be hard to do but would be super expensive on large systems to maintain a real time polling of quotas. That's why the protocol sets out methods for doing this from the MUA so that it is done per-user on an as-needed query/response from the MUA to the server. In my experience, users usually know when they are aproaching excessive storage because for one thing, their account is sluggish. When Thunderbird has 17000 headers to display, the user knows things are getting FULL.. :o) Perhaps you imagine something like GMAIL or HOTMAIL's slide-bar indicators of how much mail is in storage vs quota. That would be a nice desktop MUA feature. I have written proprietary front ends (web mail) and socially engineered communications systems which have used a 'quota report' just as does the Yahoo and Hotmail GUIs. I can well see why it is not a popular feature for mail clients. DbMailAdministrator http://www.dbma.ca enables Administrators to spot over-quota users in a heartbeat and then send the user a message or freeze the account. Just another view from another pair of eyes :o) best... Mike A003 getquotaroot "INBOX" * QUOTAROOT "INBOX" "" * QUOTA "" (STORAGE 38219 97656) GETQUOTAROOT completed - Original Message - From: "Tommi Lätti" <[EMAIL PROTECTED]> To: "DBMail mailinglist" Sent: Tuesday, January 24, 2006 11:44 PM Subject: [Dbmail] Warnings when closing in on quota? I've set some quotas for users and I noticed that there's no functionality inside dbmail to warn the user about the quota getting close to full. Is there any workaround that people use? Maybe a script or something? -- br, Tommi ___ Dbmail mailing list Dbmail@dbmail.org https://mailman.fastxs.nl/mailman/listinfo/dbmail
Re: [Dbmail] Warnings when closing in on quota?
Hi Tommi: MUA solution. DBMail IMAPD supports RFC 2087 IMAP quotas. A script should not be hard to do but would be super expensive on large systems to maintain a real time polling of quotas. That's why the protocol sets out methods for doing this from the MUA so that it is done per-user on an as-needed query/response from the MUA to the server. In my experience, users usually know when they are aproaching excessive storage because for one thing, their account is sluggish. When Thunderbird has 17000 headers to display, the user knows things are getting FULL.. :o) Perhaps you imagine something like GMAIL or HOTMAIL's slide-bar indicators of how much mail is in storage vs quota. That would be a nice desktop MUA feature. I have written proprietary front ends (web mail) and socially engineered communications systems which have used a 'quota report' just as does the Yahoo and Hotmail GUIs. I can well see why it is not a popular feature for mail clients. DbMailAdministrator http://www.dbma.ca enables Administrators to spot over-quota users in a heartbeat and then send the user a message or freeze the account. Just another view from another pair of eyes :o) best... Mike A003 getquotaroot "INBOX" * QUOTAROOT "INBOX" "" * QUOTA "" (STORAGE 38219 97656) GETQUOTAROOT completed - Original Message - From: "Tommi Lätti" <[EMAIL PROTECTED]> To: "DBMail mailinglist" Sent: Tuesday, January 24, 2006 11:44 PM Subject: [Dbmail] Warnings when closing in on quota? I've set some quotas for users and I noticed that there's no functionality inside dbmail to warn the user about the quota getting close to full. Is there any workaround that people use? Maybe a script or something? -- br, Tommi ___ Dbmail mailing list Dbmail@dbmail.org https://mailman.fastxs.nl/mailman/listinfo/dbmail
[Dbmail] Warnings when closing in on quota?
I've set some quotas for users and I noticed that there's no functionality inside dbmail to warn the user about the quota getting close to full. Is there any workaround that people use? Maybe a script or something? -- br, Tommi
Re: [Dbmail] Hardware Requirement
Tom Hancock wrote: We are strongly considering deploying a Postfix/Dbmail email solution. We will have 4 servers that will be running postfix, dbmail, and other ISP related applications. They will use a backend server for the database storage. The backend server will be running MySQL for Dbmail storage and NFS for some other applications. I do not envision NFS being heavily utilized. We currently have approximately 2500 email accounts that get spam/virus filtered through Postini. What hardware requirements would you recommend for the backend MySQL/NFS server? In particular I am interested in CPU and RAM requirements. Well, never skimp on the RAM because it's dirt cheap. If you have a budget, get more ram up to the point when it is economically feasible after you've selected the rest of the hardware. For the database, I'd use some 2-way dual core solution, Opterons really shine in this area (and there are price cuts coming in one month for the 275 model). Front end machines could be some 1-way dual core with dual gigabit NIC's. Since the dual cores don't really cost any more than a reasonably fast single core, I'd go for them in any server installation. DBMail spawns like apache prefork so it will take full advantage of extra cpu's in system without expensive context switching. For storage on the db server, you can choose the expensive way and take some biggie scsi disks and put them on reasonable raid (not raid5) and have a second raid-0 for transaction logs etc. If you want to go into more economic way, take a look at western digital server edition sata hd's, they're qualified for 24/7 operation. For the fast raid0 partition, take 2 or more from the new 10krpm 150G series. They do fly. Have another el cheap db server doing just replication for backup purposes. -- br, Tommi
Re: [Dbmail] using dbmail
On 1/24/06, Marc Dirix <[EMAIL PROTECTED]> wrote:
>
> There is an dbmailer.m4.
>
> http://www.helgrim.com/dbmaildocs/files/dbmail.m4
>
> You can put this in your /usr/share/sendmail/cf/mailer
>
> and include in sendmail.mc :
>
> MAILER('dbmail')
>
> In mailertable you can add something like:
>
> mydomaindbmail:mydomain
>
> Or remove the MAILER('local') completely.
>
> Secondly you can use the dbmailer-lsmtp
> which is acts as a "local" smtp server to which you can forward the
> mail.
Do you mean lmtp as in dbmail-lmtp?
Kind regards,
>
> Marc Dirix
>
>
> On Tue, Jan 24, 2006 at 10:07:35AM +, khalid hussein wrote:
> > Hi all,
> > i installed dbmail, but i don't know how i can use it, i can add new
> user
> > but i don't khnow how i can send mail to this user either using mail
> > command line or from other MUA, i use sendmail+pop3 for my mail server
> and
> > is running well, please help me if there any additional configuration
> for
> > configuration files for the old mail server, and how i can use dbmail
> > server for domains the host with running dbmail part of this domains.
> > thanks
> >
> >
> > ___
> > Dbmail mailing list
> > Dbmail@dbmail.org
> > https://mailman.fastxs.nl/mailman/listinfo/dbmail
> ___
> Dbmail mailing list
> Dbmail@dbmail.org
> https://mailman.fastxs.nl/mailman/listinfo/dbmail
>
