quick update
I just reset the password for the system "cyrus" user (/etc/shadow) to exaclty the same password just as the mail database user cyrus (in mysql)
now it sort-of works... but cyradm won't insert the users into mysql...!
[EMAIL PROTECTED] ~]# passwd cyrus
Changing password for user cyrus.
New UNIX password:
Retype new UNIX password:
passwd: all authentication tokens updated successfully.
[EMAIL PROTECTED] ~]# grep cyrus /etc/shadow
cyrus:XXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXX:12345::::::
[EMAIL PROTECTED] ~]# saslpasswd2 -c cyrus
Password:
Again (for verification):
[EMAIL PROTECTED] ~]# cyradm --user cyrus --server localhost --auth plain
Password:
IMAP Password:
localhost.localdomain> cm user.jhon
localhost.localdomain> sam user.jhon jhon lrswicd
localhost.localdomain> quit
[EMAIL PROTECTED] ~]#
notice that the domain is not mail2.mydomain.com as I would have expected
Feb 16 05:15:23 mailsrv1 passwd(pam_unix)[13697]: password changed for cyrus
Feb 16 05:15:37 mailsrv1 saslpasswd2: sql_select option missing
Feb 16 05:15:37 mailsrv1 saslpasswd2: auxpropfunc error no mechanism available
Feb 16 05:15:37 mailsrv1 saslpasswd2: _sasl_plugin_load failed on sasl_auxprop_plug_init for plugin: sql
Feb 16 05:15:39 mailsrv1 saslpasswd2: setpass succeeded for cyrus
Feb 16 05:15:39 mailsrv1 saslpasswd2: error deleting entry from sasldb: DB_NOTFOUND: No matching key/data pair found
This must mean something but - what? - saslpasswd2: error deleting entry from sasldb: DB_NOTFOUND: No matching key/data pair found
Feb 16 05:15:39 mailsrv1 last message repeated 2 times
Feb 16 05:15:48 mailsrv1 imaplocal[13701]: sql_select option missing
Feb 16 05:15:48 mailsrv1 imaplocal[13701]: auxpropfunc error no mechanism available
Feb 16 05:15:48 mailsrv1 imaplocal[13701]: _sasl_plugin_load failed on sasl_auxprop_plug_init for plugin: sql
Feb 16 05:15:52 mailsrv1 perl: No worthy mechs found
Feb 16 05:18:34 mailsrv1 sshd(pam_unix)[13717]: session opened for user sysadmusrzzz by (uid=0)
Feb 16 05:18:36 mailsrv1 su(pam_unix)[13749]: session opened for user root by sysadmusrzzz(uid=0)
Feb 16 05:19:26 mailsrv1 su(pam_unix)[13789]: session opened for user cyrus by sysadmusrzzz(uid=0)
Feb 16 05:21:57 mailsrv1 su(pam_unix)[13879]: session closed for user cyrus
Feb 16 05:23:01 mailsrv1 crond(pam_unix)[13901]: session opened for user root by (uid=0)
Feb 16 05:23:01 mailsrv1 crond(pam_unix)[13901]: session closed for user root
Feb 16 05:23:02 mailsrv1 postfix/smtpd[13926]: sql_select option missing
Feb 16 05:23:02 mailsrv1 postfix/smtpd[13926]: auxpropfunc error no mechanism available
Feb 16 05:23:02 mailsrv1 postfix/smtpd[13926]: _sasl_plugin_load failed on sasl_auxprop_plug_init for plugin: sql
Feb 16 05:23:02 mailsrv1 lmtpunix[13932]: sql auxprop plugin using mysql engine
Feb 16 05:24:02 mailsrv1 lmtpunix[13938]: sql auxprop plugin using mysql engine
Thank you!
On 2/16/06, Networks & Systems Admin <[EMAIL PROTECTED]> wrote:
I guess that's settled now... and I also got web-cyradm 0.5.4-1 working by removing the mail user from mysql and dropping the mail dabase then recreating all with $CRYPTO set to "plain" as this guys sais it here http://www.ductape.net/~mitja/linux.html .
now this is what I am getting from
[EMAIL PROTECTED] ~]# saslpasswd2 -c cyrus
Password:
Again (for verification):
[EMAIL PROTECTED] ~]# cyradm --user cyrus --server localhost --auth plain
Password:
IMAP Password:
Login failed: authentication failure at /usr/lib/perl5/site_perl/5.8.5/i386-linux-thread-multi/Cyrus/IMAP/Admin.pm line 118
cyradm: cannot authenticate to server with plain as cyrus
I have actually managed to create a domain, users in it etc with web-cyradm
but still something is amiss as you can see below:
Feb 16 04:37:40 mailsrv1 postfix/pickup[13201]: 0FD786EC1BB: uid=502 from=<jdoe>
Feb 16 04:37:40 mailsrv1 postfix/cleanup[13401]: 0FD786EC1BB: message-id=<[EMAIL PROTECTED] >
Feb 16 04:37:40 mailsrv1 postfix/qmgr[13202]: 0FD786EC1BB: from=< [EMAIL PROTECTED]>, size=463, nrcpt=2 (queue active)
Feb 16 04:37:41 mailsrv1 postfix/smtpd[13410]: connect from localhost.localdomain[127.0.0.1 ]
Feb 16 04:37:41 mailsrv1 postfix/smtpd[13410]: 556ED6EC1B8: client=localhost.localdomain[127.0.0.1]
Feb 16 04:37:41 mailsrv1 postfix/cleanup[13401]: 556ED6EC1B8: message-id=< [EMAIL PROTECTED]>
Feb 16 04:37:41 mailsrv1 postfix/qmgr[13202]: 556ED6EC1B8: from=< [EMAIL PROTECTED]>, size=869, nrcpt=1 (queue active)
Feb 16 04:37:41 mailsrv1 postfix/smtpd[13410]: disconnect from localhost.localdomain[127.0.0.1]
Feb 16 04:37:41 mailsrv1 amavis[13069]: (13069-02) Passed CLEAN, < [EMAIL PROTECTED]> -> <[EMAIL PROTECTED]>,< [EMAIL PROTECTED]>, Message-ID: < [EMAIL PROTECTED]>, mail_id: 8M16n-oaYTvp, Hits: 0.549 , 1324 ms
Feb 16 04:37:41 mailsrv1 postfix/smtp[13405]: 0FD786EC1BB: to=< [EMAIL PROTECTED]>, relay=127.0.0.1[ 127.0.0.1], delay=1, status=sent (250 2.6.0 Ok, id=13069-02, from MTA([ 127.0.0.1]:10025): 250 Ok: queued as 556ED6EC1B8)
Feb 16 02:37:41 mailsrv1 postfix/smtp[13405]: 0FD786EC1BB: 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=13069-02, from MTA([ 127.0.0.1]:10025): 250 Ok: queued as 556ED6EC1B8)
Feb 16 04:37:41 mailsrv1 postfix/qmgr[13202]: 0FD786EC1BB: removed
Feb 16 04:37:41 mailsrv1 lmtpunix[13396]: accepted connection
Feb 16 04:37:41 mailsrv1 lmtpunix[13396]: lmtp connection preauth'd as postman
Feb 16 04:37:41 mailsrv1 master[13416]: about to exec /usr/lib/cyrus-imapd/lmtpd
Feb 16 04:37:41 mailsrv1 lmtpunix[13416]: executed
Feb 16 04:37:41 mailsrv1 lmtpunix[13396]: verify_user(user.testuser1) failed: Mailbox does not exist
Feb 16 04:37:41 mailsrv1 postfix/pipe[13414]: 556ED6EC1B8: to=<[EMAIL PROTECTED]>, relay=cyrus, delay=0, status=bounced (data format error. Command output: testuser1: Mailbox does not exist )
Feb 16 04:37:41 mailsrv1 postfix/cleanup[13401]: 6FDDB6EC1BB: message-id=<[EMAIL PROTECTED] >
Feb 16 04:37:41 mailsrv1 postfix/qmgr[13202]: 6FDDB6EC1BB: from=<>, size=2689, nrcpt=1 (queue active)
Feb 16 04:37:41 mailsrv1 postfix/qmgr[13202]: 556ED6EC1B8: removed
Feb 16 04:37:41 mailsrv1 lmtpunix[13416]: accepted connection
Feb 16 04:37:41 mailsrv1 lmtpunix[13416]: lmtp connection preauth'd as postman
Feb 16 04:37:41 mailsrv1 lmtpunix[13416]: verify_user(user.jdoe) failed: Mailbox does not exist
Feb 16 04:37:41 mailsrv1 postfix/pipe[13414]: 6FDDB6EC1BB: to=< [EMAIL PROTECTED] >, relay=cyrus, delay=0, status=bounced (data format error. Command output: jdoe: Mailbox does not exist )
Feb 16 04:37:41 mailsrv1 postfix/qmgr[13202]: 6FDDB6EC1BB: removed
Feb 16 04:38:41 mailsrv1 master[13275]: process 13396 exited, status 0
Feb 16 04:38:41 mailsrv1 master[13275]: process 13416 exited, status 0
Feb 16 04:38:41 mailsrv1 master[13421]: about to exec /usr/lib/cyrus-imapd/lmtpd
Feb 16 04:38:41 mailsrv1 lmtpunix[13421]: executed
for extra clarity I paste the contents of the "mail" database from mysql
[EMAIL PROTECTED] ~]# mysql -u root -p
Enter password:
Welcome to the MySQL monitor. Commands end with ; or \g.
Your MySQL connection id is 888 to server version: 4.1.12
Type 'help;' or '\h' for help. Type '\c' to clear the buffer.
mysql> use mail;
Reading table information for completion of table and column names
You can turn off this feature to get a quicker startup with -A
Database changed
mysql> select * from accountuser;
+-----------+-------------------+--------+---------------------+
| username | password | prefix | domain_name |
+-----------+-------------------+--------+---------------------+
| cyrus | XXXXXXXXXXXXXXXXX | | |
| testuser1 | XXXXXXXXXXXXXXXXX | | mail2.mydomain.com |
| testuser2 | XXXXXXXXXXXXXXXXX | | mail2.mydomain.com |
+-----------+-------------------+--------+---------------------+
3 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 | | 100 | 20000 | cyrus | NO | NO |
+---------------------+--------+-------------+-------+-----------+-----------+-------------+
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] | 0001 | testuser2 | 1 |
| [EMAIL PROTECTED] | testuser1 | testuser1 | 1 |
| [EMAIL PROTECTED] | [EMAIL PROTECTED] | mail2.mydomain.com | 1 |
+-------------------------------+-------------------------------+---------------------+--------+
3 rows in set (0.00 sec)
mysql>
btw: where should those mailboxes created on the phisical file system?
Any ideea what's wrong?- Hide quoted text -On 2/15/06, Lukasz Marciniak <[EMAIL PROTECTED]> wrote:Networks & Systems Admin wrote:
> Postfix spews the following error messages in /var/log/maillog
>
> Feb 15 16:12:32 mailbox postfix/smtpd[4416]: fatal: open database
> /etc/postfix/virtual.db: No such file or directory
> Feb 15 16:12:33 mailbox postfix/master[2377]: warning: process
> /usr/libexec/postfix/smtpd pid 4416 exit status 1
> Feb 15 16:12:33 mailbox postfix/master[2377]: warning:
> /usr/libexec/postfix/smtpd: bad command startup -- throttling
>
> but I am expecting it to look for the virtual.db in mysql or am I not right?
What do you have in main.cf ?
> Then I've managed to setup Web-Cyradm but after changing admin's
> password from the web management console and now I can't log back in !!?!
Try cvs-version (0.5.5) or this:
http://savannah.nongnu.org/bugs/index.php?func=detailitem&item_id=12519
Rgds,
Lukasz
_______________________________________________
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
