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.
Reply
 
Thread Tools Display Modes
  #1  
Old 21st November 2006, 16:25
kdclaver kdclaver is offline
Member
 
Join Date: Nov 2006
Posts: 51
Thanks: 0
Thanked 2 Times in 2 Posts
Post Unable to retrieve my email via POP

Hello,
I've finished to implement my mail server following the howto "Virtual Users And Domains With Postfix, Courier And MySQL (+ SMTP-AUTH, Quota, SpamAssassin, ClamAV)". All things are running very well. But now, I can retrieve my email via a POP3 client like Outlook Express. Anytime, I must enter the password.
Can you please help me to solve this problem.

Thank you.
Reply With Quote
Sponsored Links
  #2  
Old 22nd November 2006, 10:58
till till is offline
Super Moderator
 
Join Date: Apr 2005
Location: Lneburg, Germany
Posts: 35,486
Thanks: 813
Thanked 5,256 Times in 4,121 Posts
Default

Which errors do you get in the mail.log?
__________________
Till Brehm
--
Get ISPConfig support and the ISPConfig 3 manual from ispconfig.org.
Reply With Quote
  #3  
Old 22nd November 2006, 13:29
kdclaver kdclaver is offline
Member
 
Join Date: Nov 2006
Posts: 51
Thanks: 0
Thanked 2 Times in 2 Posts
Default

This is the message I receive from my client Outlook :

Problme de connexion votre serveur de messagerie. Votre mot de passe a t refus. Compte*: '192.168.2.1', Serveur*: '192.168.2.1', Protocole : POP3, Rponse du serveur : '-ERR Maildir: No such file or directory', Port : 110, Scuris (SSL) : Non, Erreur de serveur : 0x800CCC90, Numro d'erreur : 0x800CCC92
translate ===================================
Connection problem with the mail server. Your password has been reject. Count : 192.168.2.1, Server : 192.168.2.1, Protocol : POP3, Answer of the server: 'ERR Maildir: No such file or directory', Port:110, Secured (SSL): No, Server error:0x800CC90, Error number:0x800CCC92.

Thanks for your help.
Attached Files
File Type: txt maillog.txt (24.0 KB, 225 views)
File Type: txt mailerr.txt (1.0 KB, 208 views)
Reply With Quote
  #4  
Old 22nd November 2006, 16:27
falko falko is offline
Super Moderator
 
Join Date: Apr 2005
Location: Lneburg, Germany
Posts: 41,701
Thanks: 1,900
Thanked 2,735 Times in 2,571 Posts
Default

Quote:
Originally Posted by kdclaver
This is the message I receive from my client Outlook :

Problme de connexion votre serveur de messagerie. Votre mot de passe a t refus. Compte*: '192.168.2.1', Serveur*: '192.168.2.1', Protocole : POP3, Rponse du serveur : '-ERR Maildir: No such file or directory', Port : 110, Scuris (SSL) : Non, Erreur de serveur : 0x800CCC90, Numro d'erreur : 0x800CCC92
translate ===================================
Connection problem with the mail server. Your password has been reject. Count : 192.168.2.1, Server : 192.168.2.1, Protocol : POP3, Answer of the server: 'ERR Maildir: No such file or directory', Port:110, Secured (SSL): No, Server error:0x800CC90, Error number:0x800CCC92.

Thanks for your help.
You must send a mail to that user first before you fetch emails for the first time. Maildir is created when the first email arrives.
__________________
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
  #5  
Old 23rd November 2006, 12:24
kdclaver kdclaver is offline
Member
 
Join Date: Nov 2006
Posts: 51
Thanks: 0
Thanked 2 Times in 2 Posts
Arrow

Hello,
I've send an email to this user. Below you've the log in mail.log
================================================== ==============
Nov 23 11:21:42 marina postfix/smtp[5083]: 6A44A50C45: to=<admins@dpi-arobasetelecom.ci>, relay=127.0.0.1[127.0.0.1], delay=0, status=deferred (host 127.0.0.1[127.0.0.1] said: 451 4.5.0 Error in processing, id=03646-04, creating_partsdir FAILED: DBD::mysql::st execute failed: 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 '("@",domain) IN ('admins@dpi-arobasetelecom.ci','admins','@dpi-a at (eval 38) line 238, <GEN15> line 8. (in reply to end of DATA command))
================================================== ===============
Thanks for your assistance
Reply With Quote
  #6  
Old 23rd November 2006, 16:26
falko falko is offline
Super Moderator
 
Join Date: Apr 2005
Location: Lneburg, Germany
Posts: 41,701
Thanks: 1,900
Thanked 2,735 Times in 2,571 Posts
Default

There's a problem with your MySQL statements. Please make sure your /etc/postfix/mysql*.cf files look like the ones from the tutorial.
__________________
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
  #7  
Old 23rd November 2006, 18:39
kdclaver kdclaver is offline
Member
 
Join Date: Nov 2006
Posts: 51
Thanks: 0
Thanked 2 Times in 2 Posts
Default

These are my /etc/postfix/mysql_virtual* files. As you can see I've put in them all you indicate in the the howto.
I will send you the last early.
Attached Files
File Type: doc mysql-virtual_domains.doc (3.3 KB, 182 views)
File Type: doc mysql-virtual_email2email.doc (3.3 KB, 200 views)
File Type: doc mysql-virtual_forwardings.doc (3.3 KB, 195 views)
File Type: doc mysql-virtual_mailbox_limit_maps.doc (3.3 KB, 195 views)
File Type: doc mysql-virtual_mailboxes.doc (3.3 KB, 185 views)
Reply With Quote
  #8  
Old 23rd November 2006, 18:41
kdclaver kdclaver is offline
Member
 
Join Date: Nov 2006
Posts: 51
Thanks: 0
Thanked 2 Times in 2 Posts
Default

The lastest file.
Thank for your assistance.
Attached Files
File Type: doc mysql-virtual_transports.doc (3.3 KB, 205 views)
Reply With Quote
  #9  
Old 24th November 2006, 15:46
falko falko is offline
Super Moderator
 
Join Date: Apr 2005
Location: Lneburg, Germany
Posts: 41,701
Thanks: 1,900
Thanked 2,735 Times in 2,571 Posts
Default

Please post the files here directly. Do not attach Word documents.
__________________
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
  #10  
Old 27th November 2006, 09:45
kdclaver kdclaver is offline
Member
 
Join Date: Nov 2006
Posts: 51
Thanks: 0
Thanked 2 Times in 2 Posts
 
Post

===== mysql-virtual_domains.cf =====
user = kdclaver
password = emmanuel
dbname = mail
table = domains
select_field = 'virtual'
where_field = domain
hosts = 127.0.0.1

===== mysql-virtual_email2email.cf =====
user = kdclaver
password = emmanuel
dbname = mail
table = users
select_field = email
where_field = email
hosts = 127.0.0.1

===== mysql-virtual_forwardings.cf =====
user = kdclaver
password = emmanuel
dbname = mail
table = forwardings
select_field = destination
where_field = source
hosts = 127.0.0.1

===== mysql-virtual_mailboxes.cf =====
user = kdclaver
password = emmanuel
dbname = mail
table = users
select_field = CONCAT(SUBSTRING_INDEX(email,'@',-1),CONCAT(SUBSTRING_INDEX(email,'@',-1),'/')
where_field = email
hosts = 127.0.0.1

===== mysql-virtual_mailbox_limit_maps.cf =====
user = kdclaver
password = emmanuel
dbname = mail
table = users
select_field = quota
where_field = email
hosts = 127.0.0.1

===== mysql-virtual_transports.cf =====
user = kdclaver
password = emmanuel
dbname = mail
table = transport
select_field = transport
where_field = domain
hosts = 127.0.0.1

These are the configurations pf /etc/postfix/mysql-* files. During the implementation I've just copy and paste all the informations.
Thanks more for your assistance.
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
Can't retrieve email from client cambo Installation/Configuration 13 23rd November 2006 04:08
HotSaNIC domino Tips/Tricks/Mods 23 6th November 2006 05:19
Howto suggestion suse PhP ver 4 + Ver 5 wwparrish Suggest HOWTO 11 7th August 2006 13:29
email forwarding locally consumes all resources rdells General 20 1st May 2006 19:43
Unable to retrieve email roberto Server Operation 2 21st November 2005 22:19


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


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