Task #6130 (closed)
Opened 8 years ago
Closed 8 years ago
Install & Configure OMERO.server prerequisites on DemoVM
| Reported by: | szwells | Owned by: | szwells |
|---|---|---|---|
| Priority: | minor | Milestone: | Unscheduled |
| Component: | General | Version: | n.a. |
| Keywords: | n.a. | Cc: | |
| Resources: | n.a. | Referenced By: | n.a. |
| References: | n.a. | Remaining Time: | n.a. |
| Sprint: | n.a. |
Description
Install & Configure OMERO.server prerequisites on DemoVM:
- Setup postgresql:
$ sudo -u postgres createuser -P -D -R -S omero
$ sudo -u postgres createdb -O omero omero
# e.g. passwd set to omero
$ sudo -u postgres createlang plpgsql omero
- NB. Check that a database called "omero" has been created:
$ psql -h localhost -U omero -l
- Update postgresql host based authentication to accept remote connections:
$ sudo sed '/127.0.0.1/s/md5/trust/' /etc/postgresql/8.4/main/pg_hba.conf > pg_hba.conf && sudo mv pg_hba.conf /etc/postgresql/8.4/main/pg_hba.conf
- Restart postgresql:
$ sudo /etc/init.d/postgresql restart
- Use netstat to verify that there is something listening on port 5432, this should be your postgres server:
$ netstat -an | egrep '5432.*LISTEN'
Which should display a line similar to the following:
tcp 0 0 127.0.0.1:5432 0.0.0.0:* LISTEN
Change History (1)
comment:1 Changed 8 years ago by szwells
- Resolution set to fixed
- Status changed from new to closed