Bonjour,
Je pense qu'on a maintenant la preuve que ça fonctionne et que la
majorité des clients supporteront le forçage d'expire.
Serveur:astrad5.switzernet.com
Customers: 167
sip.conf
maxexpiry=600
minexpiry=60
defaultexpiry=180
rtignoreregexpire=yes
|
Date from - to
mysql> select min(t1),max(t2) from stat_expire group by cont;
+---------------------+---------------------+
| min(t1) | max(t2) |
+---------------------+---------------------+
| 2011-06-21 17:43:00 | 2011-06-21 21:05:54 |
+---------------------+---------------------+
1 row in set (0.00 sec)
|
min,max,avg pour les 2 premiers enregistrement après l'activation
du forçage d'expire
mysql> SELECT username,MIN(TIMESTAMPDIFF(SECOND,t1,t2)) as MIN_INTERVAL_1,AVG(TIMESTAMPDIFF(SECOND,t1,t2)) as AVG_INTERVAL_1,MAX(TIMESTAMPDIFF(SECOND,t1,t2)) as MAX_INTERVAL_1,MIN(TIMESTAMPDIFF(SECOND,t2,t3)) as MIN_INTERVAL_2,AVG(TIMESTAMPDIFF(SECOND,t2,t3)) as AVG_INTERVAL_2,MAX(TIMESTAMPDIFF(SECOND,t2,t3)) as MAX_INTERVAL_2 from stat_expire where TIMESTAMPDIFF(SECOND,t1,t2)>2 and TIMESTAMPDIFF(SECOND,t2,t3)>2 group by cont;
+-------------+----------------+----------------+----------------+----------------+----------------+----------------+
| username | MIN_INTERVAL_1 | AVG_INTERVAL_1 | MAX_INTERVAL_1 | MIN_INTERVAL_2 | AVG_INTERVAL_2 | MAX_INTERVAL_2 |
+-------------+----------------+----------------+----------------+----------------+----------------+----------------+
| 41215500XXX | 54 | 264.9515 | 613 | 55 | 265.0606 | 608 |
+-------------+----------------+----------------+----------------+----------------+----------------+----------------+
1 row in set (0.00 sec)
|
Expire par client:
mysql> SELECT username,TIMESTAMPDIFF(SECOND,t1,t2) as INTERVAL1,TIMESTAMPDIFF(SECOND,t2,t3) as INTERVAL2 from stat_expire;
+-------------+-----------+-----------+
| username | INTERVAL1 | INTERVAL2 |
+-------------+-----------+-----------+
| 41215500XXX | 175 | 174 |
| ... | 175 | 174 |
| 41215500XXX | 175 | 174 |
+-------------+-----------+-----------+
167 rows in set (0.00 sec)
|
Date d'enregistrement par client:
mysql> select * from stat_expire;
+-------------+---------------------+---------------------+---------------------+------+
| username | t1 | t2 | t3 | cont |
+-------------+---------------------+---------------------+---------------------+------+
| 41215500XXX | 2011-06-21 17:44:27 | 2011-06-21 17:47:22 | 2011-06-21 17:50:16 | 4 |
| ... |
| 41215500XXX | 2011-06-21 17:44:27 | 2011-06-21 17:47:22 | 2011-06-21 17:50:16 | 4 |
+-------------+---------------------+---------------------+---------------------+------+
167 rows in set (0.00 sec)
|
On 2011-06-21 14:15, Done-by Oussama Hammami wrote:
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.XX | 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.XX | 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
|