saslpasswd2: could not find auxprop plugin

[Simone Romano]

Dear Dan,

I have my user in Mysql DB. At this time I can send mail on other recipients
(pippo at gmail.com for example) but I can't receive it?

If I try to send e-mail to my recipient I have the following message on
/var/log/mail.info

Jan 14 18:15:29 ms postfix/smtpd[18247]: connect from unknown[192.168.1.3]
Jan 14 18:15:29 ms postfix/smtpd[18247]: 625972BAD2:
client=unknown[192.168.1.3]
Jan 14 18:15:30 ms postfix/cleanup[18260]: 625972BAD2:
message-id=<000a01c9766b$4ae01ef0$e0a05cd0$@it>
Jan 14 18:15:30 ms postfix/qmgr[18212]: 625972BAD2: from=<cyrus at dajs.it>,
size=2623, nrcpt=1 (queue active)
Jan 14 18:15:30 ms postfix/pipe[18270]: 625972BAD2:
to=<cyrus.dajs.it at ms.farm.dajs>,
orig_to=<cyrus at dajs.it>, relay=cyrus, delay=0.88, delays=0.78/0.01/0/0.09,
dsn=5.6.0, status=bounced (data format error. Command output: cyrus.dajs.it:
Mailbox does not exist )
Jan 14 18:15:30 ms postfix/cleanup[18260]: 2D9A02BAE3:
message-id=<20090114171530.2D9A02BAE3 at ms.farm.dajs>
Jan 14 18:15:30 ms postfix/bounce[18276]: 625972BAD2: sender non-delivery
notification: 2D9A02BAE3
Jan 14 18:15:30 ms postfix/qmgr[18212]: 2D9A02BAE3: from=<>, size=4414,
nrcpt=1 (queue active)
Jan 14 18:15:30 ms postfix/qmgr[18212]: 625972BAD2: removed
Jan 14 18:15:30 ms postfix/pipe[18270]: 2D9A02BAE3:
to=<cyrus.dajs.it at ms.farm.dajs>,
orig_to=<cyrus at dajs.it>, relay=cyrus, delay=0.12, delays=0.04/0.02/0/0.05,
dsn=5.6.0, status=bounced (data format error. Command output: cyrus.dajs.it:
Mailbox does not exist )
Jan 14 18:15:30 ms postfix/qmgr[18212]: 2D9A02BAE3: removed
Jan 14 18:15:32 ms postfix/smtpd[18247]: disconnect from
unknown[192.168.1.3]

Could you suggest me a solution of this problem.
Thanks for support
Simone

2009/1/14 Dan White <dwhite at olp.net>

> Simone Romano wrote:
>
>> Hi to all,
>>
>> I'm trying to install a mail server using the following guide:
>> www.delouw.ch/linux/Postfix-Cyrus-Web-cyradm-HOWTO/html/
>>
>> The installation seems to work. But now when I try to add new user and
>> create the sasldb2 DB with saslpasswd2 -c user command in my
>> /var/log/messages I found the following output:
>>
>> Jan 14 14:37:11 ms saslpasswd2: could not find auxprop plugin, was
>> searching for [all]
>> Jan 14 14:37:11 ms saslpasswd2: secret not changed for cyrus: no
>> writable auxprop plugin or setpass callback found
>> Jan 14 14:37:11 ms saslpasswd2: could not find auxprop plugin, was
>> searching for [all]
>>
>> And the /etc/saldb2 was not created
>>
>> I searched a solution by Google but I didn't find how to fix this error
>> Can anyone help me?
>>
>> Thanks in advance
>> Simo
>>
>>
>
> Simone,
>
> After looking through that document, I see the following SASL config tips:
>
> In /usr/local/lib/sasl2/smtpd.conf:
>
> pwcheck_method: saslauthd
>
> and in /etc/imapd.conf:
> sasl_mech_list: PLAIN
> sasl_pwcheck_method: saslauthd
>
> /etc/imapd-local.conf:
> sasl_mech_list: PLAIN
> sasl_pwcheck_method: saslauthd
>
> saslauthd is started like:
> /usr/local/sbin/saslauthd -c -a pam&
>
> and PAM is configured to use mysql - in /etc/pam.d/imap:
> auth sufficient pam_mysql.so user=mail passwd=secret host=localhost db=mail
> table=accountuser usercolumn=username passwdcolumn=password crypt=1
> logtable=log logmsgcolumn=msg logusercolumn=user loghostcolumn=host
> logpidcolumn=pid logtimecolumn=time
> auth sufficient pam_unix_auth.so
> account required pam_mysql.so user=mail passwd=secret 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  sufficient       pam_unix_acct.so
>
> And then later it encourages you to:
>
> "To add the Cyrus user to the sasldb use the command:
> saslpasswd2 -c cyrus
> Password: (enter your passwd)
> Again (for verification): (enter your password)"
>
> and then the next step is to create other users using a MySQL client
> utility.
>
>
> The problem is that there's a step missing somewhere before the
> 'saslpasswd2' command, which doesn't make a lot of sense given the bigger
> picture.
>
> Probably your easiest fix is just to use the MySQL client to create the
> 'cyrus' user, rather than using saslpasswd2.
>
> If you really wish to create users with saslpasswd2 then you'll need to
> create a saslpass2.conf config for SASL, to give it hints on how to store
> users.
>
> For example, place the following in /usr/lib/sasl2/saslpasswd2.conf:
> pwcheck_method: auxprop
> auxprop_plugin: sql
> mech_list: PLAIN LOGIN
> sql_engine: mysql
> sql_user: mail
> sql_passwd: <the mysql user mail's password>
> sql_hostnames: <the mysqld hostname>
> sql_database: mail
> sql_select: SELECT password FROM accountuser WHERE username = '%u@%r'
>     OR (username ='%u' AND domain_name = '') (all one line)
>
>
>
> SASL config options are documented in the /doc/options.html file within the
> SASL source.
>
> I found the above config in at http://www.qwik.net/howto/howto.pdf
>
>
-------------- next part --------------
An HTML attachment was scrubbed...
URL: http://lists.andrew.cmu.edu/pipermail/cyrus-sasl/attachments/20090114/1e6ab33a/attachment.html