aboutsummaryrefslogtreecommitdiffstatshomepage
path: root/OpenSim/Data/MySQL/MySQLAssetData.cs (unfollow)
Commit message (Collapse)AuthorFilesLines
2008-11-06add create_time and access_time to asset db for mysql, as wellSean Dague1-2/+46
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-09-24let the asset tests run on MySQL. Interesting difference here, theSean Dague1-1/+1
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-06* This is the fabled LibOMV update with all of the libOMV types from JHurlimanTeravus Ovares1-3/+3
* 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.
2008-08-27remove the legacy pre-Migration database upgrade pathsSean Dague1-42/+0
2008-08-18Formatting cleanup.Jeff Ames1-4/+4
2008-07-31Thanks, sempuki, for a patch that moves all Grid Server's plugins toMike Mazur1-1/+1
PluginLoader. Fix issue 1871.
2008-07-18Thanks, sempuki, for a patch that moves all grid plugins to new PluginLoader ↵Mike Mazur1-0/+1
(issue 1763).
2008-07-07* remove unused CommitAssets() hook for nowJustin Clarke Casey1-7/+0
2008-07-03Mantis#1661. Thank you kindly, CMickeyb for a patch that:Charles Krinke1-0/+6
patch attached to check for timeouts on mysql connections *before* operations occur that are likely to timeout. if timeout occurs or the connections is down, it is reconnected before the operation fails.
2008-07-02* Drop InvType from the assets table since it is no longer usedJustin Clarke Casey1-5/+3
* Migration should be automatic on sqlite and mysql * Migration is not automatic on mssql, you will need to drop the invType column manually * Migration should be fine, but as for any db change, I would recommend making sure you have backups before moving past this revision
2008-06-29* Fix for http://opensimulator.org/mantis/view.php?id=1512Justin Clarke Casey1-1/+1
* Introduce experimental wait timeout checking to mysql region datastore code * This should mean that if the mysql connection has timed out, we should automatically reconnect and not fail or drop queries on region database manipulations
2008-06-27last round of warning squashing. calling it a day now.Dr Scofield1-10/+10
2008-06-27Mantis#1591. Thank you graciously, Sempuki for a patch that:Charles Krinke1-1/+3
Currently module loading is done ad-hoc. I propose creating a simple loader class that leverages Mono.Addins (and perhaps the new .NET addins when they become available in mono). Attached is a basic patch for review that compiles into HEAD, but doesn't yet replace any existing ad-hoc loaders.
2008-06-26Apply patch from bug #1601 -- more documentation for Data/MySQL. Thanks ↵Jeff Ames1-19/+42
kerunix_Flan!
2008-06-26Add patch from bug #1596 - adds Doxygen documentation in OpenSim.Data.MySQL ↵Jeff Ames1-1/+36
files. Thanks kerunix_Flan!
2008-06-16the beginning of the great id format migration. This makesSean Dague1-6/+4
asset uuids no longer binary. I've tested this migration a few times, and it seems working in all the scenarios I've found but it wouldn't hurt to backup your asset db before running this as it does touch a very sensitive part of our content system.
2008-06-12this, in theory, adds migration support to mysql for all Sean Dague1-34/+50
data sources besides the grid store. It is only lightly tested so the less adventurous should wait a couple of checkins before upgrading.
2008-06-04Formatting cleanup, minor refactoring, svn properties.Jeff Ames1-5/+5
2008-05-31* Duh, actually returning from the CreateAsset method once we know the asset ↵Justin Clarke Casey1-0/+1
exists would be better than carrying on
2008-05-31* Remove the mysql logging noise I accidentally left in a few commits agoJustin Clarke Casey1-2/+2
2008-05-31* Change MySQL to check whether an asset already exists before inserting it ↵Justin Clarke Casey1-1/+40
into the database
2008-05-16Formatting cleanup.Jeff Ames1-5/+5
2008-05-14More formatting cleanup.Jeff Ames1-2/+5
2008-05-01* Align new fields upgrade sql to have the same 'not null' and default ↵Justin Clarke Casey1-3/+3
settings as when an inventoryitems table is newly created * Normalize logging titles in database code, though this doesn't yet cover invoking code
2008-04-24in theory, let you pass the mysql connection string into theSean Dague1-1/+7
mysql manager class. This could use some testing of inventory and asset services. Once this is prooved out, I'll do it for mssql as well.
2008-04-23changes to allow asset_source to be specified in the opensim.iniSean Dague1-0/+7
this will work for sqlite and nhibernate, but will be ignored for mysql and mssql (reverting to their ini files) until someone writes that bit.
2008-04-21* Optimised using statements and namespace references across entire project ↵Adam Frisby1-2/+3
(this took a while to run).
2008-04-02fix ups to include OpenSim.Framework explicit includes (theySean Dague1-0/+1
were implicitly included before). Everything builds again. Now off to testing.
2008-04-02attempt to fix up all refernces to new directory structureSean Dague1-1/+1
2008-04-02whole lot more movingSean Dague1-0/+0
2008-03-28* Introduced common abstract AssetDataBase implementing IAssetProviderlbsa711-9/+9
* changed the semantics of SQLiteBase to SQLiteUtils * Added abstract placeholder files for the other db providers
2008-03-18Formatting cleanup.Jeff Ames1-26/+25
2008-02-20Minor cleanup.Jeff Ames1-1/+1
2008-02-10Clean up logging calls using String.Format explicitlyJeff Ames1-7/+7
2008-02-05Converted logging to use log4net.Jeff Ames1-8/+10
Changed LogBase to ConsoleBase, which handles console I/O. This is mostly an in-place conversion, so lots of refactoring can still be done.
2008-02-04* Synchronize asset storage operations to mysql as well as readsJustin Clarke Casey1-31/+35
* This may help with asset server mysql problems, since both the previous osgrid failures occurred when both a read and write were attempted in the same second
2008-02-04A smidgen more error info for the asset serverJustin Clarke Casey1-4/+5
2008-01-30* Print out exception information when a mysql asset fetch failsJustin Clarke Casey1-16/+29
* Attempt reconnection on fetch and create exceptions.
2007-12-27* Optimized usingslbsa711-7/+7
* shortened references * Removed redundant 'this' * Normalized EOF
2007-12-08Adding an explicit close() and dispose() in the hope that it might help with ↵Brian McBee1-0/+3
assetserver issues.
2007-11-26Attempt to handle MYSQL error fetching assetsBrian McBee1-10/+17
2007-11-01Need to clean up resources when creating/updating assetsTleiades Hax1-0/+1
2007-11-01(no commit message)Tleiades Hax1-10/+14
2007-10-30* Optimized usingslbsa711-20/+23
* Shortened type references * Removed redundant 'this' qualifier
2007-10-29as per the "Filesystem cleanup for OpenSim repository" mailing list thread. ↵MW1-1/+1
Have flattened the OpenSim.Framework project/namespace. The problem is that the namespace is still wrong as its "OpenSim.Framework" while the directory is "OpenSim\Framework\General" , so we need to decide if we change the directory or correct the namespace. Note this has lead to a big flat project, but I think a lot of the files we most likely don't even use any longer. And others belong in other projects/namespaces anyway.
2007-10-26Very early first implementation of grid based assets.Tleiades Hax1-14/+16
Run this on a major grid, and weep
2007-10-19get rid of all the ^M line endingsSean Dague1-159/+159
2007-10-15* Applied Chillken patch #418: copyright-r2094.patch updating copyright ↵lbsa711-0/+28
messages. Thanks Chillken!
2007-10-13OpenSimMain now respects the asset_plugin paramter, and storing of assets ↵Tleiades Hax1-2/+21
will *not* throw an exception
2007-10-13Added capbility to use MySQL as the database backend in stand alone mode for ↵Tleiades Hax1-21/+2
assets and inventory. Added asset_plugin key to "StandAlone" section of OpenSim.ini