Database SQL clients connect through the Ingress controller and require TLS to be enabled on the NuoDB database.
nuodb-cp database connect acme/messaging/demo \
--db-user=dba \
--db-password=changeIt
Get database connection information.
CA_CERT="$(curl $NUODB_CP_URL_BASE/databases/acme/messaging/demo | jq -r '.status.caPem')"
DB_URL="$(curl $NUODB_CP_URL_BASE/databases/acme/messaging/demo | jq -r '.status.sqlEndpoint')"
Connect using nuosql.
nuosql "demo@${DB_URL}:8443" --user dba --password changeIt --connection-property trustedCertificates="$CA_CERT"
NuoDB client package v20230228 or later is required to connect to DBaaS database.
output "dba_username" {
value = "dba"
}
output "dba_password" {
value = nuodbaas_database.db.dba_password
sensitive = true
# visible with terraform output dba_password
}
output "ca_cert" {
value = nuodbaas_database.db.status.ca_pem
}
output "db_url" {
value = "${nuodbaas_database.db.status.sql_endpoint}:443"
}
output "db_name" {
value = nuodbaas_database.db.name
}