Unable to login into my mail account?

Discussion in 'Installation/Configuration' started by maqsood22, Jan 30, 2013.

  1. maqsood22

    maqsood22 New Member

  2. till

    till Super Moderator Howtoforge Staff HowtoForge Supporter ISPConfig Developer

    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.
     
  3. maqsood22

    maqsood22 New Member

    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 ??? :(
     
  4. falko

    falko Super Moderator Howtoforge Staff Moderator HowtoForge Supporter ISPConfig Developer

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

    maqsood22 New Member

    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))
     
  6. falko

    falko Super Moderator Howtoforge Staff Moderator HowtoForge Supporter ISPConfig Developer

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

    maqsood22 New Member

    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 “
     
  8. falko

    falko Super Moderator Howtoforge Staff Moderator HowtoForge Supporter ISPConfig Developer

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

Share This Page