Skip site navigation (1) Skip section navigation (2)

Trouble with HTTP authentication and PostgreSQL validation

From: "Seader, Cameron" <CSeader(at)idahopower(dot)com>
To: pgsql-php(at)postgresql(dot)org
Subject: Trouble with HTTP authentication and PostgreSQL validation
Date: 2003-09-20 17:32:24
Message-ID: 71B8A8BEC516CF46835CA629156CF21163F5AB@bedford.idacorp.local (view raw or flat)
Thread:
Lists: pgsql-php
hi,
I am having trouble with the below attached script and getting it to validate the $SERIALNUMBER session variable received from a device. I have a database with a table that has the serialnumber information now i need to validate it with the session variable received so that i can continue and not get an HTTP 401 error every time.
can someone please help me out.
Thanks much appreciated.

Here is the Script:

<?php  

  
ob_start();    // cache header/body information, send nothing to the client yet.
  				// we actually keep cacheing until the end of the script, if you have a large amount of data, 
  				// this could potentially make your server run out of memory.  Use ob_end_flush() 
  				// to flush the output cache and send the headers, however "ReportFailure()"
  				// won't work after ob_end_flush()  				
   
/* -------------------------------------------------------------------------------------------------------------------*/
/* reporting function be used to report and terminate.
*/
function ReportFailure($szReason, $RA, $SERIALNUMBER, $MBIP, $PORT, $MB)
{   Header("WWW-Authenticate: Basic realm=\"UploadRealm\"");			// realm name is actually ignored by the AcquiSuite.
    Header("HTTP/1.0 406 Not Acceptable");
    $szNotes = sprintf("Rejected logfile upload from %s  Serial %s, modbus ip %s:%s, modbus device %s.", $RA, $SERIALNUMBER, $MBIP, $PORT, $MB);
    printf("FAILURE: $szReason\n");    // report failure to client.
    printf("NOTES:   $szNotes\n");
    ob_end_flush(); // send cached stuff, and stop caching. we've already kicked out the last header line.
    
    syslog(LOG_ERR, "$PHP_SELF: $szNotes   Reason: $szReason \n");
    exit;    
}
/* -------------------------------------------------------------------------------------------------------------------*/
/* reporting function be used to report and terminate.
*/
function ReportAuthorizationFailure($szReason, $RA, $SERIALNUMBER)
{   Header("WWW-Authenticate: Basic realm=\"UploadRealm\"");			// realm name is actually ignored by the AcquiSuite.
    Header("HTTP/1.0 401 Unauthorized");
    $szNotes = sprintf("Rejected logfile upload from %s  Serial %s.", $RA, $SERIALNUMBER);
    printf("FAILURE: $szReason\n");    // report failure to client.
    printf("NOTES:   $szNotes\n");
    ob_end_flush(); // send cached stuff, and stop caching. we've already kicked out the last header line.
    
    syslog(LOG_ERR, "$PHP_SELF: $szNotes   Reason: $szReason \n");
    exit;    
}
/* -------------------------------------------------------------------------------------------------------------------*/
/*  calculate an MD5 checksum for the file that was uploaded.  This process uses the external 
    application "busybox" which provides a command line method to obtain the MD5 checksum 
    of a file.  For more information on busybox, and to obtain the source code, visit
    the website  http://busybox.lineo.com
    
    The checksum form variable is calculated from the log file after the file has been gziped. 
*/
function GetFileChecksum($szFilename)
{
  $szChecksum = "[error]";	// provide some default value for this incase the following fails.
  if (file_exists($szFilename))
  {   $szCommand = sprintf("/bin/busybox md5sum -b %s", $szFilename);		// busybox software provides command line MD5 checksums.
	  $rfp = popen($szCommand, r);										// execute busybox
	  if ($rfp)														   // now read the result, crop checksum from the remainder of the output.
	  {   $szBuffer = fgets($rfp, 64);
	      list($szChecksum, $junk) = split(" ", $szBuffer, 2); //truncate after MD5 checksum.  Space follows it prior to file name.
	      pclose($rfp);
	  } // end if rfp not null.
	  else
	  {   printf("/bin/busybox md5sum not found or will not execute.  Checksum can not be calculated.");
	      syslog(LOG_ERR, "$PHP_SELF:  /bin/busybox md5sum not found or will not execute.  Checksum can not be calculated.");
	  }
  }
  return $szChecksum;
}
/* -------------------------------------------------------------------------------------------------------------------*/
/* -------------------------------------------------------------------------------------------------------------------*/
/* Function to  process the data file contents.

	This section processes the contents of the uploaded log file.  We open the logfile using gzopen()
	to uncompress the file while we read the contents.  For each line of the file, we create an sql
	statement that could be used to put the data into a database. 

*/
function ProcessLogFileUpload($REMOTE_ADDR, $SERIALNUMBER, $MODBUSIP, $MODBUSPORT, $MODBUSDEVICE, $LOGFILE, $MODBUSDEVICENAME, $MODBUSDEVICETYPE, $MODBUSDEVICETYPENUMBER, $MODBUSDEVICECLASS)
{
  // check here to verify the modbus device name, type, and class make sense 
	
			
  	$query_devices="SELECT * FROM tbl_devices";
	$result = pg_exec($conn,$query_devices);
	if (!$result) {
	  echo "SQL order problem.\n";
	  exit;
	}

	// locate the correct table name to store the data in the sql table
	  
  $nSuccessCount = 0;		// set counters to zero.
  $nDuplicateCount = 0;
  $nRejectCount = 0;  
  
  $fd = gzopen($LOGFILE, "r");
  if (! $fd)
  {    ReportFailure("Can't open logfile. gzopen($LOGFILE) failed.", $REMOTE_ADDR, $SERIALNUMBER, $MODBUSIP, $MODBUSPORT, $MODBUSDEVICE);
       exit;
  }
  else
  {    while(!gzeof($fd))
       {    $szBuffer = gzgets($fd, 512);
            if (strlen($szBuffer) > 15)	// 15 is kinda arbitrary, use enough space for date, err and alarms. 15 characters should be fine.
            {    // You must check for bad chars here, such as semicolon, depending on your flavor of SQL.  
            	 // All data in the log file should be numeric, and may include symbols: minus, comma, space, or 'NULL' if the data point was not available.
            	 // at some point in the future, Obvius will replace the word "NULL" with a blank column in the log data to save space.
            	 // not checking for characters like semicolon poses a security risk to your SQL database
            	 // as someone could insert a line "3,4,5,7');drop table password;('3,4,5" into the log file. (this would be very bad)            	 
                 // replace "sometable" with the name of the table you wish to insert the data into.
                 
                 $tmpArray = split(",", $szBuffer);             // start check for bad chars here, like semicolon. first split a single log entry in to components.
                 $nCol = 0;
                 $query = "INSERT INTO tbl_acquidata VALUES (";	// query prefix.  finished query string is:  insert into table values ('1','2','3')
                 foreach ($tmpArray as $value) 				 // loop through each array element by calling it "value", (one per data column,) 
			 	{   $value = str_replace("\"", "", $value);	// strip double quotes 
			 		$value = str_replace("'", "", $value); 	// strip single quotes		 
			 		$value = str_replace(";", "", $value);	 // strip semicolon. (not needed if you use the following MySQL command)
			 		$value = trim($value);	                 // trim whitespace, tabs, etc, on the ENDS of the string.  
			 	    //$value = addslashes($value);   // MySQL has a special strip function just for this purpose, other SQL versions may vary.
			 	    switch($nCol)
			 		{ case 0:  $query  = $query . sprintf("'%s'", $value); break; // quote data (utc date), first column has no leading comma
			 		  case 2: 
			 		  case 3:  $query  = $query . sprintf(",%s", $value); break;  // don't quote hex (alarm) data, column needs leading comma seperator.
			 	      default: 
			 	      {   if ($value == "NULL") $query  = $query . ",NULL" ;	// don't quote the word 'NULL'
			 	      	else $query  = $query . sprintf(",'%s'",$value); // quote data, all other columns need leading comma seperator.
			 	      }
			 	    }
			 		$nCol++;
    			 }
    			 $query = $query . ")";	// close last paren around VALUES section.
    			 // finished building sql query string.
    			                 
                 // ***** for purposes of this example, we are just going to display the SQL statement back to the caller. **** 
                 printf("SQL: %s \n", $query);
                 
                 // again, this query doesn't actually execute in the sample. Replace with a query apporpriate for your flavor of SQL
                 // $result = sql_query($query,  $SQL)                 
                 $result=1; // force success code here, REMOVE THIS LINE.
                 if (!  $result  )
                 {   // check error message from SQL query, ignore duplicate warnings.	
                 	// $strErrorMessage =     sql_error($SQL);
                      if (stristr($strErrorMessage, "duplicate entry") != FALSE)
                      {   $nDuplicateCount +=1;                  	 
                 	 }
                 	 else
                 	 {   $nRejectCount +=1;
                      }
                 	 printf( "WARNING: line rejected, %s: DATA: %s\n", $strErrorMessage, $szBuffer);
                 }
                 else                 
                 {    $nSuccessCount += 1;
				 }
            }
            else
            {    printf( "WARNING: short line rejected. DATA: %s\n", $szBuffer);
                 $nRejectCount +=1;
			}
		}
       gzclose($fd);
       // PHP automatically removes temp files when the script exits.
  }
}  
  
  // now that the data is in the database, check the most current data point, and calculate the alarm status.
  // query for last record in the database, get device status, 
  
  
  echo "REPORT: Uploaded data file contained $nSuccessCount vaild records, $nDuplicateCount duplicate records, and $nRejectCount rejected records.\n";

  // Finally, send the result code back to the AcquiSuite. Success cause the log file to be purged.
  
   // $nRejectCount = 1;   // for this sample script, the nRejectCount is set to 1 to prevent the AcquiSuite from flushing the log file.  YOU SHOULD REMOVE THIS LINE.
  if ($nRejectCount != 0)
  {	ReportFailure( "An error occurred while importing data from the data file.\n", $REMOTE_ADDR, $SERIALNUMBER, $MODBUSIP, $MODBUSPORT, $MODBUSDEVICE);
  }
  else
  {    echo "SUCCESS\n";  	 
  }
 // ProcessLogFileUpload

/* -----------------------------------------------------------------------------------------------*/
/*	This function sends a list of all current configuration files on the server. 
  	The format is as follows:
	
		CONFIGFILE,loggerconfig.ini,md5checksum,timestamp
		CONFIGFILE,modbus/mb001.ini,md5checksum,timestamp
		CONFIGFILE,modbus/mb007.ini,md5checksum,timestamp
				
	  the timestamp is in UTC time, SQL format, ie "YYYY-MM-DD HH:MM:SS" (use blank if not present/first-time)
	  The md5checksum is the md5 checksum of the config file. (use blank if not present/first-time)
	  
	  Checksums and timestamps are stored in a database, file data can be stored in the same table as a blob record.
	  When a config file is received from the AcquiSuite, the server should verify the checksum, save the config file
	  and also save the timestamp and checksum for the file for future reference.  
	  
	  The AcquiSuite will process this response, and only exchange files listed in the manifest response.
	  
	  If the config file checksum sent in the response does not match the AcquiSuite config file checksum, the 	  
	  AcquiSuite will process the exchange.  If "remote configuration" is enabled, the AcquiSuite will check the 
	  timestamp to find if the server version of the config file is newer than the AcquiSuite version .if so the 
	  AcquiSuite will request to download the configuration file from the server. 
	  
	  If the checksum values do not match and the AcquiSuite file timestamp is newer, or if the server timestamp is blank, 
	  or if the "remote configuration" option is not enabled, the AcquiSuite will send the configuration file to 
	  the server.
*/
function SendConfigFileManifest($REMOTE_ADDR, $SERIALNUMBER, $MODBUSIP, $MODBUSPORT)
{	
	// printf("CONFIGFILE,loggerconfig.ini,%s,%s\n", $szConfigurationChecksum, $szConfigurationChangeTime); 
	
	// for each modbus device on this acquisuite, process the following line:
	// printf("CONFIGFILE,modbus/mb-%03d.ini,%s,%s\n", $nModbusAddress, $szConfigurationChecksum, $szConfigurationChangeTime); 
}
/* -----------------------------------------------------------------------------------------------*/
/*	This function sends a specific configuration file to the acquisuite. 
  	The script should finish the header, and then send the config file as the body to the http response.
  	No other content should be included in the response body.
	
      The variables $SERIALNUMBER, $MODBUSIP, $MODBUSPORT and $MODBUSDEVICE are used to identify the config file.	
      THe variable $MODBUSDEVICECLASS is used to verify the device the configuration file is for is the same as
      the hardware detected on the AcquiSuite.		

      Special case: when MODBUSDEVICE and MODBUSDEVICECLASS are both 0, return the loggerconfig.ini file.
      
      The AcquiSuite will confirm the md5 checksum from the manifest with the checksum of the downloaded file for verification.
*/
function SendConfigFile($REMOTE_ADDR, $SERIALNUMBER, $MODBUSIP, $MODBUSPORT, $MODBUSDEVICE, $MODBUSDEVICECLASS)
{
}
/* ================================================================================================================== */
/* ================================================================================================================== */
/*
		BEGIN MAIN SCRIPT HERE !
		
	 First check user authenticity.  The AcuqiSuite uses basic http authentication, the PHP scripting language 
	 extracts the user/password and provides them in the variables PHP_AUTH_USER and PHP_AUTH_PW.  Different 
	 scripting languages may have different methods of providing username/password paris for basic http authentication.
*/
  if ($SENDDATATRACE == "YES") printf("<pre>\n");// make the output more readable
  
  if(!isset($_SERVER['$PHP_AUTH_USER']))
  {   ReportAuthorizationFailure("A system serial number must be supplied to upload data\n", $REMOTE_ADDR, $PHP_AUTH_USER);
      exit;
      // if your server terminates here, please read PHP Authentication comments above.
  }
  
  if(!isset($_SERVER['$PHP_AUTH_PW']))
  {   ReportAuthorizationFailure("A system serial number and password must be supplied to upload data\n", $REMOTE_ADDR, $PHP_AUTH_USER);
      exit;
      // if your server terminates here, please read PHP Authentication comments above.
  }
     
  if ($SERIALNUMBER != $_SERVER['$PHP_AUTH_USER'])
  {   ReportAuthorizationFailure("SerialNumber and http authentication username do not match.", $REMOTE_ADDR, $PHP_AUTH_USER);
      exit;
  }
  
  // check the AcquiSuite list here, make sure the serial number provided by the acquisuite is
  // one that we know about, and have tables in the database for.

  //-------------------------
  // Postgres Connection
  //-------------------------
 
   $conn = pg_connect("host=172.18.204.64 dbname=acquisuite port=5432 user=pgadmin password=pgadmin");
   //Db connection Problem
   if (!$conn) {
      echo "Database connection error.\n";
	  exit;
	}
	// SQL Order
	$query_parent="SELECT tbl_authenticate.serial_num FROM tbl_authenticate";
	$result = pg_exec($conn,$query_parent);
	if (!$result) {
	  echo "SQL order problem.\n";
	  exit;
	}
	
	// End of SQL statement
	// pg_freeresult($result);
	// pg_close($conn);
	}
	
	/*if (!isset($_SERVER['$PHP_AUTH_USER'])) {
	  authenticate();
	 }
	 else {
	  connect($_SERVER['$PHP_AUTH_USER'],$_SERVER['$PHP_AUTH_PW']);
	 }*/
	 	       
  // CHECK PASSWORD HERE. replace "password" with a stored password value for the spcific acquisuite
  // or use an SQL query to verify the password.
  
  if ($_SERVER['$PHP_AUTH_PW'] != "pass" )
  {   ReportAuthorizationFailure("The authentication serial number password do not match.", $REMOTE_ADDR, $PHP_AUTH_USER);
  	printf("Hint: this sample script uses 'password' as the passowrd");
      exit;
  }
  
  // ok, we got this far, we must have had a valid serial number and password.
  // Now we need to validate the data that was sent.
  
/* --------- End of Authentication -----------------------------------------------------------------------------------*/
/* 
   The upload process supports several types of data exchanges for things like log and config files.  
   This sample only processes log files, however the code shows branches for other connection modes.
*/

  $szChecksum = "";	// empty by default, get a file checksum if needed.
  if ($MODE == "LOGFILEUPLOAD") $szChecksum = GetFileChecksum($LOGFILE);	// calculate a checksum for the file.
  if ($MODE == "CONFIGFILEUPLOAD") $szChecksum = GetFileChecksum($CONFIGFILE);	// calculate a checksum for the file.
       
/* -------------------------------------------------------------------------------------------------------------------*/
/*  report the variables sent by the client if the client is requesting TRACE MODE.
    this must be done AFTER the checksum is calculated.
   
    In the file /etc/sysconfig/loggerconfig.ini on the acquisuite, two variables affect how the 
    upload log file is recorded.  You can set these manually with a text editor.  If the option
    is not present in the configuration file, the line with the option must be added to the file
    to enable the feature.  The order of the items in the config file is not important. Obvius 
    may provide a debug checkbox on the data upload page on the AcquiSuite in the future to 
    enable this feature.  If these are not enabled the form variable SENDDATATRACE is not included
    in the form data post, and the server should assume the setting is NO for both items.
   
		SENDDATADEBUG=YES/NO
		SENDDATATRACE=YES/NO
	
    When SENDDATATRACE is set to YES, the database server script should report progress with verbose messages
    if set to NO, the database server script should only report problems. Verbose messages include complete 
    HTTP exchange information including http response headers.
   
    SENDDATADEBUG=YES causes the AcquiSuite software to report progress while uploading the data. This will also
    cause the AcquiSuite to log all response text from the remote server to the uploadlog file on the AcquiSuite. 
    The remote server should send status information and error codes to the AcquiSuite when this form variable is
    set to YES to allow the user to see the upload progress and find where problems (if any) are happening.
   
   
    MODE specifies what type of transfer this is.
   
		LOGFILEUPLOAD		 standard transfer to upload data file
		CONFIGFILEMANIFEST	request a list of config files stored by the sql server, and report date/time for each
		CONFIGFILEUPLOAD	  send a config file to the sql server
		CONFIGFILEDOWNLOAD    download a config file from the sql server
		STATUS				send operating info about the acquisuite, firmware version, uptime, dial attempts, etc.
		TEST				  used for the AcquiSuite connection test.  Verify user/password and then return a success message.
  	 
    The MODBUSDEVICECLASS is a unique id that allows the AcquiSuite to decide what class of device
    it is working with.  It is assumed that the number and type of points stored for a specific device type are the same.
    For example, the Veris 8036 power meter has several versions for 100, 300, 800Amp, however the list of points are the
	same for all devices.  The deviceclass will be the same for all flavors of Veris 8036 meters.
	
	Currently, the deviceclass may be one of the following:
		MBCLASS_UNKNOWN     0
		MBCLASS_HXO         1		(3 data columns)
		MBCLASS_H8036       2		(26 data columns)
		MBCLASS_M4A4P       3		(8 data columns, A8923 basic io module)
		MBCLASS_H8035       4		(2 data columns)
		MBCLASS_H8163	   5		(29 data columns)
		MBCLASS_H663 	   6		(42 data columns)
		MBCLASS_H8238       7		(28 data columns)
		MBCLASS_H8076       8		(28 data columns)
		MBCLASS_M4A4P2      9		(32 data columns, A8923 enhanced io module, A8811 built-in io module)
		MBCLASS_ION6200     10		(61 data columns)
          MBCLASS_ION7300     11		(64 data columns)
          MBCLASS_ION7500     12		(64 data columns)
          MBCLASS_ION7700     13		(64 data columns)
          MBCLASS_PROMON      14		(38 data columns)
          MBCLASS_ACQUILITE   15        (28 data columns)   
	
	More device types may be added as new devices are included in the supported hardware list. Note: the data column count is 
	in addition to the first 4 columns for time,error,low-alarm, and high-alarm.

*/

  if ($SENDDATATRACE == "YES")
  {    echo "Logfile upload from $REMOTE_ADDR \n" ;
       echo "Got SENDDATATRACE:          " . $SENDDATATRACE . " \n";                // set when the AcquiSuite requests full session debug messages
       echo "Got MODE:                   " . $MODE . "\n";						  // this shows what type of exchange we are processing. 
       echo "Got SERIALNUMBER :          " . $SERIALNUMBER . " \n" ;		        // The acquisuite serial number
       
       if ($MODE == "LOGFILEUPLOAD")
       {   echo "Got LOGFILE_name:           " . $LOGFILE_name . " \n" ;			// This is original file name on the AcquiSuite flash disk.
           echo "Got LOGFILE:                " . $LOGFILE . " \n" ;				 // This is the PHP temp file name.
           echo "Got LOGFILE_size:           " . $LOGFILE_size . " \n" ;			// What PHP claims the file size is
           echo "calculated filesize:        " . filesize($LOGFILE) . "\n";	     // what the actual file size is.
       	echo "Got MD5CHECKSUM:            " . $MD5CHECKSUM . " \n" ;			 // the MD5 checksum the AcquiSuite generated prior to upload
      	 echo "calculated checksum:        " . $szChecksum . " \n" ;              // the MD5 sum we calculated on the file we received.
	       echo "Got LOOPNAME:               " . $LOOPNAME . " \n" ;			    // The name of the AcquiSuite (modbus loop name)
	       echo "Got MODBUSIP:               " . $MODBUSIP . " \n" ;				// Currently, always 127.0.0.1, may change in future products.
	       echo "Got MODBUSPORT:             " . $MODBUSPORT . " \n" ;			  // currently, always 502, may change in future products.
	       echo "Got MODBUSDEVICE:           " . $MODBUSDEVICE . " \n" ;			// the modbus device address on the physical modbus loop. (set by dip switches)
	       echo "Got MODBUSDEVICENAME:       " . $MODBUSDEVICENAME . " \n" ;		// the user specified device name. 
	       echo "Got MODBUSDEVICETYPE:       " . $MODBUSDEVICETYPE . " \n" ;		// the identity string returned by the modbus device identify command 
	       echo "Got MODBUSDEVICETYPENUMBER: " . $MODBUSDEVICETYPENUMBER . " \n" ;  // the identity number returned by the modbus device identify command 
	       echo "Got MODBUSDEVICECLASS:      " . $MODBUSDEVICECLASS . " \n" ;	   // a unique id number for the modbus device type.
	       echo "Got FILETIME:               " . $FILETIME . " \n" ;			    // the date and time the file was last modified. (in UTC time).
       }
       
       if ($MODE == "CONFIGFILEUPLOAD")
       {   echo "Got CONFIGFILE_name:        " . $CONFIGFILE_name . " \n" ; 		// This is original file name on the AcquiSuite flash disk.
           echo "Got CONFIGFILE:             " . $CONFIGFILE . " \n" ;			  // This is the PHP temp file name.
           echo "Got CONFIGFILE_size:        " . $CONFIGFILE_size . " \n" ;		 // What PHP claims the file size is
	       echo "Got MODBUSIP:               " . $MODBUSIP . " \n" ;				// Currently, always 127.0.0.1, may change in future products.
	       echo "Got MODBUSPORT:             " . $MODBUSPORT . " \n" ;			  // currently, always 502, may change in future products.
	       echo "Got FILETIME:               " . $FILETIME . " \n" ;			    // the date and time the file was last modified. (in UTC time).
           echo "calculated filesize:        " . filesize($CONFIGFILE) . "\n";      // what the actual file size is.
       	echo "Got MD5CHECKSUM:            " . $MD5CHECKSUM . " \n" ;			 // the MD5 checksum the AcquiSuite generated prior to upload
       	echo "calculated checksum:        " . $szChecksum . " \n" ;              // the MD5 sum we calculated on the file we received.     
       } 
       
       if ($MODE == "CONFIGFILEMANIFEST")
       {   echo "Got LOOPNAME:               " . $LOOPNAME . " \n" ;			    // The name of the AcquiSuite (modbus loop name)
       }
       
       if ($MODE == "CONFIGFILEDOWNLOAD")
       {   echo "Got MODBUSIP:               " . $MODBUSIP . " \n" ;				// Currently, always 127.0.0.1, may change in future products.
	       echo "Got MODBUSPORT:             " . $MODBUSPORT . " \n" ;			  // currently, always 502, may change in future products.
	       echo "Got MODBUSDEVICE:           " . $MODBUSDEVICE . " \n" ;			// the modbus device address on the physical modbus loop. (set by dip switches)
	       echo "Got MODBUSDEVICECLASS:      " . $MODBUSDEVICECLASS . " \n" ;	   // a unique id number for the modbus device type.
       }

	   if ($MODE == "STATUS")
	   {   echo "Got UPTIME:                 " . $UPTIME . " \n" ;				  // number of seconds elapsed since the AcquiSuite booted.
	       echo "Got LOOPNAME:               " . $LOOPNAME . " \n" ;			    // The name of the AcquiSuite (modbus loop name)
	   	echo "Got PERCENTBLOCKSINUSE:     " . $PERCENTBLOCKSINUSE . " \n" ;      // percentage of disk space consumed (by blocks)
	   	echo "Got PERCENTINODESINUSE:     " . $PERCENTINODESINUSE . " \n" ;      // percentage of total log file entries used 
	   	echo "Got UPLOADATTEMPT:          " . $UPLOADATTEMPT . " \n" ;           // this is upload attempt X.  Use the loggerconfig.ini file to get the max upload attempts.
	   	echo "Got ACQUISUITEVERSION:      " . $ACQUISUITEVERSION . " \n" ;       // Firmware version - AcquiSuite component
	   	echo "Got USRVERSION:             " . $USRVERSION . " \n" ;              // Firmware version - USR files component
	   	echo "Got ROOTVERSION:            " . $ROOTVERSION . " \n" ;             // Firmware version - ROOT files component
	   	echo "Got KERNELVERSION:          " . $KERNELVERSION . " \n" ;           // Firmware version - Kernel component.
	   }
	   
       if ($MODE == "TEST")
       {   echo "Test mode - nothing to do.";										// Test mode.  We've verified authentication, do no processing
       }
             
  } // end if trace session reporting enabled.
  
/* -------------------------------------------------------------------------------------------------------------------*/
/* Decide what to do based on the MODE setting.
    Each of these subroutines must report to the client what the success/failure status is.
*/

  if ($MODE == "LOGFILEUPLOAD")
  {   if ($szChecksum != $MD5CHECKSUM)
	  {  ReportFailure("Log file checksum does not match.", $REMOTE_ADDR, $SERIALNUMBER, $MODBUSIP, $MODBUSPORT, $MODBUSDEVICE);
	     exit;
	  }
      ProcessLogFileUpload($REMOTE_ADDR, $SERIALNUMBER, $MODBUSIP, $MODBUSPORT, $MODBUSDEVICE, $LOGFILE, 
	  						$MODBUSDEVICENAME, $MODBUSDEVICETYPE, $MODBUSDEVICETYPENUMBER, $MODBUSDEVICECLASS);
  } // end LOGFILEUPLOAD processing
  
       
  if ($MODE == "CONFIGFILEUPLOAD")
  {   if ($szChecksum != $MD5CHECKSUM)
	  {  ReportFailure("Configuration file checksum does not match.", $REMOTE_ADDR, $SERIALNUMBER, $MODBUSIP, $MODBUSPORT, $MODBUSDEVICE);
	     exit;
	  }
  }  // end CONFIGFILEUPLOAD processing
       
       
  if ($MODE == "CONFIGFILEMANIFEST")
  {   SendConfigFileManifest($REMOTE_ADDR, $SERIALNUMBER, $MODBUSIP, $MODBUSPORT);
  } // end CONFIGFILEMANIFEST processing
       
       
  if ($MODE == "CONFIGFILEDOWNLOAD")
  {   SendConfigFile($REMOTE_ADDR, $SERIALNUMBER, $MODBUSIP, $MODBUSPORT, $MODBUSDEVICE, $MODBUSDEVICECLASS);
  } // end CONFIGFILEDOWNLOAD processing
  
  
  // Trap all modes we don't know about, or if mode was not set.
  if ( ($MODE != "LOGFILEUPLOAD") && ($MODE != "CONFIGFILEUPLOAD") && ($MODE != "CONFIGFILEMANIFEST") && ($MODE != "CONFIGFILEDOWNLOAD") && ($MODE != "STATUS") )
  {   ReportFailure("Mode request MODE=$MODE is not supported.", $REMOTE_ADDR, $SERIALNUMBER, $MODBUSIP, $MODBUSPORT, $MODBUSDEVICE);
	  exit;
  }
      
/* -------------------------------------------------------------------------------------------------------------------*/
/* Clean up and exit.
*/       

  ob_end_flush(); // send cached stuff, and stop caching. This may only be done after the last point where you call ReportFailure()
?>

Cameron Seader
CSeader(at)Idahopower(dot)com



[INFO] -- Access Manager:
This transmission may contain information that is privileged, confidential and/or exempt from disclosure under applicable law.  If you are not the intended recipient, you are hereby notified that any disclosure, copying, distribution, or use of the information contained herein (including any reliance thereon) is STRICTLY PROHIBITED. If you received this transmission in error, please immediately contact the sender and destroy the material in its entirety, whether in electronic or hard copy format.  Thank you.   A2



pgsql-php by date

Next:From: Joshua D. DrakeDate: 2003-09-20 17:33:53
Subject: Re: Interview questions?
Previous:From: Tom LaneDate: 2003-09-20 14:50:00
Subject: Re: PG + PHP, was Re: Zend survey result about dbms...

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group