public ActionResult Post([FromForm] MyModelGen model)
{
try
{
if (!Directory.Exists(model.Source))
{
return(Json(new { message = "Nhập sai đường dẫn nguồn" }));
}
if (!Directory.Exists(model.Destination))
{
Directory.CreateDirectory(model.Destination);
}
this.Copy(model.Source, model.Destination);
}
catch (Exception ex)
{
return(Json(new { message = ex.Message, data = ex }));
}
return(Json(new { message = "Sao chép thành công!" }));
}
public async Task <Data.ObjectResult> Post([FromBody] MyModelGen modelGen)
{
using (var client = new SshClient("103.7.41.51", "root", "Gsoft@235"))
{
try
{
client.ConnectionInfo.Timeout = TimeSpan.FromSeconds(1200);
client.Connect();
if (client.IsConnected)
{
using (SftpClient sftpClient = new SftpClient("103.7.41.51", 22, "root", "Gsoft@235"))
{
sftpClient.ConnectionInfo.Timeout = TimeSpan.FromSeconds(1200);
sftpClient.OperationTimeout = TimeSpan.FromSeconds(1200);
sftpClient.Connect();
if (sftpClient.IsConnected)
{
bool isExist = false;
try
{
sftpClient.ChangeDirectory("/home/gwebsite/public_html/" + modelGen.Subdomain);
isExist = true;
}
catch (SftpPathNotFoundException)
{
isExist = false;
}
finally
{
sftpClient.Disconnect();
}
if (isExist)
{
Data.ObjectResult checkResult = new Data.ObjectResult();
checkResult.isSucceeded = false;
checkResult.ErrorMessage = "Website này đã được khởi tạo!";
return(checkResult);
}
}
}
////Copy source tu folder goc fromLocation sang folder moi toDestination
// client.RunCommand($"mkdir '{modelGen.Destination}' && cd '{modelGen.Source}' && cp * '{modelGen.Destination}'");
client.RunCommand($"mkdir '{modelGen.Destination}' && cp -a '{modelGen.Source + "/."}' '{modelGen.Destination}'");
// client.RunCommand($"cd /home/gwebsite/public_html");
//Fix permission cua tat ca folder ve 0755 va cac file ve 0644
string chmodCommand = "find " + "'/home/gwebsite/public_html/" + modelGen.Subdomain + @"' -type d -exec chmod 0755 {} \;";
client.RunCommand(chmodCommand);
string chmodAllSubFolder = "find " + "'/home/gwebsite/public_html/" + modelGen.Subdomain + "/.'" + @" -type d -exec chmod 0755 {} \;";
client.RunCommand(chmodAllSubFolder);
string chmodAllFile = "find " + "'/home/gwebsite/public_html/" + modelGen.Subdomain + "/.'" + @" -type f -exec chmod 0644 {} \;";
client.RunCommand(chmodAllFile);
//Fix permission chuyen owner cua tat ca cac file va folder source tu root -> gwebsite
string chownFolder = "chown gwebsite:gwebsite " + "'/home/gwebsite/public_html/" + modelGen.Subdomain + "'";
client.RunCommand(chownFolder);
string chownAllContent = "chown -R gwebsite:gwebsite " + "'/home/gwebsite/public_html/" + modelGen.Subdomain + "'";
client.RunCommand(chownAllContent);
/*------------*/
//Khoi tao ket noi vao MySqL
//(Khi deploy that tren Server thi PortFoward phai la "0" khi deploy Local thi la "3306")
var portForwarded = new ForwardedPortLocal("127.0.0.1", 0, "127.0.0.1", 3306);
client.AddForwardedPort(portForwarded);
portForwarded.Start();
// DatabaseConnect mySqlConnector = new DatabaseConnect("Server=127.0.0.1; Port=3306; Uid=root; Pwd=JOpaqGH7N7xz;");
DatabaseConnect mySqlConnector = new DatabaseConnect(modelGen.MySQlConnectionString);
// string createUserandDBScript = $"CREATE DATABASE IF NOT EXISTS {modelGen.DatabaseName}; CREATE USER '{modelGen.DatabaseUser}'@'localhost' IDENTIFIED BY '{modelGen.Password}'; GRANT ALL PRIVILEGES ON {modelGen.DatabaseName}. * TO '{modelGen.DatabaseUser}'@'localhost';FLUSH PRIVILEGES;";
Data.ObjectResult result = new Data.ObjectResult();
result = mySqlConnector.OpenConnection();
if (result.isSucceeded == false)
{
mySqlConnector.CloseConnection();
//result.ErrorMessage = "Lỗi không tạo được kết nối đến MySQL";
return(result);
}
string createDatabaseScript = $"CREATE DATABASE IF NOT EXISTS {modelGen.DatabaseName} CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci;";
string createUserScript = $"CREATE USER '{modelGen.DatabaseUser}'@'localhost' IDENTIFIED BY '{modelGen.Password}';";
string grantPermission = $"GRANT ALL PRIVILEGES ON {modelGen.DatabaseName}.* TO '{modelGen.DatabaseUser}'@'localhost' IDENTIFIED BY '{modelGen.Password}';";
string resetPermissionTable = $"FLUSH PRIVILEGES;";
result = await mySqlConnector.ExecuteCommand(createDatabaseScript);
if (result.isSucceeded == false)
{
mySqlConnector.CloseConnection();
return(result);
}
result = await mySqlConnector.ExecuteCommand(createUserScript);
if (result.isSucceeded == false)
{
mySqlConnector.CloseConnection();
return(result);
}
result = await mySqlConnector.ExecuteCommand(grantPermission);
if (result.isSucceeded == false)
{
mySqlConnector.CloseConnection();
return(result);
}
result = await mySqlConnector.ExecuteCommand(resetPermissionTable);
if (result.isSucceeded == false)
{
mySqlConnector.CloseConnection();
return(result);
}
//isSucceeded = await mySqlConnector.ExecuteCommand(createUserandDBScript);
//if (isSucceeded == false)
//{
// return "Lỗi xảy ra khi tạo DB và User";
//}
//Import du lieu vao DB vua tao
if (!String.IsNullOrEmpty(modelGen.ScriptLocation))
{
result = await mySqlConnector.ExecuteCommand($"USE {modelGen.DatabaseName};");
if (result.isSucceeded == false)
{
mySqlConnector.CloseConnection();
return(result);
}
//execute file script vao DB vua tao
SshCommand getScriptFileCommand = client.CreateCommand($"cat '{modelGen.ScriptLocation}'");
string scriptContent = getScriptFileCommand.Execute();
string setCharacter = "set names utf8mb4";
result = await mySqlConnector.ExecuteCommand(setCharacter);
if (result.isSucceeded == false)
{
mySqlConnector.CloseConnection();
return(result);
}
// scriptContent = Convert.ToBase64String(Encoding.UTF8.GetBytes(scriptContent));
//scriptContent = Encoding.UTF8.GetString(Convert.FromBase64String(scriptContent));
//byte[] encodedFile = Encoding.Unicode.GetBytes(scriptContent);
//scriptContent = Encoding.Unicode.GetString(encodedFile);
if (!String.IsNullOrEmpty(scriptContent))
{
result = await mySqlConnector.ExecuteCommand(scriptContent);
if (result.isSucceeded == false)
{
//mySqlConnector.CloseConnection();
// return result;
}
}
}
string changeDBQuery = $"USE {modelGen.DatabaseName};";
result = await mySqlConnector.ExecuteCommand(changeDBQuery);
if (result.isSucceeded == false)
{
mySqlConnector.CloseConnection();
return(result);
}
string siteURL = "http://" + modelGen.Subdomain + "." + modelGen.Domain;
string updateSiteURLQuery = $"Update wp_options SET option_value = '{siteURL}' WHERE option_name = 'siteurl'";
result = await mySqlConnector.ExecuteCommand(updateSiteURLQuery);
if (result.isSucceeded == false)
{
mySqlConnector.CloseConnection();
return(result);
}
string updateHomeQuery = $"Update wp_options SET option_value = '{siteURL}' WHERE option_name = 'home'";
result = await mySqlConnector.ExecuteCommand(updateHomeQuery);
if (result.isSucceeded == false)
{
mySqlConnector.CloseConnection();
return(result);
}
string useCWP = "USE root_cwp;";
result = await mySqlConnector.ExecuteCommand(useCWP);
if (result.isSucceeded == false)
{
mySqlConnector.CloseConnection();
return(result);
}
string insertSubdomain = $"Insert into subdomains (subdomain,domain,user,path,setup_time) values('{modelGen.Subdomain}','{modelGen.Domain}','gwebsite','{modelGen.Destination}','{DateTime.Now}')";
result = await mySqlConnector.ExecuteCommand(insertSubdomain);
if (result.isSucceeded == false)
{
mySqlConnector.CloseConnection();
return(result);
}
//string switchToCWPDatabase = "USE cwp_root;";
// string createSubdommainScript = "";
//mySqlConnector.ExecuteCommand("");
//Dong ket noi MySQL
mySqlConnector.CloseConnection();
//hieu chinh file wp-config
string configFileLocation = modelGen.Destination + "/wp-config.php";
SshCommand getWordpressConfigFile = client.CreateCommand($"cat '{configFileLocation}'");
string wpconfigContent = getWordpressConfigFile.Execute();
if (!String.IsNullOrEmpty(wpconfigContent))
{
wpconfigContent = wpconfigContent.Replace("define('DB_NAME','');", $"define('DB_NAME','{modelGen.DatabaseName}');");
wpconfigContent = wpconfigContent.Replace("define('DB_USER','');", $"define('DB_USER','{modelGen.DatabaseUser}');");
wpconfigContent = wpconfigContent.Replace("define('DB_PASSWORD','');", $"define('DB_PASSWORD','{modelGen.Password}');");
using (SftpClient sftpClient = new SftpClient("103.7.41.51", 22, "root", "Gsoft@235"))
{
sftpClient.ConnectionInfo.Timeout = TimeSpan.FromSeconds(1200);
sftpClient.OperationTimeout = TimeSpan.FromSeconds(1200);
sftpClient.Connect();
if (sftpClient.IsConnected)
{
try
{
using (MemoryStream memStream = new MemoryStream(System.Text.Encoding.UTF8.GetBytes(wpconfigContent)))
{
try
{
sftpClient.UploadFile(memStream, configFileLocation, true);
}
catch (Exception ex)
{
Data.ObjectResult objRS = new Data.ObjectResult();
objRS.isSucceeded = false;
objRS.ErrorMessage = "Có lỗi xảy ra khi cập nhật lại file wp-config";
return(objRS);
}
}
}
catch (Exception ex)
{
Data.ObjectResult objRS = new Data.ObjectResult();
objRS.isSucceeded = false;
objRS.ErrorMessage = "Có lỗi xảy ra khi tạo file wp-config - " + ex.Message;
return(objRS);
}
finally
{
sftpClient.Disconnect();
}
}
}
}
///Sua File VHost
string vHostFileLocation = "/usr/local/apache/conf.d/vhosts.conf";
SshCommand getvHostFile = client.CreateCommand($"cat '{vHostFileLocation}'");
string vHostFile = getvHostFile.Execute();
string vHostContent = "";
//vHostContent += Environment.NewLine;
// vHostContent += $"# vhost_start {modelGen.Subdomain + "." + modelGen.Domain} ";
vHostContent += Environment.NewLine;
vHostContent += "<VirtualHost 103.7.41.51:8181> ";
vHostContent += Environment.NewLine;
vHostContent += $"ServerName {modelGen.Subdomain + "." + modelGen.Domain} ";
vHostContent += Environment.NewLine;
vHostContent += $"ServerAlias www.{modelGen.Subdomain + "." + modelGen.Domain}";
vHostContent += Environment.NewLine;
vHostContent += $"ServerAdmin webmaster@{modelGen.Subdomain + "." + modelGen.Domain}";
vHostContent += Environment.NewLine;
vHostContent += $"DocumentRoot /home/gwebsite/public_html/{modelGen.Subdomain}";
vHostContent += Environment.NewLine;
vHostContent += "UseCanonicalName Off";
vHostContent += Environment.NewLine;
vHostContent += $"ScriptAlias /cgi-bin/ /home/gwebsite/public_html/{modelGen.Subdomain}/cgi-bin/";
vHostContent += Environment.NewLine;
vHostContent += $"# Custom settings are loaded below this line (if any exist)";
vHostContent += Environment.NewLine;
vHostContent += "# Include " + '"' + $"/usr/local/apache/conf/userdata/gwebsite/{modelGen.Subdomain + "." + modelGen.Domain}/*.conf";
vHostContent += Environment.NewLine;
vHostContent += Environment.NewLine;
vHostContent += "<IfModule mod_userdir.c>";
vHostContent += Environment.NewLine;
vHostContent += "UserDir disabled";
vHostContent += Environment.NewLine;
vHostContent += "UserDir enabled gwebsite";
vHostContent += Environment.NewLine;
vHostContent += "</IfModule>";
vHostContent += Environment.NewLine;
vHostContent += Environment.NewLine;
vHostContent += "<IfModule mod_suexec.c>";
vHostContent += Environment.NewLine;
vHostContent += "SuexecUserGroup gwebsite gwebsite";
vHostContent += Environment.NewLine;
vHostContent += "</IfModule>";
vHostContent += Environment.NewLine;
vHostContent += Environment.NewLine;
vHostContent += "<IfModule mod_suphp.c>";
vHostContent += Environment.NewLine;
vHostContent += "suPHP_UserGroup gwebsite gwebsite";
vHostContent += Environment.NewLine;
vHostContent += "suPHP_ConfigPath /home/gwebsite>";
vHostContent += Environment.NewLine;
vHostContent += "</IfModule>";
vHostContent += Environment.NewLine;
vHostContent += Environment.NewLine;
vHostContent += "<Directory " + '"' + $"/home/gwebsite/public_html/{modelGen.Subdomain}" + '"' + '>';
vHostContent += Environment.NewLine;
vHostContent += "AllowOverride All";
vHostContent += Environment.NewLine;
vHostContent += "</Directory>";
vHostContent += Environment.NewLine;
vHostContent += Environment.NewLine;
vHostContent += "</VirtualHost>";
vHostContent += Environment.NewLine;
//vHostContent += $"# vhost_end {modelGen.Subdomain + "." + modelGen.Domain}";
//vHostFile += Environment.NewLine;
vHostFile += vHostContent;
using (SftpClient sftpClient = new SftpClient("103.7.41.51", 22, "root", "Gsoft@235"))
{
sftpClient.ConnectionInfo.Timeout = TimeSpan.FromSeconds(1200);
sftpClient.OperationTimeout = TimeSpan.FromSeconds(1200);
sftpClient.Connect();
if (sftpClient.IsConnected)
{
try
{
using (MemoryStream memStream = new MemoryStream(System.Text.Encoding.UTF8.GetBytes(vHostFile)))
{
try
{
sftpClient.UploadFile(memStream, vHostFileLocation, true);
}
catch (Exception ex)
{
Data.ObjectResult objRS = new Data.ObjectResult();
objRS.isSucceeded = false;
objRS.ErrorMessage = "Có lỗi xảy ra khi cập nhật lại file vHost của Apache";
return(objRS);
}
}
}
catch (Exception ex)
{
Data.ObjectResult objRS = new Data.ObjectResult();
objRS.isSucceeded = false;
objRS.ErrorMessage = "Có lỗi xảy ra khi tạo file vHost - " + ex.Message;
return(objRS);
}
finally
{
sftpClient.Disconnect();
}
}
}
//Restart Apache de nhan Vhost moi
string restartApacheCommand = "systemctl restart httpd.service";
client.RunCommand(restartApacheCommand);
mySqlConnector.CloseConnection();
client.Disconnect();
}
else
{
Data.ObjectResult result = new Data.ObjectResult();
result.isSucceeded = false;
result.ErrorMessage = "Kết nối SSH đến VPS thất bại";
return(result);
}
Data.ObjectResult rs = new Data.ObjectResult();
rs.isSucceeded = true;
rs.ErrorMessage = "Website đã được khởi tạo!";
return(rs);
}
catch (Exception ex)
{
Data.ObjectResult rs = new Data.ObjectResult();
rs.isSucceeded = false;
rs.ErrorMessage = "Lỗi - " + ex.Message;
return(rs);
}
finally
{
client.Disconnect();
}
}
}
