I love virtualbox. Right up until I don't.
I got this error:
PXE-E06: OptionROM requires DDIM support.
And after some searching, I found messages like this....
PXE-E06: OptionROM requires DDIM support.
The system BIOS does not support DDIM. The BIOS does not support the mapping of the PCI expan-sion ROMs into upper memory as required by the PCI specification. The Intel Boot Agent cannot func-tion in this system. The Intel Boot Agent returns control to the BIOS and does not attempt toremote boot. You may be able to resolve the problem by updating the BIOS on your system. Ifupdating your system's BIOS does not fix the problem, contact your system administrator or yourcomputer vendor's customer support to resolve the problem.
....and....
PXE-E06: Option ROM requires DDIM support.
This message should not be seen in a production BIOS. PCI option ROMs must always be installed as DDIM option ROMs (they must be installed into read/write upper memory).
Eventually, what fixed it?
Delete the File "PXE-Intel.rom" which is located in the Extension Pack directory - in my install, that was
C:\Program Files\Oracle\VirtualBox\ExtensionPacks\Oracle_VM_VirtualBox_Extension_Pack
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
<Extension _gelf>
Module xm_gelf
</Extension>
<Input from_eventlog>
Module im_msvistalog
ReadFromLast FALSE
SavePos TRUE
</Input>
<Output out>
Module om_udp
Host 192.168.1.2
Port 12201
#Exec to_syslog_snare();
OutputType GELF
</Output>
<Route 1>
Path from_eventlog => out
</Route>
<Extension _fileop>
Module xm_fileop
# Check the size of our log file hourly, rotate if larger than 5MB
<Schedule>
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
<Schedule>
When @weekly
Exec if file_exists('%LOGFILE%') file_cycle('%LOGFILE%', 8);
</Schedule>
</Extension>
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
Here's the Satisfactory (Update 4) item list, but alphabetically sorted.
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
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
or
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
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.
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
|
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
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.
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!
There are loops - which is expected - but SQL Server doesn't dissolve into an explicit cursor to handle the update.
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.
So while running a really generic restore to the SQL Server cluster instance sql1:
|
USE [master] RESTORE DATABASE [enron] GO |
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 |
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.
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
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.
1.
Set-DnsClientServerAddress -InterfaceAlias Ethernet -ServerAddresses 192.168.x.x
Rename-Computer "Servername" -restart
2.
Add-Computer –domainname "mydomain" -restart
3.
sconfig, enable remote desktop
shut down
set 1st network adapter to bridged instead of NAT
enable bidrectional clipboard
enable 2nd network adapter
4.
log in via RDP and then
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
This seems like an appropriate time to post this:
MLK I have a dream - Groovelectric style
It's originally from
http://www.groovelectric.com
From this page:
How to install the PowerShell Active Directory module
