How to obtain InforRouter DB and YPS DB credentials
In each DataCenter (DC), Production or LAB, the local mgt-server has a script
/usr/local/bin/List_DB_Credentials.perl available. The usage is:
The DB server names are setup as DNS CNAMEs to the actual DB servers.
This means that e.g. vip1-master-db will point to mysql-vip-1a
or mysql-vip-1c -- as appropriate at a given point in time.
Generally: For all master DB servers there is an associated
slave DB server - e.g. for vip1-master-db there is a vip1-slave-db.
The slave DB servers will generally have the read-only variable set
to ON, which prevents updates - the exception is the YPS slave DB servers.
If you do not plan make any updates in a DB - please use ro credentials.
NOTE: Some DBs - e.g. cqm do not have ro credentials - only rw.
How to connect to a DB in a given DC
To connect to a DB server in a given DC the general method is to make a
SSH-tunnel from a local TCP port on your computer to port 3306 on the
DB server (running MySQL).
When setting up the SSH connection and associated tunnels you must a
Username and Password that is validated against the Soonr AD directory.
E.g.: To connect to VIP cell1 master DB in San Jose - make a tunnel from
localhost:9872 to vip1-master-db by using the following ssh command (Linux/MAC):
After which you can connect your favorite DB tool (e.g. DbVisualizer) to localhost:9872
and use the credentials obtained by using List_DB_Credentials.perl.
For Windows - please refer to:
ssh-port-tunneling-with-putty and
ssh-forward-ssh-key
for how to use e.g. Putty as your ssh client.
Procedure for AppServer (InfoRouter) build installation has the list of
mgt-SERVERS for LAB/DTU and Production DCs.