[ome-users] webadmin login

[Gordon W. Laurie]

See below for the record:

Last login: Mon Jun 22 13:12:35 on console
d-128-15-155:~ gordonlaurie$ mkdir /OMERO
d-128-15-155:~ gordonlaurie$ sudo mkdir /usr/share/omero

WARNING: Improper use of the sudo command could lead to data loss
or the deletion of important system files. Please double-check your
typing when using sudo. Type "man sudo" for more information.

To proceed, enter your password, or type Ctrl-C to abort.

Password:
d-128-15-155:~ gordonlaurie$ sudo mv 
/Users/gordonlaurie/Downloads/omero_dist /usr/share/omero/
Password:
d-128-15-155:~ gordonlaurie$ mkdir /opt
d-128-15-155:~ gordonlaurie$ sudo mv /Users/gordonlaurie/Downloads/Ice-3.3.1 
/opt/
d-128-15-155:~ gordonlaurie$ sudo ln -s /opt/Ice-3.3.1 /opt/Ice-3.3
d-128-15-155:~ gordonlaurie$ export PATH=/opt/Ice-3.3/bin:$PATH
d-128-15-155:~ gordonlaurie$ export 
DYLD_LIBRARY_PATH=/opt/Ice-3.3/lib:$DYLD_LIBRARY_PATH
d-128-15-155:~ gordonlaurie$ export 
PYTHONPATH=/opt/Ice-3.3/python:$PYTHONPATH
d-128-15-155:~ gordonlaurie$ export 
CLASSPATH=/opt/Ice-3.3/lib/Ice.jar:$CLASSPATH
d-128-15-155:~ gordonlaurie$ export 
CLASSPATH=/opt/Ice-3.3/lib/db.jar:$CLASSPATHd-128-15-155:~ gordonlaurie$ 
export PYTHONPATH=/usr/share/omero/omero_dist/lib/python/:$PYTHONPATH
d-128-15-155:~ gordonlaurie$ cd /usr/share/omero/omero_dist
d-128-15-155:omero_dist gordonlaurie$ /usr/share/omero/omero_dist/bin/omero 
db script
Please enter omero.db.version [OMERO4]:
Please enter omero.db.patch [0]:
Please enter password for new OMERO root user:
Please re-enter password for new OMERO root user:
Saving to /usr/share/omero/omero_dist/OMERO4__0.sql
d-128-15-155:omero_dist gordonlaurie$ /Library/PostgreSQL/8.3/bin/psql -h 
localhost -U omero omero < /usr/share/omero/omero_dist/OMERO4__0.sql
Password for user omero:
BEGIN
NOTICE:  CREATE TABLE / PRIMARY KEY will create implicit index 
"acquisitionmode_pkey" for table "acquisitionmode"
NOTICE:  CREATE TABLE / UNIQUE will create implicit index 
"acquisitionmode_value_key" for table "acquisitionmode"
NOTICE:  CREATE TABLE / UNIQUE will create implicit index 
"acquisitionmode_external_id_key" for table "acquisitionmode"
CREATE TABLE
NOTICE:  CREATE TABLE / PRIMARY KEY will create implicit index 
"annotation_pkey" for table "annotation"
NOTICE:  CREATE TABLE / UNIQUE will create implicit index 
"annotation_external_id_key" for table "annotation"
CREATE TABLE
NOTICE:  CREATE TABLE / PRIMARY KEY will create implicit index 
"annotationannotationlink_pkey" for table "annotationannotationlink"
NOTICE:  CREATE TABLE / UNIQUE will create implicit index 
"annotationannotationlink_external_id_key" for table 
"annotationannotationlink"
NOTICE:  CREATE TABLE / UNIQUE will create implicit index 
"annotationannotationlink_parent_key" for table "annotationannotationlink"
CREATE TABLE
NOTICE:  CREATE TABLE / PRIMARY KEY will create implicit index "arc_pkey" 
for table "arc"
CREATE TABLE
NOTICE:  CREATE TABLE / PRIMARY KEY will create implicit index 
"arctype_pkey" for table "arctype"
NOTICE:  CREATE TABLE / UNIQUE will create implicit index 
"arctype_value_key" for table "arctype"
NOTICE:  CREATE TABLE / UNIQUE will create implicit index 
"arctype_external_id_key" for table "arctype"
CREATE TABLE
NOTICE:  CREATE TABLE / PRIMARY KEY will create implicit index 
"binning_pkey" for table "binning"
NOTICE:  CREATE TABLE / UNIQUE will create implicit index 
"binning_value_key" for table "binning"
NOTICE:  CREATE TABLE / UNIQUE will create implicit index 
"binning_external_id_key" for table "binning"
CREATE TABLE
NOTICE:  CREATE TABLE / PRIMARY KEY will create implicit index 
"channel_pkey" for table "channel"
NOTICE:  CREATE TABLE / UNIQUE will create implicit index 
"channel_external_id_key" for table "channel"
NOTICE:  CREATE TABLE / UNIQUE will create implicit index 
"channel_pixels_key" for table "channel"
CREATE TABLE
NOTICE:  CREATE TABLE / PRIMARY KEY will create implicit index 
"channelannotationlink_pkey" for table "channelannotationlink"
NOTICE:  CREATE TABLE / UNIQUE will create implicit index 
"channelannotationlink_external_id_key" for table "channelannotationlink"
NOTICE:  CREATE TABLE / UNIQUE will create implicit index 
"channelannotationlink_parent_key" for table "channelannotationlink"
CREATE TABLE
NOTICE:  CREATE TABLE / PRIMARY KEY will create implicit index 
"channelbinding_pkey" for table "channelbinding"
NOTICE:  CREATE TABLE / UNIQUE will create implicit index 
"channelbinding_external_id_key" for table "channelbinding"
NOTICE:  CREATE TABLE / UNIQUE will create implicit index 
"channelbinding_renderingdef_key" for table "channelbinding"
CREATE TABLE
NOTICE:  CREATE TABLE / PRIMARY KEY will create implicit index 
"codomainmapcontext_pkey" for table "codomainmapcontext"
NOTICE:  CREATE TABLE / UNIQUE will create implicit index 
"codomainmapcontext_external_id_key" for table "codomainmapcontext"
NOTICE:  CREATE TABLE / UNIQUE will create implicit index 
"codomainmapcontext_renderingdef_key" for table "codomainmapcontext"
CREATE TABLE
NOTICE:  CREATE TABLE / PRIMARY KEY will create implicit index 
"contrastmethod_pkey" for table "contrastmethod"
NOTICE:  CREATE TABLE / UNIQUE will create implicit index 
"contrastmethod_value_key" for table "contrastmethod"
NOTICE:  CREATE TABLE / UNIQUE will create implicit index 
"contrastmethod_external_id_key" for table "contrastmethod"
CREATE TABLE
NOTICE:  CREATE TABLE / PRIMARY KEY will create implicit index 
"contraststretchingcontext_pkey" for table "contraststretchingcontext"
CREATE TABLE
NOTICE:  CREATE TABLE / PRIMARY KEY will create implicit index 
"correction_pkey" for table "correction"
NOTICE:  CREATE TABLE / UNIQUE will create implicit index 
"correction_value_key" for table "correction"
NOTICE:  CREATE TABLE / UNIQUE will create implicit index 
"correction_external_id_key" for table "correction"
CREATE TABLE
NOTICE:  CREATE TABLE / PRIMARY KEY will create implicit index 
"count_annotation_annotationlinks_by_owner_pkey" for table 
"count_annotation_annotationlinks_by_owner"
CREATE TABLE
NOTICE:  CREATE TABLE / PRIMARY KEY will create implicit index 
"count_channel_annotationlinks_by_owner_pkey" for table 
"count_channel_annotationlinks_by_owner"
CREATE TABLE
NOTICE:  CREATE TABLE / PRIMARY KEY will create implicit index 
"count_dataset_annotationlinks_by_owner_pkey" for table 
"count_dataset_annotationlinks_by_owner"
CREATE TABLE
NOTICE:  CREATE TABLE / PRIMARY KEY will create implicit index 
"count_dataset_imagelinks_by_owner_pkey" for table 
"count_dataset_imagelinks_by_owner"
CREATE TABLE
NOTICE:  CREATE TABLE / PRIMARY KEY will create implicit index 
"count_dataset_projectlinks_by_owner_pkey" for table 
"count_dataset_projectlinks_by_owner"
CREATE TABLE
NOTICE:  CREATE TABLE / PRIMARY KEY will create implicit index 
"count_experimentergroup_annotationlinks_by_owner_pkey" for table 
"count_experimentergroup_annotationlinks_by_owner"
CREATE TABLE
NOTICE:  CREATE TABLE / PRIMARY KEY will create implicit index 
"count_experimentergroup_groupexperimentermap_by_owner_pkey" for table 
"count_experimentergroup_groupexperimentermap_by_owner"
CREATE TABLE
NOTICE:  CREATE TABLE / PRIMARY KEY will create implicit index 
"count_experimenter_annotationlinks_by_owner_pkey" for table 
"count_experimenter_annotationlinks_by_owner"
CREATE TABLE
NOTICE:  CREATE TABLE / PRIMARY KEY will create implicit index 
"count_experimenter_groupexperimentermap_by_owner_pkey" for table 
"count_experimenter_groupexperimentermap_by_owner"
CREATE TABLE
NOTICE:  CREATE TABLE / PRIMARY KEY will create implicit index 
"count_image_annotationlinks_by_owner_pkey" for table 
"count_image_annotationlinks_by_owner"
CREATE TABLE
NOTICE:  CREATE TABLE / PRIMARY KEY will create implicit index 
"count_image_datasetlinks_by_owner_pkey" for table 
"count_image_datasetlinks_by_owner"
CREATE TABLE
NOTICE:  CREATE TABLE / PRIMARY KEY will create implicit index 
"count_job_originalfilelinks_by_owner_pkey" for table 
"count_job_originalfilelinks_by_owner"
CREATE TABLE
NOTICE:  CREATE TABLE / PRIMARY KEY will create implicit index 
"count_node_annotationlinks_by_owner_pkey" for table 
"count_node_annotationlinks_by_owner"
CREATE TABLE
NOTICE:  CREATE TABLE / PRIMARY KEY will create implicit index 
"count_originalfile_annotationlinks_by_owner_pkey" for table 
"count_originalfile_annotationlinks_by_owner"
CREATE TABLE
NOTICE:  CREATE TABLE / PRIMARY KEY will create implicit index 
"count_originalfile_pixelsfilemaps_by_owner_pkey" for table 
"count_originalfile_pixelsfilemaps_by_owner"
CREATE TABLE
NOTICE:  CREATE TABLE / PRIMARY KEY will create implicit index 
"count_pixels_annotationlinks_by_owner_pkey" for table 
"count_pixels_annotationlinks_by_owner"
CREATE TABLE
NOTICE:  CREATE TABLE / PRIMARY KEY will create implicit index 
"count_pixels_pixelsfilemaps_by_owner_pkey" for table 
"count_pixels_pixelsfilemaps_by_owner"
CREATE TABLE
NOTICE:  CREATE TABLE / PRIMARY KEY will create implicit index 
"count_planeinfo_annotationlinks_by_owner_pkey" for table 
"count_planeinfo_annotationlinks_by_owner"
CREATE TABLE
NOTICE:  CREATE TABLE / PRIMARY KEY will create implicit index 
"count_plate_annotationlinks_by_owner_pkey" for table 
"count_plate_annotationlinks_by_owner"
CREATE TABLE
NOTICE:  CREATE TABLE / PRIMARY KEY will create implicit index 
"count_plate_screenlinks_by_owner_pkey" for table 
"count_plate_screenlinks_by_owner"
CREATE TABLE
NOTICE:  CREATE TABLE / PRIMARY KEY will create implicit index 
"count_project_annotationlinks_by_owner_pkey" for table 
"count_project_annotationlinks_by_owner"
CREATE TABLE
NOTICE:  CREATE TABLE / PRIMARY KEY will create implicit index 
"count_project_datasetlinks_by_owner_pkey" for table 
"count_project_datasetlinks_by_owner"
CREATE TABLE
NOTICE:  CREATE TABLE / PRIMARY KEY will create implicit index 
"count_reagent_annotationlinks_by_owner_pkey" for table 
"count_reagent_annotationlinks_by_owner"
CREATE TABLE
NOTICE:  CREATE TABLE / PRIMARY KEY will create implicit index 
"count_reagent_welllinks_by_owner_pkey" for table 
"count_reagent_welllinks_by_owner"
CREATE TABLE
NOTICE:  CREATE TABLE / PRIMARY KEY will create implicit index 
"count_screenacquisition_annotationlinks_by_owner_pkey" for table 
"count_screenacquisition_annotationlinks_by_owner"
CREATE TABLE
NOTICE:  CREATE TABLE / PRIMARY KEY will create implicit index 
"count_screenacquisition_wellsamplelinks_by_owner_pkey" for table 
"count_screenacquisition_wellsamplelinks_by_owner"
CREATE TABLE
NOTICE:  CREATE TABLE / PRIMARY KEY will create implicit index 
"count_screen_annotationlinks_by_owner_pkey" for table 
"count_screen_annotationlinks_by_owner"
CREATE TABLE
NOTICE:  CREATE TABLE / PRIMARY KEY will create implicit index 
"count_screen_platelinks_by_owner_pkey" for table 
"count_screen_platelinks_by_owner"
CREATE TABLE
NOTICE:  CREATE TABLE / PRIMARY KEY will create implicit index 
"count_session_annotationlinks_by_owner_pkey" for table 
"count_session_annotationlinks_by_owner"
CREATE TABLE
NOTICE:  CREATE TABLE / PRIMARY KEY will create implicit index 
"count_wellsample_annotationlinks_by_owner_pkey" for table 
"count_wellsample_annotationlinks_by_owner"
CREATE TABLE
NOTICE:  CREATE TABLE / PRIMARY KEY will create implicit index 
"count_wellsample_screenacquisitionlinks_by_owner_pkey" for table 
"count_wellsample_screenacquisitionlinks_by_owner"
CREATE TABLE
NOTICE:  CREATE TABLE / PRIMARY KEY will create implicit index 
"count_well_annotationlinks_by_owner_pkey" for table 
"count_well_annotationlinks_by_owner"
CREATE TABLE
NOTICE:  CREATE TABLE / PRIMARY KEY will create implicit index 
"count_well_reagentlinks_by_owner_pkey" for table 
"count_well_reagentlinks_by_owner"
CREATE TABLE
NOTICE:  CREATE TABLE / PRIMARY KEY will create implicit index 
"dataset_pkey" for table "dataset"
NOTICE:  CREATE TABLE / UNIQUE will create implicit index 
"dataset_external_id_key" for table "dataset"
CREATE TABLE
NOTICE:  CREATE TABLE / PRIMARY KEY will create implicit index 
"datasetannotationlink_pkey" for table "datasetannotationlink"
NOTICE:  CREATE TABLE / UNIQUE will create implicit index 
"datasetannotationlink_external_id_key" for table "datasetannotationlink"
NOTICE:  CREATE TABLE / UNIQUE will create implicit index 
"datasetannotationlink_parent_key" for table "datasetannotationlink"
CREATE TABLE
NOTICE:  CREATE TABLE / PRIMARY KEY will create implicit index 
"datasetimagelink_pkey" for table "datasetimagelink"
NOTICE:  CREATE TABLE / UNIQUE will create implicit index 
"datasetimagelink_external_id_key" for table "datasetimagelink"
NOTICE:  CREATE TABLE / UNIQUE will create implicit index 
"datasetimagelink_parent_key" for table "datasetimagelink"
CREATE TABLE
NOTICE:  CREATE TABLE / PRIMARY KEY will create implicit index 
"dbpatch_pkey" for table "dbpatch"
NOTICE:  CREATE TABLE / UNIQUE will create implicit index 
"dbpatch_external_id_key" for table "dbpatch"
CREATE TABLE
NOTICE:  CREATE TABLE / PRIMARY KEY will create implicit index 
"detector_pkey" for table "detector"
NOTICE:  CREATE TABLE / UNIQUE will create implicit index 
"detector_external_id_key" for table "detector"
CREATE TABLE
NOTICE:  CREATE TABLE / PRIMARY KEY will create implicit index 
"detectorsettings_pkey" for table "detectorsettings"
NOTICE:  CREATE TABLE / UNIQUE will create implicit index 
"detectorsettings_external_id_key" for table "detectorsettings"
CREATE TABLE
NOTICE:  CREATE TABLE / PRIMARY KEY will create implicit index 
"detectortype_pkey" for table "detectortype"
NOTICE:  CREATE TABLE / UNIQUE will create implicit index 
"detectortype_value_key" for table "detectortype"
NOTICE:  CREATE TABLE / UNIQUE will create implicit index 
"detectortype_external_id_key" for table "detectortype"
CREATE TABLE
NOTICE:  CREATE TABLE / PRIMARY KEY will create implicit index 
"dichroic_pkey" for table "dichroic"
NOTICE:  CREATE TABLE / UNIQUE will create implicit index 
"dichroic_external_id_key" for table "dichroic"
CREATE TABLE
NOTICE:  CREATE TABLE / PRIMARY KEY will create implicit index 
"dimensionorder_pkey" for table "dimensionorder"
NOTICE:  CREATE TABLE / UNIQUE will create implicit index 
"dimensionorder_value_key" for table "dimensionorder"
NOTICE:  CREATE TABLE / UNIQUE will create implicit index 
"dimensionorder_external_id_key" for table "dimensionorder"
CREATE TABLE
NOTICE:  CREATE TABLE / PRIMARY KEY will create implicit index "event_pkey" 
for table "event"
NOTICE:  CREATE TABLE / UNIQUE will create implicit index 
"event_external_id_key" for table "event"
CREATE TABLE
NOTICE:  CREATE TABLE / PRIMARY KEY will create implicit index 
"eventlog_pkey" for table "eventlog"
NOTICE:  CREATE TABLE / UNIQUE will create implicit index 
"eventlog_external_id_key" for table "eventlog"
CREATE TABLE
NOTICE:  CREATE TABLE / PRIMARY KEY will create implicit index 
"eventtype_pkey" for table "eventtype"
NOTICE:  CREATE TABLE / UNIQUE will create implicit index 
"eventtype_value_key" for table "eventtype"
NOTICE:  CREATE TABLE / UNIQUE will create implicit index 
"eventtype_external_id_key" for table "eventtype"
CREATE TABLE
NOTICE:  CREATE TABLE / PRIMARY KEY will create implicit index 
"experiment_pkey" for table "experiment"
NOTICE:  CREATE TABLE / UNIQUE will create implicit index 
"experiment_external_id_key" for table "experiment"
CREATE TABLE
NOTICE:  CREATE TABLE / PRIMARY KEY will create implicit index 
"experimenter_pkey" for table "experimenter"
NOTICE:  CREATE TABLE / UNIQUE will create implicit index 
"experimenter_omename_key" for table "experimenter"
NOTICE:  CREATE TABLE / UNIQUE will create implicit index 
"experimenter_external_id_key" for table "experimenter"
CREATE TABLE
NOTICE:  CREATE TABLE / PRIMARY KEY will create implicit index 
"experimenterannotationlink_pkey" for table "experimenterannotationlink"
NOTICE:  CREATE TABLE / UNIQUE will create implicit index 
"experimenterannotationlink_external_id_key" for table 
"experimenterannotationlink"
NOTICE:  CREATE TABLE / UNIQUE will create implicit index 
"experimenterannotationlink_parent_key" for table 
"experimenterannotationlink"
CREATE TABLE
NOTICE:  CREATE TABLE / PRIMARY KEY will create implicit index 
"experimentergroup_pkey" for table "experimentergroup"
NOTICE:  CREATE TABLE / UNIQUE will create implicit index 
"experimentergroup_name_key" for table "experimentergroup"
NOTICE:  CREATE TABLE / UNIQUE will create implicit index 
"experimentergroup_external_id_key" for table "experimentergroup"
CREATE TABLE
NOTICE:  CREATE TABLE / PRIMARY KEY will create implicit index 
"experimentergroupannotationlink_pkey" for table 
"experimentergroupannotationlink"
NOTICE:  CREATE TABLE / UNIQUE will create implicit index 
"experimentergroupannotationlink_external_id_key" for table 
"experimentergroupannotationlink"
NOTICE:  CREATE TABLE / UNIQUE will create implicit index 
"experimentergroupannotationlink_parent_key" for table 
"experimentergroupannotationlink"
CREATE TABLE
NOTICE:  CREATE TABLE / PRIMARY KEY will create implicit index 
"experimenttype_pkey" for table "experimenttype"
NOTICE:  CREATE TABLE / UNIQUE will create implicit index 
"experimenttype_value_key" for table "experimenttype"
NOTICE:  CREATE TABLE / UNIQUE will create implicit index 
"experimenttype_external_id_key" for table "experimenttype"
CREATE TABLE
NOTICE:  CREATE TABLE / PRIMARY KEY will create implicit index 
"externalinfo_pkey" for table "externalinfo"
NOTICE:  CREATE TABLE / UNIQUE will create implicit index 
"externalinfo_external_id_key" for table "externalinfo"
CREATE TABLE
NOTICE:  CREATE TABLE / PRIMARY KEY will create implicit index "family_pkey" 
for table "family"
NOTICE:  CREATE TABLE / UNIQUE will create implicit index "family_value_key" 
for table "family"
NOTICE:  CREATE TABLE / UNIQUE will create implicit index 
"family_external_id_key" for table "family"
CREATE TABLE
NOTICE:  CREATE TABLE / PRIMARY KEY will create implicit index 
"filament_pkey" for table "filament"
CREATE TABLE
NOTICE:  CREATE TABLE / PRIMARY KEY will create implicit index 
"filamenttype_pkey" for table "filamenttype"
NOTICE:  CREATE TABLE / UNIQUE will create implicit index 
"filamenttype_value_key" for table "filamenttype"
NOTICE:  CREATE TABLE / UNIQUE will create implicit index 
"filamenttype_external_id_key" for table "filamenttype"
CREATE TABLE
NOTICE:  CREATE TABLE / PRIMARY KEY will create implicit index "filter_pkey" 
for table "filter"
NOTICE:  CREATE TABLE / UNIQUE will create implicit index 
"filter_external_id_key" for table "filter"
CREATE TABLE
NOTICE:  CREATE TABLE / PRIMARY KEY will create implicit index 
"filterset_pkey" for table "filterset"
NOTICE:  CREATE TABLE / UNIQUE will create implicit index 
"filterset_external_id_key" for table "filterset"
CREATE TABLE
NOTICE:  CREATE TABLE / PRIMARY KEY will create implicit index 
"filtertype_pkey" for table "filtertype"
NOTICE:  CREATE TABLE / UNIQUE will create implicit index 
"filtertype_value_key" for table "filtertype"
NOTICE:  CREATE TABLE / UNIQUE will create implicit index 
"filtertype_external_id_key" for table "filtertype"
CREATE TABLE
NOTICE:  CREATE TABLE / PRIMARY KEY will create implicit index "format_pkey" 
for table "format"
NOTICE:  CREATE TABLE / UNIQUE will create implicit index "format_value_key" 
for table "format"
NOTICE:  CREATE TABLE / UNIQUE will create implicit index 
"format_external_id_key" for table "format"
CREATE TABLE
NOTICE:  CREATE TABLE / PRIMARY KEY will create implicit index 
"groupexperimentermap_pkey" for table "groupexperimentermap"
NOTICE:  CREATE TABLE / UNIQUE will create implicit index 
"groupexperimentermap_external_id_key" for table "groupexperimentermap"
NOTICE:  CREATE TABLE / UNIQUE will create implicit index 
"groupexperimentermap_parent_key" for table "groupexperimentermap"
NOTICE:  CREATE TABLE / UNIQUE will create implicit index 
"groupexperimentermap_child_key" for table "groupexperimentermap"
CREATE TABLE
NOTICE:  CREATE TABLE / PRIMARY KEY will create implicit index 
"illumination_pkey" for table "illumination"
NOTICE:  CREATE TABLE / UNIQUE will create implicit index 
"illumination_value_key" for table "illumination"
NOTICE:  CREATE TABLE / UNIQUE will create implicit index 
"illumination_external_id_key" for table "illumination"
CREATE TABLE
NOTICE:  CREATE TABLE / PRIMARY KEY will create implicit index "image_pkey" 
for table "image"
NOTICE:  CREATE TABLE / UNIQUE will create implicit index 
"image_external_id_key" for table "image"
CREATE TABLE
NOTICE:  CREATE TABLE / PRIMARY KEY will create implicit index 
"imageannotationlink_pkey" for table "imageannotationlink"
NOTICE:  CREATE TABLE / UNIQUE will create implicit index 
"imageannotationlink_external_id_key" for table "imageannotationlink"
NOTICE:  CREATE TABLE / UNIQUE will create implicit index 
"imageannotationlink_parent_key" for table "imageannotationlink"
CREATE TABLE
NOTICE:  CREATE TABLE / PRIMARY KEY will create implicit index 
"imagingenvironment_pkey" for table "imagingenvironment"
NOTICE:  CREATE TABLE / UNIQUE will create implicit index 
"imagingenvironment_external_id_key" for table "imagingenvironment"
CREATE TABLE
NOTICE:  CREATE TABLE / PRIMARY KEY will create implicit index 
"immersion_pkey" for table "immersion"
NOTICE:  CREATE TABLE / UNIQUE will create implicit index 
"immersion_value_key" for table "immersion"
NOTICE:  CREATE TABLE / UNIQUE will create implicit index 
"immersion_external_id_key" for table "immersion"
CREATE TABLE
NOTICE:  CREATE TABLE / PRIMARY KEY will create implicit index 
"importjob_pkey" for table "importjob"
CREATE TABLE
NOTICE:  CREATE TABLE / PRIMARY KEY will create implicit index 
"instrument_pkey" for table "instrument"
NOTICE:  CREATE TABLE / UNIQUE will create implicit index 
"instrument_external_id_key" for table "instrument"
CREATE TABLE
NOTICE:  CREATE TABLE / PRIMARY KEY will create implicit index "job_pkey" 
for table "job"
NOTICE:  CREATE TABLE / UNIQUE will create implicit index 
"job_external_id_key" for table "job"
CREATE TABLE
NOTICE:  CREATE TABLE / PRIMARY KEY will create implicit index 
"joboriginalfilelink_pkey" for table "joboriginalfilelink"
NOTICE:  CREATE TABLE / UNIQUE will create implicit index 
"joboriginalfilelink_external_id_key" for table "joboriginalfilelink"
NOTICE:  CREATE TABLE / UNIQUE will create implicit index 
"joboriginalfilelink_parent_key" for table "joboriginalfilelink"
CREATE TABLE
NOTICE:  CREATE TABLE / PRIMARY KEY will create implicit index 
"jobstatus_pkey" for table "jobstatus"
NOTICE:  CREATE TABLE / UNIQUE will create implicit index 
"jobstatus_value_key" for table "jobstatus"
NOTICE:  CREATE TABLE / UNIQUE will create implicit index 
"jobstatus_external_id_key" for table "jobstatus"
CREATE TABLE
NOTICE:  CREATE TABLE / PRIMARY KEY will create implicit index "laser_pkey" 
for table "laser"
CREATE TABLE
NOTICE:  CREATE TABLE / PRIMARY KEY will create implicit index 
"lasermedium_pkey" for table "lasermedium"
NOTICE:  CREATE TABLE / UNIQUE will create implicit index 
"lasermedium_value_key" for table "lasermedium"
NOTICE:  CREATE TABLE / UNIQUE will create implicit index 
"lasermedium_external_id_key" for table "lasermedium"
CREATE TABLE
NOTICE:  CREATE TABLE / PRIMARY KEY will create implicit index 
"lasertype_pkey" for table "lasertype"
NOTICE:  CREATE TABLE / UNIQUE will create implicit index 
"lasertype_value_key" for table "lasertype"
NOTICE:  CREATE TABLE / UNIQUE will create implicit index 
"lasertype_external_id_key" for table "lasertype"
CREATE TABLE
NOTICE:  CREATE TABLE / PRIMARY KEY will create implicit index 
"lightemittingdiode_pkey" for table "lightemittingdiode"
CREATE TABLE
NOTICE:  CREATE TABLE / PRIMARY KEY will create implicit index 
"lightsettings_pkey" for table "lightsettings"
NOTICE:  CREATE TABLE / UNIQUE will create implicit index 
"lightsettings_external_id_key" for table "lightsettings"
CREATE TABLE
NOTICE:  CREATE TABLE / PRIMARY KEY will create implicit index 
"lightsource_pkey" for table "lightsource"
NOTICE:  CREATE TABLE / UNIQUE will create implicit index 
"lightsource_external_id_key" for table "lightsource"
CREATE TABLE
NOTICE:  CREATE TABLE / PRIMARY KEY will create implicit index "link_pkey" 
for table "link"
NOTICE:  CREATE TABLE / UNIQUE will create implicit index 
"link_external_id_key" for table "link"
CREATE TABLE
NOTICE:  CREATE TABLE / PRIMARY KEY will create implicit index 
"logicalchannel_pkey" for table "logicalchannel"
NOTICE:  CREATE TABLE / UNIQUE will create implicit index 
"logicalchannel_external_id_key" for table "logicalchannel"
CREATE TABLE
NOTICE:  CREATE TABLE / PRIMARY KEY will create implicit index "medium_pkey" 
for table "medium"
NOTICE:  CREATE TABLE / UNIQUE will create implicit index "medium_value_key" 
for table "medium"
NOTICE:  CREATE TABLE / UNIQUE will create implicit index 
"medium_external_id_key" for table "medium"
CREATE TABLE
NOTICE:  CREATE TABLE / PRIMARY KEY will create implicit index 
"microbeammanipulation_pkey" for table "microbeammanipulation"
NOTICE:  CREATE TABLE / UNIQUE will create implicit index 
"microbeammanipulation_external_id_key" for table "microbeammanipulation"
CREATE TABLE
NOTICE:  CREATE TABLE / PRIMARY KEY will create implicit index 
"microbeammanipulationtype_pkey" for table "microbeammanipulationtype"
NOTICE:  CREATE TABLE / UNIQUE will create implicit index 
"microbeammanipulationtype_value_key" for table "microbeammanipulationtype"
NOTICE:  CREATE TABLE / UNIQUE will create implicit index 
"microbeammanipulationtype_external_id_key" for table 
"microbeammanipulationtype"
CREATE TABLE
NOTICE:  CREATE TABLE / PRIMARY KEY will create implicit index 
"microscope_pkey" for table "microscope"
NOTICE:  CREATE TABLE / UNIQUE will create implicit index 
"microscope_external_id_key" for table "microscope"
CREATE TABLE
NOTICE:  CREATE TABLE / PRIMARY KEY will create implicit index 
"microscopetype_pkey" for table "microscopetype"
NOTICE:  CREATE TABLE / UNIQUE will create implicit index 
"microscopetype_value_key" for table "microscopetype"
NOTICE:  CREATE TABLE / UNIQUE will create implicit index 
"microscopetype_external_id_key" for table "microscopetype"
CREATE TABLE
NOTICE:  CREATE TABLE / PRIMARY KEY will create implicit index "node_pkey" 
for table "node"
NOTICE:  CREATE TABLE / UNIQUE will create implicit index 
"node_external_id_key" for table "node"
CREATE TABLE
NOTICE:  CREATE TABLE / PRIMARY KEY will create implicit index 
"nodeannotationlink_pkey" for table "nodeannotationlink"
NOTICE:  CREATE TABLE / UNIQUE will create implicit index 
"nodeannotationlink_external_id_key" for table "nodeannotationlink"
NOTICE:  CREATE TABLE / UNIQUE will create implicit index 
"nodeannotationlink_parent_key" for table "nodeannotationlink"
CREATE TABLE
NOTICE:  CREATE TABLE / PRIMARY KEY will create implicit index 
"objective_pkey" for table "objective"
NOTICE:  CREATE TABLE / UNIQUE will create implicit index 
"objective_external_id_key" for table "objective"
CREATE TABLE
NOTICE:  CREATE TABLE / PRIMARY KEY will create implicit index 
"objectivesettings_pkey" for table "objectivesettings"
NOTICE:  CREATE TABLE / UNIQUE will create implicit index 
"objectivesettings_external_id_key" for table "objectivesettings"
CREATE TABLE
NOTICE:  CREATE TABLE / PRIMARY KEY will create implicit index 
"originalfile_pkey" for table "originalfile"
NOTICE:  CREATE TABLE / UNIQUE will create implicit index 
"originalfile_external_id_key" for table "originalfile"
CREATE TABLE
NOTICE:  CREATE TABLE / PRIMARY KEY will create implicit index 
"originalfileannotationlink_pkey" for table "originalfileannotationlink"
NOTICE:  CREATE TABLE / UNIQUE will create implicit index 
"originalfileannotationlink_external_id_key" for table 
"originalfileannotationlink"
NOTICE:  CREATE TABLE / UNIQUE will create implicit index 
"originalfileannotationlink_parent_key" for table 
"originalfileannotationlink"
CREATE TABLE
NOTICE:  CREATE TABLE / PRIMARY KEY will create implicit index "otf_pkey" 
for table "otf"
NOTICE:  CREATE TABLE / UNIQUE will create implicit index 
"otf_external_id_key" for table "otf"
CREATE TABLE
NOTICE:  CREATE TABLE / PRIMARY KEY will create implicit index 
"photometricinterpretation_pkey" for table "photometricinterpretation"
NOTICE:  CREATE TABLE / UNIQUE will create implicit index 
"photometricinterpretation_value_key" for table "photometricinterpretation"
NOTICE:  CREATE TABLE / UNIQUE will create implicit index 
"photometricinterpretation_external_id_key" for table 
"photometricinterpretation"
CREATE TABLE
NOTICE:  CREATE TABLE / PRIMARY KEY will create implicit index "pixels_pkey" 
for table "pixels"
NOTICE:  CREATE TABLE / UNIQUE will create implicit index 
"pixels_external_id_key" for table "pixels"
NOTICE:  CREATE TABLE / UNIQUE will create implicit index "pixels_image_key" 
for table "pixels"
CREATE TABLE
NOTICE:  CREATE TABLE / PRIMARY KEY will create implicit index 
"pixelsannotationlink_pkey" for table "pixelsannotationlink"
NOTICE:  CREATE TABLE / UNIQUE will create implicit index 
"pixelsannotationlink_external_id_key" for table "pixelsannotationlink"
NOTICE:  CREATE TABLE / UNIQUE will create implicit index 
"pixelsannotationlink_parent_key" for table "pixelsannotationlink"
CREATE TABLE
NOTICE:  CREATE TABLE / PRIMARY KEY will create implicit index 
"pixelsoriginalfilemap_pkey" for table "pixelsoriginalfilemap"
NOTICE:  CREATE TABLE / UNIQUE will create implicit index 
"pixelsoriginalfilemap_external_id_key" for table "pixelsoriginalfilemap"
NOTICE:  CREATE TABLE / UNIQUE will create implicit index 
"pixelsoriginalfilemap_parent_key" for table "pixelsoriginalfilemap"
CREATE TABLE
NOTICE:  CREATE TABLE / PRIMARY KEY will create implicit index 
"pixelstype_pkey" for table "pixelstype"
NOTICE:  CREATE TABLE / UNIQUE will create implicit index 
"pixelstype_value_key" for table "pixelstype"
NOTICE:  CREATE TABLE / UNIQUE will create implicit index 
"pixelstype_external_id_key" for table "pixelstype"
CREATE TABLE
NOTICE:  CREATE TABLE / PRIMARY KEY will create implicit index 
"planeinfo_pkey" for table "planeinfo"
NOTICE:  CREATE TABLE / UNIQUE will create implicit index 
"planeinfo_external_id_key" for table "planeinfo"
CREATE TABLE
NOTICE:  CREATE TABLE / PRIMARY KEY will create implicit index 
"planeinfoannotationlink_pkey" for table "planeinfoannotationlink"
NOTICE:  CREATE TABLE / UNIQUE will create implicit index 
"planeinfoannotationlink_external_id_key" for table 
"planeinfoannotationlink"
NOTICE:  CREATE TABLE / UNIQUE will create implicit index 
"planeinfoannotationlink_parent_key" for table "planeinfoannotationlink"
CREATE TABLE
NOTICE:  CREATE TABLE / PRIMARY KEY will create implicit index 
"planeslicingcontext_pkey" for table "planeslicingcontext"
CREATE TABLE
NOTICE:  CREATE TABLE / PRIMARY KEY will create implicit index "plate_pkey" 
for table "plate"
NOTICE:  CREATE TABLE / UNIQUE will create implicit index 
"plate_external_id_key" for table "plate"
CREATE TABLE
NOTICE:  CREATE TABLE / PRIMARY KEY will create implicit index 
"plateannotationlink_pkey" for table "plateannotationlink"
NOTICE:  CREATE TABLE / UNIQUE will create implicit index 
"plateannotationlink_external_id_key" for table "plateannotationlink"
NOTICE:  CREATE TABLE / UNIQUE will create implicit index 
"plateannotationlink_parent_key" for table "plateannotationlink"
CREATE TABLE
NOTICE:  CREATE TABLE / PRIMARY KEY will create implicit index 
"project_pkey" for table "project"
NOTICE:  CREATE TABLE / UNIQUE will create implicit index 
"project_external_id_key" for table "project"
CREATE TABLE
NOTICE:  CREATE TABLE / PRIMARY KEY will create implicit index 
"projectannotationlink_pkey" for table "projectannotationlink"
NOTICE:  CREATE TABLE / UNIQUE will create implicit index 
"projectannotationlink_external_id_key" for table "projectannotationlink"
NOTICE:  CREATE TABLE / UNIQUE will create implicit index 
"projectannotationlink_parent_key" for table "projectannotationlink"
CREATE TABLE
NOTICE:  CREATE TABLE / PRIMARY KEY will create implicit index 
"projectdatasetlink_pkey" for table "projectdatasetlink"
NOTICE:  CREATE TABLE / UNIQUE will create implicit index 
"projectdatasetlink_external_id_key" for table "projectdatasetlink"
NOTICE:  CREATE TABLE / UNIQUE will create implicit index 
"projectdatasetlink_parent_key" for table "projectdatasetlink"
CREATE TABLE
NOTICE:  CREATE TABLE / PRIMARY KEY will create implicit index "pulse_pkey" 
for table "pulse"
NOTICE:  CREATE TABLE / UNIQUE will create implicit index "pulse_value_key" 
for table "pulse"
NOTICE:  CREATE TABLE / UNIQUE will create implicit index 
"pulse_external_id_key" for table "pulse"
CREATE TABLE
NOTICE:  CREATE TABLE / PRIMARY KEY will create implicit index 
"quantumdef_pkey" for table "quantumdef"
NOTICE:  CREATE TABLE / UNIQUE will create implicit index 
"quantumdef_external_id_key" for table "quantumdef"
CREATE TABLE
NOTICE:  CREATE TABLE / PRIMARY KEY will create implicit index 
"reagent_pkey" for table "reagent"
NOTICE:  CREATE TABLE / UNIQUE will create implicit index 
"reagent_external_id_key" for table "reagent"
CREATE TABLE
NOTICE:  CREATE TABLE / PRIMARY KEY will create implicit index 
"reagentannotationlink_pkey" for table "reagentannotationlink"
NOTICE:  CREATE TABLE / UNIQUE will create implicit index 
"reagentannotationlink_external_id_key" for table "reagentannotationlink"
NOTICE:  CREATE TABLE / UNIQUE will create implicit index 
"reagentannotationlink_parent_key" for table "reagentannotationlink"
CREATE TABLE
NOTICE:  CREATE TABLE / PRIMARY KEY will create implicit index 
"renderingdef_pkey" for table "renderingdef"
NOTICE:  CREATE TABLE / UNIQUE will create implicit index 
"renderingdef_external_id_key" for table "renderingdef"
CREATE TABLE
NOTICE:  CREATE TABLE / PRIMARY KEY will create implicit index 
"renderingmodel_pkey" for table "renderingmodel"
NOTICE:  CREATE TABLE / UNIQUE will create implicit index 
"renderingmodel_value_key" for table "renderingmodel"
NOTICE:  CREATE TABLE / UNIQUE will create implicit index 
"renderingmodel_external_id_key" for table "renderingmodel"
CREATE TABLE
NOTICE:  CREATE TABLE / PRIMARY KEY will create implicit index 
"reverseintensitycontext_pkey" for table "reverseintensitycontext"
CREATE TABLE
NOTICE:  CREATE TABLE / PRIMARY KEY will create implicit index "screen_pkey" 
for table "screen"
NOTICE:  CREATE TABLE / UNIQUE will create implicit index 
"screen_external_id_key" for table "screen"
CREATE TABLE
NOTICE:  CREATE TABLE / PRIMARY KEY will create implicit index 
"screenacquisition_pkey" for table "screenacquisition"
NOTICE:  CREATE TABLE / UNIQUE will create implicit index 
"screenacquisition_external_id_key" for table "screenacquisition"
CREATE TABLE
NOTICE:  CREATE TABLE / PRIMARY KEY will create implicit index 
"screenacquisitionannotationlink_pkey" for table 
"screenacquisitionannotationlink"
NOTICE:  CREATE TABLE / UNIQUE will create implicit index 
"screenacquisitionannotationlink_external_id_key" for table 
"screenacquisitionannotationlink"
NOTICE:  CREATE TABLE / UNIQUE will create implicit index 
"screenacquisitionannotationlink_parent_key" for table 
"screenacquisitionannotationlink"
CREATE TABLE
NOTICE:  CREATE TABLE / PRIMARY KEY will create implicit index 
"screenacquisitionwellsamplelink_pkey" for table 
"screenacquisitionwellsamplelink"
NOTICE:  CREATE TABLE / UNIQUE will create implicit index 
"screenacquisitionwellsamplelink_external_id_key" for table 
"screenacquisitionwellsamplelink"
NOTICE:  CREATE TABLE / UNIQUE will create implicit index 
"screenacquisitionwellsamplelink_parent_key" for table 
"screenacquisitionwellsamplelink"
CREATE TABLE
NOTICE:  CREATE TABLE / PRIMARY KEY will create implicit index 
"screenannotationlink_pkey" for table "screenannotationlink"
NOTICE:  CREATE TABLE / UNIQUE will create implicit index 
"screenannotationlink_external_id_key" for table "screenannotationlink"
NOTICE:  CREATE TABLE / UNIQUE will create implicit index 
"screenannotationlink_parent_key" for table "screenannotationlink"
CREATE TABLE
NOTICE:  CREATE TABLE / PRIMARY KEY will create implicit index 
"screenplatelink_pkey" for table "screenplatelink"
NOTICE:  CREATE TABLE / UNIQUE will create implicit index 
"screenplatelink_external_id_key" for table "screenplatelink"
NOTICE:  CREATE TABLE / UNIQUE will create implicit index 
"screenplatelink_parent_key" for table "screenplatelink"
CREATE TABLE
NOTICE:  CREATE TABLE / PRIMARY KEY will create implicit index 
"scriptjob_pkey" for table "scriptjob"
CREATE TABLE
NOTICE:  CREATE TABLE / PRIMARY KEY will create implicit index 
"session_pkey" for table "session"
NOTICE:  CREATE TABLE / UNIQUE will create implicit index 
"session_external_id_key" for table "session"
CREATE TABLE
NOTICE:  CREATE TABLE / PRIMARY KEY will create implicit index 
"sessionannotationlink_pkey" for table "sessionannotationlink"
NOTICE:  CREATE TABLE / UNIQUE will create implicit index 
"sessionannotationlink_external_id_key" for table "sessionannotationlink"
NOTICE:  CREATE TABLE / UNIQUE will create implicit index 
"sessionannotationlink_parent_key" for table "sessionannotationlink"
CREATE TABLE
NOTICE:  CREATE TABLE / PRIMARY KEY will create implicit index "share_pkey" 
for table "share"
CREATE TABLE
NOTICE:  CREATE TABLE / PRIMARY KEY will create implicit index 
"sharemember_pkey" for table "sharemember"
NOTICE:  CREATE TABLE / UNIQUE will create implicit index 
"sharemember_external_id_key" for table "sharemember"
NOTICE:  CREATE TABLE / UNIQUE will create implicit index 
"sharemember_parent_key" for table "sharemember"
CREATE TABLE
NOTICE:  CREATE TABLE / PRIMARY KEY will create implicit index 
"stagelabel_pkey" for table "stagelabel"
NOTICE:  CREATE TABLE / UNIQUE will create implicit index 
"stagelabel_external_id_key" for table "stagelabel"
CREATE TABLE
NOTICE:  CREATE TABLE / PRIMARY KEY will create implicit index 
"statsinfo_pkey" for table "statsinfo"
NOTICE:  CREATE TABLE / UNIQUE will create implicit index 
"statsinfo_external_id_key" for table "statsinfo"
CREATE TABLE
NOTICE:  CREATE TABLE / PRIMARY KEY will create implicit index 
"thumbnail_pkey" for table "thumbnail"
NOTICE:  CREATE TABLE / UNIQUE will create implicit index 
"thumbnail_external_id_key" for table "thumbnail"
CREATE TABLE
NOTICE:  CREATE TABLE / PRIMARY KEY will create implicit index 
"transmittancerange_pkey" for table "transmittancerange"
NOTICE:  CREATE TABLE / UNIQUE will create implicit index 
"transmittancerange_external_id_key" for table "transmittancerange"
CREATE TABLE
NOTICE:  CREATE TABLE / PRIMARY KEY will create implicit index "well_pkey" 
for table "well"
NOTICE:  CREATE TABLE / UNIQUE will create implicit index 
"well_external_id_key" for table "well"
CREATE TABLE
NOTICE:  CREATE TABLE / PRIMARY KEY will create implicit index 
"wellannotationlink_pkey" for table "wellannotationlink"
NOTICE:  CREATE TABLE / UNIQUE will create implicit index 
"wellannotationlink_external_id_key" for table "wellannotationlink"
NOTICE:  CREATE TABLE / UNIQUE will create implicit index 
"wellannotationlink_parent_key" for table "wellannotationlink"
CREATE TABLE
NOTICE:  CREATE TABLE / PRIMARY KEY will create implicit index 
"wellreagentlink_pkey" for table "wellreagentlink"
NOTICE:  CREATE TABLE / UNIQUE will create implicit index 
"wellreagentlink_external_id_key" for table "wellreagentlink"
NOTICE:  CREATE TABLE / UNIQUE will create implicit index 
"wellreagentlink_parent_key" for table "wellreagentlink"
CREATE TABLE
NOTICE:  CREATE TABLE / PRIMARY KEY will create implicit index 
"wellsample_pkey" for table "wellsample"
NOTICE:  CREATE TABLE / UNIQUE will create implicit index 
"wellsample_external_id_key" for table "wellsample"
NOTICE:  CREATE TABLE / UNIQUE will create implicit index 
"wellsample_well_key" for table "wellsample"
CREATE TABLE
NOTICE:  CREATE TABLE / PRIMARY KEY will create implicit index 
"wellsampleannotationlink_pkey" for table "wellsampleannotationlink"
NOTICE:  CREATE TABLE / UNIQUE will create implicit index 
"wellsampleannotationlink_external_id_key" for table 
"wellsampleannotationlink"
NOTICE:  CREATE TABLE / UNIQUE will create implicit index 
"wellsampleannotationlink_parent_key" for table "wellsampleannotationlink"
CREATE TABLE
ALTER TABLE
ALTER TABLE
ALTER TABLE
ALTER TABLE
ALTER TABLE
ALTER TABLE
ALTER TABLE
ALTER TABLE
ALTER TABLE
ALTER TABLE
ALTER TABLE
ALTER TABLE
ALTER TABLE
ALTER TABLE
ALTER TABLE
ALTER TABLE
ALTER TABLE
ALTER TABLE
ALTER TABLE
ALTER TABLE
ALTER TABLE
ALTER TABLE
ALTER TABLE
ALTER TABLE
ALTER TABLE
ALTER TABLE
ALTER TABLE
ALTER TABLE
ALTER TABLE
ALTER TABLE
ALTER TABLE
ALTER TABLE
ALTER TABLE
ALTER TABLE
ALTER TABLE
ALTER TABLE
ALTER TABLE
ALTER TABLE
ALTER TABLE
ALTER TABLE
ALTER TABLE
ALTER TABLE
ALTER TABLE
ALTER TABLE
ALTER TABLE
ALTER TABLE
ALTER TABLE
ALTER TABLE
ALTER TABLE
ALTER TABLE
ALTER TABLE
ALTER TABLE
ALTER TABLE
ALTER TABLE
ALTER TABLE
ALTER TABLE
ALTER TABLE
ALTER TABLE
ALTER TABLE
ALTER TABLE
NOTICE:  identifier 
"fkcontraststretchingcontext_codomainmapcontext_id_codomainmapcontext" will 
be truncated to 
"fkcontraststretchingcontext_codomainmapcontext_id_codomainmapco"
ALTER TABLE
ALTER TABLE
ALTER TABLE
ALTER TABLE
ALTER TABLE
ALTER TABLE
ALTER TABLE
ALTER TABLE
ALTER TABLE
ALTER TABLE
ALTER TABLE
ALTER TABLE
ALTER TABLE
ALTER TABLE
ALTER TABLE
ALTER TABLE
ALTER TABLE
ALTER TABLE
ALTER TABLE
ALTER TABLE
ALTER TABLE
ALTER TABLE
ALTER TABLE
ALTER TABLE
ALTER TABLE
ALTER TABLE
ALTER TABLE
ALTER TABLE
ALTER TABLE
ALTER TABLE
ALTER TABLE
ALTER TABLE
ALTER TABLE
ALTER TABLE
ALTER TABLE
ALTER TABLE
ALTER TABLE
ALTER TABLE
ALTER TABLE
ALTER TABLE
ALTER TABLE
ALTER TABLE
ALTER TABLE
ALTER TABLE
ALTER TABLE
ALTER TABLE
ALTER TABLE
ALTER TABLE
ALTER TABLE
ALTER TABLE
ALTER TABLE
ALTER TABLE
ALTER TABLE
ALTER TABLE
ALTER TABLE
ALTER TABLE
ALTER TABLE
ALTER TABLE
ALTER TABLE
ALTER TABLE
ALTER TABLE
ALTER TABLE
ALTER TABLE
ALTER TABLE
ALTER TABLE
ALTER TABLE
ALTER TABLE
ALTER TABLE
ALTER TABLE
ALTER TABLE
ALTER TABLE
ALTER TABLE
ALTER TABLE
ALTER TABLE
ALTER TABLE
ALTER TABLE
ALTER TABLE
ALTER TABLE
ALTER TABLE
ALTER TABLE
ALTER TABLE
ALTER TABLE
ALTER TABLE
ALTER TABLE
ALTER TABLE
ALTER TABLE
ALTER TABLE
ALTER TABLE
ALTER TABLE
ALTER TABLE
ALTER TABLE
ALTER TABLE
ALTER TABLE
ALTER TABLE
ALTER TABLE
ALTER TABLE
ALTER TABLE
ALTER TABLE
ALTER TABLE
ALTER TABLE
ALTER TABLE
ALTER TABLE
ALTER TABLE
ALTER TABLE
ALTER TABLE
ALTER TABLE
ALTER TABLE
ALTER TABLE
ALTER TABLE
ALTER TABLE
ALTER TABLE
ALTER TABLE
ALTER TABLE
ALTER TABLE
ALTER TABLE
ALTER TABLE
ALTER TABLE
ALTER TABLE
ALTER TABLE
ALTER TABLE
ALTER TABLE
ALTER TABLE
ALTER TABLE
ALTER TABLE
ALTER TABLE
ALTER TABLE
ALTER TABLE
ALTER TABLE
ALTER TABLE
ALTER TABLE
ALTER TABLE
ALTER TABLE
ALTER TABLE
ALTER TABLE
ALTER TABLE
ALTER TABLE
ALTER TABLE
ALTER TABLE
ALTER TABLE
ALTER TABLE
ALTER TABLE
ALTER TABLE
ALTER TABLE
ALTER TABLE
ALTER TABLE
ALTER TABLE
ALTER TABLE
ALTER TABLE
ALTER TABLE
ALTER TABLE
ALTER TABLE
ALTER TABLE
ALTER TABLE
ALTER TABLE
ALTER TABLE
ALTER TABLE
ALTER TABLE
ALTER TABLE
ALTER TABLE
ALTER TABLE
ALTER TABLE
ALTER TABLE
ALTER TABLE
ALTER TABLE
ALTER TABLE
ALTER TABLE
ALTER TABLE
ALTER TABLE
ALTER TABLE
ALTER TABLE
ALTER TABLE
ALTER TABLE
ALTER TABLE
ALTER TABLE
ALTER TABLE
ALTER TABLE
ALTER TABLE
ALTER TABLE
ALTER TABLE
ALTER TABLE
ALTER TABLE
ALTER TABLE
ALTER TABLE
ALTER TABLE
ALTER TABLE
ALTER TABLE
ALTER TABLE
ALTER TABLE
ALTER TABLE
ALTER TABLE
ALTER TABLE
ALTER TABLE
ALTER TABLE
ALTER TABLE
ALTER TABLE
ALTER TABLE
ALTER TABLE
ALTER TABLE
ALTER TABLE
ALTER TABLE
ALTER TABLE
ALTER TABLE
ALTER TABLE
ALTER TABLE
ALTER TABLE
ALTER TABLE
ALTER TABLE
ALTER TABLE
ALTER TABLE
ALTER TABLE
ALTER TABLE
ALTER TABLE
ALTER TABLE
ALTER TABLE
ALTER TABLE
ALTER TABLE
ALTER TABLE
ALTER TABLE
ALTER TABLE
ALTER TABLE
ALTER TABLE
ALTER TABLE
ALTER TABLE
ALTER TABLE
ALTER TABLE
ALTER TABLE
ALTER TABLE
ALTER TABLE
ALTER TABLE
ALTER TABLE
ALTER TABLE
ALTER TABLE
ALTER TABLE
ALTER TABLE
ALTER TABLE
ALTER TABLE
ALTER TABLE
ALTER TABLE
ALTER TABLE
ALTER TABLE
ALTER TABLE
ALTER TABLE
ALTER TABLE
ALTER TABLE
ALTER TABLE
ALTER TABLE
ALTER TABLE
ALTER TABLE
ALTER TABLE
ALTER TABLE
ALTER TABLE
ALTER TABLE
ALTER TABLE
ALTER TABLE
ALTER TABLE
ALTER TABLE
ALTER TABLE
ALTER TABLE
ALTER TABLE
ALTER TABLE
ALTER TABLE
ALTER TABLE
ALTER TABLE
ALTER TABLE
ALTER TABLE
ALTER TABLE
ALTER TABLE
ALTER TABLE
ALTER TABLE
ALTER TABLE
ALTER TABLE
ALTER TABLE
ALTER TABLE
ALTER TABLE
NOTICE:  identifier 
"fklogicalchannel_photometricinterpretation_photometricinterpretation" will 
be truncated to 
"fklogicalchannel_photometricinterpretation_photometricinterpret"
ALTER TABLE
ALTER TABLE
ALTER TABLE
ALTER TABLE
ALTER TABLE
ALTER TABLE
ALTER TABLE
ALTER TABLE
ALTER TABLE
ALTER TABLE
ALTER TABLE
ALTER TABLE
ALTER TABLE
ALTER TABLE
ALTER TABLE
ALTER TABLE
ALTER TABLE
ALTER TABLE
ALTER TABLE
ALTER TABLE
ALTER TABLE
ALTER TABLE
ALTER TABLE
ALTER TABLE
ALTER TABLE
ALTER TABLE
ALTER TABLE
ALTER TABLE
ALTER TABLE
ALTER TABLE
ALTER TABLE
ALTER TABLE
ALTER TABLE
ALTER TABLE
ALTER TABLE
ALTER TABLE
ALTER TABLE
ALTER TABLE
ALTER TABLE
ALTER TABLE
ALTER TABLE
ALTER TABLE
ALTER TABLE
ALTER TABLE
ALTER TABLE
ALTER TABLE
ALTER TABLE
ALTER TABLE
ALTER TABLE
ALTER TABLE
ALTER TABLE
ALTER TABLE
ALTER TABLE
ALTER TABLE
ALTER TABLE
ALTER TABLE
ALTER TABLE
ALTER TABLE
ALTER TABLE
ALTER TABLE
ALTER TABLE
ALTER TABLE
ALTER TABLE
ALTER TABLE
ALTER TABLE
ALTER TABLE
ALTER TABLE
ALTER TABLE
ALTER TABLE
ALTER TABLE
ALTER TABLE
ALTER TABLE
ALTER TABLE
ALTER TABLE
ALTER TABLE
ALTER TABLE
ALTER TABLE
ALTER TABLE
ALTER TABLE
ALTER TABLE
ALTER TABLE
ALTER TABLE
ALTER TABLE
ALTER TABLE
ALTER TABLE
ALTER TABLE
ALTER TABLE
ALTER TABLE
ALTER TABLE
ALTER TABLE
ALTER TABLE
ALTER TABLE
ALTER TABLE
ALTER TABLE
ALTER TABLE
ALTER TABLE
ALTER TABLE
ALTER TABLE
ALTER TABLE
ALTER TABLE
ALTER TABLE
ALTER TABLE
ALTER TABLE
ALTER TABLE
ALTER TABLE
ALTER TABLE
ALTER TABLE
ALTER TABLE
ALTER TABLE
ALTER TABLE
ALTER TABLE
ALTER TABLE
ALTER TABLE
ALTER TABLE
ALTER TABLE
ALTER TABLE
ALTER TABLE
ALTER TABLE
ALTER TABLE
ALTER TABLE
ALTER TABLE
ALTER TABLE
ALTER TABLE
ALTER TABLE
ALTER TABLE
ALTER TABLE
ALTER TABLE
ALTER TABLE
ALTER TABLE
ALTER TABLE
ALTER TABLE
ALTER TABLE
ALTER TABLE
ALTER TABLE
ALTER TABLE
ALTER TABLE
ALTER TABLE
ALTER TABLE
ALTER TABLE
ALTER TABLE
ALTER TABLE
ALTER TABLE
ALTER TABLE
ALTER TABLE
ALTER TABLE
ALTER TABLE
ALTER TABLE
ALTER TABLE
ALTER TABLE
ALTER TABLE
ALTER TABLE
ALTER TABLE
ALTER TABLE
ALTER TABLE
ALTER TABLE
ALTER TABLE
ALTER TABLE
ALTER TABLE
ALTER TABLE
ALTER TABLE
ALTER TABLE
ALTER TABLE
ALTER TABLE
ALTER TABLE
ALTER TABLE
ALTER TABLE
ALTER TABLE
ALTER TABLE
ALTER TABLE
ALTER TABLE
ALTER TABLE
ALTER TABLE
ALTER TABLE
ALTER TABLE
ALTER TABLE
ALTER TABLE
ALTER TABLE
ALTER TABLE
ALTER TABLE
ALTER TABLE
ALTER TABLE
NOTICE:  identifier 
"fkreverseintensitycontext_codomainmapcontext_id_codomainmapcontext" will be 
truncated to 
"fkreverseintensitycontext_codomainmapcontext_id_codomainmapcont"
ALTER TABLE
ALTER TABLE
ALTER TABLE
ALTER TABLE
ALTER TABLE
ALTER TABLE
ALTER TABLE
ALTER TABLE
ALTER TABLE
ALTER TABLE
ALTER TABLE
ALTER TABLE
ALTER TABLE
ALTER TABLE
ALTER TABLE
ALTER TABLE
ALTER TABLE
ALTER TABLE
ALTER TABLE
ALTER TABLE
ALTER TABLE
ALTER TABLE
ALTER TABLE
ALTER TABLE
ALTER TABLE
ALTER TABLE
ALTER TABLE
ALTER TABLE
ALTER TABLE
ALTER TABLE
ALTER TABLE
ALTER TABLE
ALTER TABLE
ALTER TABLE
ALTER TABLE
ALTER TABLE
ALTER TABLE
ALTER TABLE
ALTER TABLE
ALTER TABLE
ALTER TABLE
ALTER TABLE
ALTER TABLE
ALTER TABLE
ALTER TABLE
ALTER TABLE
ALTER TABLE
ALTER TABLE
ALTER TABLE
ALTER TABLE
ALTER TABLE
ALTER TABLE
ALTER TABLE
ALTER TABLE
ALTER TABLE
ALTER TABLE
ALTER TABLE
ALTER TABLE
ALTER TABLE
ALTER TABLE
ALTER TABLE
ALTER TABLE
ALTER TABLE
ALTER TABLE
ALTER TABLE
ALTER TABLE
ALTER TABLE
ALTER TABLE
ALTER TABLE
ALTER TABLE
ALTER TABLE
ALTER TABLE
ALTER TABLE
ALTER TABLE
ALTER TABLE
ALTER TABLE
ALTER TABLE
ALTER TABLE
ALTER TABLE
ALTER TABLE
ALTER TABLE
ALTER TABLE
ALTER TABLE
ALTER TABLE
ALTER TABLE
ALTER TABLE
ALTER TABLE
ALTER TABLE
ALTER TABLE
ALTER TABLE
ALTER TABLE
ALTER TABLE
ALTER TABLE
ALTER TABLE
ALTER TABLE
ALTER TABLE
ALTER TABLE
ALTER TABLE
ALTER TABLE
ALTER TABLE
ALTER TABLE
ALTER TABLE
ALTER TABLE
ALTER TABLE
ALTER TABLE
ALTER TABLE
ALTER TABLE
ALTER TABLE
ALTER TABLE
ALTER TABLE
ALTER TABLE
ALTER TABLE
ALTER TABLE
ALTER TABLE
CREATE TABLE
SET CONSTRAINTS
CREATE FUNCTION
CREATE FUNCTION
NOTICE:  ALTER TABLE / ADD PRIMARY KEY will create implicit index 
"seq_table_pkey" for table "seq_table"
ALTER TABLE
NOTICE:  ALTER TABLE / ADD UNIQUE will create implicit index 
"unique_dbpatch" for table "dbpatch"
ALTER TABLE
ALTER TABLE
ALTER TABLE
ALTER TABLE
INSERT 0 1
INSERT 0 1
INSERT 0 1
INSERT 0 1
INSERT 0 1
INSERT 0 1
INSERT 0 1
INSERT 0 1
INSERT 0 1
INSERT 0 1
INSERT 0 1
INSERT 0 1
INSERT 0 1
INSERT 0 1
INSERT 0 1
UPDATE 1
UPDATE 1
ALTER TABLE
ALTER TABLE
INSERT 0 1
INSERT 0 1
INSERT 0 1
INSERT 0 1
INSERT 0 1
INSERT 0 1
INSERT 0 1
INSERT 0 1
INSERT 0 1
INSERT 0 1
INSERT 0 1
INSERT 0 1
INSERT 0 1
INSERT 0 1
INSERT 0 1
INSERT 0 1
INSERT 0 1
INSERT 0 1
INSERT 0 1
INSERT 0 1
INSERT 0 1
INSERT 0 1
INSERT 0 1
INSERT 0 1
INSERT 0 1
INSERT 0 1
INSERT 0 1
INSERT 0 1
INSERT 0 1
INSERT 0 1
INSERT 0 1
INSERT 0 1
INSERT 0 1
INSERT 0 1
INSERT 0 1
INSERT 0 1
INSERT 0 1
INSERT 0 1
INSERT 0 1
INSERT 0 1
INSERT 0 1
INSERT 0 1
INSERT 0 1
INSERT 0 1
INSERT 0 1
INSERT 0 1
INSERT 0 1
INSERT 0 1
INSERT 0 1
INSERT 0 1
INSERT 0 1
INSERT 0 1
INSERT 0 1
INSERT 0 1
INSERT 0 1
INSERT 0 1
INSERT 0 1
INSERT 0 1
INSERT 0 1
INSERT 0 1
INSERT 0 1
INSERT 0 1
INSERT 0 1
INSERT 0 1
INSERT 0 1
INSERT 0 1
INSERT 0 1
INSERT 0 1
INSERT 0 1
INSERT 0 1
INSERT 0 1
INSERT 0 1
INSERT 0 1
INSERT 0 1
INSERT 0 1
INSERT 0 1
INSERT 0 1
INSERT 0 1
INSERT 0 1
INSERT 0 1
INSERT 0 1
INSERT 0 1
INSERT 0 1
INSERT 0 1
INSERT 0 1
INSERT 0 1
INSERT 0 1
INSERT 0 1
INSERT 0 1
INSERT 0 1
INSERT 0 1
INSERT 0 1
INSERT 0 1
INSERT 0 1
INSERT 0 1
INSERT 0 1
INSERT 0 1
INSERT 0 1
INSERT 0 1
INSERT 0 1
INSERT 0 1
INSERT 0 1
INSERT 0 1
INSERT 0 1
INSERT 0 1
INSERT 0 1
INSERT 0 1
INSERT 0 1
INSERT 0 1
INSERT 0 1
INSERT 0 1
INSERT 0 1
INSERT 0 1
INSERT 0 1
INSERT 0 1
INSERT 0 1
INSERT 0 1
INSERT 0 1
INSERT 0 1
INSERT 0 1
INSERT 0 1
INSERT 0 1
INSERT 0 1
INSERT 0 1
INSERT 0 1
INSERT 0 1
INSERT 0 1
INSERT 0 1
INSERT 0 1
INSERT 0 1
INSERT 0 1
INSERT 0 1
INSERT 0 1
INSERT 0 1
INSERT 0 1
INSERT 0 1
INSERT 0 1
INSERT 0 1
INSERT 0 1
INSERT 0 1
INSERT 0 1
INSERT 0 1
INSERT 0 1
INSERT 0 1
INSERT 0 1
INSERT 0 1
INSERT 0 1
INSERT 0 1
INSERT 0 1
INSERT 0 1
INSERT 0 1
INSERT 0 1
INSERT 0 1
INSERT 0 1
INSERT 0 1
INSERT 0 1
INSERT 0 1
INSERT 0 1
INSERT 0 1
INSERT 0 1
INSERT 0 1
INSERT 0 1
INSERT 0 1
INSERT 0 1
INSERT 0 1
INSERT 0 1
INSERT 0 1
INSERT 0 1
INSERT 0 1
INSERT 0 1
INSERT 0 1
INSERT 0 1
INSERT 0 1
INSERT 0 1
INSERT 0 1
INSERT 0 1
INSERT 0 1
INSERT 0 1
INSERT 0 1
INSERT 0 1
INSERT 0 1
INSERT 0 1
INSERT 0 1
INSERT 0 1
INSERT 0 1
INSERT 0 1
INSERT 0 1
INSERT 0 1
INSERT 0 1
INSERT 0 1
INSERT 0 1
INSERT 0 1
INSERT 0 1
INSERT 0 1
INSERT 0 1
INSERT 0 1
INSERT 0 1
INSERT 0 1
INSERT 0 1
INSERT 0 1
INSERT 0 1
INSERT 0 1
INSERT 0 1
INSERT 0 1
INSERT 0 1
INSERT 0 1
INSERT 0 1
INSERT 0 1
INSERT 0 1
INSERT 0 1
INSERT 0 1
INSERT 0 1
INSERT 0 1
INSERT 0 1
INSERT 0 1
INSERT 0 1
INSERT 0 1
INSERT 0 1
INSERT 0 1
INSERT 0 1
INSERT 0 1
INSERT 0 1
INSERT 0 1
INSERT 0 1
INSERT 0 1
INSERT 0 1
INSERT 0 1
INSERT 0 1
INSERT 0 1
INSERT 0 1
INSERT 0 1
INSERT 0 1
INSERT 0 1
INSERT 0 1
INSERT 0 1
INSERT 0 1
INSERT 0 1
INSERT 0 1
INSERT 0 1
INSERT 0 1
INSERT 0 1
INSERT 0 1
INSERT 0 1
INSERT 0 1
INSERT 0 1
INSERT 0 1
INSERT 0 1
INSERT 0 1
INSERT 0 1
INSERT 0 1
INSERT 0 1
INSERT 0 1
INSERT 0 1
INSERT 0 1
INSERT 0 1
INSERT 0 1
INSERT 0 1
INSERT 0 1
INSERT 0 1
INSERT 0 1
INSERT 0 1
INSERT 0 1
INSERT 0 1
INSERT 0 1
INSERT 0 1
INSERT 0 1
INSERT 0 1
INSERT 0 1
INSERT 0 1
INSERT 0 1
INSERT 0 1
INSERT 0 1
INSERT 0 1
INSERT 0 1
INSERT 0 1
INSERT 0 1
INSERT 0 1
INSERT 0 1
INSERT 0 1
INSERT 0 1
INSERT 0 1
INSERT 0 1
INSERT 0 1
INSERT 0 1
INSERT 0 1
INSERT 0 1
INSERT 0 1
INSERT 0 1
INSERT 0 1
INSERT 0 1
INSERT 0 1
INSERT 0 1
INSERT 0 1
INSERT 0 1
INSERT 0 1
INSERT 0 1
INSERT 0 1
INSERT 0 1
INSERT 0 1
INSERT 0 1
INSERT 0 1
INSERT 0 1
NOTICE:  CREATE TABLE / PRIMARY KEY will create implicit index 
"configuration_pkey" for table "configuration"
CREATE TABLE
ALTER TABLE
ALTER TABLE
ALTER TABLE
NOTICE:  CREATE TABLE / UNIQUE will create implicit index 
"password_experimenter_id_key" for table "password"
CREATE TABLE
INSERT 0 1
INSERT 0 1
UPDATE 1
DROP TABLE
CREATE VIEW
DROP TABLE
CREATE VIEW
CREATE FUNCTION
CREATE TRIGGER
DROP TABLE
CREATE VIEW
DROP TABLE
CREATE VIEW
CREATE FUNCTION
CREATE TRIGGER
DROP TABLE
CREATE VIEW
DROP TABLE
CREATE VIEW
CREATE FUNCTION
CREATE TRIGGER
DROP TABLE
CREATE VIEW
DROP TABLE
CREATE VIEW
DROP TABLE
CREATE VIEW
DROP TABLE
CREATE VIEW
DROP TABLE
CREATE VIEW
DROP TABLE
CREATE VIEW
DROP TABLE
CREATE VIEW
DROP TABLE
CREATE VIEW
DROP TABLE
CREATE VIEW
CREATE FUNCTION
CREATE TRIGGER
DROP TABLE
CREATE VIEW
DROP TABLE
CREATE VIEW
DROP TABLE
CREATE VIEW
CREATE FUNCTION
CREATE TRIGGER
DROP TABLE
CREATE VIEW
DROP TABLE
CREATE VIEW
DROP TABLE
CREATE VIEW
DROP TABLE
CREATE VIEW
DROP TABLE
CREATE VIEW
DROP TABLE
CREATE VIEW
DROP TABLE
CREATE VIEW
CREATE FUNCTION
CREATE TRIGGER
DROP TABLE
CREATE VIEW
DROP TABLE
CREATE VIEW
DROP TABLE
CREATE VIEW
DROP TABLE
CREATE VIEW
DROP TABLE
CREATE VIEW
DROP TABLE
CREATE VIEW
DROP TABLE
CREATE VIEW
DROP TABLE
CREATE VIEW
CREATE FUNCTION
COMMIT
d-128-15-155:omero_dist gordonlaurie$ bin/omero admin start
Creating /usr/share/omero/omero_dist/var/master
Initializing /usr/share/omero/omero_dist/var/log
Creating /usr/share/omero/omero_dist/var/registry
No descriptor given. Using etc/grid/default.xml
Waiting on startup. Use CTRL-C to exit
....bin/omero admin ice.^R
bin/omero admin ice
.........
...............Failed to startup after 5 minutes
d-128-15-155:omero_dist gordonlaurie$ bin/omero admin ice
Ice 3.3.1  Copyright 2003-2009 ZeroC, Inc.
>>> 
>>> bin/omero admin ice
error: syntax error
unknown `bin/omero' command (see `help' for more info)
>>> server enable Web
>>> server start Web
>>> 





On Mon, 22 Jun 2009 21:11:37 +0200
  josh.moore at gmx.de wrote:
> 
> Sure, no problem. var/log/Blitz-0.log is the file written to by the
> server after you run:
> 
>  bin/omero admin start
> 
> You can also just zip up the entire var/log directory if you'd like.
> 
> ~j.
> 
> 
> Gordon Laurie writes:
> > Thanks.  Is this the record from Terminal-icegridadmin?
> > 
> > Gordon.
> > 
> > 
> > 
> > >Hi Gordon,
> > >
> > >Could you possibly send us the var/log/Blitz-0.log file? My assumption
> > >is that your server isn't completely up and running yet. Thanks!
> > >
> > >~J.
> > >
> > >Gordon Laurie writes:
> > >  > I just installed Omero 4.0.3 (Unix) and have the server started.
> > >  > Unexpectedly I am stuck on the login page for OMERO.webadmin with 
>the
> > >  > error message 'Error: PermissionDeniedException' after entering 
>root
> > >  > for username and the same password as was entered during the
> > >  > installation for new OMERO root user.  Password is 8 digits long.
> > >  >
> > >  > Any suggestions?
> > 

Gordon W. Laurie, PhD
Associate Professor
Department of Cell Biology
Director, Biotechnology Training Program
University of Virginia