* This may be broken.. it hasn't been tested, however I wanted to get the last database changes in before sdauge changes them significantly.

author: Teravus Ovares 2008-01-09 18:57:03 +0000
committer: Teravus Ovares 2008-01-09 18:57:03 +0000
commit: 49fe4eb3cdf4b5cb11e5fe0980bb7c3a3d47b6ea (patch)
tree: 37de8fc8d0f2507fd892b6f24ae6b5899a0f0bd7
parent: default to OpenSim.Framework.Data.SQLite which is the new storage (diff)
download: opensim-SC_OLD-49fe4eb3cdf4b5cb11e5fe0980bb7c3a3d47b6ea.zip
opensim-SC_OLD-49fe4eb3cdf4b5cb11e5fe0980bb7c3a3d47b6ea.tar.gz
opensim-SC_OLD-49fe4eb3cdf4b5cb11e5fe0980bb7c3a3d47b6ea.tar.bz2
opensim-SC_OLD-49fe4eb3cdf4b5cb11e5fe0980bb7c3a3d47b6ea.tar.xz
7 files changed, 242 insertions, 6 deletions
diff --git a/OpenSim/Framework/Communications/LoginService.cs b/OpenSim/Framework/Communications/LoginService.cs
index 9cfac1c..f0a0a0b 100644
--- a/OpenSim/Framework/Communications/LoginService.cs
+++ b/OpenSim/Framework/Communications/LoginService.cs
@@ -29,6 +29,7 @@
 using System;
 using System.Collections;
 using System.Collections.Generic;
+using System.IO;
 using System.Threading;
 using libsecondlife;
 using libsecondlife.StructuredData;
@@ -79,7 +80,7 @@ namespace OpenSim.Framework.UserManagement
                Hashtable requestData = (Hashtable) request.Params[0];
                bool GoodXML = (requestData.Contains("first") && requestData.Contains("last") &&
-                                requestData.Contains("passwd"));
+                                (requestData.Contains("passwd") || requestData.Contains("web_login_key")));
                bool GoodLogin = false;
                UserProfileData userProfile;
@@ -89,7 +90,8 @@ namespace OpenSim.Framework.UserManagement
                {
                    string firstname = (string) requestData["first"];
                    string lastname = (string) requestData["last"];
-                    string passwd = (string) requestData["passwd"];
+                    
                    userProfile = GetTheUser(firstname, lastname);
                    if (userProfile == null)
@@ -100,8 +102,29 @@ namespace OpenSim.Framework.UserManagement
                        return logResponse.CreateLoginFailedResponse();
                    }
+                    if (requestData.Contains("passwd"))
+                    {
+                        string passwd = (string)requestData["passwd"];
+                        GoodLogin = AuthenticateUser(userProfile, passwd);
+                    }
+                    else if (requestData.Contains("web_login_key"))
+                    {
+                        LLUUID webloginkey = null;
+                        try
+                        {
+                            webloginkey = new LLUUID((string)requestData["web_login_key"]);
+                        }
+                        catch (System.Exception)
+                        {
+                            return logResponse.CreateFailedResponse();
+                        }
+                        GoodLogin = AuthenticateUser(userProfile, webloginkey);
-                    GoodLogin = AuthenticateUser(userProfile, passwd);
+                    }
+                    else
+                    {
+                        return logResponse.CreateFailedResponse();
+                    }
                }
                else
                {
@@ -334,6 +357,105 @@ namespace OpenSim.Framework.UserManagement
        {
        }
+        public Hashtable ProcessHTMLLogin(Hashtable keysvals)
+        {
+            Hashtable returnactions = new Hashtable();
+            int statuscode = 200;
+            returnactions["int_response_code"] = statuscode;
+            returnactions["str_response_string"] = GetDefaultLoginForm();
+            if (keysvals.ContainsKey("show_login_form"))
+            {
+                if ((string)keysvals["show_login_form"] == "TRUE")
+                {
+                }
+                else
+                {
+                }
+            }
+            return returnactions;
+             
+        }
+        public string GetLoginForm()
+        {
+            string file = Path.Combine(Util.configDir(), "http_loginform.html");
+            if (!File.Exists(file))
+                return GetDefaultLoginForm();
+            StreamReader sr = File.OpenText(file);
+            string result = sr.ReadToEnd();
+            sr.Close();
+            return result;
+        }
+        public string GetDefaultLoginForm()
+        {
+            string responseString =
+           "<!DOCTYPE html PUBLIC \"-//W3C//DTD XHTML 1.0 Transitional//EN\" \"http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd\">";
+                responseString = responseString + "<html xmlns=\"http://www.w3.org/1999/xhtml\">";
+                responseString = responseString + "<head>";
+                responseString = responseString +
+                                 "<meta http-equiv=\"Content-Type\" content=\"text/html; charset=utf-8\" />";
+                responseString = responseString + "<meta http-equiv=\"cache-control\" content=\"no-cache\">";
+                responseString = responseString + "<meta http-equiv=\"Pragma\" content=\"no-cache\">";
+                responseString = responseString + "<title>Second Life Login</title>";
+                responseString = responseString + "<body>";
+                responseString = responseString + "<div id=\"login_box\">";
+                
+                responseString = responseString + "<form action=\"/\" method=\"GET\" id=\"login-form\">";
+                responseString = responseString + "<div id=\"message\">[$errors]</div>";
+                responseString = responseString + "<fieldset id=\"firstname\">";
+                responseString = responseString + "<legend>First Name:</legend>";
+                responseString = responseString + "<input type=\"text\" id=\"firstname_input\" size=\"15\" maxlength=\"100\" name=\"username\" value=\"[$firstname]\" />";
+                responseString = responseString + "</fieldset>";
+                responseString = responseString + "<fieldset id=\"lastname\">";
+                responseString = responseString + "<legend>Last Name:</legend>";
+                responseString = responseString + "<input type=\"text\" size=\"15\" maxlength=\"100\" name=\"lastname\" value=\"[$lastname]\" />";
+                responseString = responseString + "</fieldset>";
+                responseString = responseString + "<fieldset id=\"password\">";
+                responseString = responseString + "<legend>Password:</legend>";
+                responseString = responseString + "<table cellspacing=\"0\" cellpadding=\"0\" border=\"0\">";
+                responseString = responseString + "<tr>";
+                responseString = responseString + "<td colspan=\"2\"><input type=\"password\" size=\"15\" maxlength=\"100\" name=\"password\" value=\"[$password]\" /></td>";
+                responseString = responseString + "</tr>";
+                responseString = responseString + "<tr>";
+                responseString = responseString + "<td valign=\"middle\"><input type=\"checkbox\" name=\"remember_password\" id=\"remember_password\" [$remember_password] style=\"margin-left:0px;\"/></td>";
+                responseString = responseString + "<td><label for=\"remember_password\">Remember password</label></td>";
+                responseString = responseString + "</tr>";
+                responseString = responseString + "</table>";
+                responseString = responseString + "</fieldset>";
+                responseString = responseString + "<input type=\"hidden\" name=\"show_login_form\" value=\"FALSE\" />";
+                responseString = responseString + "<input type=\"hidden\" name=\"method\" value=\"login\" />";
+                responseString = responseString + "<input type=\"hidden\" id=\"grid\" name=\"grid\" value=\"[$grid]\" />";
+                responseString = responseString + "<div id=\"submitbtn\">";
+                responseString = responseString + "<input class=\"input_over\" type=\"submit\" value=\"Connect\" />";
+                responseString = responseString + "</div>";
+                responseString = responseString + "<div id=\"connecting\" style=\"visibility:hidden\"> Connecting...</div>";
+                responseString = responseString + "<div id=\"helplinks\">";
+                responseString = responseString + "<a href=\"http://www.secondlife.com/join/index.php\" target=\"_blank\">Create new account</a> | ";
+                responseString = responseString + "<a href=\"http://www.secondlife.com/account/request.php\" target=\"_blank\">Forgot password?</a>";
+                responseString = responseString + "</div>";
+                responseString = responseString + "<div id=\"channelinfo\"> [$clientchannelinfo] | [$clientversion]=[$clientlanguage]</div>";
+                responseString = responseString + "</form>";
+                responseString = responseString + "<script language=\"JavaScript\">";
+                responseString = responseString + "document.getElementById('firstname_input').focus();";
+                responseString = responseString + "</script>";
+                responseString = responseString + "</div>";
+                responseString = responseString + "</div>";
+                responseString = responseString + "</body>";
+                responseString = responseString + "</html>";
+            return responseString;
+        }
        /// <summary>
        /// Saves a target agent to the database
        /// </summary>
@@ -353,14 +475,33 @@ namespace OpenSim.Framework.UserManagement
        /// <returns>Authenticated?</returns>
        public virtual bool AuthenticateUser(UserProfileData profile, string password)
        {
+            bool passwordSuccess = false;
            MainLog.Instance.Verbose(
                "LOGIN", "Authenticating {0} {1} ({2})", profile.username, profile.surname, profile.UUID);
+            // Web Login method seems to also occasionally send the hashed password itself
+        
            password = password.Remove(0, 3); //remove $1$
            string s = Util.Md5Hash(password + ":" + profile.passwordSalt);
-            return profile.passwordHash.Equals(s.ToString(), StringComparison.InvariantCultureIgnoreCase);
+            passwordSuccess = (profile.passwordHash.Equals(s.ToString(), StringComparison.InvariantCultureIgnoreCase) 
+                            || profile.passwordHash.Equals(password.ToString(),StringComparison.InvariantCultureIgnoreCase));
+            return passwordSuccess;
+        }
+        public virtual bool AuthenticateUser(UserProfileData profile, LLUUID webloginkey)
+        {
+            bool passwordSuccess = false;
+            MainLog.Instance.Verbose(
+                "LOGIN", "Authenticating {0} {1} ({2})", profile.username, profile.surname, profile.UUID);
+            // Match web login key unless it's the default weblogin key LLUUID.Zero
+            passwordSuccess = ((profile.webLoginKey==webloginkey) && profile.webLoginKey != LLUUID.Zero);
+            return passwordSuccess;
        }
        /// <summary>
diff --git a/OpenSim/Framework/Communications/UserManagerBase.cs b/OpenSim/Framework/Communications/UserManagerBase.cs
index bea56ea..2d72629 100644
--- a/OpenSim/Framework/Communications/UserManagerBase.cs
+++ b/OpenSim/Framework/Communications/UserManagerBase.cs
@@ -222,6 +222,23 @@ namespace OpenSim.Framework.UserManagement
        }
+        public void StoreWebLoginKey(LLUUID agentID, LLUUID webLoginKey)
+        {
+            foreach (KeyValuePair<string, IUserData> plugin in _plugins)
+            {
+                try
+                {
+                    plugin.Value.StoreWebLoginKey(agentID, webLoginKey);
+                }
+                catch (Exception e)
+                {
+                    MainLog.Instance.Verbose("USERSTORAGE",
+                                             "Unable to Store WebLoginKey via " + plugin.Key + "(" + e.ToString() + ")");
+                }
+            }
+        }
        public void AddNewUserFriend(LLUUID friendlistowner, LLUUID friend, uint perms)
        {
            foreach (KeyValuePair<string, IUserData> plugin in _plugins)
diff --git a/OpenSim/Framework/Data.DB4o/DB4oUserData.cs b/OpenSim/Framework/Data.DB4o/DB4oUserData.cs
index c6ac526..47521e4 100644
--- a/OpenSim/Framework/Data.DB4o/DB4oUserData.cs
+++ b/OpenSim/Framework/Data.DB4o/DB4oUserData.cs
@@ -132,7 +132,13 @@ namespace OpenSim.Framework.Data.DB4o
                return null;
            }
        }
+        public void StoreWebLoginKey(LLUUID AgentID, LLUUID WebLoginKey)
+        {
+            UserProfileData user = GetUserByUUID(AgentID);
+            user.webLoginKey = WebLoginKey;
+            UpdateUserProfile(user);
+        }
        #region User Friends List Data
        public void AddNewUserFriend(LLUUID friendlistowner, LLUUID friend, uint perms)
diff --git a/OpenSim/Framework/Data.MSSQL/MSSQLUserData.cs b/OpenSim/Framework/Data.MSSQL/MSSQLUserData.cs
index db3c1d6..429ed39 100644
--- a/OpenSim/Framework/Data.MSSQL/MSSQLUserData.cs
+++ b/OpenSim/Framework/Data.MSSQL/MSSQLUserData.cs
@@ -297,7 +297,13 @@ namespace OpenSim.Framework.Data.MSSQL
                return null;
            }
        }
+        public void StoreWebLoginKey(LLUUID AgentID, LLUUID WebLoginKey)
+        {
+            UserProfileData user = GetUserByUUID(AgentID);
+            user.webLoginKey = WebLoginKey;
+            UpdateUserProfile(user);
+            
+        }
        /// <summary>
        /// Creates a new users profile
        /// </summary>
@@ -358,7 +364,8 @@ namespace OpenSim.Framework.Data.MSSQL
                                                "profileAboutText = @profileAboutText," +
                                                "profileFirstText = @profileFirstText," +
                                                "profileImage = @profileImage," +
-                                                "profileFirstImage = @profileFirstImage where " +
+                                                "profileFirstImage = @profileFirstImage, " +
+                                                "webLoginKey = @webLoginKey  where " +
                                                "UUID = @keyUUUID;", database.getConnection());
            SqlParameter param1 = new SqlParameter("@uuid", user.UUID.ToString());
            SqlParameter param2 = new SqlParameter("@username", user.username);
@@ -383,6 +390,7 @@ namespace OpenSim.Framework.Data.MSSQL
            SqlParameter param21 = new SqlParameter("@profileImage", LLUUID.Zero.ToString());
            SqlParameter param22 = new SqlParameter("@profileFirstImage", LLUUID.Zero.ToString());
            SqlParameter param23 = new SqlParameter("@keyUUUID", user.UUID.ToString());
+            SqlParameter param24 = new SqlParameter("@webLoginKey", user.webLoginKey.UUID.ToString());
            command.Parameters.Add(param1);
            command.Parameters.Add(param2);
            command.Parameters.Add(param3);
@@ -406,6 +414,7 @@ namespace OpenSim.Framework.Data.MSSQL
            command.Parameters.Add(param21);
            command.Parameters.Add(param22);
            command.Parameters.Add(param23);
+            command.Parameters.Add(param24);
            try
            {
                int affected = command.ExecuteNonQuery();
diff --git a/OpenSim/Framework/Data.MySQL/MySQLUserData.cs b/OpenSim/Framework/Data.MySQL/MySQLUserData.cs
index e53ab18..76ad551 100644
--- a/OpenSim/Framework/Data.MySQL/MySQLUserData.cs
+++ b/OpenSim/Framework/Data.MySQL/MySQLUserData.cs
@@ -468,6 +468,39 @@ namespace OpenSim.Framework.Data.MySQL
            return GetAgentByUUID(profile.UUID);
        }
+        public void StoreWebLoginKey(LLUUID AgentID, LLUUID WebLoginKey)
+        {
+            
+            Dictionary<string, string> param = new Dictionary<string, string>();
+            param["?UUID"] = AgentID.UUID.ToString();
+            param["?webLoginKey"] = WebLoginKey.UUID.ToString();
+            try
+            {
+                lock (database)
+                {
+                    IDbCommand updater =
+                        database.Query(
+                        "update users " +
+                        "SET webLoginKey = ?webLoginKey " +
+                        "where UUID = ?UUID",
+                            param);
+                    updater.ExecuteNonQuery();
+                }
+            }
+            catch (Exception e)
+            {
+                database.Reconnect();
+                MainLog.Instance.Error(e.ToString());
+                return;
+            }
+                
+            
+        }
        /// <summary>
        /// Returns an agent session by account UUID
        /// </summary>
diff --git a/OpenSim/Framework/Data.SQLite/SQLiteUserData.cs b/OpenSim/Framework/Data.SQLite/SQLiteUserData.cs
index cbbb349..f1f76c4 100644
--- a/OpenSim/Framework/Data.SQLite/SQLiteUserData.cs
+++ b/OpenSim/Framework/Data.SQLite/SQLiteUserData.cs
@@ -373,6 +373,29 @@ namespace OpenSim.Framework.Data.SQLite
            }
        }
+        public void StoreWebLoginKey(LLUUID AgentID, LLUUID WebLoginKey)
+        {
+            DataTable users = ds.Tables["users"];
+            lock (ds)
+            {
+                DataRow row = users.Rows.Find(Util.ToRawUuidString(AgentID));
+                if (row == null)
+                {
+                    MainLog.Instance.Warn("WEBLOGIN", "Unable to store new web login key for non-existant user");
+                }
+                else
+                {
+                    UserProfileData user = GetUserByUUID(AgentID);
+                    user.webLoginKey = WebLoginKey;
+                    fillUserRow(row, user);
+                    da.Update(ds, "users");
+                }
+            }
+        }
        /// <summary>
        /// Creates a new user profile
        /// </summary>
@@ -392,6 +415,7 @@ namespace OpenSim.Framework.Data.SQLite
                else
                {
                    fillUserRow(row, user);
+                    
                }
                // This is why we're getting the 'logins never log-off'..    because It isn't clearing the 
                // useragents table once the useragent is null
diff --git a/OpenSim/Framework/IUserData.cs b/OpenSim/Framework/IUserData.cs
index eba2329..9fd6fa8 100644
--- a/OpenSim/Framework/IUserData.cs
+++ b/OpenSim/Framework/IUserData.cs
@@ -81,6 +81,12 @@ namespace OpenSim.Framework
        UserAgentData GetAgentByName(string fname, string lname);
        /// <summary>
+        /// Stores new web-login key for user during web page login
+        /// </summary>
+        /// <param name="webLoginKey"></param>
+        void StoreWebLoginKey(LLUUID agentID, LLUUID webLoginKey);
+        /// <summary>
        /// Adds a new User profile to the database 
        /// </summary>
        /// <param name="user">UserProfile to add</param>
author	Teravus Ovares	2008-01-09 18:57:03 +0000
committer	Teravus Ovares	2008-01-09 18:57:03 +0000
commit	49fe4eb3cdf4b5cb11e5fe0980bb7c3a3d47b6ea (patch)
tree	37de8fc8d0f2507fd892b6f24ae6b5899a0f0bd7
parent	default to OpenSim.Framework.Data.SQLite which is the new storage (diff)
download	opensim-SC_OLD-49fe4eb3cdf4b5cb11e5fe0980bb7c3a3d47b6ea.zip opensim-SC_OLD-49fe4eb3cdf4b5cb11e5fe0980bb7c3a3d47b6ea.tar.gz opensim-SC_OLD-49fe4eb3cdf4b5cb11e5fe0980bb7c3a3d47b6ea.tar.bz2 opensim-SC_OLD-49fe4eb3cdf4b5cb11e5fe0980bb7c3a3d47b6ea.tar.xz

diff --git a/OpenSim/Framework/Communications/LoginService.cs b/OpenSim/Framework/Communications/LoginService.cs index 9cfac1c..f0a0a0b 100644 --- a/OpenSim/Framework/Communications/LoginService.cs +++ b/OpenSim/Framework/Communications/LoginService.cs
@@ -29,6 +29,7 @@
29	using System;	29	using System;
30	using System.Collections;	30	using System.Collections;
31	using System.Collections.Generic;	31	using System.Collections.Generic;
		32	using System.IO;
32	using System.Threading;	33	using System.Threading;
33	using libsecondlife;	34	using libsecondlife;
34	using libsecondlife.StructuredData;	35	using libsecondlife.StructuredData;
@@ -79,7 +80,7 @@ namespace OpenSim.Framework.UserManagement
79	Hashtable requestData = (Hashtable) request.Params[0];	80	Hashtable requestData = (Hashtable) request.Params[0];
80		81
81	bool GoodXML = (requestData.Contains("first") && requestData.Contains("last") &&	82	bool GoodXML = (requestData.Contains("first") && requestData.Contains("last") &&
82	requestData.Contains("passwd"));	83	(requestData.Contains("passwd") \|\| requestData.Contains("web_login_key")));
83	bool GoodLogin = false;	84	bool GoodLogin = false;
84		85
85	UserProfileData userProfile;	86	UserProfileData userProfile;
@@ -89,7 +90,8 @@ namespace OpenSim.Framework.UserManagement
89	{	90	{
90	string firstname = (string) requestData["first"];	91	string firstname = (string) requestData["first"];
91	string lastname = (string) requestData["last"];	92	string lastname = (string) requestData["last"];
92	string passwd = (string) requestData["passwd"];	93
		94
93		95
94	userProfile = GetTheUser(firstname, lastname);	96	userProfile = GetTheUser(firstname, lastname);
95	if (userProfile == null)	97	if (userProfile == null)
@@ -100,8 +102,29 @@ namespace OpenSim.Framework.UserManagement
100		102
101	return logResponse.CreateLoginFailedResponse();	103	return logResponse.CreateLoginFailedResponse();
102	}	104	}
		105	if (requestData.Contains("passwd"))
		106	{
		107	string passwd = (string)requestData["passwd"];
		108	GoodLogin = AuthenticateUser(userProfile, passwd);
		109	}
		110	else if (requestData.Contains("web_login_key"))
		111	{
		112	LLUUID webloginkey = null;
		113	try
		114	{
		115	webloginkey = new LLUUID((string)requestData["web_login_key"]);
		116	}
		117	catch (System.Exception)
		118	{
		119	return logResponse.CreateFailedResponse();
		120	}
		121	GoodLogin = AuthenticateUser(userProfile, webloginkey);
103		122
104	GoodLogin = AuthenticateUser(userProfile, passwd);	123	}
		124	else
		125	{
		126	return logResponse.CreateFailedResponse();
		127	}
105	}	128	}
106	else	129	else
107	{	130	{
@@ -334,6 +357,105 @@ namespace OpenSim.Framework.UserManagement
334	{	357	{
335	}	358	}
336		359
		360	public Hashtable ProcessHTMLLogin(Hashtable keysvals)
		361	{
		362	Hashtable returnactions = new Hashtable();
		363	int statuscode = 200;
		364
		365	returnactions["int_response_code"] = statuscode;
		366	returnactions["str_response_string"] = GetDefaultLoginForm();
		367
		368	if (keysvals.ContainsKey("show_login_form"))
		369	{
		370	if ((string)keysvals["show_login_form"] == "TRUE")
		371	{
		372
		373	}
		374	else
		375	{
		376
		377
		378	}
		379
		380	}
		381	return returnactions;
		382
		383	}
		384
		385	public string GetLoginForm()
		386	{
		387	string file = Path.Combine(Util.configDir(), "http_loginform.html");
		388	if (!File.Exists(file))
		389	return GetDefaultLoginForm();
		390
		391	StreamReader sr = File.OpenText(file);
		392	string result = sr.ReadToEnd();
		393	sr.Close();
		394	return result;
		395	}
		396
		397	public string GetDefaultLoginForm()
		398	{
		399	string responseString =
		400	"<!DOCTYPE html PUBLIC \"-//W3C//DTD XHTML 1.0 Transitional//EN\" \"http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd\">";
		401	responseString = responseString + "<html xmlns=\"http://www.w3.org/1999/xhtml\">";
		402	responseString = responseString + "<head>";
		403	responseString = responseString +
		404	"<meta http-equiv=\"Content-Type\" content=\"text/html; charset=utf-8\" />";
		405	responseString = responseString + "<meta http-equiv=\"cache-control\" content=\"no-cache\">";
		406	responseString = responseString + "<meta http-equiv=\"Pragma\" content=\"no-cache\">";
		407	responseString = responseString + "<title>Second Life Login</title>";
		408	responseString = responseString + "<body>";
		409	responseString = responseString + "<div id=\"login_box\">";
		410
		411	responseString = responseString + "<form action=\"/\" method=\"GET\" id=\"login-form\">";
		412
		413	responseString = responseString + "<div id=\"message\">[$errors]</div>";
		414	responseString = responseString + "<fieldset id=\"firstname\">";
		415	responseString = responseString + "<legend>First Name:</legend>";
		416	responseString = responseString + "<input type=\"text\" id=\"firstname_input\" size=\"15\" maxlength=\"100\" name=\"username\" value=\"[$firstname]\" />";
		417	responseString = responseString + "</fieldset>";
		418	responseString = responseString + "<fieldset id=\"lastname\">";
		419	responseString = responseString + "<legend>Last Name:</legend>";
		420	responseString = responseString + "<input type=\"text\" size=\"15\" maxlength=\"100\" name=\"lastname\" value=\"[$lastname]\" />";
		421	responseString = responseString + "</fieldset>";
		422	responseString = responseString + "<fieldset id=\"password\">";
		423	responseString = responseString + "<legend>Password:</legend>";
		424	responseString = responseString + "<table cellspacing=\"0\" cellpadding=\"0\" border=\"0\">";
		425	responseString = responseString + "<tr>";
		426	responseString = responseString + "<td colspan=\"2\"><input type=\"password\" size=\"15\" maxlength=\"100\" name=\"password\" value=\"[$password]\" /></td>";
		427	responseString = responseString + "</tr>";
		428	responseString = responseString + "<tr>";
		429	responseString = responseString + "<td valign=\"middle\"><input type=\"checkbox\" name=\"remember_password\" id=\"remember_password\" [$remember_password] style=\"margin-left:0px;\"/></td>";
		430	responseString = responseString + "<td><label for=\"remember_password\">Remember password</label></td>";
		431	responseString = responseString + "</tr>";
		432	responseString = responseString + "</table>";
		433	responseString = responseString + "</fieldset>";
		434	responseString = responseString + "<input type=\"hidden\" name=\"show_login_form\" value=\"FALSE\" />";
		435	responseString = responseString + "<input type=\"hidden\" name=\"method\" value=\"login\" />";
		436	responseString = responseString + "<input type=\"hidden\" id=\"grid\" name=\"grid\" value=\"[$grid]\" />";
		437	responseString = responseString + "<div id=\"submitbtn\">";
		438	responseString = responseString + "<input class=\"input_over\" type=\"submit\" value=\"Connect\" />";
		439	responseString = responseString + "</div>";
		440	responseString = responseString + "<div id=\"connecting\" style=\"visibility:hidden\"> Connecting...</div>";
		441
		442	responseString = responseString + "<div id=\"helplinks\">";
		443	responseString = responseString + "<a href=\"http://www.secondlife.com/join/index.php\" target=\"_blank\">Create new account</a> \| ";
		444	responseString = responseString + "<a href=\"http://www.secondlife.com/account/request.php\" target=\"_blank\">Forgot password?</a>";
		445	responseString = responseString + "</div>";
		446
		447	responseString = responseString + "<div id=\"channelinfo\"> [$clientchannelinfo] \| [$clientversion]=[$clientlanguage]</div>";
		448	responseString = responseString + "</form>";
		449	responseString = responseString + "<script language=\"JavaScript\">";
		450	responseString = responseString + "document.getElementById('firstname_input').focus();";
		451	responseString = responseString + "</script>";
		452	responseString = responseString + "</div>";
		453	responseString = responseString + "</div>";
		454	responseString = responseString + "</body>";
		455	responseString = responseString + "</html>";
		456	return responseString;
		457	}
		458
337	/// <summary>	459	/// <summary>
338	/// Saves a target agent to the database	460	/// Saves a target agent to the database
339	/// </summary>	461	/// </summary>
@@ -353,14 +475,33 @@ namespace OpenSim.Framework.UserManagement
353	/// <returns>Authenticated?</returns>	475	/// <returns>Authenticated?</returns>
354	public virtual bool AuthenticateUser(UserProfileData profile, string password)	476	public virtual bool AuthenticateUser(UserProfileData profile, string password)
355	{	477	{
		478	bool passwordSuccess = false;
356	MainLog.Instance.Verbose(	479	MainLog.Instance.Verbose(
357	"LOGIN", "Authenticating {0} {1} ({2})", profile.username, profile.surname, profile.UUID);	480	"LOGIN", "Authenticating {0} {1} ({2})", profile.username, profile.surname, profile.UUID);
358		481
		482	// Web Login method seems to also occasionally send the hashed password itself
		483
		484
359	password = password.Remove(0, 3); //remove $1$	485	password = password.Remove(0, 3); //remove $1$
360		486
361	string s = Util.Md5Hash(password + ":" + profile.passwordSalt);	487	string s = Util.Md5Hash(password + ":" + profile.passwordSalt);
362		488
363	return profile.passwordHash.Equals(s.ToString(), StringComparison.InvariantCultureIgnoreCase);	489	passwordSuccess = (profile.passwordHash.Equals(s.ToString(), StringComparison.InvariantCultureIgnoreCase)
		490	\|\| profile.passwordHash.Equals(password.ToString(),StringComparison.InvariantCultureIgnoreCase));
		491
		492	return passwordSuccess;
		493	}
		494
		495	public virtual bool AuthenticateUser(UserProfileData profile, LLUUID webloginkey)
		496	{
		497	bool passwordSuccess = false;
		498	MainLog.Instance.Verbose(
		499	"LOGIN", "Authenticating {0} {1} ({2})", profile.username, profile.surname, profile.UUID);
		500
		501	// Match web login key unless it's the default weblogin key LLUUID.Zero
		502	passwordSuccess = ((profile.webLoginKey==webloginkey) && profile.webLoginKey != LLUUID.Zero);
		503
		504	return passwordSuccess;
364	}	505	}
365		506
366	/// <summary>	507	/// <summary>


diff --git a/OpenSim/Framework/Communications/UserManagerBase.cs b/OpenSim/Framework/Communications/UserManagerBase.cs index bea56ea..2d72629 100644 --- a/OpenSim/Framework/Communications/UserManagerBase.cs +++ b/OpenSim/Framework/Communications/UserManagerBase.cs
@@ -222,6 +222,23 @@ namespace OpenSim.Framework.UserManagement
222		222
223	}	223	}
224		224
		225	public void StoreWebLoginKey(LLUUID agentID, LLUUID webLoginKey)
		226	{
		227
		228	foreach (KeyValuePair<string, IUserData> plugin in _plugins)
		229	{
		230	try
		231	{
		232	plugin.Value.StoreWebLoginKey(agentID, webLoginKey);
		233	}
		234	catch (Exception e)
		235	{
		236	MainLog.Instance.Verbose("USERSTORAGE",
		237	"Unable to Store WebLoginKey via " + plugin.Key + "(" + e.ToString() + ")");
		238	}
		239	}
		240	}
		241
225	public void AddNewUserFriend(LLUUID friendlistowner, LLUUID friend, uint perms)	242	public void AddNewUserFriend(LLUUID friendlistowner, LLUUID friend, uint perms)
226	{	243	{
227	foreach (KeyValuePair<string, IUserData> plugin in _plugins)	244	foreach (KeyValuePair<string, IUserData> plugin in _plugins)


diff --git a/OpenSim/Framework/Data.DB4o/DB4oUserData.cs b/OpenSim/Framework/Data.DB4o/DB4oUserData.cs index c6ac526..47521e4 100644 --- a/OpenSim/Framework/Data.DB4o/DB4oUserData.cs +++ b/OpenSim/Framework/Data.DB4o/DB4oUserData.cs
@@ -132,7 +132,13 @@ namespace OpenSim.Framework.Data.DB4o
132	return null;	132	return null;
133	}	133	}
134	}	134	}
		135	public void StoreWebLoginKey(LLUUID AgentID, LLUUID WebLoginKey)
		136	{
		137	UserProfileData user = GetUserByUUID(AgentID);
		138	user.webLoginKey = WebLoginKey;
		139	UpdateUserProfile(user);
135		140
		141	}
136	#region User Friends List Data	142	#region User Friends List Data
137		143
138	public void AddNewUserFriend(LLUUID friendlistowner, LLUUID friend, uint perms)	144	public void AddNewUserFriend(LLUUID friendlistowner, LLUUID friend, uint perms)


diff --git a/OpenSim/Framework/Data.MSSQL/MSSQLUserData.cs b/OpenSim/Framework/Data.MSSQL/MSSQLUserData.cs index db3c1d6..429ed39 100644 --- a/OpenSim/Framework/Data.MSSQL/MSSQLUserData.cs +++ b/OpenSim/Framework/Data.MSSQL/MSSQLUserData.cs
@@ -297,7 +297,13 @@ namespace OpenSim.Framework.Data.MSSQL
297	return null;	297	return null;
298	}	298	}
299	}	299	}
300		300	public void StoreWebLoginKey(LLUUID AgentID, LLUUID WebLoginKey)
		301	{
		302	UserProfileData user = GetUserByUUID(AgentID);
		303	user.webLoginKey = WebLoginKey;
		304	UpdateUserProfile(user);
		305
		306	}
301	/// <summary>	307	/// <summary>
302	/// Creates a new users profile	308	/// Creates a new users profile
303	/// </summary>	309	/// </summary>
@@ -358,7 +364,8 @@ namespace OpenSim.Framework.Data.MSSQL
358	"profileAboutText = @profileAboutText," +	364	"profileAboutText = @profileAboutText," +
359	"profileFirstText = @profileFirstText," +	365	"profileFirstText = @profileFirstText," +
360	"profileImage = @profileImage," +	366	"profileImage = @profileImage," +
361	"profileFirstImage = @profileFirstImage where " +	367	"profileFirstImage = @profileFirstImage, " +
		368	"webLoginKey = @webLoginKey where " +
362	"UUID = @keyUUUID;", database.getConnection());	369	"UUID = @keyUUUID;", database.getConnection());
363	SqlParameter param1 = new SqlParameter("@uuid", user.UUID.ToString());	370	SqlParameter param1 = new SqlParameter("@uuid", user.UUID.ToString());
364	SqlParameter param2 = new SqlParameter("@username", user.username);	371	SqlParameter param2 = new SqlParameter("@username", user.username);
@@ -383,6 +390,7 @@ namespace OpenSim.Framework.Data.MSSQL
383	SqlParameter param21 = new SqlParameter("@profileImage", LLUUID.Zero.ToString());	390	SqlParameter param21 = new SqlParameter("@profileImage", LLUUID.Zero.ToString());
384	SqlParameter param22 = new SqlParameter("@profileFirstImage", LLUUID.Zero.ToString());	391	SqlParameter param22 = new SqlParameter("@profileFirstImage", LLUUID.Zero.ToString());
385	SqlParameter param23 = new SqlParameter("@keyUUUID", user.UUID.ToString());	392	SqlParameter param23 = new SqlParameter("@keyUUUID", user.UUID.ToString());
		393	SqlParameter param24 = new SqlParameter("@webLoginKey", user.webLoginKey.UUID.ToString());
386	command.Parameters.Add(param1);	394	command.Parameters.Add(param1);
387	command.Parameters.Add(param2);	395	command.Parameters.Add(param2);
388	command.Parameters.Add(param3);	396	command.Parameters.Add(param3);
@@ -406,6 +414,7 @@ namespace OpenSim.Framework.Data.MSSQL
406	command.Parameters.Add(param21);	414	command.Parameters.Add(param21);
407	command.Parameters.Add(param22);	415	command.Parameters.Add(param22);
408	command.Parameters.Add(param23);	416	command.Parameters.Add(param23);
		417	command.Parameters.Add(param24);
409	try	418	try
410	{	419	{
411	int affected = command.ExecuteNonQuery();	420	int affected = command.ExecuteNonQuery();


diff --git a/OpenSim/Framework/Data.MySQL/MySQLUserData.cs b/OpenSim/Framework/Data.MySQL/MySQLUserData.cs index e53ab18..76ad551 100644 --- a/OpenSim/Framework/Data.MySQL/MySQLUserData.cs +++ b/OpenSim/Framework/Data.MySQL/MySQLUserData.cs
@@ -468,6 +468,39 @@ namespace OpenSim.Framework.Data.MySQL
468	return GetAgentByUUID(profile.UUID);	468	return GetAgentByUUID(profile.UUID);
469	}	469	}
470		470
		471	public void StoreWebLoginKey(LLUUID AgentID, LLUUID WebLoginKey)
		472	{
		473
		474	Dictionary<string, string> param = new Dictionary<string, string>();
		475	param["?UUID"] = AgentID.UUID.ToString();
		476	param["?webLoginKey"] = WebLoginKey.UUID.ToString();
		477
		478	try
		479	{
		480	lock (database)
		481	{
		482	IDbCommand updater =
		483	database.Query(
		484	"update users " +
		485	"SET webLoginKey = ?webLoginKey " +
		486	"where UUID = ?UUID",
		487	param);
		488	updater.ExecuteNonQuery();
		489
		490	}
		491	}
		492	catch (Exception e)
		493	{
		494	database.Reconnect();
		495	MainLog.Instance.Error(e.ToString());
		496	return;
		497	}
		498
		499
		500
		501
		502	}
		503
471	/// <summary>	504	/// <summary>
472	/// Returns an agent session by account UUID	505	/// Returns an agent session by account UUID
473	/// </summary>	506	/// </summary>


diff --git a/OpenSim/Framework/Data.SQLite/SQLiteUserData.cs b/OpenSim/Framework/Data.SQLite/SQLiteUserData.cs index cbbb349..f1f76c4 100644 --- a/OpenSim/Framework/Data.SQLite/SQLiteUserData.cs +++ b/OpenSim/Framework/Data.SQLite/SQLiteUserData.cs
@@ -373,6 +373,29 @@ namespace OpenSim.Framework.Data.SQLite
373	}	373	}
374	}	374	}
375		375
		376
		377	public void StoreWebLoginKey(LLUUID AgentID, LLUUID WebLoginKey)
		378	{
		379	DataTable users = ds.Tables["users"];
		380	lock (ds)
		381	{
		382	DataRow row = users.Rows.Find(Util.ToRawUuidString(AgentID));
		383	if (row == null)
		384	{
		385	MainLog.Instance.Warn("WEBLOGIN", "Unable to store new web login key for non-existant user");
		386	}
		387	else
		388	{
		389	UserProfileData user = GetUserByUUID(AgentID);
		390	user.webLoginKey = WebLoginKey;
		391	fillUserRow(row, user);
		392	da.Update(ds, "users");
		393
		394	}
		395	}
		396
		397	}
		398
376	/// <summary>	399	/// <summary>
377	/// Creates a new user profile	400	/// Creates a new user profile
378	/// </summary>	401	/// </summary>
@@ -392,6 +415,7 @@ namespace OpenSim.Framework.Data.SQLite
392	else	415	else
393	{	416	{
394	fillUserRow(row, user);	417	fillUserRow(row, user);
		418
395	}	419	}
396	// This is why we're getting the 'logins never log-off'.. because It isn't clearing the	420	// This is why we're getting the 'logins never log-off'.. because It isn't clearing the
397	// useragents table once the useragent is null	421	// useragents table once the useragent is null


diff --git a/OpenSim/Framework/IUserData.cs b/OpenSim/Framework/IUserData.cs index eba2329..9fd6fa8 100644 --- a/OpenSim/Framework/IUserData.cs +++ b/OpenSim/Framework/IUserData.cs
@@ -81,6 +81,12 @@ namespace OpenSim.Framework
81	UserAgentData GetAgentByName(string fname, string lname);	81	UserAgentData GetAgentByName(string fname, string lname);
82		82
83	/// <summary>	83	/// <summary>
		84	/// Stores new web-login key for user during web page login
		85	/// </summary>
		86	/// <param name="webLoginKey"></param>
		87	void StoreWebLoginKey(LLUUID agentID, LLUUID webLoginKey);
		88
		89	/// <summary>
84	/// Adds a new User profile to the database	90	/// Adds a new User profile to the database
85	/// </summary>	91	/// </summary>
86	/// <param name="user">UserProfile to add</param>	92	/// <param name="user">UserProfile to add</param>