How to manage scgStore

How to log in to scgStore?

  • In the Store menu of the launcher, choose ’Connect to Repository’. A dialog pops up where you have to fill in information for connecting to a Store database.
  • Provide the following information:
    • Interface: select PostgreSql from the dropdown box
    • Environment: type (without the quotes!): ’db.iam.unibe.ch:5432_scgStore’
    • User Name: storeguest (if you have one, put yours)
    • Password: storeguest (if you have one, put yours)
  • Connect
  • To access the SCG Store do the following In the Store menu of the launcher: Store -> Published Items

How to add a user to scgStore?

  • log in as scg on db.iam.unibe.ch
  • do: ’module load postgres’
  • do: ’createuser -D -A -P’ (this prompts for username and password)
  • If the user needs write access to store
    • use psql scgStore and "alter group storeusers add user username;"
  • open a Visualworks image and connect to the scg store using the user ’scg’ with the regular password. This is the administrator user for the scgStore.
  • go to Store>Administration>User/Group Management.
  • in the application, add the user under the correct heading (e.g. probably scg)

How to add a database?

  • log in as scg on db.iam.unibe.ch
  • do: ’module load postgres’
  • do: ’psql’ and in that command-line program execute ’CREATE DATABASE XYZ’
  • to correctly initialize the tables open an image with a loaded Store-parcel and execute in a workspace ’Store.DbRegistry installDatabaseTables’
Last changed by admin on 21 April 2009