Dani Crisan wrote: > Hello, > > I have just installed Postfix+Courier+Mysql using this: > http://flurdy.com/docs/postfix/#data > > First a have created in Mysql 2 users (they are also system users), and > then created another user: > INSERT INTO users (id,name,maildir,clear) VALUES ('[EMAIL PROTECTED]','JOHN > DOE' , 'john/' , encrypt('XXXXX') ); > > 2questions: > 1) Is there a way to automatically create the folders > /var/spool/mail/virtual/<new user>/cur ,new, tmp?
No, you should write your own script for that. I posted an example some while ago, see http://www.mail-archive.com/[email protected]/msg29854.html > 2) If I try to authenticate with the new created user: [EMAIL PROTECTED] I > get this in the log file: > Jul 18 16:02:35 mail imapd-ssl: Connection, ip=[::ffff:127.0.0.1] > Jul 18 16:02:35 mail authdaemond: received auth request, service=imap, > authtype=login > Jul 18 16:02:35 mail authdaemond: authmysql: trying this module > Jul 18 16:02:35 mail authdaemond: SQL query: SELECT id, crypt, "", uid, > gid, home, concat(home,'/',maildir), "", name, "" FROM users WHERE id = > "[EMAIL PROTECTED]" AND (enabled=1) Does that query work correctly from, say, `mysql --batch --user=the-value-configured-in-authmysqlrc --database=ditto --execute='SELECT id, crypt, "", [...] AND (enabled=1)'`? > Jul 18 16:02:35 mail authdaemond: supplied password 'THIS PASSWORD IS > CLEAR TEXT AND IT IS CORRECT' does not match encrypted password > 'sdtrusfX0Jj66' Eh? I don't think that text is stored as your cleartext password. Where is it from? ------------------------------------------------------------------------- This SF.Net email is sponsored by the Moblin Your Move Developer's challenge Build the coolest Linux based applications with Moblin SDK & win great prizes Grand prize is a trip for two to an Open Source event anywhere in the world http://moblin-contest.org/redirect.php?banner_id=100&url=/ _______________________________________________ courier-users mailing list [email protected] Unsubscribe: https://lists.sourceforge.net/lists/listinfo/courier-users
