[Web-cyradm] trouble with Postfix + MySQL + Cyrus IMAPd +
Web-Cyradm integration - on CentOS 4.2 - RHEL 4 "clone"
Networks & Systems Admin
netsysadm at gmail.com
Wed Feb 15 22:06:53 EST 2006
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
<http://www.ductape.net/%7Emitja/linux.html>.
now this is what I am getting from
[root at mailsrv1 ~]# saslpasswd2 -c cyrus
Password:
Again (for verification):
[root at mailsrv1 ~]# 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=<20060216023740.GI10067 at mailsrv1.mydomain.com
>
Feb 16 04:37:40 mailsrv1 postfix/qmgr[13202]: 0FD786EC1BB: from=<
jdoe at mail2.mydomain.com>, 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=<
20060216023740.GI10067 at mailsrv1.mydomain.com>
Feb 16 04:37:41 mailsrv1 postfix/qmgr[13202]: 556ED6EC1B8:
from=<jdoe at mail2.mydomain.com>,
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, <
jdoe at mail2.mydomain.com> ->
<testuser1 at mail2.mydomain.com>,<testuser1 at mail2.mydomain.com>,
Message-ID: < 20060216023740.GI10067 at mailsrv1.mydomain.com>, mail_id:
8M16n-oaYTvp, Hits: 0.549 , 1324 ms
Feb 16 04:37:41 mailsrv1 postfix/smtp[13405]: 0FD786EC1BB: to=<
testuser1 at mail2.mydomain.com>, 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=<testuser1 at mail2.mydomain.com>,
orig_to=< dd at mail2.mydomain.com>, 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=<
testuser1 at mail2.mydomain.com>, 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=<20060216023741.6FDDB6EC1BB at mail2.mydomain.com
>
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=<jdoe at mail2.mydomain.com >,
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
[root at mailsrv1 ~]# 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 |
+-------------------------------+-------------------------------+---------------------+--------+
| testuser2 at mail2.mydomain.com | 0001 |
testuser2 | 1 |
| testuser1 at mail2.mydomain.com | testuser1 |
testuser1 | 1 |
| dd at mail2.mydomain.com | testuser1 at mail2.mydomain.com |
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 <landm at ibi.pl> 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 at web-cyradm.org
> http://www.web-cyradm.org/mailman/listinfo/web-cyradm
-------------- next part --------------
An HTML attachment was scrubbed...
URL: https://lists.andrew.cmu.edu/mailman/private/info-cyrus/attachments/20060216/b5e11ef8/attachment-0001.html
More information about the Info-cyrus
mailing list