aboutsummaryrefslogtreecommitdiffstatshomepage
path: root/OpenSim/Data/MySQL (follow)
Commit message (Collapse)AuthorAgeFilesLines
* Committing the incomplete table handler to get it into the tree. No userMelanie2009-11-151-0/+200
| | | | functionality yet
* Changing the AssetBase constructors to avoid initializing assets with an ↵John Hurliman2009-11-051-4/+1
| | | | unknown asset type, and log an error if it ever does happen
* Removing Console.WriteLine()s that were brought in with the revertJohn Hurliman2009-11-021-2/+0
|
* Removing duplicate SceneObjectPart.RotationalVelocity propertyJohn Hurliman2009-11-021-4/+4
|
* Reverting the memory leak patch for MySQL. Problems have been reported with ↵John Hurliman2009-11-0210-834/+860
| | | | the grid server after running for several hours
* * Tweak to region module loading to check for a matching constructor first ↵John Hurliman2009-10-271-14/+18
| | | | | | | instead of throwing and catching exceptions * Commenting out the MySQL startup sequence that cleans out dropped attachments under the advice that it is no longer relevant. If anything, it could be brought back as a database cleanup console command * Updated to the latest libomv 0.8.0-pre. UUID.TryParse() will no longer throw and catch exceptions for most failed UUID parses
* Changing Scene.ForEachClient to use the synchronous for loop instead of ↵John Hurliman2009-10-252-30/+26
| | | | | | | | | | Parallel. This is quite possibly the source of some deadlocking, and at the very least the synchronous version gives better stack traces * Lock the LLUDPClient RTO math * Add a helper function for backing off the RTO, and follow the optional advice in RFC 2988 to clear existing SRTT and RTTVAR values during a backoff * Removing the unused PrimitiveBaseShape.SculptImage parameter * Improved performance of SceneObjectPart instantiation * ZeroMesher now drops SculptData bytes like Meshmerizer, to allow the texture data to be GCed * Improved typecasting speed in MySQLLegacyRegionData.BuildShape() * Improved the instantiation of PrimitiveBaseShape
* * Big performance increase in loading prims from the region database with MySQLJohn Hurliman2009-10-181-133/+138
| | | | | | * Handle the AgentFOV packet * Bypass queuing and throttles for ping checks to make ping times more closely match network latency * Only track reliable bytes in LLUDPCLient.BytesSinceLastACK
* * Changing the "clean dropped attachments" MySQL command to a using ↵John Hurliman2009-10-161-6/+14
| | | | | | statement inside a try/catch. This statement times out for me very frequently * More verbose logging when zerocoding fails on an outbound packet
* * Change appearance packets from State to Task. This will hopefully fix the ↵John Hurliman2009-10-161-0/+5
| | | | | | cloud issues * Changed the throttling logic to obey the requested client bandwidth limit but also share bandwidth between some of the categories to improve throughput on high prim or heavily trafficked regions
* * Replaced (possibly broken?) math for calculating the unix timestamp in ↵John Hurliman2009-10-141-5/+5
| | | | | | | MySQLAssetData with Utils.DateTimeToUnixTime() * Disabled UpdateAccessTime() function since it was only writing zeros anyways. This gave me a significant performance improvement for startup times and avatar logins in standalone mode * Load attachments asynchronously so avatars with lots of attachments don't have to race the timeout clock to login
* Stop null values from being returned on database queriesMelanie2009-10-121-1/+4
|
* Reverting MySQLLegacyRegionData spamJohn Hurliman2009-10-061-6/+0
|
* MySQLLegacyRegionData: Extreme Spam Edition(tm)John Hurliman2009-10-061-0/+6
|
* Merge branch 'master' of ssh://opensimulator.org/var/git/opensim into ↵John Hurliman2009-10-064-75/+77
|\ | | | | | | htb-throttle
| * Remove the using() constructs from the new style database modules; they causedMelanie2009-10-064-75/+77
| | | | | | | | | | | | | | | | the underlying connection of a reader or command to be closed before the reader or command itself. Added the proper logic to Close and dispose items in CloseDBConnection. Readers and Connections need Close(), Commands need Dispose(), in the order Reader, Command, Connection. Also reinstated 80-column-friendly formatting
* | * Continued work on the new LLUDP implementation. Appears to be functioning, ↵John Hurliman2009-10-061-4/+2
|/ | | | | | | | although not everything is reimplemented yet * Replaced logic in ThreadTracker with a call to System.Diagnostics that does the same thing * Added Util.StringToBytes256() and Util.StringToBytes1024() to clamp output at byte[256] and byte[1024], respectively * Fixed formatting for a MySQLAssetData error logging line
* Added CloseDBConnection() to replace the old CloseReaderCommand(). This will ↵John Hurliman2009-10-054-11/+21
| | | | close the MySQLConnection attached to a MySQLCommand. I'm not sure if this accounts for every time a database connection needs to be closed, but it matches up 1:1 with the places where the database connection was previously being closed
* * MySQL data tests now pass by fixing a bad fix for a bad cast on the asset ↵John Hurliman2009-10-0411-1213/+1111
| | | | | | Local member in MySQLAssetData * First pass at applying the using(){} pattern to IDisposable objects. Always use the using pattern on IDisposable objects whenever possible, do not manually call .Close() or .Dispose() unless there is no other way to write the code. This pass mostly covers OpenSim.Data.MySQL, and should have no functional change (tests still pass)
* - cleaning up LandData/ILandObject capitalization issuesdr scofield (aka dirk husemann)2009-10-021-3/+3
| | | | - adding LandDataSerializer to OAR mechanics
* Formatting cleanup.Jeff Ames2009-10-014-11/+11
|
* Add copyright header. Formatting cleanup.Jeff Ames2009-09-293-3/+3
|
* Make the RegionData plugin store the RegionNameMelanie2009-09-271-2/+3
|
* Prevent manually setting Data["locX"] and Data["locY"], since that wouldMelanie2009-09-271-0/+4
| | | | overwrite the posX and posY members of the structure
* Merge branch 'master' of ssh://melanie@opensimulator.org/var/git/opensimMelanie2009-09-272-8/+5
|\ | | | | | | | | Conflicts: OpenSim/Data/MySQL/MySQLRegionData.cs
| * minor: remove some mono compiler warningsJustin Clark-Casey (justincc)2009-09-252-2/+2
| |
| * All tests pass for MySQL/MySQLRegionData.Diva Canto2009-09-241-12/+3
| | | | | | | | Added OpenSim.GridServer.ini.example that I have been using for testing the ROBUST grid service with the GridClient.
* | Add the Migration for the regions tableMelanie2009-09-272-8/+20
|/
* Add the migration for scoping grid dataMelanie2009-09-161-0/+7
|
* Adding the MySQL RegionData service.Melanie2009-09-162-1471/+1738
|
* Revising the user account data interfaces. No user functionality yetMelanie2009-09-062-0/+185
|
* Add the new AuthStore to migrations. Update OpenSim.Server.iniMelanie2009-09-042-0/+24
|
* Fully implement unencrypted auth token operationsMelanie2009-09-041-0/+52
|
* More work on new authentication serviceMelanie2009-09-042-12/+31
|
* Add the user authentication data adapter. This is meant to use a new tableMelanie2009-09-042-0/+261
| | | | | | schema, but can read the old ones for compatibility. It should not be used to write to the old tables unless you know what you're doing! This is untested and will probably not work.
* Thank you, dslake, for a set of patches to improve OpenSim startupMelanie2009-09-021-9/+40
| | | | and idle performance.
* Fix issue where conversion of temporary boolean variable fails on MySQLArthur Valadares2009-08-211-2/+2
|
* Fixing a spot I missed in assets. Switching Grid to the new naming schema ↵Kunnis2009-08-191-12/+1
| | | | with Store/Get
* * Switching IAssetData to follow the new naming schema, removing the ↵Kunnis2009-08-191-11/+2
| | | | separate insert and update methods.
* Add copyright headers. Formatting cleanup. Fix a compiler warning.Jeff Ames2009-08-171-1/+1
|
* * Fixed MySQL/MySQLAssetData.cs to properly do updates * Removed an extra ↵Kunnis2009-08-162-9/+2
| | | | parameter from MySQL/MySQLInventoryData.cs * Fixed a bug in SQLite/SQLiteAssetData.cs that was causing a NRE when updating an asset. * Improved the BasicAssetTest.cs to do full create/update/get testing * Improved the BasicInventoryTest.cs to do full create/update/get of both a folder and an item * Moved the null ref tests to the start of the PropertyCompareConstraint.cs, so that it doesn't throw when passing in a null item
* Adding in Reflection-based testing, to ensure that all properties are covered.Kunnis2009-08-165-15/+34
|
* * Remove hard coded 256 limitations from various places. There's no more ↵Teravus Ovares (Dan Olivares)2009-08-071-6/+6
| | | | 256m limitation within the OpenSimulator framework, however, the LLClient ClientView does not support regions larger then 256 meters so, if you try and make your region larger by setting Constants.RegionSize = 512; in OpenSim.Framework.Constants.cs, the terrain will not display on clients using the LLUDP protocol
* * Updates libOMV to version 0.7.0Teravus Ovares2009-07-251-2/+2
| | | | | | | | * Uses mantis #3811 as a base (thanks jhuliman) with changes. * E-mail regarding interface changes sent to the opensim-dev list * Archive: https://lists.berlios.de/pipermail/opensim-dev/2009-July/007219.html
* * Apply asset and inventory name and description bound checks to MySQLJustin Clarke Casey2009-07-242-5/+40
|
* From: Chris Yeoh <yeohc@au1.ibm.com>Sean Dague2009-06-301-1/+1
| | | | | | | Ooops, sorry there was a bug in the patch and causes an exception on some system (I think it only happens on windows since it didn't occur during my testin). I've attached a one liner which fixes the problem.
* From: Chris Yeoh <yeohc@au1.ibm.com>Sean Dague2009-06-292-13/+11
| | | | | | | | Attached is a patch that changes the oar file saving of creation date/time to an integer instead of a string. I did this after justincc emailed me saying there is a problem with internationalisation doing it the old way and I said I'd fix it. Its been tested with MySQL and I've made the changes for MSSQL but that hasn't been well tested.
* From: Chris Yeoh <yeohc@au1.ibm.com>Dr Scofield2009-06-032-2/+31
| | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | This patch adds oar file date and time (UTC) meta data to an oar file when it is created. It also adds a unique ID, though this id does not in anyway identify the machine that the oar file was created on. When an oar file with this meta data is loaded this extra information is saved with the region settings and available via LSL through: - osLoadedCreationDate() - osLoadedCreationTime() - osLoadedCreationID() If there is no meta data these fields will be blank. Subsequent oar file loads will erase the information for the previous oar file load. Persistence has only been implemented for MySQL, the other backends need updating. Overall this allows us to much more easily identify the specific version of software that clients are using. Its very straightforward to edit the oar file to change the ID string to be something more human friendly. Included in the patch is a new file OpenSim/Data/MySQL/Resources/030_RegionStore.sql required for the MySQL DB migration. btw I had a chat with justincc about this a few weeks ago since he wrote the oar file import/export and he sounded happy to accept something that included date/time information but didn't want anything that would silently leak private information like machine names.
* Minor: Change OpenSim to OpenSimulator in older copyright headers and ↵Jeff Ames2009-06-0115-15/+15
| | | | LICENSE.txt.
* From: Chris Yeoh <cyeoh@au1.ibm.com>Dr Scofield2009-05-272-2/+17
| | | | | | | | | | | | The attached patch implements llPassTouches. It has been added to the export/import XML along with the flag for AllowedInventoryDrop. The MySQL backend has been updated as well, though I haven't done one of those before so could do with a check. I added the migration mysql file as well. The other data backends need updating as well.