While moving a WordPress website to the WordPress on App Service recently, I ran into an error message being displayed in the Log steam within the Azure portal. That error message looked basically like this: 2024-04-11T00:10:40.437443394Z: [ERROR] 2024/04/11 00:10:40 [error] 968#968: *3123 upstream sent too big header while reading response header from upstream, client: 169.254.129.1, server: _, request: "POST /wp-admin/admin-ajax.php HTTP/1.1", upstream: "fastcgi://unix:/var/run/php/php-fpm.sock:", host: "{site}", referrer: https://{site}/ The fix for this is to edit the config file for th ..read more

Microsoft Azure has a great feature within it called Private Endpoints. With Private Endpoints, you can connect to the Platform as a Service. The Private Endpoint is configured to use a private IP Address instead of routing your connection over the public Internet. This then lets you disable the public endpoint, closing the service off from the public Internet completely. There’s a little work that sometimes needs to be done with Private DNS zones to make everything function correctly, and everything will work great using Microsoft Edge, Google Chrome, Apple’s Safari, or just about any other w ..read more

One of the great features of running Windows 2022 Virtual Machines (VMs) in Azure is that you can log into them using Entra ID (Azure Active Directory). However, if you deploy a new VM and simply try to log into that VM with the Remote Desktop application (RDP), you’ll be presented with the error message from RDP which says, “The Target Identifier in the Request was not Found in the Tenant”. Thankfully this error message is easy enough to fix, but there are a few steps that you’ll need to take. Fix DNS The first step is to add the machine to DNS. If your VM has a Public IP Address (I don’t re ..read more

Today, World AIDS Day, DCAC is launching its annual matching funds campaign on behalf of the Elizabeth Glaser Pediatric AIDS Foundation (EGPAF). Since 2018, we’ve raised more than $70,000 to support an AIDS-free generation. And there’s still work to do. That’s why DCAC has again pledged to match up to $10,000 in your donations!   It’s easy to participate! From December 1-24. Every dollar you donate to EGPAF gets doubled by DCAC. Donate more, and DCAC donates more…up to $10,000! For 35 years, the Elizabeth Glaser Pediatric AIDS Foundation has led the charge to prioritize children in ..read more

When building automated processes, Microsoft Azure Automation just doesn’t always do the trick. Sometimes, you want third-party PowerShell modules, or you just need to be able to call some legacy application, or you just need access to on-premise resources such as a database server or file server, none of which are doable all that easily (if at all). This means that you need to run them from a physical machine or virtual machine, either on-premises or in the cloud. As our company has been moving to the cloud, the company has been moving to only PaaS services and has not put any virtual machine ..read more

Recently, I upgraded our core Azure SQL Database for MySQL Single Server to Azure SQL Database for MySQL Flex Server. The migration was pretty straight forward and I simply did an export with mysqldump and then an import with MySQL. The problem came up when I tried to use Power BI (PBI) and connect to to the Azure SQL Database for MySQL Flex Server instead. When I tried to connect PBI to the Flex server I kept getting “The given key was not present in the dictionary”. After a ton of searching, and some troubleshooting tips from two differing Microsoft Data Platform MVPs (who both know WAY mor ..read more

If you are a user of Microsoft Azure, there is a breaking change coming. There is good news about this change and bad news. Bad News First, the bad news is that this is a breaking change that requires some changes to your Azure environment. The change is that unless you have a specific method of getting Internet access, such as one of the following, the Virtual Machine(s) will lose Internet Access. Those options are: Azure NAT gateway Azure Load Balancer outbound rules Public IP address attached to the VM If you have one of those three configurations within your Azure environment, there’s n ..read more

Will you be attending the PASS Data Community Summit 2023 or Microsoft Ignite 2023? If you are, we’ve got THE party of the conference for you to attend. DCAC has hosted a welcome Karaoke party at Cow Girls Inc. in downtown Seattle for several years, and we are repeating this event this year and inviting all the attendees from Microsoft Ignite and the PASS Data Community Summit to attend. As is our norm, the event is free to attend; you simply need to sign up and present your ticket at the door (either the physical ticket or via the Event Bright app on your phone). We’ve made a slight change t ..read more

Door and mailbox in the desert If you’ve been on the Internet this week, you probably noticed a bunch of spammers sending emails from random onmicrosoft.com email addresses, and most annoyingly, these SPAM messages are getting through basically every SPAM filter out there. The reason for this is that the email domains are all “legit” domains that have been set up as free trials in Office 365. This means the emails will go out until they hit the limit of emails they can send out. And because the domains have valid SPF settings, the emails won’t get flagged as SPAM. So, how do we block these dom ..read more

Microsoft Azure has a great feature within it called Private Endpoints. With Private Endpoints, you can connect to the Platform as a Service. The Private Endpoint is configured to use a private IP Address instead of routing your connection over the public Internet. This then lets you disable the public endpoint, closing the service off from the public Internet completely. There’s a little work that sometimes needs to be done with Private DNS zones to make everything function correctly, and everything will work great using Microsoft Edge, Google Chrome, Apple’s Safari, or just about any other w ..read more