@simply:
What table are the user accounts supposed to be stored in ?
My greatest desire to store all user info on the DB.
Thanks for the reply.
DB? Table?
Yes, LDAP can use databases. It's up to you to configure a database backend for your LDAP Server!
I use the OpenLDAP build in database, no fancy backends.
Here are some relevant LDIF Files:
dn: ou=users,dc=bewoelkt,dc=lan
ou: users
objectClass: top
objectClass: organizationalUnit
structuralObjectClass: organizationalUnit
dn: ou=groups,dc=bewoelkt,dc=lan
ou: groups
objectClass: top
objectClass: organizationalUnit
structuralObjectClass: organizationalUnit
dn: uid=jho,ou=users,dc=bewoelkt,dc=lan
objectClass: top
objectClass: radiusprofile
objectClass: inetOrgPerson
cn: jho
sn: jho
uid: jho
description: Radius User Joerg Hochwald
userPassword: PWhere
radiusReplyItem: WISPr-Redirection-URL+='http://www.bewoelkt.net'
radiusReplyItem: WISPr-Bandwidth-Max-Down+=1024
radiusReplyItem: WISPr-Bandwidth-Max-Up+=1024
radiusReplyItem: WISPr-Location-Name+="FFM01"
radiusReplyItem: WISPr-Location-ID+="01"
radiusReplyItem: WISPr-Max-Daily-Session+=3600
radiusReplyItem: Simultaneous-Use+="0"
radiusReplyItem: Max-Daily-Session+='3600'
radiusReplyItem: MHS-INT-Site+="Default"
radiusReplyItem: myHotspot-Group+="Guest"
radiusSessionTimeout: 7200
Just include the Radius Schema in /etc/ldap/slapd.conf:
# Radius include
include /etc/ldap/schema/radius.schema
Now create a file (schema.conf below) with the following content:
include /etc/ldap/schema/radius.schema
And import the Schema to your LDAP Server:
slaptest -f schema.conf -F testdir/
ldapadd -Y EXTERNAL -H ldapi:/// -f testdir/cn\=config/cn\=schema/cn\=\{0\}radius.ldif
The Schema above works fine with pfSense. Just did some tests with 50k Users (imported via LDIF).
There is only one problem: The RADIUS didn't return all radiusReplyItem configured in the example above. But I didn't find the time to dig into that issue. All relevant infos are parsed :)
For mySQL: You will find a lot of good howtos via Google (Remember, this is your friend) ;-)