Brad McKuhen: 2021

Monday, November 1, 2021

Task Manager in Windows 11

Task Manager in Windows 11

In Windows 10 you can start Task Manger by
   Right click the taskbar >> Task Manager

But that doesn't work anymore!

In Windows 11
Right-click the taskbar in Windows 11 only shows "Taskbar Settings"

So there's three choices:

Via Task Manager shortcut
   Ctrl+Shift+Esc is the direct keyboard shortcut

Via WinX menu
   Right click the Windows start button >> Task Manager
   or
   Press Windows Key+X to get the same pop-up menu >> Task Manager

Via Windows search
   Click start >> type "Task Manager"
   Click the shortcut that says "App"

Thursday, September 30, 2021

nxlog conf file

My nxlog.conf file for the lab

///////////////////////////////////////////////////////////////

Panic Soft

#NoFreeOnExit TRUE

define ROOT C:\Program Files (x86)\nxlog

define CERTDIR %ROOT%\cert

define CONFDIR %ROOT%\conf

define LOGDIR %ROOT%\data

define LOGFILE %LOGDIR%\nxlog.log

LogFile %LOGFILE%

Moduledir %ROOT%\modules

CacheDir %ROOT%\data

Pidfile %ROOT%\data\nxlog.pid

SpoolDir %ROOT%\data

Module xm_gelf

</Extension>

Module im_msvistalog

ReadFromLast FALSE

SavePos TRUE

</Input>

Module om_udp

Host 192.168.1.2

Port 12201

#Exec to_syslog_snare();

OutputType GELF

</Output>

Path from_eventlog => out

</Route>

Module xm_fileop

# Check the size of our log file hourly, rotate if larger than 5MB

Every 1 hour

Exec if (file_exists('%LOGFILE%') and \

(file_size('%LOGFILE%') >= 5M)) \

file_cycle('%LOGFILE%', 8);

</Schedule>

# Rotate our log file every week on Sunday at midnight

When @weekly

Exec if file_exists('%LOGFILE%') file_cycle('%LOGFILE%', 8);

</Schedule>

</Extension>

Monday, September 27, 2021

Graylog Notes

I'm using the Graylog OVA, imported into VirtualBox

I'm setting up a syslog UDP input on Graylog

Need to redirect port 514 to port 1514

sudo iptables -t nat -A PREROUTING -p udp --dport 514 -j REDIRECT --to-port 1514

Monday, August 30, 2021

All Items In Satisfactory (Update 4) (Sorted)

Here's the Satisfactory (Update 4) item list, but alphabetically sorted.

Adaptive Control Unit

AI Limiter

Alclad Aluminum Sheet

Alumina Solution

Aluminum Casing

Aluminum Ingot

Aluminum Scrap

Assembly Director System

Automated Wiring

Battery

Bauxite

Beacon

Biomass

Black Powder

Cable

Caterium Ingot

Caterium Ore

Circuit Board

Coal

Color Cartridge

Compacted Coal

Computer

Concrete

Cooling System

Copper Ingot

Copper Ore

Copper Powder

Copper Sheet

Crude Oil

Crystal Oscillator

Electromagnetic Control Rod

Empty Canister

Empty Fluid Tank

Encased Industrial Beam

Encased Plutonium Cell

Encased Uranium Cell

Fabric

FICSIT Coupon

Flower Petals

Fuel

Fused Modular Frame

Gas Filter

Green Power Slug

Heat Sink

Heavy Modular Frame

Heavy Oil Residue

High-Speed Connector

Iodine Infused Filter

Iron Ingot

Iron Ore

Iron Plate

Iron Rod

Leaves

Limestone

Liquid Biofuel

Magnetic Field Generator

Modular Engine

Modular Frame

Motor

Mycelia

Nitric Acid

Nitrogen Gas

Nobelisk

Non-fissile Uranium

Nuclear Pasta

Packaged Alumina Solution

Packaged Fuel

Packaged Heavy Oil Residue

Packaged Liquid Biofuel

Packaged Nitric Acid

Packaged Nitrogen Gas

Packaged Oil

Packaged Sulfuric Acid

Packaged Turbofuel

Packaged Water

Petroleum Coke

Plastic

Plutonium Fuel Rod

Plutonium Pellet

Plutonium Waste

Polymer Resin

Power Shard

Pressure Conversion Cube

Purple Power Slug

Quantum Computer

Quartz Crystal

Quickwire

Radio Control Unit

Raw Quartz

Reinforced Iron Plate

Rifle Cartridge

Rotor

Rubber

S.A.M. Ore

Screw

Silica

Smart Plating

Solid Biofuel

Spiked Rebar

Stator

Steel Beam

Steel Ingot

Steel Pipe

Sulfur

Sulfuric Acid

Supercomputer

Superposition Oscillator

Thermal Propulsion Rocket

Turbo Motor

Turbofuel

Uranium

Uranium Fuel Rod

Uranium Waste

Versatile Framework

Water

Wire

Wood

Yellow Power Slug

Saturday, August 28, 2021

All Items In Satisfactory (Update 4)

Every so often, I need to have a list of items for a calculation in Satisfactory, and I need a list of all the items. This is from Update 4.

Limestone

Iron Ore

Copper Ore

Caterium Ore

Coal

Raw Quartz

Sulfur

Bauxite

S.A.M. Ore

Uranium

Water

Crude Oil

Heavy Oil Residue

Fuel

Liquid Biofuel

Turbofuel

Alumina Solution

Sulfuric Acid

Nitric Acid

Nitrogen Gas

Concrete

Iron Ingot

Copper Ingot

Caterium Ingot

Steel Ingot

Aluminum Ingot

Quartz Crystal

Polymer Resin

Petroleum Coke

Aluminum Scrap

Copper Powder

Aluminum Casing

Empty Fluid Tank

Silica

Black Powder

Wire

Cable

Iron Rod

Screw

Iron Plate

Reinforced Iron Plate

Copper Sheet

Alclad Aluminum Sheet

Plastic

Rubber

Packaged Water

Packaged Alumina Solution

Packaged Sulfuric Acid

Packaged Nitric Acid

Packaged Nitrogen Gas

Steel Pipe

Steel Beam

Encased Industrial Beam

Green Power Slug

Yellow Power Slug

Purple Power Slug

Flower Petals

Crystal Oscillator

Empty Canister

Fabric

Modular Frame

Heavy Modular Frame

Pressure Conversion Cube

Fused Modular Frame

Rotor

Stator

Motor

Quickwire

Circuit Board

Computer

AI Limiter

High-Speed Connector

Supercomputer

Battery

Heat Sink

Radio Control Unit

Turbo Motor

Electromagnetic Control Rod

Encased Uranium Cell

Non-fissile Uranium

Plutonium Pellet

Encased Plutonium Cell

Cooling System

Quantum Computer

Superposition Oscillator

Beacon

Compacted Coal

Leaves

Mycelia

Wood

Biomass

Packaged Oil

Packaged Heavy Oil Residue

Solid Biofuel

Packaged Fuel

Packaged Liquid Biofuel

Packaged Turbofuel

Uranium Fuel Rod

Plutonium Fuel Rod

Nobelisk

Gas Filter

Color Cartridge

Rifle Cartridge

Spiked Rebar

Iodine Infused Filter

Power Shard

FICSIT Coupon

Smart Plating

Versatile Framework

Automated Wiring

Modular Engine

Adaptive Control Unit

Assembly Director System

Magnetic Field Generator

Thermal Propulsion Rocket

Nuclear Pasta

Uranium Waste

Plutonium Waste

Friday, July 2, 2021

Getting logs related to a specific user login in Ubuntu 20.04

I was having some trouble on Ubuntu 20.04 with figuring out why a Active Directory user couldn't log in to the server via SSH, and eventually came up with this, which was inspired by the link below it.

sudo journalctl | grep <<username>>

From here:

https://serverfault.com/questions/130482/how-to-check-sshd-log

All messages about sshd:

journalctl -t sshd

journalctl -u ssh

Messages about sshd from the last boot:

journalctl -t sshd -b0

Messages about sshd from the last boot in the reverse order:

journalctl -t sshd -b0 -r

Monday, June 21, 2021

Linux Log Locations

Linux log locations

. . . because I never remember

/var/log/messages : General log messages
/var/log/boot : System boot log
/var/log/debug : Debugging log messages
/var/log/auth.log : User login and authentication logs
/var/log/daemon.log : Running services such as squid, ntpd and others log message to this file
/var/log/dmesg : Linux kernel ring buffer log
/var/log/dpkg.log : All binary package log includes package installation and other information
/var/log/faillog : User failed login log file
/var/log/kern.log : Kernel log file
/var/log/lpr.log : Printer log file
/var/log/mail.* : All mail server message log files
/var/log/mysql.* : MySQL server log file
/var/log/user.log : All userlevel logs
/var/log/xorg.0.log : X.org log file
/var/log/apache2/* : Apache web server log files directory
/var/log/lighttpd/* : Lighttpd web server log files directory
/var/log/fsck/* : fsck command log
/var/log/apport.log : Application crash report / log file

Copied from

https://ubuntuforums.org/showthread.php?t=1568706

Friday, May 14, 2021

The trust relationship between this workstation and the primary domain failed (in server core)

I got the error

The trust relationship between this workstation and the primary domain failed

in server core after restoring from a snapshot in VirtualBox.

On my remote management machine, I tried to connect to the machine using Computer Management, which threw this not-quite-helpful error message.

Computer X cannot be managed. Verify that the network path is correct, the computer is available on the network, and that the appropriate Windows Firewall rules are enable on the target computer.

To enable the appropriate Windows Firewall rules on the remote computer, open the Windows Firewall with Advanced Security snap-in, and enable the following Inbound rules:

COM+ Network Access (DCOM-in)
All rules in the Remote Event Log Management group

You can also enable these rules by using Group Policy settings for Windows Firewall with Advanced Security. For servers that are running the Server Core installation option, run the Netsh AdvFirewall command, or the Windows Powershell NetSecurity module.

As originally posted on this page, here's the steps to resolve.

1. Log into the server in question using the non domain admin account.

2. Open the Power Shell and run the command:

$credential = Get-Credential

3. Then run the command:

Reset-ComputerMachinePassword -Server ClosestDomainControllerNameHere

Thursday, February 18, 2021

Revised Script: Indexing and looking for a cursor in an update statement

I ran a QC script over the results of yesterday's cursor counts table, and realized I had made a logical error.

Here's the QC scripts:

select count(*) as counted, 'photos' as [Source] from dbo.photos
union all
select count(*) as counted, 'photos-null votes' as [Source] from dbo.photos where tally is null
union all
select count(*) as counted, 'votes' as [Source] from dbo.votes;

select top 10 * from dbo.photos;
select top 10 * from dbo.votes;
select sum(tally) as TotalVotesCounted from dbo.photos;
select top 10 * from dbo.votes as v left join dbo.photos as p on p.id = v.photoID where p.tally is null

And here's the revised creation script:

set nocount on;
use enron;
go

if object_id('dbo.photos') is null
create table photos (id INT identity(1,1) primary key, photo varbinary(max), tally INT);
else
truncate table dbo.photos;
go

if object_id('dbo.votes') is null
create table votes(id INT identity(1,1) primary key, userID INT, photoID INT);
else
truncate table dbo.votes;
go

DECLARE @counter INT;  
SET @counter = 1;  
WHILE @counter < 500
   BEGIN  
      insert into dbo.photos(photo) values(rand() * 1000)
      SET @counter = @counter + 1  
   END;  
GO  

DECLARE @counter INT, @userid int, @photoid int, @msg varchar(256);  
SET @counter = 1;  
WHILE @counter < 50000
	BEGIN  
		SELECT @userid = rand() * 100;
		select @photoid = rand() * 1000;
		if (@photoid between 1 and 499)
		insert into votes(userid, photoid) values (@userid, @photoid)
		SET @counter = @counter + 1;
	END;  
GO

Wednesday, February 17, 2021

Indexing and looking for a cursor in an update statement

From this page:

http://www.artfulsoftware.com/infotree/qrytip.php?id=531&m=0

I wanted to see if, in SQL Server, this same mySQL query

Could be reproduced
Could be sped up with an index
Would show up as a cursor in the estimated execution plan for the update statement

1. Reproduction

So, yes, this is a fairly simple script to reproduce.

set nocount on;
use enron;
go

if object_id('dbo.photos') is null
create table photos (id INT identity(1,1) primary key, photo varbinary(max), tally INT);
else
truncate table dbo.photos;
go

if object_id('dbo.votes') is null
create table votes(id INT identity(1,1) primary key, userID INT, photoID INT);
else
truncate table dbo.votes;
go

DECLARE @counter INT;  
SET @counter = 1;  
WHILE @counter < 500
   BEGIN  
      insert into dbo.photos(photo) values(rand() * 1000)
      SET @counter = @counter + 1  
   END;  
GO  

DECLARE @counter INT, @userid int, @photoid int, @msg varchar(256);  
SET @counter = 1;  
WHILE @counter < 50000
	BEGIN  
		SELECT @userid = rand() * 100;
		select @photoid = rand() * 1000;
		if (@photoid between 0 and 500)
		insert into votes(userid, photoid) values (@userid, @photoid)
		SET @counter = @counter + 1;
	END;  
GO

However, in my version, I loaded a larger data set into the tables, as I wanted to have enough data to get a measureable difference when applying the index in step two.

Note also, that in my version, the values are randomly generated, but controlled, so they can only be inserted if they match a photo that we expect to actually have.

2. Indexing

Yes, the statement can be sped up with an index.

Here's the properties of the script, before index application:

Here's after applying the index:

It's a third of the cost. Win!

3. Cursor

There are loops - which is expected - but SQL Server doesn't dissolve into an explicit cursor to handle the update.

Friday, February 5, 2021

Installing SQL Server Configuration Manager when missing for remote management

Following up from the previous post, installing Client Tools Connectivity from the SQL Server 2019 DVD/ISO installed the SQL Server Configuration Manager feature into Server Manager & Computer Management within my management VM.

Thursday, February 4, 2021

There is insufficient system memory in resource pool 'default' to run this query

So while running a really generic restore to the SQL Server cluster instance sql1:

USE [master]

RESTORE DATABASE [enron]
FROM DISK = N'\\ServerE\iso\enron.bak'
WITH FILE = 1,
MOVE N'enron_Data' TO N'C:\Data\enron_Data.mdf',
MOVE N'enron_Log' TO N'C:\Data\enron_Log.ldf',
NOUNLOAD, REPLACE, STATS = 5

The error, while descriptive, was interesting because it was "terse" :)

Msg 3224, Level 16, State 2, Line 2

Error: 3224, Severity: 16, State: 2. (Params:). The error is printed in terse mode because there was error during formatting. Tracing, ETW, notifications etc are skipped.

Msg 3013, Level 16, State 1, Line 2

RESTORE DATABASE is terminating abnormally.

Msg 701, Level 17, State 123, Line 2

There is insufficient system memory in resource pool 'default' to run this query.

Completion time: 2021-02-04T03:18:26.1654581-08:00

Turns out, the RAM for the server was still set at it's installation default of 128 MB.

Once that was increased to 1024 MB, the problem magically went away.

Tuesday, February 2, 2021

SSMS Error - An exception occurred while executing a Transact-SQL statement or batch.

I really don't like the errors like this. :(

I'm going to increase the RAM of the servers in the cluster and see if that helps.

TITLE: Microsoft SQL Server Management Studio
------------------------------

Failed to retrieve data for this request. (Microsoft.SqlServer.Management.Sdk.Sfc)

For help, click: https://go.microsoft.com/fwlink?ProdName=Microsoft%20SQL%20Server&LinkId=20476

------------------------------
ADDITIONAL INFORMATION:

An exception occurred while executing a Transact-SQL statement or batch. (Microsoft.SqlServer.ConnectionInfo)

------------------------------

Error: 802, Severity: 16, State: 1. (Params:). The error is printed in terse mode because there was error during formatting. Tracing, ETW, notifications etc are skipped.
(Microsoft SQL Server, Error: 802)

For help, click: http://go.microsoft.com/fwlink?ProdName=Microsoft%20SQL%20Server&ProdVer=15.00.2000&EvtSrc=MSSQLServer&EvtID=802&LinkId=20476

------------------------------
BUTTONS:

OK
------------------------------

Monday, February 1, 2021

Can't see SQL Server Configuration Manager in Computer Management

So according to this doc on MS docs, I should be able to run configuration manager against a remote SQL server from a machine with a GUI.

https://docs.microsoft.com/en-us/sql/database-engine/install-windows/configure-sql-server-on-a-server-core-installation?view=sql-server-ver15

Except, as you can see from the screenshot, "SQL Server Configuration Manager" isn't anywhere in there.

The server is Windows Server Core 2019. MMC is a no-go.

So let's find the .msc, I thought, and so I pointed my File Explorer at c:\windows\system32. So I tried starting it manually, and got the error "Class not registered".

OK, this is Server Core, that's not really all that shocking.

I copied the .msc from my Server Core machine over to the GUI server I have SSMS installed on, and tried running it from there. This is the error I get.

So I'm going to have to figure out how to install the configuration manager without installing SQL Server itself.

Friday, January 22, 2021

pushing and popping in Windows Server Core

This is yet another "daggone it, how DID I forget that????"

I would like to share this URL:

https://superuser.com/questions/282963/browse-an-unc-path-using-windows-cmd-without-mapping-it-to-a-network-drive

Whose answer was:

If you use pushd and popd instead of cd you won't get that UNC error.

pushd <UNC path> will create a temporary virtual drive and get into it.
popd will delete the temporary drive and get you back to the path you were when you entered pushd.

Tuesday, January 19, 2021

New checklist for standing up servers in the VirtualBox UCS domain

It's dev! Don't disable your firewalls in production! Don't run with scissors, either, kids.

Set-DnsClientServerAddress -InterfaceAlias Ethernet -ServerAddresses 192.168.x.x

Rename-Computer "Servername" -restart

Add-Computer –domainname "mydomain" -restart

sconfig, enable remote desktop

shut down

set 1st network adapter to bridged instead of NAT

enable bidrectional clipboard

enable 2nd network adapter

In Command Prompt as Adminsitrator

sc config vds start=auto

net start vds

In powershell as administrator

Set-NetFirewallProfile -Profile Domain,Public,Private -Enabled False

enable-psremoting

Install-WindowsFeature -Name Failover-Clustering -IncludeManagementTools -Restart

Monday, January 18, 2021

MLK Day: Groovelectric

This seems like an appropriate time to post this:

MLK I have a dream - Groovelectric style

It's originally from

http://www.groovelectric.com

Friday, January 15, 2021

Install the PowerShell A/D module

From this page:

How to install the PowerShell Active Directory module

Enable Active Directory module for Windows PowerShell in Remote Server Administration Tools > Role Administration Tools > AD DS and AD LDS Tools.

Thursday, January 14, 2021

How do I know if a Windows feature is installed?

Honestly, every time previously I've tried filtering for Windows Features, I've used some form of variables and/or the PowerShell where-object, and today, I learned the get-windowsfeature cmdlet takes wildcards.

get-windowsfeature "*fs*"

Wednesday, January 13, 2021

Set the friendly name of a physical disk

I need to set the FriendlyName of a PhysicalDisk in PowerShell, but the uniqueID isn't shown.

Use this:

Get-PhysicalDisk | Select-Object SerialNumber,UniqueID

Tuesday, January 12, 2021

Ubuntu: Error pop ups when connecting via xrdp

I can't possibly hope to do justice to the write up of the fix for the error popups while using xrdp on Ubuntu that's found over here:

xRDP – Infamous “Authentication required to refresh system repositories” popup on Ubuntu 19.04 – The correct fix !!

and

xRDP – How to Fix the Infamous system crash popups in Ubuntu 18.04 (and previous versions)

Monday, January 11, 2021

Ubuntu: Errors when installing VirtualBox

I want to install VirtualBox on my Ubuntu 20.04 LTS host, so I run:

sudo apt install virtualbox virtualbox-ext-pack virtualbox-guest-additions-iso

which gives me THIS ugly mess

Setting up virtualbox-dkms (6.1.10-dfsg-1~ubuntu1.20.04.1) ...
Loading new virtualbox-6.1.10 DKMS files...
Building for 5.8.0-36-generic
Building initial module for 5.8.0-36-generic
Error! Bad return status for module build on kernel: 5.8.0-36-generic (x86_64)
Consult /var/lib/dkms/virtualbox/6.1.10/build/make.log for more information.
dpkg: error processing package virtualbox-dkms (--configure):
 installed virtualbox-dkms package post-installation script subprocess returned error exit status 10
dpkg: dependency problems prevent configuration of virtualbox:
 virtualbox depends on virtualbox-dkms (>= 6.1.10-dfsg-1~ubuntu1.20.04.1) | virtualbox-source (>= 6.1.10-dfsg-1~ubu
ntu1.20.04.1) | virtualbox-modules; however:
  Package virtualbox-dkms is not configured yet.
  Package virtualbox-source is not installed.
  Package virtualbox-modules is not installed.
    Package virtualbox-dkms which provides virtualbox-modules is not configured yet.
  
  

  dpkg: error processing package virtualbox (--configure):
   dependency problems - leaving unconfigured
  dpkg: dependency problems prevent configuration of virtualbox-ext-pack:
   virtualbox-ext-pack depends on virtualbox (>= 6.1.10-dfsg-0~) | virtualbox-6.1; however:
    Package virtualbox is not configured yet.
    Package virtualbox-6.1 is not installed.
   virtualbox-ext-pack depends on virtualbox (<< 6.1.10-dfsg-z) | virtualbox-6.1; however:
    Package virtualbox is not configured yet.
    Package virtualbox-6.1 is not installed.
  
  

  dpkNo apport report written because the error message indicates its a followup error from a previous failure.
                                                                                                               No app
  ort report written because the error message indicates its a followup error from a previous failure.
                                                                                                      No apport repor
  t written because MaxReports is reached already
                                                 g: error processing package virtualbox-ext-pack (--configure):
   dependency problems - leaving unconfigured
  dpkg: dependency problems prevent configuration of virtualbox-qt:
   virtualbox-qt depends on virtualbox (= 6.1.10-dfsg-1~ubuntu1.20.04.1); however:
    Package virtualbox is not configured yet.
  

  dpkg: error processing package virtualbox-qt (--configure):
   dependency problems - leaving unconfigured
  Processing triggers for desktop-file-utils (0.24-1ubuntu3) ...
  Processing triggers for mime-support (3.64ubuntu1) ...
  Processing triggers for hicolor-icon-theme (0.17-2) ...
  Processing triggers for gnome-menus (3.36.0-1ubuntu1) ...
  Processing triggers for libc-bin (2.31-0ubuntu9.1) ...
  Processing triggers for systemd (245.4-4ubuntu3.3) ...
  Processing triggers for man-db (2.9.1-1) ...
  Processing triggers for shared-mime-info (1.15-1) ...
  Errors were encountered while processing:
   virtualbox-dkms
   virtualbox
   virtualbox-ext-pack
   virtualbox-qt
  E: Sub-process /usr/bin/dpkg returned an error code (1)

So now, I'm going with Plan B.

sudo apt-get install software–properties–common
wget –q https://www.virtualbox.org/download/oracle_vbox_2016.asc -O- | sudo apt-key add -
wget -q https://www.virtualbox.org/download/oracle_vbox.asc -O- | sudo apt-key add -
sudo add-apt-repository "deb http://download.virtualbox.org/virtualbox/debian focal contrib"
sudo apt update
sudo apt install virtualbox-6.1

However, I *still* get the same error.

Loading new virtualbox-6.1.10 DKMS files...
Building for 5.8.0-36-generic
Building initial module for 5.8.0-36-generic
ERROR: Cannot create report: [Errno 17] File exists: '/var/crash/virtualbox-dkms.0.crash'
Error! Bad return status for module build on kernel: 5.8.0-36-generic (x86_64)
Consult /var/lib/dkms/virtualbox/6.1.10/build/make.log for more information.
dpkg: error processing package virtualbox-dkms (--configure):
 installed virtualbox-dkms package post-installation script subprocess returned error exit status 10
Setting up python2.7 (2.7.18-1~20.04) ...
Setting up libpython2-stdlib:amd64 (2.7.17-2ubuntu4) ...
Setting up python2 (2.7.17-2ubuntu4) ...
Setting up python-is-python2 (2.7.17-4) ...
Setting up virtualbox-6.1 (6.1.16-140961~Ubuntu~eoan) ...
Adding group `vboxusers' (GID 134) ...
Done.
Setting up virtualbox-ext-pack (6.1.10-1~ubuntu1.20.04.1) ...
removing old virtualbox extension packs
virtualbox-ext-pack: downloading: https://download.virtualbox.org/virtualbox/6.1.10/Oracle_VM_VirtualBox_Extension_
Pack-6.1.10.vbox-extpack
The file will be downloaded into /usr/share/virtualbox-ext-pack
License accepted.
0%...10%...20%...30%...40%...50%...60%...70%...80%...90%...100%
Successfully installed "Oracle VM VirtualBox Extension Pack".
Processing triggers for mime-support (3.64ubuntu1) ...
Processing triggers for hicolor-icon-theme (0.17-2) ...
Processing triggers for gnome-menus (3.36.0-1ubuntu1) ...
Processing triggers for libc-bin (2.31-0ubuntu9.1) ...
Processing triggers for systemd (245.4-4ubuntu3.3) ...
Processing triggers for man-db (2.9.1-1) ...
Processing triggers for shared-mime-info (1.15-1) ...
Processing triggers for desktop-file-utils (0.24-1ubuntu3) ...
Errors were encountered while processing:
 virtualbox-dkms
E: Sub-process /usr/bin/dpkg returned an error code (1)

The difference is, this time VirtualBox starts.

Interestingly, when I start VirtualBox, I am immediately chastised for having an out of date version of the extensions (!), and it walks me through downloading and applying the latest version.

Friday, January 8, 2021

Ubuntu: Install xrdp

When I'm connecting from my Windows 10 laptop, I want to use mRemoteNG to keep my machines/connections/thoughts organized. I also run my VMs on an old laptop running Ubuntu, which means I'm using xrdp instead of VNC to connect.

Since I never remember the steps to reinstall xrdp, I'm sharing them here, so I remember next time:

sudo apt install xrdp
sudo systemctl status xrdp
sudo adduser xrdp ssl-cert
sudo systemctl restart xrdp
sudo systemctl status xrdp

Thursday, January 7, 2021

Windows 10: ESENT Error 642

I see a ton of this error in my PC Event Log:

DllHost (7412,D,12) Microsoft.Windows.Search_cw5n1h2txyewy_NOEDP_LEGACY_IDB: The database format feature version 9080 (0x2378) could not be used due to the current database format 1568.20.0, controlled by the parameter 0x410022D8 (8920 | JET_efvAllowHigherPersistedFormat).

Solution:

You can rid yourself of the ESENT Microsoft.Windows.Search entries by going to control panel -> Indexing Options -> Advanced -> Delete and rebuild index.

Found on:

https://answers.microsoft.com/en-us/windows/forum/all/lots-of-event-log-warnings-after-updating-today/c6c9bafd-f1ea-45d2-a340-3d0d7927277b?page=2

Wednesday, January 6, 2021

mySQL: Create a temp table

Quick reference: Create a temp table in mySQL

CREATE TABLE table_t1 (c1 int) ENGINE=MyISAM;

CREATE TABLE table_t2 (c1 int) ENGINE=MEMORY;

CREATE TEMPORARY TABLE table_t3 (c1 int) ENGINE=MyISAM;

CREATE TEMPORARY TABLE table_t4 (c1 int) ENGINE=MEMORY;

Related docs page:

8.4.4 Internal Temporary Table Use in MySQL

Tuesday, January 5, 2021

mySQL: How NOT to edit your mysql.cnf

When I edited my mysql.cnf recently, I forgot the [mysqld] section header, which produced this error on startup:

brad@alienware:/etc/mysql/mysql.conf.d$ systemctl status mysql.service

● mysql.service - MySQL Community Server

Loaded: loaded (/lib/systemd/system/mysql.service; enabled; vendor preset: enabled)

Active: failed (Result: exit-code) since Sat 2020-12-19 19:46:23 EST; 2min 6s ago

Process: 9336 ExecStartPre=/usr/share/mysql/mysql-systemd-start pre (code=exited, status=1/FAILURE)

Dec 19 19:46:23 alienware systemd[1]: mysql.service: Scheduled restart job, restart counter is at 5.

Dec 19 19:46:23 alienware systemd[1]: Stopped MySQL Community Server.

Dec 19 19:46:23 alienware systemd[1]: mysql.service: Start request repeated too quickly.

Dec 19 19:46:23 alienware systemd[1]: mysql.service: Failed with result 'exit-code'.

Dec 19 19:46:23 alienware systemd[1]: Failed to start MySQL Community Server.

A quick check of the verbose help showed an immediately easy "well, duh" moment:

brad@alienware:/etc/mysql/mysql.conf.d$ mysqld --help --verbose

mysqld: [ERROR] Found option without preceding group in config file /etc/mysql/my.cnf at line 22.

mysqld: [ERROR] Fatal error in defaults handling. Program aborted!

Fixed that, and the server started.