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
Web-cyradm@web-cyradm.org
http://www.web-cyradm.org/mailman/listinfo/web-cyradm
----
Cyrus Home Page: http://asg.web.cmu.edu/cyrus
Cyrus Wiki/FAQ: http://cyruswiki.andrew.cmu.edu
List Archives/Info: http://asg.web.cmu.edu/cyrus/mailing-list.html

Reply via email to