[James Wiki] Update of "VirtualUserTable" by ChanochWiggers

[Apache Wiki <wi...@apache.org>]

Dear Wiki user,

You have subscribed to a wiki page or wiki category on "James Wiki" for change notification.

The "VirtualUserTable" page has been changed by ChanochWiggers.
The comment on this change is: Language and formatting changes.
http://wiki.apache.org/james/VirtualUserTable?action=diff&rev1=4&rev2=5

--------------------------------------------------

  
  == JDBCVirtualUserTable ==
  
- First of all, you should READ the following:  http://james.apache.org/FAQ.html#7
+ 
+ First of all, you should READ the following:  http://james.apache.org/FAQ.html#7 '''<-Link no longer works''' /* Anyone know where it's gone? */
  
  Just read it, but don't do anything about it just yet.  I'll walk you through the proccess to the best of my abilities.
  
  === Setting Up Database ===
  
-  1. Well first you need a database.  I use MySQL (www.MySQL.com), but you can use whatever you want, as long as they have a Java driver.  So get and install a database (I'm not going to walk you through this - they have entire books written on the subject; I assume if you're an admin, you should know how to install a database).
+  1. Well first you need a database.  I use MySQL (www.MySQL.com), but you can use whatever you want, as long as they have a JDBC driver.  So get and install a database (I'm not going to walk you through this - they have entire books written on the subject; I assume if you're an admin, you should know how to install a database).
  
   1. After installing the database, create a db named "mail" or whatever you want to call it:
  
@@ -72, +73 @@

  create database mail default charset utf8
  }}}
  
-  1.#3  Now you want to create a user with privileges on database "mail".  I don't create users via raw SQL, I use MySQLCC, so I don't really know what the SQL for that is :(.  '''TODO''': fill int the SQL for creating a user.
+  1.#3  Now you want to [[http://dev.mysql.com/doc/refman/5.1/en/adding-users.html|create a user with privileges on database "mail"]].  I don't create users via raw SQL, I use MySQLCC, so I don't really know what the SQL for that is 
  
   1.  Now we want to add the table for mappings:
  {{{
@@ -147, +148 @@

  quit
  }}}
  
-   1.#5  TADA!  Now you should have two users:  bob@yourdomain1.com and jen@yourdomain1.com.  Emails sent to "jen@yourdomain1.com" will get a user not found message (unless of course you have another mapping for that domain name or a local user named simply "jen", which would break our naming policy).
+   1.#5  TADA!  Now you should have two users:  {{{ bob@yourdomain1.com }}} and {{{ jen@yourdomain1.com }}}.  Emails sent to "jen@yourdomain1.com" will get a user not found message (unless of course you have another mapping for that domain name or a local user named simply "jen", which would break our naming policy).
  
  Also, emails sent to sales@yourdomain1.com will go to bob's email; all sent to sales@yourdomain2.com will go to jen's email.
  
@@ -167, +168 @@

  
    * '''user''': CEO '''domain''': yourdomain2.com '''target_address''': president@whitehouse.gov
  
-  1.#2  The reason I mentioned that you should have a nameserver "localhost" in the very beginning is because I had some hard times figuring out why the virtual table wasn't working.  The problem was my '''target_address''' entries - I'd specify them as simply "bob..yourdomain1.com".  Turns out that JDBCVirtualUserTable automatically appends "@localhost" to target_address's that don't have a domain part.  And I didn't have the "localhost" in my servernames, and as a result the message couldn't be delivered.
+  1.#2  The reason I mentioned that you should have a nameserver "localhost" in the very beginning is because I had some hard times figuring out why the virtual table wasn't working.  The problem was my '''target_address''' entries - I'd specify them as simply "bob..yourdomain1.com".  Turns out that JDBCVirtualUserTable automatically appends "@localhost" to target_addresses that don't have a domain part.  And I didn't have the "localhost" in my servernames, and as a result the message couldn't be delivered.
  
  === TROUBLESHOOTING ===