Hi Norman, Thanks for your reply,now it makes a perfect sense how it works :)
I am not very strong in Java,but this feature of course can be useful,I mean to add a whole domain to whitelist for all recepients. Thanks for your reply. 2010/7/13 Norman Maurer <[email protected]> > Hi Max, > > you can only whitelist senders for explicit recipients. There is no > "whitelist sender X for domain Y" feature, If you need it you will > need to patch the Mailet/Matcher. > > Here is an example what you would need to insert into the DB to > whitelist the sender address [email protected] for the recipient [email protected]: > > INSERT INTO whitelist (localUser, localHost, remoteUser, remoteHost) > VALUES('bar','foo.de', 'foo',bar.de'); > > Hope it helps, > Norman > > 2010/7/13 Max Levinson <[email protected]>: > > Hi Norman, > > > > I understand how to make SQL query,but I need to know what exactly to put > > into those fields. > > > > First scenario is that I want to whitelist sender domain for all of the > > recepients will something like this work? > > > > INSERT INTO whitelist (localUser, localHost, remoteUser, remoteHost) > > VALUES('','','','test-domain.com'); > > > > Or should I always specify for what recipient I am adding whitelisting > entry > > like this: > > > > INSERT INTO whitelist (localUser, localHost, remoteUser, remoteHost) > > VALUES('[email protected]','localdomain.com','[email protected]',' > > test-domain.com'); > > > > Table structure makes me confused,can you please give me some real > whitelist > > entries and explain how they work it would be extremely helpful for > > understanding James whitelist. > > > > 2010/7/13 Norman Maurer <[email protected]> > > > >> Hi Max, > >> > >> you can have a look at the sqlResources.xml. But this should work: > >> > >> INSERT INTO whitelist (localUser, localHost, remoteUser, remoteHost) > >> VALUES ('recipient','recipient.domain','sender','sender.domain'); > >> > >> Bye, > >> Norman > >> > >> > >> 2010/7/12 Max Levinson <[email protected]>: > >> > Yes, I want to know what exactly I need to insert into table in case > if I > >> > want to add individual email or hostname or IP into whitelist. > >> > > >> > Thanks. > >> > > >> > 2010/7/11 Norman Maurer <[email protected]> > >> > > >> >> Hi Max, > >> >> > >> >> you want to know what you need to insert into the table ? > >> >> > >> >> Bye, > >> >> Norman > >> >> > >> >> 2010/7/11 Max Levinson <[email protected]>: > >> >> > Hi list, > >> >> > > >> >> > Have a question about a structure of whitelist database table. > >> >> > > >> >> > In my case because I am keeping whitelist entries in DB table > >> structure > >> >> > looks the following: > >> >> > > >> >> > CREATE TABLE whitelist > >> >> > ( > >> >> > localuser character varying(64) NOT NULL, > >> >> > localhost character varying(255) NOT NULL, > >> >> > remoteuser character varying(64) NOT NULL, > >> >> > remotehost character varying(255) NOT NULL, > >> >> > CONSTRAINT whitelist_pkey PRIMARY KEY (localuser, localhost, > >> remoteuser, > >> >> > remotehost) > >> >> > ) > >> >> > WITH ( > >> >> > OIDS=FALSE > >> >> > ); > >> >> > ALTER TABLE whitelist OWNER TO postgres; > >> >> > > >> >> > So without using whitelist manager what entries should I add to DB > in > >> >> case I > >> >> > want to add remote IP to whitelist or individual address, does it > only > >> >> work > >> >> > in pairs(remote address or local host should be added together with > >> >> > localuser or localhost)? > >> >> > > >> >> > Can anyone give me an example entry for better understanding the > >> process, > >> >> > for examle I want to add remote address [email protected] to > >> >> whitelist? > >> >> > > >> >> > Thanks. > >> >> > > >> >> > >> >> --------------------------------------------------------------------- > >> >> To unsubscribe, e-mail: [email protected] > >> >> For additional commands, e-mail: [email protected] > >> >> > >> >> > >> > > >> > >> --------------------------------------------------------------------- > >> To unsubscribe, e-mail: [email protected] > >> For additional commands, e-mail: [email protected] > >> > >> > > > > --------------------------------------------------------------------- > To unsubscribe, e-mail: [email protected] > For additional commands, e-mail: [email protected] > >
