Open Microscopy Environment

I will PM you the link to access the file.

Hope you can help me.
Alex

Thanks Alex

The ordering of the entries in pg_hba.conf is important- postgres will attempt to authenticate a user with the first matching line. Can you try moving the line ending with ident to below the lines ending with md5?

I will try it asap and I will let you know if it works.

Thank you
Alex

Hi,

I tried to modify the file as you suggest, I hope I did it correctly.
You can look at the modified file at the same link I sent you.
The file is labeled as "pg_hba_2.conf".

If I modified the file correctly, the solution you proposed is not working.
I get always the same error.

Thanks for your help.
Best,

Alex

Thanks Alex.

Could you try passing the -h option to psql, e.g.:

Code: Select all

psql -h localhost dbname username

There are two ways of connecting to the Postgres server: via a network connection, or using a local socket, and it's possible for them to use different authentication mechanisms. OMERO requires the former. Without the '-h hostname' psql will attempt to use the latter- sorry for not spotting this earlier.

Simon

Sorry for the late answer.

I tried

Code: Select all

psql -h localhost dbname username

and it is working.

The major issue should be solved because of the line moved in the configuration file, am I right?

Thanks for your patience.
Alex

Hi Alex

Yes, it looks like your database is setup correctly. If you have any further problems post them here and we'll try and help you out.

Hi,

It seems that we still have problems.

At the end of the last week some users reported a slow down of the service, they had to wait a long time for insight to load data from the server. The problem lasted a couple of hours.

Today a user told me that the server was not accessible. I tried it and neither insight nor the web service were able to access the server. The web server was not even reachable (endless loading).

Do you need that I put the new log online?

Thank you for your help.
Alex

Hi Alex

If you could zip up the log directory and put them online again that would be most helpful. Could you also tell us what dates/times the slowdowns occurred, to make it easier for us when going through the logs?

Thanks

Simon

I uploaded the logs in the same location where I told you last time.
The following problems happened:

slow down - friday 6.9.2013
server non accessible - monday 9.9.2013

Tell me if you need more information.
Thanks for your help.
Alex