Re: [gentoo-user] postfix .. transports .. and virtual domains ..
On Thu, 19 Oct 2006 14:42:47 -0700 kashani [EMAIL PROTECTED] wrote: Henti Smith wrote: Hi guys, I've got a virtual domain setup for postfix working .. all good .. however I want to setup a spam@ and ham@ address for all domains in the virtual lookup table (mysql) to go via a transport to the script that procresses the mail. I've added the transport in main.cf transport_maps = pcre:/etc/postfix/dspam_lerning_transport.pcre local_recipient_maps = $transport_maps but I'm getting this when I try to send to [EMAIL PROTECTED] Recipient address rejected: User unknown in virtual mailbox table any ideas ? Depending on which virtual guide you followed your virtual domains are going to be under virtual_mailbox_domains rather than transport. I'd add the virtual aliases into the db for ham and spam, if you're using PostfixAdmin you can add spam and ham in as accounts that are created automatically wheneven a new domain is added. This does not work. mail gets delivered to maildir as per account setup not the transport service where it's being procesed for spam. All I really need to do is tell postfix to accept any mail for spam@ and ham@ I don't need it delivered anywhere as the transport works fine on localhost, it's just smtp deliveries that gives me problems. H -- Henti Smith [EMAIL PROTECTED] +27 82 958 2525 http://www.geekware.co.za DISCLAIMER : Unauthorised use of characters, images, sounds, odors, severed limbs, noodles, wierd dreams, strange looking fruit, oxygen, and certain parts of Jupiter are strictly forbidden. If I find you violating, or molesting my property in any way, I will employ a pair of burly convicts to find you, kidnap you, and perform god-awful sexual experiments on you until you lose the ability to sound out vowels. I don't know why you are still reading this, but by doing so you have proven that you have far too much time on your hands, and you should go plant a tree, or read a book or something. - http://www.ctrlaltdel-online.com/ -- gentoo-user@gentoo.org mailing list
Re: [gentoo-user] postfix .. transports .. and virtual domains ..
On Thu, 19 Oct 2006 23:53:40 +0100 Neil Bothwick [EMAIL PROTECTED] wrote: On Thu, 19 Oct 2006 19:25:07 +0200, Henti Smith wrote: however I want to setup a spam@ and ham@ address for all domains in the virtual lookup table (mysql) to go via a transport to the script that procresses the mail. Can't you do this with aliases? That's how I do it with dspam and postfix, using lines like this in /etc/mail/aliases spam: |'/usr/local/bin/dspam' --user --class=spam --source=error -mode=teft --deliver=innocent Aliases are ignored when using virtual tables. hence the error : User unknown in virtual mailbox table -- Henti Smith [EMAIL PROTECTED] +27 82 958 2525 http://www.geekware.co.za DISCLAIMER : Unauthorised use of characters, images, sounds, odors, severed limbs, noodles, wierd dreams, strange looking fruit, oxygen, and certain parts of Jupiter are strictly forbidden. If I find you violating, or molesting my property in any way, I will employ a pair of burly convicts to find you, kidnap you, and perform god-awful sexual experiments on you until you lose the ability to sound out vowels. I don't know why you are still reading this, but by doing so you have proven that you have far too much time on your hands, and you should go plant a tree, or read a book or something. - http://www.ctrlaltdel-online.com/ -- gentoo-user@gentoo.org mailing list
Re: [gentoo-user] postfix .. transports .. and virtual domains ..
Henti Smith wrote: This does not work. mail gets delivered to maildir as per account setup not the transport service where it's being procesed for spam. All I really need to do is tell postfix to accept any mail for spam@ and ham@ I don't need it delivered anywhere as the transport works fine on localhost, it's just smtp deliveries that gives me problems. If I read your original email right, you're using db driven virtual domains, mailboxes, and aliases for your users. Is that correct? Assuming it is then you'll need to shuffle mail around a bit to get things to work. All the dspam howto's I looked at do not take db based virtual users into account so they are going to be no help. Let's say you've got this: domains type virtualdomain.com virtual: localdomain.com local: Alias goto [EMAIL PROTECTED] - [EMAIL PROTECTED] [EMAIL PROTECTED] - [EMAIL PROTECTED] Then the path through your system would be Postfix - mysql - virtualdomain - mysql - virtual user - localdomain - transport table - dspam I did something similar with sending things to /dev/null which didn't work with the virtual stuff. The other possibility is to sit down with phpmyadmin (or postgres) and change your db query in mysql_virtual_alias_maps.cf from query = SELECT goto FROM alias WHERE address='%s' to something that uses a like [EMAIL PROTECTED] or like [EMAIL PROTECTED] to return to the local addresses as well as doing the original query. This is definitely possible with Postfix as I do some fairly extreme Mysql queries for an email upload system, but significantly harder depending on how well you know sql. You might search around a bit and see if anyone has posted some pattern matching Postfix/Mysql queries... I had the DBA write the complex ones we user which are not solving the same problem you are. kashani -- gentoo-user@gentoo.org mailing list
RE: [gentoo-user] postfix .. transports .. and virtual domains ..
Henti Smith wrote: Hi guys, I've got a virtual domain setup for postfix working .. all good .. however I want to setup a spam@ and ham@ address for all domains in the virtual lookup table (mysql) to go via a transport to the script that procresses the mail. I've added the transport in main.cf transport_maps = pcre:/etc/postfix/dspam_lerning_transport.pcre local_recipient_maps = $transport_maps but I'm getting this when I try to send to [EMAIL PROTECTED] Recipient address rejected: User unknown in virtual mailbox table any ideas ? Yup.. the virtual manpage: http://www.postfix.org/virtual.8.html That should help you out--if not, you might consider asking on the postfix-user mailing list. Good luck! :) Best, --Glenn -- Glenn E. Sieb, MTS Bell Laboratories [EMAIL PROTECTED] +1 732 949 5453 -- gentoo-user@gentoo.org mailing list
Re: [gentoo-user] postfix .. transports .. and virtual domains ..
Henti Smith wrote: Hi guys, I've got a virtual domain setup for postfix working .. all good .. however I want to setup a spam@ and ham@ address for all domains in the virtual lookup table (mysql) to go via a transport to the script that procresses the mail. I've added the transport in main.cf transport_maps = pcre:/etc/postfix/dspam_lerning_transport.pcre local_recipient_maps = $transport_maps but I'm getting this when I try to send to [EMAIL PROTECTED] Recipient address rejected: User unknown in virtual mailbox table any ideas ? Depending on which virtual guide you followed your virtual domains are going to be under virtual_mailbox_domains rather than transport. I'd add the virtual aliases into the db for ham and spam, if you're using PostfixAdmin you can add spam and ham in as accounts that are created automatically wheneven a new domain is added. kashani -- gentoo-user@gentoo.org mailing list
Re: [gentoo-user] postfix .. transports .. and virtual domains ..
Sieb, Glenn E (Glenn) wrote: Yup.. the virtual manpage: http://www.postfix.org/virtual.8.html That should help you out--if not, you might consider asking on the postfix-user mailing list. Good luck! :) Best, --Glenn I haven't had to say it in almost a year, which is frankly amazing for any list and says something about the overall quality of the gentoo mail lists. In any case... I don't complain about frame buffers, bash tricks, anything to do with Xorg, grub, kde, gnome, and hundred other things I have no interest in under Gentoo. I ask that *you* do not complain about Apache, PHP, Postfix, Mysql, etc. otherwise known as things I do care about. kashani -- gentoo-user@gentoo.org mailing list
RE: [gentoo-user] postfix .. transports .. and virtual domains ..
kashani wrote: That should help you out--if not, you might consider asking on the postfix-user mailing list. Good luck! :) I haven't had to say it in almost a year, which is frankly amazing for any list and says something about the overall quality of the gentoo mail lists. In any case... I don't complain about frame buffers, bash tricks, anything to do with Xorg, grub, kde, gnome, and hundred other things I have no interest in under Gentoo. I ask that *you* do not complain about Apache, PHP, Postfix, Mysql, etc. otherwise known as things I do care about. *rereads above* Um, I wasn't complaining. I pointed him to a man page on postfix.org, and said if that didn't help, he might get better answers on a Postfix mailing list. That's all. *shrug* (And frankly, if I had been complaining, there wouldn't have been a smiley :) there either.) Best, --Glenn -- Glenn E. Sieb, MTS Bell Laboratories [EMAIL PROTECTED] +1 732 949 5453 -- gentoo-user@gentoo.org mailing list
Re: [gentoo-user] postfix .. transports .. and virtual domains ..
On Thu, 19 Oct 2006 19:25:07 +0200, Henti Smith wrote: however I want to setup a spam@ and ham@ address for all domains in the virtual lookup table (mysql) to go via a transport to the script that procresses the mail. Can't you do this with aliases? That's how I do it with dspam and postfix, using lines like this in /etc/mail/aliases spam: |'/usr/local/bin/dspam' --user --class=spam --source=error -mode=teft --deliver=innocent -- Neil Bothwick Access denied--nah nah na nah nah! signature.asc Description: PGP signature