Go Back   HowtoForge Forums | HowtoForge - Linux Howtos and Tutorials > Linux Forums > Installation/Configuration

Do you like HowtoForge? Please consider supporting us by becoming a subscriber.
Closed Thread
 
Thread Tools Display Modes
  #21  
Old 10th November 2005, 09:28
oaky oaky is offline
Junior Member
 
Join Date: Nov 2005
Location: Salzburg / Austria
Posts: 14
Thanks: 0
Thanked 0 Times in 0 Posts
Default

Quote:
Originally Posted by falko
What's in /etc/courier/authmysqlrc? Do you have authmodulelist="authmysql" in /etc/courier/authdaemonrc?
I tried it also with "MYSQL_SERVER 127.0.0.1". Do I have to restart any program?
Code:
MYSQL_SERVER localhost
MYSQL_USERNAME mail_admin
MYSQL_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


Code:
#
# The authentication modules that are linked into authdaemond.  The
# default list is installed.  You may selectively disable modules simply
# by removing them from the following list.  The available modules you
# can use are: authcustom authcram authuserdb authldap authmysql authpam

authmodulelist="authmysql"
Sponsored Links
  #22  
Old 10th November 2005, 09:36
till till is offline
Super Moderator
 
Join Date: Apr 2005
Location: Lüneburg, Germany
Posts: 35,774
Thanks: 821
Thanked 5,331 Times in 4,183 Posts
Default

Please check the courier config files if you have any whitespces behind the values. Courier is very picky with that. I had this in one setup and searched for hours until i found the whitespace... Most other programs are ignoring whitespaces behind values in config files.

Example:

This will work:

MYSQL_USERNAME mail_admin

This wont work:

MYSQL_USERNAME mail_admin[WHITESPACE]
  #23  
Old 10th November 2005, 09:47
falko falko is offline
Super Moderator
 
Join Date: Apr 2005
Location: Lüneburg, Germany
Posts: 41,701
Thanks: 1,900
Thanked 2,740 Times in 2,575 Posts
Default

Quote:
Originally Posted by oaky
I tried it also with "MYSQL_SERVER 127.0.0.1". Do I have to restart any program?
Yes:
Code:
/etc/init.d/courier-authdaemon restart
Is the uid/gid of user/group vmail really 5000?
__________________
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:
  #24  
Old 10th November 2005, 09:52
oaky oaky is offline
Junior Member
 
Join Date: Nov 2005
Location: Salzburg / Austria
Posts: 14
Thanks: 0
Thanked 0 Times in 0 Posts
Default

Quote:
Originally Posted by till
Please check the courier config files if you have any whitespces behind the values. Courier is very picky with that. I had this in one setup and searched for hours until i found the whitespace... Most other programs are ignoring whitespaces behind values in config files.

Example:

This will work:

MYSQL_USERNAME mail_admin

This wont work:

MYSQL_USERNAME mail_admin[WHITESPACE]
I had whitespaces after mail_admin and password.

...but nothing has changed, do I have to restart any program?
  #25  
Old 10th November 2005, 09:58
till till is offline
Super Moderator
 
Join Date: Apr 2005
Location: Lüneburg, Germany
Posts: 35,774
Thanks: 821
Thanked 5,331 Times in 4,183 Posts
Default

Yes. Go to /etc/init.d/ and restart everything with courier in the name.
  #26  
Old 10th November 2005, 10:40
oaky oaky is offline
Junior Member
 
Join Date: Nov 2005
Location: Salzburg / Austria
Posts: 14
Thanks: 0
Thanked 0 Times in 0 Posts
Default

Quote:
Originally Posted by till
Yes. Go to /etc/init.d/ and restart everything with courier in the name.
Thank you, that was one problem!

But now I get:

"Unable to open the maildir for this account -- the maildir doesn't exist or has incorrect ownership or permissions."

I will search for this problem in the forum....
  #27  
Old 10th November 2005, 11:02
falko falko is offline
Super Moderator
 
Join Date: Apr 2005
Location: Lüneburg, Germany
Posts: 41,701
Thanks: 1,900
Thanked 2,740 Times in 2,575 Posts
Default

Quote:
Originally Posted by oaky

"Unable to open the maildir for this account -- the maildir doesn't exist or has incorrect ownership or permissions."
When does it happen? When you send an email to that account, or when you try to fetch emails with POP3/IMAP? In the latter case you first have to send an email to the account in question - the Maildir will then be created.
__________________
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:
  #28  
Old 10th November 2005, 11:18
oaky oaky is offline
Junior Member
 
Join Date: Nov 2005
Location: Salzburg / Austria
Posts: 14
Thanks: 0
Thanked 0 Times in 0 Posts
Default

Quote:
Originally Posted by falko
When does it happen? When you send an email to that account, or when you try to fetch emails with POP3/IMAP? In the latter case you first have to send an email to the account in question - the Maildir will then be created.
It happens when I want to fetch emails with sqwebmail.

I wrote allready an email to this account.

Should there be a folder in /home/vmail ? Because there is no folder.

Is there a log where I can see if the mail has arrived at my mailserver because I get no "undeliverable" message from my provider.

Code:
Nov 10 10:04:00 m34s12 courierpop3login: LOGIN FAILED, ip=[::ffff:62.47.184.28]
Nov 10 10:04:09 m34s12 courierpop3login: LOGIN FAILED, ip=[::ffff:62.47.184.28]
Nov 10 10:05:25 m34s12 last message repeated 2 times
Nov 10 10:06:07 m34s12 postfix/trivial-rewrite[24810]: warning: do not list domain m34s12.vlinux.de in BOTH mydestination and virtual_mailbox_domains

Last edited by oaky; 10th November 2005 at 11:38.
  #29  
Old 10th November 2005, 11:47
falko falko is offline
Super Moderator
 
Join Date: Apr 2005
Location: Lüneburg, Germany
Posts: 41,701
Thanks: 1,900
Thanked 2,740 Times in 2,575 Posts
Default

Quote:
Originally Posted by oaky
Is there a log where I can see if the mail has arrived at my mailserver because I get no "undeliverable" message from my provider.
Yes, /var/log/mail.log.

Quote:
Originally Posted by oaky
Code:
Nov 10 10:06:07 m34s12 postfix/trivial-rewrite[24810]: warning: do not list domain m34s12.vlinux.de in BOTH mydestination and virtual_mailbox_domains
You have m34s12.vlinux.de in both mydestination and in the domains table in the database. Remove it from one of them and restart Postfix!
__________________
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:
  #30  
Old 10th November 2005, 12:01
oaky oaky is offline
Junior Member
 
Join Date: Nov 2005
Location: Salzburg / Austria
Posts: 14
Thanks: 0
Thanked 0 Times in 0 Posts
 
Default

I removed it and restarted postfix...

mail.log

Code:
Nov 10 10:48:16 m34s12 postfix/smtpd[1789]: connect from warsl404pip7.highway.telekom.at[195.3.96.91]
Nov 10 10:48:16 m34s12 postfix/smtpd[1789]: 2B590333D5: client=warsl404pip7.highway.telekom.at[195.3.96.91]
Nov 10 10:48:16 m34s12 postfix/cleanup[1797]: 2B590333D5: message-id=<20051110104816.2B590333D5@m34s12.vlinux.de>
Nov 10 10:48:16 m34s12 postfix/qmgr[1702]: 2B590333D5: from=<michael.eichriedler@aon.at>, size=1030, nrcpt=1 (queue active)
Nov 10 10:48:16 m34s12 postfix/qmgr[1702]: 2B590333D5: to=<office@m34s12.vlinux.de>, relay=none, delay=0, status=deferred (delivery temporarily suspended: connect to 127.0.0.1[127.0.0.1]: server dropped connection without sending the initial SMTP greeting)
Nov 10 10:48:16 m34s12 postfix/smtpd[1789]: disconnect from warsl404pip7.highway.telekom.at[195.3.96.91]
Closed Thread

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 21:45
Problems with postfix vervem Installation/Configuration 5 27th March 2008 19:40
Virtual Users And Domains With Postfix, Courier And MySQL (+ SMTP-AUTH, Quota, SpamAs pontifex HOWTO-Related Questions 2 26th October 2005 17:54
Removed PostFix, Now MySql Problems!!! sapient Installation/Configuration 10 24th October 2005 07:11
postfix problems. jernis Installation/Configuration 2 16th September 2005 21:14


All times are GMT +2. The time now is 10:11.


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