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

    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

    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

    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

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

Share This Page