HowtoForge Forums | HowtoForge - Linux Howtos and Tutorials

HowtoForge Forums | HowtoForge - Linux Howtos and Tutorials (http://www.howtoforge.com/forums/index.php)
-   Installation/Configuration (http://www.howtoforge.com/forums/forumdisplay.php?f=4)
-   -   Unable to login into my mail account? (http://www.howtoforge.com/forums/showthread.php?t=60373)

maqsood22 30th January 2013 10:46

Unable to login into my mail account?
 
Using this link (http://www.howtoforge.com/virtual-us...l-ubuntu-12.10) I configured my Postfix mail server onto my Ubuntu 12.10 machine.
After completing the configuration, while I am trying to login i receives this error message.
"ERROR:
ERROR: Connection dropped by IMAP server
"

Please guide me in this regard

till 30th January 2013 11:09

The mailfir of the account does not exist yet, so you cant login. Send a email to the email address so postfix creates the maildir.

maqsood22 31st January 2013 09:43

I followed all the steps given in above link very carefully. And, didn't missed any step. I don't know why even then i am facing such problems ??? :(

falko 31st January 2013 17:07

Are there any errors in your mail log (in the /var/log/ directory)?

maqsood22 1st February 2013 13:00

Log is given below,please check and guide


Jan 30 22:23:35 lroms postfix/trivial-rewrite[3881]: warning: transport_maps lookup failure
Jan 30 22:23:35 lroms postfix/trivial-rewrite[3881]: warning: proxy:mysql:/etc/postfix/mysql-virtual_domains.cf: table lookup problem
Jan 30 22:23:35 lroms postfix/trivial-rewrite[3881]: warning: proxy:mysql:/etc/postfix/mysql-virtual_transports.cf lookup error for "sales@lroms.com"
Jan 30 22:23:35 lroms postfix/trivial-rewrite[3881]: warning: transport_maps lookup failure
Jan 30 22:23:35 lroms postfix/smtpd[3879]: 5E1653E0AD9: client=localhost[127.0.0.1]
Jan 30 22:23:35 lroms postfix/proxymap[3880]: warning: connect to mysql server 127.0.0.1: Access denied for user 'mail_admin'@'localhost' (using password: YES)
Jan 30 22:23:35 lroms postfix/cleanup[3883]: warning: proxy:mysql:/etc/postfix/mysql-virtual_forwardings.cf lookup error for "sales@lroms.com"
Jan 30 22:23:35 lroms postfix/cleanup[3883]: warning: 5E1653E0AD9: virtual_alias_maps map lookup problem for sales@lroms.com -- deferring delivery
Jan 30 22:23:35 lroms amavis[2476]: (02476-05) Negative SMTP response to data-dot (<sales@lroms.com>): 451 4.3.0 Error: queue file write error
Jan 30 22:23:35 lroms postfix/cleanup[3883]: warning: proxy:mysql:/etc/postfix/mysql-virtual_forwardings.cf lookup error for "postmaster@lroms.com"
Jan 30 22:23:35 lroms postfix/cleanup[3883]: warning: 5E8343E0AD9: virtual_alias_maps map lookup problem for postmaster@lroms.com -- deferring delivery
Jan 30 22:23:35 lroms postfix/smtpd[3879]: disconnect from localhost[127.0.0.1]
Jan 30 22:23:35 lroms amavis[2476]: (02476-05) (!)FWD from <root@lroms.com> -> <sales@lroms.com>,BODY=7BIT 451 4.3.0 from MTA(smtp:[127.0.0.1]:10025): 451 4.3.0 Error:$
Jan 30 22:23:35 lroms amavis[2476]: (02476-05) Blocked MTA-BLOCKED {TempFailedInbound}, <root@lroms.com> -> <sales@lroms.com>, Message-ID: <20130130112548.59E563E0AD7@$
Jan 30 22:23:35 lroms postfix/smtp[3875]: 59E563E0AD7: to=<sales@lroms.com>, relay=127.0.0.1[127.0.0.1]:10024, delay=21467, delays=21459/0.01/0/8.1, dsn=4.3.0, status=$
Jan 30 23:33:27 lroms postfix/qmgr[2369]: 59E563E0AD7: from=<root@lroms.com>, size=343, nrcpt=1 (queue active)
Jan 30 23:33:33 lroms postfix/smtpd[4215]: connect from localhost[127.0.0.1]
Jan 30 23:33:33 lroms postfix/proxymap[4216]: warning: connect to mysql server 127.0.0.1: Access denied for user 'mail_admin'@'localhost' (using password: YES)
Jan 30 23:33:33 lroms postfix/trivial-rewrite[4217]: warning: proxy:mysql:/etc/postfix/mysql-virtual_transports.cf lookup error for "*"
Jan 30 23:33:33 lroms postfix/trivial-rewrite[4217]: warning: proxy:mysql:/etc/postfix/mysql-virtual_transports.cf lookup error for "*"
Jan 30 23:33:33 lroms postfix/proxymap[4216]: warning: connect to mysql server 127.0.0.1: Access denied for user 'mail_admin'@'localhost' (using password: YES)
Jan 30 23:33:33 lroms postfix/trivial-rewrite[4217]: warning: proxy:mysql:/etc/postfix/mysql-virtual_domains.cf: table lookup problem
Jan 30 23:33:33 lroms postfix/trivial-rewrite[4217]: warning: proxy:mysql:/etc/postfix/mysql-virtual_transports.cf lookup error for "root@lroms.com"
Jan 30 23:33:33 lroms postfix/trivial-rewrite[4217]: warning: transport_maps lookup failure
Jan 30 23:33:33 lroms postfix/trivial-rewrite[4217]: warning: proxy:mysql:/etc/postfix/mysql-virtual_domains.cf: table lookup problem
Jan 30 23:33:33 lroms postfix/trivial-rewrite[4217]: warning: proxy:mysql:/etc/postfix/mysql-virtual_transports.cf lookup error for "sales@lroms.com"
Jan 30 23:33:33 lroms postfix/trivial-rewrite[4217]: warning: transport_maps lookup failure
Jan 30 23:33:33 lroms postfix/smtpd[4215]: AB0B13E0AD9: client=localhost[127.0.0.1]
Jan 30 23:33:33 lroms postfix/proxymap[4216]: warning: connect to mysql server 127.0.0.1: Access denied for user 'mail_admin'@'localhost' (using password: YES)
Jan 30 23:33:33 lroms postfix/cleanup[4219]: warning: proxy:mysql:/etc/postfix/mysql-virtual_forwardings.cf lookup error for "sales@lroms.com"
Jan 30 23:33:33 lroms postfix/cleanup[4219]: warning: AB0B13E0AD9: virtual_alias_maps map lookup problem for sales@lroms.com -- deferring delivery
Jan 30 23:33:33 lroms amavis[2475]: (02475-05) Negative SMTP response to data-dot (<sales@lroms.com>): 451 4.3.0 Error: queue file write error
Jan 30 23:33:33 lroms postfix/cleanup[4219]: warning: proxy:mysql:/etc/postfix/mysql-virtual_forwardings.cf lookup error for "postmaster@lroms.com"
Jan 30 23:33:33 lroms postfix/cleanup[4219]: warning: ABA5B3E0AD9: virtual_alias_maps map lookup problem for postmaster@lroms.com -- deferring delivery
Jan 30 23:33:33 lroms postfix/smtpd[4215]: disconnect from localhost[127.0.0.1]
Jan 30 23:33:33 lroms amavis[2475]: (02475-05) (!)FWD from <root@lroms.com> -> <sales@lroms.com>,BODY=7BIT 451 4.3.0 from MTA(smtp:[127.0.0.1]:10025): 451 4.3.0 Error:$
Jan 30 23:33:33 lroms amavis[2475]: (02475-05) Blocked MTA-BLOCKED {TempFailedInbound}, <root@lroms.com> -> <sales@lroms.com>, Message-ID: <20130130112548.59E563E0AD7@$
$eue file write error (in reply to end of DATA command))

falko 1st February 2013 18:17

Do you use the correct MySQL details in the /etc/postfix/mysql*.cf files?

maqsood22 6th February 2013 10:41

Details of "/etc/postfix/mysql*.cf" files are given below. Please guide me that have I made any mistake in these configuration files.

nano mysql-virtual_domains.cf
“user = mail_admin
password = mail_admin_password
dbname = mail
query = SELECT domain AS virtual FROM domains WHERE domain='%s'
hosts = 127.0.0.1 “

nano mysql-virtual_email2email.cf
“user = mail_admin
password = mail_admin_password
dbname = mail
query = SELECT email FROM users WHERE email='%s'
hosts = 127.0.0.1 “

nano mysql-virtual_forwardings.cf
“user = mail_admin
password = mail_admin_password
dbname = mail
query = SELECT destination FROM forwardings WHERE source='%s'
hosts = 127.0.0.1 “

nano mysql-virtual_mailboxes.cf
“ user = mail_admin
password = mail_admin_password
dbname = mail
query = SELECT CONCAT(SUBSTRING_INDEX(email,'@',-1),'/',SUBSTRING_INDEX(email,'$
hosts = 127.0.0.1 “

nano mysql-virtual_transports.cf
“user = mail_admin
password = mail_admin_password
dbname = mail
query = SELECT transport FROM transport WHERE domain='%s'
hosts = 127.0.0.1 “

falko 9th February 2013 09:47

Are the MySQL details (username, password, database name) correct?


All times are GMT +2. The time now is 22:55.

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