Connecting to the Database
The database that holds the billing information is hosted on the same instance that the service is on, so we will need the PublicDNS.
We are using a PostgreSQL and the default connection information is:
- host: PublicDNS
- database name:
billing - username:
billing_viewer - password will be
billing_viewer_password
ODBC
See Setting Up a Microsoft Windows ODBC Connection
JDBC
The driver class is org.postgresql.Driver and the jdbc url will look like jdbc:postgresql://PublicDNS/billing. If you go to http://PublicDNS/rest/v1/connectionInfo it will give the literal jdbc url for the host.
Command Line
Console - user@hostname ~ $
1
psql -h PublicDNS -U billing_viewer billing
Give billing_viewer_password when prompted for the password.