rlm_sql: The 'Attribute' field is empty or NULL
Hi All I have this error in my log file : Sun Feb 16 09:17:57 2014 : Error: rlm_sql: The 'Attribute' field is empty or NULL, skipping the entire row. Sun Feb 16 09:17:57 2014 : Error: rlm_sql (sql): Error getting data from database Sun Feb 16 09:17:57 2014 : Error: [sql] SQL query error; rejecting user Sun Feb 16 09:18:00 2014 : Error: rlm_sql: The 'Attribute' field is empty or NULL, skipping the entire row. Sun Feb 16 09:18:00 2014 : Error: rlm_sql (sql): Error getting data from database Sun Feb 16 09:18:00 2014 : Error: [sql] SQL query error; rejecting user Do I have null attribute in my database ? or this null attribute is in request packet from NAS ? Best regards.
Dear alan I check in all database tables and there is no any null attribute in any tables. I want to know this error from rlm_sql can be related to request attribute or this errors is related to database attribute ? Best regards. On Sun, Feb 16, 2014 at 1:27 PM, <A.L.M.Buxey@lboro.ac.uk> wrote:
Hi,
I have this error in my log file : Sun Feb 16 09:17:57 2014 : Error: rlm_sql: The 'Attribute' field is empty or NULL, skipping the entire row.
so....what does the database show as attributes for this user? or the group they are in etc?
alan - List info/subscribe/unsubscribe? See http://www.freeradius.org/list/users.html
On 16 Feb 2014, at 10:39, Mehdi Ravanbakhsh <babakco@gmail.com> wrote:
Dear alan
I check in all database tables and there is no any null attribute in any tables.
I want to know this error from rlm_sql can be related to request attribute or this errors is related to database attribute ?
A row in radcheck radreply, radgroupcheck, radgroup reply, has a NULL value in the Attribute column. Arran Cudbard-Bell <a.cudbardb@freeradius.org> FreeRADIUS Development Team FD31 3077 42EC 7FCD 32FE 5EE2 56CF 27F9 30A8 CAA2
On 16 Feb 2014, at 11:22, Arran Cudbard-Bell <a.cudbardb@freeradius.org> wrote:
On 16 Feb 2014, at 10:39, Mehdi Ravanbakhsh <babakco@gmail.com> wrote:
Dear alan
I check in all database tables and there is no any null attribute in any tables.
I want to know this error from rlm_sql can be related to request attribute or this errors is related to database attribute ?
A row in radcheck radreply, radgroupcheck, radgroup reply, has a NULL value in the Attribute column.
in this case empty means ''. Arran Cudbard-Bell <a.cudbardb@freeradius.org> FreeRADIUS Development Team FD31 3077 42EC 7FCD 32FE 5EE2 56CF 27F9 30A8 CAA2
participants (3)
-
A.L.M.Buxey＠lboro.ac.uk -
Arran Cudbard-Bell -
Mehdi Ravanbakhsh