Difference between revisions of "API: Databases"
From BrainyCP
| Line 100: | Line 100: | ||
Other useful articles: | Other useful articles: | ||
| − | {| style="width: | + | {| style="width: 1025px;" |
|- | |- | ||
| − | | | + | | style="width: 274px;" | |
| − | '''[https://docs.brainycp.io/index.php/API:_подключение API: | + | '''[https://docs.brainycp.io/index.php/API:_подключение <font><font>API: connection</font></font>]''' |
| − | | | + | | style="width: 321px;" | |
| − | '''[https://docs.brainycp.io/index.php/API:_мониторинг API: | + | '''[https://docs.brainycp.io/index.php/API:_мониторинг <font><font>API: monitoring</font></font>]''' |
| − | | | + | | style="width: 407px;" | |
| − | '''[https://docs.brainycp.io/index.php/API:_статус_веб-сервера API: | + | '''[https://docs.brainycp.io/index.php/API:_статус_веб-сервера <font><font>API: web server status</font></font>]''' |
|- | |- | ||
| − | | | + | | style="width: 274px;" | |
| − | '''[https://docs.brainycp.io/index.php/API:_автоустановщик_CMS API: | + | '''[https://docs.brainycp.io/index.php/API:_автоустановщик_CMS <font><font>API: auto installer CMS</font></font>]''' |
| − | | | + | | style="width: 321px;" | |
| − | '''[https://docs.brainycp.io/index.php/API:_настройка_бекапов API: | + | '''[https://docs.brainycp.io/index.php/API:_настройка_бекапов <font><font>API: configuring backups</font></font>]''' |
| − | | | + | | style="width: 407px;" | |
| − | '''[https://docs.brainycp.io/index.php/API:_трансфер_между_серверами API: | + | '''[https://docs.brainycp.io/index.php/API:_трансфер_между_серверами <font><font>API: transfer between servers</font></font>]''' |
|- | |- | ||
| − | | | + | | style="width: 274px;" | |
| − | '''[https://docs.brainycp.io/index.php/API:_антивирус API: | + | '''[https://docs.brainycp.io/index.php/API:_антивирус <font><font>API: antivirus</font></font>]''' |
| − | | | + | | style="width: 321px;" | |
| − | '''[https://docs.brainycp.io/index.php/API:_настройки_сервера API: | + | '''[https://docs.brainycp.io/index.php/API:_настройки_сервера <font><font>API: server settings</font></font>]''' |
| − | | | + | | style="width: 407px;" | |
| − | '''[https://docs.brainycp.io/index.php/API:_управление_веб-сервером API: | + | '''[https://docs.brainycp.io/index.php/API:_управление_веб-сервером <font><font>API: web server management</font></font>]''' |
|- | |- | ||
| − | | | + | | style="width: 274px;" | |
| − | '''[https://docs.brainycp.io/index.php/API:_базы_данных API: | + | '''[https://docs.brainycp.io/index.php/API:_базы_данных <font><font>API: database</font></font>]''' |
| − | | | + | | style="width: 321px;" | |
| − | '''[https://docs.brainycp.io/index.php/API:_пользовательские_сертификаты API: | + | '''[https://docs.brainycp.io/index.php/API:_пользовательские_сертификаты <font><font>API: custom certificates</font></font>]''' |
| − | | | + | | style="width: 407px;" | |
| − | '''[https://docs.brainycp.io/index.php/API:_управление_почтовыми_ящиками API: | + | '''[https://docs.brainycp.io/index.php/API:_управление_почтовыми_ящиками <font><font>API: mailbox management</font></font>]''' |
|- | |- | ||
| − | | | + | | style="width: 274px;" | |
| − | '''[https://docs.brainycp.io/index.php/API:_информация_о_сервере API: | + | '''[https://docs.brainycp.io/index.php/API:_информация_о_сервере <font><font>API: server information</font></font>]''' |
| − | | | + | | style="width: 321px;" | |
| − | '''[https://docs.brainycp.io/index.php/API:_почта API: | + | '''[https://docs.brainycp.io/index.php/API:_почта <font><font>API: mail</font></font>]''' |
| − | | | + | | style="width: 407px;" | |
| − | '''[https://docs.brainycp.io/index.php/API:_управление_DNS-зонами API: | + | '''[https://docs.brainycp.io/index.php/API:_управление_DNS-зонами <font><font>API: DNS zone management</font></font>]''' |
|- | |- | ||
| − | | | + | | style="width: 274px;" | |
| − | '''[https://docs.brainycp.io/index.php/API:_использование_трафика API: | + | '''[https://docs.brainycp.io/index.php/API:_использование_трафика <font><font>API: traffic usage</font></font>]''' |
| − | | | + | | style="width: 321px;" | |
| − | '''[https://docs.brainycp.io/index.php/API:_почтовые_ящики_клиента API: | + | '''[https://docs.brainycp.io/index.php/API:_почтовые_ящики_клиента <font><font>API: client mailboxes</font></font>]''' |
| − | | | + | | style="width: 407px;" | |
| − | '''[https://docs.brainycp.io/index.php/API:_установка_веб-сервера API: | + | '''[https://docs.brainycp.io/index.php/API:_установка_веб-сервера <font><font>API: web server installation</font></font>]''' |
|- | |- | ||
| − | | | + | | style="width: 274px;" | |
| − | '''[https://docs.brainycp.io/index.php/API:_логирование API: | + | '''[https://docs.brainycp.io/index.php/API:_логирование <font><font>API: logging</font></font>]''' |
| − | | | + | | style="width: 321px;" | |
| − | '''[https://docs.brainycp.io/index.php/API:_сервер_имен API: | + | '''[https://docs.brainycp.io/index.php/API:_сервер_имен <font><font>API: name server</font></font>]''' |
| − | | | + | | style="width: 407px;" | |
| − | '''[https://docs.brainycp.io/index.php/API:_хост-аккаунты API: | + | '''[https://docs.brainycp.io/index.php/API:_хост-аккаунты <font><font>API: host accounts</font></font>]''' |
|- | |- | ||
| − | | | + | | style="width: 274px;" | |
| − | '''[https://docs.brainycp.io/index.php/API:_менеджер_приложений API: | + | '''[https://docs.brainycp.io/index.php/API:_менеджер_приложений <font><font>API: application manager</font></font>]''' |
| − | | | + | | style="width: 321px;" | |
| − | '''[https://docs.brainycp.io/index.php/API:_сертификаты_сервисов API: | + | '''[https://docs.brainycp.io/index.php/API:_сертификаты_сервисов <font><font>API: service certificates</font></font>]''' |
| − | | | + | | style="width: 407px;" | |
| − | '''[https://docs.brainycp.io/index.php/API:_CRON API: CRON]''' | + | '''[https://docs.brainycp.io/index.php/API:_CRON <font><font>API: CRON</font></font>]''' |
|- | |- | ||
| − | | | + | | style="width: 274px;" | |
| − | '''[https://docs.brainycp.io/index.php/API:_менеджер_процессов API: | + | '''[https://docs.brainycp.io/index.php/API:_менеджер_процессов <font><font>API: process manager</font></font>]''' |
| − | | | + | | style="width: 321px;" | |
| − | '''[https://docs.brainycp.io/index.php/API:_сетевые_инструменты API: | + | '''[https://docs.brainycp.io/index.php/API:_сетевые_инструменты <font><font>API: network tools</font></font>]''' |
| − | | | + | | style="width: 407px;" | |
| − | '''[https://docs.brainycp.io/index.php/API:_FTP-сервер API: FTP | + | '''[https://docs.brainycp.io/index.php/API:_FTP-сервер <font><font>API: FTP server</font></font>]''' |
|- | |- | ||
| − | | | + | | style="width: 274px;" | |
| − | '''[https://docs.brainycp.io/index.php/API:_менеджер_IP-адресов API: | + | '''[https://docs.brainycp.io/index.php/API:_менеджер_IP-адресов <font><font>API: IP address manager</font></font>]''' |
| − | | | + | | style="width: 321px;" | |
| − | '''[https://docs.brainycp.io/index.php/API:_средняя_нагрузка API: | + | '''[https://docs.brainycp.io/index.php/API:_средняя_нагрузка <font><font>API: average load</font></font>]''' |
| − | | | + | | style="width: 407px;" | |
| − | '''[https://docs.brainycp.io/index.php/API:_MySQL_processlist API: MySQL processlist]''' | + | '''[https://docs.brainycp.io/index.php/API:_MySQL_processlist <font><font>API: MySQL processlist</font></font>]''' |
|} | |} | ||
| | ||
Revision as of 11:41, 17 November 2021
Administrative functions require API root rights in order to use any login hosted on the server. If you do not have root rights, you can only use your login.
Incoming data marked with an asterisk are required.
| Module |
Function |
Incoming data |
Error variants |
|
dbusage |
List of user databases. show_db |
username (post or get) * - username; password (post or get) * - user password; dbusage (post or get) * - constant, module name; show_db (post or get) * - constant, operation name; user_edit (post or get) - the name of the user being edited; language (post or get) - can take the value: en / ru (ru by default).
|
error: 0, mess: 'Displaying user bases'; error: 100, mess: 'The array of bases is empty'; error: 400, mess: 'You do not have sufficient rights. Remove user_edit '.
|
|
dbusage |
List of users of user databases.. show_users |
username (post or get) * - username; password (post or get) * - user password; dbusage (post or get) * - constant, module name; show_users (post or get) * - constant, operation name; user_edit (post or get) - the name of the user being edited; language (post or get) - can take the value: en / ru (ru by default).
|
error: 0, mess: 'Displaying all users'; error: 100, mess: 'The user array is empty'; error: 400, mess: 'You do not have sufficient rights. Remove user_edit '.
|
|
dbusage |
List of database user privileges. show_privilegies |
username (post or get) * - username; password (post or get) * - user password; dbusage (post or get) * - constant, module name; show_privilegies (post or get) * - constant, operation name; name_db (post or get) * - the name of the database; name_user (post or get) * - database user; language (post or get) - can take the value: en / ru (ru by default).
|
error: 0, mess: 'Privilege list'; error: 100, mess: 'The user has no privileges. The list of privileges is empty '; error: 101, mess: 'Username is empty'; error: 102, mess: 'Database name must be filled'.
|
|
dbusage |
Add database. add_db |
username (post or get) * - username; password (post or get) * - user password; dbusage (post or get) * - constant, module name; add_db (post or get) * - constant, operation name; name_db (post or get) * - the name of the database; user_edit (post or get) - the name of the user being edited;
language (post или get) —can take a value: en/ru (by default ru). |
error: 0, message: 'Database created'; error: 100, message: 'Database name must be filled in'; error: 108, message: 'Wrong mysql root password. Please connects with server administrator '; error: -1, message: 'Database exists'; error: 400, message: 'You do not have sufficient rights. Remove user_edit '; error: 404, message: 'mysql is not working'; error: 107, message: 'Error. You have reached the maximum number of bases'; error: 100, message: 'DB NAME must be filled'; error: 102, message: 'DB already exists'.
|
|
dbusage |
Add user. add_user |
username (post or get) * - username; password (post or get) * - user password; dbusage (post or get) * - constant, module name; add_user (post or get) * - constant, operation name; login_user (post or get) * - database user login; password_user (post or get) * - database user password; user_edit (post or get) - the name of the user being edited; language (post or get) - can take the value: en / ru (ru by default).
|
error: 0, mess: 'User added'; error: 404, mess: 'mysql is not working'; error: 108, mess: 'Wrong mysql root password. Please connects with server administrator '; error: 101, mess: 'Username is empty'; error: 102, mess: 'The password for user bd is empty'; error: 400, mess: 'You do not have sufficient rights. Remove user_edit '; error: -1, mess: 'User exists'; error: 100, mess: 'Login must be filled'; error: 101, mess: 'Login must be no more than 7 letters' error: 102, mess: 'Login already exists'; error: 100, mess: 'Password must be filled'.
|
|
dbusage |
Add user to database. add_user_db |
username (post or get) * - username; password (post or get) * - user password; dbusage (post or get) * - constant, module name; add_user_db (post or get) * - constant, operation name; name_db (post or get) * - the name of the database; name_user (post or get) * - database user; user_edit (post or get) - the name of the user being edited; language (post or get) - can take the value: en / ru (ru by default); privilegies name_user (post or get) * = all_privilegies (all privileges); open_remote (post or get) * - remote access ip-addresses separated by commas.
|
error: 0, mess: 'Privileges applied'; error: 100, mess: 'Privilege is written incorrectly'; error: 101, mess: 'Username is empty'; error: 102, mess: 'Database name must be filled in'; error: 109, mess: 'DB validation failed'; error: 110, mess: 'User verification error'; error: 404, mess: 'mysql is not working'; error: 108, mess: 'mysql is not working'; error: 405, mess: 'Attempt to edit data that is not your own'.
|
| dbusage |
Removing a user from the database . drop_user |
username (post or get) * - username; |
error: 0, mess: 'Successfully completed'; error: 404, mess: 'mysql is not working'; error: 101, mess: 'Username is empty'; error: 105, mess: 'There is no such user'; |
| dbusage |
Removing the database. drop_db |
username (post or get) * - username; password (post or get) * - user password; dbusage (post or get) * - constant, module name; drop_db (post or get) * - constant, operation name; name_db (post or get) * - the name of the database (to be deleted); user_edit (post or get) - the name of the user being edited; language (post or get) - can take the value: en / ru (ru by default); |
error: 0, mess: 'Successfully completed'; error: 404, mess: 'mysql is not working'; error: 100, mess: 'Database name must be filled.'; error: 106, mess: 'There is no such database'; |
Other useful articles:
