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 ro...@poczta.fm on 2005/04/17 20:17:08 UTC

Virtual user table.

How I can define virtual user table in SQL?
Example: 

user: mail.test
domain: domain.com

in virtualusertable:

insert into virtualusertable (username,domain,target_address) values ('mail.test','domain.com','mail.test@domain.com');

It is properly?

Where create user for POP3 client? By telnet on 4555?



----------------------------------------------------------------------
Wszystko o MOTORYZACJI >>> http://link.interia.pl/f186a


---------------------------------------------------------------------
To unsubscribe, e-mail: server-user-unsubscribe@james.apache.org
For additional commands, e-mail: server-user-help@james.apache.org


RE: Virtual user table.

Posted by Daniel Perry <d....@netcase.co.uk>.
Yes, and no!
The target_address should be a local address.  Assuming domain.com is local,
then this is ok, but if you mail.test@otherdomain.com (where otherdomain is
local), it will go to the same mailbox.

You would be better off creating mailboxes that include the domain name, so
that there's no overlap between domains.

e.g.

insert into virtualusertable (username,domain,target_address) values
('mail.test','domain.com','mail.test_domain.com');

insert into virtualusertable (username,domain,target_address) values
('mail.test','otherdomain.com','mail.test_otherdomain.com');

To add the user for pop3, use telnet 4555, and add the user :
mail.test_domain.com, and mail.test_otherdomain.com

Note the target_address must be the same as the pop3 username.  Also note
that the only the part before the @ counts in target address (ie, if the
domain is local, then it is used to determine mailbox, otherwise it is
forwarded to other server with full address).

Daniel.


> -----Original Message-----
> From: robert.skubij@poczta.fm [mailto:robert.skubij@poczta.fm]
> Sent: 17 April 2005 19:17
> To: server-user@james.apache.org
> Subject: Virtual user table.
>
>
>
> How I can define virtual user table in SQL?
> Example:
>
> user: mail.test
> domain: domain.com
>
> in virtualusertable:
>
> insert into virtualusertable (username,domain,target_address)
> values ('mail.test','domain.com','mail.test@domain.com');
>
> It is properly?
>
> Where create user for POP3 client? By telnet on 4555?
>
>
>
> ----------------------------------------------------------------------
> Wszystko o MOTORYZACJI >>> http://link.interia.pl/f186a
>
>
> ---------------------------------------------------------------------
> 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