diff options
4 files changed, 661 insertions, 2 deletions
diff --git a/OpenSim/Data/MySQL/MySQLXAssetData.cs b/OpenSim/Data/MySQL/MySQLXAssetData.cs new file mode 100644 index 0000000..f15a9f3 --- /dev/null +++ b/OpenSim/Data/MySQL/MySQLXAssetData.cs | |||
@@ -0,0 +1,416 @@ | |||
1 | /* | ||
2 | * Copyright (c) Contributors, http://opensimulator.org/ | ||
3 | * See CONTRIBUTORS.TXT for a full list of copyright holders. | ||
4 | * | ||
5 | * Redistribution and use in source and binary forms, with or without | ||
6 | * modification, are permitted provided that the following conditions are met: | ||
7 | * * Redistributions of source code must retain the above copyright | ||
8 | * notice, this list of conditions and the following disclaimer. | ||
9 | * * Redistributions in binary form must reproduce the above copyright | ||
10 | * notice, this list of conditions and the following disclaimer in the | ||
11 | * documentation and/or other materials provided with the distribution. | ||
12 | * * Neither the name of the OpenSimulator Project nor the | ||
13 | * names of its contributors may be used to endorse or promote products | ||
14 | * derived from this software without specific prior written permission. | ||
15 | * | ||
16 | * THIS SOFTWARE IS PROVIDED BY THE DEVELOPERS ``AS IS'' AND ANY | ||
17 | * EXPRESS OR IMPLIED WARRANTIES, INCLUDING, BUT NOT LIMITED TO, THE IMPLIED | ||
18 | * WARRANTIES OF MERCHANTABILITY AND FITNESS FOR A PARTICULAR PURPOSE ARE | ||
19 | * DISCLAIMED. IN NO EVENT SHALL THE CONTRIBUTORS BE LIABLE FOR ANY | ||
20 | * DIRECT, INDIRECT, INCIDENTAL, SPECIAL, EXEMPLARY, OR CONSEQUENTIAL DAMAGES | ||
21 | * (INCLUDING, BUT NOT LIMITED TO, PROCUREMENT OF SUBSTITUTE GOODS OR SERVICES; | ||
22 | * LOSS OF USE, DATA, OR PROFITS; OR BUSINESS INTERRUPTION) HOWEVER CAUSED AND | ||
23 | * ON ANY THEORY OF LIABILITY, WHETHER IN CONTRACT, STRICT LIABILITY, OR TORT | ||
24 | * (INCLUDING NEGLIGENCE OR OTHERWISE) ARISING IN ANY WAY OUT OF THE USE OF THIS | ||
25 | * SOFTWARE, EVEN IF ADVISED OF THE POSSIBILITY OF SUCH DAMAGE. | ||
26 | */ | ||
27 | |||
28 | using System; | ||
29 | using System.Data; | ||
30 | using System.Reflection; | ||
31 | using System.Collections.Generic; | ||
32 | using System.Text; | ||
33 | using log4net; | ||
34 | using MySql.Data.MySqlClient; | ||
35 | using OpenMetaverse; | ||
36 | using OpenSim.Framework; | ||
37 | using OpenSim.Data; | ||
38 | |||
39 | namespace OpenSim.Data.MySQL | ||
40 | { | ||
41 | public class MySQLXAssetData : AssetDataBase | ||
42 | { | ||
43 | private static readonly ILog m_log = LogManager.GetLogger(MethodBase.GetCurrentMethod().DeclaringType); | ||
44 | |||
45 | private string m_connectionString; | ||
46 | private object m_dbLock = new object(); | ||
47 | |||
48 | protected virtual Assembly Assembly | ||
49 | { | ||
50 | get { return GetType().Assembly; } | ||
51 | } | ||
52 | |||
53 | #region IPlugin Members | ||
54 | |||
55 | public override string Version { get { return "1.0.0.0"; } } | ||
56 | |||
57 | /// <summary> | ||
58 | /// <para>Initialises Asset interface</para> | ||
59 | /// <para> | ||
60 | /// <list type="bullet"> | ||
61 | /// <item>Loads and initialises the MySQL storage plugin.</item> | ||
62 | /// <item>Warns and uses the obsolete mysql_connection.ini if connect string is empty.</item> | ||
63 | /// <item>Check for migration</item> | ||
64 | /// </list> | ||
65 | /// </para> | ||
66 | /// </summary> | ||
67 | /// <param name="connect">connect string</param> | ||
68 | public override void Initialise(string connect) | ||
69 | { | ||
70 | m_connectionString = connect; | ||
71 | |||
72 | using (MySqlConnection dbcon = new MySqlConnection(m_connectionString)) | ||
73 | { | ||
74 | dbcon.Open(); | ||
75 | Migration m = new Migration(dbcon, Assembly, "XAssetStore"); | ||
76 | m.Update(); | ||
77 | } | ||
78 | } | ||
79 | |||
80 | public override void Initialise() | ||
81 | { | ||
82 | throw new NotImplementedException(); | ||
83 | } | ||
84 | |||
85 | public override void Dispose() { } | ||
86 | |||
87 | /// <summary> | ||
88 | /// The name of this DB provider | ||
89 | /// </summary> | ||
90 | override public string Name | ||
91 | { | ||
92 | get { return "MySQL XAsset storage engine"; } | ||
93 | } | ||
94 | |||
95 | #endregion | ||
96 | |||
97 | #region IAssetDataPlugin Members | ||
98 | |||
99 | /// <summary> | ||
100 | /// Fetch Asset <paramref name="assetID"/> from database | ||
101 | /// </summary> | ||
102 | /// <param name="assetID">Asset UUID to fetch</param> | ||
103 | /// <returns>Return the asset</returns> | ||
104 | /// <remarks>On failure : throw an exception and attempt to reconnect to database</remarks> | ||
105 | override public AssetBase GetAsset(UUID assetID) | ||
106 | { | ||
107 | AssetBase asset = null; | ||
108 | lock (m_dbLock) | ||
109 | { | ||
110 | using (MySqlConnection dbcon = new MySqlConnection(m_connectionString)) | ||
111 | { | ||
112 | dbcon.Open(); | ||
113 | |||
114 | string hash = null; | ||
115 | |||
116 | using (MySqlCommand cmd = new MySqlCommand( | ||
117 | "SELECT name, hash, description, asset_type, local, temporary, asset_flags, creator_id FROM xassetsmeta WHERE id=?id", | ||
118 | dbcon)) | ||
119 | { | ||
120 | cmd.Parameters.AddWithValue("?id", assetID.ToString()); | ||
121 | |||
122 | try | ||
123 | { | ||
124 | using (MySqlDataReader dbReader = cmd.ExecuteReader(CommandBehavior.SingleRow)) | ||
125 | { | ||
126 | if (dbReader.Read()) | ||
127 | { | ||
128 | asset = new AssetBase(assetID, (string)dbReader["name"], (sbyte)dbReader["asset_type"], dbReader["creator_id"].ToString()); | ||
129 | hash = (string)dbReader["hash"]; | ||
130 | asset.Description = (string)dbReader["description"]; | ||
131 | |||
132 | string local = dbReader["local"].ToString(); | ||
133 | if (local.Equals("1") || local.Equals("true", StringComparison.InvariantCultureIgnoreCase)) | ||
134 | asset.Local = true; | ||
135 | else | ||
136 | asset.Local = false; | ||
137 | |||
138 | asset.Temporary = Convert.ToBoolean(dbReader["temporary"]); | ||
139 | asset.Flags = (AssetFlags)Convert.ToInt32(dbReader["asset_flags"]); | ||
140 | } | ||
141 | } | ||
142 | } | ||
143 | catch (Exception e) | ||
144 | { | ||
145 | m_log.Error("[MYSQL XASSET DATA]: MySql failure fetching asset " + assetID + ": " + e.Message); | ||
146 | } | ||
147 | } | ||
148 | |||
149 | if (asset == null) | ||
150 | return null; | ||
151 | |||
152 | m_log.DebugFormat( | ||
153 | "[MYSQL XASSET DATA]: Looking for asset {0} {1} with hash {2}", asset.FullID, asset.Name, hash); | ||
154 | |||
155 | using (MySqlCommand cmd = new MySqlCommand( | ||
156 | "SELECT data FROM xassetsdata WHERE hash=?hash", | ||
157 | dbcon)) | ||
158 | { | ||
159 | cmd.Parameters.AddWithValue("?hash", hash); | ||
160 | |||
161 | try | ||
162 | { | ||
163 | using (MySqlDataReader dbReader = cmd.ExecuteReader(CommandBehavior.SingleRow)) | ||
164 | { | ||
165 | if (dbReader.Read()) | ||
166 | asset.Data = (byte[])dbReader["data"]; | ||
167 | } | ||
168 | } | ||
169 | catch (Exception e) | ||
170 | { | ||
171 | m_log.Error("[MYSQL XASSET DATA]: MySql failure fetching asset metadata " + assetID + ": " + e.Message); | ||
172 | } | ||
173 | } | ||
174 | } | ||
175 | } | ||
176 | |||
177 | return asset; | ||
178 | } | ||
179 | |||
180 | /// <summary> | ||
181 | /// Create an asset in database, or update it if existing. | ||
182 | /// </summary> | ||
183 | /// <param name="asset">Asset UUID to create</param> | ||
184 | /// <remarks>On failure : Throw an exception and attempt to reconnect to database</remarks> | ||
185 | override public void StoreAsset(AssetBase asset) | ||
186 | { | ||
187 | lock (m_dbLock) | ||
188 | { | ||
189 | using (MySqlConnection dbcon = new MySqlConnection(m_connectionString)) | ||
190 | { | ||
191 | dbcon.Open(); | ||
192 | |||
193 | string assetName = asset.Name; | ||
194 | if (asset.Name.Length > 64) | ||
195 | { | ||
196 | assetName = asset.Name.Substring(0, 64); | ||
197 | m_log.Warn("[XASSET DB]: Name field truncated from " + asset.Name.Length + " to " + assetName.Length + " characters on add"); | ||
198 | } | ||
199 | |||
200 | string assetDescription = asset.Description; | ||
201 | if (asset.Description.Length > 64) | ||
202 | { | ||
203 | assetDescription = asset.Description.Substring(0, 64); | ||
204 | m_log.Warn("[XASSET DB]: Description field truncated from " + asset.Description.Length + " to " + assetDescription.Length + " characters on add"); | ||
205 | } | ||
206 | |||
207 | string hash = Util.SHA1Hash(asset.Data); | ||
208 | |||
209 | try | ||
210 | { | ||
211 | using (MySqlCommand cmd = | ||
212 | new MySqlCommand( | ||
213 | "replace INTO xassetsmeta(id, hash, name, description, asset_type, local, temporary, create_time, access_time, asset_flags, creator_id)" + | ||
214 | "VALUES(?id, ?hash, ?name, ?description, ?asset_type, ?local, ?temporary, ?create_time, ?access_time, ?asset_flags, ?creator_id)", | ||
215 | dbcon)) | ||
216 | { | ||
217 | // create unix epoch time | ||
218 | int now = (int)Utils.DateTimeToUnixTime(DateTime.UtcNow); | ||
219 | cmd.Parameters.AddWithValue("?id", asset.ID); | ||
220 | cmd.Parameters.AddWithValue("?hash", hash); | ||
221 | cmd.Parameters.AddWithValue("?name", assetName); | ||
222 | cmd.Parameters.AddWithValue("?description", assetDescription); | ||
223 | cmd.Parameters.AddWithValue("?asset_type", asset.Type); | ||
224 | cmd.Parameters.AddWithValue("?local", asset.Local); | ||
225 | cmd.Parameters.AddWithValue("?temporary", asset.Temporary); | ||
226 | cmd.Parameters.AddWithValue("?create_time", now); | ||
227 | cmd.Parameters.AddWithValue("?access_time", now); | ||
228 | cmd.Parameters.AddWithValue("?creator_id", asset.Metadata.CreatorID); | ||
229 | cmd.Parameters.AddWithValue("?asset_flags", (int)asset.Flags); | ||
230 | cmd.Parameters.AddWithValue("?data", asset.Data); | ||
231 | cmd.ExecuteNonQuery(); | ||
232 | cmd.Dispose(); | ||
233 | } | ||
234 | } | ||
235 | catch (Exception e) | ||
236 | { | ||
237 | m_log.ErrorFormat("[ASSET DB]: MySQL failure creating asset metadata {0} with name \"{1}\". Error: {2}", | ||
238 | asset.FullID, asset.Name, e.Message); | ||
239 | } | ||
240 | |||
241 | try | ||
242 | { | ||
243 | using (MySqlCommand cmd = | ||
244 | new MySqlCommand( | ||
245 | "replace INTO xassetsdata(hash, data) VALUES(?hash, ?data)", | ||
246 | dbcon)) | ||
247 | { | ||
248 | cmd.Parameters.AddWithValue("?hash", hash); | ||
249 | cmd.Parameters.AddWithValue("?data", asset.Data); | ||
250 | cmd.ExecuteNonQuery(); | ||
251 | cmd.Dispose(); | ||
252 | } | ||
253 | } | ||
254 | catch (Exception e) | ||
255 | { | ||
256 | m_log.ErrorFormat("[XASSET DB]: MySQL failure creating asset data {0} with name \"{1}\". Error: {2}", | ||
257 | asset.FullID, asset.Name, e.Message); | ||
258 | } | ||
259 | } | ||
260 | } | ||
261 | } | ||
262 | |||
263 | // private void UpdateAccessTime(AssetBase asset) | ||
264 | // { | ||
265 | // lock (m_dbLock) | ||
266 | // { | ||
267 | // using (MySqlConnection dbcon = new MySqlConnection(m_connectionString)) | ||
268 | // { | ||
269 | // dbcon.Open(); | ||
270 | // MySqlCommand cmd = | ||
271 | // new MySqlCommand("update assets set access_time=?access_time where id=?id", | ||
272 | // dbcon); | ||
273 | // | ||
274 | // // need to ensure we dispose | ||
275 | // try | ||
276 | // { | ||
277 | // using (cmd) | ||
278 | // { | ||
279 | // // create unix epoch time | ||
280 | // int now = (int)Utils.DateTimeToUnixTime(DateTime.UtcNow); | ||
281 | // cmd.Parameters.AddWithValue("?id", asset.ID); | ||
282 | // cmd.Parameters.AddWithValue("?access_time", now); | ||
283 | // cmd.ExecuteNonQuery(); | ||
284 | // cmd.Dispose(); | ||
285 | // } | ||
286 | // } | ||
287 | // catch (Exception e) | ||
288 | // { | ||
289 | // m_log.ErrorFormat( | ||
290 | // "[ASSETS DB]: " + | ||
291 | // "MySql failure updating access_time for asset {0} with name {1}" + Environment.NewLine + e.ToString() | ||
292 | // + Environment.NewLine + "Attempting reconnection", asset.FullID, asset.Name); | ||
293 | // } | ||
294 | // } | ||
295 | // } | ||
296 | // | ||
297 | // } | ||
298 | |||
299 | /// <summary> | ||
300 | /// Check if the asset exists in the database | ||
301 | /// </summary> | ||
302 | /// <param name="uuid">The asset UUID</param> | ||
303 | /// <returns>true if it exists, false otherwise.</returns> | ||
304 | override public bool ExistsAsset(UUID uuid) | ||
305 | { | ||
306 | // m_log.DebugFormat("[ASSETS DB]: Checking for asset {0}", uuid); | ||
307 | |||
308 | bool assetExists = false; | ||
309 | |||
310 | lock (m_dbLock) | ||
311 | { | ||
312 | using (MySqlConnection dbcon = new MySqlConnection(m_connectionString)) | ||
313 | { | ||
314 | dbcon.Open(); | ||
315 | using (MySqlCommand cmd = new MySqlCommand("SELECT id FROM xassetsmeta WHERE id=?id", dbcon)) | ||
316 | { | ||
317 | cmd.Parameters.AddWithValue("?id", uuid.ToString()); | ||
318 | |||
319 | try | ||
320 | { | ||
321 | using (MySqlDataReader dbReader = cmd.ExecuteReader(CommandBehavior.SingleRow)) | ||
322 | { | ||
323 | if (dbReader.Read()) | ||
324 | { | ||
325 | // m_log.DebugFormat("[ASSETS DB]: Found asset {0}", uuid); | ||
326 | assetExists = true; | ||
327 | } | ||
328 | } | ||
329 | } | ||
330 | catch (Exception e) | ||
331 | { | ||
332 | m_log.ErrorFormat( | ||
333 | "[XASSETS DB]: MySql failure fetching asset {0}" + Environment.NewLine + e.ToString(), uuid); | ||
334 | } | ||
335 | } | ||
336 | } | ||
337 | } | ||
338 | |||
339 | return assetExists; | ||
340 | } | ||
341 | |||
342 | /// <summary> | ||
343 | /// Returns a list of AssetMetadata objects. The list is a subset of | ||
344 | /// the entire data set offset by <paramref name="start" /> containing | ||
345 | /// <paramref name="count" /> elements. | ||
346 | /// </summary> | ||
347 | /// <param name="start">The number of results to discard from the total data set.</param> | ||
348 | /// <param name="count">The number of rows the returned list should contain.</param> | ||
349 | /// <returns>A list of AssetMetadata objects.</returns> | ||
350 | public override List<AssetMetadata> FetchAssetMetadataSet(int start, int count) | ||
351 | { | ||
352 | List<AssetMetadata> retList = new List<AssetMetadata>(count); | ||
353 | |||
354 | lock (m_dbLock) | ||
355 | { | ||
356 | using (MySqlConnection dbcon = new MySqlConnection(m_connectionString)) | ||
357 | { | ||
358 | dbcon.Open(); | ||
359 | MySqlCommand cmd = new MySqlCommand("SELECT name,description,asset_type,temporary,id,asset_flags,creator_id FROM xassetsmeta LIMIT ?start, ?count", dbcon); | ||
360 | cmd.Parameters.AddWithValue("?start", start); | ||
361 | cmd.Parameters.AddWithValue("?count", count); | ||
362 | |||
363 | try | ||
364 | { | ||
365 | using (MySqlDataReader dbReader = cmd.ExecuteReader()) | ||
366 | { | ||
367 | while (dbReader.Read()) | ||
368 | { | ||
369 | AssetMetadata metadata = new AssetMetadata(); | ||
370 | metadata.Name = (string)dbReader["name"]; | ||
371 | metadata.Description = (string)dbReader["description"]; | ||
372 | metadata.Type = (sbyte)dbReader["asset_type"]; | ||
373 | metadata.Temporary = Convert.ToBoolean(dbReader["temporary"]); // Not sure if this is correct. | ||
374 | metadata.Flags = (AssetFlags)Convert.ToInt32(dbReader["asset_flags"]); | ||
375 | metadata.FullID = DBGuid.FromDB(dbReader["id"]); | ||
376 | metadata.CreatorID = dbReader["creator_id"].ToString(); | ||
377 | metadata.SHA1 = Encoding.Default.GetBytes((string)dbReader["hash"]); | ||
378 | |||
379 | retList.Add(metadata); | ||
380 | } | ||
381 | } | ||
382 | } | ||
383 | catch (Exception e) | ||
384 | { | ||
385 | m_log.Error("[XASSETS DB]: MySql failure fetching asset set" + Environment.NewLine + e.ToString()); | ||
386 | } | ||
387 | } | ||
388 | } | ||
389 | |||
390 | return retList; | ||
391 | } | ||
392 | |||
393 | public override bool Delete(string id) | ||
394 | { | ||
395 | lock (m_dbLock) | ||
396 | { | ||
397 | using (MySqlConnection dbcon = new MySqlConnection(m_connectionString)) | ||
398 | { | ||
399 | dbcon.Open(); | ||
400 | MySqlCommand cmd = new MySqlCommand("delete from xassetsmeta where id=?id", dbcon); | ||
401 | cmd.Parameters.AddWithValue("?id", id); | ||
402 | cmd.ExecuteNonQuery(); | ||
403 | |||
404 | cmd.Dispose(); | ||
405 | |||
406 | // TODO: How do we deal with data from deleted assets? Probably not easily reapable unless we | ||
407 | // keep a reference count (?) | ||
408 | } | ||
409 | } | ||
410 | |||
411 | return true; | ||
412 | } | ||
413 | |||
414 | #endregion | ||
415 | } | ||
416 | } \ No newline at end of file | ||
diff --git a/OpenSim/Data/MySQL/Resources/XAssetStore.migrations b/OpenSim/Data/MySQL/Resources/XAssetStore.migrations new file mode 100644 index 0000000..b89eab2 --- /dev/null +++ b/OpenSim/Data/MySQL/Resources/XAssetStore.migrations | |||
@@ -0,0 +1,27 @@ | |||
1 | # ----------------- | ||
2 | :VERSION 1 | ||
3 | |||
4 | BEGIN; | ||
5 | |||
6 | CREATE TABLE `xassetsmeta` ( | ||
7 | `id` char(36) NOT NULL, | ||
8 | `hash` char(64) NOT NULL, | ||
9 | `name` varchar(64) NOT NULL, | ||
10 | `description` varchar(64) NOT NULL, | ||
11 | `asset_type` tinyint(4) NOT NULL, | ||
12 | `local` tinyint(1) NOT NULL, | ||
13 | `temporary` tinyint(1) NOT NULL, | ||
14 | `create_time` int(11) NOT NULL, | ||
15 | `access_time` int(11) NOT NULL, | ||
16 | `asset_flags` int(11) NOT NULL, | ||
17 | `creator_id` varchar(128) NOT NULL, | ||
18 | PRIMARY KEY (`id`) | ||
19 | ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='Version 1'; | ||
20 | |||
21 | CREATE TABLE `xassetsdata` ( | ||
22 | `hash` char(64) NOT NULL, | ||
23 | `data` longblob NOT NULL, | ||
24 | PRIMARY KEY (`hash`) | ||
25 | ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='Version 1'; | ||
26 | |||
27 | COMMIT; \ No newline at end of file | ||
diff --git a/OpenSim/Region/CoreModules/ServiceConnectorsOut/Asset/LocalAssetServiceConnector.cs b/OpenSim/Region/CoreModules/ServiceConnectorsOut/Asset/LocalAssetServiceConnector.cs index 2e6ec90..c78915f 100644 --- a/OpenSim/Region/CoreModules/ServiceConnectorsOut/Asset/LocalAssetServiceConnector.cs +++ b/OpenSim/Region/CoreModules/ServiceConnectorsOut/Asset/LocalAssetServiceConnector.cs | |||
@@ -73,14 +73,17 @@ namespace OpenSim.Region.CoreModules.ServiceConnectorsOut.Asset | |||
73 | return; | 73 | return; |
74 | } | 74 | } |
75 | 75 | ||
76 | string serviceDll = assetConfig.GetString("LocalServiceModule", | 76 | string serviceDll = assetConfig.GetString("LocalServiceModule", String.Empty); |
77 | String.Empty); | ||
78 | 77 | ||
79 | if (serviceDll == String.Empty) | 78 | if (serviceDll == String.Empty) |
80 | { | 79 | { |
81 | m_log.Error("[LOCAL ASSET SERVICES CONNECTOR]: No LocalServiceModule named in section AssetService"); | 80 | m_log.Error("[LOCAL ASSET SERVICES CONNECTOR]: No LocalServiceModule named in section AssetService"); |
82 | return; | 81 | return; |
83 | } | 82 | } |
83 | else | ||
84 | { | ||
85 | m_log.DebugFormat("[LOCAL ASSET SERVICES CONNECTOR]: Loading asset service at {0}", serviceDll); | ||
86 | } | ||
84 | 87 | ||
85 | Object[] args = new Object[] { source }; | 88 | Object[] args = new Object[] { source }; |
86 | m_AssetService = ServerUtils.LoadPlugin<IAssetService>(serviceDll, args); | 89 | m_AssetService = ServerUtils.LoadPlugin<IAssetService>(serviceDll, args); |
diff --git a/OpenSim/Services/AssetService/XAssetService.cs b/OpenSim/Services/AssetService/XAssetService.cs new file mode 100644 index 0000000..d161c58 --- /dev/null +++ b/OpenSim/Services/AssetService/XAssetService.cs | |||
@@ -0,0 +1,213 @@ | |||
1 | /* | ||
2 | * Copyright (c) Contributors, http://opensimulator.org/ | ||
3 | * See CONTRIBUTORS.TXT for a full list of copyright holders. | ||
4 | * | ||
5 | * Redistribution and use in source and binary forms, with or without | ||
6 | * modification, are permitted provided that the following conditions are met: | ||
7 | * * Redistributions of source code must retain the above copyright | ||
8 | * notice, this list of conditions and the following disclaimer. | ||
9 | * * Redistributions in binary form must reproduce the above copyright | ||
10 | * notice, this list of conditions and the following disclaimer in the | ||
11 | * documentation and/or other materials provided with the distribution. | ||
12 | * * Neither the name of the OpenSimulator Project nor the | ||
13 | * names of its contributors may be used to endorse or promote products | ||
14 | * derived from this software without specific prior written permission. | ||
15 | * | ||
16 | * THIS SOFTWARE IS PROVIDED BY THE DEVELOPERS ``AS IS'' AND ANY | ||
17 | * EXPRESS OR IMPLIED WARRANTIES, INCLUDING, BUT NOT LIMITED TO, THE IMPLIED | ||
18 | * WARRANTIES OF MERCHANTABILITY AND FITNESS FOR A PARTICULAR PURPOSE ARE | ||
19 | * DISCLAIMED. IN NO EVENT SHALL THE CONTRIBUTORS BE LIABLE FOR ANY | ||
20 | * DIRECT, INDIRECT, INCIDENTAL, SPECIAL, EXEMPLARY, OR CONSEQUENTIAL DAMAGES | ||
21 | * (INCLUDING, BUT NOT LIMITED TO, PROCUREMENT OF SUBSTITUTE GOODS OR SERVICES; | ||
22 | * LOSS OF USE, DATA, OR PROFITS; OR BUSINESS INTERRUPTION) HOWEVER CAUSED AND | ||
23 | * ON ANY THEORY OF LIABILITY, WHETHER IN CONTRACT, STRICT LIABILITY, OR TORT | ||
24 | * (INCLUDING NEGLIGENCE OR OTHERWISE) ARISING IN ANY WAY OUT OF THE USE OF THIS | ||
25 | * SOFTWARE, EVEN IF ADVISED OF THE POSSIBILITY OF SUCH DAMAGE. | ||
26 | */ | ||
27 | |||
28 | using System; | ||
29 | using System.Collections.Generic; | ||
30 | using System.IO; | ||
31 | using System.Reflection; | ||
32 | using Nini.Config; | ||
33 | using log4net; | ||
34 | using OpenSim.Framework; | ||
35 | using OpenSim.Data; | ||
36 | using OpenSim.Services.Interfaces; | ||
37 | using OpenMetaverse; | ||
38 | |||
39 | namespace OpenSim.Services.AssetService | ||
40 | { | ||
41 | /// <summary> | ||
42 | /// This will be developed into a de-duplicating asset service. | ||
43 | /// XXX: Currently it's a just a copy of the existing AssetService. so please don't attempt to use it. | ||
44 | /// </summary> | ||
45 | public class XAssetService : AssetServiceBase, IAssetService | ||
46 | { | ||
47 | private static readonly ILog m_log = LogManager.GetLogger(MethodBase.GetCurrentMethod().DeclaringType); | ||
48 | |||
49 | protected static XAssetService m_RootInstance; | ||
50 | |||
51 | public XAssetService(IConfigSource config) : base(config) | ||
52 | { | ||
53 | if (m_RootInstance == null) | ||
54 | { | ||
55 | m_RootInstance = this; | ||
56 | |||
57 | if (m_AssetLoader != null) | ||
58 | { | ||
59 | IConfig assetConfig = config.Configs["AssetService"]; | ||
60 | if (assetConfig == null) | ||
61 | throw new Exception("No AssetService configuration"); | ||
62 | |||
63 | string loaderArgs = assetConfig.GetString("AssetLoaderArgs", | ||
64 | String.Empty); | ||
65 | |||
66 | bool assetLoaderEnabled = assetConfig.GetBoolean("AssetLoaderEnabled", true); | ||
67 | |||
68 | if (assetLoaderEnabled) | ||
69 | { | ||
70 | m_log.DebugFormat("[XASSET SERVICE]: Loading default asset set from {0}", loaderArgs); | ||
71 | |||
72 | m_AssetLoader.ForEachDefaultXmlAsset( | ||
73 | loaderArgs, | ||
74 | delegate(AssetBase a) | ||
75 | { | ||
76 | AssetBase existingAsset = Get(a.ID); | ||
77 | // AssetMetadata existingMetadata = GetMetadata(a.ID); | ||
78 | |||
79 | if (existingAsset == null || Util.SHA1Hash(existingAsset.Data) != Util.SHA1Hash(a.Data)) | ||
80 | { | ||
81 | // m_log.DebugFormat("[ASSET]: Storing {0} {1}", a.Name, a.ID); | ||
82 | Store(a); | ||
83 | } | ||
84 | }); | ||
85 | } | ||
86 | |||
87 | m_log.Debug("[XASSET SERVICE]: Local asset service enabled"); | ||
88 | } | ||
89 | } | ||
90 | } | ||
91 | |||
92 | public virtual AssetBase Get(string id) | ||
93 | { | ||
94 | // m_log.DebugFormat("[ASSET SERVICE]: Get asset for {0}", id); | ||
95 | |||
96 | UUID assetID; | ||
97 | |||
98 | if (!UUID.TryParse(id, out assetID)) | ||
99 | { | ||
100 | m_log.WarnFormat("[XASSET SERVICE]: Could not parse requested asset id {0}", id); | ||
101 | return null; | ||
102 | } | ||
103 | |||
104 | try | ||
105 | { | ||
106 | return m_Database.GetAsset(assetID); | ||
107 | } | ||
108 | catch (Exception e) | ||
109 | { | ||
110 | m_log.ErrorFormat("[XASSET SERVICE]: Exception getting asset {0} {1}", assetID, e); | ||
111 | return null; | ||
112 | } | ||
113 | } | ||
114 | |||
115 | public virtual AssetBase GetCached(string id) | ||
116 | { | ||
117 | return Get(id); | ||
118 | } | ||
119 | |||
120 | public virtual AssetMetadata GetMetadata(string id) | ||
121 | { | ||
122 | // m_log.DebugFormat("[XASSET SERVICE]: Get asset metadata for {0}", id); | ||
123 | |||
124 | UUID assetID; | ||
125 | |||
126 | if (!UUID.TryParse(id, out assetID)) | ||
127 | return null; | ||
128 | |||
129 | AssetBase asset = m_Database.GetAsset(assetID); | ||
130 | if (asset != null) | ||
131 | return asset.Metadata; | ||
132 | |||
133 | return null; | ||
134 | } | ||
135 | |||
136 | public virtual byte[] GetData(string id) | ||
137 | { | ||
138 | // m_log.DebugFormat("[XASSET SERVICE]: Get asset data for {0}", id); | ||
139 | |||
140 | UUID assetID; | ||
141 | |||
142 | if (!UUID.TryParse(id, out assetID)) | ||
143 | return null; | ||
144 | |||
145 | AssetBase asset = m_Database.GetAsset(assetID); | ||
146 | return asset.Data; | ||
147 | } | ||
148 | |||
149 | public virtual bool Get(string id, Object sender, AssetRetrieved handler) | ||
150 | { | ||
151 | //m_log.DebugFormat("[XASSET SERVICE]: Get asset async {0}", id); | ||
152 | |||
153 | UUID assetID; | ||
154 | |||
155 | if (!UUID.TryParse(id, out assetID)) | ||
156 | return false; | ||
157 | |||
158 | AssetBase asset = m_Database.GetAsset(assetID); | ||
159 | |||
160 | //m_log.DebugFormat("[XASSET SERVICE]: Got asset {0}", asset); | ||
161 | |||
162 | handler(id, sender, asset); | ||
163 | |||
164 | return true; | ||
165 | } | ||
166 | |||
167 | public virtual string Store(AssetBase asset) | ||
168 | { | ||
169 | if (!m_Database.ExistsAsset(asset.FullID)) | ||
170 | { | ||
171 | // m_log.DebugFormat( | ||
172 | // "[XASSET SERVICE]: Storing asset {0} {1}, bytes {2}", asset.Name, asset.FullID, asset.Data.Length); | ||
173 | m_Database.StoreAsset(asset); | ||
174 | } | ||
175 | // else | ||
176 | // { | ||
177 | // m_log.DebugFormat( | ||
178 | // "[XASSET SERVICE]: Not storing asset {0} {1}, bytes {2} as it already exists", asset.Name, asset.FullID, asset.Data.Length); | ||
179 | // } | ||
180 | |||
181 | return asset.ID; | ||
182 | } | ||
183 | |||
184 | public bool UpdateContent(string id, byte[] data) | ||
185 | { | ||
186 | return false; | ||
187 | } | ||
188 | |||
189 | public virtual bool Delete(string id) | ||
190 | { | ||
191 | m_log.DebugFormat("[XASSET SERVICE]: Deleting asset {0}", id); | ||
192 | UUID assetID; | ||
193 | if (!UUID.TryParse(id, out assetID)) | ||
194 | return false; | ||
195 | |||
196 | AssetBase asset = m_Database.GetAsset(assetID); | ||
197 | if (asset == null) | ||
198 | return false; | ||
199 | |||
200 | if ((int)(asset.Flags & AssetFlags.Maptile) != 0) | ||
201 | { | ||
202 | return m_Database.Delete(id); | ||
203 | } | ||
204 | else | ||
205 | { | ||
206 | m_log.DebugFormat("[XASSET SERVICE]: Request to delete asset {0}, but flags are not Maptile", id); | ||
207 | } | ||
208 | |||
209 | return false; | ||
210 | } | ||
211 | } | ||
212 | } | ||
213 | |||