<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN">
<HTML><HEAD>
<META http-equiv=Content-Type content="text/html; charset=iso-8859-1">
<META content="MSHTML 6.00.2900.2722" name=GENERATOR>
<STYLE></STYLE>
</HEAD>
<BODY bgColor=#ffffff>
<DIV>
<DIV><FONT face=Arial size=2>
<DIV><FONT face=Arial size=2></FONT> </DIV>
<DIV><FONT face=Arial size=2>Hello</FONT></DIV>
<DIV> </DIV>
<DIV>My name is Maikel Nixon Martin, I am developer and I am working in the
integration of my systems MikroTik with Radius using database mysql.
<BR> <BR>Everything is in perfect operation except the authentication for
mac address of my MikroTik in her interface wireless. <BR>
<BR>According to the manuals, I should add the mac address wanted as username in
my table radcheck, however he always returns me that mistake:</DIV>
<DIV><FONT face=Arial size=2></FONT> </DIV>
<DIV><FONT face=Arial size=2>rad_recv: Access-Request packet from host
10.10.20.150:32769, id=115,
length=86<BR> Service-Type =
Framed-User<BR> NAS-Port-Id =
"wlan1"<BR> User-Name =
"00:16:CF:9D:4C:B9"<BR> User-Password
= ""<BR> NAS-Identifier =
"MikroTik"<BR> NAS-IP-Address =
10.10.20.150<BR>rlm_sql (sql): Reserving sql socket id: 4<BR>rlm_sql: The
'Attribute' field is empty or NULL, skipping the entire row.<BR>rlm_sql (sql):
Error getting data from database<BR>rlm_sql (sql): SQL query error; rejecting
user<BR>rlm_sql (sql): Released sql socket id: 4<BR>rad_recv: Access-Request
packet from host 10.10.20.150:32769, id=115, length=86<BR>rad_recv:
Access-Request packet from host 10.10.20.150:32769, id=115,
length=86<BR></FONT></DIV>
<DIV><FONT face=Arial size=2>As the error message says, it is as if I could not
leave the attribute fields and null value. <BR> <BR>Then I added
other attributes to try to do to work as NAS-Ip-Address, NAS-Port-id among
others. But nothing was fast, the mistakes stay. <BR> <BR>I need an
urgent help because only lack that to finish the project. <BR>
<BR>Greetings <BR> <BR>Maikel Nixon Martin <BR>Development
department InfoTec Wireless. </FONT></DIV>
<DIV><FONT face=Arial
size=2>RS/Brasil.<BR></DIV></FONT></FONT></DIV></DIV></BODY></HTML>