--- mouss <[EMAIL PROTECTED]> wrote: > >>> Debian Etch > >>> Postfix 2.3.8 > >>> Dovcot
- snip - > >>> On /etc/postfix/mysql-virtual-mailbox-maps.cf > >>> user = mailuser > >>> password = mailuserpasswd > >>> hosts = 127.0.0.1 > >>> dbname = mailserver > >>> query = SELECT 1 FROM view_users WHERE email='%s' > >>> > >> unless you are using an external delivery agent, > virtual_mailbox_maps > >> > >> should return the mailbox location, not "1". > > > > > > Could you please explain in more detail. I'm going to create > mailboxes > > for users. On non "virtual mailbox domain class" I just run; > > > > useradd -m -s /bin/bash username > > > > > > On the arrival of the 1st mail to users' account the mailbox will > be > > automatically created on /home/username/. How about on "virtual > > mailbox domain class". What steps shall I perform? TIA > > > > if you were using a hash table, you would simply put things like > > [EMAIL PROTECTED] satimis.com/info > ... > > or if you want maildir (recommended) > [EMAIL PROTECTED] satimis.com/info/ > ... > > but you are using mysql, so this information must be put in a mysql > table and your SELECT query must return the field in the second > column > "satimis.com/info/", somthing like > > query = select mailbox from ... > > instead of "select 1...". see the workaround.org howto for examples. > > you need to be familiar with mysql. > > > > >> take a look at the howto on http://workaround.org/ > > > > Noted with thanks > > read it. it has examples of tables etc. Hi mouss, Thanks for your advice. What I can't figure out is; User 'satimis' was created when I built Debian Etch. It has folder created on /home/satimis # ls -ld /home/satimis/ drwxr-xr-x 2 satimis satimis 4096 2008-10-09 17:02 /home/satimis/ satimis can't receive mails, all mails to [EMAIL PROTECTED] rejected because it is not on vmail group. I ran; # groupadd -g 5000 vmail # useradd -g vmail -u 5000 vmail -d /home/vmail -m creating vmail account. Performed following test; # chown vmail:vmail /home/satimis to change the owner and group of satimis folder. Still the mail to [EMAIL PROTECTED] was rejected. # tail /var/log/mail.log Oct 10 04:54:02 xen6 authdaemond: stopping authdaemond children Oct 10 04:54:02 xen6 postfix/master[1313]: terminating on signal 15 Oct 10 04:55:17 xen6 authdaemond: modules="authmysql", daemons=5 Oct 10 04:55:17 xen6 authdaemond: Installing libauthmysql Oct 10 04:55:17 xen6 authdaemond: Installation complete: authmysql Oct 10 04:55:18 xen6 postfix/master[1309]: daemon started -- version 2.3.8, configuration /etc/postfix Oct 10 05:02:35 xen6 postfix/master[1309]: reload configuration /etc/postfix Oct 10 05:03:23 xen6 postfix/smtpd[1447]: connect from ti-out-0910.google.com[209.85.142.184] Oct 10 05:03:24 xen6 postfix/smtpd[1447]: NOQUEUE: reject: RCPT from ti-out-0910.google.com[209.85.142.184]: 550 5.1.1 <[EMAIL PROTECTED]>: Recipient address rejected: User unknown in virtual mailbox table; from=<[EMAIL PROTECTED]> to=<[EMAIL PROTECTED]> proto=ESMTP helo=<ti-out-0910.google.com> Oct 10 05:03:24 xen6 postfix/smtpd[1447]: disconnect from ti-out-0910.google.com[209.85.142.184] I doubt whether I'm allowed to run; # useradd -g vmail -u 5001 satimis -d /home/vmail/satimis -m Because user 'satimis' already exiting. Please help. TIA B.R. satimis Send instant messages to your online friends http://uk.messenger.yahoo.com
