summaryrefslogtreecommitdiff
path: root/nodeStatus.php
blob: 5f8b476e34109c23a07dc37721048a7608fd72f0 (plain)
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100
101
<?php

/* vim: set expandtab tabstop=4 shiftwidth=4 softtabstop=4: */

/**
 * Node status of pgpool
 *
 * PHP versions 4 and 5
 *
 * LICENSE: Permission to use, copy, modify, and distribute this software and
 * its documentation for any purpose and without fee is hereby
 * granted, provided that the above copyright notice appear in all
 * copies and that both that copyright notice and this permission
 * notice appear in supporting documentation, and that the name of the
 * author not be used in advertising or publicity pertaining to
 * distribution of the software without specific, written prior
 * permission. The author makes no representations about the
 * suitability of this software for any purpose.  It is provided "as
 * is" without express or implied warranty.
 *
 * @author     Ryuma Ando <ando@ecomas.co.jp>
 * @copyright  2003-2007 PgPool Global Development Group
 * @version    SVN: $Id$
 */

require_once('common.php');
require_once('command.php');
$tpl->assign('help', basename( __FILE__, '.php'));

$MAX_VALUE = 2147483647;

if(!isset($_SESSION[SESSION_LOGIN_USER])) {
    exit();
}

$ret = execPcp('PCP_NODE_COUNT');
if(!array_key_exists('SUCCESS', $ret)) {
    $errorCode = 'e1002';
    $tpl->assign('errorCode', $errorCode);
    $tpl->display('innerError.tpl');
    exit();
} else {
    $nodeCount = $ret['SUCCESS'];
}

$tpl->assign('nodeCount', $nodeCount);

$isParallelMode = isParallelMode();
$isReplicationMode = isReplicationMode();
$isMasterSlaveMode = isMasterSlaveMode();

$nodeInfo = array();

for($i=0; $i<$nodeCount; $i++) {
    $ret = execPcp('PCP_NODE_INFO', $i);
    if(!array_key_exists('SUCCESS', $ret)) {
        $errorCode = 'e1003';
        $tpl->assign('errorCode', $errorCode);
        $tpl->display('innerError.tpl');
        exit();
    } else {
        $ret = $ret['SUCCESS'];
    }
    $nodeInfo[$i] = split(" ", $ret);
    $nodeInfo[$i][3] =  sprintf('%.3f', $nodeInfo[$i][3] / $MAX_VALUE);
    if( $isParallelMode ) {
        array_push($nodeInfo[$i], 'none');
    } else {
        switch($nodeInfo[$i][2]) {
            case 1:
            case 2:
                if($isReplicationMode || $isMasterSlaveMode) {
                    array_push($nodeInfo[$i], 'disconnect');
                } else {
                    array_push($nodeInfo[$i], 'none');
                }
               break; 
            case 3:
               if(NodeActive($i)) {
                if($isReplicationMode || $isMasterSlaveMode) {
                    array_push($nodeInfo[$i], 'return');
                } else {
                    array_push($nodeInfo[$i], 'none');
                }
               break; 
               }
               else {
                  array_push($nodeInfo[$i], 'none');
               }
               break; 
        }
    }
}

$tpl->assign('refreshTime', _PGPOOL2_STATUS_REFRESH_TIME*1000);
$tpl->assign('nodeInfo', $nodeInfo);
$tpl->assign('parallelMode', $isParallelMode);
$tpl->assign('msgStopPgpool', $message['msgStopPgpool']);
$tpl->display('nodeStatus.tpl');

?>