diff options
author | Adam Frisby | 2007-05-05 23:39:42 +0000 |
---|---|---|
committer | Adam Frisby | 2007-05-05 23:39:42 +0000 |
commit | 7935a8cfcd659d38985c19a612d6a302c344a122 (patch) | |
tree | 300938e47fa2944a15db502906b784669854d21f /OpenGrid.Framework.Data.MSSQL/MSSQLGridData.cs | |
parent | Updated and run prebuild. (diff) | |
download | opensim-SC-7935a8cfcd659d38985c19a612d6a302c344a122.zip opensim-SC-7935a8cfcd659d38985c19a612d6a302c344a122.tar.gz opensim-SC-7935a8cfcd659d38985c19a612d6a302c344a122.tar.bz2 opensim-SC-7935a8cfcd659d38985c19a612d6a302c344a122.tar.xz |
* Added Microsoft SQL Support
Diffstat (limited to '')
-rw-r--r-- | OpenGrid.Framework.Data.MSSQL/MSSQLGridData.cs | 131 |
1 files changed, 131 insertions, 0 deletions
diff --git a/OpenGrid.Framework.Data.MSSQL/MSSQLGridData.cs b/OpenGrid.Framework.Data.MSSQL/MSSQLGridData.cs new file mode 100644 index 0000000..8a93d40 --- /dev/null +++ b/OpenGrid.Framework.Data.MSSQL/MSSQLGridData.cs | |||
@@ -0,0 +1,131 @@ | |||
1 | using System; | ||
2 | using System.Collections.Generic; | ||
3 | using System.Text; | ||
4 | using OpenGrid.Framework.Data; | ||
5 | |||
6 | namespace OpenGrid.Framework.Data.MSSQL | ||
7 | { | ||
8 | public class SqlGridData : IGridData | ||
9 | { | ||
10 | private MSSqlManager database; | ||
11 | |||
12 | /// <summary> | ||
13 | /// Initialises the Grid Interface | ||
14 | /// </summary> | ||
15 | public void Initialise() | ||
16 | { | ||
17 | database = new MSSqlManager("localhost", "db", "user", "password", "false"); | ||
18 | } | ||
19 | |||
20 | /// <summary> | ||
21 | /// Shuts down the grid interface | ||
22 | /// </summary> | ||
23 | public void Close() | ||
24 | { | ||
25 | database.Close(); | ||
26 | } | ||
27 | |||
28 | public string getName() | ||
29 | { | ||
30 | return "Sql OpenGridData"; | ||
31 | } | ||
32 | |||
33 | public string getVersion() | ||
34 | { | ||
35 | return "0.1"; | ||
36 | } | ||
37 | |||
38 | /// <summary> | ||
39 | /// Returns a sim profile from it's location | ||
40 | /// </summary> | ||
41 | /// <param name="handle">Region location handle</param> | ||
42 | /// <returns>Sim profile</returns> | ||
43 | public SimProfileData GetProfileByHandle(ulong handle) | ||
44 | { | ||
45 | Dictionary<string, string> param = new Dictionary<string, string>(); | ||
46 | param["handle"] = handle.ToString(); | ||
47 | |||
48 | System.Data.IDbCommand result = database.Query("SELECT * FROM regions WHERE handle = @handle", param); | ||
49 | System.Data.IDataReader reader = result.ExecuteReader(); | ||
50 | |||
51 | SimProfileData row = database.getRow(reader); | ||
52 | reader.Close(); | ||
53 | result.Dispose(); | ||
54 | |||
55 | return row; | ||
56 | } | ||
57 | |||
58 | /// <summary> | ||
59 | /// Returns a sim profile from it's UUID | ||
60 | /// </summary> | ||
61 | /// <param name="uuid">The region UUID</param> | ||
62 | /// <returns>The sim profile</returns> | ||
63 | public SimProfileData GetProfileByLLUUID(libsecondlife.LLUUID uuid) | ||
64 | { | ||
65 | Dictionary<string, string> param = new Dictionary<string, string>(); | ||
66 | param["uuid"] = uuid.ToStringHyphenated(); | ||
67 | |||
68 | System.Data.IDbCommand result = database.Query("SELECT * FROM regions WHERE uuid = @uuid", param); | ||
69 | System.Data.IDataReader reader = result.ExecuteReader(); | ||
70 | |||
71 | SimProfileData row = database.getRow(reader); | ||
72 | reader.Close(); | ||
73 | result.Dispose(); | ||
74 | |||
75 | return row; | ||
76 | } | ||
77 | |||
78 | public DataResponse AddProfile(SimProfileData profile) | ||
79 | { | ||
80 | if (database.insertRow(profile)) | ||
81 | { | ||
82 | return DataResponse.RESPONSE_OK; | ||
83 | } | ||
84 | else | ||
85 | { | ||
86 | return DataResponse.RESPONSE_ERROR; | ||
87 | } | ||
88 | } | ||
89 | |||
90 | /// <summary> | ||
91 | /// DEPRECIATED. Attempts to authenticate a region by comparing a shared secret. | ||
92 | /// </summary> | ||
93 | /// <param name="uuid">The UUID of the challenger</param> | ||
94 | /// <param name="handle">The attempted regionHandle of the challenger</param> | ||
95 | /// <param name="authkey">The secret</param> | ||
96 | /// <returns>Whether the secret and regionhandle match the database entry for UUID</returns> | ||
97 | public bool AuthenticateSim(libsecondlife.LLUUID uuid, ulong handle, string authkey) | ||
98 | { | ||
99 | bool throwHissyFit = false; // Should be true by 1.0 | ||
100 | |||
101 | if (throwHissyFit) | ||
102 | throw new Exception("CRYPTOWEAK AUTHENTICATE: Refusing to authenticate due to replay potential."); | ||
103 | |||
104 | SimProfileData data = GetProfileByLLUUID(uuid); | ||
105 | |||
106 | return (handle == data.regionHandle && authkey == data.regionSecret); | ||
107 | } | ||
108 | |||
109 | /// <summary> | ||
110 | /// NOT YET FUNCTIONAL. Provides a cryptographic authentication of a region | ||
111 | /// </summary> | ||
112 | /// <remarks>This requires a security audit.</remarks> | ||
113 | /// <param name="uuid"></param> | ||
114 | /// <param name="handle"></param> | ||
115 | /// <param name="authhash"></param> | ||
116 | /// <param name="challenge"></param> | ||
117 | /// <returns></returns> | ||
118 | public bool AuthenticateSim(libsecondlife.LLUUID uuid, ulong handle, string authhash, string challenge) | ||
119 | { | ||
120 | System.Security.Cryptography.SHA512Managed HashProvider = new System.Security.Cryptography.SHA512Managed(); | ||
121 | System.Text.ASCIIEncoding TextProvider = new ASCIIEncoding(); | ||
122 | |||
123 | byte[] stream = TextProvider.GetBytes(uuid.ToStringHyphenated() + ":" + handle.ToString() + ":" + challenge); | ||
124 | byte[] hash = HashProvider.ComputeHash(stream); | ||
125 | |||
126 | return false; | ||
127 | } | ||
128 | } | ||
129 | |||
130 | |||
131 | } | ||