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


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

Happy New Year - 2021

 Welcome to 2021!


I hope you have a great year!