corestack_ external_ db_ user_ password_ rotate
Rotate a database user's password.
When to use it
Give a database user a new password: when it may have leaked, when a person who knew it leaves, or when a generated password was lost (it is shown only once). The old password stops working as soon as the change applies, so update the tool that uses it straight after; open sessions keep working until they reconnect.
Send your own password ({"mode": "set", "value": ...}) or let the Control Panel make one ({"mode": "generate"}), shown once in the person's browser, or given to you with exec and reveal_to_agent: true when the task completes. application, the site's own login, is never rotated here.
Ask for it
Using the Corefinity MCP server, call corestack_external_db_user_password_rotate with site_id 4211, username reporting_ro, password {"mode":"generate"}. (Rotate a database user's password.) Tell me what it returned.Inputs
{"mode": "generate"}, or {"mode": "set", "value": "..."} with 12 to 64 printable ASCII characters and no quotes, backticks or backslashes.
Fields
generate: 24 characters made for you and shown once in the person's browser; set: your own value.
generatesetWith mode set: 12 to 64 printable ASCII characters, no quotes, backticks or backslashes.
Return the secret to you instead of opening it in the person's browser. Needs exec. Defaults to false.
At least 1.
The user's name from corestack_external_db_get. Up to 128 characters.
Example call
{
"name": "corestack_external_db_user_password_rotate",
"arguments": {
"site_id": 4211,
"username": "reporting_ro",
"password": {
"mode": "generate"
}
}
}If it is refused
| Reason | What to do |
|---|---|
user_not_found | No user of that name on this environment that can be changed here. |
invalid_arguments | The password breaks its rules; fields names it. |
busy | Another change to this environment is applying. |
deleted | The site is deleted (in its grace period). |
provisioning | The site is still being created. |
managed_elsewhere | Another control panel manages this site, so use that control panel for it. This is refused before anything else about the site, as in the Control Panel and the API. Nothing was done. |
tenant_mismatch | The object does not exist or the token may not see it. Check the id. |
scope_required | The token lacks a scope this call needs. Open the link in the answer to add it, then call again. |
pin_refused | The grant is limited to chosen clusters, sites or environments, and this call is outside them. Open the link in the answer to widen it. |
rate_limited | Too many calls. Wait for the number of seconds the answer names. |
temporarily_unavailable | The Control Panel could not answer just now. Nothing was started; try again shortly. |
internal_error | Something went wrong on our side. Quote the trace id to support. |