Hugh wrote... > The only possibilities I can think of are that you perhaps forgot the "," > between MAXLOGINS and FRAMED_NETMASK, or that the field FRAMED_NETMASK is > not defined in your database. > > Have a look at the trace 4 debug output to see exactly what Radiator is > doing with the database, and you can also set the DBI debugging environment > variable to get lots of debug information out of DBI/DBD. Nope, I didn't forget the "," and the field FRAMED_NETMASK is definitely defined in the database. Here's the debug level 4 for the userid/password in question, so you can see it just says bad password. The ONLY change between working and non-working was the additionof FRAMED_NETMASK to the AuthSelect and then adding AuthColumnDef 4,Framed-IP-Netmask,reply. ==============debug output==================== Type Time stamp Message 4 03/30/2000 14:08 Handling request with Handler 'Realm=DEFAULT' 4 03/30/2000 14:08 Deleting session for jlwest, 209.83.134.1, 1234 4 03/30/2000 14:08 do query is: delete from RADONLINE where NASIDENTIFIER='209.83.134.1' and NASPORT=01234 4 03/30/2000 14:08 Handling with Radius::AuthRADMIN 4 03/30/2000 14:08 do query is: insert into RADMESSAGES (TIME_STAMP, TYPE, MESSAGE) values (954446903, 4, 'Handling with Radius::AuthRADMIN') 4 03/30/2000 14:08 Handling with Radius::AuthRADMIN 4 03/30/2000 14:08 Handling with Radius::AuthRADMIN 4 03/30/2000 14:08 do query is: insert into RADMESSAGES (TIME_STAMP, TYPE, MESSAGE) values (954446903, 4, 'Handling with Radius::AuthRADMIN') 4 03/30/2000 14:08 Handling with Radius::AuthRADMIN 4 03/30/2000 14:08 Query is: select PASS_WORD,STATICADDRESS,TIMELEFT,MAXLOGINS,FRAMED_NETMASK from RADUSERS where USERNAME='jlwest' and BADLOGINS < 5 and VALIDFROM < 954446903 and VALIDTO > 954446903 4 03/30/2000 14:08 Radius::AuthRADMIN looks for match with jlwest 4 03/30/2000 14:08 do query is: insert into RADMESSAGES (TIME_STAMP, TYPE, MESSAGE) values (954446903, 4, 'Radius::AuthRADMIN looks for match with jlwest') 4 03/30/2000 14:08 Radius::AuthRADMIN looks for match with jlwest 4 03/30/2000 14:08 Query is: select NASIDENTIFIER, NASPORT, ACCTSESSIONID from RADONLINE where USERNAME='jlwest' 4 03/30/2000 14:08 Radius::AuthRADMIN REJECT: Bad Password 4 03/30/2000 14:08 do query is: insert into RADMESSAGES (TIME_STAMP, TYPE, MESSAGE) values (954446903, 4, 'Radius::AuthRADMIN REJECT: Bad Password') 4 03/30/2000 14:08 Radius::AuthRADMIN REJECT: Bad Password 4 03/30/2000 14:08 do query is: update RADUSERS set BADLOGINS=BADLOGINS+1 where USERNAME='jlwest' 4 03/30/2000 14:08 Query is: select PASS_WORD,STATICADDRESS,TIMELEFT,MAXLOGINS,FRAMED_NETMASK from RADUSERS where USERNAME='DEFAULT' and BADLOGINS < 5 and VALIDFROM < 954446903 and VALIDTO > 954446903 3 03/30/2000 14:08 Access rejected for jlwest: Bad Password ---------------------------------------------------------------------------- ---- === Archive at http://www.starport.net/~radiator/ Announcements on [EMAIL PROTECTED] To unsubscribe, email '[EMAIL PROTECTED]' with 'unsubscribe radiator' in the body of the message.
