aboutsummaryrefslogtreecommitdiffstatshomepage
path: root/OpenSim/Data/MySQL (follow)
Commit message (Collapse)AuthorAgeFilesLines
...
* Megapatch that fixes/adds: friend offer/deny/accept, friendship termination,Homer Horwitz2008-11-011-0/+43
| | | | | | | | | | | | | | on-/offline updates, calling cards for friends. This adds methods in the DB layer and changes the MessagingServer, so a full update (incl. UGAIM) is necessary to get it working. Older regions shouldn't break, nor should older UGAIM break newer regions, but friends/presence will only work with all concerned parts (UGAIM, source region and destination region) at this revision (or later). I added the DB code for MSSQL, too, but couldn't test that. BEWARE: May contain bugs.
* Fix a compile warning about unreachable codeHomer Horwitz2008-11-011-2/+0
|
* A stab a getting the user server to act right. Move acquisition of theMelanie Thielker2008-11-012-18/+21
| | | | | | | | locks to just before the try/catch/finally block, so that an exception thrown between taking the lock and entering the try doesn't leave a mutex locked
* * Added some debug information to MySQL UserDataManager to help diagnose a ↵Adam Frisby2008-10-312-18/+25
| | | | potential issue when in high load. Related to mantis #2508.
* - Includes consistency test for new and updated objects, asSean Dague2008-10-301-3/+2
| | | | | | | some fixes in MySQL and SQLite From: Arthur Rodrigo S Valadares <arthursv@linux.vnet.ibm.com>
* Mid-work, trying to fix region part insertion and retrievalSean Dague2008-10-301-7/+29
| | | | | | | | SQLite reports System NUll Reference, but works, inside LoadItems, on SQLiteRegionData.cs From: Arthur Rodrigo S Valadares <arthursv@linux.vnet.ibm.com>
* Megapatch. :) Fix skull attachment editing. Streamline Object terse updates.Melanie Thielker2008-10-182-0/+13
| | | | | | | | Add rezzing time to objects. Add Object return and traffic fields to land database. Add plumbing for auto return. Implement auto return. Contains a migration. May contain nuts.
* - Enforced no user or agent with UUID 0 on agent DB insertionSean Dague2008-10-161-0/+4
|
* * minor: comment out persisting prim inventory log messagesJustin Clarke Casey2008-10-151-1/+1
|
* - Makes MySQL reject inserting UUID 0Sean Dague2008-10-151-0/+5
| | | | | | | | | | - Makes SQLite mimick MySQL default behavior on first and last name already on db: it does not insert the new record. - Added tests for UUID 0 and for new UUID with existing first and last name.
* Add the missing bits for the new region-search:Homer Horwitz2008-10-031-0/+46
| | | | | | | | | | | | | | | | - Added lookup in the data-layer - MySQL works - SQLite doesn't have a grid-db, so it won't work there - I added MSSQL-code to the best of my knowledge; but I don't know MSSQL :-) - Added the plumbing up to OGS1GridServices. This speaks with the grid-server via XMLRPC. - Modified MapSearchModule to use the new data. It's backward compatible; if used with an old grid-server, it just returns one found region instead of a list. - Refactored a bit. Note: This updates data, grid-server and region code. No new files.
* Add database persistence for material settingMelanie Thielker2008-10-032-0/+11
|
* add delete prim tests. Found and fixed bugs where regionSean Dague2008-10-011-2/+2
| | | | | | | | is not respected by sqlite or mysql drivers so that deleting and object in a region actually deletes that object from any region.
* Update svn properties. Minor formatting cleanup. Fix a compiler warning. ↵Jeff Ames2008-09-281-2/+2
| | | | Fix a UUID vs null comparison.
* * Patch from JHurlimanTeravus Ovares2008-09-261-3/+3
| | | | | | | | | * Updates to libomv r2243, * Remove lots of unnecessary typecasts * Improves SendWindData() Thanks jhurliman. * Will update OpenSim-libs in 10 minutes..
* removal of more dead alter table codeSean Dague2008-09-251-39/+2
|
* light mysql user testsSean Dague2008-09-241-0/+88
|
* expose it for real, missed the public keywordSean Dague2008-09-241-1/+1
|
* expose MySQLUserData class so that it can be testedSean Dague2008-09-241-1/+1
|
* remove configurable table names from the mysql user driver. ThatSean Dague2008-09-241-24/+3
| | | | | | | doesn't work in a world of migrations anyway, and is only cruft that will confuse people.
* Add persistence of active gestures. This needs an UGAIM update to work.Homer Horwitz2008-09-241-0/+36
| | | | | | | | | Active gestures are sent as part of the login-response. Added fetchActiveGestures to SQLite and MySQL; added an empty one for MSSQL and NHibernate. Using the empty ones won't cause errors, but doesn't provide persistence either, of course.
* light the mysql region testsSean Dague2008-09-241-0/+97
|
* let the asset tests run on MySQL. Interesting difference here, theSean Dague2008-09-243-1/+92
| | | | | | | sqlite driver can handle .Data = Null, the mysql driver can not. We should decide which is the right behavior and adjust code for it.
* create the first attempted mysql test. This only runs locally if youSean Dague2008-09-231-8/+19
| | | | | | | have a database configured as opensim-nunit with user opensim-nunit / password opensim-nunit that has full perms on the database.
* remove log4net references, see if that helps fix bambooSean Dague2008-09-231-9/+1
|
* check in stubbing for mysql tests. This is ignored withSean Dague2008-09-231-0/+74
| | | | | | | | Assert.Ignore() for now, so it won't change anything, but I want to make sure it doesn't break the bamboo infrastructure in it's current state.
* - Add Dispose method to IRegionDataStoreHomer Horwitz2008-09-181-0/+2
| | | | | | | | - Add necessary dummy Dispose-methods where they are missing - Implement the SQLite Dispose-methods (currently only used for unit tests, in the next commit)
* Mantis #2124Melanie Thielker2008-09-141-1/+1
| | | | | | | Thank you, RuudL, for a patch that brings MSSQL up to the same implementation level as MySQL.
* Thank you kindly, CMickeyb for a patch that:Charles Krinke2008-09-141-0/+6
| | | | | | | | | Moved intialization of appearance from the SendInitialData event handler into CompleteMovement handler. That ensures that m_appearance is initialized before the inventory is retrieved (so there is a place to check on attachments).
* * Add userstore sql upgrade I carelessly forgot to check in a couple of ↵Justin Clarke Casey2008-09-121-0/+5
| | | | | | | | revisions ago * Hopefully there wasn't a problem anyway, since the look at stuff isn't enabled yet
* * Check in first part of http://opensimulator.org/mantis/view.php?id=2073Justin Clarke Casey2008-09-121-3/+6
| | | | | | | | | * This patch aims to introduce look at direction persistence between logins. It won't be active until the second part of the patch is committed in about two weeks time. At this point, region servers that haven't upgraded past this revision may run into problems * This checkin upgrades the user database. As always, we recommend you have backups in case something goes wrong. * Many thanks to tyre for this patch.
* Mantis #511Melanie Thielker2008-09-101-1/+2
| | | | | | | Allow parsing of hexadecimal int constants from strings. Also fixes a DBNull value in the touch type field crashing the sim
* Thanks, nlin, for a patch implementing persistence for "When Left Clicked"Mike Mazur2008-09-102-0/+11
| | | | | | object property. Fix issue 2149.
* Update svn properties, formatting cleanup.Jeff Ames2008-09-092-2/+2
|
* Implement proper persistence of the following prim properties:Melanie Thielker2008-09-082-3/+26
| | | | | | | | | Floating text, Rotation, Texture animation, Particle System This will make "Eye Candy" scripts work without modification in XEngine. The use of the CHANGED_REGION_RESTART hack is no longer needed. Implemented in MySQL only, hovertext also in SQLite.
* Mantis #2133Melanie Thielker2008-09-062-2/+2
| | | | | | | Thank you, Xugu Madison and ChrisDown, for a patch that fixes linux filename extensions from .Xml back to .xml
* * This is the fabled LibOMV update with all of the libOMV types from JHurlimanTeravus Ovares2008-09-068-217/+217
| | | | | | | * This is a HUGE OMG update and will definitely have unknown side effects.. so this is really only for the strong hearted at this point. Regular people should let the dust settle. * This has been tested to work with most basic functions. However.. make sure you back up 'everything' before using this. It's that big! * Essentially we're back at square 1 in the testing phase.. so lets identify things that broke.
* Update svn properties.Jeff Ames2008-09-031-24/+24
|
* Mantis #2099Melanie Thielker2008-09-032-16/+38
| | | | | | | Thank you, cmickeyb, for a patch that corrects the database connection handling in the multithreaded user server.
* apparently I missed one of the old version routines that could beSean Dague2008-09-021-39/+0
| | | | | | removed. Removing that now.
* * Added new MySQLSuperManager support for the grid servers.Adam Frisby2008-08-303-69/+140
| | | | | * In theory, login and a large number of grid functions should now at least be multithreaded.
* * Fixed #2807 Again, Whoops.Adam Frisby2008-08-301-1/+1
|
* * Fix for Mantis #2087, Standalone MySQL broken with threading improvements. ↵Adam Frisby2008-08-301-0/+9
| | | | (Didnt realise this code was being shared with the gridservers)
* * Minor fix to previous threading patch, every nTH request would previously ↵Adam Frisby2008-08-301-2/+10
| | | | have been delayed for 1000ms. This has been fixed.
* * Added new "SuperManager" class for MySQL connections, for allowing ↵Adam Frisby2008-08-302-236/+379
| | | | | | | | multiple concurrent MySQL threads. * Implemented SuperManager inside of UserData. This means the userserver when running on MySQL will use 10 connections (+1 system connection) to handle requests, preventing the previous mire of locking resulting in singlethreadedness. * This requires testing and grids relying on stability should not upgrade to this revision until it's been properly tested.
* remove legacy pre-Migration database upgrade routinesSean Dague2008-08-271-120/+0
|
* remove the legacy pre-Migration database upgrade pathsSean Dague2008-08-271-42/+0
|
* remove pre-Migration upgrade pathsSean Dague2008-08-271-92/+0
|
* we're past checkin 6000, so now cleaning up all the cruft of the preSean Dague2008-08-271-302/+3
| | | | | | migration database upgrade paths. This is coming in in stages.
* Mantis#2027. Thank you kindly, HomerHorwitz for a patch that addresses:Charles Krinke2008-08-241-1/+1
| | | | | | | | Analysis shows that the XMLRPC-request contains an empty string (<string />) for the custom_type parameter, which is deserialized wrongly to a null-value, thus leading to the exception above. The attached patch (against r5967) fixes the symptom and uses "" for customType in that case.