aboutsummaryrefslogtreecommitdiffstatshomepage
path: root/OpenSim/Data/MySQL (unfollow)
Commit message (Collapse)AuthorFilesLines
2008-11-16Make a quick stab at the "Open data reader" issue.Melanie Thielker1-8/+20
MySqlDataReader needs to be Close()d explicitly. Disposing it or letting it fall out of scope will not free it's hold on the connection.
2008-11-15Mantis#2552: Thanks idb, for a patch that fixes persistence of physical prims.Homer Horwitz1-2/+1
(added a fix for the broken build from last commit, too)
2008-11-14Add SQLite and the missing migrations files for last commitMelanie Thielker1-0/+5
2008-11-14Add group permissions to agent inventory.Melanie Thielker1-2/+4
Contains a migration. May contain nuts. Please back up your inventory data store. This revision changes the interface version!! No older regions can connect to these new UGAIM, and the new regions can't connect to the old UGAIM. Fixes a long-standing issue of permissions loss Currently persisted on MySQL only.
2008-11-13make inventory item listing more robust. It turns out that a bad itemSean Dague1-8/+28
(one that won't parse right) will prevent all other items in that folder to load when inventory is requested. This is very careful to no longer add inventory items that return as null to the hash table for getInventoryInFolder, as well as be more careful parsing UUIDs for fields that aren't marked not null in MySQL. The net result, you may see previously missing inventory items return after this checkin. Folders probably need to be hardened in the same way, but I'm out of time for today.
2008-11-13Update avatar picker search to work with OpenSearch people searchMelanie Thielker1-2/+2
2008-11-10* refactor: Expose SOG.SetRootPart for outsiders to use rather than setting ↵Justin Clarke Casey1-2/+2
RootPart and adding the part separately * Make RootPart read only
2008-11-08Mantis#2598: Thanks Fly-Man- for a patch that fixes a client-thread crash byHomer Horwitz1-1/+1
allowing landFlags bit 31 to be used (Int32 -> UInt32).
2008-11-08Remove empty OSUUID.cs file. Add copyright headers. Minor formatting cleanup.Jeff Ames1-1/+28
2008-11-06add create_time and access_time to asset db for mysql, as wellSean Dague2-2/+52
as the code to update these at the appropriate time. This isn't surfaced in AssetBase yet. Change the replace into to an insert into for asset create. Assets are not supposed to be updatable, and the replace into is more expensive. From: Sean Dague <sdague@gmail.com>
2008-11-06From: arthursv@linux.vnet.ibm.comSean Dague2-21/+21
Add more unit tests for user cases Persist more user fields into mysql that already had columns defined but weren't getting passed to the mysql manager.
2008-11-04add some null protection on emailSean Dague1-1/+1
From: Sean Dague <sdague@gmail.com>
2008-11-04implement email field for MySQL and SQLiteSean Dague3-15/+23
From: Sean Dague <sdague@gmail.com>
2008-11-01* Minor cleanupAdam Frisby1-1/+0
* Added additional error message when a Object/SOG DB save fails so we can trace why.
2008-11-01Megapatch that fixes/adds: friend offer/deny/accept, friendship termination,Homer Horwitz1-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.
2008-11-01Fix a compile warning about unreachable codeHomer Horwitz1-2/+0
2008-11-01A stab a getting the user server to act right. Move acquisition of theMelanie Thielker2-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
2008-10-31* Added some debug information to MySQL UserDataManager to help diagnose a ↵Adam Frisby2-18/+25
potential issue when in high load. Related to mantis #2508.
2008-10-30- Includes consistency test for new and updated objects, asSean Dague1-3/+2
some fixes in MySQL and SQLite From: Arthur Rodrigo S Valadares <arthursv@linux.vnet.ibm.com>
2008-10-30Mid-work, trying to fix region part insertion and retrievalSean Dague1-7/+29
SQLite reports System NUll Reference, but works, inside LoadItems, on SQLiteRegionData.cs From: Arthur Rodrigo S Valadares <arthursv@linux.vnet.ibm.com>
2008-10-18Megapatch. :) Fix skull attachment editing. Streamline Object terse updates.Melanie Thielker2-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.
2008-10-16- Enforced no user or agent with UUID 0 on agent DB insertionSean Dague1-0/+4
2008-10-15* minor: comment out persisting prim inventory log messagesJustin Clarke Casey1-1/+1
2008-10-15- Makes MySQL reject inserting UUID 0Sean Dague1-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.
2008-10-03Add the missing bits for the new region-search:Homer Horwitz1-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.
2008-10-03Add database persistence for material settingMelanie Thielker2-0/+11
2008-10-01add delete prim tests. Found and fixed bugs where regionSean Dague1-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.
2008-09-28Update svn properties. Minor formatting cleanup. Fix a compiler warning. ↵Jeff Ames1-2/+2
Fix a UUID vs null comparison.
2008-09-26* Patch from JHurlimanTeravus Ovares1-3/+3
* Updates to libomv r2243, * Remove lots of unnecessary typecasts * Improves SendWindData() Thanks jhurliman. * Will update OpenSim-libs in 10 minutes..
2008-09-25removal of more dead alter table codeSean Dague1-39/+2
2008-09-24light mysql user testsSean Dague1-0/+88
2008-09-24expose it for real, missed the public keywordSean Dague1-1/+1
2008-09-24expose MySQLUserData class so that it can be testedSean Dague1-1/+1
2008-09-24remove configurable table names from the mysql user driver. ThatSean Dague1-24/+3
doesn't work in a world of migrations anyway, and is only cruft that will confuse people.
2008-09-24Add persistence of active gestures. This needs an UGAIM update to work.Homer Horwitz1-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.
2008-09-24light the mysql region testsSean Dague1-0/+97
2008-09-24let the asset tests run on MySQL. Interesting difference here, theSean Dague3-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.
2008-09-23create the first attempted mysql test. This only runs locally if youSean Dague1-8/+19
have a database configured as opensim-nunit with user opensim-nunit / password opensim-nunit that has full perms on the database.
2008-09-23remove log4net references, see if that helps fix bambooSean Dague1-9/+1
2008-09-23check in stubbing for mysql tests. This is ignored withSean Dague1-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.
2008-09-18- Add Dispose method to IRegionDataStoreHomer Horwitz1-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)
2008-09-14Mantis #2124Melanie Thielker1-1/+1
Thank you, RuudL, for a patch that brings MSSQL up to the same implementation level as MySQL.
2008-09-14Thank you kindly, CMickeyb for a patch that:Charles Krinke1-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).
2008-09-12* Add userstore sql upgrade I carelessly forgot to check in a couple of ↵Justin Clarke Casey1-0/+5
revisions ago * Hopefully there wasn't a problem anyway, since the look at stuff isn't enabled yet
2008-09-12* Check in first part of http://opensimulator.org/mantis/view.php?id=2073Justin Clarke Casey1-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.
2008-09-10Mantis #511Melanie Thielker1-1/+2
Allow parsing of hexadecimal int constants from strings. Also fixes a DBNull value in the touch type field crashing the sim
2008-09-10Thanks, nlin, for a patch implementing persistence for "When Left Clicked"Mike Mazur2-0/+11
object property. Fix issue 2149.
2008-09-09Update svn properties, formatting cleanup.Jeff Ames2-2/+2
2008-09-08Implement proper persistence of the following prim properties:Melanie Thielker2-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.
2008-09-06Mantis #2133Melanie Thielker2-2/+2
Thank you, Xugu Madison and ChrisDown, for a patch that fixes linux filename extensions from .Xml back to .xml