Done
START
|
STOP
|
MIN(s)
|
AVG(s)
|
MAX(s)
|
EXP<=180 (%)
|
80<EXP<=600 (%)
|
EXP>600 (%)
|
TOT.customers
|
2011-06-21 11:01
|
2011-06-21 11:21
|
58
|
867
|
3600
|
43
|
33
|
24
|
210
|
2011-06-21 11:06
|
2011-06-21 11:26
|
58
|
841
|
3600
|
43
|
35
|
22
|
214
|
2011-06-21 11:20
|
2011-06-21 11:40
|
59
|
523
|
3600
|
44
|
52
|
5
|
209
|
2011-06-21 11:41
|
2011-06-21 12:01
|
59
|
423
|
600
|
40
|
60
|
0
|
229
|
2011-06-21 12:57
|
2011-06-21 13:57
|
58
|
436
|
600
|
36
|
64
|
0
|
259
|
mysql> CALL StatExp('91.121.143.56',60,20);
+---------------------+---------------------+------+------+------+------------+------------------+-----------+------+
| START | STOP | MIN | AVG | MAX | EXP <= 180 | 180 < EXP <= 600 | EXP > 600 | TOT |
+---------------------+---------------------+------+------+------+------------+------------------+-----------+------+
| 2011-06-21 10:21:15 | 2011-06-21 10:41:15 | 3598 | 3599 | 3599 | 0 | 0 | 100 | 16 |
| 2011-06-21 10:41:15 | 2011-06-21 11:01:15 | 1798 | 2924 | 3600 | 0 | 0 | 100 | 24 |
| 2011-06-21 11:01:15 | 2011-06-21 11:21:15 | 58 | 867 | 3600 | 43 | 33 | 24 | 210 |
+---------------------+---------------------+------+------+------+------------+------------------+-----------+------+
3 rows in set (0.37 sec)
mysql> CALL StatExp('91.121.143.56',60,20);
+---------------------+---------------------+------+------+------+------------+------------------+-----------+------+
| START | STOP | MIN | AVG | MAX | EXP <= 180 | 180 < EXP <= 600 | EXP > 600 | TOT |
+---------------------+---------------------+------+------+------+------------+------------------+-----------+------+
| 2011-06-21 10:26:48 | 2011-06-21 10:46:48 | 3598 | 3599 | 3599 | 0 | 0 | 100 | 14 |
| 2011-06-21 10:46:48 | 2011-06-21 11:06:48 | 1798 | 3007 | 3600 | 0 | 0 | 100 | 24 |
| 2011-06-21 11:06:48 | 2011-06-21 11:26:48 | 58 | 841 | 3600 | 43 | 35 | 22 | 214 |
+---------------------+---------------------+------+------+------+------------+------------------+-----------+------+
mysql> CALL StatExp('91.121.143.56',60,20);
+---------------------+---------------------+------+------+------+------------+------------------+-----------+------+
| START | STOP | MIN | AVG | MAX | EXP <= 180 | 180 < EXP <= 600 | EXP > 600 | TOT |
+---------------------+---------------------+------+------+------+------------+------------------+-----------+------+
| 2011-06-21 10:40:26 | 2011-06-21 11:00:26 | 3598 | 3599 | 3600 | 0 | 0 | 100 | 13 |
| 2011-06-21 11:00:26 | 2011-06-21 11:20:26 | 1798 | 2874 | 3600 | 0 | 0 | 100 | 32 |
| 2011-06-21 11:20:26 | 2011-06-21 11:40:26 | 59 | 523 | 3600 | 44 | 52 | 5 | 209 |
+---------------------+---------------------+------+------+------+------------+------------------+-----------+------+
mysql> CALL StatExp('91.121.143.56',60,20);
+---------------------+---------------------+------+------+------+------------+------------------+-----------+------+
| START | STOP | MIN | AVG | MAX | EXP <= 180 | 180 < EXP <= 600 | EXP > 600 | TOT |
+---------------------+---------------------+------+------+------+------------+------------------+-----------+------+
| 2011-06-21 11:01:19 | 2011-06-21 11:21:19 | 3596 | 3599 | 3600 | 0 | 0 | 100 | 19 |
| 2011-06-21 11:21:19 | 2011-06-21 11:41:19 | 3598 | 3599 | 3600 | 0 | 0 | 100 | 4 |
| 2011-06-21 11:41:19 | 2011-06-21 12:01:19 | 59 | 423 | 600 | 40 | 60 | 0 | 229 |
+---------------------+---------------------+------+------+------+------------+------------------+-----------+------+
mysql> CALL StatExp('91.121.143.56',60,60);
+---------------------+---------------------+------+------+------+------------+------------------+-----------+------+
| START | STOP | MIN | AVG | MAX | EXP <= 180 | 180 < EXP <= 600 | EXP > 600 | TOT |
+---------------------+---------------------+------+------+------+------------+------------------+-----------+------+
| 2011-06-21 12:57:15 | 2011-06-21 13:57:15 | 58 | 436 | 600 | 36 | 64 | 0 | 259 |
+---------------------+---------------------+------+------+------+------------+------------------+-----------+------+
1 row in set (0.14 sec)
|
On 2011-06-21 11:42, Oussama Hammami wrote:
Bonjour,
On a commencé le teste pour forcer les min,max et defaut valeur de
l’expire:
Serveur astrad8.switzernet.com
Customers: 256
sip.conf
maxexpiry=600
minexpiry=60
defaultexpiry=180
|
teste avec mon telephone
Avant le reload d'asterisk
+-------------+---------------+---------------------+---------------------+---------------------------------------------+
| username | domain | last_modified | expires | TIMESTAMPDIFF(SECOND,last_modified,expires) |
+-------------+---------------+---------------------+---------------------+---------------------------------------------+
| 41215500327 | 91.121.143.56 | 2011-06-21 11:25:02 | 2011-06-21 12:25:01 | 3599 |
+-------------+---------------+---------------------+---------------------+---------------------------------------------+
Après le reload d'asterisk
+-------------+---------------+---------------------+---------------------+---------------------------------------------+
| username | domain | last_modified | expires | TIMESTAMPDIFF(SECOND,last_modified,expires) |
+-------------+---------------+---------------------+---------------------+---------------------------------------------+
| 41215500327 | 91.121.143.56 | 2011-06-21 11:26:17 | 2011-06-21 11:36:17 | 600 |
+-------------+---------------+---------------------+---------------------+---------------------------------------------+
|
Statistique d'enregistrement
mysql> CALL StatExp('91.121.143.56',60,20);
+---------------------+---------------------+------+------+------+------------+------------------+-----------+------+
| START | STOP | MIN | AVG | MAX | EXP <= 180 | 180 < EXP <= 600 | EXP > 600 | TOT |
+---------------------+---------------------+------+------+------+------------+------------------+-----------+------+
| 2011-06-21 10:21:15 | 2011-06-21 10:41:15 | 3598 | 3599 | 3599 | 0 | 0 | 100 | 16 |
| 2011-06-21 10:41:15 | 2011-06-21 11:01:15 | 1798 | 2924 | 3600 | 0 | 0 | 100 | 24 |
| 2011-06-21 11:01:15 | 2011-06-21 11:21:15 | 58 | 867 | 3600 | 43 | 33 | 24 | 210 |
+---------------------+---------------------+------+------+------+------------+------------------+-----------+------+
3 rows in set (0.37 sec)
|
On 2011-06-14 01:10, Emin Gabrielyan wrote:
Examine a situation when the server (asterisk) forces a short registration period (such as 1m), but the telephone ignores and sends the registrations with longer intervals. Will server unregistered the UA if the UA sends it's next register after 3 min instead of requested 1m.
Envoyé de mon iPad
|