Sysadmins of the North (Page 16)

Technical SysOps blog, where topics include Sysadmin, DevOps, computers, servers, web, MySQL, database, virtualization, optimization and security

Create your own CDN using IIS Outbound Rules

Offloading content is important for the performance of your website, because then content is downloaded in parallel and thus faster. A faster website attracts more visitors, is more user friendly, improves CTR and Google SEO. Here is how to create a Content Delivery Network (CDN) using IIS outbound rewrite rules.

Bash: Grep through a large number of files - "Argument list too long"

/bash/grep and /bash/rm give me an error Argument list too long. Here is how to overcome this grep error.

WordPress CMS admin password reset

How to reset your WordPress password? If you've lost or forgotten your WordPress admin password, you can easily reset the password. Either use the following MySQL statement to reset your WordPress admin password, or change it through functions.php.

Fix "Could not establish trust relationship for the SSL/TLS secure channel" error

Here is how to resolve the ASP.NET exception "System.Net.WebException: The underlying connection was closed: Could not establish trust relationship for the SSL/TLS secure channel."

ASP.NET performance: what to keep in mind

A lot of information is available on this subject. In this post I'll share some valuable posts, and I continue to update this post when I find something new. Posts about ASP.NET performance I frequently pass on to customers so they can improve their ASP.NET web applications.

Don't turn off CURLOPT_SSL_VERIFYPEER and fix your PHP configuration

Do not turn off CURLOPT_SSL_VERIFYPEER in your PHP configuration, but learn how to fix your PHP config instead.

Installing Debian GNU/Linux 7.0 (Wheezy) on HP EliteBook 8570w

I was FedUp with Fedora Core 17/18 after a day, so I decided to return to my old love: Debian GNU/Linux. It's been a couple of years, but I'm happy to be back! Just run the netinst installer which will take care of the most.

Connect to SqlCe (SQL Server Compact) database from ASP

Here is how to install the Microsoft.SQLSERVER.CE.OLEDB.4.0 Provider and use classic ASP to connect to an SqlCe (SQL Server Compact) database sdf file, as a Microsoft Access database replacement.

How to send authenticated SMTP over a TLS encrypted connection, in PHP, ASP and ASP.NET?

Learn how to send email securely from your website using TLS with ASP.NET, PHP, WordPress and Classic ASP!

Grep for forensic log parsing and analysis on Windows Server IIS

How to use GnuWin32 ported tools like grep.exe and find.exe for forensic log file analysis in Windows Server.

Drop all tables, SPs, triggers, constraints and dependencies in one SQL statement

Drop all tables, SPs, triggers, constraints and dependencies in an SQL Server database in one SQL statement.

Connect to MS SQL Server with PHP 5.3+

Learn how to conditionally add Google Analytics tracking code to your WordPress Multisite

MySQL Connector/NET and Entity Framework

How to let MySQL Connector/NET and [Entity Framework](https://learn.microsoft.com/en-us/aspnet/entity-framework) play nicely. This blog post is a quicky and an oldy… Since we still receive a reasonable amount of questions about this topic at the customer service of my employer I'm posting this here, with some commonly made mistakes and points of attention.

WordPress 3.5 on IIS 8.0 is unable to save a web.config file

This website Saotn.org is hosted on Windows Server 2012 with IIS 8.0 with WordPress for a few months now, and everything is running very smooth. And I would never hit this bug because I don't need to change my permalinks structure. One of my colleagues on the other hand, just moved his website to an IIS 8.0 web server and he noticed he couldn't save his Permalinks structure in the IIS web.config file. This can be pretty annoying ;-) Quick fix attached...

Create your own PHP based Origin Pull CDN

The advantage of having your website content hosted on a Content Delivery Network (CDN) is having your content distributed and stored across the Globe. Utilizing the network of the Content Delivery Network provider. Hosting your WordPress website on a Content Delivery Network is an important WordPress optimization tip.