[gentoo-user] postfix .. transports .. and virtual domains ..

[gentoo-user] postfix .. transports .. and virtual domains ..

[Henti Smith]

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 spam@mydomain.tld 

Recipient address rejected: User unknown in virtual mailbox table

any ideas ? 



-- 
Henti Smith
henti@geekware.co.za
+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 ..

[kashani]

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 spam@mydomain.tld 
> 
> 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 ..

[Henti Smith]

On Thu, 19 Oct 2006 14:42:47 -0700
kashani <kashani-list@badapple.net> 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 spam@mydomain.tld 
> > 
> > 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
henti@geekware.co.za
+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 ..

[kashani]

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
spam@virtualdomain.com	->	spam@localdomain.com
ham@virtualdomain.com	->	ham@localdomain.com

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 spam@% 
or like ham@% 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 ..

[Neil Bothwick]

[-- Attachment #1: Type: text/plain, Size: 514 bytes --]

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!

[-- Attachment #2: signature.asc --]
[-- Type: application/pgp-signature, Size: 189 bytes --]

Re: [gentoo-user] postfix .. transports .. and virtual domains ..

[Henti Smith]

On Thu, 19 Oct 2006 23:53:40 +0100
Neil Bothwick <neil@digimed.co.uk> 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
henti@geekware.co.za
+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 ..

[Sieb, Glenn E (Glenn)]

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 spam@mydomain.tld
> 
> 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
sieb@lucent.com
+1 732 949 5453
-- 
gentoo-user@gentoo.org mailing list

Re: [gentoo-user] postfix .. transports .. and virtual domains ..

[kashani]

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 ..

[Sieb, Glenn E (Glenn)]

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
sieb@lucent.com
+1 732 949 5453
-- 
gentoo-user@gentoo.org mailing list