[ome-users] Cannot see images (big damage recovered...)
Ilya Goldberg
igg at nih.gov
Tue Nov 27 17:58:23 GMT 2007
On Nov 26, 2007, at 12:32 PM, Mario Valle wrote:
> Ta da!
> There are two enties for image_server_url!
>
> ome=# select image_server_url from repositories;
> image_server_url
> ------------------------------------
> http://horus.cscs.ch/cgi-bin/omeis
> http://horus17/cgi-bin/omeis
> (2 rows)
>
> I cannot delete the 2nd line nor change it to have the same value
> as the first one.
> So I simply updated it to an alias of the host name.
Unfortunately, image_server_url has a unique constraint, so you can't
have duplicate values in there.
Also, you can't delete it because there are references to this row in
other tables.
image_pixels and original_files should be the only two tables with
references to repositories. You can re-assign the repositories in
those tables to 'http://horus.cscs.ch/cgi-bin/omeis', which will let
you delete 'http://horus17/cgi-bin/omeis'.
-Ilya
>
> Ugly, but works.
>
> Thanks to all!
> mario
>
> Curtis Rueden wrote:
>> Hi Mario,
>>
>>> Why the omeis_url changed with ome admin configuration is not
>>> updated?
>>> Beside restarting apache and postgtes, what else should I do to
>>> make the change active?
>>
>> I do not know too much about this, but you can check whether the
>> changes took effect in your DB:
>>
>> % psql ome
>>
>> ome=# select image_server_url from repositories;
>> image_server_url
>> --------------------------------------------------
>> http://skyking.microscopy.wisc.edu/cgi-bin/omeis
>> (1 row)
>>
>> ome=# select value from configuration where name='lsid_authority';
>> value
>> -----------------------------
>> skyking.microscopy.wisc.edu
>> (1 row)
>>
>> -Curtis
>>
>> On Nov 26, 2007 7:42 AM, Mario Valle <mvalle at cscs.ch> wrote:
>>> Thanks Markus in pointing me in the right direction!
>>> I have added a line to my workstation /etc/hosts file
>>> xx.xx.xx.xx horus17
>>> and now I see my images inside OME!
>>>
>>> Well, it is a temporary workaround.
>>> so the real question now is:
>>>
>>> Why the omeis_url changed with ome admin configuration is not
>>> updated?
>>> Beside restarting apache and postgtes, what else should I do to
>>> make the change active?
>>> Thanks!
>>> mario
>>>
>>> Markus Dorn wrote:
>>>> Hi Mario,
>>>>
>>>> maybe you need an alias for horus <-> horus17 in /etc/hosts?
>>>> Maybe have
>>>> a look into the generated html page in the browser to see where
>>>> ome is
>>>> looking for the pictures (left click in browser-show source and
>>>> search for an img tag). In our version it looks like that: <img
>>>> src="http://ome.kip.uni-heidelberg.de/cgi-bin/omeis?
>>>> Method=GetThumb&PixelsID=12"
>>>> Usemap="#Image12">
>>>>
>>>> Hope this points you maybe in the right direction :-)
>>>>
>>>> Markus
>>>>
>>>> Mario Valle <mvalle at cscs.ch> wrote:
>>>>
>>>>> The big damage has been recovered restoring the file /etc/ome-
>>>>> install.store
>>>>> Now I'm back to square one.
>>>>> 1) Postgres is running
>>>>> postgres 6228 1 0 11:26 pts/6 00:00:00 /usr/bin/
>>>>> postmaster -h horus17 -p 5432 -D
>>>>> /var/lib/pgsql/data
>>>>> postgres 6230 6228 0 11:26 pts/6 00:00:00 postgres: stats
>>>>> buffer process
>>>>> postgres 6231 6230 0 11:26 pts/6 00:00:00 postgres: stats
>>>>> collector process
>>>>> postgres 8289 6228 0 11:28 pts/6 00:00:00 postgres:
>>>>> apache ome [local] idle
>>>>> postgres 8308 6228 0 11:28 pts/6 00:00:00 postgres:
>>>>> apache ome [local] idle
>>>>> postgres 8645 6228 0 11:28 pts/6 00:00:00 postgres:
>>>>> apache ome [local] idle
>>>>> postgres 9058 6228 0 11:29 pts/6 00:00:00 postgres:
>>>>> apache ome [local] idle
>>>>> postgres 9131 6228 0 11:29 pts/6 00:00:00 postgres:
>>>>> apache ome [local] idle
>>>>> postgres 9728 6228 0 11:29 pts/6 00:00:00 postgres:
>>>>> apache ome [local] idle
>>>>> postgres 14503 6228 0 11:33 pts/6 00:00:00 postgres:
>>>>> apache ome [local] idle
>>>>> postgres 14566 6228 0 11:33 pts/6 00:00:00 postgres:
>>>>> apache ome [local] idle
>>>>> 2) $ hostname
>>>>> horus17
>>>>> but from outside this machine is reachable as horus.cscs.ch
>>>>> 3) I changed omeis_url to
>>>>> http://horus.cscs.ch/cgi-bin/omeis (from http://horus17/cgi-bin/
>>>>> omeis). Restarted Apache.
>>>>> No way.
>>>>> 4) Changed lsid_url to horus.cscs.ch (from horus17). Restarted
>>>>> Apache. No images at all!
>>>>> What else should I set to at last access the images!
>>>>> Thanks for the help!
>>>>> mario
>>>>
>>>>> Markus Dorn wrote:
>>>>>> Hi Mario,
>>>>>>
>>>>>> postgres db is running? Try `ps -ef | grep post`, was tells
>>>>>> `hostname`?
>>>>>>
>>>>>> If not and you dont have data in ome I would success to
>>>>>> reinstall.
>>>>>>
>>>>>> Markus
>>>>>>
>>>>>>> Now the web server does not restarts (cannot access database at
>>>>>>> horus.cscs.ch) and cannot execute ome admin configure to
>>>>>>> reset the
>>>>>>> changed values.
>>>>>>> What can I do to have back my OME server and to have a
>>>>>>> working image
>>>>>>> viewer?
>>>>> _______________________________________________
>>>>> ome-users mailing list
>>>>> ome-users at lists.openmicroscopy.org.uk
>>>>> http://lists.openmicroscopy.org.uk/mailman/listinfo/ome-users
>>>>
>>>>
>>> --
>>> Ing. Mario Valle
>>> Visualization Group | http://
>>> www.cscs.ch/~mvalle
>>> Swiss National Supercomputing Centre (CSCS) | Tel: +41 (91)
>>> 610.82.60
>>> v. Cantonale Galleria 2, 6928 Manno, Switzerland | Fax: +41 (91)
>>> 610.82.82
>>> _______________________________________________
>>> ome-users mailing list
>>> ome-users at lists.openmicroscopy.org.uk
>>> http://lists.openmicroscopy.org.uk/mailman/listinfo/ome-users
>>>
>>
>
> --
> Ing. Mario Valle
> Visualization Group | http://
> www.cscs.ch/~mvalle
> Swiss National Supercomputing Centre (CSCS) | Tel: +41 (91)
> 610.82.60
> v. Cantonale Galleria 2, 6928 Manno, Switzerland | Fax: +41 (91)
> 610.82.82
> _______________________________________________
> ome-users mailing list
> ome-users at lists.openmicroscopy.org.uk
> http://lists.openmicroscopy.org.uk/mailman/listinfo/ome-users
>
More information about the ome-users
mailing list