Re: Cyrus SASL auxprop mysql plugin

From: Ken Murchison (ken at oceana dot com)
Date: Fri Nov 21 2003 - 09:38:22 EST

  • Next message: Andre Gildemeister: "Re: Cyrus SASL auxprop mysql plugin"

    Andre Gildemeister wrote:

    > Hello List,
    >
    > I have a problem related to the Cyrus SASL auxprop MySQL Plugin.
    > After I compiled BerkleyDB 4.1.25, SASL 2.1.15 and Cyrus 2.1.15 on
    > Slackware Linux 9.1 and create the config file imapd.conf:
    >
    > configdirectory: /var/imap
    > partition-default: /var/spool/imap
    > admins: cyrus root
    > allowanonymouslogin: no
    > allowplaintext: yes
    > maxmessagesize: 262144000
    > sieveusehomedir: false
    > sievedir: /var/imap/sieve
    > hashimapspool: true
    > sieve_maxscriptsize: 32
    > sieve_maxscripts: 5
    > sasl_pwcheck_method: auxprop
    > sasl_auxprop_plugin: mysql
    > sasl_mysql_user: sasl
    > sasl_mysql_passwd: xxxxxxx
    > sasl_mysql_hostnames: localhost
    > sasl_mysql_database: mail
    > sasl_mysql_statement: select password from user where username='%u' LIMIT 1
    > sasl_mysql_verbose: true
    >
    > I started /usr/cyrus/bin/master and test the authentication with telnet
    > localhost 110. (the user and password were already stored in the
    > database table and nothing was wrong)
    > +OK neptun Cyrus POP3 v2.1.15 server ready <3438886587 dot 1069359941 at neptun>
    > user andre
    > +OK Name is a valid mailbox
    > pass xxxxx
    >
    > I type in the correct password, but because of the logfile entrys I
    > suppose that SASL could't find MySQL as a Plugin, beacuse of wrong
    > compiling? I compiled SASL with: ./configure
    > --with-openssl=/usr/include/openssl/ --enable-login
    > --with-mysql=/usr/local/mysql/
    >
    > neptun pop3d[713]: badlogin: localhost[127.0.0.1] plaintext andre
    > SASL(-13): user not found: checkpass failed
    >
    > neptun pop3[687]: executed
    > neptun pop3d[687]: accepted connection
    > eptun pop3d[687]: could not find auxprop plugin, was searching for 'mysql'
    >
    >
    > Any suggestions or help?

    Did you install the mysql plugin, and if so, where? You'll probably
    have to make a link from /usr/lib/sasl2 to the directory containing the
    plugins.

    -- 
    Kenneth Murchison     Oceana Matrix Ltd.
    Software Engineer     21 Princeton Place
    716-662-8973 x26      Orchard Park, NY 14127
    --PGP Public Key--    http://www.oceana.com/~ken/ksm.pgp
    

  • Next message: Andre Gildemeister: "Re: Cyrus SASL auxprop mysql plugin"





    Hosted Email Solutions

    Invaluement Anti-Spam DNSBLs



    Powered By FreeBSD   Powered By FreeBSD