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]
