Hello,
We have added a feature to auth_db which will update the time of the last successful login in the subscriber table. This gives an easy way to find the number of active users in the past day/week/month etc.
Please send me any comments on the attached patch.
There will of course be documentation in the final cut!
Hugh
On 13 Mar 2014, at 18:30, Hugh Waite hugh.waite@crocodile-rcs.com wrote:
Hello, We have added a feature to auth_db which will update the time of the last successful login in the subscriber table. This gives an easy way to find the number of active users in the past day/week/month etc.
Please send me any comments on the attached patch.
There will of course be documentation in the final cut!
That information is already in the location table - why do you want it in the subscriber table too?
There's no "login" in SIP - what are you documenting here?
/O
maybe because after AOR's expire this information will be deleted ?
On Thu, Mar 13, 2014 at 6:49 PM, Olle E. Johansson oej@edvina.net wrote:
On 13 Mar 2014, at 18:30, Hugh Waite hugh.waite@crocodile-rcs.com wrote:
Hello, We have added a feature to auth_db which will update the time of the last successful login in the subscriber table. This gives an easy way to find the number of active users in the past day/week/month etc.
Please send me any comments on the attached patch.
There will of course be documentation in the final cut!
That information is already in the location table - why do you want it in the subscriber table too?
There's no "login" in SIP - what are you documenting here?
/O
sr-dev mailing list sr-dev@lists.sip-router.org http://lists.sip-router.org/cgi-bin/mailman/listinfo/sr-dev
On 13 Mar 2014, at 19:51, Alexandr Dubovikov alexandr.dubovikov@gmail.com wrote:
maybe because after AOR's expire this information will be deleted ?
And now we have an event_route to insert something in any table at that point...
I still don't understand how it belongs to the subscriber table.
/O
On Thu, Mar 13, 2014 at 6:49 PM, Olle E. Johansson oej@edvina.net wrote:
On 13 Mar 2014, at 18:30, Hugh Waite hugh.waite@crocodile-rcs.com wrote:
Hello, We have added a feature to auth_db which will update the time of the last successful login in the subscriber table. This gives an easy way to find the number of active users in the past day/week/month etc.
Please send me any comments on the attached patch.
There will of course be documentation in the final cut!
That information is already in the location table - why do you want it in the subscriber table too?
There's no "login" in SIP - what are you documenting here?
/O
sr-dev mailing list sr-dev@lists.sip-router.org http://lists.sip-router.org/cgi-bin/mailman/listinfo/sr-dev
sr-dev mailing list sr-dev@lists.sip-router.org http://lists.sip-router.org/cgi-bin/mailman/listinfo/sr-dev
The reason for storing the last registation with the subscriber is, as Alexandr says, so it is permanent. If I have a million accounts I can see how many have registered within the last month etc, not just how many are online at one point.
If an event_route can be run when the contact is inserted (i.e. on a UL_CONTACT_INSERT callback) then we could use sqlops to update this info in any table, including subscriber. I don't believe there is one though. This patch stores the time of successful registrations at the point that they are inserted, not when they expire, or when they are successfully un-registered.
Maybe this patch is too specific, and making event routes for the usrloc callbacks would be more flexible?
Hugh
On 13/03/2014 20:18, Olle E. Johansson wrote:
On 13 Mar 2014, at 19:51, Alexandr Dubovikov <alexandr.dubovikov@gmail.com mailto:alexandr.dubovikov@gmail.com> wrote:
maybe because after AOR's expire this information will be deleted ?
And now we have an event_route to insert something in any table at that point...
I still don't understand how it belongs to the subscriber table.
/O
On Thu, Mar 13, 2014 at 6:49 PM, Olle E. Johansson <oej@edvina.net mailto:oej@edvina.net> wrote:
On 13 Mar 2014, at 18:30, Hugh Waite <hugh.waite@crocodile-rcs.com <mailto:hugh.waite@crocodile-rcs.com>> wrote:Hello, We have added a feature to auth_db which will update the time of the last successful login in the subscriber table. This gives an easy way to find the number of active users in the past day/week/month etc. Please send me any comments on the attached patch. There will of course be documentation in the final cut!That information is already in the location table - why do you want it in the subscriber table too? There's no "login" in SIP - what are you documenting here? /O _______________________________________________ sr-dev mailing list sr-dev@lists.sip-router.org <mailto:sr-dev@lists.sip-router.org> http://lists.sip-router.org/cgi-bin/mailman/listinfo/sr-dev
sr-dev mailing list sr-dev@lists.sip-router.org mailto:sr-dev@lists.sip-router.org http://lists.sip-router.org/cgi-bin/mailman/listinfo/sr-dev
sr-dev mailing list sr-dev@lists.sip-router.org http://lists.sip-router.org/cgi-bin/mailman/listinfo/sr-dev
-
Alexandr Dubovikov -
Hugh Waite -
Olle E. Johansson