Missing Maildir directory in script?

[Pete Boyd]

In goldfish<version>.php, this line:

$conf['q_mailbox_path'] = "SELECT CONCAT('/home/vmail/',
SUBSTRING_INDEX(email,'@',-1), '/', SUBSTRING_INDEX(email,'@',1), '/')
as `path` FROM view_users WHERE `email` = '%m'";

seems to me to assume the mailbox is in /home/vmail/<domain>/
<mailbox>/ when in fact it is in /home/vmail/<domain>/<mailbox>/
Maildir/.
See "mail_location = maildir:/home/vmail/%d/%n/Maildir" in
http://workaround.org/articles/ispmail-etch/#step-6-configure-dovecot

Should the line above not read like this?:
$conf['q_mailbox_path'] = "SELECT CONCAT('/home/vmail/',
SUBSTRING_INDEX(email,'@',-1), '/', SUBSTRING_INDEX(email,'@',1), '/
Maildir/') as `path` FROM view_users WHERE `email` = '%m'";

[Pete Boyd]

What do you reckon, Remo?

[remofritzsche]

I think this one should work, yes.

$conf['q_mailbox_path'] = "SELECT CONCAT('/home/vmail/',
SUBSTRING_INDEX(email,'@',-1), '/', SUBSTRING_INDEX(email,'@',1), '/
Maildir/') as `path` FROM view_users WHERE `email` = '%m'";

On Jul 10, 10:43 pm, Pete Boyd <petes-accou...@thegoldenear.org>
wrote:

[Pete Boyd]

Doesn't this mean then that your script won't work with the ISPMail-
Etch tutorial?

[remofritzsche]

Well, generally this script has been thought as a general script for
every Postfix installation with MySQL backend - that's why I call the
SQL section the 'configuration section'. When I wrote the script, I
have not known that so many people followed this tutorial and assumed,
that this fits perfectly.

But I think goldfish should work with the etch tutorial, many people
use it. But actually I don't know if they all have changed the path
themselves..


On Jul 11, 12:55 pm, Pete Boyd <petes-accou...@thegoldenear.org>
wrote: