Go Back   HowtoForge Forums | HowtoForge - Linux Howtos and Tutorials > Linux Forums > HOWTO-Related Questions

Do you like HowtoForge? Please consider supporting us by becoming a subscriber.
Reply
 
Thread Tools Display Modes
  #11  
Old 7th January 2006, 13:55
ruskicar ruskicar is offline
Junior Member
 
Join Date: Jan 2006
Location: Slovenia
Posts: 25
Thanks: 0
Thanked 0 Times in 0 Posts
Default

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

Quote:
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>

Last edited by ruskicar; 7th January 2006 at 13:58.
Reply With Quote
Sponsored Links
  #12  
Old 7th January 2006, 16:27
falko falko is offline
Super Moderator
 
Join Date: Apr 2005
Location: Lüneburg, Germany
Posts: 41,701
Thanks: 1,900
Thanked 2,751 Times in 2,581 Posts
Default

Does /etc/courier/authmysqlrc look like this?

Code:
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
Code:
ls -la /home
Also post the output of
Code:
netstat -tap
__________________
Falko
--
Download the ISPConfig 3 Manual! | Check out the ISPConfig 3 Billing Module!

FB: http://www.facebook.com/howtoforge

nginx-Webhosting: Timme Hosting | Follow me on:
Reply With Quote
  #13  
Old 7th January 2006, 16:48
ruskicar ruskicar is offline
Junior Member
 
Join Date: Jan 2006
Location: Slovenia
Posts: 25
Thanks: 0
Thanked 0 Times in 0 Posts
Default

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:
Code:
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:
Code:
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
Reply With Quote
  #14  
Old 7th January 2006, 20:02
till till is offline
Super Moderator
 
Join Date: Apr 2005
Location: Lüneburg, Germany
Posts: 37,015
Thanks: 840
Thanked 5,652 Times in 4,461 Posts
Default

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.
__________________
Till Brehm
--
Get ISPConfig support and the ISPConfig 3 manual from ispconfig.org.
Reply With Quote
  #15  
Old 7th January 2006, 20:26
ruskicar ruskicar is offline
Junior Member
 
Join Date: Jan 2006
Location: Slovenia
Posts: 25
Thanks: 0
Thanked 0 Times in 0 Posts
Default

Till, I have already checked this twice .

Any other proposals?

Bye,RuskiCar
Reply With Quote
  #16  
Old 7th January 2006, 20:56
falko falko is offline
Super Moderator
 
Join Date: Apr 2005
Location: Lüneburg, Germany
Posts: 41,701
Thanks: 1,900
Thanked 2,751 Times in 2,581 Posts
Default

Quote:
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?
__________________
Falko
--
Download the ISPConfig 3 Manual! | Check out the ISPConfig 3 Billing Module!

FB: http://www.facebook.com/howtoforge

nginx-Webhosting: Timme Hosting | Follow me on:
Reply With Quote
  #17  
Old 7th January 2006, 21:08
ruskicar ruskicar is offline
Junior Member
 
Join Date: Jan 2006
Location: Slovenia
Posts: 25
Thanks: 0
Thanked 0 Times in 0 Posts
Default

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:

Code:
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:
Code:
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
Reply With Quote
  #18  
Old 7th January 2006, 21:14
falko falko is offline
Super Moderator
 
Join Date: Apr 2005
Location: Lüneburg, Germany
Posts: 41,701
Thanks: 1,900
Thanked 2,751 Times in 2,581 Posts
Default

Quote:
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:

Code:
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.
__________________
Falko
--
Download the ISPConfig 3 Manual! | Check out the ISPConfig 3 Billing Module!

FB: http://www.facebook.com/howtoforge

nginx-Webhosting: Timme Hosting | Follow me on:
Reply With Quote
  #19  
Old 7th January 2006, 21:20
ruskicar ruskicar is offline
Junior Member
 
Join Date: Jan 2006
Location: Slovenia
Posts: 25
Thanks: 0
Thanked 0 Times in 0 Posts
Default

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
Reply With Quote
  #20  
Old 7th January 2006, 21:24
ruskicar ruskicar is offline
Junior Member
 
Join Date: Jan 2006
Location: Slovenia
Posts: 25
Thanks: 0
Thanked 0 Times in 0 Posts
 
Default

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
Reply With Quote
Reply

Bookmarks

Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off

Forum Jump

Similar Threads
Thread Thread Starter Forum Replies Last Post
Virtual Users And Domains With Postfix, Courier And MySQL (+ SMTP-AUTH, Quota... killfrog HOWTO-Related Questions 3 25th September 2009 22:45
Virtual Users And Domains With Postfix, Courier And MySQL (+ SMTP-AUTH, Quota, SpamAs amilcar HOWTO-Related Questions 1 1st January 2006 18:12
Virtual Users And Domains With Postfix, Courier And MySQL: POP/IMAP authentication SeanG HOWTO-Related Questions 3 1st January 2006 18:08
Virtual Users And Domains With Postfix, Courier And MySQL ariek HOWTO-Related Questions 3 12th December 2005 23:14
Virtual Users And Domains With Postfix, Courier And MySQL (+ SMTP-AUTH, Quota, SpamAs pontifex HOWTO-Related Questions 2 26th October 2005 18:54


All times are GMT +2. The time now is 07:51.


Powered by vBulletin® Version 3.8.7
Copyright ©2000 - 2014, vBulletin Solutions, Inc.