Where's this entries " entries in radcheck and radreply" OK, here's the way as I'm add the user (I don't know if this way is Ok)
mysql> INSERT INTO radcheck VALUES (1,'jpeterson','Password','==','loco'); mysql> INSERT INTO radreply VALUES (1,'jpeterson','Trapeze-VLAN-Name',':=','corp'); mysql> INSERT INTO radreply VALUES (2,'jpeterson','Session-Timeout',':=','300'); radtest atenea:/etc/freeradius# radtest jpeterson loco 127.0.0.1 0 mySecret Sending Access-Request of id 161 to 127.0.0.1 port 1812 User-Name = "jpeterson" User-Password = "loco" NAS-IP-Address = 255.255.255.255 NAS-Port = 0 rad_recv: Access-Reject packet from host 127.0.0.1:1812, id=161, length=20 atenea:/etc/freeradius# Debug of freeradius rad_recv: Access-Request packet from host 127.0.0.1:1111, id=168, length=61 User-Name = "jpeterson" User-Password = "loco" NAS-IP-Address = 255.255.255.255 NAS-Port = 0 Mon May 14 13:21:41 2007 : Debug: Processing the authorize section of radiusd.conf Mon May 14 13:21:41 2007 : Debug: modcall: entering group authorize for request 0 Mon May 14 13:21:41 2007 : Debug: modsingle[authorize]: calling preprocess (rlm_preprocess) for request 0 Mon May 14 13:21:41 2007 : Debug: modsingle[authorize]: returned from preprocess (rlm_preprocess) for request 0 Mon May 14 13:21:41 2007 : Debug: modcall[authorize]: module "preprocess" returns ok for request 0 Mon May 14 13:21:41 2007 : Debug: modsingle[authorize]: calling chap (rlm_chap) for request 0 Mon May 14 13:21:41 2007 : Debug: modsingle[authorize]: returned from chap (rlm_chap) for request 0 Mon May 14 13:21:41 2007 : Debug: modcall[authorize]: module "chap" returns noop for request 0 Mon May 14 13:21:41 2007 : Debug: modsingle[authorize]: calling mschap (rlm_mschap) for request 0 Mon May 14 13:21:41 2007 : Debug: modsingle[authorize]: returned from mschap (rlm_mschap) for request 0 Mon May 14 13:21:41 2007 : Debug: modcall[authorize]: module "mschap" returns noop for request 0 Mon May 14 13:21:41 2007 : Debug: modsingle[authorize]: calling suffix (rlm_realm) for request 0 Mon May 14 13:21:41 2007 : Debug: rlm_realm: No '@' in User-Name = "jpeterson", looking up realm NULL Mon May 14 13:21:41 2007 : Debug: rlm_realm: No such realm "NULL" Mon May 14 13:21:41 2007 : Debug: modsingle[authorize]: returned from suffix (rlm_realm) for request 0 Mon May 14 13:21:41 2007 : Debug: modcall[authorize]: module "suffix" returns noop for request 0 Mon May 14 13:21:41 2007 : Debug: modsingle[authorize]: calling eap (rlm_eap) for request 0 Mon May 14 13:21:41 2007 : Debug: rlm_eap: No EAP-Message, not doing EAP Mon May 14 13:21:41 2007 : Debug: modsingle[authorize]: returned from eap (rlm_eap) for request 0 Mon May 14 13:21:41 2007 : Debug: modcall[authorize]: module "eap" returns noop for request 0 Mon May 14 13:21:41 2007 : Debug: modsingle[authorize]: calling files (rlm_files) for request 0 Mon May 14 13:21:41 2007 : Debug: users: Matched entry DEFAULT at line 152 Mon May 14 13:21:41 2007 : Debug: modsingle[authorize]: returned from files (rlm_files) for request 0 Mon May 14 13:21:41 2007 : Debug: modcall[authorize]: module "files" returns ok for request 0 Mon May 14 13:21:41 2007 : Debug: modsingle[authorize]: calling sql (rlm_sql) for request 0 Mon May 14 13:21:41 2007 : Debug: radius_xlat: 'jpeterson' Mon May 14 13:21:41 2007 : Debug: rlm_sql (sql): sql_set_user escaped user --> 'jpeterson' Mon May 14 13:21:41 2007 : Debug: radius_xlat: 'SELECT id, UserName, Attribute, Value, op FROM radcheck WHE RE Username = BINARY 'jpeterson' ORDER BY id' Mon May 14 13:21:41 2007 : Debug: rlm_sql (sql): Reserving sql socket id: 3 Mon May 14 13:21:41 2007 : Debug: rlm_sql_mysql: query: SELECT id, UserName, Attribute, Value, op FROM radcheck WHERE Username = BINARY 'jpeterson' ORDER BY id --More-- oupcheck.Value,radgroupcheck.op FROM radgroupcheck,usergroup WHERE usergroup.Username = BINARY 'jpeterson' AND usergroup.Group Name = radgroupcheck.GroupName ORDER BY radgroupcheck.id' Mon May 14 13:21:41 2007 : Debug: rlm_sql_mysql: query: SELECT radgroupcheck.id,radgroupcheck.GroupName,radgroupcheck.Attribu te,radgroupcheck.Value,radgroupcheck.op FROM radgroupcheck,usergroup WHERE usergroup.Username = BINARY 'jpeterson' AND usergro up.GroupName = radgroupcheck.GroupName ORDER BY radgroupcheck.id Mon May 14 13:21:41 2007 : Debug: radius_xlat: 'SELECT id, UserName, Attribute, Value, op FROM radreply WHE RE Username = BINARY 'jpeterson' ORDER BY id' Mon May 14 13:21:41 2007 : Debug: rlm_sql_mysql: query: SELECT id, UserName, Attribute, Value, op FROM radreply WHERE Username = BINARY 'jpeterson' ORDER BY id Mon May 14 13:21:41 2007 : Debug: radius_xlat: 'SELECT radgroupreply.id,radgroupreply.GroupName,radgroupreply.Attribute,radgr oupreply.Value,radgroupreply.op FROM radgroupreply,usergroup WHERE usergroup.Username = BINARY 'jpeterson' AND usergroup.Grou pName = radgroupreply.GroupName ORDER BY radgroupreply.id' Mon May 14 13:21:41 2007 : Debug: rlm_sql_mysql: query: SELECT radgroupreply.id,radgroupreply.GroupName,radgroupreply.Attribu te,radgroupreply.Value,radgroupreply.op FROM radgroupreply,usergroup WHERE usergroup.Username = BINARY 'jpeterson' AND usergr oup.GroupName = radgroupreply.GroupName ORDER BY radgroupreply.id Mon May 14 13:21:41 2007 : Debug: rlm_sql (sql): Released sql socket id: 3 Mon May 14 13:21:41 2007 : Debug: modsingle[authorize]: returned from sql (rlm_sql) for request 0 Mon May 14 13:21:41 2007 : Debug: modcall[authorize]: module "sql" returns ok for request 0 Mon May 14 13:21:41 2007 : Debug: modsingle[authorize]: calling daily (rlm_counter) for request 0 Mon May 14 13:21:41 2007 : Debug: rlm_counter: Entering module authorize code Mon May 14 13:21:41 2007 : Debug: rlm_counter: Could not find Check item value pair Mon May 14 13:21:41 2007 : Debug: modsingle[authorize]: returned from daily (rlm_counter) for request 0 Mon May 14 13:21:41 2007 : Debug: modcall[authorize]: module "daily" returns noop for request 0 Mon May 14 13:21:41 2007 : Debug: modsingle[authorize]: calling checkval (rlm_checkval) for request 0 Mon May 14 13:21:41 2007 : Debug: rlm_checkval: Could not find item named Calling-Station-Id in request Mon May 14 13:21:41 2007 : Debug: rlm_checkval: Could not find attribute named Calling-Station-Id in check pairs Mon May 14 13:21:41 2007 : Debug: modsingle[authorize]: returned from checkval (rlm_checkval) for request 0 Mon May 14 13:21:41 2007 : Debug: modcall[authorize]: module "checkval" returns notfound for request 0 Mon May 14 13:21:41 2007 : Debug: modcall: leaving group authorize (returns ok) for request 0 Mon May 14 13:21:41 2007 : Debug: rad_check_password: Found Auth-Type System Mon May 14 13:21:41 2007 : Debug: auth: type "System" Mon May 14 13:21:41 2007 : Debug: Processing the authenticate section of radiusd.conf Mon May 14 13:21:41 2007 : Debug: modcall: entering group authenticate for request 0 Mon May 14 13:21:41 2007 : Debug: modsingle[authenticate]: calling unix (rlm_unix) for request 0 Mon May 14 13:21:41 2007 : Debug: modsingle[authenticate]: returned from unix (rlm_unix) for request 0 Mon May 14 13:21:41 2007 : Debug: modcall[authenticate]: module "unix" returns notfound for request 0 Mon May 14 13:21:41 2007 : Debug: modcall: leaving group authenticate (returns notfound) for request 0 Mon May 14 13:21:41 2007 : Debug: auth: Failed to validate the user. Mon May 14 13:21:41 2007 : Debug: Delaying request 0 for 1 seconds Mon May 14 13:21:41 2007 : Debug: Finished request 0 Mon May 14 13:21:41 2007 : Debug: Going to the next request Mon May 14 13:21:41 2007 : Debug: --- Walking the entire request list --- Mon May 14 13:21:41 2007 : Debug: Waking up in 1 seconds... --More-- Mon May 14 13:21:41 2007 : Debug: Finished request 0 Mon May 14 13:21:41 2007 : Debug: Going to the next request Mon May 14 13:21:41 2007 : Debug: --- Walking the entire request list --- Mon May 14 13:21:41 2007 : Debug: Waking up in 1 seconds... Mon May 14 13:21:42 2007 : Debug: --- Walking the entire request list --- Mon May 14 13:21:42 2007 : Debug: Waking up in 1 seconds... Mon May 14 13:21:43 2007 : Debug: --- Walking the entire request list --- Sending Access-Reject of id 168 to 127.0.0.1 port 1111 Mon May 14 13:21:43 2007 : Debug: Waking up in 4 seconds... Mon May 14 13:21:47 2007 : Debug: --- Walking the entire request list --- Mon May 14 13:21:47 2007 : Debug: Cleaning up request 0 ID 168 with timestamp 46489aa5 Mon May 14 13:21:47 2007 : Debug: Nothing to do. Sleeping until we see a request. -----Original Message----- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] org] On Behalf Of [EMAIL PROTECTED] Sent: Monday, May 14, 2007 4:42 PM To: FreeRadius users mailing list Subject: RE: freeradius+mysql Post the output from radiusd -X (open 2 ssh windows - 1 for radtest and one for debug) so we can see what's going on. Also post your entries in radcheck and radreply. Ivan Kalik Kalik Informatika ISP Dana 14/5/2007, "Hermidio A. Rodrguez Chavez" <[EMAIL PROTECTED]> piše: >Friend, thanks for your reply but where I must add this line? > >Thanks in advance > >Hermidio > >I've configure sql in my radiusd.conf > >I try to add one users and try too to test with radtest, but not right for >me!!! > >How I must add users ? > >Please help > > - List info/subscribe/unsubscribe? See http://www.freeradius.org/list/users.html - List info/subscribe/unsubscribe? See http://www.freeradius.org/list/users.html