aboutsummaryrefslogtreecommitdiffstatshomepage
path: root/OpenSim/Data/MySQL (unfollow)
Commit message (Collapse)AuthorFilesLines
2008-11-26A migration to convert the floats int the database to doubles.Melanie Thielker2-0/+60
Maybe we don't have to say "Shift happens" as often anymore....
2008-11-26Fix 2 of the failed tests. Cause terrain queries to return null when noMelanie Thielker1-1/+1
terrain is found, rather than a default "0" terrain. Remove the "remove object wrong region" test. UUIDs either are unique or they're not. This test tested a bad behavior I have chosen not to duplicate.
2008-11-26Committing the LCO database layer. Native MySQL, no ADO. New reconnectMelanie Thielker2-1472/+746
mechanism to prevent prim loss. Preserve link order on sim restart and drag copy. Fix drag-copied prims' inventories. Fix persistence of child prim inventories.
2008-11-23Remove code from an experimantal patch that wasn't supposed to be committedMelanie Thielker1-39/+13
2008-11-23Don't serve texture preview from other people's objects if youMelanie Thielker1-13/+39
havenever seen that texture before.
2008-11-23Plumb in the presence notifications and region shutdown/restart messagesMelanie Thielker1-0/+26
from the presence module to the message server, through the user server and on into the database. This should fix the "Already logged in" issue that grids see after a sim crashes, or a user crashes out of a sim. Not yet a 100% solution for friends, but getting there.
2008-11-21* refactor: Rip out SOP inventory from the partial into a separate classJustin Clarke Casey1-1/+1
* SceneObjectPartInventory.cs isn't a particularly good name but it's probably not got a long life * A proper inventory interface to follow * Parallel changes for other inventory partial classes to follow at a later date
2008-11-21Update svn properties, minor formatting cleanup.Jeff Ames1-6/+6
2008-11-19Mantis#2656. Thank you kindly, Nlin for a patch that:Charles Krinke2-0/+15
Attached patch implements llCollisionSound. Thanks T. Sado.
2008-11-18Fixed MySQL and SQLite so they will save theSean Dague2-0/+19
variable sun vector, adding 3 new fields on both. From: Arthur Rodrigo S Valadares <arthursv@linux.vnet.ibm.com>
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.