From owner-freebsd-questions@FreeBSD.ORG  Sun Feb 26 19:37:31 2006
Return-Path: <owner-freebsd-questions@FreeBSD.ORG>
X-Original-To: freebsd-questions@freebsd.org
Delivered-To: freebsd-questions@freebsd.org
Received: from mx1.FreeBSD.org (mx1.freebsd.org [216.136.204.125])
	by hub.freebsd.org (Postfix) with ESMTP id 8B1D416A420
	for <freebsd-questions@freebsd.org>;
	Sun, 26 Feb 2006 19:37:31 +0000 (GMT)
	(envelope-from fred@automaticrootbeer.com)
Received: from mta4.srv.hcvlny.cv.net (mta4.srv.hcvlny.cv.net [167.206.4.199])
	by mx1.FreeBSD.org (Postfix) with ESMTP id 3AE3843D45
	for <freebsd-questions@freebsd.org>;
	Sun, 26 Feb 2006 19:37:30 +0000 (GMT)
	(envelope-from fred@automaticrootbeer.com)
Received: from [192.168.1.27] (ool-43503553.dyn.optonline.net [67.80.53.83])
	by mta4.srv.hcvlny.cv.net
	(Sun Java System Messaging Server 6.2-4.03 (built Sep 22 2005))
	with ESMTP id <0IVB000AF7UHUE00@mta4.srv.hcvlny.cv.net> for
	freebsd-questions@freebsd.org; Sun, 26 Feb 2006 14:37:30 -0500 (EST)
Date: Sun, 26 Feb 2006 14:37:27 -0500
From: Fred McCann <fred@automaticrootbeer.com>
In-reply-to: <mailman.0.1129741444.16876.freebsd-questions@freebsd.org>
To: freebsd-questions@freebsd.org
Message-id: <2C0034AB-3452-490B-823A-938C08E68AB1@automaticrootbeer.com>
MIME-version: 1.0
X-Mailer: Apple Mail (2.746.2)
Content-type: text/plain; charset=US-ASCII; delsp=yes; format=flowed
Content-transfer-encoding: 7BIT
References: <mailman.0.1129741444.16876.freebsd-questions@freebsd.org>
Subject: Re: Welcome to the "freebsd-questions" mailing list (Digest mode)
X-BeenThere: freebsd-questions@freebsd.org
X-Mailman-Version: 2.1.5
Precedence: list
List-Id: User questions <freebsd-questions.freebsd.org>
List-Unsubscribe: <http://lists.freebsd.org/mailman/listinfo/freebsd-questions>, 
	<mailto:freebsd-questions-request@freebsd.org?subject=unsubscribe>
List-Archive: <http://lists.freebsd.org/pipermail/freebsd-questions>
List-Post: <mailto:freebsd-questions@freebsd.org>
List-Help: <mailto:freebsd-questions-request@freebsd.org?subject=help>
List-Subscribe: <http://lists.freebsd.org/mailman/listinfo/freebsd-questions>, 
	<mailto:freebsd-questions-request@freebsd.org?subject=subscribe>
X-List-Received-Date: Sun, 26 Feb 2006 19:37:31 -0000

I'm trying to configure mod_authn_dbd to use a mysql database. I'm  
running MySQL 5.0.18 and Apache 2.2 on FreeBSD 6.0-RELEASE.


Here's what I have for configuration:

# Database Management
DBDriver mysql

#Connection string: database name and login credentials
DBDParams "dbname=UserDirectory user=readonly password=moo"

#Parameters for Connection Pool Management
DBDMin  1
DBDKeep 2
DBDMax  10
DBDExptime 60

NameVirtualHost 192.168.1.7

<VirtualHost 192.168.1.7:*>
         ServerAdmin admin@example.com
         DocumentRoot /usr/local/www/apache22/data
         ServerName intranet.example.com
         ErrorLog logs/intranet.example.com-error_log

         <Directory /usr/local/www/apache22/data>
                 AuthType Basic
                 AuthName "Intranet"
                 AuthBasicProvider dbd
                 Require valid-user
                 AuthDBDUserPWQuery "select password from  
user_permissions where username = %s"
         </Directory>
</VirtualHost>


When I try to start apache, I'm getting a segfault:

fry# /usr/local/etc/rc.d/apache22.sh onerestart
Performing sanity check on apache22 configuration:
Segmentation fault (core dumped)

I've tried removing each config option one at a time, and the  
offending directive is AuthDBDUserPWQuery. Is there something I'm  
doing wrong here? I've verified that the server is running, the  
username+password is correct, and the query is valid.

Is there anything I got wrong here? Is apr_dbd_mysql incompatible  
with my version of MySQL, FreeBSD, or Apache?

- Fred