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