Change database of a web hosting package
Change the description of a database, give it a new password, or have manitu forget the password.
manitu_webhosting_web_database_set on https://mcp.manitu.de/mcpAnnotations as tools/list sends them
Description for the model
Changes a database of a web hosting package of the manitu customer account this connection works in, by site_id and database_id from manitu_webhosting_web_database_list. Only the fields given change: description; password_action regenerate - manitu sets a new password on the database server, and every program that connects with the old one (CMS, shop) stops working until it is changed there too -, or forget - manitu no longer keeps the password (the database keeps it; dumps and copies are not possible until a new one). The new password is NOT given here (secrets_withheld): the customer finds it in the customer panel. Refused with a conflict when the package cannot be changed now (not_configurable). Ask the customer for an explicit yes first, naming what stops working.
Arguments
site_idinteger | stringrequiredThe site_id from manitu_webhosting_list - never guess one.
database_idinteger | stringrequiredThe database_id from manitu_webhosting_web_database_list - never guess one.
descriptionstring | nullThe customer's description, for his own overview. Left out: unchanged (set) or none (create); null or empty: none.
password_actionstringregenerate: a new password, made by manitu; forget: manitu no longer keeps the password.
Result structuredContent, checked against the schema
database_idintegerrequiredThe database - what the other database tools take.
server_typestring | nullrequiredThe kind of database server: mariadb, mysql or postgres; null if it cannot be told right now.
hostnamestringrequiredThe database server to connect to - from the web hosting package's own scripts.
namestringrequiredThe name of the database (db<number>).
usernamestringrequiredThe user to connect with (u<number>).
descriptionstring | nullrequiredWhat the customer wrote about it (his description), null if nothing - not its name or user name.
password_storedbooleanrequiredmanitu still knows the password. false: the customer had it forgotten - the database keeps it, dumps and copies need a new one (set with password_action regenerate).
table_countinteger | nullrequiredHow many tables it has, as last counted; null if never counted.
data_size_mbinteger | nullrequiredHow much data and indexes it holds in MB (rounded down), as reported by the database server when last counted; the files on disk can be larger. null if never counted.
counted_atstring | nullrequiredWhen table_count and data_size_mb were counted.
created_atstring | nullrequiredWhen it was created.
passwordstring | nullrequiredThe password - a secret; null where it is withheld (secrets_withheld) or not stored (password_stored).
secrets_withheldbooleanrequiredThe password is left out here (an answer to an agent) - the customer finds it in the customer panel.
Authentication
One of X-API-Key, Authorization: Bearer … - never more than one in a request. More
Request body JSON; unknown fields are refused
site_idinteger | stringrequiredThe site_id from manitu_webhosting_list - never guess one.
database_idinteger | stringrequiredThe database_id from manitu_webhosting_web_database_list - never guess one.
descriptionstring | nullThe customer's description, for his own overview. Left out: unchanged (set) or none (create); null or empty: none.
password_actionstringregenerate: a new password, made by manitu; forget: manitu no longer keeps the password.
Response in data; the rest of the body as on every call
database_idintegerrequiredThe database - what the other database tools take.
server_typestring | nullrequiredThe kind of database server: mariadb, mysql or postgres; null if it cannot be told right now.
hostnamestringrequiredThe database server to connect to - from the web hosting package's own scripts.
namestringrequiredThe name of the database (db<number>).
usernamestringrequiredThe user to connect with (u<number>).
descriptionstring | nullrequiredWhat the customer wrote about it (his description), null if nothing - not its name or user name.
password_storedbooleanrequiredmanitu still knows the password. false: the customer had it forgotten - the database keeps it, dumps and copies need a new one (set with password_action regenerate).
table_countinteger | nullrequiredHow many tables it has, as last counted; null if never counted.
data_size_mbinteger | nullrequiredHow much data and indexes it holds in MB (rounded down), as reported by the database server when last counted; the files on disk can be larger. null if never counted.
counted_atstring | nullrequiredWhen table_count and data_size_mb were counted.
created_atstring | nullrequiredWhen it was created.
passwordstring | nullrequiredThe password - a secret; null where it is withheld (secrets_withheld) or not stored (password_stored).
secrets_withheldbooleanrequiredThe password is left out here (an answer to an agent) - the customer finds it in the customer panel.
Statuses
200Success.400The request does not match the declared input schema.401No credential was presented, or it was not recognised.403The credential is not permitted to use this operation.500The server failed. Nothing about the request was wrong. Whether a change took effect is not known - check before trying it again.503The channel this operation forwards through is unavailable.