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.
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/
Hello Peter In my database, I added my customer's mac address in the format 00:11:AA:BB:CC:22, in the field Username, and anything plus, as command the manual. And the mistake persists. I thank for the attention Maikel Nixon Martin ----- Original Message ----- From: "Peter Nixon" <listuser@peternixon.net> To: "FreeRadius developers mailing list" <freeradius-devel@lists.freeradius.org> Sent: Saturday, October 13, 2007 5:43 AM Subject: Re: help
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/ - List info/subscribe/unsubscribe? See http://www.freeradius.org/list/devel.html
participants (2)
-
InfoTec Computadores -
Peter Nixon