On Mon, 2002-12-30 at 20:57, Sam Varshavchik wrote: > Jose de Paula Eufrasio Junior writes: > > > My spool directory is organized like this: > > > > /var/spool/mail/(first domain letter)/(first username > > letter)/username/Maildir/ > > > > like > > > > /var/spool/mail/t/test.com/c/coredump/Maildir/ > > This ... > > > CONCAT(domain.path, '/', popbox.mbox_name), \ > > ... and this does not jive.
excuse-me... i don't understand the "jive" term but seems like you say that the CONCAT... will not return the correct maildir path for a given user? Well... I tried this query (just for testing): SELECT concat( domain.path, '/', popbox.mbox_name ) FROM domain, popbox; and it gives to me results like this: /var/spool/mail/t/test.com/p/postmaster/Maildir/ /var/spool/mail/t/test.com/c/coredump/Maildir/ That is the correct path for the Maildirs in my system (where Exim is delivering the mail). Inside this dir are the new, cur and tmp dirs, the standart maildir thing. When I do the query for an user, I can supply an empty HomeDir? Like '' on the query that I send before? []s core ------------------------------------------------------- This sf.net email is sponsored by:ThinkGeek Welcome to geek heaven. http://thinkgeek.com/sf _______________________________________________ courier-users mailing list [EMAIL PROTECTED] Unsubscribe: https://lists.sourceforge.net/lists/listinfo/courier-users
