problem with table radacct column acctstarttime acctstoptime

[Alan DeKok]

On May 24, 2018, at 8:29 AM, Alexandr <systemn17088 at gmail.com> wrote:
> 
> 
> On 24.05.2018 11:59, Alexandr wrote:
>> I found function strftime, i think it writes time , but i found error contain strftime
>> 
>> (12) sql: ERROR: rlm_sql_mysql: ERROR 1305 (FUNCTION radius_serv.strftime does not exist): 42000
>> (12) sql: SQL query returned: server error
>> 
>> How do fix it?

  Read the MySQL documentation to see what functions it accepts.

  If you edit the SQL queries, you should know how to do that, and how to debug issues with them.

  And *read* the debug output.  ALL OF IT.  Try to understand what it's doing:

 	http://wiki.freeradius.org/radius-X

  If you only look at 1-2 lines of the output, you will never understand the problem.  And therefore never fix it.

  Alan DeKok.