Virtual Users And Domains With Postfix, Courier And MySQL (+ SMTP-AUTH, Quota, SpamAs

[ruskicar]

I followed the instructions and there is /home/vmail directory on my server! I don't know why courier doesn't find it.

No, don't put real system users into the database!
If someone sends mails to users from /etc/aliases, these mails will get delivered as described in /etc/aliases. Postfix can distinguish between system users and virtual users.

But there are some real system users on my server, for example myself (ruskicar = postmaster). And postfix says there is no user ruskicar in virtual table...so I don't get any mail in mutt (as i was used to before).

Jan 7 12:56:41 lintvern postfix/smtpd[12211]: NOQUEUE: reject: RCPT from mta2.siol.net[193.189.160.133]: 550 <ruskicar@lintvern.net>: Recipient address rejected: User unknown in virtual mailbox table; from=<ruskicar@siol.net> to=<ruskicar@lintvern.net> proto=ESMTP helo=<mta2.siol.net>

[falko]

Does /etc/courier/authmysqlrc look like this?

MYSQL_SERVER localhost
MYSQL_USERNAME mail_admin
MYSQL_PASSWORD mail_admin_password
MYSQL_PORT 0
MYSQL_DATABASE mail
MYSQL_USER_TABLE users
MYSQL_CRYPT_PWFIELD password
#MYSQL_CLEAR_PWFIELD password
MYSQL_UID_FIELD 5000
MYSQL_GID_FIELD 5000
MYSQL_LOGIN_FIELD email
MYSQL_HOME_FIELD "/home/vmail"
MYSQL_MAILDIR_FIELD CONCAT(SUBSTRING_INDEX(email,'@',-1),'/',SUBSTRING_INDEX(email,'@',1),'/')
#MYSQL_NAME_FIELD
MYSQL_QUOTA_FIELD quota

Please post the output of

ls -la /home

Also post the output of

netstat -tap

[ruskicar]

Yes, /etc/courier/authmysqlrc looks like that (only that I have some lines that are originally in /etc/courier/authmysqlrc and are all commented)

ls -la /home:

ruskicar@lintvern:/$ ls -la /home
total 72
drwxrwsr-x   7 root     staff     4096 2006-01-06 21:54 ./
drwxr-xr-x  21 root     root      4096 2006-01-06 19:26 ../
drwxr-xr-x   2 ftp      nogroup   4096 2006-01-06 21:20 ftp/
drwxr-xr-x   2 jammz    jammz     4096 2006-01-06 21:54 jammz/
drwxr-xr-x   2 root     root     49152 2006-01-06 19:23 lost+found/
drwxr-xr-x   3 ruskicar ruskicar  4096 2006-01-06 21:51 ruskicar/
drwxr-xr-x   3 vmail    vmail     4096 2006-01-06 23:57 vmail/

netstat -tap:

lintvern:~# netstat -tap
Active Internet connections (servers and established)
Proto Recv-Q Send-Q Local Address           Foreign Address         State       PID/Program name
tcp        0      0 localhost.localdo:10024 *:*                     LISTEN     2089/amavisd (maste
tcp        0      0 localhost.localdo:10025 *:*                     LISTEN     12462/master
tcp        0      0 localhost.localdo:mysql *:*                     LISTEN     13032/mysqld
tcp        0      0 lintvern.ne:netbios-ssn *:*                     LISTEN     5789/smbd
tcp        0      0 *:ftp                   *:*                     LISTEN     3112/proftpd: (acce
tcp        0      0 *:smtp                  *:*                     LISTEN     12462/master
tcp        0      0 lintvern.n:microsoft-ds *:*                     LISTEN     5789/smbd
tcp        1      0 localhost.localdo:33011 localhost.localdo:mysql CLOSE_WAIT 2552/amavisd (child
tcp        1      0 localhost.localdo:33023 localhost.localdo:mysql CLOSE_WAIT 2553/amavisd (child
tcp        1      0 localhost.localdo:33056 localhost.localdo:mysql CLOSE_WAIT 2551/amavisd (child
tcp        1      0 localhost.localdo:33041 localhost.localdo:mysql CLOSE_WAIT 2554/amavisd (child
tcp        0      0 lintvern.ne:netbios-ssn pc.lintvern.net:1031    ESTABLISHED11433/smbd
tcp6       0      0 *:imaps                 *:*                     LISTEN     2203/couriertcpd
tcp6       0      0 *:pop3s                 *:*                     LISTEN     2224/couriertcpd
tcp6       0      0 *:pop3                  *:*                     LISTEN     11838/couriertcpd
tcp6       0      0 *:imap2                 *:*                     LISTEN     11823/couriertcpd
tcp6       0      0 *:www                   *:*                     LISTEN     2999/apache2
tcp6       0      0 *:ssh                   *:*                     LISTEN     2442/sshd
tcp6       0      0 *:smtp                  *:*                     LISTEN     12462/master
tcp6       0      0 *:https                 *:*                     LISTEN     2999/apache2
tcp6     104      0 ::ffff:192.168.1.1:ssh  ::ffff:192.168.1.2:2317 ESTABLISHED12325/sshd: ruskica

Regards, RuskiCar

[till]

Please make sure that you dont have any whitespaces behind the values in /etc/courier/authmysqlrc and the other courier files. Courier does not strip whitespaces that where behind any value.

[ruskicar]

Till, I have already checked this twice .

Any other proposals?

Bye,RuskiCar

[falko]

Originally Posted by ruskicar

Yes, /etc/courier/authmysqlrc looks like that (only that I have some lines that are originally in /etc/courier/authmysqlrc and are all commented)

Please try to use the file from the tutorial, without any other lines/comments. Maybe that makes a difference.

What's in /etc/hosts?

[ruskicar]

Hy.

Great! I've really tried to use the same file /etc/courier/authmysqlrc from tutorials, and now user jammz (which is in virtual table) can log in the system. How strange... Thanks.

But I still have the problem with real system users. If I want to send mail to ruskicar, I still get the message:

Jan 7 12:56:41 lintvern postfix/smtpd[12211]: NOQUEUE: reject: RCPT from mta2.siol.net[193.189.160.133]: 550 <ruskicar@lintvern.net>: Recipient address rejected: User unknown in virtual mailbox table; from=<ruskicar@siol.net> to=<ruskicar@lintvern.net> proto=ESMTP helo=<mta2.siol.net>

Here is my /etc/hosts:

127.0.0.1       localhost.localdomain   localhost       lintvern
192.168.1.1     lintvern.net            lintvern
192.168.1.20    pc.lintvern.net         pc
192.168.1.21    notebook.lintvern.net   notebook

# The following lines are desirable for IPv6 capable hosts
::1     ip6-localhost ip6-loopback
fe00::0 ip6-localnet
ff00::0 ip6-mcastprefix
ff02::1 ip6-allnodes
ff02::2 ip6-allrouters
ff02::3 ip6-allhosts

Regards, Drejc

[falko]

Originally Posted by ruskicar

But I still have the problem with real system users. If I want to send mail to ruskicar, I still get the message:

Jan 7 12:56:41 lintvern postfix/smtpd[12211]: NOQUEUE: reject: RCPT from mta2.siol.net[193.189.160.133]: 550 <ruskicar@lintvern.net>: Recipient address rejected: User unknown in virtual mailbox table; from=<ruskicar@siol.net> to=<ruskicar@lintvern.net> proto=ESMTP helo=<mta2.siol.net>

Is lintvern.net a domain that you manage in the Postfix MySQL database? Then you have to create a new virtual user for ruskicar@lintvern.net to be able to accept emails for that address.

[ruskicar]

Yes I manage lintvern.net as a virtual domain in mysql postfix database.
But I don't want to add my email to mysql database, because I want that postfix recognizes me as a real system user. If I add ruskicar@lintvern.net to mysql, than I should put all /etc/aliases to mysql, shouldn't I?

I don't know...is there any other possibility?

Bye, RuskiCar

[ruskicar]

Just something: What if I put some other subdomain in mysql domain list (for example email.lintvern.net). Will then mail for ruskicar@lintvern.net work normal? And if I then add user jammz with /bin/false shell, will he be able to connect my server via pop3?
Because I can make that, if it's about to work ofcourse .

Bye