Using the lsst-dev-db Server¶
lsst-dev-db
is the development MySQL database server run by NCSA for LSST DM development work.
The CNAMEs lsst-db.ncsa.illinois.edu
and lsst10.ncsa.illinois.edu
direct to lsst-dev-db.ncsa.illinois.edu
to support historical usage of those hostnames.
To get an account, see the Onboarding Checklist.
This page is designed to assist developers in their work with lsst-dev-db
:
Account Password¶
The lsst-dev-db
server does NOT use your NCSA account.
After you receive your initial temporary password, change it as soon as possible as follows.
Set the MYSQL_HISTFILE
environment variable to /dev/null
(By doing it you will prevent the command with your new password from being saved in clear-text history file.).
export MYSQL_HISTFILE=/dev/null
Then, log into MySQL:
mysql -h lsst-dev-db.ncsa.illinois.edu -u<userName> -p
Password: <type temporary mysql password>
And then, set a new password:
set password = password('theNewPassword');
Authentication Configuration File¶
Create a db-auth.py
configuration file with your mysql host, user, password and mysql port information. This file belongs in $HOME/.lsst/
, and must have permissions 600.
config.database.authInfo["auth1"].host = "lsst-dev-db.ncsa.illinois.edu"
config.database.authInfo["auth1"].user = "<user>"
config.database.authInfo["auth1"].password = "<password>"
config.database.authInfo["auth1"].port = 3306
You will also need to create a db-auth.paf
file, because the pex_persistence
package hasn’t been updated to use Config. This file also belongs in $HOME/.lsst
, and requires permissions 600.
database: {
authInfo: {
host: lsst-dev-db.ncsa.illinois.edu
port: 3306
user: <user>
password: <password>
}
}