OpenSim-NGC / OpenSim-Sasquatch

OpenSim Core ++. Provides Bug Fixes and some new ideas that enhance the reliability and performance of OpenSim Core Yeti.
Other
21 stars 11 forks source link

Setting [Webstats] to true causes crash #72

Open punyauk opened 5 months ago

punyauk commented 5 months ago

Enabling Webstats option crash ( OpenSim NGC Rel 0.9.2.2.8738 )

With [WebStats] enabled=true

This is on a system using MySQL as the database and no money system (I tried setting economy module to none) [Economy] EconomyModule = None

ERROR: 19:54:06 - [MONEY]: PostInitialise: 19:54:06 - Fatal error: System.DllNotFoundException: SQLite.Interop.dll assembly: type: member:(null) at (wrapper managed-to-native) System.Data.SQLite.UnsafeNativeMethods.sqlite3_config_none(System.Data.SQLite.SQLiteConfigOpsEnum) at System.Data.SQLite.SQLite3.StaticIsInitialized () [0x0001c]: in <33e9c369d13c449ba79f1798811d3583>:0 at System.Data.SQLite.SQLiteLog.PrivateInitialize (System.String className) [0x00032] in <33e9c369d13c449ba79f1798811d3583>:0 at System.Data.SQLite.SQLiteLog.Initialize (System.String className) [0x00023] in <33e9c369d13c449ba79f1798811d3583>:0 at System.Data.SQLite.SQLiteConnection..ctor (System.String connectionString, System.Boolean parseViaFramework) [0x0002c] in <33e9c369d13c449ba79f1798811d3583>:0 at System.Data.SQLite.SQLiteConnection..ctor (System.String connectionString) [0x00000] in <33e9c369d13c449ba79f1798811d3583>:0 at (wrapper remoting-invoke-with-check) System.Data.SQLite.SQLiteConnection..ctor(string) at OpenSim.Region.UserStatistics.WebStatsModule.PostInitialise () [0x0001b] in <0d6e702d085b49ccb011e7f184cee5cb>:0 at OpenSim.ApplicationPlugins.RegionModulesController.RegionModulesControllerPlugin.PostInitialise () [0x00029] in <0477f8df272a4f35afef7c25876fdb28>:0 at OpenSim.OpenSimBase.StartupSpecific () [0x00248] in <920b45f4d2ac4cf1a3a5e32a26b19e76>:0 at OpenSim.OpenSim.StartupSpecific () [0x000f6] in <920b45f4d2ac4cf1a3a5e32a26b19e76>:0 at OpenSim.Framework.Servers.BaseOpenSimServer.Startup () [0x00099] in :0

renevega commented 4 months ago

The comments in OpenSim.ini are incorrect. The economy module has to be the name of currency module or an empty string. An empty string indicates to the region simulator to not load a money module.

[Economy] EconomyModule = ""

renevega commented 4 months ago

But specific to your problem, it appears that WEBstats requires mysqlite. The OpenSimDefaults.ini does not have a setting to specifiy MySQL.

But you could use jsonSimStats, which is always enabled, if you are looking for stats like the following. http://youregionservername:regionport/jsonSimStats/

{"Dilatn":"1","SimFPS":"55","PhyFPS":"55","AgntUp":"0","RootAg":"0","ChldAg":"0","NPCAg":"0","Prims":"116","AtvPrm":"0","AtvScr":"19","ScrLPS":"0","ScrEPS":"5","PktsIn":"0","PktOut":"0","PendDl":"0","PendUl":"0","UnackB":"0","TotlFt":"18.18","NetFt":"0","PhysFt":"0.06","OthrFt":"0.02","AgntFt":"0","ImgsFt":"0","FrameDilatn":"1","Logging in Users":"0","GeoPrims":"116","Mesh Objects":"34","Script Engine Thread Count":"0","RegionName":"Test2x2","Util Thread Count":"0","System Thread Count":"40","System Thread Active":"0","ProcMem":"177884","Memory":"44","Uptime":"17.12:43:11.7930130","Version":"OpenSim-NGC Tranquillity 0.9.2.2.8738 "}