/* * 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.Collections; using System.Collections.Generic; using System.Reflection; using System.Security.Cryptography; using libsecondlife; using libsecondlife.StructuredData; using log4net; using Nwc.XmlRpc; using OpenSim.Framework.Statistics; namespace OpenSim.Framework.Communications { /// /// Base class for user management (create, read, etc) /// public abstract class UserManagerBase : IUserService, IAvatarService { private static readonly ILog m_log = LogManager.GetLogger(MethodBase.GetCurrentMethod().DeclaringType); public UserConfig _config; private List _plugins = new List(); /// /// Adds a new user server plugin - user servers will be requested in the order they were loaded. /// /// The filename to the user server plugin DLL public void AddPlugin(string provider, string connect) { PluginLoader loader = new PluginLoader (new UserDataInitialiser (connect)); // loader will try to load all providers (MySQL, MSSQL, etc) // unless it is constrainted to the correct "Provider" entry in the addin.xml loader.Add ("/OpenSim/UserData", new PluginProviderFilter (provider)); loader.Load(); _plugins = loader.Plugins; } #region Get UserProfile // see IUserService public UserProfileData GetUserProfile(string fname, string lname) { foreach (IUserDataPlugin plugin in _plugins) { UserProfileData profile = plugin.GetUserByName(fname, lname); if (profile != null) { profile.CurrentAgent = GetUserAgent(profile.ID); return profile; } } return null; } public UserAgentData GetAgentByUUID(LLUUID userId) { foreach (IUserDataPlugin plugin in _plugins) { UserAgentData agent = plugin.GetAgentByUUID(userId); if (agent != null) { return agent; } } return null; } // see IUserService public UserProfileData GetUserProfile(LLUUID uuid) { foreach (IUserDataPlugin plugin in _plugins) { UserProfileData profile = plugin.GetUserByUUID(uuid); if (null != profile) { profile.CurrentAgent = GetUserAgent(profile.ID); return profile; } } return null; } public List GenerateAgentPickerRequestResponse(LLUUID queryID, string query) { List pickerlist = new List(); foreach (IUserDataPlugin plugin in _plugins) { try { pickerlist = plugin.GeneratePickerResults(queryID, query); } catch (Exception) { m_log.Info("[USERSTORAGE]: Unable to generate AgentPickerData via " + plugin.Name + "(" + query + ")"); return new List(); } } return pickerlist; } /// /// Updates a user profile from data object /// /// /// public bool UpdateUserProfile(UserProfileData data) { foreach (IUserDataPlugin plugin in _plugins) { try { plugin.UpdateUserProfile(data); return true; } catch (Exception e) { m_log.InfoFormat("[USERSTORAGE]: Unable to set user {0} {1} via {2}: {3}", data.FirstName, data.SurName, plugin.Name, e.ToString()); } } return false; } #endregion #region Get UserAgent /// /// Loads a user agent by uuid (not called directly) /// /// The agent's UUID /// Agent profiles public UserAgentData GetUserAgent(LLUUID uuid) { foreach (IUserDataPlugin plugin in _plugins) { try { return plugin.GetAgentByUUID(uuid); } catch (Exception e) { m_log.Info("[USERSTORAGE]: Unable to find user via " + plugin.Name + "(" + e.ToString() + ")"); } } return null; } /// /// Loads a user agent by name (not called directly) /// /// The agent's name /// A user agent public UserAgentData GetUserAgent(string name) { foreach (IUserDataPlugin plugin in _plugins) { try { return plugin.GetAgentByName(name); } catch (Exception e) { m_log.Info("[USERSTORAGE]: Unable to find user via " + plugin.Name + "(" + e.ToString() + ")"); } } return null; } /// /// Loads a user agent by name (not called directly) /// /// The agent's firstname /// The agent's lastname /// A user agent public UserAgentData GetUserAgent(string fname, string lname) { foreach (IUserDataPlugin plugin in _plugins) { try { return plugin.GetAgentByName(fname, lname); } catch (Exception e) { m_log.Info("[USERSTORAGE]: Unable to find user via " + plugin.Name + "(" + e.ToString() + ")"); } } return null; } public void UpdateUserCurrentRegion(LLUUID avatarid, LLUUID regionuuid, ulong regionhandle) { foreach (IUserDataPlugin plugin in _plugins) { try { plugin.UpdateUserCurrentRegion(avatarid, regionuuid, regionhandle); } catch (Exception e) { m_log.Info("[USERSTORAGE]: Unable to updateuser location via " + plugin.Name + "(" + e.ToString() + ")"); } } } /// /// Loads a user's friend list /// /// the UUID of the friend list owner /// A List of FriendListItems that contains info about the user's friends public List GetUserFriendList(LLUUID ownerID) { foreach (IUserDataPlugin plugin in _plugins) { try { return plugin.GetUserFriendList(ownerID); } catch (Exception e) { m_log.Info("[USERSTORAGE]: Unable to GetUserFriendList via " + plugin.Name + "(" + e.ToString() + ")"); } } return null; } public void StoreWebLoginKey(LLUUID agentID, LLUUID webLoginKey) { foreach (IUserDataPlugin plugin in _plugins) { try { plugin.StoreWebLoginKey(agentID, webLoginKey); } catch (Exception e) { m_log.Info("[USERSTORAGE]: Unable to Store WebLoginKey via " + plugin.Name + "(" + e.ToString() + ")"); } } } public void AddNewUserFriend(LLUUID friendlistowner, LLUUID friend, uint perms) { foreach (IUserDataPlugin plugin in _plugins) { try { plugin.AddNewUserFriend(friendlistowner,friend,perms); } catch (Exception e) { m_log.Info("[USERSTORAGE]: Unable to AddNewUserFriend via " + plugin.Name + "(" + e.ToString() + ")"); } } } public void RemoveUserFriend(LLUUID friendlistowner, LLUUID friend) { foreach (IUserDataPlugin plugin in _plugins) { try { plugin.RemoveUserFriend(friendlistowner, friend); } catch (Exception e) { m_log.Info("[USERSTORAGE]: Unable to RemoveUserFriend via " + plugin.Name + "(" + e.ToString() + ")"); } } } public void UpdateUserFriendPerms(LLUUID friendlistowner, LLUUID friend, uint perms) { foreach (IUserDataPlugin plugin in _plugins) { try { plugin.UpdateUserFriendPerms(friendlistowner, friend, perms); } catch (Exception e) { m_log.Info("[USERSTORAGE]: Unable to UpdateUserFriendPerms via " + plugin.Name + "(" + e.ToString() + ")"); } } } /// /// Resets the currentAgent in the user profile /// /// The agent's ID public void ClearUserAgent(LLUUID agentID) { UserProfileData profile = GetUserProfile(agentID); profile.CurrentAgent = null; UpdateUserProfile(profile); } #endregion #region CreateAgent /// /// Creates and initialises a new user agent - make sure to use CommitAgent when done to submit to the DB /// /// The users profile /// The users loginrequest public void CreateAgent(UserProfileData profile, XmlRpcRequest request) { Hashtable requestData = (Hashtable) request.Params[0]; UserAgentData agent = new UserAgentData(); // User connection agent.AgentOnline = true; // Generate sessions RNGCryptoServiceProvider rand = new RNGCryptoServiceProvider(); byte[] randDataS = new byte[16]; byte[] randDataSS = new byte[16]; rand.GetBytes(randDataS); rand.GetBytes(randDataSS); agent.SecureSessionID = new LLUUID(randDataSS, 0); agent.SessionID = new LLUUID(randDataS, 0); // Profile UUID agent.ProfileID = profile.ID; // Current position (from Home) agent.Handle = profile.HomeRegion; agent.Position = profile.HomeLocation; // If user specified additional start, use that if (requestData.ContainsKey("start")) { string startLoc = ((string)requestData["start"]).Trim(); if (("last" == startLoc) && (profile.CurrentAgent != null)) { if ((profile.CurrentAgent.Position.X > 0) && (profile.CurrentAgent.Position.Y > 0) && (profile.CurrentAgent.Position.Z > 0) ) { // TODO: Right now, currentRegion has not been used in GridServer for requesting region. // TODO: It is only using currentHandle. agent.Region = profile.CurrentAgent.Region; agent.Handle = profile.CurrentAgent.Handle; agent.Position = profile.CurrentAgent.Position; } } // if (!(startLoc == "last" || startLoc == "home")) // { // // Format: uri:Ahern&162&213&34 // try // { // string[] parts = startLoc.Remove(0, 4).Split('&'); // //string region = parts[0]; // // //////////////////////////////////////////////////// // //SimProfile SimInfo = new SimProfile(); // //SimInfo = SimInfo.LoadFromGrid(theUser.currentAgent.currentHandle, _config.GridServerURL, _config.GridSendKey, _config.GridRecvKey); // } // catch (Exception) // { // } // } } // What time did the user login? agent.LoginTime = Util.UnixTimeSinceEpoch(); agent.LogoutTime = 0; // Current location agent.InitialRegion = LLUUID.Zero; // Fill in later agent.Region = LLUUID.Zero; // Fill in later profile.CurrentAgent = agent; } /// /// Process a user logoff from OpenSim. /// /// /// /// /// /// /// public void LogOffUser(LLUUID userid, LLUUID regionid, ulong regionhandle, float posx, float posy, float posz) { if (StatsManager.UserStats != null) StatsManager.UserStats.AddLogout(); UserProfileData userProfile; UserAgentData userAgent; LLVector3 currentPos = new LLVector3(posx, posy, posz); userProfile = GetUserProfile(userid); if (userProfile != null) { // This line needs to be in side the above if statement or the UserServer will crash on some logouts. m_log.Info("[LOGOUT]: " + userProfile.FirstName + " " + userProfile.SurName + " from " + regionhandle + "(" + posx + "," + posy + "," + posz + ")"); userAgent = userProfile.CurrentAgent; if (userAgent != null) { userAgent.AgentOnline = false; userAgent.LogoutTime = Util.UnixTimeSinceEpoch(); //userAgent.sessionID = LLUUID.Zero; if (regionid != LLUUID.Zero) { userAgent.Region = regionid; } userAgent.Handle = regionhandle; userAgent.Position = currentPos; userProfile.CurrentAgent = userAgent; CommitAgent(ref userProfile); } else { // If currentagent is null, we can't reference it here or the UserServer crashes! m_log.Info("[LOGOUT]: didn't save logout position: " + userid.ToString()); } } else { m_log.Warn("[LOGOUT]: Unknown User logged out"); } } public void CreateAgent(UserProfileData profile, LLSD request) { UserAgentData agent = new UserAgentData(); // User connection agent.AgentOnline = true; // Generate sessions RNGCryptoServiceProvider rand = new RNGCryptoServiceProvider(); byte[] randDataS = new byte[16]; byte[] randDataSS = new byte[16]; rand.GetBytes(randDataS); rand.GetBytes(randDataSS); agent.SecureSessionID = new LLUUID(randDataSS, 0); agent.SessionID = new LLUUID(randDataS, 0); // Profile UUID agent.ProfileID = profile.ID; // Current position (from Home) agent.Handle = profile.HomeRegion; agent.Position = profile.HomeLocation; // What time did the user login? agent.LoginTime = Util.UnixTimeSinceEpoch(); agent.LogoutTime = 0; // Current location agent.InitialRegion = LLUUID.Zero; // Fill in later agent.Region = LLUUID.Zero; // Fill in later profile.CurrentAgent = agent; } /// /// Saves a target agent to the database /// /// The users profile /// Successful? public bool CommitAgent(ref UserProfileData profile) { // TODO: how is this function different from setUserProfile? -> Add AddUserAgent() here and commit both tables "users" and "agents" // TODO: what is the logic should be? bool ret = false; ret = AddUserAgent(profile.CurrentAgent); ret = ret & UpdateUserProfile(profile); return ret; } #endregion /// /// /// /// public LLUUID AddUserProfile(string firstName, string lastName, string pass, uint regX, uint regY) { UserProfileData user = new UserProfileData(); user.HomeLocation = new LLVector3(128, 128, 100); user.ID = LLUUID.Random(); user.FirstName = firstName; user.SurName = lastName; user.PasswordHash = pass; user.PasswordSalt = String.Empty; user.Created = Util.UnixTimeSinceEpoch(); user.HomeLookAt = new LLVector3(100, 100, 100); user.HomeRegionX = regX; user.HomeRegionY = regY; foreach (IUserDataPlugin plugin in _plugins) { try { plugin.AddNewUserProfile(user); } catch (Exception e) { m_log.Info("[USERSTORAGE]: Unable to add user via " + plugin.Name + "(" + e.ToString() + ")"); } } return user.ID; } public bool UpdateUserProfileProperties(UserProfileData UserProfile) { if (null == GetUserProfile(UserProfile.ID)) { m_log.Info("[USERSTORAGE]: Failed to find User by UUID " + UserProfile.ID.ToString()); return false; } foreach (IUserDataPlugin plugin in _plugins) { try { plugin.UpdateUserProfile(UserProfile); } catch (Exception e) { m_log.Info("[USERSTORAGE]: Unable to update user " + UserProfile.ID.ToString() + " via " + plugin.Name + "(" + e.ToString() + ")"); return false; } } return true; } public abstract UserProfileData SetupMasterUser(string firstName, string lastName); public abstract UserProfileData SetupMasterUser(string firstName, string lastName, string password); public abstract UserProfileData SetupMasterUser(LLUUID uuid); /// /// Add agent to DB /// /// The agent data to be added public bool AddUserAgent(UserAgentData agentdata) { foreach (IUserDataPlugin plugin in _plugins) { try { plugin.AddNewUserAgent(agentdata); return true; } catch (Exception e) { m_log.Info("[USERSTORAGE]: Unable to add agent via " + plugin.Name + "(" + e.ToString() + ")"); } } return false; } /// Appearance /// TODO: stubs for now to get us to a compiling state gently public AvatarAppearance GetUserAppearance(LLUUID user) { foreach (IUserDataPlugin plugin in _plugins) { try { return plugin.GetUserAppearance(user); } catch (Exception e) { m_log.InfoFormat("[USERSTORAGE]: Unable to find user appearance {0} via {1} ({2})", user.ToString(), plugin.Name, e.ToString()); } } return null; } public void UpdateUserAppearance(LLUUID user, AvatarAppearance appearance) { foreach (IUserDataPlugin plugin in _plugins) { try { plugin.UpdateUserAppearance(user, appearance); } catch (Exception e) { m_log.InfoFormat("[USERSTORAGE]: Unable to update user appearance {0} via {1} ({2})", user.ToString(), plugin.Name, e.ToString()); } } } public void AddAttachment(LLUUID user, LLUUID item) { foreach (IUserDataPlugin plugin in _plugins) { try { plugin.AddAttachment(user, item); } catch (Exception e) { m_log.InfoFormat("[USERSTORAGE]: Unable to attach {3} => {0} via {1} ({2})", user.ToString(), plugin.Name, e.ToString(), item.ToString()); } } } public void RemoveAttachment(LLUUID user, LLUUID item) { foreach (IUserDataPlugin plugin in _plugins) { try { plugin.RemoveAttachment(user, item); } catch (Exception e) { m_log.InfoFormat("[USERSTORAGE]: Unable to remove attachment {3} => {0} via {1} ({2})", user.ToString(), plugin.Name, e.ToString(), item.ToString()); } } } public List GetAttachments(LLUUID user) { foreach (IUserDataPlugin plugin in _plugins) { try { return plugin.GetAttachments(user); } catch (Exception e) { m_log.InfoFormat("[USERSTORAGE]: Unable to get attachments for {0} via {1} ({2})", user.ToString(), plugin.Name, e.ToString()); } } return new List(); } } }