From this page:
How to install the PowerShell Active Directory module
Friday, January 15, 2021
Install the PowerShell A/D module
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:
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:
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:
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.
Monday, January 4, 2021
mySQL: Combine strings into a single list
In mySQL, how do I combine strings into a single list? That is, how do I pivot them from rows into a list of values?
First, let's take a look at the data we're dealing with. We have two tables, message and recipientinfo, and we want to show all messages as rows, and instead of having one row per TO recipient, we want to have one row per message, that holds all the people listed on the TO line for each message. To do this, in mySQL, we have the GROUP_CONCAT() function, and in SQL Server, in order to combine values, we have to STUFF() them.
Now, let's take a look at the statements using the Enron data set.
mySQL
SELECT m.sender,
date,
GROUP_CONCAT(r.rvalue) as 'TO'
FROM recipientinfo as r
right JOIN message as m ON r.mid = m.mid
where rtype = 'TO'
GROUP BY m.sender, date
LIMIT 100;
SQL Server
SELECT
m.sender as MsgSender,
m.[date] as MsgDate,
MsgToList = STUFF((
SELECT ',' + r.rvalue
FROM dbo.recipientinfo as r
WHERE r.mid = m.mid and rtype = 'TO'
FOR XML PATH(''), TYPE).value('.', 'NVARCHAR(MAX)'), 1, 1, '')
FROM dbo.[message] as m
Friday, January 1, 2021
Subscribe to:
Posts (Atom)