From bb171717ceaef37b022a135209c2e0bf031d21f9 Mon Sep 17 00:00:00 2001
From: Diva Canto
Date: Sun, 21 Feb 2010 15:38:52 -0800
Subject: Deleted obsolete files in the Data layer. Compiles.
---
OpenSim/Data/MSSQL/MSSQLGridData.cs | 587 ------------------------------------
1 file changed, 587 deletions(-)
delete mode 100644 OpenSim/Data/MSSQL/MSSQLGridData.cs
(limited to 'OpenSim/Data/MSSQL/MSSQLGridData.cs')
diff --git a/OpenSim/Data/MSSQL/MSSQLGridData.cs b/OpenSim/Data/MSSQL/MSSQLGridData.cs
deleted file mode 100644
index 8a3d332..0000000
--- a/OpenSim/Data/MSSQL/MSSQLGridData.cs
+++ /dev/null
@@ -1,587 +0,0 @@
-/*
- * 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 OpenSimulator 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.Collections.Generic;
-using System.Data;
-using System.Data.SqlClient;
-using System.Reflection;
-using log4net;
-using OpenMetaverse;
-using OpenSim.Framework;
-
-namespace OpenSim.Data.MSSQL
-{
- ///
- /// A grid data interface for MSSQL Server
- ///
- public class MSSQLGridData : GridDataBase
- {
- private const string _migrationStore = "GridStore";
-
- private static readonly ILog m_log = LogManager.GetLogger(MethodBase.GetCurrentMethod().DeclaringType);
-
- ///
- /// Database manager
- ///
- private MSSQLManager database;
-
- private string m_regionsTableName = "regions";
-
- #region IPlugin Members
-
- // [Obsolete("Cannot be default-initialized!")]
- override public void Initialise()
- {
- m_log.Info("[GRID DB]: " + Name + " cannot be default-initialized!");
- throw new PluginNotInitialisedException(Name);
- }
-
- ///
- /// Initialises the Grid Interface
- ///
- /// connect string
- /// use mssql_connection.ini
- override public void Initialise(string connectionString)
- {
- if (!string.IsNullOrEmpty(connectionString))
- {
- database = new MSSQLManager(connectionString);
- }
- else
- {
- // TODO: make the connect string actually do something
- IniFile iniFile = new IniFile("mssql_connection.ini");
-
- string settingDataSource = iniFile.ParseFileReadValue("data_source");
- string settingInitialCatalog = iniFile.ParseFileReadValue("initial_catalog");
- string settingPersistSecurityInfo = iniFile.ParseFileReadValue("persist_security_info");
- string settingUserId = iniFile.ParseFileReadValue("user_id");
- string settingPassword = iniFile.ParseFileReadValue("password");
-
- m_regionsTableName = iniFile.ParseFileReadValue("regionstablename");
- if (m_regionsTableName == null)
- {
- m_regionsTableName = "regions";
- }
-
- database =
- new MSSQLManager(settingDataSource, settingInitialCatalog, settingPersistSecurityInfo, settingUserId,
- settingPassword);
- }
-
- //New migrations check of store
- database.CheckMigration(_migrationStore);
- }
-
- ///
- /// Shuts down the grid interface
- ///
- override public void Dispose()
- {
- database = null;
- }
-
- ///
- /// The name of this DB provider.
- ///
- /// A string containing the storage system name
- override public string Name
- {
- get { return "MSSQL OpenGridData"; }
- }
-
- ///
- /// Database provider version.
- ///
- /// A string containing the storage system version
- override public string Version
- {
- get { return "0.1"; }
- }
-
- #endregion
-
- #region Public override GridDataBase methods
-
- ///
- /// Returns a list of regions within the specified ranges
- ///
- /// minimum X coordinate
- /// minimum Y coordinate
- /// maximum X coordinate
- /// maximum Y coordinate
- /// null
- /// always return null
- override public RegionProfileData[] GetProfilesInRange(uint xmin, uint ymin, uint xmax, uint ymax)
- {
- using (AutoClosingSqlCommand command = database.Query("SELECT * FROM regions WHERE locX >= @xmin AND locX <= @xmax AND locY >= @ymin AND locY <= @ymax"))
- {
- command.Parameters.Add(database.CreateParameter("xmin", xmin));
- command.Parameters.Add(database.CreateParameter("ymin", ymin));
- command.Parameters.Add(database.CreateParameter("xmax", xmax));
- command.Parameters.Add(database.CreateParameter("ymax", ymax));
-
- List rows = new List();
-
- using (SqlDataReader reader = command.ExecuteReader())
- {
- while (reader.Read())
- {
- rows.Add(ReadSimRow(reader));
- }
- }
-
- if (rows.Count > 0)
- {
- return rows.ToArray();
- }
- }
- m_log.Info("[GRID DB] : Found no regions within range.");
- return null;
- }
-
-
- ///
- /// Returns up to maxNum profiles of regions that have a name starting with namePrefix
- ///
- /// The name to match against
- /// Maximum number of profiles to return
- /// A list of sim profiles
- override public List GetRegionsByName (string namePrefix, uint maxNum)
- {
- using (AutoClosingSqlCommand command = database.Query("SELECT * FROM regions WHERE regionName LIKE @name"))
- {
- command.Parameters.Add(database.CreateParameter("name", namePrefix + "%"));
-
- List rows = new List();
-
- using (SqlDataReader reader = command.ExecuteReader())
- {
- while (rows.Count < maxNum && reader.Read())
- {
- rows.Add(ReadSimRow(reader));
- }
- }
-
- return rows;
- }
- }
-
- ///
- /// Returns a sim profile from its location
- ///
- /// Region location handle
- /// Sim profile
- override public RegionProfileData GetProfileByHandle(ulong handle)
- {
- using (AutoClosingSqlCommand command = database.Query("SELECT * FROM " + m_regionsTableName + " WHERE regionHandle = @handle"))
- {
- command.Parameters.Add(database.CreateParameter("handle", handle));
-
- using (SqlDataReader reader = command.ExecuteReader())
- {
- if (reader.Read())
- {
- return ReadSimRow(reader);
- }
- }
- }
- m_log.InfoFormat("[GRID DB] : No region found with handle : {0}", handle);
- return null;
- }
-
- ///
- /// Returns a sim profile from its UUID
- ///
- /// The region UUID
- /// The sim profile
- override public RegionProfileData GetProfileByUUID(UUID uuid)
- {
- using (AutoClosingSqlCommand command = database.Query("SELECT * FROM " + m_regionsTableName + " WHERE uuid = @uuid"))
- {
- command.Parameters.Add(database.CreateParameter("uuid", uuid));
-
- using (SqlDataReader reader = command.ExecuteReader())
- {
- if (reader.Read())
- {
- return ReadSimRow(reader);
- }
- }
- }
- m_log.InfoFormat("[GRID DB] : No region found with UUID : {0}", uuid);
- return null;
- }
-
- ///
- /// Returns a sim profile from it's Region name string
- ///
- /// The region name search query
- /// The sim profile
- override public RegionProfileData GetProfileByString(string regionName)
- {
- if (regionName.Length > 2)
- {
- using (AutoClosingSqlCommand command = database.Query("SELECT top 1 * FROM " + m_regionsTableName + " WHERE regionName like @regionName order by regionName"))
- {
- command.Parameters.Add(database.CreateParameter("regionName", regionName + "%"));
-
- using (SqlDataReader reader = command.ExecuteReader())
- {
- if (reader.Read())
- {
- return ReadSimRow(reader);
- }
- }
- }
- m_log.InfoFormat("[GRID DB] : No region found with regionName : {0}", regionName);
- return null;
- }
-
- m_log.Error("[GRID DB]: Searched for a Region Name shorter then 3 characters");
- return null;
- }
-
- ///
- /// Adds a new specified region to the database
- ///
- /// The profile to add
- /// A dataresponse enum indicating success
- override public DataResponse StoreProfile(RegionProfileData profile)
- {
- if (GetProfileByUUID(profile.UUID) == null)
- {
- if (InsertRegionRow(profile))
- {
- return DataResponse.RESPONSE_OK;
- }
- }
- else
- {
- if (UpdateRegionRow(profile))
- {
- return DataResponse.RESPONSE_OK;
- }
- }
-
- return DataResponse.RESPONSE_ERROR;
- }
-
- ///
- /// Deletes a sim profile from the database
- ///
- /// the sim UUID
- /// Successful?
- //public DataResponse DeleteProfile(RegionProfileData profile)
- override public DataResponse DeleteProfile(string uuid)
- {
- using (AutoClosingSqlCommand command = database.Query("DELETE FROM regions WHERE uuid = @uuid;"))
- {
- command.Parameters.Add(database.CreateParameter("uuid", uuid));
- try
- {
- command.ExecuteNonQuery();
- return DataResponse.RESPONSE_OK;
- }
- catch (Exception e)
- {
- m_log.DebugFormat("[GRID DB] : Error deleting region info, error is : {0}", e.Message);
- return DataResponse.RESPONSE_ERROR;
- }
- }
- }
-
- #endregion
-
- #region Methods that are not used or deprecated (still needed because of base class)
-
- ///
- /// DEPRECATED. Attempts to authenticate a region by comparing a shared secret.
- ///
- /// The UUID of the challenger
- /// The attempted regionHandle of the challenger
- /// The secret
- /// Whether the secret and regionhandle match the database entry for UUID
- override public bool AuthenticateSim(UUID uuid, ulong handle, string authkey)
- {
- bool throwHissyFit = false; // Should be true by 1.0
-
- if (throwHissyFit)
- throw new Exception("CRYPTOWEAK AUTHENTICATE: Refusing to authenticate due to replay potential.");
-
- RegionProfileData data = GetProfileByUUID(uuid);
-
- return (handle == data.regionHandle && authkey == data.regionSecret);
- }
-
- ///
- /// NOT YET FUNCTIONAL. Provides a cryptographic authentication of a region
- ///
- /// This requires a security audit.
- ///
- ///
- ///
- ///
- ///
- public bool AuthenticateSim(UUID uuid, ulong handle, string authhash, string challenge)
- {
- // SHA512Managed HashProvider = new SHA512Managed();
- // Encoding TextProvider = new UTF8Encoding();
-
- // byte[] stream = TextProvider.GetBytes(uuid.ToString() + ":" + handle.ToString() + ":" + challenge);
- // byte[] hash = HashProvider.ComputeHash(stream);
- return false;
- }
-
- ///
- /// NOT IMPLEMENTED
- /// WHEN IS THIS GONNA BE IMPLEMENTED.
- ///
- ///
- ///
- /// null
- override public ReservationData GetReservationAtPoint(uint x, uint y)
- {
- return null;
- }
-
- #endregion
-
- #region private methods
-
- ///
- /// Reads a region row from a database reader
- ///
- /// An active database reader
- /// A region profile
- private static RegionProfileData ReadSimRow(IDataRecord reader)
- {
- RegionProfileData retval = new RegionProfileData();
-
- // Region Main gotta-have-or-we-return-null parts
- UInt64 tmp64;
- if (!UInt64.TryParse(reader["regionHandle"].ToString(), out tmp64))
- {
- return null;
- }
-
- retval.regionHandle = tmp64;
-
-// UUID tmp_uuid;
-// if (!UUID.TryParse((string)reader["uuid"], out tmp_uuid))
-// {
-// return null;
-// }
-
- retval.UUID = new UUID((Guid)reader["uuid"]); // tmp_uuid;
-
- // non-critical parts
- retval.regionName = reader["regionName"].ToString();
- retval.originUUID = new UUID((Guid)reader["originUUID"]);
-
- // Secrets
- retval.regionRecvKey = reader["regionRecvKey"].ToString();
- retval.regionSecret = reader["regionSecret"].ToString();
- retval.regionSendKey = reader["regionSendKey"].ToString();
-
- // Region Server
- retval.regionDataURI = reader["regionDataURI"].ToString();
- retval.regionOnline = false; // Needs to be pinged before this can be set.
- retval.serverIP = reader["serverIP"].ToString();
- retval.serverPort = Convert.ToUInt32(reader["serverPort"]);
- retval.serverURI = reader["serverURI"].ToString();
- retval.httpPort = Convert.ToUInt32(reader["serverHttpPort"].ToString());
- retval.remotingPort = Convert.ToUInt32(reader["serverRemotingPort"].ToString());
-
- // Location
- retval.regionLocX = Convert.ToUInt32(reader["locX"].ToString());
- retval.regionLocY = Convert.ToUInt32(reader["locY"].ToString());
- retval.regionLocZ = Convert.ToUInt32(reader["locZ"].ToString());
-
- // Neighbours - 0 = No Override
- retval.regionEastOverrideHandle = Convert.ToUInt64(reader["eastOverrideHandle"].ToString());
- retval.regionWestOverrideHandle = Convert.ToUInt64(reader["westOverrideHandle"].ToString());
- retval.regionSouthOverrideHandle = Convert.ToUInt64(reader["southOverrideHandle"].ToString());
- retval.regionNorthOverrideHandle = Convert.ToUInt64(reader["northOverrideHandle"].ToString());
-
- // Assets
- retval.regionAssetURI = reader["regionAssetURI"].ToString();
- retval.regionAssetRecvKey = reader["regionAssetRecvKey"].ToString();
- retval.regionAssetSendKey = reader["regionAssetSendKey"].ToString();
-
- // Userserver
- retval.regionUserURI = reader["regionUserURI"].ToString();
- retval.regionUserRecvKey = reader["regionUserRecvKey"].ToString();
- retval.regionUserSendKey = reader["regionUserSendKey"].ToString();
-
- // World Map Addition
- retval.regionMapTextureID = new UUID((Guid)reader["regionMapTexture"]);
- retval.owner_uuid = new UUID((Guid)reader["owner_uuid"]);
- retval.maturity = Convert.ToUInt32(reader["access"]);
- return retval;
- }
-
- ///
- /// Update the specified region in the database
- ///
- /// The profile to update
- /// success ?
- private bool UpdateRegionRow(RegionProfileData profile)
- {
- bool returnval = false;
-
- //Insert new region
- string sql =
- "UPDATE " + m_regionsTableName + @" SET
- [regionHandle]=@regionHandle, [regionName]=@regionName,
- [regionRecvKey]=@regionRecvKey, [regionSecret]=@regionSecret, [regionSendKey]=@regionSendKey,
- [regionDataURI]=@regionDataURI, [serverIP]=@serverIP, [serverPort]=@serverPort, [serverURI]=@serverURI,
- [locX]=@locX, [locY]=@locY, [locZ]=@locZ, [eastOverrideHandle]=@eastOverrideHandle,
- [westOverrideHandle]=@westOverrideHandle, [southOverrideHandle]=@southOverrideHandle,
- [northOverrideHandle]=@northOverrideHandle, [regionAssetURI]=@regionAssetURI,
- [regionAssetRecvKey]=@regionAssetRecvKey, [regionAssetSendKey]=@regionAssetSendKey,
- [regionUserURI]=@regionUserURI, [regionUserRecvKey]=@regionUserRecvKey, [regionUserSendKey]=@regionUserSendKey,
- [regionMapTexture]=@regionMapTexture, [serverHttpPort]=@serverHttpPort,
- [serverRemotingPort]=@serverRemotingPort, [owner_uuid]=@owner_uuid , [originUUID]=@originUUID
- where [uuid]=@uuid";
-
- using (AutoClosingSqlCommand command = database.Query(sql))
- {
- command.Parameters.Add(database.CreateParameter("regionHandle", profile.regionHandle));
- command.Parameters.Add(database.CreateParameter("regionName", profile.regionName));
- command.Parameters.Add(database.CreateParameter("uuid", profile.UUID));
- command.Parameters.Add(database.CreateParameter("regionRecvKey", profile.regionRecvKey));
- command.Parameters.Add(database.CreateParameter("regionSecret", profile.regionSecret));
- command.Parameters.Add(database.CreateParameter("regionSendKey", profile.regionSendKey));
- command.Parameters.Add(database.CreateParameter("regionDataURI", profile.regionDataURI));
- command.Parameters.Add(database.CreateParameter("serverIP", profile.serverIP));
- command.Parameters.Add(database.CreateParameter("serverPort", profile.serverPort));
- command.Parameters.Add(database.CreateParameter("serverURI", profile.serverURI));
- command.Parameters.Add(database.CreateParameter("locX", profile.regionLocX));
- command.Parameters.Add(database.CreateParameter("locY", profile.regionLocY));
- command.Parameters.Add(database.CreateParameter("locZ", profile.regionLocZ));
- command.Parameters.Add(database.CreateParameter("eastOverrideHandle", profile.regionEastOverrideHandle));
- command.Parameters.Add(database.CreateParameter("westOverrideHandle", profile.regionWestOverrideHandle));
- command.Parameters.Add(database.CreateParameter("northOverrideHandle", profile.regionNorthOverrideHandle));
- command.Parameters.Add(database.CreateParameter("southOverrideHandle", profile.regionSouthOverrideHandle));
- command.Parameters.Add(database.CreateParameter("regionAssetURI", profile.regionAssetURI));
- command.Parameters.Add(database.CreateParameter("regionAssetRecvKey", profile.regionAssetRecvKey));
- command.Parameters.Add(database.CreateParameter("regionAssetSendKey", profile.regionAssetSendKey));
- command.Parameters.Add(database.CreateParameter("regionUserURI", profile.regionUserURI));
- command.Parameters.Add(database.CreateParameter("regionUserRecvKey", profile.regionUserRecvKey));
- command.Parameters.Add(database.CreateParameter("regionUserSendKey", profile.regionUserSendKey));
- command.Parameters.Add(database.CreateParameter("regionMapTexture", profile.regionMapTextureID));
- command.Parameters.Add(database.CreateParameter("serverHttpPort", profile.httpPort));
- command.Parameters.Add(database.CreateParameter("serverRemotingPort", profile.remotingPort));
- command.Parameters.Add(database.CreateParameter("owner_uuid", profile.owner_uuid));
- command.Parameters.Add(database.CreateParameter("originUUID", profile.originUUID));
-
- try
- {
- command.ExecuteNonQuery();
- returnval = true;
- }
- catch (Exception e)
- {
- m_log.Error("[GRID DB] : Error updating region, error: " + e.Message);
- }
- }
-
- return returnval;
- }
-
- ///
- /// Creates a new region in the database
- ///
- /// The region profile to insert
- /// Successful?
- private bool InsertRegionRow(RegionProfileData profile)
- {
- bool returnval = false;
-
- //Insert new region
- string sql =
- "INSERT INTO " + m_regionsTableName + @" ([regionHandle], [regionName], [uuid], [regionRecvKey], [regionSecret], [regionSendKey], [regionDataURI],
- [serverIP], [serverPort], [serverURI], [locX], [locY], [locZ], [eastOverrideHandle], [westOverrideHandle],
- [southOverrideHandle], [northOverrideHandle], [regionAssetURI], [regionAssetRecvKey], [regionAssetSendKey],
- [regionUserURI], [regionUserRecvKey], [regionUserSendKey], [regionMapTexture], [serverHttpPort],
- [serverRemotingPort], [owner_uuid], [originUUID], [access])
- VALUES (@regionHandle, @regionName, @uuid, @regionRecvKey, @regionSecret, @regionSendKey, @regionDataURI,
- @serverIP, @serverPort, @serverURI, @locX, @locY, @locZ, @eastOverrideHandle, @westOverrideHandle,
- @southOverrideHandle, @northOverrideHandle, @regionAssetURI, @regionAssetRecvKey, @regionAssetSendKey,
- @regionUserURI, @regionUserRecvKey, @regionUserSendKey, @regionMapTexture, @serverHttpPort, @serverRemotingPort, @owner_uuid, @originUUID, @access);";
-
- using (AutoClosingSqlCommand command = database.Query(sql))
- {
- command.Parameters.Add(database.CreateParameter("regionHandle", profile.regionHandle));
- command.Parameters.Add(database.CreateParameter("regionName", profile.regionName));
- command.Parameters.Add(database.CreateParameter("uuid", profile.UUID));
- command.Parameters.Add(database.CreateParameter("regionRecvKey", profile.regionRecvKey));
- command.Parameters.Add(database.CreateParameter("regionSecret", profile.regionSecret));
- command.Parameters.Add(database.CreateParameter("regionSendKey", profile.regionSendKey));
- command.Parameters.Add(database.CreateParameter("regionDataURI", profile.regionDataURI));
- command.Parameters.Add(database.CreateParameter("serverIP", profile.serverIP));
- command.Parameters.Add(database.CreateParameter("serverPort", profile.serverPort));
- command.Parameters.Add(database.CreateParameter("serverURI", profile.serverURI));
- command.Parameters.Add(database.CreateParameter("locX", profile.regionLocX));
- command.Parameters.Add(database.CreateParameter("locY", profile.regionLocY));
- command.Parameters.Add(database.CreateParameter("locZ", profile.regionLocZ));
- command.Parameters.Add(database.CreateParameter("eastOverrideHandle", profile.regionEastOverrideHandle));
- command.Parameters.Add(database.CreateParameter("westOverrideHandle", profile.regionWestOverrideHandle));
- command.Parameters.Add(database.CreateParameter("northOverrideHandle", profile.regionNorthOverrideHandle));
- command.Parameters.Add(database.CreateParameter("southOverrideHandle", profile.regionSouthOverrideHandle));
- command.Parameters.Add(database.CreateParameter("regionAssetURI", profile.regionAssetURI));
- command.Parameters.Add(database.CreateParameter("regionAssetRecvKey", profile.regionAssetRecvKey));
- command.Parameters.Add(database.CreateParameter("regionAssetSendKey", profile.regionAssetSendKey));
- command.Parameters.Add(database.CreateParameter("regionUserURI", profile.regionUserURI));
- command.Parameters.Add(database.CreateParameter("regionUserRecvKey", profile.regionUserRecvKey));
- command.Parameters.Add(database.CreateParameter("regionUserSendKey", profile.regionUserSendKey));
- command.Parameters.Add(database.CreateParameter("regionMapTexture", profile.regionMapTextureID));
- command.Parameters.Add(database.CreateParameter("serverHttpPort", profile.httpPort));
- command.Parameters.Add(database.CreateParameter("serverRemotingPort", profile.remotingPort));
- command.Parameters.Add(database.CreateParameter("owner_uuid", profile.owner_uuid));
- command.Parameters.Add(database.CreateParameter("originUUID", profile.originUUID));
- command.Parameters.Add(database.CreateParameter("access", profile.maturity));
-
- try
- {
- command.ExecuteNonQuery();
- returnval = true;
- }
- catch (Exception e)
- {
- m_log.Error("[GRID DB] : Error inserting region, error: " + e.Message);
- }
- }
-
- return returnval;
- }
-
- #endregion
- }
-}
--
cgit v1.1