Re: mysql troubles

2005-08-20 Thread Lewis Bergman
Alan DeKok said: > See the rlm_sql documentation. The '==' is a comparison operator. > Use ':=' > I did but somehow I didn't glean that from it. >> If I put the user in the users file, the correct post-auth sql query is >> executed and the accounting record is correctly inserted into the db. >

Re: freeradius proxy question

2005-08-20 Thread freeradius
> [EMAIL PROTECTED] wrote: >> Greetings. I am using freeradius and want to do the following: >> 1. proxy authentication to a secondary server for two-factor >> authentication >> 2. if the user is authenticated via the home server, add attributes via >> definitions from the local freeradius ser

How does FreeRADIUS compare? See HP.

2005-08-20 Thread Alan DeKok
http://www.hp.com/rnd/pdf_html/access_control_security_brief.htm It's interesting to note that the RADIUS servers they list are Microsoft IAS, Funk, and FreeRADIUS. This is happening more and more. Many of the smaller commercial vendors just can't compete with FreeRADIUS. Alan DeKok. - L

Re: mysql troubles

2005-08-20 Thread Alan DeKok
"Lewis Bergman" <[EMAIL PROTECTED]> wrote: > But, when I run the same sql command from the radius server's mysql client > I get: > mysql> SELECT id,UserName,Attribute,Value,op FROM radcheck WHERE Username > = 'testuser' ORDER BY id; > ++--+---+--++ > | id | UserN

Database field lengths for radacct and radpostauth

2005-08-20 Thread Thor Spruyt
I've reported bug 266 with a patch for postgresql http://bugs.freeradius.org/show_bug.cgi?id=266 You don't know the maximum length of the username and password of your roaming partners, but you need to store those as well into the database. -- Groeten, Regards, Salutations, Thor Spruyt M: +32 (0