Hi Josh!<br><br><br><div class="gmail_quote"><blockquote class="gmail_quote" style="border-left: 1px solid rgb(204, 204, 204); margin: 0pt 0pt 0pt 0.8ex; padding-left: 1ex;">At the moment, it's necessary to have all configuration properties set<br>
before startup (bin/omero admin start). Setting those properties<br>
consists of editing any (or all) of the files in etc/ and then running<br>
"ant update". "java omero setup" is simply a method of creating<br>
etc/local.properties, which you can equally do by hand.</blockquote><div><br>Ah, maybe I missed the update all the time ... good to know!<br>
</div><div> </div><blockquote class="gmail_quote" style="border-left: 1px solid rgb(204, 204, 204); margin: 0pt 0pt 0pt 0.8ex; padding-left: 1ex;"><div><div class="Wj3C7c"><br>
</div></div>The command you give here "psql -U omero omero3_1" uses a local socket<br>
for connection. Java/JDBC, however, will always have to use a TCP<br>
connection. To test how OMERO would connect, try:<br>
<br>
psql -h localhost -U omero omero3_1</blockquote><div><br>That worke as well, though db connection from blitz didn't. <br> <br></div><blockquote class="gmail_quote" style="border-left: 1px solid rgb(204, 204, 204); margin: 0pt 0pt 0pt 0.8ex; padding-left: 1ex;">
Have you run across:<br>
<br>
<a href="http://trac.openmicroscopy.org.uk/omero/wiki/OmeroAndPostgres" target="_blank">http://trac.openmicroscopy.org.uk/omero/wiki/OmeroAndPostgres</a><br>
<br>
yet?</blockquote><div><br>I've seen it before, and read it again. I've looked into the authentication configuration and the ip/port defintions. Now I have in pg_hba.conf<br><br> IPv4 local connections:<br>host all all <a href="http://127.0.0.1/32">127.0.0.1/32</a> md5<br>
host all all <a href="http://192.168.1.0/24">192.168.1.0/24</a> md5<br><br><br>and in postgresql.conf<br><br>listen_addresses = 'localhost,bbox' # what IP address(es) to listen on;<br>
<br>where bbox is the name of my host which is in the private network from where hosts are allowed to connect to.<br>This setup works now, I can connect from blitz clients to the db :-)<br><br>Suspicious was that with the previous setup without the private network connection configuration, I wasn't asked for a password when connection to the db server using <br>
$ psql -h localhsot -U omero omero3_1<br>Welcome to psql 8.3.5, the PostgreSQL interactive terminal.<br><br>Now, when using bbox as the db host, I have to enter the password for the omero user:<br>$ psql -h bbox -U omero omero3_1<br>
Password for user omero:<br>Welcome to psql 8.3.5, the PostgreSQL interactive terminal.<br><br>I bet this is related to the problem being not able to connect to the db via blitz using another account rather than omero for running the server.<br>
<br>Best wishes! Bernhard<br></div></div><br>