User accounts on test server

You can create it at https://master.apis.dev.openstreetmap.org/ for testing editing without affecting real database.

Accounts on Dev/Tool Server (errol)

Please contact TomH if you require a dev server account.

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.