Jan 11 00:30:41 exampleserver authdaemond: authmysql: MYSQL_SERVER nor MYSQL_SOCKET s

Discussion in 'Installation/Configuration' started by rakeshakurathi, Jan 11, 2010.

  1. rakeshakurathi

    rakeshakurathi New Member

    i was breaking my head to solve this probs from 2 days i cant take it any more
    please any one help me urgent

    this is my mail log,
    i can send mails from mailx, but when i send mail to one of the user from gmail account it bounces back with delivery notification,
    in this log i have tried to connect through thunderbird which resulted in error ,even squirrelmail doesnt work,
    i don know what is the problem


    i followed http://www.howtoforge.com/virtual-us...-ubuntu9.04-p5
    please guys help me any information is helpful

    i have done all the steps 4 times and i dint get any error all the telnet sessions gave me the exact output as in the tutorial. please any one help me....


    log file:-
    Jan 11 00:30:41 exampleserver authdaemond: authmysql: MYSQL_SERVER nor MYSQL_SOCKET set in/etc/courier/authmysqlrc.
    Jan 11 00:30:41 exampleserver authdaemond: authmysql: TEMPFAIL - no more modules will be tried
    Jan 11 00:30:41 exampleserver imapd: LOGIN FAILED, method=PLAIN, ip=[::ffff:90.152.67.122]
    Jan 11 00:30:41 exampleserver imapd: authentication error: Input/output error
    Jan 11 00:31:53 exampleserver postfix/smtpd[4360]: connect from eba.b.xyar.se[xxx.xxx.xx.xx]
    Jan 11 00:31:53 exampleserver postfix/smtpd[4360]: lost connection after CONNECT from eba.b.xyar.se[xxx.xxx.xx.xx]
    Jan 11 00:31:53 exampleserver postfix/smtpd[4360]: disconnect from eba.b.xyar.se[xxx.xxx.xx.xx]
    Jan 11 00:32:34 exampleserver postfix/anvil[4363]: statistics: max connection rate 2/60s for (smtp:90.152.67.122) at Jan 11 00:26:56
    Jan 11 00:32:34 exampleserver postfix/anvil[4363]: statistics: max connection count 1 for (smtp:xxx.xxx.xx.xx) at Jan 11 00:22:34
    Jan 11 00:32:34 exampleserver postfix/anvil[4363]: statistics: max cache size 2 at Jan 11 00:26:44
    Jan 11 00:32:34 exampleserver postfix/smtpd[4360]: connect from eba.b.xyar.se[xxx.xxx.xx.xx]
    Jan 11 00:32:34 exampleserver postfix/smtpd[4360]: lost connection after CONNECT from eba.b.xyar.se[xxx.xxx.xx.xx]
    Jan 11 00:32:34 exampleserver postfix/smtpd[4360]: disconnect from eba.b.xyar.se[xxx.xxx.xx.xx]
    Jan 11 00:33:34 exampleserver postfix/smtpd[4360]: connect from eba.b.xyar.se[xxx.xxx.xx.xx]
    Jan 11 00:33:34 exampleserver postfix/smtpd[4360]: lost connection after CONNECT from eba.b.xyar.se[xxx.xxx.xx.xx]
    Jan 11 00:33:34 exampleserver postfix/smtpd[4360]: disconnect from eba.b.xyar.se[xxx.xxx.xx.xx]
    Jan 11 00:34:01 exampleserver imapd: Connection, ip=[::1]
    Jan 11 00:34:01 exampleserver authdaemond: received auth request, service=imap, authtype=login
    Jan 11 00:34:01 exampleserver authdaemond: authmysql: trying this module
    Jan 11 00:34:01 exampleserver authdaemond: authmysql: MYSQL_SERVER nor MYSQL_SOCKET set in/etc/courier/authmysqlrc.
    Jan 11 00:34:01 exampleserver authdaemond: authmysql: TEMPFAIL - no more modules will be tried
    Jan 11 00:34:01 exampleserver imapd: LOGIN FAILED, [email protected], ip=[::1]
    Jan 11 00:34:01 exampleserver imapd: authentication error: Input/output error
     
  2. falko

    falko Super Moderator Howtoforge Staff

    What's in /etc/courier/authmysqlrc?
     
  3. rakeshakurathi1

    rakeshakurathi1 New Member

    this is rakeshakurathi i have just lost my password so i have created one more accoun

    sorry for double posting the contents after posting the content i though that i have posted in wrong thread, so i have posted it again,

    this is the contents of file which u have requested.

    MYSQL_PASSWORD mail_admin_password
    MYSQL_PORT 0
    MYSQL_DATABASE mail
    MYSQL_USER_TABLE users
    MYSQL_CRYPT_PWFIELD password
    #MYSQL_CLEAR_PWFIELD password
    MYSQL_UID_FIELD 5000
    MYSQL_GID_FIELD 5000
    MYSQL_LOGIN_FIELD email
    MYSQL_HOME_FIELD "/home/vmail"
    MYSQL_MAILDIR_FIELD CONCAT(SUBSTRING_INDEX(email,'@',-1),'/',SUBSTRING_INDEX(email,'@',1),'/')
    #MYSQL_NAME_FIELD
    MYSQL_QUOTA_FIELD quota
    ~
     
  4. rakeshakurathi1

    rakeshakurathi1 New Member

    THanks falko for replying me ...

    thanks a tonn..

    thanks for ur tutorial , its good, i thought i was almost done its worked exactly as u described, but unable to figure out what the error is.

    thanks in advance.
     
  5. falko

    falko Super Moderator Howtoforge Staff

    The file must look as follows:
    Code:
    MYSQL_SERVER localhost
    MYSQL_USERNAME mail_admin
    MYSQL_PASSWORD mail_admin_password
    MYSQL_PORT 0
    MYSQL_DATABASE mail
    MYSQL_USER_TABLE users
    MYSQL_CRYPT_PWFIELD password
    #MYSQL_CLEAR_PWFIELD password
    MYSQL_UID_FIELD 5000
    MYSQL_GID_FIELD 5000
    MYSQL_LOGIN_FIELD email
    MYSQL_HOME_FIELD "/home/vmail"
    MYSQL_MAILDIR_FIELD CONCAT(SUBSTRING_INDEX(email,'@',-1),'/',SUBSTRING_INDEX(email,'@',1),'/')
    #MYSQL_NAME_FIELD
    MYSQL_QUOTA_FIELD quota
    The first two lines are missing in your file.
     
  6. rakeshakurathi1

    rakeshakurathi1 New Member

    hey i have copied the wrong contents

    i have wrongly pasted the contents hear. but i have done the whole process
    again now for the 5th time

    strangely i m able to access the contents its working pretty fine.
    i can send mails to this accont from yahoo. and even tested with sending the mails from web client squirrelmail

    i used thunderbird to login its working fine. but i m not unable to send the messages from thunderbird,
    and i m unable to connect through outlook it seems that we have to create route map what does it mean
    is similar /home/vmail/username
    but it gives me cannot create root map

    now i have created one more user it gives the same error..

    after creation new user i have done these steps

    mkdir /home/vmail/example.com
    chown -R vmail.vmail /home/vmail/example.com/yourname
    maildirmake /home/vmail/example.com/yourname

    now mistakenly i have used the previous username which worked

    now i have following errors
    for first account which worked previously now i cannot send mails even from squirrel nor able to send messages from gmail account

    for the second account it gives me the following error
    ERROR: Could not complete request.
    Query: SELECT "INBOX"
    Reason Given: Unable to open this mailbox.


    is there any process to create a new user account
     
  7. rakeshakurathi1

    rakeshakurathi1 New Member

    even when i create new user i m unable to send him the messages

    can this be fixed, if i m able to login from thunderbird why cant i login from microsoft outlook

    is there is no possibilty to send messages from thunderbird.
     
  8. falko

    falko Super Moderator Howtoforge Staff

    Any errors in your mail log?

    Please make sure you followed the tutorial to the letter - I know that it's working. Please double-check all your configuration files.
     
  9. rakeshakurathi1

    rakeshakurathi1 New Member

    thanks falko for ur concern this is the lod file

    i din find any errors in the log file.....

    i have done following things...
    1)first i have login to squirrel mail with [email protected]
    logged in succesfully, and mailed to my gmail ID its working fine .
    2)i tried to reply back to [email protected] ,i got delivery notification error.
    3)i tried to login from [email protected] from squirrel mail i got error
    ERROR: Could not complete request.
    Query: SELECT "INBOX"
    Reason Given: Unable to open this mailbox.
    4)i have tried to login wiht third account in squirrel mail i go the following error.
    ERROR: Connection dropped by IMAP server.





    id=5000, homedir=/home/vmail, [email protected], fullname=<null>, maildir=serverexample. se/xxx/, quota=10485760, options=<null>
    Jan 13 14:42:55 serverexample authdaemond: Authenticated: clearpasswd=xxx, passwd=UX4SD9F5XqG82
    Jan 13 14:42:55 serverexample imapd: LOGIN, [email protected], ip=[::1], port=[41886], prot ocol=IMAP
    Jan 13 14:42:55 serverexample imapd: LOGOUT, [email protected], ip=[::1], headers=0, body=0 , rcvd=689, sent=203, time=0
    Jan 13 14:42:55 serverexample imapd: Connection, ip=[::1]
    Jan 13 14:42:55 serverexample authdaemond: received auth request, service=imap, authtype=login
    Jan 13 14:42:55 serverexample authdaemond: authmysql: trying this module
    Jan 13 14:42:55 serverexample authdaemond: authmysqllib: connected. Versions: header 50067, client 500 75, server 50075
    Jan 13 14:42:55 serverexample authdaemond: SQL query: SELECT email, password, "", 5000, 5000, "/home/v mail", CONCAT(SUBSTRING_INDEX(email,'@',-1),'/',SUBSTRING_INDEX(email,'@',1),'/'), quota, "", "" FROM us ers WHERE email = '[email protected]'
    Jan 13 14:42:55 serverexample authdaemond: password matches successfully
    Jan 13 14:42:55 serverexample authdaemond: authmysql: sysusername=<null>, sysuserid=5000, sysgroupid=5 000, homedir=/home/vmail, [email protected], fullname=<null>, maildir=serverexample.se/a min/, quota=10485760, options=<null>
    Jan 13 14:42:55 serverexample authdaemond: authmysql: clearpasswd=<null>, passwd=UX4SD9F5XqG82
    Jan 13 14:42:55 serverexample authdaemond: Authenticated: sysusername=<null>, sysuserid=5000, sysgroup id=5000, homedir=/home/vmail, [email protected], fullname=<null>, maildir=serverexample. se/xxx/, quota=10485760, options=<null>
    Jan 13 14:42:55 serverexample authdaemond: Authenticated: clearpasswd=xxx, passwd=UX4SD9F5XqG82
    Jan 13 14:42:55 serverexample imapd: LOGIN, [email protected], ip=[::1], port=[41888], prot ocol=IMAP
    Jan 13 14:42:55 serverexample imapd: LOGOUT, [email protected], ip=[::1], headers=481, body =0, rcvd=296, sent=2109, time=0
    Jan 13 14:43:03 serverexample postfix/smtpd[24666]: connect from mail.serverexample.se[127.0.0.1]
    Jan 13 14:43:03 serverexample postfix/trivial-rewrite[24668]: warning: do not list domain serverexample rna.se in BOTH mydestination and virtual_mailbox_domains
    Jan 13 14:43:03 serverexample postfix/smtpd[24666]: 3E60982E06C: client=mail.serverexample.se[127.0. 0.1]
    Jan 13 14:43:03 serverexample postfix/cleanup[24658]: 3E60982E06C: message-id=<4b18d51c611c5a8d1b7eafc [email protected]>
    Jan 13 14:43:03 serverexample postfix/smtpd[24666]: disconnect from mail.serverexample.se[127.0.0.1]
    Jan 13 14:43:03 serverexample postfix/qmgr[3336]: 3E60982E06C: from=<[email protected]>, size=12 97, nrcpt=1 (queue active)
    Jan 13 14:43:03 serverexample amavis[2870]: (02870-02) Passed CLEAN, LOCAL [127.0.0.1] [90.152.67.122] <[email protected]> -> <[email protected]>, Message-ID: <4b18d51c611c5a8d1b7eafce7d63cde9. [email protected]>, mail_id: RytwRLHE1OBt, Hits: -0.896, size: 818, queued_as: 3E60982E06C , 7690 ms
    Jan 13 14:43:03 serverexample postfix/smtp[24659]: 7EA7982E06B: to=<[email protected]>, relay=1 27.0.0.1[127.0.0.1]:10024, delay=18, delays=10/0.01/0/7.7, dsn=2.0.0, status=sent (250 2.0.0 Ok, id=0287 0-02, from MTA([127.0.0.1]:10025): 250 2.0.0 Ok: queued as 3E60982E06C)
    Jan 13 14:43:03 serverexample postfix/qmgr[3336]: 7EA7982E06B: removed
    Jan 13 14:43:03 serverexample postfix/smtp[24670]: connect to gmail-smtp-in.l.google.com[209.85.219.22 ]:25: Connection refused
    Jan 13 14:43:04 serverexample postfix/smtp[24670]: 3E60982E06C: to=<[email protected]>, relay=a lt1.gmail-smtp-in.l.google.com[209.85.220.43]:25, delay=0.94, delays=0.01/0.01/0.19/0.74, dsn=2.0.0, sta tus=sent (250 2.0.0 OK 1263390184 3si3363502fxm.69)
    Jan 13 14:43:04 serverexample postfix/qmgr[3336]: 3E60982E06C: removed
    Jan 13 14:43:09 serverexample postfix/smtpd[24011]: connect from xyz.w.bmw.se[213.180.69.20]
    Jan 13 14:43:09 serverexample postfix/smtpd[24011]: lost connection after CONNECT from xyz.w.bmw.se [213.180.69.20]
    Jan 13 14:43:09 serverexample postfix/smtpd[24011]: disconnect from xyz.w.bmw.se[213.180.69.20]
    Jan 13 14:43:29 serverexample imapd: Connection, ip=[::1]
    Jan 13 14:43:29 serverexample authdaemond: received auth request, service=imap, authtype=login
    Jan 13 14:43:29 serverexample authdaemond: authmysql: trying this module
    Jan 13 14:43:29 serverexample authdaemond: authmysqllib: connected. Versions: header 50067, client 500 75, server 50075
    Jan 13 14:43:29 serverexample authdaemond: SQL query: SELECT email, password, "", 5000, 5000, "/home/v mail", CONCAT(SUBSTRING_INDEX(email,'@',-1),'/',SUBSTRING_INDEX(email,'@',1),'/'), quota, "", "" FROM us ers WHERE email = '[email protected]'
    Jan 13 14:43:29 serverexample authdaemond: password matches successfully
    Jan 13 14:43:29 serverexample authdaemond: authmysql: sysusername=<null>, sysuserid=5000, sysgroupid=5 000, homedir=/home/vmail, [email protected], fullname=<null>, maildir=serverexample.se/a min/, quota=10485760, options=<null>
    Jan 13 14:43:29 serverexample authdaemond: authmysql: clearpasswd=<null>, passwd=UX4SD9F5XqG82
    Jan 13 14:43:29 serverexample authdaemond: Authenticated: sysusername=<null>, sysuserid=5000, sysgroup id=5000, homedir=/home/vmail, [email protected], fullname=<null>, maildir=serverexample. se/xxx/, quota=10485760, options=<null>
    Jan 13 14:43:29 serverexample authdaemond: Authenticated: clearpasswd=xxx, passwd=UX4SD9F5XqG82
    Jan 13 14:43:29 serverexample imapd: LOGIN, [email protected], ip=[::1], port=[41899], prot ocol=IMAP
    Jan 13 14:43:29 serverexample imapd: LOGOUT, [email protected], ip=[::1], headers=0, body=0 , rcvd=30, sent=238, time=0
    Jan 13 14:43:30 serverexample imapd: Connection, ip=[::1]
    Jan 13 14:43:30 serverexample authdaemond: received auth request, service=imap, authtype=login
    Jan 13 14:43:30 serverexample authdaemond: authmysql: trying this module
    Jan 13 14:43:30 serverexample authdaemond: SQL query: SELECT email, password, "", 5000, 5000, "/home/v mail", CONCAT(SUBSTRING_INDEX(email,'@',-1),'/',SUBSTRING_INDEX(email,'@',1),'/'), quota, "", "" FROM us ers WHERE email = '[email protected]'
    Jan 13 14:43:30 serverexample authdaemond: password matches successfully
    Jan 13 14:43:30 serverexample authdaemond: authmysql: sysusername=<null>, sysuserid=5000, sysgroupid=5 000, homedir=/home/vmail, [email protected], fullname=<null>, maildir=serverexample.se/a min/, quota=10485760, options=<null>
    Jan 13 14:43:30 serverexample authdaemond: authmysql: clearpasswd=<null>, passwd=UX4SD9F5XqG82
    Jan 13 14:43:30 serverexample authdaemond: Authenticated: sysusername=<null>, sysuserid=5000, sysgroup id=5000, homedir=/home/vmail, [email protected], fullname=<null>, maildir=serverexample. se/xxx/, quota=10485760, options=<null>
    Jan 13 14:43:30 serverexample authdaemond: Authenticated: clearpasswd=xxx, passwd=UX4SD9F5XqG82
    Jan 13 14:43:30 serverexample imapd: LOGIN, [email protected], ip=[::1], port=[41900], prot ocol=IMAP
    Jan 13 14:43:30 serverexample imapd: LOGOUT, [email protected], ip=[::1], headers=0, body=0 , rcvd=493, sent=1670, time=0
    Jan 13 14:43:30 serverexample imapd: Connection, ip=[::1]
    Jan 13 14:43:30 serverexample authdaemond: received auth request, service=imap, authtype=login
    Jan 13 14:43:30 serverexample authdaemond: authmysql: trying this module
    Jan 13 14:43:30 serverexample authdaemond: SQL query: SELECT email, password, "", 5000, 5000, "/home/v mail", CONCAT(SUBSTRING_INDEX(email,'@',-1),'/',SUBSTRING_INDEX(email,'@',1),'/'), quota, "", "" FROM us ers WHERE email = '[email protected]'
    Jan 13 14:43:30 serverexample authdaemond: password matches successfully
    Jan 13 14:43:30 serverexample authdaemond: authmysql: sysusername=<null>, sysuserid=5000, sysgroupid=5 000, homedir=/home/vmail, [email protected], fullname=<null>, maildir=serverexample.se/a min/, quota=10485760, options=<null>
    Jan 13 14:43:30 serverexample authdaemond: authmysql: clearpasswd=<null>, passwd=UX4SD9F5XqG82
    Jan 13 14:43:30 serverexample authdaemond: Authenticated: sysusername=<null>, sysuserid=5000, sysgroup id=5000, homedir=/home/vmail, [email protected], fullname=<null>, maildir=serverexample. se/xxx/, quota=10485760, options=<null>
    Jan 13 14:43:30 serverexample authdaemond: Authenticated: clearpasswd=xxx, passwd=UX4SD9F5XqG82
    Jan 13 14:43:30 serverexample imapd: LOGIN, [email protected], ip=[::1], port=[41901], prot ocol=IMAP
    Jan 13 14:43:30 serverexample imapd: LOGOUT, [email protected], ip=[::1], headers=481, body =0, rcvd=296, sent=2109, time=0
    Jan 13 14:44:09 serverexample postfix/smtpd[24011]: connect from xyz.w.bmw.se[213.180.69.20]
    Jan 13 14:44:09 serverexample postfix/smtpd[24011]: lost connection after CONNECT from xyz.w.bmw.se [213.180.69.20]
    Jan 13 14:44:09 serverexample postfix/smtpd[24011]: disconnect from xyz.w.bmw.se[213.180.69.20]
    Jan 13 14:44:57 serverexample postfix/smtpd[24011]: connect from mail-px0-f200.google.com[209.85.216.2 00]
    Jan 13 14:45:07 serverexample postfix/smtpd[24011]: warning: 200.216.85.209.sbl.spamhaus.org: RBL look up error: Host or domain name not found. Name service error for name=200.216.85.209.sbl.spamhaus.org typ e=A: Host not found, try again
    Jan 13 14:45:07 serverexample postfix/smtpd[24011]: B196B82E06B: client=mail-px0-f200.google.com[209.8 5.216.200]
    Jan 13 14:45:08 serverexample postfix/cleanup[24715]: B196B82E06B: message-id=<3e345ca1001130544s37399 [email protected]>
    Jan 13 14:45:08 serverexample postfix/qmgr[3336]: B196B82E06B: from=<[email protected]>, size=2 544, nrcpt=1 (queue active)
    Jan 13 14:45:09 serverexample postfix/smtpd[24720]: connect from xyz.w.bmw.se[213.180.69.20]
    Jan 13 14:45:09 serverexample postfix/smtpd[24720]: lost connection after CONNECT from xyz.w.bmw.se [213.180.69.20]
    Jan 13 14:45:09 serverexample postfix/smtpd[24720]: disconnect from xyz.w.bmw.se[213.180.69.20]
    Jan 13 14:45:13 serverexample postfix/smtpd[24723]: connect from mail.serverexample.se[127.0.0.1]
    Jan 13 14:45:13 serverexample postfix/trivial-rewrite[24724]: warning: do not list domain serverexample rna.se in BOTH mydestination and virtual_mailbox_domains
    Jan 13 14:45:13 serverexample postfix/smtpd[24723]: 0D33382E06C: client=mail.serverexample.se[127.0. 0.1]
    Jan 13 14:45:13 serverexample postfix/cleanup[24715]: 0D33382E06C: message-id=<3e345ca1001130544s37399 [email protected]>
    Jan 13 14:45:13 serverexample postfix/qmgr[3336]: 0D33382E06C: from=<[email protected]>, size=3 226, nrcpt=1 (queue active)
    Jan 13 14:45:13 serverexample postfix/smtpd[24723]: disconnect from mail.serverexample.se[127.0.0.1]
    Jan 13 14:45:13 serverexample postfix/trivial-rewrite[24724]: warning: do not list domain serverexample rna.se in BOTH mydestination and virtual_mailbox_domains
    Jan 13 14:45:13 serverexample amavis[2872]: (02872-02) Passed CLEAN, [209.85.216.200] [209.85.216.200] <[email protected]> -> <[email protected]>, Message-ID: <3e345ca1001130544s373999c7m99a032 [email protected]>, mail_id: p3SdecZU0YTk, Hits: 0.469, size: 2544, queued_as: 0D33382E06C, dkim [email protected],[email protected], 4960 ms
    Jan 13 14:45:13 serverexample postfix/smtp[24717]: B196B82E06B: to=<[email protected]>, relay=12 7.0.0.1[127.0.0.1]:10024, delay=16, delays=11/0.01/0/5, dsn=2.0.0, status=sent (250 2.0.0 Ok, id=02872-0 2, from MTA([127.0.0.1]:10025): 250 2.0.0 Ok: queued as 0D33382E06C)
    Jan 13 14:45:13 serverexample postfix/qmgr[3336]: B196B82E06B: removed
    Jan 13 14:45:13 serverexample postfix/local[24726]: 0D33382E06C: to=<[email protected]>, relay=l ocal, delay=0.04, delays=0.01/0.02/0/0.01, dsn=5.1.1, status=bounced (unknown user: "xxx")
    Jan 13 14:45:13 serverexample postfix/cleanup[24715]: 1634A82E06D: message-id=<20100113134513.1634A82E [email protected]>
    Jan 13 14:45:13 serverexample postfix/qmgr[3336]: 1634A82E06D: from=<>, size=5074, nrcpt=1 (queue acti ve)
    Jan 13 14:45:13 serverexample postfix/bounce[24727]: 0D33382E06C: sender non-delivery notification: 16 34A82E06D
    Jan 13 14:45:13 serverexample postfix/qmgr[3336]: 0D33382E06C: removed
    Jan 13 14:45:14 serverexample postfix/smtp[24728]: 1634A82E06D: to=<[email protected]>, relay=g mail-smtp-in.l.google.com[209.85.219.53]:25, delay=0.99, delays=0.02/0.01/0.14/0.82, dsn=2.0.0, status=s ent (250 2.0.0 OK 1263390314 21si39918283ewy.42)
    Jan 13 14:45:14 serverexample postfix/qmgr[3336]: 1634A82E06D: removed
    Jan 13 14:45:38 serverexample postfix/smtpd[24011]: disconnect from mail-px0-f200.google.com[209.85.21 6.200]
    Jan 13 14:46:09 serverexample postfix/smtpd[24720]: connect from xyz.w.bmw.se[213.180.69.20]
    Jan 13 14:46:09 serverexample postfix/smtpd[24720]: lost connection after CONNECT from xyz.w.bmw.se [213.180.69.20]
    Jan 13 14:46:09 serverexample postfix/smtpd[24720]: disconnect from xyz.w.bmw.se[213.180.69.20]
    Jan 13 14:46:16 serverexample imapd: Connection, ip=[::1]
    Jan 13 14:46:16 serverexample authdaemond: received auth request, service=imap, authtype=login
    Jan 13 14:46:16 serverexample authdaemond: authmysql: trying this module
    Jan 13 14:46:16 serverexample authdaemond: SQL query: SELECT email, password, "", 5000, 5000, "/home/v mail", CONCAT(SUBSTRING_INDEX(email,'@',-1),'/',SUBSTRING_INDEX(email,'@',1),'/'), quota, "", "" FROM us ers WHERE email = '[email protected]'
    Jan 13 14:46:16 serverexample authdaemond: password matches successfully
    Jan 13 14:46:16 serverexample authdaemond: authmysql: sysusername=<null>, sysuserid=5000, sysgroupid=5 000, homedir=/home/vmail, [email protected], fullname=<null>, maildir=serverexample.se /wyx/, quota=10485760, options=<null>
    Jan 13 14:46:16 serverexample authdaemond: authmysql: clearpasswd=<null>, passwd=vrwCROHWTfM1g
    Jan 13 14:46:16 serverexample authdaemond: Authenticated: sysusername=<null>, sysuserid=5000, sysgroup id=5000, homedir=/home/vmail, [email protected], fullname=<null>, maildir=serverexamplern a.se/wyx/, quota=10485760, options=<null>
    Jan 13 14:46:16 serverexample authdaemond: Authenticated: clearpasswd=wyx, passwd=vrwCROHWTfM1g
    Jan 13 14:46:16 serverexample imapd: LOGIN, [email protected], ip=[::1], port=[41914], pr otocol=IMAP
    Jan 13 14:46:16 serverexample imapd: LOGOUT, [email protected], ip=[::1], headers=0, body =0, rcvd=30, sent=238, time=0
    Jan 13 14:46:16 serverexample imapd: Connection, ip=[::1]
    Jan 13 14:46:16 serverexample authdaemond: received auth request, service=imap, authtype=login
    Jan 13 14:46:16 serverexample authdaemond: authmysql: trying this module
    Jan 13 14:46:16 serverexample authdaemond: SQL query: SELECT email, password, "", 5000, 5000, "/home/v mail", CONCAT(SUBSTRING_INDEX(email,'@',-1),'/',SUBSTRING_INDEX(email,'@',1),'/'), quota, "", "" FROM us ers WHERE email = '[email protected]'
    Jan 13 14:46:16 serverexample authdaemond: password matches successfully
    Jan 13 14:46:16 serverexample authdaemond: authmysql: sysusername=<null>, sysuserid=5000, sysgroupid=5 000, homedir=/home/vmail, [email protected], fullname=<null>, maildir=serverexample.se /wyx/, quota=10485760, options=<null>
    Jan 13 14:46:16 serverexample authdaemond: authmysql: clearpasswd=<null>, passwd=vrwCROHWTfM1g
    Jan 13 14:46:16 serverexample authdaemond: Authenticated: sysusername=<null>, sysuserid=5000, sysgroup id=5000, homedir=/home/vmail, [email protected], fullname=<null>, maildir=serverexamplern a.se/wyx/, quota=10485760, options=<null>
    Jan 13 14:46:16 serverexample authdaemond: Authenticated: clearpasswd=wyx, passwd=vrwCROHWTfM1g
    Jan 13 14:46:16 serverexample imapd: LOGIN, [email protected], ip=[::1], port=[41915], pr otocol=IMAP
    Jan 13 14:46:16 serverexample imapd: Connection, ip=[::1]
    Jan 13 14:46:16 serverexample authdaemond: received auth request, service=imap, authtype=login
    Jan 13 14:46:16 serverexample authdaemond: authmysql: trying this module
    Jan 13 14:46:16 serverexample authdaemond: SQL query: SELECT email, password, "", 5000, 5000, "/home/v mail", CONCAT(SUBSTRING_INDEX(email,'@',-1),'/',SUBSTRING_INDEX(email,'@',1),'/'), quota, "", "" FROM us ers WHERE email = '[email protected]'
    Jan 13 14:46:16 serverexample authdaemond: password matches successfully
    Jan 13 14:46:16 serverexample authdaemond: authmysql: sysusername=<null>, sysuserid=5000, sysgroupid=5 000, homedir=/home/vmail, [email protected], fullname=<null>, maildir=serverexample.se /wyx/, quota=10485760, options=<null>
    Jan 13 14:46:16 serverexample authdaemond: authmysql: clearpasswd=<null>, passwd=vrwCROHWTfM1g
    Jan 13 14:46:16 serverexample authdaemond: Authenticated: sysusername=<null>, sysuserid=5000, sysgroup id=5000, homedir=/home/vmail, [email protected], fullname=<null>, maildir=serverexamplern a.se/wyx/, quota=10485760, options=<null>
    Jan 13 14:46:16 serverexample authdaemond: Authenticated: clearpasswd=wyx, passwd=vrwCROHWTfM1g
    Jan 13 14:46:16 serverexample imapd: LOGIN, [email protected], ip=[::1], port=[41916], pr otocol=IMAP
    Jan 13 14:46:16 serverexample imapd: DISCONNECTED, [email protected], ip=[::1], headers=0 , body=0, rcvd=21, sent=57, time=0
     
  10. rakeshakurathi1

    rakeshakurathi1 New Member

    before that i want to mention few things what i have done

    when the first account is working pretty fine even i can send mails to this account ..
    so created one more account
    and restarted the server then i got IMAP error in squirrel mail

    later i have done these steps as mentioned in the last part of ur tutorial

    mkdir /home/vmail/example.com
    chown -R vmail.vmail /home/vmail/example.com/yourname
    maildirmake /home/vmail/example.com/yourname


    for second account and got the

    ERROR: Could not complete request.
    Query: SELECT "INBOX"
    Reason Given: Unable to open this mailbox.

    unfortunately instead of second name i have used the first name which is working pretty fine .

    after that i m unable to send messages to this mail account.
    i know that it sounds little bit foolish

    please help me farko...
     
  11. rakeshakurathi1

    rakeshakurathi1 New Member

    few more issues falko

    i have tried to connect
    with these mail clients
    1)thunderbird and evolution
    login in successfully but uanble to send messages from the acount

    2)unable to login in microsoft outlook

    lastly is there any process for creating new user accounts.
    i have just inserted the new users and mailed them through mailx
    but i was unable to create any accounts..

    3)cant we send mails from above mentioned clients where as from squrrel mail i can send the mails ..
     
  12. falko

    falko Super Moderator Howtoforge Staff

    If you want to use the domain serverexamplerna.se with system users, please remove it from the domains table. If you want to use it with virtual users, please remove it from mydestination in /etc/postfix/main.cf. You cannot use that domain with system users and virtual users.
     
  13. rakeshakurathi1

    rakeshakurathi1 New Member

    thanks falko

    i ll come back to u after making the changes.....
     
  14. rakeshakurathi1

    rakeshakurathi1 New Member

    its working falko... thanks a lot still i have problems with

    i have problems with thunderbird
    i m unable to send the messages from thunderbird.
    and not even able to login from outlook


     
  15. falko

    falko Super Moderator Howtoforge Staff

    You must enable "Server requires authentication" in your email clients.
     

Share This Page