yes i think it will work. see sql.conf if you can do something like that. i don't think to have any problem if i'll try it i'll tell you.
Kyriaki Gali, IT Applications Specialist Kinetix Tele.com Support Center, Tel & Fax: +30 2310 256140 GSM: +30 6947 723737 http://www.kinetix.gr e-mail: [EMAIL PROTECTED] ----- Original Message ----- From: "Edgars" <[EMAIL PROTECTED]> To: <[EMAIL PROTECTED]> Sent: Monday, October 18, 2004 11:32 AM Subject: Re: user lost connectivity > i know that my nas is sending Lost_Carrier as Acct-Terminate-Cause > value. So in some way i should put that stoptime in the radacct table > manually when this happens. Maybe some trigger on accounting_update_query? > > Edgars > Kyriaki Gali wrote: > > >yes i know it is a problem and i don't know if we can do something else. I > >have the same problem also > >so if you find anything please let me know. > > > >regards, > > > >Kyriaki Gali, > >IT Applications Specialist > >Kinetix Tele.com Support Center, > >Tel & Fax: +30 2310 256140 > >GSM: +30 6947 723737 > >http://www.kinetix.gr > >e-mail: [EMAIL PROTECTED] > >----- Original Message ----- > >From: "Edgars" <[EMAIL PROTECTED]> > >To: <[EMAIL PROTECTED]> > >Sent: Friday, October 15, 2004 1:39 PM > >Subject: [Fwd: Re: user lost connectivity] > > > > > > > > > >>i already have such a filed in radacct and it's staying to NULL value if > >> > >>this happens. > >> > >>Edgars > >> > >>Kyriaki Gali wrote: > >> > >> > >> > >>>This is a problem i don't know if there is a way to fix this but > >>>I suggest in radacct table to insert a field to get the disconnect cause, > >>> > >>> > >so > > > > > >>>if you haven't AcctStopTime you will know why. Or check for how long your > >>>cdr is without an AcctStopTime. > >>> > >>> > >>> > >>>Kyriaki Gali, > >>>IT Applications Specialist > >>>Kinetix Tele.com Support Center, > >>>Tel & Fax: +30 2310 256140 > >>>GSM: +30 6947 723737 > >>>http://www.kinetix.gr > >>>e-mail: [EMAIL PROTECTED] > >>>----- Original Message ----- > >>>From: "Edgars" <[EMAIL PROTECTED]> > >>>To: <[EMAIL PROTECTED]> > >>>Sent: Friday, October 15, 2004 1:15 PM > >>>Subject: user lost connectivity > >>> > >>> > >>> > >>> > >>> > >>> > >>>>Hello, > >>>> > >>>>is there anyway how to write acctstoptime when the user is loosing > >>>>connectivity with his NAS? After this happens the user is promted to > >>>>login again but the previous acctstoptime stays blank. > >>>> > >>>>Edgars > >>>> > >>>> > >>>>- > >>>>List info/subscribe/unsubscribe? See > >>>> > >>>> > >>>> > >>>> > >>>http://www.freeradius.org/list/users.html > >>> > >>> > >>>- > >>>List info/subscribe/unsubscribe? See > >>> > >>> > >http://www.freeradius.org/list/users.html > > > > > >>> > >>> > >>> > >>> > >>-- > >>Edgars > >> > >> > >> > >> > >>- > >>List info/subscribe/unsubscribe? See > >> > >> > >http://www.freeradius.org/list/users.html > > > > > >- > >List info/subscribe/unsubscribe? See http://www.freeradius.org/list/users.html > > > > > > > > > > - > List info/subscribe/unsubscribe? See http://www.freeradius.org/list/users.html - List info/subscribe/unsubscribe? See http://www.freeradius.org/list/users.html