Sorry, I fixed my own problem. I changed dialect = "sqlite" in mods-available <https://github.com/zhex900/radius-config/tree/master/version.3/mods-available> /*sql to "mysql" * *Now it works.* *Jake He* On 24 June 2015 at 14:29, Jake He <jake.he@gmail.com> wrote:
Hi,
I am running freeradius v3. acct-start-time is not inserted into the sql database. Below is the from the debug log.
After running this sql, acctstarttime field is 0000-00-00 00:00:00. I want the acct-start-time to have date and time.
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 ('82100105', 'bce29f02064857e16fe65303d219cfe4', 'jake', '', '10.1.1.23', '', 'Wireless-802.11', 1435126480, 1435126480, NULL, '0', 'RADIUS', '', '', '0', '0', '', '', '', 'Framed-User', '', '')