search for: pplsnet

Hello all, I've been trying to setup my postfix and dovecot to AUTH with mysql, and I'm almost there! BUT, for some reason, dovecot won't create the folders in their proper location. For some reason, instead of going into /var/vmail/pplsnet.com/{username}location, where the postfix put all the emails, dovecot creates a whole new set of folders in /var/vmail/{username} I have attempted to force dovecot to put into a sub directly, without using the %d, but that doesn't work either: #mail_location = mbox:/var/vmail/%d/%n mail_locati...

...to work with my other web application, the username is in one field, and the database is in another. can anyone make a suggestion as to how i can do the user_query to work this way? (both with dovecot and the postfix) any help would be greatly appreciated! dovecot: connect = host=localhost dbname=pplsnet user=xxxx password=xxxxxxx password_query = SELECT password FROM mailbox WHERE username = '%u' user_query = SELECT '/var/vmail/%d/%n' as home, 'maildir:/var/vmail/%d/%n' as mail, 150 AS uid, 12 AS gid, concat('dirsize:storage=',quota) AS quota FROM mailbox WHERE user...