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: [email protected] and [email protected]. Emails sent to "[email protected]" 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: {{{ [email protected] }}} and {{{ [email protected] }}}. Emails sent to "[email protected]" 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 [email protected] will go to bob's email; all sent to [email protected] will go to jen's email. @@ -167, +168 @@ * '''user''': CEO '''domain''': yourdomain2.com '''target_address''': [email protected] - 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 ===
