It's on the wiki. The cidr_acl might work in this case, but it won't let me customize the error message to the client.
The assumption is that I have some business logic that says: "Customer didn't pay this month, lock their account so they can't get their email, but let other still send SMTP to them." So I would like a status field that I can alter which will cause POP/IMAP/SMTP to display some customizable message much like Postfix does. That way the POP client will display the message "You can't get your Email because you need to pay your account." Rather than just, "Account not found." Which just leads to a phone call by the user and our support staff telling them the same thing. (This is under the assumption users ALWAYS read their error messages.) If I had customizable SQL, I can get half way there, by writing my own function to check the account status and then give back a user_idnr of the valid address or NULL to act like the account doesn't exist. Granted, I'm about to be doing this now and just altering the SQL directly in the code. I agree it's a slipery slope, the more customizable the more chance for disaster, so I'll understand if it's not some place you want to go. People like me can just piddle in the code and bring upon our own doom, the beauty of open source. -- David A. Niblett | email: [EMAIL PROTECTED] Network Administrator | Phone: (352) 334-3400 Gainesville Regional Utilities | Web: http://www.gru.net/ -----Original Message----- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Paul J Stevens Sent: Monday, October 23, 2006 3:08 PM To: DBMail mailinglist Subject: Re: [Dbmail] subdomains in the alias table Niblett, David A wrote: > Stevens, Paul J wrote: >> Am I working on that? Wasn't aware of it :-) > > I guess you aren't, but I still wish you would. I've had thoughts of > creating a stored proceedure/function to do some processing based on > customer account status and if valid I would return the user_idnr, > otherwise, pretend they don't exist. > > I'll probably end up modifying the code, but I do something like that > in FreeRadius and being able to just set the select query in the > config file is helpful. > > I thought we talked about this once and you said you might add that > ability. Refresh my memory. What are you trying to do. Last time you had problems like this we ended up with usermap/cidr_acl, and that's a pretty cool feature. > > Even cooler would be customizable responses for say the POP and IMAP > servers to say "Hey deadbeat pay your bill and I'll give you your > Email." (I'm sure marketing would approve that.) A logical extension. David, please document ideas like this on the wiki. -- ________________________________________________________________ Paul Stevens paul at nfg.nl NET FACILITIES GROUP GPG/PGP: 1024D/11F8CD31 The Netherlands________________________________http://www.nfg.nl _______________________________________________ DBmail mailing list DBmail@dbmail.org https://mailman.fastxs.nl/mailman/listinfo/dbmail
