RE: sendmail + mysql login

From: Michael C. Clark (me at michaelcclark dot com)
Date: Mon Sep 29 2003 - 05:44:46 EDT

  • Next message: Diego Rivera: "User name problems with Postfix"

    Hi Danny,

    You can most certainly authenticate using SASL against the mySQL
    database. You are exactly correct that the Sendmail.conf file is the
    key. The directives are quite similar to those for IMAP config, but
    without the "sasl_"

    My Sendmail.conf looks like this:

    pwcheck_method:auxprop
    auxprop_plugin:sql
    sql_engine:mysql
    sql_user:cyrus
    sql_passwd:cyrus
    sql_hostnames:127.0.0.1:3306
    sql_database:cyrus
    sql_statement:select userpassword from mail_users where username='%u'
    and realm='%r'
    sql_verbose:true

    The 2.1.15 documention describes the directives available.

    HTH,
    Michael C. Clark

    ---- Original Message ----
    From: danny at g2k dot es
    To: cyrus-sasl at lists dot andrew dot cmu dot edu
    Subject: RE: sendmail + mysql login
    Date: Mon, 29 Sep 2003 11:52:30 +0200

    >Hello List.
    >
    >I have cyrus-sasl-2.1.15 installed and my cyrus-imap-2_2b server is
    >authenticating users against mysql server database, using mysql
    >pluggin.
    >
    >/etc/imap.conf
    >
    >configdirectory: /var/imap
    >partition-default: /var/spool/imap
    >admins: cyrus cyrus at xxx dot com
    >virtdomains: yes
    >defaultdomain: localdomain
    >sasl_pwcheck_method: auxprop
    >sasl_auxprop_plugin: mysql
    >sasl_mysql_user: eeee
    >sasl_mysql_passwd: rrrr
    >sasl_mysql_hostnames: micalet
    >sasl_mysql_database: mail
    >sasl_mysql_statement: select plaintext from accountuser where user =
    >'%u'
    >and r$
    >sasl_mysql_verbose: false
    >
    >Then, right now i need smtp auth for authorized user into the same
    >mysql
    >database. Can i use mysql pluggin into Sendmail.conf file?. is
    >saslauthd
    >daemon neccesary to do this?.
    >
    >My sendmail ehlo response look like this:
    >
    >250-localhost.localdomain Hello micalet [127.0.0.1], pleased to meet
    >you
    >250-ENHANCEDSTATUSCODES
    >250-PIPELINING
    >250-8BITMIME
    >250-SIZE
    >250-DSN
    >250-ETRN
    >250-AUTH DIGEST-MD5 CRAM-MD5 PLAIN LOGIN
    >250-DELIVERBY
    >250 HELP
    >
    >Any Hints?
    >
    >Thank in advanced
    >Danny
    >


  • Next message: Diego Rivera: "User name problems with Postfix"





    Hosted Email Solutions

    Invaluement Anti-Spam DNSBLs



    Powered By FreeBSD   Powered By FreeBSD