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
  #1  
Old 6th July 2007, 23:19
wildgoosed wildgoosed is offline
Member
 
Join Date: Jul 2007
Posts: 46
Thanks: 0
Thanked 0 Times in 0 Posts
Default Virtual Users And Domains With Postfix, Courier And MySQL can't login

Hey everyone,

I just finished following the Virtual Users And Domains With Postfix, Courier And MySQL guide which was very well done

I tried connecting with outlook express and squirremail but both clients cannot connect. I always get a invalid user name or password error :/

I have added the domain and user into my mysql database as instructed.

Can anyone help?

Thanks
Reply With Quote
Sponsored Links
  #2  
Old 7th July 2007, 17:20
falko falko is offline
Super Moderator
 
Join Date: Apr 2005
Location: Lüneburg, Germany
Posts: 41,701
Thanks: 1,900
Thanked 2,741 Times in 2,575 Posts
Default

Do you use the right username? It must be of the form user@domain.com.
__________________
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
  #3  
Old 8th July 2007, 19:42
MattijsR MattijsR is offline
Junior Member
 
Join Date: Feb 2007
Posts: 13
Thanks: 3
Thanked 0 Times in 0 Posts
Default

I have the same problem... Trying to connect with Eudora.

The settings in Eudora are this:
email address: user@xxxxx.nl
user name: user@xxxxx.nl
smtp server: smtp.xxxxx.nl
authentication allowed
incomming mail server: mail.xxxxx.nl
authentication style: passwords
secure sockets when receiving: never

maillog:
Jul 8 19:24:56 fedora pop3d: Connection, ip=[::ffff:192.168.0.1]
Jul 8 19:24:56 fedora pop3d: LOGIN FAILED, user=user@xxxxx.nl, ip=[::ffff:192.168.0.1]
Jul 8 19:24:56 fedora pop3d: authentication error: Input/output error

postconf -n:
alias_database = hash:/etc/postfix/aliases
alias_maps = hash:/etc/postfix/aliases
broken_sasl_auth_clients = yes
command_directory = /usr/sbin
config_directory = /etc/postfix
content_filter = amavis:[127.0.0.1]:10024
daemon_directory = /usr/libexec/postfix
debug_peer_level = 2
html_directory = /usr/share/doc/postfix-2.4.3-documentation/html
inet_interfaces = all
mail_owner = postfix
mailq_path = /usr/bin/mailq.postfix
manpage_directory = /usr/share/man
mydestination = mail.xxxxx.nl, localhost, localhost.localdomain
myhostname = mail.xxxxx.nl
mynetworks = 127.0.0.0/8
newaliases_path = /usr/bin/newaliases.postfix
proxy_read_maps = $local_recipient_maps $mydestination $virtual_alias_maps $virtual_alias_domains $virtual_mailbox_maps $virtual_mailbox_domains $relay_recipient_maps $relay_domains $canonical_maps $sender_canonical_maps $recipient_canonical_maps $relocated_maps $transport_maps $mynetworks $virtual_mailbox_limit_maps
queue_directory = /var/spool/postfix
readme_directory = /usr/share/doc/postfix-2.4.3-documentation/readme
receive_override_options = no_address_mappings
sample_directory = /etc/postfix
sendmail_path = /usr/sbin/sendmail.postfix
setgid_group = postdrop
smtpd_recipient_restrictions = permit_mynetworks, permit_sasl_authenticated, reject_unauth_destination
smtpd_sasl_auth_enable = yes
smtpd_tls_cert_file = /etc/postfix/smtpd.crt
smtpd_tls_key_file = /etc/postfix/smtpd.key
smtpd_use_tls = yes
transport_maps = proxy:mysql:/etc/postfix/mysql-virtual_transports.cf
unknown_local_recipient_reject_code = 550
virtual_alias_domains =
virtual_alias_maps = proxy:mysql:/etc/postfix/mysql-virtual_forwardings.cf, mysql:/etc/postfix/mysql-virtual_email2email.cf
virtual_create_maildirsize = yes
virtual_gid_maps = static:5000
virtual_mailbox_base = /home/vmail
virtual_mailbox_domains = proxy:mysql:/etc/postfix/mysql-virtual_domains.cf
virtual_mailbox_limit_maps = proxy:mysql:/etc/postfix/mysql-virtual_mailbox_limit_maps.cf
virtual_mailbox_limit_override = yes
virtual_mailbox_maps = proxy:mysql:/etc/postfix/mysql-virtual_mailboxes.cf
virtual_maildir_limit_message = "The user you are trying to reach is over quota."
virtual_overquota_bounce = yes
virtual_uid_maps = static:5000

Any ideas where I went wrong?

Thanks,
Mitzi

Last edited by MattijsR; 8th July 2007 at 22:20.
Reply With Quote
  #4  
Old 8th July 2007, 22:20
MattijsR MattijsR is offline
Junior Member
 
Join Date: Feb 2007
Posts: 13
Thanks: 3
Thanked 0 Times in 0 Posts
Default

After searching some more I found a post from Falco that en email has to be send to the account before the Maildir is created.

But doing that got the following result in maillog:
Jul 8 22:17:47 fedora postfix/smtpd[11686]: fatal: open database /etc/postfix/aliases.db: No such file or directory
Jul 8 22:17:48 fedora postfix/master[11075]: warning: process /usr/libexec/postfix/smtpd pid 11686 exit status 1
Jul 8 22:17:48 fedora postfix/master[11075]: warning: /usr/libexec/postfix/smtpd: bad command startup -- throttling
Reply With Quote
  #5  
Old 9th July 2007, 17:04
falko falko is offline
Super Moderator
 
Join Date: Apr 2005
Location: Lüneburg, Germany
Posts: 41,701
Thanks: 1,900
Thanked 2,741 Times in 2,575 Posts
Default

Quote:
Originally Posted by Mitzi
Jul 8 22:17:47 fedora postfix/smtpd[11686]: fatal: open database /etc/postfix/aliases.db: No such file or directory
What are the outputs of
Code:
ls -l /etc/aliases*
and
Code:
ls -l /etc/postfix/aliases*
?
__________________
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
  #6  
Old 9th July 2007, 18:34
wildgoosed wildgoosed is offline
Member
 
Join Date: Jul 2007
Posts: 46
Thanks: 0
Thanked 0 Times in 0 Posts
Default

These are my outputs...

root@test:~# ls -l /etc/aliases*
-rw-r--r-- 1 root root 68 2007-07-06 14:11 /etc/aliases
-rw-r--r-- 1 root root 12288 2007-07-06 14:11 /etc/aliases.db
root@test:~# ls -l /etc/postfix/aliases*
-rw-r--r-- 1 root root 68 2007-07-06 11:48 /etc/postfix/aliases
root@test:~#

What log files should I be checking ?
Reply With Quote
  #7  
Old 9th July 2007, 22:52
wildgoosed wildgoosed is offline
Member
 
Join Date: Jul 2007
Posts: 46
Thanks: 0
Thanked 0 Times in 0 Posts
Default

I did a tail -f on /var/log/syslog and this is how my attempted login went...

Jul 9 14:48:01 test imaplogin: Connection, ip=[::ffff:127.0.0.1]
Jul 9 14:48:01 test imaplogin: LOGIN: DEBUG: ip=[::ffff:127.0.0.1], command=LOGIN
Jul 9 14:48:01 test imaplogin: LOGIN: DEBUG: ip=[::ffff:127.0.0.1], username=david@test.iainc.local
Jul 9 14:48:01 test imaplogin: LOGIN: DEBUG: ip=[::ffff:127.0.0.1], password=fred
Jul 9 14:48:01 test imaplogin: authdaemon: starting client module
Jul 9 14:48:02 test imaplogin: authdaemon: REJECT
Jul 9 14:48:07 test imaplogin: LOGIN FAILED, ip=[::ffff:127.0.0.1]
Jul 9 14:48:07 test imaplogin: LOGIN: DEBUG: ip=[::ffff:127.0.0.1], command=LOGOUT
Jul 9 14:48:07 test imaplogin: LOGOUT, ip=[::ffff:127.0.0.1]


I figured perhaps its a problem with authmysql ? This is what my authmysqlrc file looks like under /etc/courier/authmysqlrc...

MYSQL_SERVER localhost

MYSQL_USERNAME mail_admin

MYSQL_PASSWORD test

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
Reply With Quote
  #8  
Old 9th July 2007, 22:55
wildgoosed wildgoosed is offline
Member
 
Join Date: Jul 2007
Posts: 46
Thanks: 0
Thanked 0 Times in 0 Posts
Default

Also, here is my postconf -n output...

root@test:/var/log# postconf -n
alias_database = hash:/etc/aliases
alias_maps = hash:/etc/aliases
append_dot_mydomain = no
biff = no
broken_sasl_auth_clients = yes
config_directory = /etc/postfix
content_filter = amavis:[127.0.0.1]:10024
delay_warning_time = 4h
disable_vrfy_command = yes
inet_interfaces = all
local_recipient_maps =
mailbox_size_limit = 0
maximal_backoff_time = 8000s
maximal_queue_lifetime = 7d
minimal_backoff_time = 1000s
mydestination = test.iainc.local, localhost, localhost.localdomain
myhostname = test.iainc.local
mynetworks = 127.0.0.0/8
mynetworks_style = host
myorigin = /etc/mailname
proxy_read_maps = $local_recipient_maps $mydestination $virtual_alias_maps $virtual_alias_domains $virtual_mailbox_maps $virtual_ mailbox_domains $relay_recipient_maps $relay_domains $canonical_maps $sender_canonical_maps $recipient_canonical_maps $relocated_ maps $transport_maps $mynetworks $virtual_mailbox_limit_maps
receive_override_options = no_address_mappings
recipient_delimiter = +
relayhost =
smtp_helo_timeout = 60s
smtp_tls_session_cache_database = btree:${queue_directory}/smtp_scache
smtpd_banner = $myhostname ESMTP $mail_name (Ubuntu)
smtpd_client_restrictions = reject_rbl_client sbl.spamhaus.org, reject_rbl_client relays.ordb.org, reject_rbl_client blackholes.e asynet.nl, reject_rbl_client dnsbl.njabl.org
smtpd_hard_error_limit = 12
smtpd_recipient_limit = 16
smtpd_recipient_restrictions = permit_mynetworks, permit_sasl_authenticated, reject_unauth_destination
smtpd_sasl_auth_enable = yes
smtpd_sender_restrictions = permit_mynetworks, warn_if_reject reject_non_fqdn_sender, reject_unknown_sender_domain, reject_unauth _pipelining, permit
smtpd_tls_cert_file = /etc/postfix/smtpd.cert
smtpd_tls_key_file = /etc/postfix/smtpd.key
smtpd_tls_session_cache_database = btree:${queue_directory}/smtpd_scache
smtpd_use_tls = yes
transport_maps = proxy:mysql:/etc/postfix/mysql-virtual_transports.cf
unknown_local_recipient_reject_code = 450
virtual_alias_domains =
virtual_alias_maps = proxy:mysql:/etc/postfix/mysql-virtual_forwardings.cf, mysql:/etc/postfix/mysql-virtual_email2email.cf
virtual_gid_maps = static:5000
virtual_mailbox_base = /home/vmail
virtual_mailbox_domains = proxy:mysql:/etc/postfix/mysql-virtual_domains.cf
virtual_mailbox_maps = proxy:mysql:/etc/postfix/mysql-virtual_mailboxes.cf
virtual_uid_maps = static:5000
Reply With Quote
  #9  
Old 9th July 2007, 23:05
wildgoosed wildgoosed is offline
Member
 
Join Date: Jul 2007
Posts: 46
Thanks: 0
Thanked 0 Times in 0 Posts
Default

Can someone post the correct commands to use telnet with smtp-auth to send an email? I wanna test that things are actually working :/
Reply With Quote
  #10  
Old 10th July 2007, 07:34
MattijsR MattijsR is offline
Junior Member
 
Join Date: Feb 2007
Posts: 13
Thanks: 3
Thanked 0 Times in 0 Posts
 
Default

Quote:
Originally Posted by falko
What are the outputs of
Code:
ls -l /etc/aliases*
and
Code:
ls -l /etc/postfix/aliases*
?

[root@fedora ~]# ll /etc/aliases*
-rw-r--r-- 1 root root 1512 2005-04-25 18:48 /etc/aliases
-rw-r----- 1 root smmsp 12288 2007-07-07 05:51 /etc/aliases.db
[root@fedora ~]# ll /etc/postfix/aliases*
ls: cannot access /etc/postfix/aliases*: No such file or directory
[root@fedora ~]#

Seeing my problem... Thanks

Other problem is that telnet localhost 25 hangs after Escape character is '^]'.
And other things got messed up also.
I'll do a clean install.
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 Secondary MX acoghlan HOWTO-Related Questions 1 8th March 2008 05:02
Virtual Users And Domains With Postfix, Courier And MySQL Login Problem BCNW HOWTO-Related Questions 6 4th January 2007 01:43
Virtual Users And Domains With Postfix, Courier And MySQL [+ procmail ?] immobilia HOWTO-Related Questions 5 29th June 2006 23:20
Virtual Users And Domains With Postfix, Courier And MySQL - "apt-get" and Courier burritonator HOWTO-Related Questions 3 15th March 2006 20:11
Problem with Virtual Users And Domains With Postfix, Courier And MySQL Howto fenix Server Operation 4 11th March 2006 02:53


All times are GMT +2. The time now is 04:49.


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