My Logitech C210 webcam stopped working after the most recent round of Windows update(s). Unplugging and replugging it showed a popup that redirects to a MS link.
In order to get the webcam to work again, go to Windows Security / Core isolation, switch off Memory Integrity and reboot.
If you are trying to install .Net 3.5 via the Add Programs/Features on Windows 11 and get the above error, follow these simple steps:
Dism /online /enable-feature /featurename:NetFX3 /All /Source:%setupdrv%:\sources\sxs /LimitAccess
Learnt today that MariaDB has this great feature called a Sequence Storage Engine.
Ever needed to repeat something couple of times but don't want to write a loop? Just write a query that joins to a sequence table, for example:
set @date = date(now());selectdate(date_add(@date, interval seq day)) as date,dayname(date_add(@date, interval seq day)) as dayname,week(date_add(@date, interval seq day)) as weeknum,mod(dayofweek(date_add(@date, interval seq day))+5, 7) dayofweek,case when mod(dayofweek(date_add(@date, interval seq day))+5, 7) < 5 then 1 else 0 end workdayfrom seq_0_to_21
+------------+-----------+---------+-----------+---------+
| date | dayname | weeknum | dayofweek | workday |
+------------+-----------+---------+-----------+---------+
| 2020-04-14 | Tuesday | 15 | 1 | 1 |
| 2020-04-15 | Wednesday | 15 | 2 | 1 |
| 2020-04-16 | Thursday | 15 | 3 | 1 |
| 2020-04-17 | Friday | 15 | 4 | 1 |
| 2020-04-18 | Saturday | 15 | 5 | 0 |
| 2020-04-19 | Sunday | 16 | 6 | 0 |
| 2020-04-20 | Monday | 16 | 0 | 1 |
| 2020-04-21 | Tuesday | 16 | 1 | 1 |
| 2020-04-22 | Wednesday | 16 | 2 | 1 |
| 2020-04-23 | Thursday | 16 | 3 | 1 |
| 2020-04-24 | Friday | 16 | 4 | 1 |
| 2020-04-25 | Saturday | 16 | 5 | 0 |
| 2020-04-26 | Sunday | 17 | 6 | 0 |
| 2020-04-27 | Monday | 17 | 0 | 1 |
| 2020-04-28 | Tuesday | 17 | 1 | 1 |
| 2020-04-29 | Wednesday | 17 | 2 | 1 |
| 2020-04-30 | Thursday | 17 | 3 | 1 |
| 2020-05-01 | Friday | 17 | 4 | 1 |
| 2020-05-02 | Saturday | 17 | 5 | 0 |
| 2020-05-03 | Sunday | 18 | 6 | 0 |
| 2020-05-04 | Monday | 18 | 0 | 1 |
| 2020-05-05 | Tuesday | 18 | 1 | 1 |
+------------+-----------+---------+-----------+---------+
22 rows in set (0.01 sec)
The sequence table name is dynamic, so to get a sequence from 1 to 5 use the table name seq_1_to_5. It has a column called seq that contains the sequence number
QuickAccess in Windows10 Explorer is quite handy for pinning often-used folders. Recently mine stopped working for some reason. It would not show the items previously pinned, nor would it accept new pins.
After a bit of searching, the fix is:
Below is sample code of a proxy ASP.Net page that queries a TempageR 4E realtime temperature monitor and exposes the temperature to PRTG in order to report and escalate out of range values.
public partial class FetchTemp : System.Web.UI.Page
{
protected void Page_Load(object sender, EventArgs e)
{
System.Net.Sockets.TcpClient client = new System.Net.Sockets.TcpClient(System.Configuration.ConfigurationManager.AppSettings["ip"], 80);
NetworkStream ns = client.GetStream();
byte[] request = System.Text.Encoding.ASCII.GetBytes("GET /getData.htm HTTP/1.1\r\n\r\n");
ns.Write(request, 0, request.Length);
byte[] resp = new byte[2048];
int bytes = -1;
StringBuilder sb = new StringBuilder();
while (bytes != 0)
{
bytes = ns.Read(resp, 0, resp.Length);
sb.Append(System.Text.Encoding.ASCII.GetString(resp, 0, bytes));
}
dynamic obj = JsonConvert.DeserializeObject(sb.ToString());
Response.Write("[" + obj.sensor[0].tempc + "]");
}
}
It calls the getData.htm page, which exposes the device info, sensors and their values as a JSON object. This gets parsed, and the value of the first sensor is written to the Response in blockquotes. The PRTG HTTP Content sensor is configured with the URL of the page (FetchTemp.aspx).
The code uses a TcpClient instance to retrieve the data. The getData.htm page does not return HTTP response headers, which causes HttpWebRequest as well as the built-in PRTG HTTP XML/REST sensor to fail with "The underlying connection was closed unexpectedly", using TcpClient solves this issue.
One of our partners stopped support for SSL3.0 and TLS1.0 on a service that we connect to with a .Net 4.0 application.
Using WireShark we determined that the application was attempting connections using SSL3.0 and TLS1.0 only. Digging into this we found a link mentioning that a registry value needs to be configured for .Net4.0 to be able to use TLS1.0 and above.
Once we configured the registry value and restarted the application, it was able to connect to the remote service.
A recent task involved migrating tens of jobs from Control M to VisualCron. I 'm never in the mood for manual repetitive tasks, so the approach was taken to do it with XSLT, since both Control M and VisualCron support XML config schemas.
VisualCron expects various Ids to be GUIDs, and XSL has no built-in functionality to generate GUIDs, so a plan had to be made. I queried Google and found that one can write extension objects in C# and use them during the translation.
The code for to generate a GUID is very simple:
This is then plugged into the transformation code like this:public class TransformUtils{public string GenerateGuid(){return Guid.NewGuid().ToString();}}
string xmlPath = txtXMLSource.Text;
string xslPath = txtXSLSource.Text;
StringBuilder output = new StringBuilder();
XsltArgumentList arguments = new XsltArgumentList();
arguments.AddExtensionObject("EPS:TransformUtils", new TransformUtils());
using (StringWriter writer = new StringWriter(output))
{
XslCompiledTransform transform = new XslCompiledTransform();
transform.Load(xslPath);
transform.Transform(xmlPath, arguments, writer);
}
Inside the xslt stylesheet the extension function can now be called:
<xsl:value-of select="TransformUtils:GenerateGuid()" />
