We're Hiring!

OMERO server 4.03 login problems

Having a problem deploying OMERO? Please ask new questions at https://forum.image.sc/tags/omero
Please note:
Historical discussions about OMERO. Please look for and ask new questions at https://forum.image.sc/tags/omero

The OMERO.server installation documentation begins here and you can find OMERO.web deployment documentation here.

Re: OMERO server 4.03 login problems

Postby chekki » Mon Jun 22, 2009 7:49 am

This cmd works fine as you can see here:
    D:\Program Files\PostgreSQL\8.3\bin>psql -h localhost -U omero omero
    Passwort fⁿr Benutzer omero:
    Dies ist psql 8.3.7, das interaktive PostgreSQL-Terminal.

    Geben Sie ein: \copyright für Urheberrechtsinformationen
    \h für Hilfe über SQL-Anweisungen
    \? für Hilfe über interne Anweisungen
    \g oder Semikolon, um eine Anfrage auszuführen
    \q um zu beenden

    Warnung: Konsolencodeseite (437) unterscheidet sich von der Windows-
    Codeseite (1252). 8-Bit-Zeichen funktionieren möglicherweise nicht
    richtig. Einzelheiten finden Sie auf der psql-Handbuchseite unter
    »Notes for Windows users«.

    omero=>
chekki
 
Posts: 10
Joined: Mon Jun 08, 2009 3:42 pm

Re: OMERO server 4.03 login problems

Postby jmoore » Mon Jun 22, 2009 8:32 am

Hmm....alright. Would you mind posting the results of "select * from dbpatch;" then?
User avatar
jmoore
Site Admin
 
Posts: 1591
Joined: Fri May 22, 2009 1:29 pm
Location: Germany

Re: OMERO server 4.03 login problems

Postby chekki » Mon Jun 22, 2009 8:49 am

Here you go - no output (data) !?
    omero->
    omero-> select * from dbpatch
    omero-> select * from arc
    omero-> select * from detector
    omero->
chekki
 
Posts: 10
Joined: Mon Jun 08, 2009 3:42 pm

Re: OMERO server 4.03 login problems

Postby cxallan » Mon Jun 22, 2009 9:05 am

chekki wrote:Here you go - no output (data) !?
    omero->
    omero-> select * from dbpatch
    omero-> select * from arc
    omero-> select * from detector
    omero->


You need a semi-colon ";" at the end of your SELECT statements.

Code: Select all
SELECT * FROM dbpatch;
cxallan
Site Admin
 
Posts: 509
Joined: Fri May 01, 2009 8:07 am

Re: OMERO server 4.03 login problems

Postby chekki » Mon Jun 22, 2009 12:58 pm

Uups, ok, now I got it:
    omero=> select * from dbpatch;
    id | currentpatch | currentversion | permissions | finished | message | previouspatch | previousversion | external_i
    d
    ----+--------------+----------------+-------------+-------------------------+-----------------+---------------+-----------------+-----------
    --
    1 | 0 | OMERO4 | -35 | 2009-06-15 15:19:57.505 | Database ready. | 0 | OMERO4 |

    (1 Zeile)

    omero=>
chekki
 
Posts: 10
Joined: Mon Jun 08, 2009 3:42 pm

Re: OMERO server 4.03 login problems

Postby cxallan » Mon Jun 22, 2009 2:14 pm

Can you give us the output of "\df ome_nextval"?

It should look like this:

Code: Select all
omero=# \df ome_nextval
                                 List of functions
Schema |    Name     | Result data type |           Argument data types           
--------+-------------+------------------+------------------------------------------
public | ome_nextval | bigint           | seq character varying
public | ome_nextval | bigint           | seq character varying, increment integer
(2 rows)
cxallan
Site Admin
 
Posts: 509
Joined: Fri May 01, 2009 8:07 am

Re: OMERO server 4.03 login problems

Postby chekki » Mon Jun 22, 2009 3:14 pm

Looks exactly the same to me:
Code: Select all
omero=> # \df ome_nextval
                                Liste der Funktionen
Schema |    Name     | Ergebnisdatentyp |            Argumentdatentypen
--------+-------------+------------------+------------------------------------------
public | ome_nextval | bigint           | seq character varying
public | ome_nextval | bigint           | seq character varying, increment integer
(2 Zeilen)

chekki
 
Posts: 10
Joined: Mon Jun 08, 2009 3:42 pm

Re: OMERO server 4.03 login problems

Postby jmoore » Fri Jun 26, 2009 2:00 pm

Whew, chekki, I think you win a prize.

Your logs are saying that your database is not reachable, but everything we have been able to think to check, you've clearly and definitely shown to work! Has anything changed in the logs? Perhaps whatever database issue there, has since been corrected and there's a new error?

Sorry for not having more for you to go on. ~J.
User avatar
jmoore
Site Admin
 
Posts: 1591
Joined: Fri May 22, 2009 1:29 pm
Location: Germany

Re: OMERO server 4.03 login problems

Postby chekki » Mon Jun 29, 2009 1:04 pm

Hi Josh,

attached please find the latest logs.

Maybe time to give up on Windows and worth thinking to deploy the server on Linux instead...

Stefan
Attachments
OMEROweb.zip
(161.41 KiB) Downloaded 286 times
chekki
 
Posts: 10
Joined: Mon Jun 08, 2009 3:42 pm

Re: OMERO server 4.03 login problems

Postby jmoore » Mon Jun 29, 2009 3:12 pm

Stefan,

since the "Did you create your database error?" which you were originally getting, there was at least one successful start (from Blitz-0.log):

Code: Select all
2009-06-26 16:32:22,535 INFO  [    ome.services.util.ServerVersionCheck] (      main) -------------------------------------------------
2009-06-26 16:32:22,535 INFO  [    ome.services.util.ServerVersionCheck] (      main) OMERO Version: Beta-4.0.2 Ready.
2009-06-26 16:32:22,535 INFO  [    ome.services.util.ServerVersionCheck] (      main) -------------------------------------------------


which ran until here:

Code: Select all
2009-06-26 18:48:00,023 INFO  [ ome.services.blitz.fire.SessionManagerI] (r_Worker-9) Performing requestHeartbeats


where the logs have a gap. After that the server again runs successfully, ...

Code: Select all
2009-06-29 09:41:31,828 INFO  [ome.services.sessions.state.SessionCache] (r_Worker-3) Synchronizing session cache. Count = 1
2009-06-29 09:41:31,828 INFO  [        ome.services.util.ServiceHandler] (r_Worker-3)  Executor.doWork -- ome.services.sessions.SessionManagerImpl.reload
2009-06-29 09:41:31,828 INFO  [        ome.services.util.ServiceHandler] (r_Worker-3)  Args:    [null, ome.tools.spring.InternalServiceFactory@1105f32]
2009-06-29 09:41:31,843 INFO  [ ome.services.blitz.fire.SessionManagerI] (r_Worker-6) Performing requestHeartbeats


until apparently PostgreSQL was turned off:

Code: Select all
2009-06-29 13:12:05,020 ERROR [ome.services.db.SelfCorrectingDataSource] (r_Worker-5) Failed to acquire connection after retries=3
...
Caused by: org.postgresql.util.PSQLException: Verbindung verweigert. <DC>berpr<FC>fen Sie die Korrektheit von Hostnamen und der Portnummer und dass der Datenbankserver
TCP/IP-Verbindungen annimmt.
        at org.postgresql.core.v3.ConnectionFactoryImpl.openConnectionImpl(ConnectionFactoryImpl.java:123)
        at org.postgresql.core.ConnectionFactory.openConnection(ConnectionFactory.java:66)
        at org.postgresql.jdbc2.AbstractJdbc2Connection.<init>(AbstractJdbc2Connection.java:124)


Do those dates ring a bell? Could your database server have been turned off?

Hope that helps,
~J.
User avatar
jmoore
Site Admin
 
Posts: 1591
Joined: Fri May 22, 2009 1:29 pm
Location: Germany

PreviousNext

Return to Installation and Deployment

Who is online

Users browsing this forum: No registered users and 1 guest