Email problems postfix+roundcube+sasl

[LMSSML]

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#

[LMSSML]

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