MySQL-User/Mysql-Database/FTP-User
hello people,
I have problems with the build of MySQL users.
View all users:
public function sites_database_get_all_by_user($session_id, $client_id) { global $app; //if(!$this->checkPerm($session_id, 'sites_database_get')) { //$this->server->fault('permission_denied', 'You do not have the permissions to access this function.'); // return false; // } $client_id = $app->functions->intval($client_id); $sql = "SELECT d.database_id, d.database_name, d.database_user_id, d.database_ro_user_id, du.database_user, du.database_password, du.sys_groupid FROM web_database d LEFT JOIN web_database_user du ON (du.database_user_id = d.database_user_id) INNER JOIN sys_user s ON (d.sys_groupid = s.default_group AND du.sys_groupid = s.default_group) WHERE client_id = $client_id"; $all = $app->db->queryAllRecords($sql); return $all; }
Error in the documentation for database add
Parameter (in $ params): server_id (int (11)) type (varchar (16)) database_name (varchar (64)) database_user_ID (int (11)) database_ro_user_id (int (11)) database_password (varchar (64)) database_charset (varchar (64)) REMOTE_ACCESS (enum ('n', 'y')) remote_ips (text) backup_interval (varchar (255)) backup_copies (int (11)) active (enum ('n', 'y')) output:
Database and user add
Parameter (in $ params): server_id (int (11)) database_user (varchar (64)) database_password (varchar (64)) output:
Typo error in the Database_user_add, example file. $database_id = $client->sites_database_user_add($session_id, $client_id, $params); database_id echo "Database ID:" $ database_user_ID "n";
When creating the database, he breaks with System error: Call to undefined method remoting :: insertQueryPrepare () from.
When you create one ftp-users is a created but not the params processed.
I hope you understand me. ;)