Find the answer to your Linux question:
Page 4 of 4 FirstFirst 1 2 3 4
Results 31 to 32 of 32
Hi scathefire. Done to do some changes and tryied but not working at the moment, it's likewe never going to get out of the same step Apr 6 22:25:46 mail ...
Enjoy an ad free experience by logging in. Not a member yet? Register.
  1. #31
    Just Joined!
    Join Date
    Nov 2007
    Posts
    36

    Smile Trying again


    Hi scathefire.

    Done to do some changes and tryied but not working at the moment, it's likewe never going to get out of the same step

    Apr 6 22:25:46 mail authdaemond: authmysql: REJECT - try next module
    Apr 6 22:25:46 mail authdaemond: FAIL, all modules rejected
    Apr 6 22:25:46 mail imapd-ssl: LOGIN FAILED, user=user@example.pt, ip=[::ffff:127.0.0.1]
    Apr 6 22:25:51 mail imapd-ssl: LOGOUT, ip=[::ffff:127.0.0.1], rcvd=58, sent=334
    Apr 6 22:28:12 mail imapd-ssl: Connection, ip=[::ffff:127.0.0.1]
    Apr 6 22:28:12 mail authdaemond: received auth request, service=imap, authtype=login
    Apr 6 22:28:12 mail authdaemond: authmysql: trying this module
    Apr 6 22:28:12 mail authdaemond: authmysqllib: connected. Versions: header 50075, client 50083, server 50137
    Apr 6 22:28:12 mail authdaemond: SQL query: SELECT username, password, "", '5000', '5000', '/home/vmail', maildir, concat(quota,'S'), name, "" FROM mailbox WHERE username = 'user@example.pt'
    Apr 6 22:28:12 mail authdaemond: password matches successfully
    Apr 6 22:28:12 mail authdaemond: authmysql: sysusername=<null>, sysuserid=5000, sysgroupid=5000, homedir=/home/vmail, address=user@example.pt, fullname=User, maildir=example.pt/user/, quota=0S, options=<null>
    Apr 6 22:28:12 mail authdaemond: authmysql: clearpasswd=<null>, passwd=XvwM2BIrL4VI2
    Apr 6 22:28:12 mail authdaemond: Authenticated: sysusername=<null>, sysuserid=5000, sysgroupid=5000, homedir=/home/vmail, address=user@example.pt, fullname=User, maildir=example.pt/user/, quota=0S, options=<null>
    Apr 6 22:28:12 mail authdaemond: Authenticated: clearpasswd=123456, passwd=XvwM2BIrL4VI2
    Apr 6 22:28:12 mail imapd-ssl: chdir example.pt/user/: No such file or directory
    Apr 6 22:28:12 mail imapd-ssl: user@example.pt: No such file or directory
    Changed mysql_virtual_mailbox_maps.cf to:

    Original:

    user = postfix
    password = password
    hosts = 127.0.0.1
    dbname = postfix
    table = mailbox
    select_field = maildir
    where_field = username
    #additional_conditions = and active = '1'

    Changed to :

    user = postfix
    password = password
    hosts = localhost
    dbname = postfix
    #table = mailbox
    #select_field = maildir
    #where_field = username
    #additional_conditions = and active = '1'
    query = SELECT CONCAT(domain,'/',maildir) FROM mailbox WHERE username='%s' AND active = 1

    But I think the result is the same when trying to enter on webmail:

    ERROR:
    ERROR: Could not complete request.
    Query: SELECT "INBOX"
    Reason Given: Unable to open this mailbox.
    And on the left bar from squirrelmail I've got:

    ERROR:
    ERROR: Connection dropped by IMAP server.
    Query: SUBSCRIBE "INBOX.Sent"

    Weird thing I saw on log


    6 22:28:12 mail authdaemond: Authenticated: sysusername=<null>, sysuserid=5000, sysgroupid=5000, homedir=/home/vmail address=user@example.pt, fullname=User, maildir=example.pt/user/, quota=0S, options=<null>
    Apr 6 22:28:12 mail authdaemond: Authenticated: clearpasswd=123456, passwd=XvwM2BIrL4VI2
    Apr 6 22:37:06 mail authdaemond: password matches successfully
    Apr 6 22:37:06 mail authdaemond: authmysql: sysusername=<null>, sysuserid=5000, sysgroupid=5000, homedir=/var/spool/mail/virtual, address=user@example.pt, fullname=User, maildir=example.pt/user/, quota=0S, options=<null>
    Apr 6 22:37:06 mail authdaemond: authmysql: clearpasswd=<null>, passwd=XvwM2BIrL4VI2
    Apr 6 22:37:06 mail authdaemond: Authenticated: sysusername=<null>, sysuserid=5000, sysgroupid=5000, homedir=/var/spool/mail/virtual, address=user@example.pt, fullname=User, maildir=example.pt/user/, quota=0S, options=<null>
    Apr 6 22:37:06 mail authdaemond: Authenticated: clearpasswd=123456, passwd=XvwM2BIrL4VI2
    Apr 6 22:37:06 mail imapd-ssl: LOGIN, user=user@example.pt, ip=[::ffff:127.0.0.1], port=[42589], protocol=IMAP
    Apr 6 22:37:06 mail imapd-ssl: Connection, ip=[::ffff:127.0.0.1]
    Apr 6 22:37:06 mail authdaemond: received auth request, service=imap, authtype=login
    Apr 6 22:37:06 mail authdaemond: authmysql: trying this module
    Apr 6 22:37:06 mail authdaemond: SQL query: SELECT username, password, "", '5000', '5000', '/var/spool/mail/virtual', maildir, concat(quota,'S'), name, "" FROM mailbox WHERE username = 'user@example.pt'
    Apr 6 22:37:06 mail authdaemond: password matches successfully
    Apr 6 22:37:06 mail authdaemond: authmysql: sysusername=<null>, sysuserid=5000, sysgroupid=5000, homedir=/var/spool/mail/virtual, address=user@example.pt, fullname=User, maildir=example.pt/user/, quota=0S, options=<null>
    Apr 6 22:37:06 mail authdaemond: authmysql: clearpasswd=<null>, passwd=XvwM2BIrL4VI2
    Apr 6 22:37:06 mail authdaemond: Authenticated: sysusername=<null>, sysuserid=5000, sysgroupid=5000, homedir=/var/spool/mail/virtual, address=user@example.pt, fullname=User, maildir=example.pt/user/, quota=0S, options=<null>
    Apr 6 22:37:06 mail authdaemond: Authenticated: clearpasswd=123456, passwd=XvwM2BIrL4VI2
    Apr 6 22:37:06 mail imapd-ssl: LOGIN, user=user@example.pt, ip=[::ffff:127.0.0.1], port=[42590], protocol=IMAP
    Apr 6 22:37:06 mail imapd-ssl: DISCONNECTED, user=user@example.pt, ip=[::ffff:127.0.0.1], headers=0, body=0, rcvd=21, sent=57, time=0, starttls=1
    Apr 6 22:39:19 mail postfix/anvil[20438]: statistics: max connection rate 1/60s for (smtp:122.116.113.64) at Apr 6 22:35:57
    Apr 6 22:39:19 mail postfix/anvil[20438]: statistics: max connection count 1 for (smtp:122.116.113.64) at Apr 6 22:35:57
    Apr 6 22:39:19 mail postfix/anvil[20438]: statistics: max cache size 1 at Apr 6 22:35:57

    Can't define and know why sometimes homedir is /home/vmail and sometimes goes with a different path like /var/spool/mail/virtual ?


    By the way the path of /var/spool/mail/virtual and the permissions:

    root# pwd
    /var/spool/mail/virtual
    root# ls -lha
    total 44K
    drwxrwsrwx 11 virtual virtual 4.0K 2010-03-31 22:41 .
    drwxrwsr-x 4 virtual virtual 4.0K 2010-02-20 00:35 ..
    drwxr-sr-x 9 virtual virtual 4.0K 2010-03-02 18:27 user2
    drwxr-sr-x 5 virtual virtual 4.0K 2010-03-30 16:27 user2@example.pt
    drwxrwsrwx 5 777 777 4.0K 2010-03-31 22:47 example.pt
    drwx--S--- 10 virtual virtual 4.0K 2010-03-12 14:50 user1
    drwxr-sr-x 4 virtual virtual 4.0K 2010-03-31 22:19 user1@example.pt
    drwx------ 6 virtual virtual 4.0K 2010-02-26 12:51 .Sent
    drwxr-sr-x 9 virtual virtual 4.0K 2010-03-02 14:11 teste
    drwxr-sr-x 5 virtual virtual 4.0K 2010-03-12 15:14 teste34
    drwxrwsrwx 5 root virtual 4.0K 2010-03-31 22:41 user
    root#

    where the mails should be with all the permissions


    /var/spool/mail/virtual/example.pt
    total 20K
    drwxrwsrwx 5 777 777 4.0K 2010-03-31 22:47 .
    drwxrwsrwx 11 virtual virtual 4.0K 2010-03-31 22:41 ..
    drwxr-sr-x 5 virtual virtual 4.0K 2010-03-30 16:33 user1@example.pt
    drwxrwsrwx 6 virtual virtual 4.0K 2010-03-31 22:51 user
    drwxrwsrwx 5 virtual virtual 4.0K 2010-03-31 22:43 user@example.pt
    root#

  2. #32
    Just Joined!
    Join Date
    Nov 2007
    Posts
    36

    Manual

    Hi there !!


    Is there any manual to get the solution working ?

    I've tried some but none working with the solution ?

    I have ubuntu server and I would like to know if there is one with postfix + mysql +squirrelmail and to create mailbox by site with webmin or postfixadmin .

    I think this is desperated state.

    Thansk in advanced to all

Page 4 of 4 FirstFirst 1 2 3 4

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •