[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 23:00:13 EST 2006
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...!
[root at mailsrv1 ~]# passwd cyrus
Changing password for user cyrus.
New UNIX password:
Retype new UNIX password:
passwd: all authentication tokens updated successfully.
[root at mailsrv1 ~]# grep cyrus /etc/shadow
cyrus:XXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXX:12345::::::
[root at mailsrv1 ~]# saslpasswd2 -c cyrus
Password:
Again (for verification):
[root at mailsrv1 ~]# 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
[root at mailsrv1 ~]#
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
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 <netsysadm at gmail.com> 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
> <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/afa8af36/attachment-0001.html
More information about the Info-cyrus
mailing list