Index: /branches/eam_branches/ipp-20121219/Ohana/src/dvopsps/src/insert_detections_dvopsps.c
===================================================================
--- /branches/eam_branches/ipp-20121219/Ohana/src/dvopsps/src/insert_detections_dvopsps.c	(revision 34916)
+++ /branches/eam_branches/ipp-20121219/Ohana/src/dvopsps/src/insert_detections_dvopsps.c	(revision 34917)
@@ -1,3 +1,4 @@
 # include "dvopsps.h"
+# define USE_MYSQL 0
 
 // determine the relevant catalogs, launch parallel clients if desired
@@ -26,4 +27,5 @@
   myAssert (skylist, "ooops!");
 
+# if (0)
   // NOTE: mysql connection happens here since each dvopsps_client makes its own connection
   MYSQL  mysqlBase;
@@ -33,4 +35,5 @@
     exit (1);
   }
+
 
   // select measurements for each populated catalog
Index: /branches/eam_branches/ipp-20121219/Ohana/src/dvopsps/test/dbadmin.sh
===================================================================
--- /branches/eam_branches/ipp-20121219/Ohana/src/dvopsps/test/dbadmin.sh	(revision 34917)
+++ /branches/eam_branches/ipp-20121219/Ohana/src/dvopsps/test/dbadmin.sh	(revision 34917)
@@ -0,0 +1,58 @@
+#!/bin/csh -f
+
+## this script creates a database for testing dvopsps
+
+if ($#argv < 3) goto usage;
+
+if ("$1" == "user") then
+  if ($#argv != 4) goto usage;
+  set dbhost = $2
+  set dbuser = $3
+  set dbpass = $4
+
+  mysql -h $dbhost -u root -p <<EOF
+   grant all on *.* to $dbuser@"$dbhost" identified by '$dbpass';
+EOF
+    exit 0;
+endif
+
+if ("$1" == "create") then
+  if ($#argv != 4) goto usage;
+  set dbhost = $2
+  set dbname = $3
+  set dbuser = $4
+
+  mysql -h $dbhost -u $dbuser -p <<EOF
+   CREATE DATABASE $dbname;
+   USE $dbname;
+   CREATE TABLE dvoDetection (
+               imageID INT,
+               ippDetectID BIGINT,
+               detectID BIGINT,
+               ippObjID BIGINT,
+               objID BIGINT,
+               flags INT,
+               zp REAL,
+               zpErr REAL,
+               airMass REAL,
+               expTime REAL,
+               ra FLOAT,
+               dec_ FLOAT,
+               raErr REAL,
+               decErr REAL,
+               PRIMARY KEY (imageID, ippDetectID) 
+    );
+EOF
+    exit 0;
+endif
+
+usage:
+  echo "USAGE: dbadmin.sh (options)"
+  echo ""
+  echo "  dbadmin.sh create (dbhost) (dbname) (dbuser)"
+  echo "      create a new test db"
+  echo ""
+  echo "  dbadmin.sh user (dbhost) (dbname) (dbuser) (password)"
+  echo "      create a new user and password for the test db"
+  echo ""
+  exit 2