From owner-freebsd-isp@FreeBSD.ORG  Mon Feb  6 20:31:35 2006
Return-Path: <owner-freebsd-isp@FreeBSD.ORG>
X-Original-To: freebsd-isp@freebsd.org
Delivered-To: freebsd-isp@freebsd.org
Received: from mx1.FreeBSD.org (mx1.freebsd.org [216.136.204.125])
	by hub.freebsd.org (Postfix) with ESMTP id 72FC916A423
	for <freebsd-isp@freebsd.org>; Mon,  6 Feb 2006 20:31:35 +0000 (GMT)
	(envelope-from bsdnode@gmail.com)
Received: from wproxy.gmail.com (wproxy.gmail.com [64.233.184.196])
	by mx1.FreeBSD.org (Postfix) with ESMTP id 512BA43D8C
	for <freebsd-isp@freebsd.org>; Mon,  6 Feb 2006 20:31:26 +0000 (GMT)
	(envelope-from bsdnode@gmail.com)
Received: by wproxy.gmail.com with SMTP id 71so1119692wra
	for <freebsd-isp@freebsd.org>; Mon, 06 Feb 2006 12:31:22 -0800 (PST)
DomainKey-Signature: a=rsa-sha1; q=dns; c=nofws; s=beta; d=gmail.com;
	h=received:message-id:date:from:to:subject:mime-version:content-type:content-transfer-encoding:content-disposition;
	b=Ea36mtcGG+c+vtvFzvvVlzxHGU4YF1WblxQxSS+JRdIrrIO7HrPVRaClu5SNM+u86eCd1KjM9ESFqHQ06k6RfAiCNwYyPL/v765Wwl0PYv3y+2DPw7W8i6hgi6XiZYrDCnTtoR83IAmfCW3mJdX0lYUd2tqkW/0swqV3CqkbpKs=
Received: by 10.54.76.1 with SMTP id y1mr4274229wra;
	Mon, 06 Feb 2006 12:30:27 -0800 (PST)
Received: by 10.54.152.2 with HTTP; Mon, 6 Feb 2006 12:31:21 -0800 (PST)
Message-ID: <40356a660602061231k23ed832bl9be22f5a7c3c3f06@mail.gmail.com>
Date: Mon, 6 Feb 2006 15:31:21 -0500
From: Bruno Gallant <bsdnode@gmail.com>
To: freebsd-isp@freebsd.org
MIME-Version: 1.0
Content-Type: text/plain; charset=ISO-8859-1
Content-Transfer-Encoding: quoted-printable
Content-Disposition: inline
Subject: using freeradius + ldap + postgres + freebsd 5.4
X-BeenThere: freebsd-isp@freebsd.org
X-Mailman-Version: 2.1.5
Precedence: list
List-Id: Internet Services Providers <freebsd-isp.freebsd.org>
List-Unsubscribe: <http://lists.freebsd.org/mailman/listinfo/freebsd-isp>,
	<mailto:freebsd-isp-request@freebsd.org?subject=unsubscribe>
List-Archive: <http://lists.freebsd.org/pipermail/freebsd-isp>
List-Post: <mailto:freebsd-isp@freebsd.org>
List-Help: <mailto:freebsd-isp-request@freebsd.org?subject=help>
List-Subscribe: <http://lists.freebsd.org/mailman/listinfo/freebsd-isp>,
	<mailto:freebsd-isp-request@freebsd.org?subject=subscribe>
X-List-Received-Date: Mon, 06 Feb 2006 20:31:35 -0000

Hello people,

I am having issues with a freeradius installation using ldap and
postgresql on a freebsd 5.4.

The radius server and the database is on the same machine, and the
ldap is on another one (both connected on a gigaswitch)

I have tried many settings to make freeradius work with postgres, but
it seems that under heavy loads, it breaks down, or gives me the
"Info: rlm_sql (sql_local): There are no DB handles to use!".

I have about 14,000 users, of these 2000 DSL subscribers and the rest
dialup users, with 3 NASes.

SYSTEM:
# sysctl -a | grep threads
kern.threads.thr_scope: 0
kern.threads.thr_concurrency: 0
kern.threads.debug: 0
kern.threads.max_threads_per_proc: 1500
kern.threads.max_groups_per_proc: 1500
kern.threads.max_threads_hits: 0
kern.threads.virtual_cpu: 2
vm.stats.vm.v_kthreads: 294

FREERADIUS:
max_requests =3D 1024

POSTGRESQL:

max_connections =3D 128
shared_buffers =3D 1000                   # min 16 or max_connections*2, 8K=
B each

If there are other settings you need to know, just tell me I'll post it.


Thanks in advance!





--
# Bruno Gallant - scion@bsdnode.net - bsdnode@gmail.com
# In girum imus nocte ecce et consumimur igni.
# Quidquid latine dictum sit, altum sonatur.