Dev Server Account

From OpenStreetMap Wiki
Jump to: navigation, search

Accounts

Accounts on Dev/Tool Server (Gorilla-server.svgerrol)

Please contact TomH if you require a dev server account.

Setting up Accounts

Creating the Account

Steps to follow when creating an account on errol:

  • Ask the user to agree to the Dev Server Account Policy.
  • Add the user to the user list with a new, unique uid value.
  • Create a group - groupadd -g uid username.
  • Create an account - useradd -u uid-g uid -c fullname -m username.
  • Generate a strong random password - pwgen is a useful tool for this.
  • Set the account password - passwd username then enter password twice.
  • Run /usr/local/bin/update-apache-users
  • Add entry to /etc/aliases of the form username: email
  • Mail username and password to user.

Setting up PostgreSQL Access

To give a user access to Postgres follow these steps:

  • Generate a strong random password - pwgen is a useful tool for this.
  • Create a Postgres user - createuser -dPRS username and enter the password when prompted.
  • Mail password to user.

The user will then be able to create databases with createdb.

Setting up MySQL Access

To give a user access to MySQL follow these steps:

  • Generate a strong random password - pwgen is a useful tool for this.
  • Create a MySQL user - CREATE USER username@localhost IDENTIFIED BY password
  • Create a database for the user - CREATE DATABASE username
  • Give the user access to the database - GRANT ALL ON username.* TO username@localhost

If more than one database is required each one will need to be created by an admin as described above, as the MySQL privilege system sucks.