PushQ new user

This page describes how to create a new pushQ account for a new user.

PushQ

The pushQ has a web interface, which is the main way we interact with the pushQ.

However, the pushQ is actually a mysql database called 'qapushq' on the mysqlbeta server.

Adding a New User

Add a new record to the "users" table with a new username, no value for the password (single quotes with nothing inside of them as the value for password), the appropriate role ('qa' for member of the QA team and 'dev' for engineers), and no value for content (single quotes with nothing inside of them as the value for content):

From hgwdev, here is how you would add a QA user:

hgwdev ~]$ hgsql -h mysqlbeta -Ne "INSERT INTO users (user, password, role, contents) VALUES ('jdoe', '', 'qa', '');" qapushq

or:

hgwdev ~]$ hgsql -h mysqlbeta
mysql> use qapushq
mysql> INSERT INTO users (user, password, role, contents) VALUES ('jdoe', '', 'qa', '');

for an engineer, in either of the above examples, change 'qa' (the value of the role field) to 'dev', for example:

mysql> INSERT INTO users (user, password, role, contents) VALUES ('jdoe', '', 'dev', '');

Accessing New Account

Let the new user know what their username is and have the person go to the pushQ web interface to login. The first time they log in, whatever they enter in as their password will become their password.