== IPP Progress Report for the week 2011.05.02 - 2011.05.06 == 
[[PageOutline]]

(Up to [wiki:IPP_Progress_Reports IPP Progress Reports])

=== Eugene Magnier ===

=== Serge Chastel ===
 * Helped Peter for MOPS
 * MySQL replication. ippdb01 databases are replicated on a second server running on ippdb02 (port 3307). Unfortunately the host cannot hold the load.
 
=== Heather Flewelling === 

 * power outage at manoa tuesday afternoon
 * linked new dvo db to ifaps1
 * helped Roy/answered Roy questions.
 * JT stacks (pushed a few more along, answer questions)
 * sdss 3pi plots - I got started on this, and got distracted by isp...
 * sorting out isp astrometry problems:
  * r and i 3 pi chunk has lovely astrometry - initially they did not:
    * ISP was using gpc1 CRLIMITS, found limits for isp
    * needed 3rd order fitting 
    * needed multiple iterations
  * y needs a lot of work (problems related to few stars? too bright? wrong selection of refstars?) I'm still sorting it out
 * sick half a day
=== Roy Henderson ===

 * Detection batches from last week loaded successfully. A relief.
  * able to test new, fast !DetectionCalib table with PSVO
  * work to confirm that we have the same calibrated magnitude in PSPS as in the original IPP smf files

 * Stack loading:
  * issue with NULL xPos and yPos values in !StackDetection: was failing load
  * discovered that deep stacks can have duplicate objIDs and NULL flux values in psf table, thus explaining some previous issues
  * power-cut on monday. Hassles getting datastore back up, loading all the stuff processed the night before
  * discovered hundreds of nightly stacks with 0.0 EXPTIME, thus screwing up flux calculations
   * gpc1 query kindly supplied by Bill, but highlighted that a proportion of the previous stacks had non-zero, but incorrect, EXPTIME
   * changed code to use Bill's query, and reloaded everything
  * dupe objID confusions in deep stacks - ok in detection table, NOT in object table. Reloaded all deep stacks AGAIN
  * merge failed on Friday: ID we are using for stackDetectID is not unique. Need to add stack ID to primary key as a temporary fix.

 * PSVO
  * discussions and testing of PSVO with query builder
  * made MOPSSchema class for query builder to use
  * slow queries now passed straight to TOPCAT, only first 1000 rows shown in table
  * many other minor changes

=== Bill Sweeney ===
 * started working on adding authentication to the data store products and the tools used that access them. 
 * spent one day analyzing the apache access logs for our data store, postage stamp server, and other services provided by po02. 
 * changed the web proxy configuration to restrict access to ps1sc institutions.
 * spent Friday finally installing a new operating system on my desktop. (I was about two years behind.)
 * set up the database to enable distribution of the LAP outputs.

=== Chris Waters ===