Hello milver, i already test what you said. example for user X has a session time of 10 hrs (43200 secs). After 1 month he/she update his/her account then what i did add another 10 hrs, which will 43200 + 43200 = session timeout. but as i said we have a client with constant username, adding 10 hrs in session timeout everytime the user updating his/her account is too difficult to maintain. Im concern in noresetcounter sql_query which compute the total sum of user accounting. How to construct sql_query which only compute the total sum of user accounting from this date until this date. thanks you very much for your response.
----- Original Message ----- From: "Milver S. Nisay" <[EMAIL PROTECTED]> To: <[EMAIL PROTECTED]> Sent: Monday, April 26, 2004 9:08 PM Subject: Re: setting up accounting in mysql > > > Hello milver, what i mean is in noresetcounter configuration in > > rlm_sqlcounter. Where resetcounter add all accounting of the user and > > compare to session timeout. My problem is i have a client with constant > > username. example: user X have a connection of 10 hrs starting from date, > > April 26 which should expire on May 27. After May 26, 2004, user X update > > his/here account. Add another 10 hrs, take note user X has contant > username. > > What im doing is delete user X accounting, so that when he/she login again > > he/she have new accounting record which will be compared against his/her > > session timeout. A new start of his/her 10 hrs. Any comment or suggestion? > I > > want to keep this accounting of all users i have. > > one solution is edit your attributes from your database. if the old > attributes is 10 hours, add another 10 hours. > in this case, the accounting session are still intact with your database. > there is no need to delete > and re create his account, you just need to prolong his limit in hours. you > can do it directly with > your database, or using perl script or using PHP script to manipulate your > database. > prolong session-timout or max-all-session timeout attributes (if you are > using database). > > > > > > - > List info/subscribe/unsubscribe? See http://www.freeradius.org/list/users.html > > - List info/subscribe/unsubscribe? See http://www.freeradius.org/list/users.html