From owner-freebsd-ports@freebsd.org Fri Nov 6 19:17:41 2015 Return-Path: Delivered-To: freebsd-ports@mailman.ysv.freebsd.org Received: from mx1.freebsd.org (mx1.freebsd.org [IPv6:2001:1900:2254:206a::19:1]) by mailman.ysv.freebsd.org (Postfix) with ESMTP id 4B627A289FD for ; Fri, 6 Nov 2015 19:17:41 +0000 (UTC) (envelope-from papowell@astart.com) Received: from astart2.astart.com (wsip-72-214-30-30.sd.sd.cox.net [72.214.30.30]) (using TLSv1 with cipher DHE-RSA-AES256-SHA (256/256 bits)) (Client did not present a certificate) by mx1.freebsd.org (Postfix) with ESMTPS id 301061F31 for ; Fri, 6 Nov 2015 19:17:40 +0000 (UTC) (envelope-from papowell@astart.com) Received: from laptop_93.private (localhost [127.0.0.1]) by astart2.astart.com (8.14.9/8.14.9) with ESMTP id tA6JHXgM020521 for ; Fri, 6 Nov 2015 11:17:33 -0800 (PST) (envelope-from papowell@astart.com) Message-ID: <563CFCCD.90006@astart.com> Date: Fri, 06 Nov 2015 11:17:33 -0800 From: Patrick Powell Reply-To: papowell@astart.com Organization: Astart Technologies User-Agent: Mozilla/5.0 (X11; FreeBSD amd64; rv:31.0) Gecko/20100101 Thunderbird/31.5.0 MIME-Version: 1.0 To: freebsd-ports@freebsd.org Subject: Re: www/mod_auth_mysql2 should be disabled for apache24 References: In-Reply-To: Content-Type: text/plain; charset=windows-1252; format=flowed Content-Transfer-Encoding: 7bit X-BeenThere: freebsd-ports@freebsd.org X-Mailman-Version: 2.1.20 Precedence: list List-Id: Porting software to FreeBSD List-Unsubscribe: , List-Archive: List-Post: List-Help: List-Subscribe: , X-List-Received-Date: Fri, 06 Nov 2015 19:17:41 -0000 On 11/06/15 08:03, Andreas Nilsson wrote: > Hello, > > Trying to resort to this module for mysql auth support in apache, I got the > exact same problem: > > httpd: Syntax error on line 533 of /usr/local/etc/apache24/httpd.conf: > Syntax error on line 2 of /usr/local/etc/apache24/Includes/my-ssl.conf: > Cannot load libexec/apache24/mod_auth_mysql.so into server: > /usr/local/libexec/apache24/mod_auth_mysql.so: Undefined symbol > "ap_requires" > > Since ap_requires was removed with apache24 release, there is no point in > building for apache24. > > Best regards > Andreas > _______________________________________________ > freebsd-ports@freebsd.org mailing list > https://lists.freebsd.org/mailman/listinfo/freebsd-ports > To unsubscribe, send any mail to "freebsd-ports-unsubscribe@freebsd.org" > Apparently these modules have been replaced/upgraded by mod_dbd Here is what I have in an httpd.conf file: ######## LOADMODULE ############# LoadModule authn_dbd_module libexec/apache24/mod_authn_dbd.so LoadModule authz_dbd_module libexec/apache24/mod_authz_dbd.so LoadModule dbd_module libexec/apache24/mod_dbd.so DBDriver mysql DBDParams "host=127.0.0.1 dbname=useraccounts user=secret pass=password" DBDMin 1 DBDKeep 8 DBDMax 20 DBDExptime 300 And a matching entry in htaccess. I suspect this could be added to the VirtualHost entry rather than in a separate file. AuthBasicProvider dbd AuthDBDUserPWQuery "SELECT password FROM permissions WHERE id = %s" Require valid-user AuthType Basic AuthName "accounting" There were quite a few helpful 'HOWTOs' on using the mod_dbd module and MySQL. Note that you may need to update/add MySQL support to the devel/apr1 module as it is not included by default. I hope this helps or at least gives some hints on using the mod_dbd module approach. -- Patrick Powell Astart Technologies papowell@astart.com 1530 Jamacha Rd, Suite X Network and System San Diego, CA 92019 Consulting 858-874-6543 FAX 858-751-2435 Web: www.astart.com