From owner-freebsd-questions@FreeBSD.ORG Fri Aug 10 15:27:48 2012 Return-Path: Delivered-To: questions@FreeBSD.org Received: from mx1.freebsd.org (mx1.freebsd.org [69.147.83.52]) by hub.freebsd.org (Postfix) with ESMTP id 4A560106564A for ; Fri, 10 Aug 2012 15:27:48 +0000 (UTC) (envelope-from matthew@FreeBSD.org) Received: from smtp.infracaninophile.co.uk (smtp6.infracaninophile.co.uk [IPv6:2001:8b0:151:1:3cd3:cd67:fafa:3d78]) by mx1.freebsd.org (Postfix) with ESMTP id A864E8FC16 for ; Fri, 10 Aug 2012 15:27:47 +0000 (UTC) Received: from seedling.black-earth.co.uk (seedling.black-earth.co.uk [IPv6:2001:8b0:151:1:fa1e:dfff:feda:c0bb]) (authenticated bits=0) by smtp.infracaninophile.co.uk (8.14.5/8.14.5) with ESMTP id q7AFRhtA015595 (version=TLSv1/SSLv3 cipher=DHE-RSA-CAMELLIA256-SHA bits=256 verify=NO); Fri, 10 Aug 2012 16:27:43 +0100 (BST) (envelope-from matthew@FreeBSD.org) X-DKIM: OpenDKIM Filter v2.5.2 smtp.infracaninophile.co.uk q7AFRhtA015595 Authentication-Results: smtp.infracaninophile.co.uk/q7AFRhtA015595; dkim=none (no signature); dkim-adsp=none Message-ID: <5025286F.7070602@FreeBSD.org> Date: Fri, 10 Aug 2012 16:27:43 +0100 From: Matthew Seaman User-Agent: Mozilla/5.0 (Macintosh; Intel Mac OS X 10.6; rv:14.0) Gecko/20120713 Thunderbird/14.0 MIME-Version: 1.0 To: Robert Huff References: <20517.3419.673436.191619@jerusalem.litteratus.org> In-Reply-To: <20517.3419.673436.191619@jerusalem.litteratus.org> X-Enigmail-Version: 1.4.3 Content-Type: multipart/signed; micalg=pgp-sha1; protocol="application/pgp-signature"; boundary="------------enig7EBB65CABD1FAAB22287D0E5" X-Virus-Scanned: clamav-milter 0.97.5 at lucid-nonsense.infracaninophile.co.uk X-Virus-Status: Clean X-Spam-Status: No, score=-2.7 required=5.0 tests=ALL_TRUSTED,AWL,BAYES_00 autolearn=ham version=3.3.2 X-Spam-Checker-Version: SpamAssassin 3.3.2 (2011-06-06) on lucid-nonsense.infracaninophile.co.uk Cc: questions@FreeBSD.org Subject: Re: partial sendmail breakage X-BeenThere: freebsd-questions@freebsd.org X-Mailman-Version: 2.1.5 Precedence: list List-Id: User questions List-Unsubscribe: , List-Archive: List-Post: List-Help: List-Subscribe: , X-List-Received-Date: Fri, 10 Aug 2012 15:27:48 -0000 This is an OpenPGP/MIME signed message (RFC 2440 and 3156) --------------enig7EBB65CABD1FAAB22287D0E5 Content-Type: text/plain; charset=ISO-8859-1 Content-Transfer-Encoding: quoted-printable On 10/08/2012 14:32, Robert Huff wrote: > I have restarted sendmail and get this in /var/log/messages: >=20 > Aug 10 08:26:56 jerusalem sm-mta[87853]: sql_select option missing > Aug 10 08:26:56 jerusalem sm-mta[87853]: auxpropfunc error no mechanism= available >=20 > I'm (obviously) not a sendmail expert; what other information > should I provide to help figure out what went wrong? You've implemented saslauth in this sendmail instance against some sort of SQL database. However something has caused sendmail to lose the ability to look up user accounts in that DB. Could be all sorts of things: is the DB running? Can you login to it manually using the same credentials as sendmail? Has there been any changes to DB schemas or user grants recently? How about changes to /usr/local/lib/sasl2/Sendmail.conf ? One thing you can try is turning up the log level in Sendmail.conf to get a better idea of what SASL is trying to do. Add a line log_level: N where N is an integer, bigger meaning more verbose logging. Cheers, Matthew --=20 Dr Matthew J Seaman MA, D.Phil. PGP: http://www.infracaninophile.co.uk/pgpkey --------------enig7EBB65CABD1FAAB22287D0E5 Content-Type: application/pgp-signature; name="signature.asc" Content-Description: OpenPGP digital signature Content-Disposition: attachment; filename="signature.asc" -----BEGIN PGP SIGNATURE----- Version: GnuPG/MacGPG2 v2.0.16 (Darwin) Comment: Using GnuPG with Mozilla - http://enigmail.mozdev.org/ iEYEARECAAYFAlAlKG8ACgkQ8Mjk52CukIyLsgCfePBFfG9UV2ngvg4N5PF/3Y1s xzkAn0+5Gzwts56F5mAwrV56qpVEFQMl =RiAN -----END PGP SIGNATURE----- --------------enig7EBB65CABD1FAAB22287D0E5--