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 10th July 2007, 15:37
falko falko is offline
Super Moderator
 
Join Date: Apr 2005
Location: Lneburg, Germany
Posts: 41,701
Thanks: 1,900
Thanked 2,741 Times in 2,575 Posts
Default

Quote:
Originally Posted by Mitzi
[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
Did you fix it (by changing the values in /etc/postfix/main.cf and restarting Postfix)?

Quote:
Originally Posted by Mitzi
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.
Any errors in your mail log? What's the output of
Code:
postconf -n
and
Code:
hostname -f
?
__________________
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
The Following User Says Thank You to falko For This Useful Post:
Mitzi (11th July 2007)
Sponsored Links
  #12  
Old 10th July 2007, 20:59
MattijsR MattijsR is offline
Junior Member
 
Join Date: Feb 2007
Posts: 13
Thanks: 3
Thanked 0 Times in 0 Posts
Default

postconf -n
Code:
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 $virtu              al_mailbox_domains $relay_recipient_maps $relay_domains $canonical_maps $sender_canonical_maps $recipient_canonical_maps $relo              cated_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_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
hostname -f
Code:
fedora.xxxxx.nl

Last edited by MattijsR; 11th July 2007 at 22:15.
Reply With Quote
  #13  
Old 11th July 2007, 16:39
falko falko is offline
Super Moderator
 
Join Date: Apr 2005
Location: Lneburg, Germany
Posts: 41,701
Thanks: 1,900
Thanked 2,741 Times in 2,575 Posts
Default

Please create an A record for fedora.mellowtown.nl and run
Code:
postconf -e 'alias_database = hash:/etc/aliases'
postconf -e 'alias_maps = hash:/etc/aliases'
postconf -e 'myorigin = fedora.mellowtown.nl'
/etc/init.d/postfix restart
__________________
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
  #14  
Old 11th July 2007, 17:21
MattijsR MattijsR is offline
Junior Member
 
Join Date: Feb 2007
Posts: 13
Thanks: 3
Thanked 0 Times in 0 Posts
Default

But I want to use mail.xxxxx.nl as address for incomming mail.
Do I have to change the hostname of the server to mail.xxxxx.nl?

Last edited by MattijsR; 11th July 2007 at 22:15.
Reply With Quote
  #15  
Old 11th July 2007, 17:22
falko falko is offline
Super Moderator
 
Join Date: Apr 2005
Location: Lneburg, Germany
Posts: 41,701
Thanks: 1,900
Thanked 2,741 Times in 2,575 Posts
Default

The A record for mail.mellowtown.nl is already existing, so you don't have to create that one.

Change the above commands to
Code:
postconf -e 'alias_database = hash:/etc/aliases'
postconf -e 'alias_maps = hash:/etc/aliases'
postconf -e 'myorigin = mail.mellowtown.nl'
/etc/init.d/postfix restart
__________________
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
The Following User Says Thank You to falko For This Useful Post:
Mitzi (11th July 2007)
  #16  
Old 11th July 2007, 17:52
MattijsR MattijsR is offline
Junior Member
 
Join Date: Feb 2007
Posts: 13
Thanks: 3
Thanked 0 Times in 0 Posts
Default

Thanks, got a bit further, but still not all the way

Code:
Jul 11 17:24:41 fedora postfix/smtpd[5126]: connect from post-24.mail.nl.xxxxx.net[194.159.73.194]
Jul 11 17:24:42 fedora postfix/smtpd[5126]: 2177CAC2D6: client=post-24.mail.nl.xxxxx.net[194.159.73.194]
Jul 11 17:24:42 fedora postfix/cleanup[5137]: 2177CAC2D6: message-id=<20070711152442.2177CAC2D6@mail.xxxxx.nl>
Jul 11 17:24:42 fedora postfix/qmgr[5123]: 2177CAC2D6: from=<mail@xxxxxx.xxxxx.nl>, size=790, nrcpt=1 (queue active)
Jul 11 17:24:42 fedora postfix/smtpd[5126]: disconnect from post-24.mail.nl.demon.net[194.159.73.194]
Jul 11 17:24:43 fedora clamd.amavisd[1702]: SelfCheck: Database status OK.
Jul 11 17:24:46 fedora postfix/smtpd[5143]: connect from unknown[127.0.0.1]
Jul 11 17:24:46 fedora postfix/smtpd[5143]: 50BE8AC2DE: client=unknown[127.0.0.1]
Jul 11 17:24:46 fedora postfix/cleanup[5137]: 50BE8AC2DE: message-id=<20070711152442.2177CAC2D6@mail.xxxxx.nl>
Jul 11 17:24:46 fedora postfix/qmgr[5123]: 50BE8AC2DE: from=<mail@xxxxx.xxxxx.nl>, size=1379, nrcpt=1 (queue active)
Jul 11 17:24:46 fedora amavis[2088]: (02088-01) Passed CLEAN, [194.159.73.194] [83.160.144.39] <mail@xxxxx.xxxxx.nl> -
> <user@xxxxx.nl>, Message-ID: <20070711152442.2177CAC2D6@mail.xxxxx.nl>, mail_id: 5atA-bIwi-e2, Hits: 2.899, size
: 790, queued_as: 50BE8AC2DE, 4192 ms
Jul 11 17:24:46 fedora postfix/smtp[5138]: 2177CAC2D6: to=<user@xxxxx.nl>, relay=127.0.0.1[127.0.0.1]:10024, delay=4.7,
 delays=0.34/0.14/0.07/4.2, dsn=2.0.0, status=sent (250 2.0.0 Ok: queued as 50BE8AC2DE)
Jul 11 17:24:46 fedora postfix/qmgr[5123]: 2177CAC2D6: removed
Jul 11 17:24:46 fedora postfix/smtpd[5143]: disconnect from unknown[127.0.0.1]
Jul 11 17:24:46 fedora postfix/virtual[5145]: 50BE8AC2DE: to=<user@xxxxx.nl>, relay=virtual, delay=0.49, delays=0.1/0.2
9/0/0.1, dsn=2.0.0, status=sent (delivered to maildir)
Jul 11 17:24:46 fedora postfix/qmgr[5123]: 50BE8AC2DE: removed
Jul 11 17:26:04 fedora pop3d: Connection, ip=[::ffff:192.168.0.1]
Jul 11 17:26:05 fedora pop3d: LOGIN FAILED, user=user@xxxxx.nl, ip=[::ffff:192.168.0.1]
It looks like the mail is recieved, but if i try to log in with eudora, it fails to login.

Using user@xxxxx.nl to log in. But I don't get the password.
When I use phpMyAdmin to add the account I put encrypt in the function. But if I remove the password and fill it again, it shows another encrypted word then before.
Might the be why I can't log in???

Last edited by MattijsR; 11th July 2007 at 22:17.
Reply With Quote
  #17  
Old 11th July 2007, 17:57
theMikeroy theMikeroy is offline
Junior Member
 
Join Date: Sep 2006
Posts: 4
Thanks: 0
Thanked 0 Times in 0 Posts
Default

But if I remove the password and fill it again, it shows another encrypted word then before.
Might the be why I can't log in???
If I'm not mistaken, MySQL's ENCRYPT() function uses a random salt if none is explicitly given, which means that the same password will always encrypt differently unless you specify the salt to use.

MySQL will remember the salt it used (somehow?) but it's designed that way so encrypted stuff can't be reverted back easily (if at all). I can't see this affecting the password issue you're having, but you never know.

the ENCRYPT() function uses the system's Crypt library, so unless there's something weird about their relationship, I don't think it's what's causing the issue you're experiencing.

If I'm wrong, my apologies, I just thought I'd try to offer some help rather than always just bugging Falco =)

Last edited by theMikeroy; 11th July 2007 at 17:59.
Reply With Quote
  #18  
Old 11th July 2007, 19:03
MattijsR MattijsR is offline
Junior Member
 
Join Date: Feb 2007
Posts: 13
Thanks: 3
Thanked 0 Times in 0 Posts
Default

Makes sense Mike...

But who can I check where the login fails?
Reply With Quote
  #19  
Old 11th July 2007, 21:34
MattijsR MattijsR is offline
Junior Member
 
Join Date: Feb 2007
Posts: 13
Thanks: 3
Thanked 0 Times in 0 Posts
 
Talking Solved!!!

On www.courier-mta.org/authlib/README.authdebug.html I found how to debug the login.

Code:
Jul 11 21:18:25 fedora pop3d: Connection, ip=[::ffff:127.0.0.1]
Jul 11 21:18:48 fedora authdaemond: received auth request, service=pop3, authtype=login
Jul 11 21:18:48 fedora authdaemond: authmysql: trying this module
Jul 11 21:18:48 fedora authdaemond: SQL query: SELECT email, password, password, 5000, 5000, /home/vmail, CONCAT(SUBSTRING_INDEX(email,'@',-1),'/',SUBSTRING_INDEX(email,'@',1),'/'), quota, "", "" FROM users WHERE email = "user@xxxxx.nl"
Jul 11 21:18:48 fedora authdaemond: mysql_query failed, reconnecting: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '/home/vmail, CONCAT(SUBSTRING_INDEX(email,'@',-1),'/',SUBSTRING_INDEX(email,'@',' at line 1
Jul 11 21:18:48 fedora authdaemond: mysql_query failed second time, giving up: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '/home/vmail, CONCAT(SUBSTRING_INDEX(email,'@',-1),'/',SUBSTRING_INDEX(email,'@',' at line 1
Jul 11 21:18:48 fedora authdaemond: authmysql: TEMPFAIL - no more modules will be tried
Jul 11 21:18:48 fedora pop3d: LOGIN FAILED, user=user@xxxxx.nl, ip=[::ffff:127.0.0.1]
Jul 11 21:18:48 fedora pop3d: authentication error: Input/output error
The SQL syntax is in /etc/authlib/authmysqlrc and my mistake was
MYSQL_HOME_FIELD /home/vmail

but should be
MYSQL_HOME_FIELD "/home/vmail"

Thanks for your help!!!

Last edited by MattijsR; 11th July 2007 at 22:14.
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:29.


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