aboutsummaryrefslogtreecommitdiffstatshomepage
path: root/OpenSim/Data/MySQL/MySQLLegacyRegionData.cs (unfollow)
Commit message (Collapse)AuthorFilesLines
2010-08-13refactor: Use SOP.Flags rather than SOP.ObjectFlagsJustin Clark-Casey (justincc)1-2/+2
2010-08-04fix mysql/mssql prim serialization problemJustin Clark-Casey (justincc)1-6/+2
2010-08-03Implement MediaUrl persistence for MySQL and MsSQLJustin Clark-Casey (justincc)1-2/+8
Not sure how I forgot this. This may resolve problems with media textures not persisting over restart for these databases.
2010-08-03get rid of PrimitiveBaseShape.MediaRaw staging postJustin Clark-Casey (justincc)1-3/+5
using an OSD serialization rather than auto forces serialization code to be placed in OpenSim.Framework this makes the media texture raw data staging post in PrimitiveBaseShape redundant, now we just directly call the code in PrimitiveBaseShape.MediaList itself
2010-07-26add mysql support for media on a primJustin Clark-Casey (justincc)1-2/+6
2010-07-26add mysql support for media on a primJustin Clark-Casey (justincc)1-2/+6
2010-05-19All (?) MySQL stores fixed to use DBGuid.FromDB()AlexRa1-42/+40
This was needed if we want to update to the latest MySQL connector dll. It automatically converts CHAR(36) to Guids, so getting them as strings no longer works. By using DBGuid.FromDB(), we unlink from any particular storage format of GUIDs, could even make them BINARY(16) if we like. Actually not all MySql units are touched, but the remaining ones don't seem to be affected (they don't read GUIDs from DB)
2010-05-09OK, this really fixes it, I promise.Diva Canto1-2/+2
2010-05-09Yey for unit tests. The previous commit had a couple of bugs on SQL ↵Diva Canto1-2/+2
statements. Fixed here.
2010-05-09* Fixed spamming the assets table with map tiles. The tile image ID is now ↵Diva Canto1-1/+5
stored in regionsettings. Upon generation of a new tile image, the old one is deleted. Tested for SQLite and MySql standalone. * Fixed small bug with map search where the local sim regions weren't found.
2010-03-31Committing the LightShare code, which was developed by TomMeta of Meta7.Melanie1-0/+199
This allows scripts to set WindLight parameters for clients connecting to a region. Currently, this is only supported by the Meta7 viewer.
2010-02-05Updated MySQL connection management to use the MySQL connection pooling. ↵Master ScienceSim1-443/+481
This should accommodate various timeout problems that exist with the current connection pool code in a more general and standard way.
2009-12-11Refix the fixMelanie1-1/+1
2009-12-11Kill a NRE caused by an error message trying to print unavailable datagrid1-2/+2
2009-12-02Log old position and region information when an orphaned child prim is foundJustin Clark-Casey (justincc)1-1/+3
2009-11-02Removing duplicate SceneObjectPart.RotationalVelocity propertyJohn Hurliman1-4/+4
2009-10-27* Tweak to region module loading to check for a matching constructor first ↵John Hurliman1-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
2009-10-25Changing Scene.ForEachClient to use the synchronous for loop instead of ↵John Hurliman1-27/+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
2009-10-18* Big performance increase in loading prims from the region database with MySQLJohn Hurliman1-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
2009-10-16* Changing the "clean dropped attachments" MySQL command to a using ↵John Hurliman1-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
2009-10-16* Change appearance packets from State to Task. This will hopefully fix the ↵John Hurliman1-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
2009-10-06Reverting MySQLLegacyRegionData spamJohn Hurliman1-6/+0
2009-10-06MySQLLegacyRegionData: Extreme Spam Edition(tm)John Hurliman1-0/+6
2009-10-04* MySQL data tests now pass by fixing a bad fix for a bad cast on the asset ↵John Hurliman1-297/+234
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)
2009-10-02- cleaning up LandData/ILandObject capitalization issuesdr scofield (aka dirk husemann)1-3/+3
- adding LandDataSerializer to OAR mechanics
2009-10-01Formatting cleanup.Jeff Ames1-2/+2
2009-09-29Add copyright header. Formatting cleanup.Jeff Ames1-1/+1
2009-09-16Adding the MySQL RegionData service.Melanie1-0/+0
2009-09-02Thank you, dslake, for a set of patches to improve OpenSim startupMelanie1-9/+40
and idle performance.
2009-08-16Adding in Reflection-based testing, to ensure that all properties are covered.Kunnis1-7/+10
2009-08-07* Remove hard coded 256 limitations from various places. There's no more ↵Teravus Ovares (Dan Olivares)1-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
2009-07-25* Updates libOMV to version 0.7.0Teravus Ovares1-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
2009-06-30From: Chris Yeoh <yeohc@au1.ibm.com>Sean Dague1-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.
2009-06-29From: Chris Yeoh <yeohc@au1.ibm.com>Sean Dague1-13/+4
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.
2009-06-03From: Chris Yeoh <yeohc@au1.ibm.com>Dr Scofield1-2/+24
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.
2009-06-01Minor: Change OpenSim to OpenSimulator in older copyright headers and ↵Jeff Ames1-1/+1
LICENSE.txt.
2009-05-27From: Chris Yeoh <cyeoh@au1.ibm.com>Dr Scofield1-2/+12
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.
2009-05-25Revert "From: Chris Yeoh <cyeoh@au1.ibm.com>"Dr Scofield1-12/+2
This reverts r9666. for some reason the mysql update does not work.
2009-05-25From: Chris Yeoh <cyeoh@au1.ibm.com>Dr Scofield1-2/+12
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.
2009-05-07* Consistently used dashed uuid format for mysql region data, as is done for ↵Justin Clarke Casey1-29/+26
all other tables * This revision contains a mysql data migration. Please backup your mysql region database as a precaution before using this code. * I also advise that you do a runprebuild[.sh|.bat] and a clean build ("nant clean build" if you're using the command line). * This change is needed for future id schemes
2009-02-25* Refactored SOP.FolderID weirdness by removing calls to empty setter. YEs, ↵lbsa711-4/+0
I do realize the setter has to be there for legacy reasons, but since the calls will never acually DO anyhting, I'm removing them. * So, SOP.FolderID is actually a cruft field that should be removed.
2009-02-12* optimized usings.lbsa711-4/+4
2009-02-06This changeset is the step 1 of 2 in refactoringDr Scofield1-2/+2
OpenSim.Region.Environment into a "framework" part and a modules only part. This first changeset refactors OpenSim.Region.Environment.Scenes, OpenSim.Region.Environment.Interfaces, and OpenSim.Region.Interfaces into OpenSim.Region.Framework.{Interfaces,Scenes} leaving only region modules in OpenSim.Region.Environment. The next step will be to move region modules up from OpenSim.Region.Environment.Modules to OpenSim.Region.CoreModules and then sort out which modules are really core modules and which should move out to forge. I've been very careful to NOT BREAK anything. i hope i've succeeded. as this is the work of a whole week i hope i managed to keep track with the applied patches of the last week --- could any of you that did check in stuff have a look at whether it survived? thx!
2009-01-29* If an orphaned group is found in the mysql or mssql databases (i.e. there ↵Justin Clarke Casey1-1/+15
is no prim where UUID = SceneGroupID), then force one prim to have UUID = SceneGroupID. * A warning is posted about this on startup giving the location of the object * This should allow one class of persistently undeletable prims to be removed * This change should not cause any issues, but I still suggest that you backup your database beforehand * If this doesn't work for previously linked objects, then you could also try the workaround in http://opensimulator.org/mantis/view.php?id=3059 * This change has been made to mysql and mssql, but sqlite appears to work in a different way
2008-12-23* Fix http://opensimulator.org/mantis/view.php?id=2889Justin Clarke Casey1-2/+2
* Primshapes uuid wasn't being converted to raw (non-dashed) format before being used in primshapes delete command
2008-12-08change a UUID cast to an actual new UUID call to be consistant withSean Dague1-1/+1
the rest of the assignments here.
2008-12-08fix an issue I found where primshapes weren't every being removedSean Dague1-9/+82
because of a logic error. attempt to speed up deletes a bit by batching up all the primitem deletes and primshape deletes into single delete statements. This removes the lock/release/lock/release/lock/release for loop.
2008-12-02* Resolve http://opensimulator.org/mantis/view.php?id=2743 and ↵Justin Clarke Casey1-5/+3
http://opensimulator.org/mantis/view.php?id=2739 by no longer bothering to store or retrieve the local parentID in the region database * The original issue is that the now randomly generated local ids do not fit into the int parentID datatype * However, as far as I know it's actually pointless to store this local parent ID anyway (we already store the groupUUID), especially as we don't bother to store the localID (as opposed to UUID itself). * Conservatively, the actual column will be removed in a later commit
2008-12-02Catch all possible exceptions in the mysql module. It throws non-mysqlMelanie Thielker1-2/+2
exceptions as well.
2008-12-01Fix the terrain loaderMelanie Thielker1-1/+1