https://wikiold.home.tartarefr.eu/index.php?action=history&feed=atom&title=B2PWeb%2FServices%2FMonitoring%2FTopClient
B2PWeb/Services/Monitoring/TopClient - Historique des versions
2026-07-08T02:09:25Z
Historique des versions pour cette page sur le wiki
MediaWiki 1.43.8
https://wikiold.home.tartarefr.eu/index.php?title=B2PWeb/Services/Monitoring/TopClient&diff=2366&oldid=prev
Didier : /* Fonctionnement */
2013-09-09T09:15:24Z
<p><span class="autocomment">Fonctionnement</span></p>
<table style="background-color: #fff; color: #202122;" data-mw="interface">
<col class="diff-marker" />
<col class="diff-content" />
<col class="diff-marker" />
<col class="diff-content" />
<tr class="diff-title" lang="fr">
<td colspan="2" style="background-color: #fff; color: #202122; text-align: center;">← Version précédente</td>
<td colspan="2" style="background-color: #fff; color: #202122; text-align: center;">Version du 9 septembre 2013 à 09:15</td>
</tr><tr><td colspan="2" class="diff-lineno" id="mw-diff-left-l124">Ligne 124 :</td>
<td colspan="2" class="diff-lineno">Ligne 124 :</td></tr>
<tr><td class="diff-marker"></td><td style="background-color: #f8f9fa; color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #eaecf0; vertical-align: top; white-space: pre-wrap;"><div>== Fonctionnement ==</div></td><td class="diff-marker"></td><td style="background-color: #f8f9fa; color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #eaecf0; vertical-align: top; white-space: pre-wrap;"><div>== Fonctionnement ==</div></td></tr>
<tr><td class="diff-marker"></td><td style="background-color: #f8f9fa; color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #eaecf0; vertical-align: top; white-space: pre-wrap;"><br></td><td class="diff-marker"></td><td style="background-color: #f8f9fa; color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #eaecf0; vertical-align: top; white-space: pre-wrap;"><br></td></tr>
<tr><td class="diff-marker" data-marker="−"></td><td style="color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #ffe49c; vertical-align: top; white-space: pre-wrap;"><div>* La partie '''Engine''' : Sur '''<del style="font-weight: bold; text-decoration: none;">sql2-cogent</del>''', un script enrichit la base de données, moteur qui est lancé via un cron tous les quart d'heure.</div></td><td class="diff-marker" data-marker="+"></td><td style="color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #a3d3ff; vertical-align: top; white-space: pre-wrap;"><div>* La partie '''Engine''' : Sur '''<ins style="font-weight: bold; text-decoration: none;">stats</ins>''', un script enrichit la base de données, moteur qui est lancé via un cron tous les quart d'heure.</div></td></tr>
<tr><td class="diff-marker" data-marker="−"></td><td style="color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #ffe49c; vertical-align: top; white-space: pre-wrap;"><div>:# Requêtes mysql sur <del style="font-weight: bold; text-decoration: none;">sql2-cogent</del></div></td><td class="diff-marker" data-marker="+"></td><td style="color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #a3d3ff; vertical-align: top; white-space: pre-wrap;"><div>:# Requêtes mysql sur <ins style="font-weight: bold; text-decoration: none;">stats</ins></div></td></tr>
<tr><td class="diff-marker"></td><td style="background-color: #f8f9fa; color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #eaecf0; vertical-align: top; white-space: pre-wrap;"><div>:# Mise en base des résultats synthétisés</div></td><td class="diff-marker"></td><td style="background-color: #f8f9fa; color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #eaecf0; vertical-align: top; white-space: pre-wrap;"><div>:# Mise en base des résultats synthétisés</div></td></tr>
<tr><td class="diff-marker"></td><td style="background-color: #f8f9fa; color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #eaecf0; vertical-align: top; white-space: pre-wrap;"><div>* La partie '''serveur''' du topclient est installé sur tous les WSR et interroge la base '''monitoring'''</div></td><td class="diff-marker"></td><td style="background-color: #f8f9fa; color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #eaecf0; vertical-align: top; white-space: pre-wrap;"><div>* La partie '''serveur''' du topclient est installé sur tous les WSR et interroge la base '''monitoring'''</div></td></tr>
</table>
Didier
https://wikiold.home.tartarefr.eu/index.php?title=B2PWeb/Services/Monitoring/TopClient&diff=2365&oldid=prev
Didier le 9 septembre 2013 à 09:08
2013-09-09T09:08:14Z
<p></p>
<table style="background-color: #fff; color: #202122;" data-mw="interface">
<col class="diff-marker" />
<col class="diff-content" />
<col class="diff-marker" />
<col class="diff-content" />
<tr class="diff-title" lang="fr">
<td colspan="2" style="background-color: #fff; color: #202122; text-align: center;">← Version précédente</td>
<td colspan="2" style="background-color: #fff; color: #202122; text-align: center;">Version du 9 septembre 2013 à 09:08</td>
</tr><tr><td colspan="2" class="diff-lineno" id="mw-diff-left-l13">Ligne 13 :</td>
<td colspan="2" class="diff-lineno">Ligne 13 :</td></tr>
<tr><td class="diff-marker"></td><td style="background-color: #f8f9fa; color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #eaecf0; vertical-align: top; white-space: pre-wrap;"><div>* '''log''' : /var/log/monitoring-engine-topclient.log</div></td><td class="diff-marker"></td><td style="background-color: #f8f9fa; color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #eaecf0; vertical-align: top; white-space: pre-wrap;"><div>* '''log''' : /var/log/monitoring-engine-topclient.log</div></td></tr>
<tr><td class="diff-marker"></td><td style="background-color: #f8f9fa; color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #eaecf0; vertical-align: top; white-space: pre-wrap;"><div>* '''lock''' : /var/lock/b2p/topclient.lock}}</div></td><td class="diff-marker"></td><td style="background-color: #f8f9fa; color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #eaecf0; vertical-align: top; white-space: pre-wrap;"><div>* '''lock''' : /var/lock/b2p/topclient.lock}}</div></td></tr>
<tr><td colspan="2" class="diff-side-deleted"></td><td class="diff-marker" data-marker="+"></td><td style="color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #a3d3ff; vertical-align: top; white-space: pre-wrap;"><div><ins style="font-weight: bold; text-decoration: none;">En éditant le fichier <path>/root/scripts/monitoring/topclient/vars.php</path>, on peut voir le nom du fichier de '''lock''' utilisé: <path>/var/lock/b2p/topclient.lock</path>, ainsi que la définition de chaque client et autres paramètres.</ins></div></td></tr>
<tr><td colspan="2" class="diff-side-deleted"></td><td class="diff-marker" data-marker="+"></td><td style="color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #a3d3ff; vertical-align: top; white-space: pre-wrap;"><div><ins style="font-weight: bold; text-decoration: none;">* Pour chaque client, on définit dans le tableau '''CUSTOMER_LIST'''</ins></div></td></tr>
<tr><td colspan="2" class="diff-side-deleted"></td><td class="diff-marker" data-marker="+"></td><td style="color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #a3d3ff; vertical-align: top; white-space: pre-wrap;"><div><ins style="font-weight: bold; text-decoration: none;">** Les paramètres obligatoires</ins></div></td></tr>
<tr><td colspan="2" class="diff-side-deleted"></td><td class="diff-marker" data-marker="+"></td><td style="color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #a3d3ff; vertical-align: top; white-space: pre-wrap;"><div><ins style="font-weight: bold; text-decoration: none;">*** '''order''': Paramètre déprécié.</ins></div></td></tr>
<tr><td colspan="2" class="diff-side-deleted"></td><td class="diff-marker" data-marker="+"></td><td style="color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #a3d3ff; vertical-align: top; white-space: pre-wrap;"><div><ins style="font-weight: bold; text-decoration: none;">*** '''name''': Le nom du client correspondant à l'identifiant. Le préfixe (P) est automatiquement ajouté, de même que le suffixe (DED) si la requète est exécuter sur un serveur dédié.</ins></div></td></tr>
<tr><td colspan="2" class="diff-side-deleted"></td><td class="diff-marker" data-marker="+"></td><td style="color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #a3d3ff; vertical-align: top; white-space: pre-wrap;"><div><ins style="font-weight: bold; text-decoration: none;">*** '''ID''': L'identifiant unique</ins></div></td></tr>
<tr><td colspan="2" class="diff-side-deleted"></td><td class="diff-marker" data-marker="+"></td><td style="color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #a3d3ff; vertical-align: top; white-space: pre-wrap;"><div><ins style="font-weight: bold; text-decoration: none;">*** '''level''': Correspond à différentes méthodes d’interrogation des bases de données. Paramètre déprécié.</ins></div></td></tr>
<tr><td colspan="2" class="diff-side-deleted"></td><td class="diff-marker" data-marker="+"></td><td style="color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #a3d3ff; vertical-align: top; white-space: pre-wrap;"><div><ins style="font-weight: bold; text-decoration: none;">** Les paramètres facultatifs</ins></div></td></tr>
<tr><td colspan="2" class="diff-side-deleted"></td><td class="diff-marker" data-marker="+"></td><td style="color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #a3d3ff; vertical-align: top; white-space: pre-wrap;"><div><ins style="font-weight: bold; text-decoration: none;">*** '''dbhost''': Correspond à la cible définit dans le fichier <path>/home/common/Bdf/config/db.ini</path> pour les paramètres de la base de données.<br>Si celui-ci est absent ou vide, c'est ''MONITORING_LOG'' qui sera utilisé (c.a.d. la base B2P_LOG sur le serveur stats ).</ins></div></td></tr>
<tr><td colspan="2" class="diff-side-deleted"></td><td class="diff-marker" data-marker="+"></td><td style="color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #a3d3ff; vertical-align: top; white-space: pre-wrap;"><div><ins style="font-weight: bold; text-decoration: none;">*** '''timeperiods''': définit la la plage horaire pendant laquelle l'envoi d'email d'alerte est autorisé pour ce customer. Si ce champs est absent ou vide, c'est la période de temps par défaut qui est prise en compte. La syntaxe est la même que ''DEFAULT_TIMEPERIOD''.</ins></div></td></tr>
<tr><td colspan="2" class="diff-side-deleted"></td><td class="diff-marker" data-marker="+"></td><td style="color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #a3d3ff; vertical-align: top; white-space: pre-wrap;"><div><ins style="font-weight: bold; text-decoration: none;">* '''LOCK_FILE''': Le fichier de lock afin de prévenir plusieurs démarrage d'instance de ce même script.</ins></div></td></tr>
<tr><td colspan="2" class="diff-side-deleted"></td><td class="diff-marker" data-marker="+"></td><td style="color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #a3d3ff; vertical-align: top; white-space: pre-wrap;"><div><ins style="font-weight: bold; text-decoration: none;">* '''ALERT_RECEIVERS''': Définition de toutes les adresses email réceptrices des alertes.</ins></div></td></tr>
<tr><td colspan="2" class="diff-side-deleted"></td><td class="diff-marker" data-marker="+"></td><td style="color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #a3d3ff; vertical-align: top; white-space: pre-wrap;"><div><ins style="font-weight: bold; text-decoration: none;">* '''DEFAULT_TIMEPERIOD''': Définition de la plage horaire par défaut où l'envoi de mail d'alerte est autorisé. Le nombre correspond au nombre de secondes depuis minuit. Les plages horaires sont cumulatives ( OU et non pas ET ).</ins></div></td></tr>
<tr><td colspan="2" class="diff-side-deleted"></td><td class="diff-marker" data-marker="+"></td><td style="color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #a3d3ff; vertical-align: top; white-space: pre-wrap;"><div><ins style="font-weight: bold; text-decoration: none;">* '''ALERT_SUBJECT''': Sujet de l'email d'alerte</ins></div></td></tr>
<tr><td colspan="2" class="diff-side-deleted"></td><td class="diff-marker" data-marker="+"></td><td style="color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #a3d3ff; vertical-align: top; white-space: pre-wrap;"><div><ins style="font-weight: bold; text-decoration: none;">* '''ALERT_MESSAGE''': Corps du message d'alerte</ins></div></td></tr>
<tr><td colspan="2" class="diff-side-deleted"></td><td class="diff-marker" data-marker="+"></td><td style="color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #a3d3ff; vertical-align: top; white-space: pre-wrap;"><div><ins style="font-weight: bold; text-decoration: none;">* '''DEPOSIT_PERIOD''': Période de temps durant laquelle le nombre d'offre déposées est comptabilisé, en secondes.</ins></div></td></tr>
<tr><td colspan="2" class="diff-side-deleted"></td><td class="diff-marker" data-marker="+"></td><td style="color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #a3d3ff; vertical-align: top; white-space: pre-wrap;"><div><ins style="font-weight: bold; text-decoration: none;">* '''ALERT_PERIOD''': Période minimum entre deux alertes par email, en secondes.</ins></div></td></tr>
<tr><td colspan="2" class="diff-side-deleted"></td><td class="diff-marker" data-marker="+"></td><td style="color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #a3d3ff; vertical-align: top; white-space: pre-wrap;"><div><ins style="font-weight: bold; text-decoration: none;">* '''DEBUG''': les logs contiennent des traces de debug si ce paramètre est fixé à true.</ins></div></td></tr>
<tr><td colspan="2" class="diff-side-deleted"></td><td class="diff-marker" data-marker="+"></td><td style="color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #a3d3ff; vertical-align: top; white-space: pre-wrap;"><div><ins style="font-weight: bold; text-decoration: none;">* '''VERBOSE''': Les logs sont plus bavards si ce paramètre est fixé à true.</ins></div></td></tr>
<tr><td colspan="2" class="diff-side-deleted"></td><td class="diff-marker" data-marker="+"></td><td style="color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #a3d3ff; vertical-align: top; white-space: pre-wrap;"><div><ins style="font-weight: bold; text-decoration: none;"><syntaxhighlight lang="php"></ins></div></td></tr>
<tr><td colspan="2" class="diff-side-deleted"></td><td class="diff-marker" data-marker="+"></td><td style="color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #a3d3ff; vertical-align: top; white-space: pre-wrap;"><div><ins style="font-weight: bold; text-decoration: none;"><?php</ins></div></td></tr>
<tr><td colspan="2" class="diff-side-deleted"></td><td class="diff-marker" data-marker="+"></td><td style="color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #a3d3ff; vertical-align: top; white-space: pre-wrap;"><div><ins style="font-weight: bold; text-decoration: none;"> /*</ins></div></td></tr>
<tr><td colspan="2" class="diff-side-deleted"></td><td class="diff-marker" data-marker="+"></td><td style="color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #a3d3ff; vertical-align: top; white-space: pre-wrap;"><div><ins style="font-weight: bold; text-decoration: none;"> * dbhost: must be MONITORING_LOG for sending request on public platform</ins></div></td></tr>
<tr><td colspan="2" class="diff-side-deleted"></td><td class="diff-marker" data-marker="+"></td><td style="color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #a3d3ff; vertical-align: top; white-space: pre-wrap;"><div><ins style="font-weight: bold; text-decoration: none;"> */</ins></div></td></tr>
<tr><td colspan="2" class="diff-side-deleted"></td><td class="diff-marker" data-marker="+"></td><td style="color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #a3d3ff; vertical-align: top; white-space: pre-wrap;"><div><ins style="font-weight: bold; text-decoration: none;"> $CUSTOMER_LIST = array (</ins></div></td></tr>
<tr><td colspan="2" class="diff-side-deleted"></td><td class="diff-marker" data-marker="+"></td><td style="color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #a3d3ff; vertical-align: top; white-space: pre-wrap;"><div><ins style="font-weight: bold; text-decoration: none;"> array ( 'order'=>'1', 'name'=>'ALLOIN', 'ID'=>'400100', 'level'=>'2', 'dbhost'=>'MONITORING_ALLOIN' ),</ins></div></td></tr>
<tr><td colspan="2" class="diff-side-deleted"></td><td class="diff-marker" data-marker="+"></td><td style="color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #a3d3ff; vertical-align: top; white-space: pre-wrap;"><div><ins style="font-weight: bold; text-decoration: none;"> array ( 'order'=>'1', 'name'=>'BREGER', 'ID'=>'401780', 'level'=>'2', 'dbhost'=>'MONITORING_BREGER' ),</ins></div></td></tr>
<tr><td colspan="2" class="diff-side-deleted"></td><td class="diff-marker" data-marker="+"></td><td style="color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #a3d3ff; vertical-align: top; white-space: pre-wrap;"><div><ins style="font-weight: bold; text-decoration: none;"> array ( 'order'=>'1', 'name'=>'GEFCO', 'ID'=>'401307', 'level'=>'2', ),</ins></div></td></tr>
<tr><td colspan="2" class="diff-side-deleted"></td><td class="diff-marker" data-marker="+"></td><td style="color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #a3d3ff; vertical-align: top; white-space: pre-wrap;"><div><ins style="font-weight: bold; text-decoration: none;"> array ( 'order'=>'1', 'name'=>'GEODIS BM', 'ID'=>'401664', 'level'=>'2', 'dbhost'=>'MONITORING_GEODIS' ),</ins></div></td></tr>
<tr><td colspan="2" class="diff-side-deleted"></td><td class="diff-marker" data-marker="+"></td><td style="color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #a3d3ff; vertical-align: top; white-space: pre-wrap;"><div><ins style="font-weight: bold; text-decoration: none;"> array ( 'order'=>'1', 'name'=>'GEODIS CALBERSON', 'ID'=>'401663', 'level'=>'2', 'dbhost'=>'MONITORING_GEODIS' ),</ins></div></td></tr>
<tr><td colspan="2" class="diff-side-deleted"></td><td class="diff-marker" data-marker="+"></td><td style="color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #a3d3ff; vertical-align: top; white-space: pre-wrap;"><div><ins style="font-weight: bold; text-decoration: none;"> array ( 'order'=>'1', 'name'=>'HEPPNER', 'ID'=>'401263', 'level'=>'2', ),</ins></div></td></tr>
<tr><td colspan="2" class="diff-side-deleted"></td><td class="diff-marker" data-marker="+"></td><td style="color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #a3d3ff; vertical-align: top; white-space: pre-wrap;"><div><ins style="font-weight: bold; text-decoration: none;"> array ( 'order'=>'1', 'name'=>'JUNG', 'ID'=>'407455', 'level'=>'2', ),</ins></div></td></tr>
<tr><td colspan="2" class="diff-side-deleted"></td><td class="diff-marker" data-marker="+"></td><td style="color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #a3d3ff; vertical-align: top; white-space: pre-wrap;"><div><ins style="font-weight: bold; text-decoration: none;"> array ( 'order'=>'1', 'name'=>'LEROY', 'ID'=>'406067', 'level'=>'2', 'dbhost'=>'MONITORING_LEROY' ),</ins></div></td></tr>
<tr><td colspan="2" class="diff-side-deleted"></td><td class="diff-marker" data-marker="+"></td><td style="color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #a3d3ff; vertical-align: top; white-space: pre-wrap;"><div><ins style="font-weight: bold; text-decoration: none;"> array ( 'order'=>'1', 'name'=>'MAUFFREY', 'ID'=>'401274', 'level'=>'2', ),</ins></div></td></tr>
<tr><td colspan="2" class="diff-side-deleted"></td><td class="diff-marker" data-marker="+"></td><td style="color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #a3d3ff; vertical-align: top; white-space: pre-wrap;"><div><ins style="font-weight: bold; text-decoration: none;"> array ( 'order'=>'1', 'name'=>'MTA', 'ID'=>'406615', 'level'=>'2', ),</ins></div></td></tr>
<tr><td colspan="2" class="diff-side-deleted"></td><td class="diff-marker" data-marker="+"></td><td style="color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #a3d3ff; vertical-align: top; white-space: pre-wrap;"><div><ins style="font-weight: bold; text-decoration: none;"> array ( 'order'=>'1', 'name'=>'SCHENCKER JOYAU', 'ID'=>'400101', 'level'=>'2', ),</ins></div></td></tr>
<tr><td colspan="2" class="diff-side-deleted"></td><td class="diff-marker" data-marker="+"></td><td style="color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #a3d3ff; vertical-align: top; white-space: pre-wrap;"><div><ins style="font-weight: bold; text-decoration: none;"> array ( 'order'=>'1', 'name'=>'STEF', 'ID'=>'403522', 'level'=>'2', 'dbhost'=>'MONITORING_STEF' ),</ins></div></td></tr>
<tr><td colspan="2" class="diff-side-deleted"></td><td class="diff-marker" data-marker="+"></td><td style="color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #a3d3ff; vertical-align: top; white-space: pre-wrap;"><div><ins style="font-weight: bold; text-decoration: none;"> array ( 'order'=>'1', 'name'=>'TRANSALLIANCE', 'ID'=>'404010', 'level'=>'2', ),</ins></div></td></tr>
<tr><td colspan="2" class="diff-side-deleted"></td><td class="diff-marker" data-marker="+"></td><td style="color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #a3d3ff; vertical-align: top; white-space: pre-wrap;"><div><ins style="font-weight: bold; text-decoration: none;"> array ( 'order'=>'1', 'name'=>'ZIEGLER', 'ID'=>'410838', 'level'=>'2', 'dbhost'=>'MONITORING_ZIEGLER' ),</ins></div></td></tr>
<tr><td colspan="2" class="diff-side-deleted"></td><td class="diff-marker" data-marker="+"></td><td style="color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #a3d3ff; vertical-align: top; white-space: pre-wrap;"><div><ins style="font-weight: bold; text-decoration: none;"> );</ins></div></td></tr>
<tr><td class="diff-marker"></td><td style="background-color: #f8f9fa; color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #eaecf0; vertical-align: top; white-space: pre-wrap;"><br></td><td class="diff-marker"></td><td style="background-color: #f8f9fa; color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #eaecf0; vertical-align: top; white-space: pre-wrap;"><br></td></tr>
<tr><td class="diff-marker" data-marker="−"></td><td style="color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #ffe49c; vertical-align: top; white-space: pre-wrap;"><div><del style="font-weight: bold; text-decoration: none;">En éditant le fichier <path></del>/<del style="font-weight: bold; text-decoration: none;">root</del>/<del style="font-weight: bold; text-decoration: none;">scripts</del>/<del style="font-weight: bold; text-decoration: none;">monitoring</del>/topclient/<del style="font-weight: bold; text-decoration: none;">vars.php<</del>/<del style="font-weight: bold; text-decoration: none;">path</del>>, <del style="font-weight: bold; text-decoration: none;">on peut voir le nom du fichier de lock utilisé: <path</del>>/<del style="font-weight: bold; text-decoration: none;">var</del>/<del style="font-weight: bold; text-decoration: none;">lock</del>/<del style="font-weight: bold; text-decoration: none;">b2p</del>/<del style="font-weight: bold; text-decoration: none;">topclient</del>.<del style="font-weight: bold; text-decoration: none;">lock</del></<del style="font-weight: bold; text-decoration: none;">path</del>></div></td><td class="diff-marker" data-marker="+"></td><td style="color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #a3d3ff; vertical-align: top; white-space: pre-wrap;"><div><ins style="font-weight: bold; text-decoration: none;"> $LOCK_FILE = "</ins>/<ins style="font-weight: bold; text-decoration: none;">var</ins>/<ins style="font-weight: bold; text-decoration: none;">lock</ins>/<ins style="font-weight: bold; text-decoration: none;">b2p</ins>/topclient<ins style="font-weight: bold; text-decoration: none;">.lock";</ins></div></td></tr>
<tr><td colspan="2" class="diff-side-deleted"></td><td class="diff-marker" data-marker="+"></td><td style="color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #a3d3ff; vertical-align: top; white-space: pre-wrap;"><div> </div></td></tr>
<tr><td colspan="2" class="diff-side-deleted"></td><td class="diff-marker" data-marker="+"></td><td style="color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #a3d3ff; vertical-align: top; white-space: pre-wrap;"><div><ins style="font-weight: bold; text-decoration: none;"> $DEBUG = false;</ins></div></td></tr>
<tr><td colspan="2" class="diff-side-deleted"></td><td class="diff-marker" data-marker="+"></td><td style="color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #a3d3ff; vertical-align: top; white-space: pre-wrap;"><div><ins style="font-weight: bold; text-decoration: none;"> $VERBOSE = true;</ins></div></td></tr>
<tr><td colspan="2" class="diff-side-deleted"></td><td class="diff-marker" data-marker="+"></td><td style="color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #a3d3ff; vertical-align: top; white-space: pre-wrap;"><div> </div></td></tr>
<tr><td colspan="2" class="diff-side-deleted"></td><td class="diff-marker" data-marker="+"></td><td style="color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #a3d3ff; vertical-align: top; white-space: pre-wrap;"><div><ins style="font-weight: bold; text-decoration: none;"> $ALERT_RECEIVERS = array(</ins></div></td></tr>
<tr><td colspan="2" class="diff-side-deleted"></td><td class="diff-marker" data-marker="+"></td><td style="color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #a3d3ff; vertical-align: top; white-space: pre-wrap;"><div><ins style="font-weight: bold; text-decoration: none;"> 'dfabert@b2pweb.com',</ins></div></td></tr>
<tr><td colspan="2" class="diff-side-deleted"></td><td class="diff-marker" data-marker="+"></td><td style="color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #a3d3ff; vertical-align: top; white-space: pre-wrap;"><div><ins style="font-weight: bold; text-decoration: none;"> );</ins></div></td></tr>
<tr><td colspan="2" class="diff-side-deleted"></td><td class="diff-marker" data-marker="+"></td><td style="color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #a3d3ff; vertical-align: top; white-space: pre-wrap;"><div> </div></td></tr>
<tr><td colspan="2" class="diff-side-deleted"></td><td class="diff-marker" data-marker="+"></td><td style="color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #a3d3ff; vertical-align: top; white-space: pre-wrap;"><div><ins style="font-weight: bold; text-decoration: none;"> /* Number of seconds elapsed after midnight */</ins></div></td></tr>
<tr><td colspan="2" class="diff-side-deleted"></td><td class="diff-marker" data-marker="+"></td><td style="color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #a3d3ff; vertical-align: top; white-space: pre-wrap;"><div><ins style="font-weight: bold; text-decoration: none;"> $DEFAULT_TIMEPERIOD = array(</ins></div></td></tr>
<tr><td colspan="2" class="diff-side-deleted"></td><td class="diff-marker" data-marker="+"></td><td style="color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #a3d3ff; vertical-align: top; white-space: pre-wrap;"><div><ins style="font-weight: bold; text-decoration: none;"> array( 'begin' => 28800, 'end' => 43200 ), </ins>// <ins style="font-weight: bold; text-decoration: none;">08h00 - 12h00</ins></div></td></tr>
<tr><td colspan="2" class="diff-side-deleted"></td><td class="diff-marker" data-marker="+"></td><td style="color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #a3d3ff; vertical-align: top; white-space: pre-wrap;"><div><ins style="font-weight: bold; text-decoration: none;"> array( 'begin' =</ins>> <ins style="font-weight: bold; text-decoration: none;">50400</ins>, <ins style="font-weight: bold; text-decoration: none;">'end' =</ins>> <ins style="font-weight: bold; text-decoration: none;">64800 ), // 14h00 - 18h00</ins></div></td></tr>
<tr><td colspan="2" class="diff-side-deleted"></td><td class="diff-marker" data-marker="+"></td><td style="color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #a3d3ff; vertical-align: top; white-space: pre-wrap;"><div><ins style="font-weight: bold; text-decoration: none;"> );</ins></div></td></tr>
<tr><td colspan="2" class="diff-side-deleted"></td><td class="diff-marker" data-marker="+"></td><td style="color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #a3d3ff; vertical-align: top; white-space: pre-wrap;"><div> </div></td></tr>
<tr><td colspan="2" class="diff-side-deleted"></td><td class="diff-marker" data-marker="+"></td><td style="color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #a3d3ff; vertical-align: top; white-space: pre-wrap;"><div><ins style="font-weight: bold; text-decoration: none;"> $ALERT_SUBJECT = 'TopClient Passerelle alert - Customer %1';</ins></div></td></tr>
<tr><td colspan="2" class="diff-side-deleted"></td><td class="diff-marker" data-marker="+"></td><td style="color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #a3d3ff; vertical-align: top; white-space: pre-wrap;"><div><ins style="font-weight: bold; text-decoration: none;"> $ALERT_MESSAGE = 'Deposit from customer %1 not found in last 30 minutes !!!';</ins></div></td></tr>
<tr><td colspan="2" class="diff-side-deleted"></td><td class="diff-marker" data-marker="+"></td><td style="color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #a3d3ff; vertical-align: top; white-space: pre-wrap;"><div> </div></td></tr>
<tr><td colspan="2" class="diff-side-deleted"></td><td class="diff-marker" data-marker="+"></td><td style="color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #a3d3ff; vertical-align: top; white-space: pre-wrap;"><div><ins style="font-weight: bold; text-decoration: none;"> </ins>// <ins style="font-weight: bold; text-decoration: none;">Period about last deposit in seconds. 1800 = 30 minutes</ins></div></td></tr>
<tr><td colspan="2" class="diff-side-deleted"></td><td class="diff-marker" data-marker="+"></td><td style="color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #a3d3ff; vertical-align: top; white-space: pre-wrap;"><div><ins style="font-weight: bold; text-decoration: none;"> $DEPOSIT_PERIOD = 1800;</ins></div></td></tr>
<tr><td colspan="2" class="diff-side-deleted"></td><td class="diff-marker" data-marker="+"></td><td style="color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #a3d3ff; vertical-align: top; white-space: pre-wrap;"><div> </div></td></tr>
<tr><td colspan="2" class="diff-side-deleted"></td><td class="diff-marker" data-marker="+"></td><td style="color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #a3d3ff; vertical-align: top; white-space: pre-wrap;"><div><ins style="font-weight: bold; text-decoration: none;"> </ins>// <ins style="font-weight: bold; text-decoration: none;">Period about alert in seconds</ins>. <ins style="font-weight: bold; text-decoration: none;">3600 = 1hour</ins></div></td></tr>
<tr><td colspan="2" class="diff-side-deleted"></td><td class="diff-marker" data-marker="+"></td><td style="color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #a3d3ff; vertical-align: top; white-space: pre-wrap;"><div><ins style="font-weight: bold; text-decoration: none;"> $ALERT_PERIOD = 3600;</ins></div></td></tr>
<tr><td colspan="2" class="diff-side-deleted"></td><td class="diff-marker" data-marker="+"></td><td style="color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #a3d3ff; vertical-align: top; white-space: pre-wrap;"><div><ins style="font-weight: bold; text-decoration: none;">?></ins></div></td></tr>
<tr><td colspan="2" class="diff-side-deleted"></td><td class="diff-marker" data-marker="+"></td><td style="color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #a3d3ff; vertical-align: top; white-space: pre-wrap;"><div></<ins style="font-weight: bold; text-decoration: none;">syntaxhighlight</ins>></div></td></tr>
<tr><td class="diff-marker"></td><td style="background-color: #f8f9fa; color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #eaecf0; vertical-align: top; white-space: pre-wrap;"><br></td><td class="diff-marker"></td><td style="background-color: #f8f9fa; color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #eaecf0; vertical-align: top; white-space: pre-wrap;"><br></td></tr>
<tr><td class="diff-marker"></td><td style="background-color: #f8f9fa; color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #eaecf0; vertical-align: top; white-space: pre-wrap;"><div>Le fichier de log est spécifié dans le crontab : <path>/var/log/monitoring-engine-topclient.log</path></div></td><td class="diff-marker"></td><td style="background-color: #f8f9fa; color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #eaecf0; vertical-align: top; white-space: pre-wrap;"><div>Le fichier de log est spécifié dans le crontab : <path>/var/log/monitoring-engine-topclient.log</path></div></td></tr>
</table>
Didier
https://wikiold.home.tartarefr.eu/index.php?title=B2PWeb/Services/Monitoring/TopClient&diff=1354&oldid=prev
Admin : a déplacé B2PWeb/Process/TopClient vers B2PWeb/Services/Monitoring/TopClient
2013-01-10T07:39:33Z
<p>a déplacé <a href="/index.php/B2PWeb/Process/TopClient" class="mw-redirect" title="B2PWeb/Process/TopClient">B2PWeb/Process/TopClient</a> vers <a href="/index.php/B2PWeb/Services/Monitoring/TopClient" title="B2PWeb/Services/Monitoring/TopClient">B2PWeb/Services/Monitoring/TopClient</a></p>
<table style="background-color: #fff; color: #202122;" data-mw="interface">
<tr class="diff-title" lang="fr">
<td colspan="1" style="background-color: #fff; color: #202122; text-align: center;">← Version précédente</td>
<td colspan="1" style="background-color: #fff; color: #202122; text-align: center;">Version du 10 janvier 2013 à 07:39</td>
</tr><tr><td colspan="2" class="diff-notice" lang="fr"><div class="mw-diff-empty">(Aucune différence)</div>
</td></tr></table>
Admin
https://wikiold.home.tartarefr.eu/index.php?title=B2PWeb/Services/Monitoring/TopClient&diff=1341&oldid=prev
Didier : Page créée avec « == Installation == 800px === Engine === Le moteur est situé sur '''sql2-cogent''' dans le répertoire <path>/root/scripts/monitoring/topclient</p... »
2013-01-09T07:47:14Z
<p>Page créée avec « == Installation == <a href="/index.php/Fichier:TopClient.png" title="Fichier:TopClient.png">800px</a> === Engine === Le moteur est situé sur '''sql2-cogent''' dans le répertoire <path>/root/scripts/monitoring/topclient</p... »</p>
<p><b>Nouvelle page</b></p><div>== Installation ==<br />
[[Fichier:TopClient.png|800px]]<br />
<br />
=== Engine ===<br />
<br />
Le moteur est situé sur '''sql2-cogent''' dans le répertoire <path>/root/scripts/monitoring/topclient</path>. Il est lancé par un cron.<br />
# crontab -l | grep -i 'top\s*client'<br />
<br />
# Monitoring - Top client engine<br />
*/15 8-20 * * 1-5 /root/scripts/monitoring/topclient/engine-topclient.php 1>>/var/log/monitoring-engine-topclient.log 2>&1<br />
<br />
{{Admon/important|Fichiers utilisés|<br />
* '''log''' : /var/log/monitoring-engine-topclient.log<br />
* '''lock''' : /var/lock/b2p/topclient.lock}}<br />
<br />
En éditant le fichier <path>/root/scripts/monitoring/topclient/vars.php</path>, on peut voir le nom du fichier de lock utilisé: <path>/var/lock/b2p/topclient.lock</path><br />
<br />
Le fichier de log est spécifié dans le crontab : <path>/var/log/monitoring-engine-topclient.log</path><br />
<br />
La base de données '''monitoring''' est placé sur '''sql2-cogent'''.<br />
<syntaxhighlight lang="sql"><br />
DROP TABLE IF EXISTS `topclient`;<br />
<br />
CREATE TABLE `topclient` (<br />
`client_id` int(11) NOT NULL,<br />
`client_name` varchar(50) NOT NULL,<br />
`cur_hour_act` int(11) DEFAULT NULL,<br />
`cur_day_act` int(11) DEFAULT NULL,<br />
`last_week_day_act` int(11) DEFAULT NULL,<br />
`last_check` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,<br />
PRIMARY KEY (`client_id`),<br />
KEY `last_check` (`last_check`)<br />
) ENGINE=InnoDB DEFAULT CHARSET=utf8;<br />
</syntaxhighlight><br />
<br />
=== Webservice ===<br />
<br />
Le moteur est situé sur tous les WSR dans le répertoire <path>/home/b2pweb.com/services.b2pweb.com/monitoring</path><br />
<pre><br />
monitoring<br />
|-- class<br />
| |-- bdd.class.php<br />
| |-- fault.class.php<br />
| `-- monitoring.class.php<br />
|-- conf<br />
| `-- config.conf.php<br />
|-- include<br />
| `-- fonctions.php<br />
|-- index.php<br />
`-- wsdl<br />
`-- monitoring.wsdl<br />
</pre><br />
<br />
=== Client ===<br />
<br />
Le client est situé sur les virtual machine monitoring ( ns1 et ns2 ) du LAN. Il est installé via un paquet RPM dans le répertoire <path>/usr/share/webservice-monitoring/client/</path>.<br />
<br />
De plus le fichier de configuration pour Apache est <path>/etc/httpd/conf.d/webservice-monitoring-client.conf</path><br />
<br />
== Fonctionnement ==<br />
<br />
* La partie '''Engine''' : Sur '''sql2-cogent''', un script enrichit la base de données, moteur qui est lancé via un cron tous les quart d'heure.<br />
:# Requêtes mysql sur sql2-cogent<br />
:# Mise en base des résultats synthétisés<br />
* La partie '''serveur''' du topclient est installé sur tous les WSR et interroge la base '''monitoring'''<br />
* La partie '''cliente''' fait une requête HTTP sur le webservice http://services.b2pweb.com/monitoring des WSR.<br />
<br />
== Interface ==<br />
<br />
La date de dernière mise à jour apparait au survol de la souris sur le champs '''ClientID'''.<br />
<br />
* Lorsque le champs '''ClientID''' est '''{{color|green|vert}}''', les informations sont à jour.<br />
* Lorsque le champs '''ClientID''' est '''{{color|orange|orange}}''', les informations commence à être obsolètes ( entre 15 et 20 minutes ).<br />
* Lorsque le champs '''ClientID''' est '''{{color|red|rouge}}''', les informations sont obsolètes ( supérieures à 20 minutes ).<br />
<br />
<br />
[[Fichier:TopClientInterface.png]]<br />
<br />
== F.A.Q. ==<br />
<br />
=== Le top client ne se met plus à jour ! ===<br />
<br />
{{Admon/important|Vérifier le fichier de log|La dernière ligne peut indiquer le problème}}<br />
<br />
* Si la dernière ligne du fichier de log contient:<pre>Previous process is still running!</pre><br />
:# C'est qu'une exécution antérieure ne s'est pas bien terminée et que le fichier de lock est encore présent. Il suffit juste de supprimer ce fichier<pre>rm -f /var/lock/b2p/topclient.lock</pre><br />
:# L'engine a planté suite à une erreur <pre>Fatal error: Uncaught exception 'Bdf_Db_Exception' with message 'Erreur d'execution' in /home/common/Bdf/Bdf/Db/Adapter/MySQLi.class.php:99</pre>Il faut augmenter les paramètres '''wait_timeout''' et '''interactive_wait_timeout''' dans le fichier <path>/etc/my.cnf</path> et relancer MySQL.</div>
Didier