Sierra Database Connection Tutorial

Slides available at:
slides.mobiusconsortium.org/blake/sierradb

Created by Blake Graham-Henderson / [email protected]

Press ESC to browse slides

You will need

  • Your DB server name or IP
  • Sierra admin account
  • Postgres client software for your OS

Login to admin panel

http://swan.searchmobius.org/sierra/admin

Authorizations

Click

Create User

Click

Fill Form

Supply the username and password

Only need to provide the minimum

Save

Click

Applications

Click

Drag SQL Access

Click and drag the Sierra SQL Access left

Agree

Click Accept

Save

Click

Let's get pgadmin

Google "pgadmin"

Search results

Let's get pgadmin

Choose your OS

Download

http://www.pgadmin.org/download/

Install pgadmin

Install the downloaded file

Click "Next" a bunch

Add server

Click file -> Add Server

Name:Whatever you want
Host:swan-db.searchmobius.org
Port:1032
Service:Blank
Maintenance:iii (that's triple "I")
Username:Chosen username from setup
Password:Chosen password from setup

Browse the DB

Databases

Schemas

sierra_view

Views

THE END

Blake Graham-Henderson

MOBIUS

[email protected]