help

[InfoTec Computadores]

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 at peternixon.net>
To: "FreeRadius developers mailing list" 
<freeradius-devel at 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