| public AddToLog ( string audit, bool alwaysLog ) : void | ||
| audit | string | |
| alwaysLog | bool | |
| return | void | |
/// <summary>
/// Gets an image from the DB
/// </summary>
/// <param name="imageId">The id of the image to get</param>
/// <returns>the requested image</returns>
public OSAEImage GetImage(int imageId)
{
OSAEImage osaeImage = new OSAEImage();
if (Common.TestConnection())
{
using (MySqlConnection connection = new MySqlConnection(Common.ConnectionString))
{
MySqlCommand command = new MySqlCommand("SELECT * FROM osae_images WHERE image_id = " + imageId, connection);
connection.Open();
MySqlDataReader reader = command.ExecuteReader();
if (reader.Read())
{
osaeImage.ID = reader.GetUInt32("image_id");
osaeImage.Name = reader.GetString("image_name");
osaeImage.Type = reader.GetString("image_type");
osaeImage.Data = (byte[])reader.GetValue(1);
}
else
{
logging.AddToLog("API - Failed to get requested image from DB: " + imageId.ToString(), true);
}
}
}
return(osaeImage);
}
/// <summary>
/// Create a new object
/// </summary>
/// <param name="name"></param>
/// <param name="description"></param>
/// <param name="objectType"></param>
/// <param name="address"></param>
/// <param name="container"></param>
public static void ObjectAdd(string name, string alias, string description, string objectType, string address, string container, int minTrustLevel, bool enabled)
{
Logging logging = Logging.GetLogger();
using (MySqlCommand command = new MySqlCommand())
{
command.CommandText = "osae_sp_object_add";
command.CommandType = CommandType.StoredProcedure;
command.Parameters.AddWithValue("?pname", name);
command.Parameters.AddWithValue("?palias", alias);
command.Parameters.AddWithValue("?pdescription", description);
command.Parameters.AddWithValue("?pobjecttype", objectType);
command.Parameters.AddWithValue("?paddress", address);
command.Parameters.AddWithValue("?pcontainer", container);
command.Parameters.AddWithValue("?pmintrustlevel", minTrustLevel);
command.Parameters.AddWithValue("?penabled", enabled);
command.Parameters.Add(new MySqlParameter("?results", MySqlDbType.Int32));
command.Parameters["?results"].Direction = ParameterDirection.Output;
try
{
MySqlConnection connection = new MySqlConnection(Common.ConnectionString);
command.Connection = connection;
command.Connection.Open();
command.ExecuteNonQuery();
if (command.Parameters["?results"].Value.ToString() == "1")
{
logging.AddToLog("API - ObjectAdded successfully", true);
}
else if (command.Parameters["?results"].Value.ToString() == "2")
{
logging.AddToLog("API - ObjectAdd failed. Object type doesn't exist.", true);
}
else if (command.Parameters["?results"].Value.ToString() == "3")
{
logging.AddToLog("API - ObjectAdd failed. Object with same name or address already exists", true);
}
}
catch (Exception ex)
{
logging.AddToLog("API - ObjectAdd error: " + command.CommandText + " - error: " + ex.Message, true);
}
}
}
public bool ActivatePlugin()
{
try
{
logging.AddToLog("Activating Plugin: " + PluginName, true);
_plugin = (OSAEPluginBase)_domain.CreateInstanceAndUnwrap(_assemblyName, _assemblyType);
_plugin.InitializeLifetimeService();
_domain.UnhandledException += Domain_UnhandledException;
return(true);
}
catch (Exception ex)
{
logging.AddToLog("Error activating plugin (" + PluginName + "): " + ex.Message + " - " + ex.InnerException, true);
_enabled = false;
return(false);
}
}
static void Main(string[] args)
{
if (args.Length > 0)
{
Logging commandLineLogging = new Logging("OSACL");
OSAE osacl = new OSAE("OSACL");
string pattern = osacl.MatchPattern(args[0]);
commandLineLogging.AddToLog("Processing command: " + args[0] + ", Pattern: " + pattern, true);
if (pattern != "")
osacl.MethodQueueAdd("Script Processor", "NAMED SCRIPT", pattern, "");
}
else
{
ServiceBase.Run(new ClientService());
}
}
public static bool InstallPlugin(string PluginPackagePath, ref string ErrorText)
{
OSAE osae = new OSAE("Plugin Installer");
Logging logging = new Logging("Plugin Installer");
string exePath = Path.GetDirectoryName(Application.ExecutablePath);
if (Directory.Exists(exePath + "/tempDir/"))
{
Directory.Delete(exePath + "/tempDir/", true);
}
PluginDescription desc = new PluginDescription();
string tempfolder = exePath + "/tempDir/";
string zipFileName = Path.GetFullPath(PluginPackagePath);
string DescPath = null;
bool NoError = true;
FastZip fastZip = new FastZip();
//try
//{
fastZip.ExtractZip(zipFileName, tempfolder, null);
// find all included plugin descriptions and install the plugins
List<string> osapdFiles = new List<string>();
List<string> sqlFiles = new List<string>();
string[] pluginFile = Directory.GetFiles(tempfolder, "*.osapd", SearchOption.TopDirectoryOnly);
osapdFiles.AddRange(pluginFile);
string[] sqlFile = Directory.GetFiles(tempfolder, "*.sql", SearchOption.TopDirectoryOnly);
sqlFiles.AddRange(sqlFile);
if (osapdFiles.Count == 0)
{
MessageBox.Show("No plugin description files found.");
return false;
}
if (osapdFiles.Count > 1)
{
MessageBox.Show("More than one plugin description file found.");
return false;
}
if (osapdFiles.Count == 1)
{
DescPath = osapdFiles[0];
}
if (!string.IsNullOrEmpty(DescPath))
{
desc.Deserialize(DescPath);
//NoError = desc.VerifyInstall(ref ErrorText);
//uninstall previous plugin and delete the folder
bool u = UninstallPlugin(desc);
// get the plugin folder path
string pluginFolder = desc.Path;
if (!string.IsNullOrEmpty(pluginFolder)) //only extract valid plugins
{
//Directory.CreateDirectory(exePath + "/Plugins/" + pluginFolder);
string[] files = System.IO.Directory.GetFiles(tempfolder);
// Copy the files and overwrite destination files if they already exist.
//foreach (string s in files)
//{
// string fileName = System.IO.Path.GetFileName(s);
// if (desc.AdditionalAssemblies.Contains(fileName))
// {
// string destFile = System.IO.Path.Combine(exePath + "/", fileName);
// System.IO.File.Copy(s, destFile, true);
// }
//}
string ConnectionString = string.Format("Uid={0};Pwd={1};Server={2};Port={3};Database={4};allow user variables=true",
osae.DBUsername, osae.DBPassword, osae.DBConnection, osae.DBPort, osae.DBName);
MySql.Data.MySqlClient.MySqlConnection connection = new MySql.Data.MySqlClient.MySqlConnection(ConnectionString);
connection.Open();
foreach (string s in sqlFile)
{
try
{
MySql.Data.MySqlClient.MySqlScript script = new MySql.Data.MySqlClient.MySqlScript(connection,File.ReadAllText(s));
script.Execute();
}
catch (Exception ex)
{
logging.AddToLog("Error running sql script: " + s + " | " + ex.Message, true);
}
}
System.IO.Directory.Move(tempfolder, exePath + "/Plugins/" + pluginFolder);
//Check if we are running a x64 bit architecture (This is a silly way to do it since I am not sure if every 64 bit machine has this directory...)
bool is64bit = Environment.Is64BitOperatingSystem;
//Do a check for any x64 assemblies, and prompt the user to install them if they are running a 64 bit machine
if (is64bit && (desc.x64Assemblies.Count > 0))
{
/* x64 assemblies generally have the same name as their x32 counterparts when referenced by the OSA app
* however they are packaged as "filename.ext.x64" so we will replace the 32bit file which is installed by
* default with the 64bit versioin with the same filename.ext
*/
if (MessageBox.Show(
"You are running an x64 architecture and this plugin has specific assemblies built for 64bit machines." +
" It is highly recommended that you install the 64bit versions to ensure proper compatibility",
"Install 64bit Assemblies?", MessageBoxButtons.YesNo) == DialogResult.Yes)
{
//Install the 64bit assemblies over the 32 bit ones...
string[] x64files = System.IO.Directory.GetFiles(exePath + "/Plugins/" + pluginFolder, "*.x64");
foreach (string str in x64files)
{
string destFile = System.IO.Path.Combine(exePath + "/Plugins/" + pluginFolder + "/", System.IO.Path.GetFileNameWithoutExtension(str));
//Copy it to the new destination overwriting the old file if it exists
System.IO.File.Copy(str, destFile, true);
}
}
}
//Delete all the files with .x64 extensions since they aren't needed anymore
string[] delfiles = System.IO.Directory.GetFiles(exePath + "/Plugins/" + pluginFolder, "*.x64");
foreach (string str in delfiles)
System.IO.File.Delete(str);
logging.AddToLog("Sending message to service to load plugin.", true);
using (MySql.Data.MySqlClient.MySqlCommand command = new MySql.Data.MySqlClient.MySqlCommand())
{
command.CommandText = "CALL osae_sp_method_queue_add (@pobject,@pmethod,@pparameter1,@pparameter2,@pfromobject,@pdebuginfo);";
command.Parameters.AddWithValue("@pobject", "SERVICE-" + osae.ComputerName);
command.Parameters.AddWithValue("@pmethod", "LOAD PLUGIN");
command.Parameters.AddWithValue("@pparameter1", "");
command.Parameters.AddWithValue("@pparameter2", "");
command.Parameters.AddWithValue("@pfromobject", "");
command.Parameters.AddWithValue("@pdebuginfo", "");
try
{
osae.RunQuery(command);
}
catch (Exception ex)
{
logging.AddToLog("Error adding LOAD PLUGIN method: " + command.CommandText + " - error: " + ex.Message, true);
}
}
}
}
//}
//catch (Exception ex)
//{
// MessageBox.Show("catch: " + ex.Message);
// return false;
//}
if (Directory.Exists(exePath + "/tempDir/"))
{
deleteFolder(exePath + "/tempDir/");
}
osae.MethodQueueAdd("SERVICE-" + osae.ComputerName, "RELOAD PLUGINS", "", "");
return NoError;
}
