Исходное сообщение
"FreeRadius сбор CDR в разные таблицы" Отправлено Renat, 27-Сен-13 14:57
> В sql.conf: > sql { > ... >  switch "%{User-Name}" { >   case Cisco1 {accounting_start_query = "INSERT into ${acct_table1} ...} >   case Cisco2 {accounting_start_query = "INSERT into ${acct_table2} ...} >  } > ... > } Не поехало Raidus отказывается запускатся 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', NULL, \              '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}')"