aboutsummaryrefslogtreecommitdiffstatshomepage
path: root/OpenSim/Data (unfollow)
Commit message (Collapse)AuthorFilesLines
2014-08-22Remove database connection locking in MySQLXAssetData. This is unnecessary ↵Justin Clark-Casey (justincc)1-186/+168
as connections aren't shared and transactions are already in place where necessary.
2014-08-22Remove query locking in MySQLUserProfileData. This is not necessary as the ↵Justin Clark-Casey (justincc)1-20/+8
connection is not shared.
2014-08-22Remove some use of database connection locking from MySQLSimulationData - ↵Justin Clark-Casey (justincc)1-318/+298
this has not been necessary for some time as database connections are not shared. However, many locks remain since they may effectively be providing transactionality in some operations (e.g. prim updates across multiple tables). These are candidates for being replaced with proper database transactions, since this would not block unrelated operations (e.g. land save and object save) or unrelated operations on the same tables (e.g. storage of one linkset whilst another is being removed). In practice, any performance deg due to contention is probably rare and short lived as the major prim operations are performed in memory and only persisted some time afterwards.
2014-08-22Remove lock in MySQLFramework. This is not necessary as the connection is ↵Justin Clark-Casey (justincc)1-21/+12
not shared.
2014-08-22Removing locking on requests in MySQLAssetData.Justin Clark-Casey (justincc)1-161/+144
These locks are not necessary since the connection is taken from the underlying mysql pool and not shared. Such locking is already not done by some other parts of OpenSim.Data.MySQL. Pointed out by arribasim-dev
2014-07-21Add missing parts to profiles - classified deleteBlueWall1-7/+3
2014-07-20Add code to GridService to check for overlapping of varregionsRobert Adams1-2/+2
when registering a new region. Adds parameter "[GridService]SuppressVarRegionOverlapCheckOnRegistration=false" that can be turned on to suppress the error check if a simulator's database has old regions that overlap.
2014-07-17fix all instances of "non-existant" to "non-existent" (spelling mistakes) ↵Michael Cerquoni1-2/+2
thanks Ai Austin for pointing this out.
2014-06-17Change assembly versions to 0.8.1Justin Clark-Casey (justincc)6-6/+6
2014-05-31Fix a bug where estate not found would result in a dummy estate record with ↵Diva Canto1-2/+9
erroneous information. Also, added conversion of EstateSettings from/to key-value pairs in preparation for robust net work connectors.
2014-05-30Moved these two estate-related interfaces to the projects where they belong.Diva Canto1-0/+120
2014-05-27Change Assembly verson of OpenSim.Data.PGSQL.dll to 0.8.0.* to match all ↵Justin Clark-Casey (justincc)1-1/+1
other assembly versions
2014-05-15minor: eliminate now unnecessary string.Format in postgresql RetrieveGroups ↵Justin Clark-Casey (justincc)1-1/+1
method
2014-05-15Escape find string in PgSQL core groups pluginJustin Clark-Casey (justincc)2-3/+25
2014-05-15Escape find string in MySQL core groups pluginJustin Clark-Casey (justincc)1-1/+1
2014-04-24When sending JSON-RPC calls (for UserProfile), use WebUtil instead of ↵Oren Hurvitz2-11/+0
constructing the HTTP requests manually. This allows the calls to be logged when using "debug http all 6".
2014-04-23Eliminated many warningsOren Hurvitz7-9/+8
2014-04-23Changed table 'im_offline' to use UTF8 characters. This fixes a problem with ↵Oren Hurvitz1-1/+9
Offline IM V2 (only relevant to MySQL). This fixes http://opensimulator.org/mantis/view.php?id=7123 Users that use MySQL should change their MySQL configuration to support UTF8. In the config file /etc/my.cnf (Linux) or my.ini (Windows), add these settings: [mysqld] character-set-server=utf8 [client] default-character-set=utf8 And then restart MySQL (on Linux: "sudo service mysqld restart").
2014-04-22Changed the maximum asset name and description lengths to constants. Also, ↵Oren Hurvitz5-20/+20
pre-truncate the description of dynamic textures.
2014-04-21Better logging in PresenceService, to help diagnose presence problems.Oren Hurvitz2-4/+20
2014-04-11Fix the presence info caching used in llRequestAgentData(), which was ↵Justin Clark-Casey (justincc)1-1/+1
completely inoperative. This means the presence info may be out of date by up to 20 seconds, but this avoids scripts potentially triggering constants requests to user accout and presence info services. Relates to http://opensimulator.org/mantis/view.php?id=7088 though I fixed in a different way. Adds regression test for this case.
2014-04-02Fixed AssetsExist in SQLiteOren Hurvitz1-2/+2
2014-04-02Made the SQLite unit tests work on Windows (sqlite3.dll wasn't being loaded)Oren Hurvitz1-0/+3
2014-04-02Added assets service method AssetsExist(), which returns whether the given ↵Oren Hurvitz10-83/+166
list of assets exist. This method is used to optimize sending assets with embedded assets: e.g., when a Hypergrid visitor takes an item into the inventory.
2014-03-26Fix MSSQLInventoryHandler.IncreementFolderVersion where sql accidentally ↵Justin Clark-Casey (justincc)1-1/+1
used a MySQL style ?folderID insted of @folderID Thanks to LuciusSirnah in http://opensimulator.org/mantis/view.php?id=7075 for this fix
2014-03-26minor: remove compiler warning from NullEstateDataJustin Clark-Casey (justincc)1-1/+1
2014-03-26Add MSSQL EstateStore.migrations VERSION 10 transaction to add ↵Justin Clark-Casey (justincc)1-0/+8
AllowLandMark, AllowParcelChanges and AllowSetHome columns to estate_settings table. Taken from http://opensimulator.org/mantis/view.php?id=7074 by LuciusSirnah. Thanks!
2014-03-26Fix extra physics params MSSQL migration (version 39).Justin Clark-Casey (justincc)1-5/+5
This was failing because it used MySQL syntax This is taken from Lucius Sirnah's entry in http://opensimulator.org/mantis/view.php?id=6593 But with the column existence checking removed, as this should not be necessary in a migration and is inconsistent with all other migrations, though I can see a case for doing it.
2014-03-24Fixed updating usersettings in the databaseOren Hurvitz1-2/+2
Resolves http://opensimulator.org/mantis/view.php?id=6938
2014-03-24Don't show hidden groups in search resultsOren Hurvitz1-3/+3
Resolves http://opensimulator.org/mantis/view.php?id=6937
2014-03-18Fix a bug in previous commit 01520bb where I accidentally saved ↵Justin Clark-Casey (justincc)1-1/+1
OtherCleanTime instead of Dwell
2014-03-18Save and load dwell parcel stat in MySQL DB adaptor. Field in table already ↵Justin Clark-Casey (justincc)1-3/+4
exists! The SQLite database adaptor was loading and saving dwell whilst MySQL was not, even though the field already exists in the db table.
2014-03-07Add regression test for sending group notices via xmlrpc groups connector.Justin Clark-Casey (justincc)2-25/+68
2014-01-28Repair database routines so they properly return null when asked forRobert Adams5-4/+21
the heighmap of a region that does not exist.
2014-01-16In the offline message table, store the sender.Oren Hurvitz2-2/+13
This data is useful for preventing abuse (e.g., someone who sends too many messages), or for deleting message if their sender has been deleted.
2013-12-16Fix issue with editing notes for other avatarsBlueWall1-0/+4
2013-12-16Populate user preferences with UserAccount email if it is present, else ↵BlueWall2-7/+12
return an error indicating no email is on record for the user.
2013-12-14varregion: rename 'LegacyRegionLocX' back to 'RegionLocX' and same for Y and Z.Robert Adams1-4/+4
Rename 'RegionWorldLocX' to 'WorldLocX' and same for Y and Z. This keeps the downward compatibility and follows the scheme of 'region' and 'world' location naming that is happening in the Util module.
2013-12-06Add support for user preferences (im via email)BlueWall7-36/+148
2013-12-05Adding profile partners fix to SQLite and PgSQL driversBlueWall2-4/+0
2013-12-05Stop writing partner id to record when updating profile data. This should be ↵BlueWall1-2/+0
changed only by admin in backend.
2013-12-06Reversing back to the row["ColumnName"] case field name. ↵Fernando Oliveira1-1/+1
http://opensimulator.org/mantis/view.php?id=6868
2013-11-25Corrected case to get columns from Regions table from PostgreSQL ↵Fernando Oliveira1-2/+2
http://opensimulator.org/mantis/view.php?id=6865 Signed-off-by: Michael Cerquoni <nebadon2025@gmail.com>
2013-11-22Fixed the update StoreRegionWindlightSettings() wasn't updating ↵Fernando Oliveira1-4/+5
regionwindlight table, raising PrimaryKey violation; Signed-off-by: Fernando Oliveira <fernando@oliveira.eti.br> Signed-off-by: Michael Cerquoni <nebadon2025@gmail.com>
2013-11-08varregion: elimination of Constants.RegionSize from all over OpenSimulator.Robert Adams1-2/+2
Routines in Util to compute region world coordinates from region coordinates as well as the conversion to and from region handles. These routines have replaced a lot of math scattered throughout the simulator. Should be no functional changes.
2013-11-04varregion: remove unused terrain serialization code in SQLite and PGSQL modulesRobert Adams2-40/+0
2013-11-01varregion: push TerrainData implementation up and down the database storage ↵Robert Adams5-95/+97
stack. Implement both LoadTerrain and StoreTerrain for all DBs. Move all database blob serialization/deserialization into TerrainData.
2013-10-16Corrected estateID to EstateID on getEstates function at PGSQLEstateData.csFernando Oliveira1-1/+1
2013-10-16* One More thing, add an appdomain data element to ensure that we don't ↵Fernando Oliveira2-4/+15
duplicate the assembly resolving.
2013-10-16* Fixes mantis mantis 0006803 [PGSQL] - Simulator crashes - ↵Fernando Oliveira2-0/+47
Mono.Security.dll missing. The root of the issue is that the Postgres driver relies on Mono.Security.dll from the mono project. Unfortunately, when using Mono, including the dll in the distribution causes conflicts. This solution puts Mono.Security.dll in bin/lib/NET/ and, if windows .NET is the runtime, informs the assembly loader to load bin/lib/NET/Mono.Security.dll when .NET is scanning for the Mono.Security namespace. On Mono, the included Mono.Security assembly is ignored.
generated by cgit v1.1 at 2024-12-22 16:24:21 +0000