aboutsummaryrefslogtreecommitdiffstatshomepage
path: root/OpenSim/Data/MySQL (follow)
Commit message (Collapse)AuthorAgeFilesLines
* Fix logging level to Error in exception handlersBlueWall2014-10-151-18/+18
|
* Remove database connection locking in MySQLXAssetData. This is unnecessary ↵Justin Clark-Casey (justincc)2014-08-221-186/+168
| | | | as connections aren't shared and transactions are already in place where necessary.
* Remove query locking in MySQLUserProfileData. This is not necessary as the ↵Justin Clark-Casey (justincc)2014-08-221-20/+8
| | | | connection is not shared.
* Remove some use of database connection locking from MySQLSimulationData - ↵Justin Clark-Casey (justincc)2014-08-221-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.
* Remove lock in MySQLFramework. This is not necessary as the connection is ↵Justin Clark-Casey (justincc)2014-08-221-21/+12
| | | | not shared.
* Removing locking on requests in MySQLAssetData.Justin Clark-Casey (justincc)2014-08-221-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
* Add missing parts to profiles - classified deleteBlueWall2014-07-211-7/+3
|
* Change assembly versions to 0.8.1Justin Clark-Casey (justincc)2014-06-171-1/+1
|
* Fix a bug where estate not found would result in a dummy estate record with ↵Diva Canto2014-05-311-2/+9
| | | | | | erroneous information. Also, added conversion of EstateSettings from/to key-value pairs in preparation for robust net work connectors.
* Escape find string in MySQL core groups pluginJustin Clark-Casey (justincc)2014-05-151-1/+1
|
* When sending JSON-RPC calls (for UserProfile), use WebUtil instead of ↵Oren Hurvitz2014-04-241-5/+0
| | | | constructing the HTTP requests manually. This allows the calls to be logged when using "debug http all 6".
* Eliminated many warningsOren Hurvitz2014-04-232-2/+2
|
* Changed table 'im_offline' to use UTF8 characters. This fixes a problem with ↵Oren Hurvitz2014-04-231-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").
* Changed the maximum asset name and description lengths to constants. Also, ↵Oren Hurvitz2014-04-222-8/+8
| | | | pre-truncate the description of dynamic textures.
* Better logging in PresenceService, to help diagnose presence problems.Oren Hurvitz2014-04-211-1/+9
|
* Added assets service method AssetsExist(), which returns whether the given ↵Oren Hurvitz2014-04-022-43/+39
| | | | | | 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.
* Fixed updating usersettings in the databaseOren Hurvitz2014-03-241-2/+2
| | | | Resolves http://opensimulator.org/mantis/view.php?id=6938
* Don't show hidden groups in search resultsOren Hurvitz2014-03-241-3/+3
| | | | Resolves http://opensimulator.org/mantis/view.php?id=6937
* Fix a bug in previous commit 01520bb where I accidentally saved ↵Justin Clark-Casey (justincc)2014-03-181-1/+1
| | | | OtherCleanTime instead of Dwell
* Save and load dwell parcel stat in MySQL DB adaptor. Field in table already ↵Justin Clark-Casey (justincc)2014-03-181-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.
* Repair database routines so they properly return null when asked forRobert Adams2014-01-281-1/+5
| | | | the heighmap of a region that does not exist.
* Merge branch 'master' into varregionRobert Adams2014-01-191-1/+11
|\
| * Merge branch 'justincc-master'Justin Clark-Casey (justincc)2014-01-161-1/+11
| |\
| | * In the offline message table, store the sender.Oren Hurvitz2014-01-161-1/+11
| | | | | | | | | | | | 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.
* | | Merge branch 'master' into varregionRobert Adams2013-12-172-27/+42
|\ \ \ | |/ / | | | | | | | | | | | | | | | | | | Add new region crossing code to varregion Conflicts: OpenSim/Region/CoreModules/Framework/EntityTransfer/EntityTransferModule.cs OpenSim/Region/Framework/Scenes/ScenePresence.cs
| * | Fix issue with editing notes for other avatarsBlueWall2013-12-161-0/+4
| | |
| * | Populate user preferences with UserAccount email if it is present, else ↵BlueWall2013-12-161-6/+10
| |/ | | | | | | return an error indicating no email is on record for the user.
| * Add support for user preferences (im via email)BlueWall2013-12-062-21/+28
| |
* | Merge branch 'master' into varregionRobert Adams2013-12-051-2/+0
|\ \ | |/
| * Stop writing partner id to record when updating profile data. This should be ↵BlueWall2013-12-051-2/+0
| | | | | | | | changed only by admin in backend.
* | varregion: push TerrainData implementation up and down the database storage ↵Robert Adams2013-11-011-21/+11
| | | | | | | | | | | | | | stack. Implement both LoadTerrain and StoreTerrain for all DBs. Move all database blob serialization/deserialization into TerrainData.
* | Merge branch 'master' into varregionRobert Adams2013-10-071-1/+1
|\ \ | |/
| * Bump OPenSimulator version and assembly versions up to 0.8.0 DevJustin Clark-Casey (justincc)2013-10-041-1/+1
| |
* | varregion: plug in TerrainData class and modify TerrainModule and ↵Robert Adams2013-10-071-30/+17
| | | | | | | | LLClientView to use same. This passes a terrain info class around rather than passing a one dimensional array thus allowing variable regions. Update the database storage for variable region sizes. This should be downward compatible (same format for 256x256 regions).
* | Remove time based terrain storage in SQLite so revision number can be usedRobert Adams2013-09-281-3/+4
|/ | | | | | | to denote terrain format revision. Add terrain DB format revision codes to ISimulationDataStore.cs. Setup so legacy compatible terrain storage and fetch is possible while allowing future format extensions.
* Preserve attachment point & position when attachment is rezzed in worldAleric Inglewood2013-09-222-5/+34
| | | | | | | | | | Patch taken from http://opensimulator.org/mantis/view.php?id=4905 originally by Greg C. Fixed to apply to r/23314 commit ba9daf849e7c8db48e7c03e7cdedb77776b2052f (cherry picked from commit 4ff9fbca441110cc2b93edc7286e0e9339e61cbe)
* Allow one to specify a DefaultHGRegion flag in [GridService] in order to ↵Justin Clark-Casey (justincc)2013-09-021-0/+5
| | | | | | | | | | allow different default regions for HG and direct grid logins. This requires a new GridService.GetDefaultHypergridRegions() so ROBUST services require updating but not simulators. This method still returns regions flagged with just DefaultRegion after any DefaultHGRegions, so if no DefaultHGRegions are specified then existing configured defaults will still work. Immediate use is for conference where we need to be able to specify different defaults However, this is also generally useful to send experienced HG users to one default location and local users whose specified region fails (e.g. no "home" or "last") to another.
* This makes group search work (Groups V2).Diva Canto2013-07-281-1/+1
|
* Cleanup old hg sessions (older than 2 days)Diva Canto2013-07-142-0/+11
|
* HG UAS: Moved hg-session data from memory to DB storage. This makes it so ↵Diva Canto2013-07-142-0/+87
| | | | that traveling info survives Robust resets. It should also eliminate the cause of empty IP addresses in agent circuit data that we saw in CC grid. MySQL only.
* HG Friends: migration #3 is failing on some installations of MySql. Setting ↵Diva Canto2013-07-041-1/+1
| | | | the table to InnoDB seems to fix the problem.
* Fix SQL statementDiva Canto2013-07-021-1/+1
|
* Really make it call the method with the query interfaceDiva Canto2013-07-021-1/+1
|
* This should have a strong effect on the Unknown User issue mantis #6625Diva Canto2013-07-021-2/+5
|
* In XAssetService, on a delete asset request also delete the asset in any ↵Justin Clark-Casey (justincc)2013-06-281-0/+2
| | | | | | chained service. This eliminates the async migration since it causes a race condition with the "delete asset" console command
* Make the concept of namespaces explicit in dynamic attributesJustin Clark-Casey (justincc)2013-06-271-1/+1
| | | | | | | | This is in order to reduce the likelihood of naming clashes, make it easier to filter in/out attributes, ensure uniformity, etc. All dynattrs in the opensim distro itself or likely future ones should be in the "OpenSim" namespace. This does alter the underlying dynattrs data structure. All data in previous structures may not be available, though old structures should not cause errors. This is done without notice since this feature has been explicitly labelled as experimental, subject to change and has not been in a release. However, existing materials data is being preserved by moving it to the "Materials" store in the "OpenSim" namespace.
* * This fixes having to select and deselect prim to get keyframemotion to ↵teravus2013-06-121-2/+0
| | | | start running when pulled from data storage.
* Database persistence for keyframes. Contains a Migration.Melanie2013-06-062-4/+32
|
* Adding standard OpenSim header to source filesBlueWall2013-05-311-0/+27
|
* Fill in fields with default values on profile creationBlueWall2013-05-311-2/+48
|