Dev Server Account

Accounts

User accounts on test server

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

Note that it has no dedicated map rendering or overpass server and data is different than one on live osm.org

If you want overpass, rendering etc you will need to provide it on its own. If you want to test edit on data matching real database you will need to add it first.

Accounts on Dev/Tool Server (faffy)

If you are unable to sign up using the link above, please fill out the server account request form

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.