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 Robert SKUBIJ <ro...@poczta.fm> on 2006/10/30 15:28:00 UTC

JDBCVirtualUserTable

Hi!

I have question.

I want use jdbcvirtualusertable with std. query from documentation.
What I must insert into user,domain,target_address?

Example from my test configuration.

Domain: somedomain.com

Local users:  (added by adduser from 4555)
robert,
frank.

robert => robert@somedomain.com
frank => frank@somedomain.com

When I send mail to robert and frank all mail is arrived only for robert !!

My records in virtualusers

user| domain | target_address
------------------------------------------------
robert | somedomain.com | robert@somedomain.com
frank | somedomain.com | frank@somedomain.com

And old records

user| domain | target_address
------------------------------------------------
robert | somedomain.com | robert
frank | somedomain.com | frank

Regards

----------------------------------------------------------------------
PS. >>> http://link.interia.pl/f19a6


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


RE: JDBCVirtualUserTable

Posted by "Noel J. Bergman" <no...@devtech.com>.
> Which SQL we use? Built-in?

Personally, I use MySQL for it.  Have not tried with others yet.

	--- Noel


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


Re: JDBCVirtualUserTable

Posted by Robert SKUBIJ <ro...@poczta.fm>.
Noel J. Bergman napisaƂ(a):
>> robert => robert@somedomain.com
>> frank => frank@somedomain.com
> 
>> user| domain | target_address
>> ------------------------------------------------
>> robert | somedomain.com | robert@somedomain.com
>> frank | somedomain.com | frank@somedomain.com
> 
> Wrong.
> 
>> user| domain | target_address
>> ------------------------------------------------
>> robert | somedomain.com | robert
>> frank | somedomain.com | frank
> 
> Right.
> 
> 	--- Noel
> 
> 
> ---------------------------------------------------------------------
> To unsubscribe, e-mail: server-user-unsubscribe@james.apache.org
> For additional commands, e-mail: server-user-help@james.apache.org
> 
> 
> 
Which SQL we use? Built-in?



----------------------------------------------------------------------
PS. >>> http://link.interia.pl/f19a6


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


RE: JDBCVirtualUserTable

Posted by "Noel J. Bergman" <no...@devtech.com>.
> robert => robert@somedomain.com
> frank => frank@somedomain.com

> user| domain | target_address
> ------------------------------------------------
> robert | somedomain.com | robert@somedomain.com
> frank | somedomain.com | frank@somedomain.com

Wrong.

> user| domain | target_address
> ------------------------------------------------
> robert | somedomain.com | robert
> frank | somedomain.com | frank

Right.

	--- Noel


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