aboutsummaryrefslogtreecommitdiffstatshomepage
path: root/OpenSim/Data/MySQL (unfollow)
Commit message (Collapse)AuthorFilesLines
2010-01-01New LL login service is working! -- tested in standalone only. Things still ↵Diva Canto1-3/+3
missing from response, namely Library and Friends. Appearance service is also missing.
2010-01-01Auth data migration.Diva Canto1-0/+5
2009-12-31Implement avatar picker queriesMelanie1-2/+36
2009-12-31Implement saving user account dataMelanie1-1/+1
2009-12-30Some modifications to user service. Query by name is implemented nowMelanie1-0/+1
2009-12-29Fixed a couple of bugs that were bombing the data migration.Diva Canto2-2/+2
2009-12-29Polished the IUserService interface.Diva Canto1-4/+4
2009-12-29Change the interface a bit before someone depends on it's current formMelanie1-0/+4
2009-12-29Give the new user tables the once-over. Strip the current set of methodsMelanie4-139/+18
from IUserAccountService, we need to define what goes in there. Change the handler to the generic handler. Adjust migrations, add index
2009-12-29* Added useraccount tableDiva Canto1-0/+13
2009-12-28Add the indices to really make this table workMelanie1-0/+6
2009-12-28Add a migration to add the 3 new fieldsMelanie1-0/+7
2009-12-28Adding new fields and home location methid to presence. Adding cleanupMelanie2-0/+54
(deleting all but one presence record) on logout so that they don't pile up.
2009-12-28Add the second step of the friends migration to pull data from the old table ↵Melanie1-0/+5
into the new
2009-12-28Add the migration for friends and guard the presence Report functionMelanie2-0/+13
2009-12-28Forgot the migration fileMelanie1-0/+15
2009-12-27Add the MySQL presence data moduleMelanie1-0/+93
2009-12-26Correct some issues with the last commitroot1-1/+2
2009-12-26Close a SQL injection loophole in the new database driverMelanie1-2/+3
2009-12-26Make the GenericTableHandler work as intendedroot1-2/+8
2009-12-26Add a generic REPLACE INTO handler for put into the generic table handlerMelanie1-0/+25
2009-12-13* Implements OSSL function: osGetSimulatorMemory - returns the current ↵Adam Frisby1-0/+3
amount of memory allocated to the simulator process (Moderate Threat Level). * Cleans redundant information out of the Simulator Version. Versions now look like: "OpenSimulator 0.6.9(dev) Unix/Mono" * [Minor] additional log info for MySQLInventoryData
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-23* Implements SQL Rollback support to Inventory Service for quicker backup ↵Adam Frisby1-0/+154
restoration. * Can optionally replace the OpenGridMode committed earlier. * Will create a series of incrementing restore SQL files, one per user, in folders listed per-day. * For MySql Section of InventoryService INI: rollback = "true" rollbackdir = "/absolute/path/to/rollback/storage/dir"
2009-11-23* Adds a modicum of additional checking to the Inventory Service (MySQL only)Adam Frisby1-5/+22
* Enable "opengridmode=true" in your Inventory Connector (where the mysql connection strings are) to enable if you are running a 'wide-open-grid'. * More comprehensive rollback support being implemented, should be available later today.
2009-11-23Formatting cleanup.Jeff Ames1-2/+2
2009-11-18Implement generic delete methodMelanie1-1/+14
2009-11-18Tweak presence handling and whip up a database connector and handlerMelanie1-1/+3
for testign the new generic table handling
2009-11-15Committing the incomplete table handler to get it into the tree. No userMelanie1-0/+200
functionality yet
2009-11-05Changing the AssetBase constructors to avoid initializing assets with an ↵John Hurliman1-4/+1
unknown asset type, and log an error if it ever does happen
2009-11-02Removing Console.WriteLine()s that were brought in with the revertJohn Hurliman1-2/+0
2009-11-02Removing duplicate SceneObjectPart.RotationalVelocity propertyJohn Hurliman1-4/+4
2009-11-02Reverting the memory leak patch for MySQL. Problems have been reported with ↵John Hurliman10-834/+860
the grid server after running for several hours
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 Hurliman2-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
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-14* Replaced (possibly broken?) math for calculating the unix timestamp in ↵John Hurliman1-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
2009-10-12Stop null values from being returned on database queriesMelanie1-1/+4
2009-10-06Reverting MySQLLegacyRegionData spamJohn Hurliman1-6/+0
2009-10-06MySQLLegacyRegionData: Extreme Spam Edition(tm)John Hurliman1-0/+6
2009-10-06Remove the using() constructs from the new style database modules; they causedMelanie4-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
2009-10-06* Continued work on the new LLUDP implementation. Appears to be functioning, ↵John Hurliman1-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
2009-10-05Added CloseDBConnection() to replace the old CloseReaderCommand(). This will ↵John Hurliman4-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
2009-10-04* MySQL data tests now pass by fixing a bad fix for a bad cast on the asset ↵John Hurliman11-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)
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 Ames4-11/+11