all in /etc/pam.d/ - I mean imap, pop, sieve and smtp are all containing the same:
[EMAIL PROTECTED] pam.d]# cat imap
auth sufficient pam_mysql.so user=mail passwd=secretmysqlmaildb321 host=localhost db=mail table=accountuser usercolumn=username passwdcolumn=password crypt=1 logtable=log logmsgcolumn=msg logusercolumn=user loghostcolumn=host logpidcolumn=pid logtimecolumn=time
account required pam_mysql.so user=mail passwd=secretmysqlmaildb321 host=localhost db=mail table=accountuser usercolumn=username passwdcolumn=password crypt=1 logtable=log logmsgcolumn=msg logusercolumn=user loghostcolumn=host logpidcolumn=pid logtimecolumn=time
[EMAIL PROTECTED] pam.d]# cd
I am currently using plain-text passwords in the mail database to make sure that at least that's not causing issues
From Web-Cyradm
I've created this new domain
action domainname prefix max Accounts default quota per user
Edit Domain Delete Domain accounts Aliases mail2.mydomain.com user 100 20000
and this new mail user
action Email address Username Last login Quota used
Edit account Change Password Forward Delete account Set quota Set catch all [EMAIL PROTECTED] user0001 n/a 0 KBytes out of 20000 KBytes (0.00%)
to get a more clear picture there a the relevant mysql queries from the mail database
mysql> select * from accountuser;
+----------+-------------------+--------+---------------------+
| username | password | prefix | domain_name |
+----------+-------------------+--------+---------------------+
| cyrus | xxxxxxxxxxxxxxxxx | | |
| user0001 | super | user | mail2.mydomain.com |
+----------+-------------------+--------+---------------------+
2 rows in set (0.00 sec)
mysql> select * from adminuser;
+----------+--------------------+------+-----+------+
| username | password | type | SID | home |
+----------+--------------------+------+-----+------+
| admin | xxxxxxxxxxxxxxxxxx | 0 | | |
+----------+--------------------+------+-----+------+
1 row in set (0.00 sec)
mysql> select * from alias;
Empty set (0.00 sec)
mysql> select * from domain;
+---------------------+--------+-------------+-------+-----------+-----------+-------------+
| domain_name | prefix | maxaccounts | quota | transport | freenames | freeaddress |
+---------------------+--------+-------------+-------+-----------+-----------+-------------+
| mail2.mydomain.com | user | 100 | 20000 | cyrus | YES | YES |
+---------------------+--------+-------------+-------+-----------+-----------+-------------+
1 row in set (0.00 sec)
mysql> select * from domainadmin;
+-------------+-----------+
| domain_name | adminuser |
+-------------+-----------+
| * | admin |
+-------------+-----------+
1 row in set (0.00 sec)
mysql> select * from log;
Empty set (0.00 sec)
mysql> select * from search;
Empty set (0.00 sec)
mysql> select * from virtual;
+---------------------------+----------+----------+--------+
| alias | dest | username | status |
+---------------------------+----------+----------+--------+
| [EMAIL PROTECTED] | user0001 | user0001 | 1 |
+---------------------------+----------+----------+--------+
1 row in set (0.00 sec)
mysql>
but it seems that it doesn't really creates the actual mailboxes !!
-- /var/log/maillog
Feb 17 12:42:30 mailsrv1 postfix/pickup[2603]: 0DF076EC1BF: uid=502 from=<jdoe>
Feb 17 12:42:30 mailsrv1 postfix/cleanup[4221]: 0DF076EC1BF: message-id=< [EMAIL PROTECTED]>
Feb 17 12:42:30 mailsrv1 postfix/qmgr[2604]: 0DF076EC1BF: from=<[EMAIL PROTECTED]>, size=433, nrcpt=1 (queue active)
Feb 17 12:42:31 mailsrv1 postfix/smtpd[4231]: connect from localhost.localdomain[127.0.0.1]
Feb 17 12:42:31 mailsrv1 postfix/smtpd[4231]: 7F3D56EC1BD: client=localhost.localdomain[ 127.0.0.1]
Feb 17 12:42:31 mailsrv1 postfix/cleanup[4221]: 7F3D56EC1BD: message-id=<[EMAIL PROTECTED]>
Feb 17 12:42:31 mailsrv1 postfix/smtpd[4231]: disconnect from localhost.localdomain[127.0.0.1]
Feb 17 12:42:31 mailsrv1 amavis[2583]: (02583-03) Passed CLEAN, <[EMAIL PROTECTED]> -> < [EMAIL PROTECTED]>, Message-ID: <[EMAIL PROTECTED]>, mail_id: daDyXdc1p8cU, Hits: 0.549, 1514 ms
Feb 17 12:42:31 mailsrv1 postfix/smtp[4226]: 0DF076EC1BF: to=< [EMAIL PROTECTED]>, orig_to=<[EMAIL PROTECTED]>, relay=127.0.0.1[127.0.0.1 ], delay=1, status=sent (250 2.6.0 Ok, id=02583-03, from MTA([127.0.0.1]:10025): 250 Ok: queued as 7F3D56EC1BD)
Feb 17 12:42:31 mailsrv1 postfix/qmgr[2604]: 7F3D56EC1BD: from=< [EMAIL PROTECTED]>, size=911, nrcpt=1 (queue active)
Feb 17 12:42:31 mailsrv1 postfix/qmgr[2604]: 0DF076EC1BF: removed
Feb 17 12:42:31 mailsrv1 lmtpunix[4004]: accepted connection
Feb 17 12:42:31 mailsrv1 lmtpunix[4004]: lmtp connection preauth'd as postman
Feb 17 12:42:31 mailsrv1 master[4237]: about to exec /usr/lib/cyrus-imapd/lmtpd
Feb 17 12:42:31 mailsrv1 lmtpunix[4237]: executed
Feb 17 12:42:31 mailsrv1 lmtpunix[4004]: IOERROR: opening /var/spool/imap/u/user/user0001/cyrus.header: No such file or directory
Feb 17 12:42:31 mailsrv1 lmtpunix[4004]: verify_user(user.user0001) failed: System I/O error
Feb 17 12:42:31 mailsrv1 postfix/pipe[4235]: 7F3D56EC1BD: to=<[EMAIL PROTECTED] >, relay=cyrus, delay=0, status=deferred (temporary failure)
Feb 17 12:43:01 mailsrv1 postfix/pickup[2603]: 757D16EC1C0: uid=0 from=<root>
Feb 17 12:43:01 mailsrv1 postfix/cleanup[4221]: 757D16EC1C0: message-id=< [EMAIL PROTECTED]>
Feb 17 12:43:01 mailsrv1 postfix/qmgr[2604]: 757D16EC1C0: from=< [EMAIL PROTECTED]>, size=569, nrcpt=1 (queue active)
Feb 17 12:43:01 mailsrv1 postfix/smtpd[4231]: connect from localhost.localdomain[127.0.0.1]
Feb 17 12:43:01 mailsrv1 postfix/smtpd[4231]: A176B6EC1BF: client= localhost.localdomain[127.0.0.1]
Feb 17 12:43:01 mailsrv1 postfix/cleanup[4221]: A176B6EC1BF: message-id=<[EMAIL PROTECTED] >
Feb 17 12:43:01 mailsrv1 postfix/smtpd[4231]: disconnect from localhost.localdomain[127.0.0.1]
Feb 17 12:43:01 mailsrv1 postfix/qmgr[2604]: A176B6EC1BF: from=< [EMAIL PROTECTED]>, size=1039, nrcpt=1 (queue active)
Feb 17 12:43:01 mailsrv1 amavis[2582]: (02582-04) Passed CLEAN, <[EMAIL PROTECTED]> -> < [EMAIL PROTECTED]>, Message-ID: <[EMAIL PROTECTED]>, mail_id: cSbrFf0rebfV, Hits: - 0.001, 282 ms
Feb 17 10:43:01 mailsrv1 postfix/smtp[4226]: 757D16EC1C0: to=<[EMAIL PROTECTED]>, orig_to=<root>, relay=127.0.0.1[ 127.0.0.1], delay=0, status=sent (250 2.6.0 Ok, id=02582-04, from MTA([127.0.0.1]:10025): 250 Ok: queued as A176B6EC1BF)
Feb 17 12:43:01 mailsrv1 postfix/qmgr[2604]: 757D16EC1C0: removed
Feb 17 12:43:01 mailsrv1 lmtpunix[4237]: accepted connection
Feb 17 12:43:01 mailsrv1 lmtpunix[4237]: lmtp connection preauth'd as postman
Feb 17 12:43:01 mailsrv1 lmtpunix[4237]: verify_user(user.root) failed: Mailbox does not exist
Feb 17 12:43:01 mailsrv1 postfix/pipe[4235]: A176B6EC1BF: to=<[EMAIL PROTECTED]>, relay=cyrus, delay=0, status=bounced (data format error. Command output: root: Mailbox does not exist )
Feb 17 12:43:01 mailsrv1 postfix/cleanup[4221]: C35A06EC1C1: message-id=<[EMAIL PROTECTED]>
Feb 17 12:43:01 mailsrv1 postfix/qmgr[2604]: C35A06EC1C1: from=<>, size=2825, nrcpt=1 (queue active)
Feb 17 12:43:01 mailsrv1 postfix/qmgr[2604]: A176B6EC1BF: removed
Feb 17 12:43:01 mailsrv1 lmtpunix[4004]: accepted connection
Feb 17 12:43:01 mailsrv1 lmtpunix[4004]: lmtp connection preauth'd as postman
Feb 17 12:43:01 mailsrv1 lmtpunix[4004]: verify_user( user.root) failed: Mailbox does not exist
Feb 17 12:43:01 mailsrv1 postfix/pipe[4235]: C35A06EC1C1: to=<[EMAIL PROTECTED]>, relay=cyrus, delay=0, status=bounced (data format error. Command output: root: Mailbox does not exist )
Feb 17 12:43:01 mailsrv1 postfix/qmgr[2604]: C35A06EC1C1: removed
Feb 17 12:44:01 mailsrv1 master[2505]: process 4237 exited, status 0
Feb 17 12:44:01 mailsrv1 master[2505]: process 4004 exited, status 0
Feb 17 12:44:01 mailsrv1 master[4263]: about to exec /usr/lib/cyrus-imapd/lmtpd
Feb 17 12:44:01 mailsrv1 lmtpunix[4263]: executed
Feb 17 12:47:49 mailsrv1 master[4265]: about to exec /usr/lib/cyrus-imapd/ctl_cyrusdb
Feb 17 12:47:49 mailsrv1 ctl_cyrusdb[4265]: checkpointing cyrus databases
Feb 17 12:47:49 mailsrv1 ctl_cyrusdb[4265]: archiving database file: /var/imap/annotations.db
Feb 17 12:47:49 mailsrv1 ctl_cyrusdb[4265]: archiving log file: /var/imap/db/log.0000000001
Feb 17 12:47:49 mailsrv1 ctl_cyrusdb[4265]: archiving database file: /var/imap/mailboxes.db
Feb 17 12:47:49 mailsrv1 ctl_cyrusdb[4265]: archiving log file: /var/imap/db/log.0000000001
Feb 17 12:47:49 mailsrv1 ctl_cyrusdb[4265]: done checkpointing cyrus databases
Feb 17 12:47:49 mailsrv1 master[2505]: process 4265 exited, status 0
On 2/16/06, Muenz, Michael
<[EMAIL PROTECTED]> wrote:
> Hey Lukazs & Cheeto
> here are my config files - I hope they are explicite enough
> I wanna bring up that I actually don't want plain text
> password for the users in the mail database rather 'crypt'
> ones so I can easily migrate existing pop3 users (from
> /etc/shadow) to postfix + mysql + cyrus without the hassle of
> changing everyone's password - especially that many of my
> users are several thousands of miles away... helpdesk/support
> is really difficult for non-techie users.
You can't use auxprop (configured in you imapd.conf) with crypted
PW's in DB. Use saslauthd, and change your pam files to use the
DB (like explained in the HowTo fom Luc)
Michael
_______________________________________________
This mailing list is hosted and supported
by bit-heads GmbH | http://www.bit-heads.ch
_______________________________________________
Web-cyradm mailing list
[email protected]
http://www.web-cyradm.org/mailman/listinfo/web-cyradm
_______________________________________________ This mailing list is hosted and supported by bit-heads GmbH | http://www.bit-heads.ch
_______________________________________________ Web-cyradm mailing list [email protected] http://www.web-cyradm.org/mailman/listinfo/web-cyradm
