You are viewing a plain text version of this content. The canonical link for it is here.
Posted to server-user@james.apache.org by Max Levinson <ma...@gmail.com> on 2010/07/11 00:33:16 UTC
Question about whitelist.
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 remote@remotehost.com to whitelist?
Thanks.
Re: Question about whitelist.
Posted by Max Levinson <ma...@gmail.com>.
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 <no...@apache.org>
> 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 foo@bar.de for the recipient bar@foo.de:
>
> INSERT INTO whitelist (localUser, localHost, remoteUser, remoteHost)
> VALUES('bar','foo.de', 'foo',bar.de');
>
> Hope it helps,
> Norman
>
> 2010/7/13 Max Levinson <ma...@gmail.com>:
> > 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('max@localdomain.com','localdomain.com','alex@test-domain.com','
> > 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 <no...@apache.org>
> >
> >> 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 <ma...@gmail.com>:
> >> > 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 <no...@apache.org>
> >> >
> >> >> Hi Max,
> >> >>
> >> >> you want to know what you need to insert into the table ?
> >> >>
> >> >> Bye,
> >> >> Norman
> >> >>
> >> >> 2010/7/11 Max Levinson <ma...@gmail.com>:
> >> >> > 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 remote@remotehost.com to
> >> >> whitelist?
> >> >> >
> >> >> > Thanks.
> >> >> >
> >> >>
> >> >> ---------------------------------------------------------------------
> >> >> To unsubscribe, e-mail: server-user-unsubscribe@james.apache.org
> >> >> For additional commands, e-mail: server-user-help@james.apache.org
> >> >>
> >> >>
> >> >
> >>
> >> ---------------------------------------------------------------------
> >> To unsubscribe, e-mail: server-user-unsubscribe@james.apache.org
> >> For additional commands, e-mail: server-user-help@james.apache.org
> >>
> >>
> >
>
> ---------------------------------------------------------------------
> To unsubscribe, e-mail: server-user-unsubscribe@james.apache.org
> For additional commands, e-mail: server-user-help@james.apache.org
>
>
Re: Question about whitelist.
Posted by Norman Maurer <no...@apache.org>.
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 foo@bar.de for the recipient bar@foo.de:
INSERT INTO whitelist (localUser, localHost, remoteUser, remoteHost)
VALUES('bar','foo.de', 'foo',bar.de');
Hope it helps,
Norman
2010/7/13 Max Levinson <ma...@gmail.com>:
> 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('max@localdomain.com','localdomain.com','alex@test-domain.com','
> 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 <no...@apache.org>
>
>> 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 <ma...@gmail.com>:
>> > 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 <no...@apache.org>
>> >
>> >> Hi Max,
>> >>
>> >> you want to know what you need to insert into the table ?
>> >>
>> >> Bye,
>> >> Norman
>> >>
>> >> 2010/7/11 Max Levinson <ma...@gmail.com>:
>> >> > 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 remote@remotehost.com to
>> >> whitelist?
>> >> >
>> >> > Thanks.
>> >> >
>> >>
>> >> ---------------------------------------------------------------------
>> >> To unsubscribe, e-mail: server-user-unsubscribe@james.apache.org
>> >> For additional commands, e-mail: server-user-help@james.apache.org
>> >>
>> >>
>> >
>>
>> ---------------------------------------------------------------------
>> To unsubscribe, e-mail: server-user-unsubscribe@james.apache.org
>> For additional commands, e-mail: server-user-help@james.apache.org
>>
>>
>
---------------------------------------------------------------------
To unsubscribe, e-mail: server-user-unsubscribe@james.apache.org
For additional commands, e-mail: server-user-help@james.apache.org
Re: Question about whitelist.
Posted by Max Levinson <ma...@gmail.com>.
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('max@localdomain.com','localdomain.com','alex@test-domain.com','
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 <no...@apache.org>
> 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 <ma...@gmail.com>:
> > 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 <no...@apache.org>
> >
> >> Hi Max,
> >>
> >> you want to know what you need to insert into the table ?
> >>
> >> Bye,
> >> Norman
> >>
> >> 2010/7/11 Max Levinson <ma...@gmail.com>:
> >> > 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 remote@remotehost.com to
> >> whitelist?
> >> >
> >> > Thanks.
> >> >
> >>
> >> ---------------------------------------------------------------------
> >> To unsubscribe, e-mail: server-user-unsubscribe@james.apache.org
> >> For additional commands, e-mail: server-user-help@james.apache.org
> >>
> >>
> >
>
> ---------------------------------------------------------------------
> To unsubscribe, e-mail: server-user-unsubscribe@james.apache.org
> For additional commands, e-mail: server-user-help@james.apache.org
>
>
Re: Question about whitelist.
Posted by Norman Maurer <no...@apache.org>.
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 <ma...@gmail.com>:
> 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 <no...@apache.org>
>
>> Hi Max,
>>
>> you want to know what you need to insert into the table ?
>>
>> Bye,
>> Norman
>>
>> 2010/7/11 Max Levinson <ma...@gmail.com>:
>> > 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 remote@remotehost.com to
>> whitelist?
>> >
>> > Thanks.
>> >
>>
>> ---------------------------------------------------------------------
>> To unsubscribe, e-mail: server-user-unsubscribe@james.apache.org
>> For additional commands, e-mail: server-user-help@james.apache.org
>>
>>
>
---------------------------------------------------------------------
To unsubscribe, e-mail: server-user-unsubscribe@james.apache.org
For additional commands, e-mail: server-user-help@james.apache.org
Re: Question about whitelist.
Posted by Max Levinson <ma...@gmail.com>.
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 <no...@apache.org>
> Hi Max,
>
> you want to know what you need to insert into the table ?
>
> Bye,
> Norman
>
> 2010/7/11 Max Levinson <ma...@gmail.com>:
> > 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 remote@remotehost.com to
> whitelist?
> >
> > Thanks.
> >
>
> ---------------------------------------------------------------------
> To unsubscribe, e-mail: server-user-unsubscribe@james.apache.org
> For additional commands, e-mail: server-user-help@james.apache.org
>
>
Re: Question about whitelist.
Posted by Norman Maurer <no...@apache.org>.
Hi Max,
you want to know what you need to insert into the table ?
Bye,
Norman
2010/7/11 Max Levinson <ma...@gmail.com>:
> 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 remote@remotehost.com to whitelist?
>
> Thanks.
>
---------------------------------------------------------------------
To unsubscribe, e-mail: server-user-unsubscribe@james.apache.org
For additional commands, e-mail: server-user-help@james.apache.org