delayed update on sql logging

[Oguzhan Kayhan]

>> At the first try of sql i see the error
>> rlm_sql (sql_lojnet): Couldn't insert SQL accounting START record -
>> Column
>> 'AcctStopTime' cannot be null
>>
>> Maybe that might be causing this...
>> So how can i fix that???
>
> Something is wrong with your schema. Default is:
>
>  acctstoptime datetime NULL default NULL
>
> Are you using schema that doesn't belong to this server version?
>
> Ivan Kalik
> Kalik Informatika ISP
>

Schema might belong to a previous version of freeradius.
But i solved this issue with changing dialup.conf as follows.Now it works...




accounting_start_query = " \
          INSERT INTO ${acct_table1} \
            (acctsessionid,    acctuniqueid,     username, \
             realm,            nasipaddress,     nasportid, \
             nasporttype,      acctstarttime,    acctstoptime, \
             acctsessiontime,  acctauthentic,    connectinfo_start, \
             connectinfo_stop, acctinputoctets,  acctoutputoctets, \
             calledstationid,  callingstationid, acctterminatecause, \
             servicetype,      framedprotocol,   framedipaddress, \
             acctstartdelay,   acctstopdelay,    xascendsessionsvrkey) \
          VALUES \
            ('%{Acct-Session-Id}', '%{Acct-Unique-Session-Id}', \
             '%{SQL-User-Name}', \
             '%{Realm}', '%{NAS-IP-Address}', '%{NAS-Port}', \
             '%{NAS-Port-Type}', '%S', '0000-00-00 00:00:00', \
             '0', '%{Acct-Authentic}', '%{Connect-Info}', \
             '', '0', '0', \
             '%{Called-Station-Id}', '%{Calling-Station-Id}', '', \
             '%{Service-Type}', '%{Framed-Protocol}',
'%{Framed-IP-Address}', \
             '%{%{Acct-Delay-Time}:-0}', '0', '%{X-Ascend-Session-Svr-Key}')"





> -
> List info/subscribe/unsubscribe? See
> http://www.freeradius.org/list/users.html
>