radius accounting not starting....

[Alan DeKok]

On Mar 15, 2019, at 10:55 AM, Somanath Mishra <somanath.mishra at planetsbrain.com> wrote:
> Many thanks for the suggestion.after modified radius IP in controller it
> worked. but still not getting data in radaact table.showing error like
> "Incorrect datetime value: '1552660521' for column 'acctstarttime' at row
> 1". Please help.
> 
> 
> 
> here are the logs:
> 
> freeradius    | (0) Received Access-Request Id 169 from 192.168.0.4:47212
> to 172.25.0.101:1812 length 182

  Please just post the output of "radiusd -X".  There's no need to add a "freeradius | " header to every line.  That makes it harder to read.

  And only post the *relevant* logs.  If you have a question about accounting, you don't need to post authentication requests.

> freeradius    | (1) sql: Executing query: INSERT INTO radacct
> (acctsessionid, acctuniqueid, username, realm, nasipaddress, nasportid,
> nasporttype, acctstarttime, acctupdatetime, acctstoptime, acctsessiontime,
> acctauthentic, connectinfo_start, connectinfo_stop, acctinputoctets,
> acctoutputoctets, calledstationid, callingstationid, acctterminatecause,
> servicetype, framedprotocol, framedipaddress) VALUES ('1801000A-0001122B',
> 'd99b6270bc08322e50fc1284c175858d', '12378@@TM11', '', '192.168.0.4', '0',
> 'Wireless-802.11', 1552660517, 1552660517, NULL, '0', 'RADIUS', 'CONNECT
> Unknown Radio', '', '0', '0', '00:0c:29:67:6d:ec', '9c:4e:36:9c:71:18',
> '', '', '', '10.0.1.24')
> freeradius    | (1) sql: ERROR: rlm_sql_mysql: ERROR 1292 (Incorrect
> datetime value: '1552660517' for column 'acctstarttime' at row 1): 22007

  You're either running a very old version of FreeRADIUS, or you edited the MySQL queries and broke them.

  The default configuration in v3 (mods-config/sql/main/mysql/queries.conf) contains:

	...
					AcctStartTime = FROM_UNIXTIME(%{integer:Event-Timestamp}), \
	...

  Which works.

  Use the standard queries that come with FreeRADIUS.

  Alan DeKok.