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]
