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