opserver / opserver Goto Github PK

Some images are referenced in the solution but missing in the content folder

I've been working with this for a couple months and it seems that regardless of what attempts I make to reconfigure the Instance name or other options, I cannot get the performance stats to show up on servers that have named instances. If it uses the default instance I get all the data I would expect to get.

Wondering if this has to do with some of the instance issues other people have had. Also wondering if anyone has a workaround that would help me with this.

Thanks In advance for any ideas.

If i try publish project to server. I get this error.
On localhost works fine.

Hi, i have a problem with this. Unable to fetch from SQL: Error opening connection to master at WOLVERINE timeout was: 5 000 ms
Login failed for user 'WOLVERINE\Guest'.

First sql instance on local network it works ok. But if i try add second instance on different network on internet i get this error "Unable to fetch from SQL: Error opening connection to master at WOLVERINE timeout was: 5 000 ms
Login failed for user 'WOLVERINE\Guest'. "
My connections is this:
{
"defaultConnectionString": "Data Source=$ServerName$;Initial Catalog=master;Integrated Security=SSPI;",
"instances": [
{
"name": "SKIEN"
}
],
"secondConnectionString": "Data Source=$ServerName$;Initial Catalog=master;User Id=sa;Password=sa;Trusted_Connection=False",
"instances": [
{
"name": "WOLVERINE"
}
]
}
Thank you

I am trying to modify this to add in some more features that would be useful to our organization and I'm having trouble figuring out where all I will need to make changes. It's built to be pretty extensible but I'm just having a bit of trouble on where to get started.

When using AD authentication instead of giving everyone using "alladmin" I was able to login and see the Hub and Dashboard but the SQL dashboard gives me Access Denied :( error. The account running the app and the one I use to login has access to the SQL Instances. I also included AD group that the account is member of in the ViewGroup setting in web.config.

What am I missing? Has anyone seen this? Is there a way to give access to dashboard to individual users without group?

Can't open project in Vs2012
when I open the solution , vs2012 would shut down

I saw this at SQLPASS last week - it looks brilliant and I would like to give it a workout....
Is there VS 2010 version download still available somewhere?

We're running SQL 2005.

Looking at and running the sql from class SQLDatabaseBackupInfo, it does return multiple rows per database. These databases were originally restored from a multi file backup set. With the exception of the LastFullBackupPhysicalDeviceName column, all values are identical.

Message=An item with the same key has already been added.
  Source=mscorlib
  StackTrace:
       at System.ThrowHelper.ThrowArgumentException(ExceptionResource resource)
       at System.Collections.Generic.Dictionary`2.Insert(TKey key, TValue value, Boolean add)
       at System.Linq.Enumerable.ToDictionary[TSource,TKey,TElement](IEnumerable`1 source, Func`2 keySelector, Func`2 elementSelector, IEqualityComparer`1 comparer)
       at System.Linq.Enumerable.ToDictionary[TSource,TKey](IEnumerable`1 source, Func`2 keySelector)
       at ASP._Page_Views_SQL_Databases_cshtml.Execute() in c:\Users\[xxx]\Documents\GitHub\Opserver\Opserver\Views\SQL\Databases.cshtml:line 8
       at System.Web.WebPages.WebPageBase.ExecutePageHierarchy()
       at System.Web.Mvc.WebViewPage.ExecutePageHierarchy()
       at System.Web.WebPages.WebPageBase.ExecutePageHierarchy(WebPageContext pageContext, TextWriter writer, WebPageRenderingBase startPage)
       at System.Web.Mvc.RazorView.RenderView(ViewContext viewContext, TextWriter writer, Object instance)
       at System.Web.Mvc.BuildManagerCompiledView.Render(ViewContext viewContext, TextWriter writer)
       at StackExchange.Profiling.Mvc.WrappedView.Render(ViewContext viewContext, TextWriter writer)
       at System.Web.Mvc.HtmlHelper.RenderPartialInternal(String partialViewName, ViewDataDictionary viewData, Object model, TextWriter writer, ViewEngineCollection viewEngineCollection)
       at System.Web.Mvc.Html.PartialExtensions.Partial(HtmlHelper htmlHelper, String partialViewName, Object model, ViewDataDictionary viewData)
       at System.Web.Mvc.Html.PartialExtensions.Partial(HtmlHelper htmlHelper, String partialViewName, Object model)
       at ASP._Page_Views_SQL_Dashboard_cshtml.Execute() in c:\Users\[xxx]\Documents\GitHub\Opserver\Opserver\Views\SQL\Dashboard.cshtml:line 56
       at System.Web.WebPages.WebPageBase.ExecutePageHierarchy()
       at System.Web.Mvc.WebViewPage.ExecutePageHierarchy()
       at System.Web.WebPages.StartPage.RunPage()
       at System.Web.WebPages.StartPage.ExecutePageHierarchy()
       at System.Web.WebPages.WebPageBase.ExecutePageHierarchy(WebPageContext pageContext, TextWriter writer, WebPageRenderingBase startPage)
       at System.Web.Mvc.RazorView.RenderView(ViewContext viewContext, TextWriter writer, Object instance)
       at System.Web.Mvc.BuildManagerCompiledView.Render(ViewContext viewContext, TextWriter writer)
       at StackExchange.Profiling.Mvc.WrappedView.Render(ViewContext viewContext, TextWriter writer)
       at System.Web.Mvc.ViewResultBase.ExecuteResult(ControllerContext context)
       at System.Web.Mvc.ControllerActionInvoker.InvokeActionResult(ControllerContext controllerContext, ActionResult actionResult)
       at System.Web.Mvc.ControllerActionInvoker.<>c__DisplayClass1a.<InvokeActionResultWithFilters>b__17()
       at System.Web.Mvc.ControllerActionInvoker.InvokeActionResultFilter(IResultFilter filter, ResultExecutingContext preContext, Func`1 continuation)
  InnerException: 

When I visit /hub on an intended dashboard I simply get a "no config" error.

The roles being assigned in /about are Anonymous, InternalRequest

securitysettings.config looks like:

<?xml version="1.0" encoding="utf-8"?>
<SecuritySettings provider="AD">
    <InternalNetworks>
        <Network name="TV Monitor" ip="10.128.0.x" cidr="32" />
    </InternalNetworks>
</SecuritySettings>

and web.config looks like

  <add key="ViewGroups" value="foo_view" />
  <add key="AdminGroups" value="foo_admins" />

/admin/errors shows no errors.

AD Logins work OK

Currently only have SQL provider setup and running OK when logged in.

There are no security settings set in the sqlsettings.json

Hi, I have installed Opserver in a test environment but I am failing to understand how exactly the dashboard works.

The example screenshots appear to show monitoring of some basic information about servers however I do not understand how these are configured.

I have SQL and Redis monitoring configured, should these also be showing up on the dashboard automatically?

I have removed the Orion bit from the dashboard configuration (I don't have such a system). Is this provider required? As far as I could tell it was just used for network monitoring which I am not interested in.

Current DesktopSettings.json file https://gist.github.com/lutzee/3e1b6ec72eacbc8047e8

The Dashboard is currently showing up as disabled.

I have a question regarding virtual directory. When I run it in local, I try make it run like on the server so I create a virtual directory. The project url becomes something like http://localhost:56259/Opserver. However, it doesn't work. I tried to deploy it on server (IIS8), somehow it keeps jump to \login instead of \login How to fix it ? Thanks. Btw it is a great tool !

I'm using AD authentication and when visiting the login page, the style is missing. Looking further, it seems that requests to files below /Content are denied for unauthenticated users.

We are currently using Opserver and are planning to test Bosun. However, the Bosun branch seems to be rather stale, are there are plans to integrate it into the master branch?

While evaluating OpServer on our intranet, we noticed some features don't work when IE is in compat mode. Clicking a row in top queries doesn't show the pop-up window . Another one is clicking a database name to show details.

Disabling compatibility mode for intranet sites in IE fixes this, but unfortunately it needs to be enabled for other intranet sites within the company. Thought I would throw it out there in case anyone else runs across it or if there is a fix.

sysadmin seems to work! :)

But it would be nice to know the minimal permission set to give my OpServer service account.

There is a TeamCity settings json file yet I couldn't find a controller for builds or TeamCity.
It looks like there is code to support connecting to the TeamCity rest API and gathering information about builds but no view for it. Is this coming in a later release?

SQL servers monitoring not display CPU graph for both standalone and cluster
Note: i get the latest version.

sys.dm_exec_connections returns timestamps in local server time, so when a server is not set to UTC, /sql/connections will report wrong information like "Login in 59 minutes" and "Connected in 24 minutes".

Hello!
I didn't work with C#/MVS before and can't understand, how should I Install/Run it.
I made a Web Depoly Package, deployed it in IIS as Default Web Site/OPServer, renamed security config (as Web.config asks me) and fixed security config for my subnet, but then if I trying to open http://localhost/OPServer I'm getting 404 error as 'No content found'.
http://localhost/OPServer/Global.asax not working as well. And there are no any default web-page.
Which file/catalog or how should I run Opserver?

Environment vs2013 update 2.
Error 1 "csc2.exe" exited with code -532462766. Opserver.Core.

I'm thinking I'm running into environment issues but thought I'd check here too. I've deployed and when I browse I get an error on the security config file because it has the .example extension so I expected that. But when I make a copy and remove the .example extension I get a 404 error. Any thoughts why?

This line throws an error against MS SQL 2005 servers:

Declare @sql nvarchar(max) = '';

Cannot declare and assign a value on same line. Should be the following to ensure capatibility:

Declare @sql nvarchar(max);
Set @sql = '';

How do I initialize the database schema, so the HAProxy traffic tab will work?

I have found the HAProxy monitoring very useful thus far and would like to see what the traffic tab does, however, I have not been able to figure out properly configure the database from a schema standpoint.

If connectionstrings have a backslash in them, like server\instance, it crashes. Using server\instance works.

Start and End values are incorrect/confusing.

e.g.
on my local machine the time is 10:43AM
the SQL Server has a daily job that runs at 1:05AM
In Opserver Start = 22 minutes, End = 27 minutes, duration 4m 21s

On mouse hover, Start shows the correct start time of 1:05AM.

its not clear what start and end refer to.. i have assumed it related to the job.. but maybe this relates to the schedule?

It would be great to have last run, next run information for agent jobs (Job activity monitor)

I'd like to extend the instance configuration system, specifying - for example - one (or more) database name not be monitored (it's ok sometimes to have a db offline, in these cases seeing the issue it's really noisy and disturbing).

Not sure about how to proceed: those new settings could be necessary at classes like SQLDatabaseInfo, which are singleton scoped and serve many different SqlInstance instances. Or the settings could passed to the GetFetchSQL() method, but it has many implementors and I would like do fewer modifications to the code.

Any ideas?

Hello there,
When I try to log in, I receive error:

In fact, there isn't any Plugins.js file in Content directory. Did I miss something?

Hi,

I have AD authentication turned on but it doesnt seem to be working. I have tried logging in with just %username%, %username%@%domain.suffix% and %domain%%username%.
The problem is when I log in, I get the 'Uh oh! No Configuration!' error.

I have set in the web config the following keys:

  <add key="ViewGroups" value="Domain Admins" />
  <add key="AdminGroups" value="Domain Admins" />

Do I need to set the value to be %domain%\Domain Admins?
/about has Security: Enabled and Roles: Authenticated listed.
/admin/errors has No errors yet, yay!

I dont understand what to do for this line in the readme:
You can also edit the ViewGroups and AdminGroups on a per monitor basis by adding "AdminGroups": "GroupName", or "ViewGRoups": "GroupName", to the json config file.
SecuritySettings.config does not seem to have a section for these keys?

Secondly, when I set up an SQL server as an instance for testing, using SSPI as the authentication method, it seems to use %domainname%%servername% as the username as access credentials. This means I can never retrieve info from the SQL server - when I drill down I get an error message like:

Unable to fetch from SQL: Error opening connection to master at timeout was: 5,000 ms
Login failed for user '%domain%%servername%$'.

I can use the credentials I am logging in with in SQL Management studio and log in OK.

if I set authentication to be alladmin, I can get an error like:

Unable to fetch from SQL: The user does not have permission to perform this action.
The user does not have permission to perform this action.

/about has:
Security: Enabled
Roles: Authenticated, Exceptions, ExceptionsAdmin, HAProxy, HAProxyAdmin, SQL, SQLAdmin, Elastic, ElasticAdmin, Dashboard, DashboardAdmin, GlobalAdmin
/admin/errors has:
No errors yet, yay!

Thirdly, I see the message '16 Indexes in trouble on 1 node (elasticsearch)' on the elasticsearch page - I can't click on anything and I have no stats - is this normal?

Thanks for your help.

Feature suggestion (and I'd be happy to volunteer my own time for implementation): allow linking exceptions to a bug tracker URLs, e.g. FogBugz:

Idea is: when known exceptions resurface ("known" meaning they would get grouped together by "view similar"), the person monitoring the exception log can immediately see that it's a known issue and look at the bug to get more context.

Makes sense?

Is there any tutorials on this set up. I have spent a couple days on this now trying to get it configured. I did the build in Visual Studio 2012 and then used IIS manager to deploy. Or anything that can point me in the right direction as in steps to take? Installation says deploy as is so does that mean the configs we don't need to modify.

Hi,

I have Opserver looking at an SQL instance - it seems to pull data ok, but it shows me some jobs are unhealthy - should i be able to see these jobs when I click on the unhealthy/ healthy link next to Jobs when in the Instance tab?

Also, the view configuration link does not seem to do anything - should something pop-up or display?

Thanks

Line 15 of Opserver / Opserver / Views / Shared / Master.cshtml is:

I was getting error messages about jQuery not being accessible when trying to get opserver up and running. Adding the http: in front of the path resolved that issue for me, resulting in the following:

The error is csc2.exe exit,code is -532462766 when I use vs2013 to open this project and bulid it . How to fix it ?

For standalone instances Opserver is working great, showing the status of the server on the main SQL dashboard and also when i drill down to each server I see many details. But for clustered nodes some columns in the SQL Dashboard are missing even listing the state as "Offline" and the quorum state as unknown. Also when i drill down to each instance Performance, Size and Cache information are missing. Attached are two screenshots showing what is missing.

Did I misconfigure something? Any idea whats going on?

Opserver

Got lastest, hit rebuild, error.

NuGet Package restore failed for project Opserver.Core: Unable to find version '0.1.25' of package 'StackExchange.Elastic'..

performing a search for the package on nuget.org returned 0 results
https://www.nuget.org/packages?q=StackExchange.elastic

Open the solution via VS, Scripts.StackOverflow.js was added in project but this file does not existed in Content/js/

is Scripts.StackOverflow.js rename to Script.js?

You've probably already fixed this in the internal repo because it completely breaks IntelliSense in views, but just in case: System.Web.WebPages.Razor, Version=2.0.0.0 should be System.Web.WebPages.Razor, Version=3.0.0.0 and System.Web.Mvc, Version=4.0.0.0 should be System.Web.Mvc, Version=5.0.0.0

Repro steps:

1. Go to the Sql Tab, select a Db, then go to the Top subtab
2. Click on the "Min Execs" link in the upper right, and change the filter from the default. For example, filter on a specific database
3. After the page reloads, click on a different column header in the table to resort

Expected: page will resort, while maintaining filter
Currently: filter settings are lost

The opposite is not true: You can sort on a column and filter, and it will remain sorted on that column after the filter is applied.

I have same graphic issues (In most cases when a small number of tables)

Is any way how can i working with this very potencionaly good freatures ?
I have installed BlitzIndex and Blitz and WhoIsActive.
Thanks

Is there any plugin available today in this project to monitor any Microsoft SQL Server backups? Same idea/question for Postgres as well.

Our current backup is a shell script (powershell) that gets executed every 6 hours, but I'd like to have something that we can constantly monitor at any given threshold during the day/week. Opserver sounds close to what I'm looking for, but am unsure at this time.

As this is for a startup project, and not a mega-million dollar enterprise, I'm looking at open source initiatives to save a few green-backs instead of spending mega bucks to solve my problem.

Any help/advice would be appreciated.

It appears that Opserver is capable of monitoring CPU, mem, diskspace, performance counters, etc on servers. How is this enabled?

Can this redis monitor be set with same port but different ip address and server name?I tried a lot of config but always get errors when reading the other redis status,Could you give a example of the right way to config it ?Thanks a lot.

It seems that SQL Azure does not support most of the stored procedures used to return system performance information. I don't know if we should add version checks to call different queries or if we should create a different page to show specific stats for Azure. For example, sysjobs is not available and you can't install sp_WhoIsActive.

Not necessarily a bug, but may be noted.

Clustered monitoring uses catalogs views only available in SQL Server 2012 or greater.

The following are queried:
sys.availability_replicas
sys.dm_hadr_availability_replica_states
sys.dm_hadr_availability_replica_cluster_states
sys.dm_hadr_database_replica_states
sys.availability_groups

CPU performance monitoring [spark chart images] for non SQL Server 2008 R2 or lesser machines may still display however.

Hello,

I Installed & Configured OPServer for my SQL Server through "SQLSettings.json.example" file and It is working perfect. I am not from programming filed so I need help.
I need .json files like "SQLSettings.json.example". I want to add and Monitor my AD (windows active directory) server & DNS Server as well as other servers (File Server, Print Server, Web Serevr or a Normal Server) in my network.

Please Advise me ASAP !

Thanks & Regards,
Hariom Prakash Singh. Delhi, India