13 Mar
2014
13 Mar
'14
7:30 p.m.
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
13 Mar
13 Mar
7:49 p.m.
On 13 Mar 2014, at 18:30, Hugh Waite <hugh.waite(a)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
8:51 p.m.
maybe because after AOR's expire this information will be deleted ?
On Thu, Mar 13, 2014 at 6:49 PM, Olle E. Johansson <oej(a)edvina.net> wrote:
On 13 Mar 2014, at 18:30, Hugh Waite <hugh.waite(a)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(a)lists.sip-router.org
http://lists.sip-router.org/cgi-bin/mailman/listinfo/sr-dev
10:18 p.m.
On 13 Mar 2014, at 19:51, Alexandr Dubovikov <alexandr.dubovikov(a)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(a)edvina.net> wrote:
On 13 Mar 2014, at 18:30, Hugh Waite <hugh.waite(a)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(a)lists.sip-router.org
http://lists.sip-router.org/cgi-bin/mailman/listinfo/sr-dev
_______________________________________________
sr-dev mailing list
sr-dev(a)lists.sip-router.org
http://lists.sip-router.org/cgi-bin/mailman/listinfo/sr-dev
14 Mar
14 Mar
12:37 a.m.
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(a)gmail.com <mailto:alexandr.dubovikov@gmail.com>>
wrote:
--
Hugh Waite
Principal Design Engineer
Crocodile RCS Ltd.
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(a)edvina.net
<mailto:oej@edvina.net>> wrote:
On 13 Mar 2014, at 18:30, Hugh Waite
<hugh.waite(a)crocodile-rcs.com
<mailto:hugh.waite@crocodile-rcs.com>> wrote:
_______________________________________________
sr-dev mailing list
sr-dev(a)lists.sip-router.org
http://lists.sip-router.org/cgi-bin/mailman/listinfo/sr-dev 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(a)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(a)lists.sip-router.org <mailto:sr-dev@lists.sip-router.org>
http://lists.sip-router.org/cgi-bin/mailman/listinfo/sr-dev
3912
days inactive
3912
days old
4 comments
3 participants
participants (3)
-
Alexandr Dubovikov -
Hugh Waite -
Olle E. Johansson