Hi Maikel You should be asking this type of question on the users list. FreeRADIUS is telling you the problem in the logs you posted: rlm_sql: The 'Attribute' field is empty or NULL, skipping the entire row. rlm_sql (sql): Error getting data from database rlm_sql (sql): SQL query error; rejecting user ie. You dont have the correct information in the database table. Regards Peter On Sat 13 Oct 2007, InfoTec Computadores wrote:
Hello
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.
Everything is in perfect operation except the authentication for mac address of my MikroTik in her interface wireless.
According to the manuals, I should add the mac address wanted as username in my table radcheck, however he always returns me that mistake:
rad_recv: Access-Request packet from host 10.10.20.150:32769, id=115, length=86 Service-Type = Framed-User NAS-Port-Id = "wlan1" User-Name = "00:16:CF:9D:4C:B9" User-Password = "" NAS-Identifier = "MikroTik" NAS-IP-Address = 10.10.20.150 rlm_sql (sql): Reserving sql socket id: 4 rlm_sql: The 'Attribute' field is empty or NULL, skipping the entire row. rlm_sql (sql): Error getting data from database rlm_sql (sql): SQL query error; rejecting user rlm_sql (sql): Released sql socket id: 4 rad_recv: Access-Request packet from host 10.10.20.150:32769, id=115, length=86 rad_recv: Access-Request packet from host 10.10.20.150:32769, id=115, length=86
As the error message says, it is as if I could not leave the attribute fields and null value.
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.
I need an urgent help because only lack that to finish the project.
Greetings
Maikel Nixon Martin Development department InfoTec Wireless. RS/Brasil.
-- Peter Nixon http://peternixon.net/