/* * Copyright (c) Contributors, http://opensimulator.org/ * See CONTRIBUTORS.TXT for a full list of copyright holders. * * Redistribution and use in source and binary forms, with or without * modification, are permitted provided that the following conditions are met: * * Redistributions of source code must retain the above copyright * notice, this list of conditions and the following disclaimer. * * Redistributions in binary form must reproduce the above copyright * notice, this list of conditions and the following disclaimer in the * documentation and/or other materials provided with the distribution. * * Neither the name of the OpenSim Project nor the * names of its contributors may be used to endorse or promote products * derived from this software without specific prior written permission. * * THIS SOFTWARE IS PROVIDED BY THE DEVELOPERS ``AS IS'' AND ANY * EXPRESS OR IMPLIED WARRANTIES, INCLUDING, BUT NOT LIMITED TO, THE IMPLIED * WARRANTIES OF MERCHANTABILITY AND FITNESS FOR A PARTICULAR PURPOSE ARE * DISCLAIMED. IN NO EVENT SHALL THE CONTRIBUTORS BE LIABLE FOR ANY * DIRECT, INDIRECT, INCIDENTAL, SPECIAL, EXEMPLARY, OR CONSEQUENTIAL DAMAGES * (INCLUDING, BUT NOT LIMITED TO, PROCUREMENT OF SUBSTITUTE GOODS OR SERVICES; * LOSS OF USE, DATA, OR PROFITS; OR BUSINESS INTERRUPTION) HOWEVER CAUSED AND * ON ANY THEORY OF LIABILITY, WHETHER IN CONTRACT, STRICT LIABILITY, OR TORT * (INCLUDING NEGLIGENCE OR OTHERWISE) ARISING IN ANY WAY OUT OF THE USE OF THIS * SOFTWARE, EVEN IF ADVISED OF THE POSSIBILITY OF SUCH DAMAGE. */ using System; using System.Data.SqlClient; using System.Reflection; using System.Collections.Generic; using System.Data; using log4net; using OpenSim.Framework; namespace OpenSim.Data.MSSQL { /// <summary> /// An interface to the log database for MSSQL /// </summary> internal class MSSQLLogData : ILogDataPlugin { private const string _migrationStore = "LogStore"; private static readonly ILog m_log = LogManager.GetLogger(MethodBase.GetCurrentMethod().DeclaringType); /// <summary> /// The database manager /// </summary> public MSSQLManager database; public void Initialise() { m_log.Info("[LOG DB]: " + Name + " cannot be default-initialized!"); throw new PluginNotInitialisedException (Name); } /// <summary> /// Artificial constructor called when the plugin is loaded /// </summary> public void Initialise(string connect) { if (string.IsNullOrEmpty(connect)) { database = new MSSQLManager(connect); } else { // TODO: do something with the connect string IniFile gridDataMSSqlFile = new IniFile("mssql_connection.ini"); string settingDataSource = gridDataMSSqlFile.ParseFileReadValue("data_source"); string settingInitialCatalog = gridDataMSSqlFile.ParseFileReadValue("initial_catalog"); string settingPersistSecurityInfo = gridDataMSSqlFile.ParseFileReadValue("persist_security_info"); string settingUserId = gridDataMSSqlFile.ParseFileReadValue("user_id"); string settingPassword = gridDataMSSqlFile.ParseFileReadValue("password"); database = new MSSQLManager(settingDataSource, settingInitialCatalog, settingPersistSecurityInfo, settingUserId, settingPassword); } //TODO when can this be removed TestTable(); //Updating mechanisme database.CheckMigration(_migrationStore); } /// <summary> /// Can be removed someday!!! /// </summary> private void TestTable() { using (IDbCommand cmd = database.Query("select top 1 * from logs", new Dictionary<string, string>())) { try { cmd.ExecuteNonQuery(); } catch { database.ExecuteResourceSql("Mssql-logs.sql"); } } using (AutoClosingSqlCommand cmd = database.Query("select * from migrations where name = '" + _migrationStore + "'")) { //Special for Migrations to create backword compatible try { bool insert = true; using (SqlDataReader reader = cmd.ExecuteReader()) { if (reader.Read()) insert = false; } if (insert) { cmd.CommandText = "insert into migrations(name, version) values('" + _migrationStore + "', 1)"; cmd.ExecuteNonQuery(); } } catch { //No migrations table //HACK create one and add data cmd.CommandText = "create table migrations(name varchar(100), version int)"; cmd.ExecuteNonQuery(); cmd.CommandText = "insert into migrations(name, version) values('migrations', 1)"; cmd.ExecuteNonQuery(); cmd.CommandText = "insert into migrations(name, version) values('" + _migrationStore + "', 1)"; cmd.ExecuteNonQuery(); } } } /// <summary> /// Saves a log item to the database /// </summary> /// <param name="serverDaemon">The daemon triggering the event</param> /// <param name="target">The target of the action (region / agent UUID, etc)</param> /// <param name="methodCall">The method call where the problem occured</param> /// <param name="arguments">The arguments passed to the method</param> /// <param name="priority">How critical is this?</param> /// <param name="logMessage">The message to log</param> public void saveLog(string serverDaemon, string target, string methodCall, string arguments, int priority, string logMessage) { string sql = "INSERT INTO logs ([target], [server], [method], [arguments], [priority], [message]) VALUES "; sql += "(@target, @server, @method, @arguments, @priority, @message);"; using (AutoClosingSqlCommand command = database.Query(sql)) { command.Parameters.Add(database.CreateParameter("server", serverDaemon)); command.Parameters.Add(database.CreateParameter("target",target)); command.Parameters.Add(database.CreateParameter("method", methodCall)); command.Parameters.Add(database.CreateParameter("arguments", arguments)); command.Parameters.Add(database.CreateParameter("priority", priority.ToString())); command.Parameters.Add(database.CreateParameter("message", logMessage)); try { command.ExecuteNonQuery(); } catch (Exception e) { //Are we not in a loop here //m_log.Error(e.ToString()); Console.WriteLine("[LOG DB] Error logging : " + e.Message); } } } /// <summary> /// Returns the name of this DB provider /// </summary> /// <returns>A string containing the DB provider name</returns> public string Name { get { return "MSSQL Logdata Interface"; } } /// <summary> /// Closes the database provider /// </summary> public void Dispose() { database = null; } /// <summary> /// Returns the version of this DB provider /// </summary> /// <returns>A string containing the provider version</returns> public string Version { get { return "0.1"; } } } }