Using OpenVPN on Windows instead of VPN apps: missing certificate

Sorry this might be a noob question, but I subscribed to a VPN provider which ships its own app on Windows. Now I thought I’d prefer to use the OpenVPN client app instead.

I create a profile by providing it with a .ovpn file, which contains a block and a block as well.

Upon connecting, OpenVPN fails with “Connection Error. Missing external certificate“.

All those different certificates are quite abstract to me, but I think it needs a “client certificate”. Is it something created for my profile by the VPN provider when I registered? Or can I generate it myself? When trying to add a certificate in the Windows OpenVPN app, I am asked for .p12 files. Also, when hitting “continue” (without external certificate), the connection never establishes.

For comparison, when putting .ovpn file in Linux in Network-Manager, it works out of the box.

What is the missing step or package? It’s never made clear on the VPN provider help pages.

watchos – Why does the Watch app on my iPhone state that my apps will need to be updated during setup when I already have the latest versions installed?

When pairing an Apple Watch to my iPhone, I’ve noticed that even though the App Store lists all of my apps being up-to-date, the Watch app on my iPhone states that several of my iOS apps will be updated for compatibility before their watchOS counterparts will be sent over to my Watch. Is this a standard message that appears – even if all iOS apps on the paired iPhone are fully updated to the latest versions?

microsoft office – Can I use Power Apps with users that sign in from B2C?

I’m a little confused about power apps and the pricing. Suppose I want to create a dog walking website and app and in there have a form connect to the Common Data Service (or other storage).

  • Is this possible to accomplish without having to pay a monthly per customer charge? I don’t want to add $15 per customer as one can imagine?

If Power Apps is used in corporate scenarios, I can see how they can charge that much per seat… it’s like InfoPath on the server with maybe Dynamics.

Why is it possible for all programs / apps to see all network traffic?

Sniffing network traffic is typically a privileged action. An unprivileged user does not have the ability to perform a packet capture by default.

You have outlined two scenarios (HTTP Canary and Wireshark) that require special privileges. In the first case, HTTP Canary must be explicitly enabled as a VPN by the device owner. An app cannot obtain this privilege on its own, and a user should not grant this privilege to an app that they do not trust to view all of their traffic.

In the second case, an unprivileged user cannot sniff using Wireshark without extra privileges. On Linux, this means being a member of the system “wireshark” group, or running it as root. On Windows, I believe this requires a driver installation that needs administrator privileges.

Since it requires extra privileges anyway, I don’t think it really is a concern related to sandboxing. To conclude, packet sniffing is not something trivial that any application can do without acquiring special privileges. Even then, lots of traffic will not be visible since HTTPS is used almost universally.

accessibility – Does WCAG (2.1) apply to native (iOS, Android) mobile apps?

WCAG stands for Web Content Accessibility Guidelines, but it never defines what is meant by “web content”.

Many of the success criteria are defined in terms of “user agent” as if they meant a web browser, but the WCAG 2.0 Glossary defines “user agent” again in the terms of “web content”, while it also mentions a “media player” as an example of a user agent that “…helps retrieving and rendering Web content”. So if a stream of video data is considered web content, then even multiplayer video games can be considered as rendering web content?

Then there is this 2015 document How WCAG 2.0 and Other W3C/WAI Guidelines Apply to Mobile that specifically mentions “…native applications (also known as “mobile apps”)”, but then it says “(the document) provides informative guidance, but does not set requirements.”

I am perplexed.

My question: Does the WCAG 2.1 success criteria apply to native (iOS, Android) mobile apps?

appletv – Remote, game controllers can’t control apps on Apple TV until apps are relaunched

I play games on my 4th-gen Apple TV running tvOS 13.4 and frequently switch between using several SteelSeries controllers and the Apple TV remote. For about the last 4 months or so, when I go back into an app that I was previously using and am coming back to, I can’t move the cursor (or selection) until I force quit the app and re-launch it.

If the controller works in the app, the remote will not, until relaunched. If the remote works with the app, the controller won’t until relaunched.

Some examples of apps that have this behavior are Netflix, YouTube, Sky Force Reloaded, and others.

I can’t tell if Apple changed an API (as they frequently do) causing apps to break, or if this is a bug with the OS. It’s a pretty annoying problem to have, and wonder if this is documented or there’s a solution.

How to use google apps script to validate a cell?

/** @OnlyCurrentDoc */
function myFunction() {

  var app = SpreadsheetApp
  var activeSheet = app.getActiveSpreadsheet().getActiveSheet();


  for (var i = 1; i<10; i++) {

   var workingcell = activeSheet.getRange(i,1).getValue();
    if( workingcell == "TRUE" ) { 

       activeSheet.getRange(i,2).setValue("Incorrect Data");
       }

  else {activeSheet.getRange(i,2).setValue("DD Data");}    

}
}