ERROR: rlm_sql_mysql: ERROR 1136
I have noticed several messages in the freeradius logs that appear below: Fri Mar 24 17:18:12 2017 : ERROR: (17331) sql: ERROR: rlm_sql_mysql: ERROR 1136 (Column count doesn't match value count at row 1): 21S01 I made the system update (FreeBSD 10.3) and also updated freeradius to version 3.0.13, but the problem persists. Anyone know how to solve this? Regards, Renato L. Sousa
On Mar 24, 2017, at 4:42 PM, Renato Sousa <rensousa@gmail.com> wrote:
I have noticed several messages in the freeradius logs that appear below:
Fri Mar 24 17:18:12 2017 : ERROR: (17331) sql: ERROR: rlm_sql_mysql: ERROR 1136 (Column count doesn't match value count at row 1): 21S01
That error comes from MySL. Go see the MySQL documentation for how to fix it. Alan DeKok.
Hello Alan, That error comes from MySL. Go see the MySQL documentation for how to
fix it.
I looked at the SQL statements log and could not find any obvious errors. Today the radius server is in version 3.0.13. It has been updated a few times. Has the DB structure changed in these intermediate versions generating incompatibility with the radius server and the DB? How can I better diagnose this situation? Regards, Renato L. Sousa
On Mar 30, 2017, at 2:24 PM, Renato Sousa <rensousa@gmail.com> wrote:
Hello Alan,
That error comes from MySL. Go see the MySQL documentation for how to
fix it.
I looked at the SQL statements log and could not find any obvious errors.
What I'm saying is that you need to read the *MySQL documentation* to see what error 1136 is.
Today the radius server is in version 3.0.13. It has been updated a few times. Has the DB structure changed in these intermediate versions generating incompatibility with the radius server and the DB? How can I better diagnose this situation?
Go read the MySQL documentation. Alan DeKok.
participants (2)
-
Alan DeKok -
Renato Sousa