*sigh* nevermind, after having some coffee and waking my lazy a.. up I realized that it was querying out path from the DB not dynamically! I used postfix.admin so going to see if it was something in the setup that did it, but there is only a few users so far, so I will make the changes via mysql command line.
Better than a surprise, just a dumba.. behind the keyboard 2nt~ Thanks again... On Mon, Mar 21, 2011 at 9:40 PM, lance raymond <lance.raym...@gmail.com>wrote: > I just love surprises :) But back to the question, sorry I didn't put > the full conf report, but both the old and new do have the > virtual_mailbox_maps, but the problem is there are multiple domains, and on > the old the path is as I said; > /home/vmail/domain1/user. Using me as the example, the old would be; > > /home/vmail/domain1/lance/Maildir/ (new/cur/ ...) > /home/vmail/domain2/lance/Maildir/ (new/cur/ ...) > > with the new server it's simply; > /home/vmail/lance@domain1/Maildir/lance@domain1/Maildir (new/cur) > > I hope that makes it a bit more clearer, but looking at the old conf and > seeing how it uses a mysql query, the old server has similar queries (table > names are diff now), but did notice a slight difference, notice the 2; > > *old.* > user = root > password = pass > dbname = mail > table = users > select_field = > CONCAT(SUBSTRING_INDEX(email,'@',-1),'/',SUBSTRING_INDEX(email,'@',1),'/') > where_field = email > * > new.* > hosts = localhost > user = postfix > password = pass > dbname = postfix > table = mailbox > select_field = maildir > where_field = username > additional_conditions = and active = '1' > result_format = %sMaildir/ > > No harm in trying so I am going to play a bit with the new and see what I > find, but if things don't work ... be prepared for more surprises! Tnx > again .... > > On Mon, Mar 21, 2011 at 4:15 PM, Jeroen Geilman <jer...@adaptr.nl> wrote: > >> On 03/21/2011 04:11 PM, lance raymond wrote: >> >> ok next question (a little more intelligent I would hope). I am now >> looking at my working mail and as some test mail comes in for some users, >> the path is the following; >> >> /home/vmail/u...@domain.com for each. The problem is both it's not easy >> as more and more users get running as well as roundcube is not working (more >> of a config thing) I would think, but the old server that crashed had >> /home/vmail/domain/username. >> >> I am looking at the postconf -n (nice command) and the only thing I notice >> from this to the old one that crashed and is now barely alive is under the >> sasl section and not sure as reading a bit on this didn't shed light on it; >> The original box shows; >> *smtpd_sasl_local_domain = $mydomain* >> the new one didn't have that entry at all. >> >> So I do figure it's a postfix config as he is the mailserver delivery guy, >> but the other thing is the original has the virtual_mailbox_domains = >> hardcoded with the domains, the new one has virtual_mailbox_domains = >> mysql:/etc/postfix/mysql-domains.cf which just queries them out >> (better). So I probably gave 2 much non essential info, for something so >> simple, but that's the qeustion. How do you tell postfix to put the users >> mail in the /home/vmail/domain/user folder, NOT /home/vmail/ >> u...@domain.com folder. >> >> >> Virtual mailbox locations are controlled by - surprise - the >> virtual_mailbox_maps parameter. >> Each result is appended to virtual_mailbox_base, if defined, to yield a >> filename or directory location. >> >> >> -- >> J. >> >> >
