using freeradius + ldap + postgres + freebsd 5.4

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 = 1024

POSTGRESQL:

max_connections = 128
shared_buffers = 1000 # min 16 or max_connections*2, 8KB each

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


Thanks in advance!





--
# Bruno Gallant - scion@xxxxxxxxxxx - bsdnode@xxxxxxxxx
# In girum imus nocte ecce et consumimur igni.
# Quidquid latine dictum sit, altum sonatur.
_______________________________________________
freebsd-isp@xxxxxxxxxxx mailing list
http://lists.freebsd.org/mailman/listinfo/freebsd-isp
To unsubscribe, send any mail to "freebsd-isp-unsubscribe@xxxxxxxxxxx"

Relevant Pages

  • Re: Setting up openldap on Suse 10.0 for use with Open-Xchange
    ... OX stores user information in LDAP ... When I issue the same command from the command prompt I can login to PG SQL ... postgresql problem rather than an openldap problem. ...
    (alt.os.linux.suse)
  • Re: Postgresql very slow to start on with LDAP
    ... PostgreSQL start-up time because ridiculously high. ... (The PostgreSQL server isn't used as the back-end for LDAP; ... By looking at the LDAP server logs, I noticed that during the long time ...
    (Debian-User)
  • Postgresql very slow to start on with LDAP
    ... PostgreSQL start-up time because ridiculously high. ... (The PostgreSQL server isn't used as the back-end for LDAP; ... By looking at the LDAP server logs, I noticed that during the long time ...
    (Debian-User)
  • Re: postgreSQL und LDAP an eDirectory
    ... Ist zwar beim Überfliegen eher etwas wie ich LDAP in postgreSQL ... LDAP anzusprechen und sich darüber zu authentifizieren. ... Prev by Date: ... Next by Date: ...
    (de.comp.datenbanken.misc)