C-NET :: PROJECTS

ls -t projects/

C-Net Projects

Old-school tech and modern annoyances. Howtos, solved problems and reference notes on Linux, Windows, networks and the odd piece of old hardware, since 2008.

2026

Excel Conditional Formatting

Two Excel conditional formatting tricks: apply a rule to a whole sheet, and match exact cell values with EXACT().

Windows · Reference

2025

Posting table data to a web API using PowerQuery in Excel

How to send Excel table data to a web API from PowerQuery by building a CSV payload and forcing Excel to make the request.

Howto's · Windows · Solved Problems · Software

2024

Quickly generate a 10 year, base64 encoded, self signed, client cert using OpenSSL

A bash script that makes a self-signed client certificate valid for 10 years with OpenSSL and prints the PFX as base64.

Reference · Solved Problems
PowerShell script to download a certificate and update all IIS sites' bindings

A PowerShell script that downloads a certificate, installs it in the WebHosting store and sets it on every HTTPS binding in IIS.

Reference
What the heck is Windows Antimalware Service scanning all the time?

How to find the files Windows Defender keeps scanning with MpPerformanceRecording, and exclude them to cut CPU use.

Windows · Solved Problems

2023

Forcing an ARRAY() in postgres subqueries

How to stop the PostgreSQL planner from filtering on an IN subquery too late by wrapping the subquery in = ANY(ARRAY(...)).

Reference
TIKI-100 Documentation

Archived scans of manuals and the software catalog for the Norwegian TIKI-100 microcomputer.

Reference

2022

Allowing an empty JSON body, or no Content-Type, in a C# ASP.NET Core API

An ASP.NET Core attribute that accepts requests with an empty body or no Content-Type, avoiding 415 and 400 errors on net6 and older.

Reference · Solved Problems
Moving columns in PowerQuery without naming every column

How to move a column to a given position in Power Query without naming every column, also when merging and expanding tables.

Windows · Reference · Solved Problems
Unpivoting two columns in PostgreSQL

How to unpivot two id columns into one distinct column without NULLs in PostgreSQL, using UNNEST on an array instead of a UNION.

Reference
Recursive PostgreSQL user manager query for PowerBI path value, with loop handling

A recursive PostgreSQL query that builds a manager path for PowerBI's PATH() while it skips loops and missing managers.

Reference
Copying data from a restored postgres database to the live database

How to copy selected rows from a restored PostgreSQL database into the live database with COPY and psql.

Linux · Reference · Software

2021

AWS RDS IAM Login pitfalls and checklist

A checklist for fixing failed IAM database logins to AWS RDS PostgreSQL from ECS containers, the CLI and C#.

Reference
Allowing RDP remote passwords in Windows 10 in 2021

How to stop Windows 10 from prompting for a password when connecting with saved RDP credentials, through a Group Policy setting.

Windows · Reference · Solved Problems
DNS names for VirtualBox client machines

A PowerShell script that adds the IP addresses of running VirtualBox guests to the Windows hosts file, and autostarts chosen VMs headless.

Howto's · Linux · Windows · Reference · Solved Problems
DNS names for Hyper-V client machines

A PowerShell script that keeps the Windows hosts file updated with the IP addresses of running Hyper-V virtual machines.

Howto's · Linux · Windows · Solved Problems
Office Volume License Keys (VLK)

KMS client setup keys for volume-licensed Office 2016, 2019, LTSC 2021 and LTSC 2024 products.

Reference
Finding and killing stuck or mistyped postgresql queries

PostgreSQL queries to list, cancel and terminate running or stuck queries.

Howto's · Reference · Software
Web Echo Service for developers

A pointer to the C-Net Echo Service, which returns the exact HTTP request it receives, for web client and proxy development.

Linux · Reference · Solved Problems
Generating a C# library from swagger.json using Docker for Windows

How to generate a C# client library from a swagger.json URL with swagger-codegen or openapi-generator in Docker for Windows.

Windows · Reference
Remote Desktop (RDP) to a computer that's enrolled in Azure AD

How to connect with Remote Desktop to an Azure AD joined computer from a machine outside the domain, with the .rdp file settings it needs.

Reference

2020

curl SSL fails even with ca-certificates installed

How to fix curl error 60 in a Docker container that has ca-certificates installed, by forcing a certificate rehash.

Linux · Reference · Solved Problems
GLaDOS Voice Generator (weekend project)

Announcement of the GLaDOS Voice Generator, a replacement for an offline GLaDOS speech synthesis site.

Reference · Solved Problems · Software
Perl one-liner to create random passwords

A Perl one-liner that prints a random alphanumeric password of a chosen length.

Linux · Reference
Disable the "Other people are logged on to this computer" message on a Windows VM

A registry setting that stops Windows asking for confirmation when the power button is pressed while other users are logged on.

Reference

2019

How to use Invoke-WebRequest in PowerShell without having to first open Internet Explorer

How to disable the Internet Explorer first-run wizard so Invoke-WebRequest works without -UseBasicParsing.

Reference
“Invalid provider type specified” CryptographicException when accessing the PrivateKey property of a certificate in C#/.Net

How to fix the .Net "Invalid provider type specified" error on a certificate's private key by converting the CNG key to an RSA key with OpenSSL.

Windows · Solved Problems
Docker starts slowly on Raspberry Pi / Raspbian

How to fix Docker taking minutes to start on a Raspberry Pi running Raspbian, caused by a lack of random entropy, by installing haveged.

Howto's · Linux · Solved Problems
Reinstalling a used iMac (20-inch, Early 2008)

How a used iMac (20-inch, Early 2008) was reinstalled from a USB stick after the recovery installer demanded a linked Apple ID.

Rants · Solved Problems
The trust relationship between this workstation and the primary domain failed

How to fix a lost trust relationship with the domain on a restored Windows machine with Reset-ComputerMachinePassword, without rejoining the domain.

Windows · Reference · Solved Problems
Finding the first (default) IPv4 gateway in a Windows batch script

A Windows batch snippet that reads the default IPv4 gateway from route print into a variable.

Reference
Binary pastebin

Announcement of paste.c-net.org, a console friendly pastebin that also accepts binary files.

Linux · Solved Problems

2018

Recovering versioned files from Owncloud's data directory

How to find versioned files in ownCloud's data directory and copy them out with readable timestamped names.

Howto's · Linux · Solved Problems
Who deleted the files from the Windows file server?

How to audit file deletions on a Windows file server and find who deleted a file, with a PowerShell script that reads the Security log.

Windows · Solved Problems
ClipWriter, a PowerShell script that emulates keyboard input to transfer files and text

ClipWriter, an open source PowerShell script that types text, files and directory trees into remote sessions that block pasting and file transfer.

Rants · Windows · Solved Problems
Enable remote management of Windows Server Core and Hyper-V Core

PowerShell commands that enable the firewall rules needed to manage Windows Server Core and Hyper-V Core remotely.

Windows · Reference
Forcing Cygwin to create sane permissions on Windows

How to stop Cygwin from creating incorrectly ordered Windows permissions by adding noacl to the /cygdrive mount options.

Linux · Windows · Solved Problems
Property 'BindToHostTpm' does not exist in class 'Msvm_SecuritySettingData'

How to disable Secure Boot on a Hyper-V Server guest with PowerShell when Hyper-V Manager shows the BindToHostTpm error on the Security tab.

Windows · Solved Problems
Script for creating a compressed image file from a Raspbian SD card

A script that shrinks a Raspbian SD card, zero-fills its free space and saves it as a compressed image file.

Howto's · Linux · Solved Problems
Using external Certificate Authority certificates in a restricted or closed environment

How to find the CRL and OCSP URLs of a public CA certificate and open the pinholes a closed network needs to verify it, on Linux and Windows.

Howto's · Windows
My tweaks to get Kali Linux running well on the GPD Pocket

Tweaks for Kali Linux on the GPD Pocket: no GRUB splash, WiFi and power settings with tlp, lid screen handling and xorg config.

Linux · Reference · Solved Problems
Outlook removes "extra line breaks" from plain text emails: How to stop it

How to stop Outlook from removing line breaks in plain text emails, in Outlook's options or by ending each line with three spaces.

Windows · Solved Problems
How to deal with error 0xC03F6506 when upgrading stubborn Windows 10 Home Edition machines to Pro using a VLK

How to upgrade Windows 10 Home to Pro with the generic upgrade key when activation fails with error 0xC03F6506.

Windows · Solved Problems
Shrinking a Windows 10 installation for small harddrives

How to save disk space on small Windows 10 devices by compressing the operating system files with compact.exe /CompactOS.

Howto's · Windows · Solved Problems
Drivers for the Multicom Talisa U230

A download of the WiFi driver and the other drivers for the Multicom Talisa U230 laptop that Windows Update does not provide.

Windows · Reference · Solved Problems
Checking for required packages on a Debian (or derivative) system

A Bash snippet that checks a list of required Debian packages with a single dpkg-query call and reports the missing ones.

Linux · Reference · Solved Problems
Some tools for my GPD Pocket

Archived copies of AutoHotkey and LidWatcher, used on a GPD Pocket laptop.

Reference
Avoid having Visual Studio put all its floating windows on top

How to stop Visual Studio's floating tool windows from staying on top of other applications on multi-screen setups.

Windows · Solved Problems

2017

Sleeping without a subprocess in Bash, and how to sleep forever

A Bash function that sleeps, or sleeps forever, with the read builtin on a process substitution instead of running the external sleep command.

Howto's · Linux · Solved Problems
Making Windows keep the system clock in UTC

How to make Windows keep the hardware clock in UTC with the RealTimeIsUniversal registry value, for virtual machines and dual boot.

Windows · Solved Problems
Supermicro X10DRL-i manual

A copy of the Supermicro X10DRL-i motherboard manual (MNL-1566), for reference.

Reference
Finding the most expensive recent SQL queries on SQL Server

A SQL Server query on the dynamic management views that lists the most expensive recent queries by reads, writes or CPU time.

Windows · Reference
Creating a local Certificate Authority using OpenSSL

Pointers to guides for running a local OpenSSL certificate authority and adding custom fields to client certificates.

Reference · Solved Problems
Shrinking a Raspbian installation and re-enabling auto expanding for distribution of customized images

How to shrink a customized Raspbian SD card into a small image file that expands again on first boot.

Howto's · Linux · Solved Problems
Handling multiple overlapping VPN client networks with pfSense and a reflector VM

How to reach VPN client networks that overlap your own or each other with pfSense, outbound NAT and a Shorewall reflector VM.

Howto's · Linux · Solved Problems
Making a minimal VPN routing virtual machine to isolate obnoxious VPN clients

How to build a small Debian VM with OpenConnect and Shorewall that routes traffic to a client VPN, kept apart from pfSense.

Howto's · Linux · Solved Problems
BashDB, a single dynamic database table for bash scripts

BashDB, a Bash library that stores a single key and value table with dynamic columns and lists, to keep persistent state in shell scripts.

Howto's · Linux · Solved Problems
Upgrading the Vostro 1700 to beyond maximum specs

Notes on upgrading a Dell Vostro 1700 past its factory maximum with a T9500 CPU and more RAM, and which memory sizes the BIOS accepts.

Rants
How to set the default location for new computers in Active Directory

How to change the default container for new computer accounts in Active Directory with redircmp.

Windows · Reference
Figuring out which session is blocking a query on Microsoft SQL Server (query suspended)

A SQL Server query that shows which session is blocking which, to find the cause of suspended queries and lock waits.

Howto's · Windows · Reference · Solved Problems
Using IPv6 SLAAC with IP forwarding on Debian Stretch ("connect: network is unreachable", no default gateway)

How to make a Debian Stretch host with IP forwarding enabled accept IPv6 router advertisements and get a default route, by setting accept_ra to 2.

Linux · Solved Problems
Exim4 line length in Debian Stretch - "Mail delivery failed: returning message to sender"

How to make Exim4 in Debian Stretch accept emails with lines longer than 998 characters instead of returning them to the sender.

Linux · Solved Problems
Understanding mcelog ECC errors - Which stick of RAM is broken?

How to find the faulty RAM stick from an mcelog ECC error, by matching its memory address to a DIMM slot with dmidecode.

Linux · Solved Problems
Finding duplicate files with Bash

cdupes, a Bash script that finds duplicate files by size and checksum with find and a few pipes, much like fdupes.

Howto's · Linux · Solved Problems
Yamaha Sting owner's manual

A copy of the Yamaha Sting owner's manual as a PDF.

Reference
Cygwin for Windows XP - fast mirror

Where to get the last Cygwin release that works on Windows XP from a fast mirror, and the setup option needed to install from it.

Windows · Solved Problems
The Intel 82579V on Hyper-V Server 2016, installing unsupported network adapters

How to install the Intel 82579V network driver on Hyper-V Server 2016 by editing the driver .inf file and disabling driver signature checks.

Windows · Solved Problems
Killing a process tree, killing a PID and all children

Two Bash functions that kill a process and all its children recursively, or all children of the current script.

Linux · Solved Problems
Making a telnet server with Bash and tcpserver

How to serve a Bash script over telnet with tcpserver, and a function library that handles telnet line endings, ctrl+c and password input.

Linux · Solved Problems
apt-get reports Packages not found

How to fix 404 errors from apt-get update on Debian by removing stale partial package lists, and what else to check if that does not help.

Linux · Solved Problems
Reset dpkg (apt) package configuration to default, restore deleted config files

How to restore a Debian package's deleted or changed config files with dpkg or apt-get and --force-confmiss.

Linux · Reference · Solved Problems
Installing Windows XP on the Dell Vostro 1700

How to install Windows XP on a Dell Vostro 1700, with an F6 floppy of SATA drivers and a collection of the XP drivers that work.

Windows · Reference
Windows Volume License Keys (VLK)

Windows KMS client setup keys for Windows and Windows Server editions, the Windows 10 Pro upgrade key, and the commands to activate with them.

Windows · Reference
Installing Windows XP on the Fujitsu Siemens Esprimo u9200 in 2017

How to install Windows XP on the Fujitsu Siemens Esprimo u9200 with slipstreamed SATA drivers, plus drivers, tweaks and tools.

Howto's · Windows
How to remove the "Favorites" button from Internet Explorer 8 on Windows XP

How to remove the Favorites button from the Internet Explorer 8 favorites bar on Windows XP with the NoCommandBar registry policy.

Windows · Solved Problems
The Windows XP PowerToys, archived here for your pleasure

An archive of the Microsoft PowerToys for Windows XP, with a short description of each tool.

Windows · Solved Problems
Import email from existing POP3 account to Gmail in 2017

Step-by-step screenshots for importing mail from an existing POP3 account into Gmail and sending as that address.

Howto's

2016

Duplicate bind mounts with chroots on systemd

How to stop duplicate bind mounts in chroot jails on systemd by marking the fstab bind mounts private.

Linux · Solved Problems
Setting all SQL Server databases to "simple" recovery model and deleting all the transaction logs

A T-SQL script that sets every user database on SQL Server to the simple recovery model and shrinks its transaction log, also for odd database names.

Howto's · Windows
Debugging SQL Server Query Performance

How to measure SQL Server query time and IO, and how to clear the caches for a clean test.

Howto's · Windows · Software
Force SQL Server Database offline

How to force a SQL Server database offline when active sessions block it, and how to bring it back online.

Howto's · Windows
Automatic Windows Logon on Domain Member Machines

How to enable automatic Windows logon on a domain member machine by setting the WinLogon registry values.

Howto's · Windows · Solved Problems
Shrinking the MS SQL Server "tempdb" (when it won't shrink)

How to shrink the MS SQL Server tempdb database when it refuses to shrink, by freeing the caches first.

Howto's · Windows · Solved Problems
Fixing empty search results in the Windows 10 Settings (the shiny new Control Panel)

How to fix empty search results in the Windows 10 Settings app by toggling content indexing on its LocalState Indexed folder.

Howto's · Windows · Solved Problems
W: [pulseaudio] authkey.c: Failed to open cookie file '/home/user/.config/pulse/cookie': No such file or directory

How to fix the PulseAudio warning about a missing ~/.config/pulse/cookie file by symlinking the old cookie file.

Linux · Solved Problems
Export certificates marked as not exportable in the Windows certificate manager

How to export certificates and private keys marked as not exportable from the Windows certificate store with Mimikatz, and convert them for Wireshark.

Windows · Solved Problems · Software
Some fonts shown as squares in Kali Linux

How to fix fonts shown as squares in Kali Linux by rebuilding the font cache.

Linux · Reference · Solved Problems
My tweaks to Kali Linux (note to self)

A checklist of settings, packages and tweaks for Kali Linux 2016.1: autologin, smartmontools, power button, encrypted swap file and virt-manager.

Linux · Reference
Enabling Quick Launch in Windows 10

How to add the classic Quick Launch toolbar to the Windows 10 taskbar, so pinned programs stay in place.

Windows · Reference · Solved Problems
Find and kill long running MS SQL Server queries

SQL queries to list running MS SQL Server queries by elapsed time and to kill one or all long-running ones.

Windows · Reference · Solved Problems
SPF exists for a reason, and postfix makes it ridiculously easy

What SPF does and does not do for email, with a pointer to a guide for enabling SPF checks in Postfix on Debian and Ubuntu.

Howto's · Linux
pfSense as a Cisco AnyConnect VPN Client using OpenConnect

How to install OpenConnect on pfSense, keep a Cisco AnyConnect VPN connection up from cron and add its interface to the GUI.

Howto's · Linux · Solved Problems
Squid Compile with SSL support under Debian Jessie

How to rebuild the Debian Jessie squid3 package from source with SSL support enabled.

Linux · Reference

2015

Force removal of a package that's "is in a very bad inconsistent state"

How to force dpkg to remove a package that is in a very bad inconsistent state.

Linux · Reference · Solved Problems
Error 0x80041002 from PowerShell after upgrade to Windows 10

How to fix error 0x80041002 from New-ScheduledTaskTrigger after a Windows 10 upgrade by rebuilding the WMI repository with a batch file.

Windows · Solved Problems
A few group policies I use on Windows 10

Group policy settings for Windows 10 that disable the lock screen and prevent the use of OneDrive.

Windows · Reference
Relay UDP broadcasts between subnets in pfSense

A script that relays UDP broadcasts between subnets in pfSense, with tcpdump and tcpreplay.

Linux · Solved Problems
Wiping an (Azure) SQL Server database, deleting all tables

A T-SQL script that drops all foreign keys, tables and views in a SQL Server or Azure SQL database.

Windows · Reference
Mounting and using KVM raw image files on the host system

How to map the partitions of a KVM raw disk image on the host with losetup and kpartx, and how to unmap them again.

Linux · Reference
Hardening IIS and scanning for SSL-related vulnerabilities - IISCrypto

IISCrypto, a tool that sets the registry entries to allow only secure cryptographic algorithms on IIS, with archived copies and a link to an SSL scanner.

Windows · Reference
Tool tip: "vbetool" runs real-mode video BIOS code to alter hardware state

The vbetool manual page: a tool that turns displays on and off and changes video BIOS state from the console.

Linux · Reference
Solution: Using ProxyPass from http to https in apache2 causes AH02032 SNI error

How to fix the AH02032 SNI hostname error when Apache proxies from HTTP to an internal HTTPS server, by turning off ProxyAddHeaders.

Linux · Solved Problems
The fastest way to extend disk image files on Linux

How to grow a virtual machine disk image file on Linux with the truncate tool instead of dd.

Linux · Reference · Solved Problems
Aeon Cobra 50cc (GOES 50s) service manuals and parts lists

Parts lists and service manuals (PDF) for the Aeon Cobra 50cc quad, sold in the Nordic countries as the GOES 50s.

Reference
Using MERGE to insert/update in SQL Server

How to insert or update a row in one statement with MERGE in SQL Server 2008.

Rants · Windows
How to use a gateway outside of the local subnet on Linux

How to route all traffic on Debian through a gateway with a private IP outside the local public subnet.

Howto's · Linux · Solved Problems
MSSQL Mass Delete

How to delete large amounts of data from a SQL Server table in small chunks with DELETE TOP.

Howto's · Windows · Reference · Solved Problems
dovecot: master: Error: systemd listens on port 143, but it’s not configured in Dovecot. Closing.

How to stop Dovecot's systemd socket errors after an upgrade from Debian Wheezy to Jessie by disabling dovecot.socket.

Linux · Solved Problems
Installing Windows Live Essentials on Windows XP - Error: OnCatalogResult: 0x80190194

How to install Windows Live Essentials on Windows XP when the web installer fails with OnCatalogResult 0x80190194, using archived offline installers.

Windows · Solved Problems
Deleting duplicates in SQL Server before adding a Unique Index

How to delete only the duplicate rows in a SQL Server table with ROW_NUMBER() so that a unique index can be added.

Windows · Reference · Solved Problems
Taking a screenshot of an entire page with Firefox, saved as a .png

How to save a full-page screenshot as a PNG with the Firefox developer toolbar.

Linux · Windows · Solved Problems
Disable the startup page in Vistual Studio 2013 Community Edition (and probably all others)

How to disable the start page in Visual Studio 2013 Community Edition.

Windows · Solved Problems
What to do when kill -9 doesn't do anything

A pointer to an explanation of why kill -9 sometimes has no effect on a process.

Linux · Reference
Renaming an MSSQL instance (Invalid Urn filter on server level)

How to fix "Invalid Urn filter on server level" by renaming the SQL Server instance after a host rename.

Windows · Solved Problems
Restarting a VPN client on pfSense through the CLI (SSH)

How to restart an OpenVPN client on pfSense from another machine over SSH with a small script, for a flaky VPN connection.

Howto's · Linux · Solved Problems
Weakening Windows Server 2012

Where to find the Windows Server 2012 settings for password policy, Ctrl+Alt+Del, Shutdown Event Tracker, IE Enhanced Security and remote desktop shadowing.

Windows · Solved Problems
Excellent article about the issues with 24 bit audio

A pointer to an article on xiph.org explaining why 24 bit audio playback is not audibly better, with an archived copy.

Reference
Using a Windows 8 upgrade key for a clean install

How to activate a clean Windows 8 install with an upgrade key by resetting MediaBootInstall and running slmgr /rearm.

Windows · Solved Problems
Writing a newline to separate commands in XChat

How to type a line break in XChat to put several commands on one line.

Linux · Reference
MSSQL Mass Copy

SQL Server batch loops for copying large amounts of data between tables without locking them for a long time.

Windows · Reference
SMPS Repair

A pointer to a useful general guide on repairing switched mode power supplies, with an archived copy.

Reference

2014

Moving Windows' Offline File Cache away from C:\

How to move the Windows Offline Files cache (C:\Windows\CSC) to another drive with a directory junction.

Howto's · Windows
Handler “PageHandlerFactory-Integrated” has a bad module “ManagedPipelineHandler” in its module list

How to fix the IIS ManagedPipelineHandler bad module error by registering ASP.NET 4 with aspnet_regiis -i.

Windows · Reference · Solved Problems
Enabling read_committed_snapshot on an existing MSSQL database

The SQL statements that turn on snapshot isolation and read_committed_snapshot for an existing SQL Server database.

Windows · Reference · Solved Problems
Note to Self: Useful cygwin packages

A short list of useful cygwin packages, with a PowerShell script that installs them.

Rants
Typing the escape character ^] on a non-english keyboard

How to type the telnet escape character ^] on a Norwegian or other non-English keyboard: press Ctrl + 5.

Linux · Reference · Solved Problems
Removing VMware Player or workstation when the Hyper-V role is active

How to uninstall VMware Player or Workstation when the Hyper-V role blocks the uninstaller, by editing bootstrap.lua.

Windows · Reference · Solved Problems
Make exim4 on Debian respect .forward and /etc/aliases when using a smarthost

How to make exim4 on Debian apply /etc/aliases and ~/.forward to outgoing mail when it sends through a smarthost.

Howto's · Linux · Solved Problems
Samba servers show up slowly in Network Neighborhood when VMware is installed

How to make Samba servers show up quickly in Network Neighborhood when VMware network adapters are installed.

Windows · Solved Problems
Resetting an Aeon Labs Z-Stick S2

How to reset an Aeon Labs Z-Stick S2 Z-Wave adapter with the Danfoss ZWave PC Controller, with the manual, driver and firmware.

Windows · Solved Problems · Software
Reverse SSHFS mounts (fs push)

How to mount a file system on a remote machine with sshfs, started from the machine that holds the files, using dpipe and sshfs slave mode.

Howto's · Linux · Solved Problems
regedit access denied

How to edit protected registry keys that give Access Denied even to administrators, by running regedit as SYSTEM with psexec.

Windows · Solved Problems
Removing a WIFI-network in Windows 8

How to list and delete stored WiFi network profiles in Windows 8 with netsh.

Windows · Reference · Solved Problems
Shrinking a vmdk with VMware Player

How to shrink a VMware virtual disk from the command line with VMwareToolboxCmd.

Linux · Reference · Solved Problems

2013

Logging out of a samba file server

How to clear Windows' cached network credentials with net use after a samba password change gives "access denied".

Windows · Solved Problems
Disable screensaver in default desktop Raspbian installation

How to disable the screensaver and screen blanking in the default LXDE desktop on Raspbian.

Linux · Reference
Creating persistent SSH tunnels in Windows using autossh

How to run autossh from Cygwin as a Windows service, to keep an SSH tunnel up with key authentication.

Howto's · Windows
Running PulseAudio in system mode with TCP listening on Debian Wheezy

How to run PulseAudio in system mode on Debian Wheezy with a TCP listener for remote sound over an SSH tunnel.

Howto's · Linux
Mysterious IGMP Query Request packets from 0.0.0.0 to 224.0.0.1

Why a Linux bridge sends IGMP queries from 0.0.0.0 to 224.0.0.1 every two minutes, and how to turn off multicast_snooping to stop them.

Linux · Solved Problems
How to prevent ssh -X from hanging on exit when dbus is used

How to stop ssh -X from hanging on exit when the remote program starts dbus, by launching dbus yourself and killing it afterwards.

Linux · Reference · Solved Problems
Cygwin auto started sshd service as single user on Windows 8

Steps to run the Cygwin sshd service as a specific user without privilege separation on Windows 8, including the firewall rule.

Windows · Reference
Enable username and password in URL in Internet Explorer

How to re-enable usernames and passwords in URLs (http://user:pass@host/) in Internet Explorer through a FeatureControl registry key.

Windows · Solved Problems
One-time passwords in Debian Wheezy with libpam-otpw

How to set up one-time password SSH logins on Debian Wheezy with libpam-otpw.

Howto's · Linux
Disable UAC in Windows 8

How to disable UAC in Windows 8 through secpol.msc or, on non-pro editions, the EnableLUA registry value.

Windows · Reference · Solved Problems

2012

CD-ROM Raspberry Pi case

How an old SCSI CD-ROM drive became a case for a Raspberry Pi, with working front buttons, LEDs, audio and GPIO on the back.

Howto's
Using CheckInstall to track custom source downloads on Debian

How to use CheckInstall to make Debian packages from source installs, so they can be removed with dpkg.

Howto's · Linux
XP Windows Update error 0x8024400A solution

How to fix Windows Update error 0x8024400A on Windows XP by installing Service Pack 3.

Windows · Reference · Solved Problems
ShellShock - a Bash 3 / Bash 4 spaceshooter!

ShellShock, a top-down space shooter written in Bash, and the attention it got when the Bash exploit took the same name.

Linux
Adding http:// back to the URL bar in Firefox

Where to find how to show the http:// prefix in the Firefox URL bar again, with an archived copy of the ghacks.net article.

Reference · Software
Parse long options in bash scripts

A Bash script by geirha that parses both short and long command line options in shell scripts.

Linux · Reference
Pausing and continuing a process on Linux

How to pause and resume a running process on Linux with the STOP and CONT signals.

Howto's · Linux
Linux on Mac Mini - power on after power loss

How to make a Mac Mini running Linux power on again after a power loss, with the command for each Mac Mini model.

Linux · Solved Problems
Cool Software: Batch File Compiler PE

A pointer to Batch File Compiler PE, a tool that compiles batch files into executables and includes a syntax highlighting editor.

Software
Cool Software: PatchMyPC

A pointer to PatchMyPC, a free software updater for Windows, with a local copy of the program.

Software
Cool Software: SlowMP3

SlowMP3 changes the speed and pitch of MP3 files, useful for learning songs by ear; a copy of the program is kept here.

Software
gitolite: 'foo' does not appear to be a git repository - ForceCommand

Why gitolite says a repository does not exist when sshd's ForceCommand or a second ssh key overrides its command= setting in authorized_keys.

Linux · Solved Problems
Creating .deb-Packages With Checkinstall

Why to use checkinstall to wrap a from-source install in a .deb package on Debian, with a pointer to a howto.

Linux · Reference

2011

UDP through SSH

A link to a guide on tunneling UDP traffic through an SSH connection, with an archived copy.

Linux · Reference
Fixing "shmget() failed: No space left on device"

How to clean up shared memory segments left behind by killed x11vnc processes, with a root cron script that reports who left them.

Linux · Solved Problems
SSH in a while loop - stdin problems

Why ssh inside a while read loop only runs once, because ssh consumes stdin, and how the -n option fixes it.

Linux · Reference · Solved Problems
Set php.ini values using .htaccess

How to set php.ini values with php_value lines in an Apache .htaccess file.

Linux · Reference
GCC stray X in program

How to fix GCC's "stray in program" error caused by invalid characters in source code, from building the Intel EMGD driver.

Linux · Reference · Solved Problems
Tell your friends how to burn ISO files properly

A pointer to a guide on burning an ISO image to disc correctly with common Windows burning software.

Windows · Reference
xorg.conf for KVM

An xorg.conf that works for a Linux guest in KVM, with the VESA driver and vmmouse.

Linux · Reference
bash time limit on commands

How to put a time limit on a command using only the shell, with a script based on the pixelbeat.org timeout script.

Howto's · Linux · Solved Problems
Debian APT Pinning properly explained

A pointer to a Debian cheat sheet that explains APT pinning, with an archived PDF copy.

Linux · Reference
Using LD_PRELOAD to override a function

How to override a library function such as getpid with LD_PRELOAD and dlsym(RTLD_NEXT), with a complete example.

Linux · Reference
How difficult is it to misuse the code you write?

Rusty Russell's list of API misuse levels, from impossible to get wrong to impossible to get right.

Rants
Debian and Ubuntu auto-login and Xorg without a display manager

How to log in automatically on a spare TTY with rungetty and start Xorg from .bash_login on Debian and Ubuntu, without a display manager.

Howto's · Linux
Remote desktop does not support colour depth 24; falling back to 16

How to enable 24-bit colour for RDP connections to Windows XP through Group Policy, so rdesktop stops falling back to 16-bit.

Howto's · Windows · Solved Problems
How to Hide a User Account from the Welcome Screen

How to hide a user account from the Windows Welcome screen with the SpecialAccounts registry key.

Windows · Reference
Save and restore partition tables with sfdisk

How to copy a partition table from one drive to a replacement drive with sfdisk, for example when rebuilding an mdadm RAID.

Linux · Reference

2010

sudo without a password

How to let a user run sudo without a password, for all commands or for specific ones, in /etc/sudoers.

Linux · Reference
Using Flags and Arguments in Bash

A small example bash script that parses command line flags and their arguments with getopts.

Linux · Reference
exim4 smarthost smtp password

How to give exim4 a username and password for an authenticated smarthost in /etc/exim4/passwd.client.

Linux · Reference
Use OpenDNS with Smoothwall Express 3.x

How to make Smoothwall Express 3.x use OpenDNS instead of the DNS servers from the ISP's DHCP, by editing rc.updatered.

Linux · Reference
What's touching that config file?!

How to find which Debian package's maintainer script changes a config file, by grepping the postinst scripts in /var/lib/dpkg/info.

Linux · Reference · Solved Problems
OTP (one-time passwords) on Debian Squeeze SSH logins

How to require OPIE one-time passwords for SSH logins on Debian Squeeze with libpam-opie and challenge-response authentication.

Howto's · Linux
Putty keeps disconnecting

How to stop PuTTY SSH sessions from dropping on unstable connections by raising the TCP retransmission limits in the Windows registry.

Windows · Solved Problems
Switching alsa sound cards around

How to change the order of ALSA sound cards and pick the default card with module index options.

Linux · Reference
Windows XP activation doesn't pop up after repair or ghost

How to get into Windows XP when activation will not start after a repair or ghosting, and fix it with a hotfix and Internet Explorer 8.

Howto's · Windows · Solved Problems
Error -6003 during Creative X-fi driver install

How to fix InstallShield error -6003 during the Creative X-Fi driver install by removing a numbered RunTime folder.

Windows · Solved Problems
Avoiding invalid commands in Bash history

How to keep mistyped, not-found commands (exit status 127) out of your Bash history with a PROMPT_COMMAND function.

Howto's · Linux

2009

Hide join/part messages in XChat

How to hide and show join and part messages in XChat with the irc_conf_mode setting.

Linux · Reference
Windows 7 autologin

How to open the user accounts dialog with control userpasswords2 to let Windows 7 log in automatically.

Windows · Reference
XFCE: Unable to perform shutdown

How to fix the XFCE "Unable to perform shutdown" error by allowing the HAL shutdown, reboot and mount actions in PolicyKit.conf.

Linux · Reference
Resizing an ext3 filesystem on an lvm

The steps to shrink an ext3 filesystem and its LVM logical volume with resize2fs and lvreduce, and to give the space to another volume.

Linux · Reference
Moving or removing ~/.xsession-errors

How to move, disable or split ~/.xsession-errors per host by changing ERRFILE in /etc/X11/Xsession on Debian.

Linux · Reference
Wake on Lan on an Intel Mac Mini with Linux

How to enable Wake on LAN and power-on after power loss on an Intel Mac Mini running Linux, with setpci and ethtool.

Linux · Reference
Improve the mouse response and acceleration in Debian

How to patch and rebuild xserver-xorg-core on Debian Lenny for the improved mouse acceleration from Simon Thum's patch.

Howto's · Linux
Compiling and patching debian packages from source

A quick reference on how to compile Debian packages from source, and possibly patching them along the way.

Linux · Reference
Enlightened XFCE4

A howto stolen from http://ubuntuforums.org/showthread.php?t=101066 for later use. All credit to its writer, Iandefor.

Howto's · Linux
Fixing Windows Update errors

A batch file that re-registers the crypto DLLs and resets catroot2 and SoftwareDistribution to fix Windows Update errors.

Windows · Solved Problems
VMware Server and Windows Firewall

How to let VMware Server remote connections through Windows Firewall by allowing vmware-authd.exe instead of port 902/TCP.

Windows · Reference

2008

How to kill a process that uses too much CPU

A Bash script, run from cron, that watches a process's CPU usage and sends an alert e-mail when it goes over a set limit.

Linux · Reference
Norwegian Windows edition on suicide mission

So I downloaded this Debian netinstall image... and Windows went suicidal?

Rants · Linux
Fun with "beep"

How to play notes and simple melodies, such as Für Elise and the Axel F theme, on the PC speaker with the Linux beep program.

Linux
ssh: how to permit root login only from local network / ip

From version 4.3p2, sshd supports an interesting option called Match. At the time of writing, this is the version supplied with Debian Etch (stable).

Howto's
Disable .bash_history logging in bash, Debian

How to stop bash from writing a .bash_history file while keeping the command history of the current session.

Reference
Encrypted swap in Debian

How to encrypt swap in Debian with 256-bit AES and a random key generated at each boot, using cryptsetup and crypttab.

Howto's
Vista file transfer estimates: WTF?

In Windows XP, it seemed like the estimated transfer time of files in a folder, when copying that folder from one place to another, was estimated purely based on the sum of the file sizes and the current transfer speed. It also seemed to have a preference for transferring the larger files first.

Rants
What separates a straight network cable from a crossover network cable

If you're connecting two machines with just a single network cable, like we did with parallell and serial cables back in the days, you've no doubt used a crossover cable. But why is this?

Reference
VESA console modes

A table of VESA mode numbers, in hex and decimal, for the Linux kernel's vga= boot parameter.

Reference
Motorized Madness

A link to an impressive motorized case mod.

Rants
Disable bittorrent in Opera

Where to find the setting that disables the built-in BitTorrent support in the Opera browser.

Reference
Retrieving Opera wand passwords, opera password recovery

How to recover passwords stored in the Opera wand for free, with a power button from the Opera wiki.

Reference
Installing Opera in Debian etch

How to add the Opera apt repository and its signing key to Debian etch, and install the Opera browser.

Reference
Error "Need to reboot the computer" after running Adobe Update Manager

Steps to clear the "Need to reboot the computer" error that Adobe Update Manager keeps showing.

Solved Problems
Performance Tuning VMWare Server

Stole this from http://www.fewt.com/2008/06/performance-tuning-vmware-server-on.html for personal reference. EDIT 2015: The link is now dead, so props to me for doing so. Damn you, Internet.

Reference
Prevent syslog from spamming the console

How to set the klogd options so that syslog messages stay in the log files and are not printed on the console.

Reference
irssi auto-connect and auto-identify

How to make irssi connect, identify and join channels automatically with its built-in commands, without scripts.

Howto's
Configuring the Broadcom 2045A Bluetooth Dongle in Windows

stolen from http://www.harshj.com/2007/02/06/configuring-the-broadcom-2045a-bluetooth-dongle-in-windows/ for personal reference

Reference
Screen size calculator

How to find the widescreen size that keeps the same vertical height as a 4:3 screen, with an aspect ratio calculator.

Rants
ATX power connector pinout

A diagram of the ATX power connector pinout, for reference.

Reference
How to move a mysql database from one box to another

How to move a MySQL database to another server with mysqldump and the mysql client.

Linux · Reference
GPG Error: The following signatures were invalid

A tip for the APT error "The following signatures were invalid" when a transparent proxy is in the way.

Linux · Solved Problems
CIFS VFS No response for cmd n mid...

How to stop CIFS mounts from hanging with "No response for cmd" errors by disabling opportunistic locking.

Linux · Solved Problems
Disable the "No mail" notification on machines which have no local mail

How to stop the "No mail." message at login on machines that send all mail to a smarthost, by editing the pam_mail line in PAM.

Howto's · Linux
Hardware clock fix for Debian on Mac Mini

How to stop the hardware clock on a Mac Mini running Debian from moving back an hour each boot, with the --directisa option.

Linux · Solved Problems
Disable Debian's motd on login

How to stop Debian from showing the message of the day on login by emptying /etc/motd and disabling its regeneration at boot.

Howto's · Linux
Nifty linux oneliners

This is a list of nifty oneliners I often use and just as often forget. Now I have a place to jot them down.

Linux · Reference
Installing vmware from scratch

How to install VMware Server 1.0 and its management interface on a fresh Debian install, including the libraries it needs.

Linux · Reference
The stuff I always install on a Debian box

A list of the packages the author installs on every new Debian box, with a one-line command to install them all.

Linux
SMS Message Recieved Confirmation - IMPLEMENT IT PROPERLY

A rant about how badly mobile phones present SMS delivery reports, and how they should show them.

Rants
How to reset the root password on a Debian machine

How to reset a lost root password on Debian from a live CD or by booting with init=/bin/bash from the GRUB menu.

Howto's · Linux
Intellisense issues in Visual C++ 2005

Basic troubleshooting steps for IntelliSense problems in Visual C++ 2005.

Windows · Reference
VMWare mouse problems - mouse stuck in bottom right corner

How to fix a VMware guest mouse stuck in the bottom right corner after a conversion from Virtual PC.

Solved Problems
Linux fan speed control - speedfan for linux

A short reference for getting lm-sensors and fan speed control working on Linux, as a Linux equivalent of SpeedFan.

Linux · Reference
Yay. Blog.

The first post on this blog.

Rants
Where to rename network interfaces in debian etch

Has your desired eth0 ended up as eth1 and the other way around? Did you put in a new network card, having every config file set to use eth0, and the card shows up as eth1?

Howto's · Linux