Changeset 35 for trunk/cluster_status.php

Timestamp:

Apr 8, 2018, 4:41:57 PM (7 years ago)

Author:

gegorbet

Message:

mods mostly for use of mysqli

File:

• trunk/cluster_status.php (modified) (9 diffs)

trunk/cluster_status.php

@@ -22 +22 @@
 }
 
-exit();
+//exit();
+exit(0);
 
 // Get the cluster status
@@ -115 +116 @@
 //echo  " $cluster $queued, $status, $running\n";
 
-   $gfac_link = mysql_connect( $dbhost, $guser, $gpasswd );
-   $result = mysql_select_db( $gDB, $gfac_link );
-
-   if ( ! $result )
+   $gfac_link = mysqli_connect( $dbhost, $guser, $gpasswd, $gDB );
+
+   if ( ! $gfac_link )
    {
       write_log( "$self: Could not connect to DB $gDB" );
@@ -126 +126 @@
       
    $query = "SELECT * FROM cluster_status WHERE cluster='$cluster'";
-   $result = mysql_query( $query, $gfac_link );
+   $result = mysqli_query( $gfac_link, $query );
 
    if ( ! $result )
    {
-      write_log( "$self: Query failed $query - " .  mysql_error( $gfac_link ) );
-      echo "$self: Query failed $query - " .  mysql_error( $gfac_link ) . "\n";
+      write_log( "$self: Query failed $query - " .  mysqli_error( $gfac_link ) );
+      echo "$self: Query failed $query - " .  mysqli_error( $gfac_link ) . "\n";
       exit();
    }
 
-   $rows = mysql_num_rows( $result );
+   $rows = mysqli_num_rows( $result );
 
    if ( $rows == 0 )  // INSERT
@@ -154 +154 @@
    }
 
-   $result = mysql_query( $query, $gfac_link );
+   $result = mysqli_query( $gfac_link, $query );
 
    if ( ! $result )
    {
-      write_log( "$self: Query failed $query - " .  mysql_error( $gfac_link ) );
-      echo "$self: Query failed $query - " .  mysql_error( $gfac_link ) . "\n";
+      write_log( "$self: Query failed $query - " .  mysqli_error( $gfac_link ) );
+      echo "$self: Query failed $query - " .  mysqli_error( $gfac_link ) . "\n";
    }
 }
@@ -182 +182 @@
    else
    {
-      $clusters = array( "alamo", "lonestar5", "stampede", "comet",
-                         "stampede2-b", "jetstream", "jureca", "jacinto-b" );
+//      $clusters = array( "alamo", "lonestar5", "comet",
+//                         "stampede2", "jetstream", "jureca", "jacinto" );
+      $clusters = array( "alamo", "lonestar5", "comet",
+                         "stampede2", "jetstream" );
    }
 
@@ -238 +240 @@
             break;
          }
-         case 'stampede':
-         {
-            $host   = "us3@stampede.tacc.utexas.edu";
-            $qstat  = `ssh $host '/usr/local/bin/showq 2>&1|grep "Total Jobs"'`;
+         case 'stampede2':
+         {
+            $host   = "us3@stampede2.tacc.utexas.edu";
+            $qstat  = `ssh $host '/usr/local/bin/showq 2>/dev/null|grep "Total Jobs"'`;
             $sparts = preg_split( '/\s+/', $qstat );
             $tot    = $sparts[ 2 ];
@@ -251 +253 @@
             break;
          }
-         case 'stampede2':
-         {
-            $host   = "us3@stampede2.tacc.utexas.edu";
-            $qstat  = `ssh $host '/usr/local/bin/showq 2>&1|grep "Total Jobs"'`;
-            $sparts = preg_split( '/\s+/', $qstat );
-            $tot    = $sparts[ 2 ];
-            $run    = $sparts[ 5 ];
-            $que    = $sparts[ 8 ];
-            $sta    = "up";
-            if ( $tot == ''  ||  $tot == '0' )
-               $sta    = "down";
-            break;
-         }
          case 'lonestar5':
          {
             $host   = "us3@ls5.tacc.utexas.edu";
-            $qstat  = `ssh $host '/usr/local/bin/showq 2>&1|grep "Total Jobs"'`;
+            $qstat  = `ssh $host '/usr/local/bin/showq 2>/dev/null|grep "Total Jobs"'`;
             $sparts = preg_split( '/\s+/', $qstat );
             $tot    = $sparts[ 2 ];
@@ -280 +269 @@
             {
                $run    = $sparts[ 5 ];
-//               $que    = $sparts[ 8 ];
-               $que    = $sparts[ 11 ];
+               $que    = $sparts[ 8 ];
+//               $que    = $sparts[ 11 ];
             }
             break;
@@ -288 +277 @@
          {
             $host   = "us3@comet.sdsc.edu";
-            $qstat  = `ssh $host '/usr/bin/sinfo -s -p compute -o "%a %F" |tail -1'`;
-            $sparts = preg_split( '/\s+/', $qstat );
-            $sta    = $sparts[ 0 ];
-            $knts   = $sparts[ 1 ];
-            $sparts = preg_split( '/\//', $knts );
-            $run    = $sparts[ 0 ];
-            $que    = $sparts[ 1 ];
-            if ( $sta == "" )
-               $sta    = "down";
-            break;
-         }
-         case 'gordon':
-         {
-            $host   = "us3@gordon.sdsc.edu";
-            $qstat  = `ssh $host '/opt/torque/bin/qstat -B 2>&1|tail -1'`;
-            $sparts = preg_split( '/\s+/', $qstat );
-            $que    = $sparts[ 3 ];
-            $run    = $sparts[ 4 ];
-            $sta    = $sparts[ 10 ];
-            if ( $sta == "Active" )
-               $sta    = "up";
+            //$qstat  = `ssh $host '/usr/bin/sinfo -s -p compute -o "%a %F" |tail -1'`;
+            $qstat  = `ssh $host '/home/us3/scripts/cstat 2>&1'`;
+            $sparts = preg_split( '/\s+/', $qstat );
+            $tot    = $sparts[ 1 ];
+            $run    = '0';
+            $que    = '0';
+            $sta    = "up";
+            if ( $tot == ''  ||  $tot == '0' )
+            {
+               $sta    = "down";
+            }
             else
-               $sta    = "down";
+            {
+               $run    = $sparts[ 3 ];
+               $que    = $sparts[ 5 ];
+            }
             break;
          }