tag:blogger.com,1999:blog-37185856686042046382024-03-13T03:05:24.992-07:00Brad McKuhenSQL Server DBA, Developer, Architect, Author, PresenterAdminhttp://www.blogger.com/profile/09960815938346726074noreply@blogger.comBlogger300125tag:blogger.com,1999:blog-3718585668604204638.post-16284968934956594122024-03-01T06:54:00.000-08:002024-03-01T06:54:47.806-08:00kwargs_from_env() got an unexpected keyword argument 'ssl_version'<div>I'm getting the error </div><div>kwargs_from_env() got an unexpected keyword argument 'ssl_version'</div><div>when trying to start my docker instance.</div><div><br /></div>In searching for a solution to this insanity, I ran across <a href="https://stackoverflow.com/questions/77641240/getting-docker-compose-typeerror-kwargs-from-env-got-an-unexpected-keyword-ar" rel="nofollow" target="_blank">this article</a>, which led me to update the command line I was using.<br /><br />So I changed the command from this:<br />docker-compose -f docker-compose.arm64 up -d<br /><br />To this:<div>docker compose -f docker-compose.arm64 up -d<br /><br /><br /><br /><br /><br /></div>Adminhttp://www.blogger.com/profile/09960815938346726074noreply@blogger.com0tag:blogger.com,1999:blog-3718585668604204638.post-21066835648374157162023-07-18T06:00:00.001-07:002023-07-18T06:00:00.147-07:00PXE-E06: OptionROM requires DDIM support.<p> I love virtualbox. Right up until I don't.</p><p><br /></p><p>I got this error:</p><p><br /></p><p>PXE-E06: OptionROM requires DDIM support.</p><p><br /></p><p>And after some searching, I found messages like this....</p><p><br /></p><p></p><blockquote><p>PXE-E06: OptionROM requires DDIM support.</p><p>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.</p></blockquote><p></p><p>....and....</p><blockquote><p>PXE-E06: Option ROM requires DDIM support.</p><p>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).</p><p></p></blockquote><p><br /></p><p>Eventually, what fixed it?</p><p>Delete the File "PXE-Intel.rom" which is located in the Extension Pack directory - in my install, that was </p><p>C:\Program Files\Oracle\VirtualBox\ExtensionPacks\Oracle_VM_VirtualBox_Extension_Pack</p><div><br /></div><p><br /></p><p><br /></p><p><br /></p><p><br /></p><p><br /></p>Adminhttp://www.blogger.com/profile/09960815938346726074noreply@blogger.com0tag:blogger.com,1999:blog-3718585668604204638.post-88663237414306320702021-11-01T09:00:00.002-07:002021-11-01T09:00:00.164-07:00Task Manager in Windows 11Task Manager in Windows 11<br /><br />In Windows 10 you can start Task Manger by<br /><span> </span>Right click the taskbar >> Task Manager<br /><br />But that doesn't work anymore!<br /><br />In Windows 11<br />Right-click the taskbar in Windows 11 only shows "Taskbar Settings"<br /><br />So there's three choices:<br /><br />Via Task Manager shortcut<br /><span> </span>Ctrl+Shift+Esc is the direct keyboard shortcut<br /><br />Via WinX menu<br /><span> </span>Right click the Windows start button >> Task Manager<br /><span> </span>or<br /><span> </span>Press Windows Key+X to get the same pop-up menu >> Task Manager<br /><br />Via Windows search<br /><span> </span>Click start >> type "Task Manager"<br /><span> </span>Click the shortcut that says "App"<br /><br /><br /><br /><br /><br /><br /><br /><br /><br /><br /><br /><br /><br /><br /><br /><br /><br /><br /><br /><br /><br /><br />Adminhttp://www.blogger.com/profile/09960815938346726074noreply@blogger.com0tag:blogger.com,1999:blog-3718585668604204638.post-54618053923114132732021-09-30T09:00:00.001-07:002021-09-30T09:00:00.232-07:00nxlog conf file<p> My nxlog.conf file for the lab</p><p><br /></p><p>///////////////////////////////////////////////////////////////</p><p><br /></p><p>Panic Soft</p><p>#NoFreeOnExit TRUE</p><p><br /></p><p>define ROOT C:\Program Files (x86)\nxlog</p><p>define CERTDIR %ROOT%\cert</p><p>define CONFDIR %ROOT%\conf</p><p>define LOGDIR %ROOT%\data</p><p>define LOGFILE %LOGDIR%\nxlog.log</p><p>LogFile %LOGFILE%</p><p><br /></p><p>Moduledir %ROOT%\modules</p><p>CacheDir %ROOT%\data</p><p>Pidfile %ROOT%\data\nxlog.pid</p><p>SpoolDir %ROOT%\data</p><p><br /></p><p><Extension _gelf></p><p> Module xm_gelf</p><p></Extension></p><p><Input from_eventlog></p><p> Module im_msvistalog</p><p> ReadFromLast FALSE</p><p> SavePos TRUE</p><p></Input></p><p><Output out></p><p> Module om_udp </p><p> Host 192.168.1.2</p><p> Port 12201</p><p> #Exec to_syslog_snare();</p><p> OutputType GELF</p><p></Output></p><p><Route 1></p><p> Path from_eventlog => out</p><p></Route></p><p><br /></p><p><Extension _fileop></p><p> Module xm_fileop</p><p><br /></p><p> # Check the size of our log file hourly, rotate if larger than 5MB</p><p> <Schedule></p><p> Every 1 hour</p><p> Exec if (file_exists('%LOGFILE%') and \</p><p> (file_size('%LOGFILE%') >= 5M)) \</p><p> file_cycle('%LOGFILE%', 8);</p><p> </Schedule></p><p><br /></p><p> # Rotate our log file every week on Sunday at midnight</p><p> <Schedule></p><p> When @weekly</p><p> Exec if file_exists('%LOGFILE%') file_cycle('%LOGFILE%', 8);</p><p> </Schedule></p><p></Extension></p><p><br /></p>Adminhttp://www.blogger.com/profile/09960815938346726074noreply@blogger.com0tag:blogger.com,1999:blog-3718585668604204638.post-17401155111745436292021-09-27T09:00:00.005-07:002021-09-27T09:00:00.196-07:00Graylog Notes<p>I'm using the Graylog OVA, imported into VirtualBox</p><p>I'm setting up a syslog UDP input on Graylog </p><p>Need to redirect port 514 to port 1514</p><p>sudo iptables -t nat -A PREROUTING -p udp --dport 514 -j REDIRECT --to-port 1514</p><p><br /></p><p><br /></p>Adminhttp://www.blogger.com/profile/09960815938346726074noreply@blogger.com0tag:blogger.com,1999:blog-3718585668604204638.post-85399486328345120952021-08-30T09:00:00.002-07:002021-08-30T09:00:00.222-07:00All Items In Satisfactory (Update 4) (Sorted)<p> Here's the Satisfactory (Update 4) item list, but alphabetically sorted.</p><p><br /></p><p><br /></p><p><google-sheets-html-origin></google-sheets-html-origin></p><table border="1" cellpadding="0" cellspacing="0" dir="ltr" style="border-collapse: collapse; border: none; font-family: Arial; font-size: 10pt; table-layout: fixed; width: 0px;" xmlns="http://www.w3.org/1999/xhtml"><colgroup><col width="23"></col></colgroup><tbody><tr style="height: 21px;"><td data-sheets-value="{"1":2,"2":"Adaptive Control Unit"}" style="border-color: rgb(204, 204, 204) transparent rgb(204, 204, 204) rgb(204, 204, 204); border-image: initial; border-style: solid; border-width: 1px; overflow: visible; padding: 2px 0px; vertical-align: bottom;"><div style="left: 3px; overflow: hidden; position: relative; white-space: nowrap; width: 138px;"><div style="float: left;">Adaptive Control Unit</div></div></td></tr><tr style="height: 21px;"><td data-sheets-value="{"1":2,"2":"AI Limiter"}" style="border-color: rgb(204, 204, 204) transparent rgb(204, 204, 204) rgb(204, 204, 204); border-image: initial; border-style: solid; border-width: 1px; overflow: visible; padding: 2px 0px; vertical-align: bottom;"><div style="left: 3px; overflow: hidden; position: relative; white-space: nowrap; width: 66px;"><div style="float: left;">AI Limiter</div></div></td></tr><tr style="height: 21px;"><td data-sheets-value="{"1":2,"2":"Alclad Aluminum Sheet"}" style="border-color: rgb(204, 204, 204) transparent rgb(204, 204, 204) rgb(204, 204, 204); border-image: initial; border-style: solid; border-width: 1px; overflow: visible; padding: 2px 0px; vertical-align: bottom;"><div style="left: 3px; overflow: hidden; position: relative; white-space: nowrap; width: 138px;"><div style="float: left;">Alclad Aluminum Sheet</div></div></td></tr><tr style="height: 21px;"><td data-sheets-value="{"1":2,"2":"Alumina Solution"}" style="border-color: rgb(204, 204, 204) transparent rgb(204, 204, 204) rgb(204, 204, 204); border-image: initial; border-style: solid; border-width: 1px; overflow: visible; padding: 2px 0px; vertical-align: bottom;"><div style="left: 3px; overflow: hidden; position: relative; white-space: nowrap; width: 114px;"><div style="float: left;">Alumina Solution</div></div></td></tr><tr style="height: 21px;"><td data-sheets-value="{"1":2,"2":"Aluminum Casing"}" style="border-color: rgb(204, 204, 204) transparent rgb(204, 204, 204) rgb(204, 204, 204); border-image: initial; border-style: solid; border-width: 1px; overflow: visible; padding: 2px 0px; vertical-align: bottom;"><div style="left: 3px; overflow: hidden; position: relative; white-space: nowrap; width: 114px;"><div style="float: left;">Aluminum Casing</div></div></td></tr><tr style="height: 21px;"><td data-sheets-value="{"1":2,"2":"Aluminum Ingot"}" style="border-color: rgb(204, 204, 204) transparent rgb(204, 204, 204) rgb(204, 204, 204); border-image: initial; border-style: solid; border-width: 1px; overflow: visible; padding: 2px 0px; vertical-align: bottom;"><div style="left: 3px; overflow: hidden; position: relative; white-space: nowrap; width: 90px;"><div style="float: left;">Aluminum Ingot</div></div></td></tr><tr style="height: 21px;"><td data-sheets-value="{"1":2,"2":"Aluminum Scrap"}" style="border-color: rgb(204, 204, 204) transparent rgb(204, 204, 204) rgb(204, 204, 204); border-image: initial; border-style: solid; border-width: 1px; overflow: visible; padding: 2px 0px; vertical-align: bottom;"><div style="left: 3px; overflow: hidden; position: relative; white-space: nowrap; width: 114px;"><div style="float: left;">Aluminum Scrap</div></div></td></tr><tr style="height: 21px;"><td data-sheets-value="{"1":2,"2":"Assembly Director System"}" style="border-color: rgb(204, 204, 204) transparent rgb(204, 204, 204) rgb(204, 204, 204); border-image: initial; border-style: solid; border-width: 1px; overflow: visible; padding: 2px 0px; vertical-align: bottom;"><div style="left: 3px; overflow: hidden; position: relative; white-space: nowrap; width: 162px;"><div style="float: left;">Assembly Director System</div></div></td></tr><tr style="height: 21px;"><td data-sheets-value="{"1":2,"2":"Automated Wiring"}" style="border-color: rgb(204, 204, 204) transparent rgb(204, 204, 204) rgb(204, 204, 204); border-image: initial; border-style: solid; border-width: 1px; overflow: visible; padding: 2px 0px; vertical-align: bottom;"><div style="left: 3px; overflow: hidden; position: relative; white-space: nowrap; width: 114px;"><div style="float: left;">Automated Wiring</div></div></td></tr><tr style="height: 21px;"><td data-sheets-value="{"1":2,"2":"Battery"}" style="border-color: rgb(204, 204, 204) transparent rgb(204, 204, 204) rgb(204, 204, 204); border-image: initial; border-style: solid; border-width: 1px; overflow: visible; padding: 2px 0px; vertical-align: bottom;"><div style="left: 3px; overflow: hidden; position: relative; white-space: nowrap; width: 42px;"><div style="float: left;">Battery</div></div></td></tr><tr style="height: 21px;"><td data-sheets-value="{"1":2,"2":"Bauxite"}" style="border-color: rgb(204, 204, 204) transparent rgb(204, 204, 204) rgb(204, 204, 204); border-image: initial; border-style: solid; border-width: 1px; overflow: visible; padding: 2px 0px; vertical-align: bottom;"><div style="left: 3px; overflow: hidden; position: relative; white-space: nowrap; width: 42px;"><div style="float: left;">Bauxite</div></div></td></tr><tr style="height: 21px;"><td data-sheets-value="{"1":2,"2":"Beacon"}" style="border-color: rgb(204, 204, 204) transparent rgb(204, 204, 204) rgb(204, 204, 204); border-image: initial; border-style: solid; border-width: 1px; overflow: visible; padding: 2px 0px; vertical-align: bottom;"><div style="left: 3px; overflow: hidden; position: relative; white-space: nowrap; width: 42px;"><div style="float: left;">Beacon</div></div></td></tr><tr style="height: 21px;"><td data-sheets-value="{"1":2,"2":"Biomass"}" style="border-color: rgb(204, 204, 204) transparent rgb(204, 204, 204) rgb(204, 204, 204); border-image: initial; border-style: solid; border-width: 1px; overflow: visible; padding: 2px 0px; vertical-align: bottom;"><div style="left: 3px; overflow: hidden; position: relative; white-space: nowrap; width: 66px;"><div style="float: left;">Biomass</div></div></td></tr><tr style="height: 21px;"><td data-sheets-value="{"1":2,"2":"Black Powder"}" style="border-color: rgb(204, 204, 204) transparent rgb(204, 204, 204) rgb(204, 204, 204); border-image: initial; border-style: solid; border-width: 1px; overflow: visible; padding: 2px 0px; vertical-align: bottom;"><div style="left: 3px; overflow: hidden; position: relative; white-space: nowrap; width: 90px;"><div style="float: left;">Black Powder</div></div></td></tr><tr style="height: 21px;"><td data-sheets-value="{"1":2,"2":"Cable"}" style="border-color: rgb(204, 204, 204) transparent rgb(204, 204, 204) rgb(204, 204, 204); border-image: initial; border-style: solid; border-width: 1px; overflow: visible; padding: 2px 0px; vertical-align: bottom;"><div style="left: 3px; overflow: hidden; position: relative; white-space: nowrap; width: 42px;"><div style="float: left;">Cable</div></div></td></tr><tr style="height: 21px;"><td data-sheets-value="{"1":2,"2":"Caterium Ingot"}" style="border-color: rgb(204, 204, 204) transparent rgb(204, 204, 204) rgb(204, 204, 204); border-image: initial; border-style: solid; border-width: 1px; overflow: visible; padding: 2px 0px; vertical-align: bottom;"><div style="left: 3px; overflow: hidden; position: relative; white-space: nowrap; width: 90px;"><div style="float: left;">Caterium Ingot</div></div></td></tr><tr style="height: 21px;"><td data-sheets-value="{"1":2,"2":"Caterium Ore"}" style="border-color: rgb(204, 204, 204) transparent rgb(204, 204, 204) rgb(204, 204, 204); border-image: initial; border-style: solid; border-width: 1px; overflow: visible; padding: 2px 0px; vertical-align: bottom;"><div style="left: 3px; overflow: hidden; position: relative; white-space: nowrap; width: 90px;"><div style="float: left;">Caterium Ore</div></div></td></tr><tr style="height: 21px;"><td data-sheets-value="{"1":2,"2":"Circuit Board"}" style="border-color: rgb(204, 204, 204) transparent rgb(204, 204, 204) rgb(204, 204, 204); border-image: initial; border-style: solid; border-width: 1px; overflow: visible; padding: 2px 0px; vertical-align: bottom;"><div style="left: 3px; overflow: hidden; position: relative; white-space: nowrap; width: 90px;"><div style="float: left;">Circuit Board</div></div></td></tr><tr style="height: 21px;"><td data-sheets-value="{"1":2,"2":"Coal"}" style="border-color: rgb(204, 204, 204) transparent rgb(204, 204, 204) rgb(204, 204, 204); border-image: initial; border-style: solid; border-width: 1px; overflow: visible; padding: 2px 0px; vertical-align: bottom;"><div style="left: 3px; overflow: hidden; position: relative; white-space: nowrap; width: 42px;"><div style="float: left;">Coal</div></div></td></tr><tr style="height: 21px;"><td data-sheets-value="{"1":2,"2":"Color Cartridge"}" style="border-color: rgb(204, 204, 204) transparent rgb(204, 204, 204) rgb(204, 204, 204); border-image: initial; border-style: solid; border-width: 1px; overflow: visible; padding: 2px 0px; vertical-align: bottom;"><div style="left: 3px; overflow: hidden; position: relative; white-space: nowrap; width: 90px;"><div style="float: left;">Color Cartridge</div></div></td></tr><tr style="height: 21px;"><td data-sheets-value="{"1":2,"2":"Compacted Coal"}" style="border-color: rgb(204, 204, 204) transparent rgb(204, 204, 204) rgb(204, 204, 204); border-image: initial; border-style: solid; border-width: 1px; overflow: visible; padding: 2px 0px; vertical-align: bottom;"><div style="left: 3px; overflow: hidden; position: relative; white-space: nowrap; width: 114px;"><div style="float: left;">Compacted Coal</div></div></td></tr><tr style="height: 21px;"><td data-sheets-value="{"1":2,"2":"Computer"}" style="border-color: rgb(204, 204, 204) transparent rgb(204, 204, 204) rgb(204, 204, 204); border-image: initial; border-style: solid; border-width: 1px; overflow: visible; padding: 2px 0px; vertical-align: bottom;"><div style="left: 3px; overflow: hidden; position: relative; white-space: nowrap; width: 66px;"><div style="float: left;">Computer</div></div></td></tr><tr style="height: 21px;"><td data-sheets-value="{"1":2,"2":"Concrete"}" style="border-color: rgb(204, 204, 204) transparent rgb(204, 204, 204) rgb(204, 204, 204); border-image: initial; border-style: solid; border-width: 1px; overflow: visible; padding: 2px 0px; vertical-align: bottom;"><div style="left: 3px; overflow: hidden; position: relative; white-space: nowrap; width: 66px;"><div style="float: left;">Concrete</div></div></td></tr><tr style="height: 21px;"><td data-sheets-value="{"1":2,"2":"Cooling System"}" style="border-color: rgb(204, 204, 204) transparent rgb(204, 204, 204) rgb(204, 204, 204); border-image: initial; border-style: solid; border-width: 1px; overflow: visible; padding: 2px 0px; vertical-align: bottom;"><div style="left: 3px; overflow: hidden; position: relative; white-space: nowrap; width: 90px;"><div style="float: left;">Cooling System</div></div></td></tr><tr style="height: 21px;"><td data-sheets-value="{"1":2,"2":"Copper Ingot"}" style="border-color: rgb(204, 204, 204) transparent rgb(204, 204, 204) rgb(204, 204, 204); border-image: initial; border-style: solid; border-width: 1px; overflow: visible; padding: 2px 0px; vertical-align: bottom;"><div style="left: 3px; overflow: hidden; position: relative; white-space: nowrap; width: 90px;"><div style="float: left;">Copper Ingot</div></div></td></tr><tr style="height: 21px;"><td data-sheets-value="{"1":2,"2":"Copper Ore"}" style="border-color: rgb(204, 204, 204) transparent rgb(204, 204, 204) rgb(204, 204, 204); border-image: initial; border-style: solid; border-width: 1px; overflow: visible; padding: 2px 0px; vertical-align: bottom;"><div style="left: 3px; overflow: hidden; position: relative; white-space: nowrap; width: 90px;"><div style="float: left;">Copper Ore</div></div></td></tr><tr style="height: 21px;"><td data-sheets-value="{"1":2,"2":"Copper Powder"}" style="border-color: rgb(204, 204, 204) transparent rgb(204, 204, 204) rgb(204, 204, 204); border-image: initial; border-style: solid; border-width: 1px; overflow: visible; padding: 2px 0px; vertical-align: bottom;"><div style="left: 3px; overflow: hidden; position: relative; white-space: nowrap; width: 90px;"><div style="float: left;">Copper Powder</div></div></td></tr><tr style="height: 21px;"><td data-sheets-value="{"1":2,"2":"Copper Sheet"}" style="border-color: rgb(204, 204, 204) transparent rgb(204, 204, 204) rgb(204, 204, 204); border-image: initial; border-style: solid; border-width: 1px; overflow: visible; padding: 2px 0px; vertical-align: bottom;"><div style="left: 3px; overflow: hidden; position: relative; white-space: nowrap; width: 90px;"><div style="float: left;">Copper Sheet</div></div></td></tr><tr style="height: 21px;"><td data-sheets-value="{"1":2,"2":"Crude Oil"}" style="border-color: rgb(204, 204, 204) transparent rgb(204, 204, 204) rgb(204, 204, 204); border-image: initial; border-style: solid; border-width: 1px; overflow: visible; padding: 2px 0px; vertical-align: bottom;"><div style="left: 3px; overflow: hidden; position: relative; white-space: nowrap; width: 66px;"><div style="float: left;">Crude Oil</div></div></td></tr><tr style="height: 21px;"><td data-sheets-value="{"1":2,"2":"Crystal Oscillator"}" style="border-color: rgb(204, 204, 204) transparent rgb(204, 204, 204) rgb(204, 204, 204); border-image: initial; border-style: solid; border-width: 1px; overflow: visible; padding: 2px 0px; vertical-align: bottom;"><div style="left: 3px; overflow: hidden; position: relative; white-space: nowrap; width: 114px;"><div style="float: left;">Crystal Oscillator</div></div></td></tr><tr style="height: 21px;"><td data-sheets-value="{"1":2,"2":"Electromagnetic Control Rod"}" style="border-color: rgb(204, 204, 204) transparent rgb(204, 204, 204) rgb(204, 204, 204); border-image: initial; border-style: solid; border-width: 1px; overflow: visible; padding: 2px 0px; vertical-align: bottom;"><div style="left: 3px; overflow: hidden; position: relative; white-space: nowrap; width: 186px;"><div style="float: left;">Electromagnetic Control Rod</div></div></td></tr><tr style="height: 21px;"><td data-sheets-value="{"1":2,"2":"Empty Canister"}" style="border-color: rgb(204, 204, 204) transparent rgb(204, 204, 204) rgb(204, 204, 204); border-image: initial; border-style: solid; border-width: 1px; overflow: visible; padding: 2px 0px; vertical-align: bottom;"><div style="left: 3px; overflow: hidden; position: relative; white-space: nowrap; width: 90px;"><div style="float: left;">Empty Canister</div></div></td></tr><tr style="height: 21px;"><td data-sheets-value="{"1":2,"2":"Empty Fluid Tank"}" style="border-color: rgb(204, 204, 204) transparent rgb(204, 204, 204) rgb(204, 204, 204); border-image: initial; border-style: solid; border-width: 1px; overflow: visible; padding: 2px 0px; vertical-align: bottom;"><div style="left: 3px; overflow: hidden; position: relative; white-space: nowrap; width: 114px;"><div style="float: left;">Empty Fluid Tank</div></div></td></tr><tr style="height: 21px;"><td data-sheets-value="{"1":2,"2":"Encased Industrial Beam"}" style="border-color: rgb(204, 204, 204) transparent rgb(204, 204, 204) rgb(204, 204, 204); border-image: initial; border-style: solid; border-width: 1px; overflow: visible; padding: 2px 0px; vertical-align: bottom;"><div style="left: 3px; overflow: hidden; position: relative; white-space: nowrap; width: 162px;"><div style="float: left;">Encased Industrial Beam</div></div></td></tr><tr style="height: 21px;"><td data-sheets-value="{"1":2,"2":"Encased Plutonium Cell"}" style="border-color: rgb(204, 204, 204) transparent rgb(204, 204, 204) rgb(204, 204, 204); border-image: initial; border-style: solid; border-width: 1px; overflow: visible; padding: 2px 0px; vertical-align: bottom;"><div style="left: 3px; overflow: hidden; position: relative; white-space: nowrap; width: 162px;"><div style="float: left;">Encased Plutonium Cell</div></div></td></tr><tr style="height: 21px;"><td data-sheets-value="{"1":2,"2":"Encased Uranium Cell"}" style="border-color: rgb(204, 204, 204) transparent rgb(204, 204, 204) rgb(204, 204, 204); border-image: initial; border-style: solid; border-width: 1px; overflow: visible; padding: 2px 0px; vertical-align: bottom;"><div style="left: 3px; overflow: hidden; position: relative; white-space: nowrap; width: 138px;"><div style="float: left;">Encased Uranium Cell</div></div></td></tr><tr style="height: 21px;"><td data-sheets-value="{"1":2,"2":"Fabric"}" style="border-color: rgb(204, 204, 204) transparent rgb(204, 204, 204) rgb(204, 204, 204); border-image: initial; border-style: solid; border-width: 1px; overflow: visible; padding: 2px 0px; vertical-align: bottom;"><div style="left: 3px; overflow: hidden; position: relative; white-space: nowrap; width: 42px;"><div style="float: left;">Fabric</div></div></td></tr><tr style="height: 21px;"><td data-sheets-value="{"1":2,"2":"FICSIT Coupon"}" style="border-color: rgb(204, 204, 204) transparent rgb(204, 204, 204) rgb(204, 204, 204); border-image: initial; border-style: solid; border-width: 1px; overflow: visible; padding: 2px 0px; vertical-align: bottom;"><div style="left: 3px; overflow: hidden; position: relative; white-space: nowrap; width: 90px;"><div style="float: left;">FICSIT Coupon</div></div></td></tr><tr style="height: 21px;"><td data-sheets-value="{"1":2,"2":"Flower Petals"}" style="border-color: rgb(204, 204, 204) transparent rgb(204, 204, 204) rgb(204, 204, 204); border-image: initial; border-style: solid; border-width: 1px; overflow: visible; padding: 2px 0px; vertical-align: bottom;"><div style="left: 3px; overflow: hidden; position: relative; white-space: nowrap; width: 90px;"><div style="float: left;">Flower Petals</div></div></td></tr><tr style="height: 21px;"><td data-sheets-value="{"1":2,"2":"Fuel"}" style="border-color: rgb(204, 204, 204) transparent rgb(204, 204, 204) rgb(204, 204, 204); border-image: initial; border-style: solid; border-width: 1px; overflow: visible; padding: 2px 0px; vertical-align: bottom;"><div style="left: 3px; overflow: hidden; position: relative; white-space: nowrap; width: 42px;"><div style="float: left;">Fuel</div></div></td></tr><tr style="height: 21px;"><td data-sheets-value="{"1":2,"2":"Fused Modular Frame"}" style="border-color: rgb(204, 204, 204) transparent rgb(204, 204, 204) rgb(204, 204, 204); border-image: initial; border-style: solid; border-width: 1px; overflow: visible; padding: 2px 0px; vertical-align: bottom;"><div style="left: 3px; overflow: hidden; position: relative; white-space: nowrap; width: 138px;"><div style="float: left;">Fused Modular Frame</div></div></td></tr><tr style="height: 21px;"><td data-sheets-value="{"1":2,"2":"Gas Filter"}" style="border-color: rgb(204, 204, 204) transparent rgb(204, 204, 204) rgb(204, 204, 204); border-image: initial; border-style: solid; border-width: 1px; overflow: visible; padding: 2px 0px; vertical-align: bottom;"><div style="left: 3px; overflow: hidden; position: relative; white-space: nowrap; width: 66px;"><div style="float: left;">Gas Filter</div></div></td></tr><tr style="height: 21px;"><td data-sheets-value="{"1":2,"2":"Green Power Slug"}" style="border-color: rgb(204, 204, 204) transparent rgb(204, 204, 204) rgb(204, 204, 204); border-image: initial; border-style: solid; border-width: 1px; overflow: visible; padding: 2px 0px; vertical-align: bottom;"><div style="left: 3px; overflow: hidden; position: relative; white-space: nowrap; width: 114px;"><div style="float: left;">Green Power Slug</div></div></td></tr><tr style="height: 21px;"><td data-sheets-value="{"1":2,"2":"Heat Sink"}" style="border-color: rgb(204, 204, 204) transparent rgb(204, 204, 204) rgb(204, 204, 204); border-image: initial; border-style: solid; border-width: 1px; overflow: visible; padding: 2px 0px; vertical-align: bottom;"><div style="left: 3px; overflow: hidden; position: relative; white-space: nowrap; width: 66px;"><div style="float: left;">Heat Sink</div></div></td></tr><tr style="height: 21px;"><td data-sheets-value="{"1":2,"2":"Heavy Modular Frame"}" style="border-color: rgb(204, 204, 204) transparent rgb(204, 204, 204) rgb(204, 204, 204); border-image: initial; border-style: solid; border-width: 1px; overflow: visible; padding: 2px 0px; vertical-align: bottom;"><div style="left: 3px; overflow: hidden; position: relative; white-space: nowrap; width: 138px;"><div style="float: left;">Heavy Modular Frame</div></div></td></tr><tr style="height: 21px;"><td data-sheets-value="{"1":2,"2":"Heavy Oil Residue"}" style="border-color: rgb(204, 204, 204) transparent rgb(204, 204, 204) rgb(204, 204, 204); border-image: initial; border-style: solid; border-width: 1px; overflow: visible; padding: 2px 0px; vertical-align: bottom;"><div style="left: 3px; overflow: hidden; position: relative; white-space: nowrap; width: 114px;"><div style="float: left;">Heavy Oil Residue</div></div></td></tr><tr style="height: 21px;"><td data-sheets-value="{"1":2,"2":"High-Speed Connector"}" style="border-color: rgb(204, 204, 204) transparent rgb(204, 204, 204) rgb(204, 204, 204); border-image: initial; border-style: solid; border-width: 1px; overflow: visible; padding: 2px 0px; vertical-align: bottom;"><div style="left: 3px; overflow: hidden; position: relative; white-space: nowrap; width: 138px;"><div style="float: left;">High-Speed Connector</div></div></td></tr><tr style="height: 21px;"><td data-sheets-value="{"1":2,"2":"Iodine Infused Filter"}" style="border-color: rgb(204, 204, 204) transparent rgb(204, 204, 204) rgb(204, 204, 204); border-image: initial; border-style: solid; border-width: 1px; overflow: visible; padding: 2px 0px; vertical-align: bottom;"><div style="left: 3px; overflow: hidden; position: relative; white-space: nowrap; width: 114px;"><div style="float: left;">Iodine Infused Filter</div></div></td></tr><tr style="height: 21px;"><td data-sheets-value="{"1":2,"2":"Iron Ingot"}" style="border-color: rgb(204, 204, 204) transparent rgb(204, 204, 204) rgb(204, 204, 204); border-image: initial; border-style: solid; border-width: 1px; overflow: visible; padding: 2px 0px; vertical-align: bottom;"><div style="left: 3px; overflow: hidden; position: relative; white-space: nowrap; width: 66px;"><div style="float: left;">Iron Ingot</div></div></td></tr><tr style="height: 21px;"><td data-sheets-value="{"1":2,"2":"Iron Ore"}" style="border-color: rgb(204, 204, 204) transparent rgb(204, 204, 204) rgb(204, 204, 204); border-image: initial; border-style: solid; border-width: 1px; overflow: visible; padding: 2px 0px; vertical-align: bottom;"><div style="left: 3px; overflow: hidden; position: relative; white-space: nowrap; width: 66px;"><div style="float: left;">Iron Ore</div></div></td></tr><tr style="height: 21px;"><td data-sheets-value="{"1":2,"2":"Iron Plate"}" style="border-color: rgb(204, 204, 204) transparent rgb(204, 204, 204) rgb(204, 204, 204); border-image: initial; border-style: solid; border-width: 1px; overflow: visible; padding: 2px 0px; vertical-align: bottom;"><div style="left: 3px; overflow: hidden; position: relative; white-space: nowrap; width: 66px;"><div style="float: left;">Iron Plate</div></div></td></tr><tr style="height: 21px;"><td data-sheets-value="{"1":2,"2":"Iron Rod"}" style="border-color: rgb(204, 204, 204) transparent rgb(204, 204, 204) rgb(204, 204, 204); border-image: initial; border-style: solid; border-width: 1px; overflow: visible; padding: 2px 0px; vertical-align: bottom;"><div style="left: 3px; overflow: hidden; position: relative; white-space: nowrap; width: 66px;"><div style="float: left;">Iron Rod</div></div></td></tr><tr style="height: 21px;"><td data-sheets-value="{"1":2,"2":"Leaves"}" style="border-color: rgb(204, 204, 204) transparent rgb(204, 204, 204) rgb(204, 204, 204); border-image: initial; border-style: solid; border-width: 1px; overflow: visible; padding: 2px 0px; vertical-align: bottom;"><div style="left: 3px; overflow: hidden; position: relative; white-space: nowrap; width: 42px;"><div style="float: left;">Leaves</div></div></td></tr><tr style="height: 21px;"><td data-sheets-value="{"1":2,"2":"Limestone"}" style="border-color: rgb(204, 204, 204) transparent rgb(204, 204, 204) rgb(204, 204, 204); border-image: initial; border-style: solid; border-width: 1px; overflow: visible; padding: 2px 0px; vertical-align: bottom;"><div style="left: 3px; overflow: hidden; position: relative; white-space: nowrap; width: 66px;"><div style="float: left;">Limestone</div></div></td></tr><tr style="height: 21px;"><td data-sheets-value="{"1":2,"2":"Liquid Biofuel"}" style="border-color: rgb(204, 204, 204) transparent rgb(204, 204, 204) rgb(204, 204, 204); border-image: initial; border-style: solid; border-width: 1px; overflow: visible; padding: 2px 0px; vertical-align: bottom;"><div style="left: 3px; overflow: hidden; position: relative; white-space: nowrap; width: 90px;"><div style="float: left;">Liquid Biofuel</div></div></td></tr><tr style="height: 21px;"><td data-sheets-value="{"1":2,"2":"Magnetic Field Generator"}" style="border-color: rgb(204, 204, 204) transparent rgb(204, 204, 204) rgb(204, 204, 204); border-image: initial; border-style: solid; border-width: 1px; overflow: visible; padding: 2px 0px; vertical-align: bottom;"><div style="left: 3px; overflow: hidden; position: relative; white-space: nowrap; width: 162px;"><div style="float: left;">Magnetic Field Generator</div></div></td></tr><tr style="height: 21px;"><td data-sheets-value="{"1":2,"2":"Modular Engine"}" style="border-color: rgb(204, 204, 204) transparent rgb(204, 204, 204) rgb(204, 204, 204); border-image: initial; border-style: solid; border-width: 1px; overflow: visible; padding: 2px 0px; vertical-align: bottom;"><div style="left: 3px; overflow: hidden; position: relative; white-space: nowrap; width: 90px;"><div style="float: left;">Modular Engine</div></div></td></tr><tr style="height: 21px;"><td data-sheets-value="{"1":2,"2":"Modular Frame"}" style="border-color: rgb(204, 204, 204) transparent rgb(204, 204, 204) rgb(204, 204, 204); border-image: initial; border-style: solid; border-width: 1px; overflow: visible; padding: 2px 0px; vertical-align: bottom;"><div style="left: 3px; overflow: hidden; position: relative; white-space: nowrap; width: 90px;"><div style="float: left;">Modular Frame</div></div></td></tr><tr style="height: 21px;"><td data-sheets-value="{"1":2,"2":"Motor"}" style="border-color: rgb(204, 204, 204) transparent rgb(204, 204, 204) rgb(204, 204, 204); border-image: initial; border-style: solid; border-width: 1px; overflow: visible; padding: 2px 0px; vertical-align: bottom;"><div style="left: 3px; overflow: hidden; position: relative; white-space: nowrap; width: 42px;"><div style="float: left;">Motor</div></div></td></tr><tr style="height: 21px;"><td data-sheets-value="{"1":2,"2":"Mycelia"}" style="border-color: rgb(204, 204, 204) transparent rgb(204, 204, 204) rgb(204, 204, 204); border-image: initial; border-style: solid; border-width: 1px; overflow: visible; padding: 2px 0px; vertical-align: bottom;"><div style="left: 3px; overflow: hidden; position: relative; white-space: nowrap; width: 42px;"><div style="float: left;">Mycelia</div></div></td></tr><tr style="height: 21px;"><td data-sheets-value="{"1":2,"2":"Nitric Acid"}" style="border-color: rgb(204, 204, 204) transparent rgb(204, 204, 204) rgb(204, 204, 204); border-image: initial; border-style: solid; border-width: 1px; overflow: visible; padding: 2px 0px; vertical-align: bottom;"><div style="left: 3px; overflow: hidden; position: relative; white-space: nowrap; width: 66px;"><div style="float: left;">Nitric Acid</div></div></td></tr><tr style="height: 21px;"><td data-sheets-value="{"1":2,"2":"Nitrogen Gas"}" style="border-color: rgb(204, 204, 204) transparent rgb(204, 204, 204) rgb(204, 204, 204); border-image: initial; border-style: solid; border-width: 1px; overflow: visible; padding: 2px 0px; vertical-align: bottom;"><div style="left: 3px; overflow: hidden; position: relative; white-space: nowrap; width: 90px;"><div style="float: left;">Nitrogen Gas</div></div></td></tr><tr style="height: 21px;"><td data-sheets-value="{"1":2,"2":"Nobelisk"}" style="border-color: rgb(204, 204, 204) transparent rgb(204, 204, 204) rgb(204, 204, 204); border-image: initial; border-style: solid; border-width: 1px; overflow: visible; padding: 2px 0px; vertical-align: bottom;"><div style="left: 3px; overflow: hidden; position: relative; white-space: nowrap; width: 66px;"><div style="float: left;">Nobelisk</div></div></td></tr><tr style="height: 21px;"><td data-sheets-value="{"1":2,"2":"Non-fissile Uranium"}" style="border-color: rgb(204, 204, 204) transparent rgb(204, 204, 204) rgb(204, 204, 204); border-image: initial; border-style: solid; border-width: 1px; overflow: visible; padding: 2px 0px; vertical-align: bottom;"><div style="left: 3px; overflow: hidden; position: relative; white-space: nowrap; width: 114px;"><div style="float: left;">Non-fissile Uranium</div></div></td></tr><tr style="height: 21px;"><td data-sheets-value="{"1":2,"2":"Nuclear Pasta"}" style="border-color: rgb(204, 204, 204) transparent rgb(204, 204, 204) rgb(204, 204, 204); border-image: initial; border-style: solid; border-width: 1px; overflow: visible; padding: 2px 0px; vertical-align: bottom;"><div style="left: 3px; overflow: hidden; position: relative; white-space: nowrap; width: 90px;"><div style="float: left;">Nuclear Pasta</div></div></td></tr><tr style="height: 21px;"><td data-sheets-value="{"1":2,"2":"Packaged Alumina Solution"}" style="border-color: rgb(204, 204, 204) transparent rgb(204, 204, 204) rgb(204, 204, 204); border-image: initial; border-style: solid; border-width: 1px; overflow: visible; padding: 2px 0px; vertical-align: bottom;"><div style="left: 3px; overflow: hidden; position: relative; white-space: nowrap; width: 162px;"><div style="float: left;">Packaged Alumina Solution</div></div></td></tr><tr style="height: 21px;"><td data-sheets-value="{"1":2,"2":"Packaged Fuel"}" style="border-color: rgb(204, 204, 204) transparent rgb(204, 204, 204) rgb(204, 204, 204); border-image: initial; border-style: solid; border-width: 1px; overflow: visible; padding: 2px 0px; vertical-align: bottom;"><div style="left: 3px; overflow: hidden; position: relative; white-space: nowrap; width: 90px;"><div style="float: left;">Packaged Fuel</div></div></td></tr><tr style="height: 21px;"><td data-sheets-value="{"1":2,"2":"Packaged Heavy Oil Residue"}" style="border-color: rgb(204, 204, 204) transparent rgb(204, 204, 204) rgb(204, 204, 204); border-image: initial; border-style: solid; border-width: 1px; overflow: visible; padding: 2px 0px; vertical-align: bottom;"><div style="left: 3px; overflow: hidden; position: relative; white-space: nowrap; width: 186px;"><div style="float: left;">Packaged Heavy Oil Residue</div></div></td></tr><tr style="height: 21px;"><td data-sheets-value="{"1":2,"2":"Packaged Liquid Biofuel"}" style="border-color: rgb(204, 204, 204) transparent rgb(204, 204, 204) rgb(204, 204, 204); border-image: initial; border-style: solid; border-width: 1px; overflow: visible; padding: 2px 0px; vertical-align: bottom;"><div style="left: 3px; overflow: hidden; position: relative; white-space: nowrap; width: 162px;"><div style="float: left;">Packaged Liquid Biofuel</div></div></td></tr><tr style="height: 21px;"><td data-sheets-value="{"1":2,"2":"Packaged Nitric Acid"}" style="border-color: rgb(204, 204, 204) transparent rgb(204, 204, 204) rgb(204, 204, 204); border-image: initial; border-style: solid; border-width: 1px; overflow: visible; padding: 2px 0px; vertical-align: bottom;"><div style="left: 3px; overflow: hidden; position: relative; white-space: nowrap; width: 138px;"><div style="float: left;">Packaged Nitric Acid</div></div></td></tr><tr style="height: 21px;"><td data-sheets-value="{"1":2,"2":"Packaged Nitrogen Gas"}" style="border-color: rgb(204, 204, 204) transparent rgb(204, 204, 204) rgb(204, 204, 204); border-image: initial; border-style: solid; border-width: 1px; overflow: visible; padding: 2px 0px; vertical-align: bottom;"><div style="left: 3px; overflow: hidden; position: relative; white-space: nowrap; width: 162px;"><div style="float: left;">Packaged Nitrogen Gas</div></div></td></tr><tr style="height: 21px;"><td data-sheets-value="{"1":2,"2":"Packaged Oil"}" style="border-color: rgb(204, 204, 204) transparent rgb(204, 204, 204) rgb(204, 204, 204); border-image: initial; border-style: solid; border-width: 1px; overflow: visible; padding: 2px 0px; vertical-align: bottom;"><div style="left: 3px; overflow: hidden; position: relative; white-space: nowrap; width: 90px;"><div style="float: left;">Packaged Oil</div></div></td></tr><tr style="height: 21px;"><td data-sheets-value="{"1":2,"2":"Packaged Sulfuric Acid"}" style="border-color: rgb(204, 204, 204) transparent rgb(204, 204, 204) rgb(204, 204, 204); border-image: initial; border-style: solid; border-width: 1px; overflow: visible; padding: 2px 0px; vertical-align: bottom;"><div style="left: 3px; overflow: hidden; position: relative; white-space: nowrap; width: 138px;"><div style="float: left;">Packaged Sulfuric Acid</div></div></td></tr><tr style="height: 21px;"><td data-sheets-value="{"1":2,"2":"Packaged Turbofuel"}" style="border-color: rgb(204, 204, 204) transparent rgb(204, 204, 204) rgb(204, 204, 204); border-image: initial; border-style: solid; border-width: 1px; overflow: visible; padding: 2px 0px; vertical-align: bottom;"><div style="left: 3px; overflow: hidden; position: relative; white-space: nowrap; width: 138px;"><div style="float: left;">Packaged Turbofuel</div></div></td></tr><tr style="height: 21px;"><td data-sheets-value="{"1":2,"2":"Packaged Water"}" style="border-color: rgb(204, 204, 204) transparent rgb(204, 204, 204) rgb(204, 204, 204); border-image: initial; border-style: solid; border-width: 1px; overflow: visible; padding: 2px 0px; vertical-align: bottom;"><div style="left: 3px; overflow: hidden; position: relative; white-space: nowrap; width: 114px;"><div style="float: left;">Packaged Water</div></div></td></tr><tr style="height: 21px;"><td data-sheets-value="{"1":2,"2":"Petroleum Coke"}" style="border-color: rgb(204, 204, 204) transparent rgb(204, 204, 204) rgb(204, 204, 204); border-image: initial; border-style: solid; border-width: 1px; overflow: visible; padding: 2px 0px; vertical-align: bottom;"><div style="left: 3px; overflow: hidden; position: relative; white-space: nowrap; width: 114px;"><div style="float: left;">Petroleum Coke</div></div></td></tr><tr style="height: 21px;"><td data-sheets-value="{"1":2,"2":"Plastic"}" style="border-color: rgb(204, 204, 204) transparent rgb(204, 204, 204) rgb(204, 204, 204); border-image: initial; border-style: solid; border-width: 1px; overflow: visible; padding: 2px 0px; vertical-align: bottom;"><div style="left: 3px; overflow: hidden; position: relative; white-space: nowrap; width: 42px;"><div style="float: left;">Plastic</div></div></td></tr><tr style="height: 21px;"><td data-sheets-value="{"1":2,"2":"Plutonium Fuel Rod"}" style="border-color: rgb(204, 204, 204) transparent rgb(204, 204, 204) rgb(204, 204, 204); border-image: initial; border-style: solid; border-width: 1px; overflow: visible; padding: 2px 0px; vertical-align: bottom;"><div style="left: 3px; overflow: hidden; position: relative; white-space: nowrap; width: 114px;"><div style="float: left;">Plutonium Fuel Rod</div></div></td></tr><tr style="height: 21px;"><td data-sheets-value="{"1":2,"2":"Plutonium Pellet"}" style="border-color: rgb(204, 204, 204) transparent rgb(204, 204, 204) rgb(204, 204, 204); border-image: initial; border-style: solid; border-width: 1px; overflow: visible; padding: 2px 0px; vertical-align: bottom;"><div style="left: 3px; overflow: hidden; position: relative; white-space: nowrap; width: 114px;"><div style="float: left;">Plutonium Pellet</div></div></td></tr><tr style="height: 21px;"><td data-sheets-value="{"1":2,"2":"Plutonium Waste"}" style="border-color: rgb(204, 204, 204) transparent rgb(204, 204, 204) rgb(204, 204, 204); border-image: initial; border-style: solid; border-width: 1px; overflow: visible; padding: 2px 0px; vertical-align: bottom;"><div style="left: 3px; overflow: hidden; position: relative; white-space: nowrap; width: 114px;"><div style="float: left;">Plutonium Waste</div></div></td></tr><tr style="height: 21px;"><td data-sheets-value="{"1":2,"2":"Polymer Resin"}" style="border-color: rgb(204, 204, 204) transparent rgb(204, 204, 204) rgb(204, 204, 204); border-image: initial; border-style: solid; border-width: 1px; overflow: visible; padding: 2px 0px; vertical-align: bottom;"><div style="left: 3px; overflow: hidden; position: relative; white-space: nowrap; width: 90px;"><div style="float: left;">Polymer Resin</div></div></td></tr><tr style="height: 21px;"><td data-sheets-value="{"1":2,"2":"Power Shard"}" style="border-color: rgb(204, 204, 204) transparent rgb(204, 204, 204) rgb(204, 204, 204); border-image: initial; border-style: solid; border-width: 1px; overflow: visible; padding: 2px 0px; vertical-align: bottom;"><div style="left: 3px; overflow: hidden; position: relative; white-space: nowrap; width: 90px;"><div style="float: left;">Power Shard</div></div></td></tr><tr style="height: 21px;"><td data-sheets-value="{"1":2,"2":"Pressure Conversion Cube"}" style="border-color: rgb(204, 204, 204) transparent rgb(204, 204, 204) rgb(204, 204, 204); border-image: initial; border-style: solid; border-width: 1px; overflow: visible; padding: 2px 0px; vertical-align: bottom;"><div style="left: 3px; overflow: hidden; position: relative; white-space: nowrap; width: 162px;"><div style="float: left;">Pressure Conversion Cube</div></div></td></tr><tr style="height: 21px;"><td data-sheets-value="{"1":2,"2":"Purple Power Slug"}" style="border-color: rgb(204, 204, 204) transparent rgb(204, 204, 204) rgb(204, 204, 204); border-image: initial; border-style: solid; border-width: 1px; overflow: visible; padding: 2px 0px; vertical-align: bottom;"><div style="left: 3px; overflow: hidden; position: relative; white-space: nowrap; width: 114px;"><div style="float: left;">Purple Power Slug</div></div></td></tr><tr style="height: 21px;"><td data-sheets-value="{"1":2,"2":"Quantum Computer"}" style="border-color: rgb(204, 204, 204) transparent rgb(204, 204, 204) rgb(204, 204, 204); border-image: initial; border-style: solid; border-width: 1px; overflow: visible; padding: 2px 0px; vertical-align: bottom;"><div style="left: 3px; overflow: hidden; position: relative; white-space: nowrap; width: 114px;"><div style="float: left;">Quantum Computer</div></div></td></tr><tr style="height: 21px;"><td data-sheets-value="{"1":2,"2":"Quartz Crystal"}" style="border-color: rgb(204, 204, 204) transparent rgb(204, 204, 204) rgb(204, 204, 204); border-image: initial; border-style: solid; border-width: 1px; overflow: visible; padding: 2px 0px; vertical-align: bottom;"><div style="left: 3px; overflow: hidden; position: relative; white-space: nowrap; width: 90px;"><div style="float: left;">Quartz Crystal</div></div></td></tr><tr style="height: 21px;"><td data-sheets-value="{"1":2,"2":"Quickwire"}" style="border-color: rgb(204, 204, 204) transparent rgb(204, 204, 204) rgb(204, 204, 204); border-image: initial; border-style: solid; border-width: 1px; overflow: visible; padding: 2px 0px; vertical-align: bottom;"><div style="left: 3px; overflow: hidden; position: relative; white-space: nowrap; width: 66px;"><div style="float: left;">Quickwire</div></div></td></tr><tr style="height: 21px;"><td data-sheets-value="{"1":2,"2":"Radio Control Unit"}" style="border-color: rgb(204, 204, 204) transparent rgb(204, 204, 204) rgb(204, 204, 204); border-image: initial; border-style: solid; border-width: 1px; overflow: visible; padding: 2px 0px; vertical-align: bottom;"><div style="left: 3px; overflow: hidden; position: relative; white-space: nowrap; width: 114px;"><div style="float: left;">Radio Control Unit</div></div></td></tr><tr style="height: 21px;"><td data-sheets-value="{"1":2,"2":"Raw Quartz"}" style="border-color: rgb(204, 204, 204) transparent rgb(204, 204, 204) rgb(204, 204, 204); border-image: initial; border-style: solid; border-width: 1px; overflow: visible; padding: 2px 0px; vertical-align: bottom;"><div style="left: 3px; overflow: hidden; position: relative; white-space: nowrap; width: 90px;"><div style="float: left;">Raw Quartz</div></div></td></tr><tr style="height: 21px;"><td data-sheets-value="{"1":2,"2":"Reinforced Iron Plate"}" style="border-color: rgb(204, 204, 204) transparent rgb(204, 204, 204) rgb(204, 204, 204); border-image: initial; border-style: solid; border-width: 1px; overflow: visible; padding: 2px 0px; vertical-align: bottom;"><div style="left: 3px; overflow: hidden; position: relative; white-space: nowrap; width: 138px;"><div style="float: left;">Reinforced Iron Plate</div></div></td></tr><tr style="height: 21px;"><td data-sheets-value="{"1":2,"2":"Rifle Cartridge"}" style="border-color: rgb(204, 204, 204) transparent rgb(204, 204, 204) rgb(204, 204, 204); border-image: initial; border-style: solid; border-width: 1px; overflow: visible; padding: 2px 0px; vertical-align: bottom;"><div style="left: 3px; overflow: hidden; position: relative; white-space: nowrap; width: 90px;"><div style="float: left;">Rifle Cartridge</div></div></td></tr><tr style="height: 21px;"><td data-sheets-value="{"1":2,"2":"Rotor"}" style="border-color: rgb(204, 204, 204) transparent rgb(204, 204, 204) rgb(204, 204, 204); border-image: initial; border-style: solid; border-width: 1px; overflow: visible; padding: 2px 0px; vertical-align: bottom;"><div style="left: 3px; overflow: hidden; position: relative; white-space: nowrap; width: 42px;"><div style="float: left;">Rotor</div></div></td></tr><tr style="height: 21px;"><td data-sheets-value="{"1":2,"2":"Rubber"}" style="border-color: rgb(204, 204, 204) transparent rgb(204, 204, 204) rgb(204, 204, 204); border-image: initial; border-style: solid; border-width: 1px; overflow: visible; padding: 2px 0px; vertical-align: bottom;"><div style="left: 3px; overflow: hidden; position: relative; white-space: nowrap; width: 42px;"><div style="float: left;">Rubber</div></div></td></tr><tr style="height: 21px;"><td data-sheets-value="{"1":2,"2":"S.A.M. Ore"}" style="border-color: rgb(204, 204, 204) transparent rgb(204, 204, 204) rgb(204, 204, 204); border-image: initial; border-style: solid; border-width: 1px; overflow: visible; padding: 2px 0px; vertical-align: bottom;"><div style="left: 3px; overflow: hidden; position: relative; white-space: nowrap; width: 66px;"><div style="float: left;">S.A.M. Ore</div></div></td></tr><tr style="height: 21px;"><td data-sheets-value="{"1":2,"2":"Screw"}" style="border-color: rgb(204, 204, 204) transparent rgb(204, 204, 204) rgb(204, 204, 204); border-image: initial; border-style: solid; border-width: 1px; overflow: visible; padding: 2px 0px; vertical-align: bottom;"><div style="left: 3px; overflow: hidden; position: relative; white-space: nowrap; width: 42px;"><div style="float: left;">Screw</div></div></td></tr><tr style="height: 21px;"><td data-sheets-value="{"1":2,"2":"Silica"}" style="border-color: rgb(204, 204, 204) transparent rgb(204, 204, 204) rgb(204, 204, 204); border-image: initial; border-style: solid; border-width: 1px; overflow: visible; padding: 2px 0px; vertical-align: bottom;"><div style="left: 3px; overflow: hidden; position: relative; white-space: nowrap; width: 42px;"><div style="float: left;">Silica</div></div></td></tr><tr style="height: 21px;"><td data-sheets-value="{"1":2,"2":"Smart Plating"}" style="border-color: rgb(204, 204, 204) transparent rgb(204, 204, 204) rgb(204, 204, 204); border-image: initial; border-style: solid; border-width: 1px; overflow: visible; padding: 2px 0px; vertical-align: bottom;"><div style="left: 3px; overflow: hidden; position: relative; white-space: nowrap; width: 90px;"><div style="float: left;">Smart Plating</div></div></td></tr><tr style="height: 21px;"><td data-sheets-value="{"1":2,"2":"Solid Biofuel"}" style="border-color: rgb(204, 204, 204) transparent rgb(204, 204, 204) rgb(204, 204, 204); border-image: initial; border-style: solid; border-width: 1px; overflow: visible; padding: 2px 0px; vertical-align: bottom;"><div style="left: 3px; overflow: hidden; position: relative; white-space: nowrap; width: 90px;"><div style="float: left;">Solid Biofuel</div></div></td></tr><tr style="height: 21px;"><td data-sheets-value="{"1":2,"2":"Spiked Rebar"}" style="border-color: rgb(204, 204, 204) transparent rgb(204, 204, 204) rgb(204, 204, 204); border-image: initial; border-style: solid; border-width: 1px; overflow: visible; padding: 2px 0px; vertical-align: bottom;"><div style="left: 3px; overflow: hidden; position: relative; white-space: nowrap; width: 90px;"><div style="float: left;">Spiked Rebar</div></div></td></tr><tr style="height: 21px;"><td data-sheets-value="{"1":2,"2":"Stator"}" style="border-color: rgb(204, 204, 204) transparent rgb(204, 204, 204) rgb(204, 204, 204); border-image: initial; border-style: solid; border-width: 1px; overflow: visible; padding: 2px 0px; vertical-align: bottom;"><div style="left: 3px; overflow: hidden; position: relative; white-space: nowrap; width: 42px;"><div style="float: left;">Stator</div></div></td></tr><tr style="height: 21px;"><td data-sheets-value="{"1":2,"2":"Steel Beam"}" style="border-color: rgb(204, 204, 204) transparent rgb(204, 204, 204) rgb(204, 204, 204); border-image: initial; border-style: solid; border-width: 1px; overflow: visible; padding: 2px 0px; vertical-align: bottom;"><div style="left: 3px; overflow: hidden; position: relative; white-space: nowrap; width: 66px;"><div style="float: left;">Steel Beam</div></div></td></tr><tr style="height: 21px;"><td data-sheets-value="{"1":2,"2":"Steel Ingot"}" style="border-color: rgb(204, 204, 204) transparent rgb(204, 204, 204) rgb(204, 204, 204); border-image: initial; border-style: solid; border-width: 1px; overflow: visible; padding: 2px 0px; vertical-align: bottom;"><div style="left: 3px; overflow: hidden; position: relative; white-space: nowrap; width: 66px;"><div style="float: left;">Steel Ingot</div></div></td></tr><tr style="height: 21px;"><td data-sheets-value="{"1":2,"2":"Steel Pipe"}" style="border-color: rgb(204, 204, 204) transparent rgb(204, 204, 204) rgb(204, 204, 204); border-image: initial; border-style: solid; border-width: 1px; overflow: visible; padding: 2px 0px; vertical-align: bottom;"><div style="left: 3px; overflow: hidden; position: relative; white-space: nowrap; width: 66px;"><div style="float: left;">Steel Pipe</div></div></td></tr><tr style="height: 21px;"><td data-sheets-value="{"1":2,"2":"Sulfur"}" style="border-color: rgb(204, 204, 204) transparent rgb(204, 204, 204) rgb(204, 204, 204); border-image: initial; border-style: solid; border-width: 1px; overflow: visible; padding: 2px 0px; vertical-align: bottom;"><div style="left: 3px; overflow: hidden; position: relative; white-space: nowrap; width: 42px;"><div style="float: left;">Sulfur</div></div></td></tr><tr style="height: 21px;"><td data-sheets-value="{"1":2,"2":"Sulfuric Acid"}" style="border-color: rgb(204, 204, 204) transparent rgb(204, 204, 204) rgb(204, 204, 204); border-image: initial; border-style: solid; border-width: 1px; overflow: visible; padding: 2px 0px; vertical-align: bottom;"><div style="left: 3px; overflow: hidden; position: relative; white-space: nowrap; width: 90px;"><div style="float: left;">Sulfuric Acid</div></div></td></tr><tr style="height: 21px;"><td data-sheets-value="{"1":2,"2":"Supercomputer"}" style="border-color: rgb(204, 204, 204) transparent rgb(204, 204, 204) rgb(204, 204, 204); border-image: initial; border-style: solid; border-width: 1px; overflow: visible; padding: 2px 0px; vertical-align: bottom;"><div style="left: 3px; overflow: hidden; position: relative; white-space: nowrap; width: 90px;"><div style="float: left;">Supercomputer</div></div></td></tr><tr style="height: 21px;"><td data-sheets-value="{"1":2,"2":"Superposition Oscillator"}" style="border-color: rgb(204, 204, 204) transparent rgb(204, 204, 204) rgb(204, 204, 204); border-image: initial; border-style: solid; border-width: 1px; overflow: visible; padding: 2px 0px; vertical-align: bottom;"><div style="left: 3px; overflow: hidden; position: relative; white-space: nowrap; width: 138px;"><div style="float: left;">Superposition Oscillator</div></div></td></tr><tr style="height: 21px;"><td data-sheets-value="{"1":2,"2":"Thermal Propulsion Rocket"}" style="border-color: rgb(204, 204, 204) transparent rgb(204, 204, 204) rgb(204, 204, 204); border-image: initial; border-style: solid; border-width: 1px; overflow: visible; padding: 2px 0px; vertical-align: bottom;"><div style="left: 3px; overflow: hidden; position: relative; white-space: nowrap; width: 162px;"><div style="float: left;">Thermal Propulsion Rocket</div></div></td></tr><tr style="height: 21px;"><td data-sheets-value="{"1":2,"2":"Turbo Motor"}" style="border-color: rgb(204, 204, 204) transparent rgb(204, 204, 204) rgb(204, 204, 204); border-image: initial; border-style: solid; border-width: 1px; overflow: visible; padding: 2px 0px; vertical-align: bottom;"><div style="left: 3px; overflow: hidden; position: relative; white-space: nowrap; width: 90px;"><div style="float: left;">Turbo Motor</div></div></td></tr><tr style="height: 21px;"><td data-sheets-value="{"1":2,"2":"Turbofuel"}" style="border-color: rgb(204, 204, 204) transparent rgb(204, 204, 204) rgb(204, 204, 204); border-image: initial; border-style: solid; border-width: 1px; overflow: visible; padding: 2px 0px; vertical-align: bottom;"><div style="left: 3px; overflow: hidden; position: relative; white-space: nowrap; width: 66px;"><div style="float: left;">Turbofuel</div></div></td></tr><tr style="height: 21px;"><td data-sheets-value="{"1":2,"2":"Uranium"}" style="border-color: rgb(204, 204, 204) transparent rgb(204, 204, 204) rgb(204, 204, 204); border-image: initial; border-style: solid; border-width: 1px; overflow: visible; padding: 2px 0px; vertical-align: bottom;"><div style="left: 3px; overflow: hidden; position: relative; white-space: nowrap; width: 66px;"><div style="float: left;">Uranium</div></div></td></tr><tr style="height: 21px;"><td data-sheets-value="{"1":2,"2":"Uranium Fuel Rod"}" style="border-color: rgb(204, 204, 204) transparent rgb(204, 204, 204) rgb(204, 204, 204); border-image: initial; border-style: solid; border-width: 1px; overflow: visible; padding: 2px 0px; vertical-align: bottom;"><div style="left: 3px; overflow: hidden; position: relative; white-space: nowrap; width: 114px;"><div style="float: left;">Uranium Fuel Rod</div></div></td></tr><tr style="height: 21px;"><td data-sheets-value="{"1":2,"2":"Uranium Waste"}" style="border-color: rgb(204, 204, 204) transparent rgb(204, 204, 204) rgb(204, 204, 204); border-image: initial; border-style: solid; border-width: 1px; overflow: visible; padding: 2px 0px; vertical-align: bottom;"><div style="left: 3px; overflow: hidden; position: relative; white-space: nowrap; width: 90px;"><div style="float: left;">Uranium Waste</div></div></td></tr><tr style="height: 21px;"><td data-sheets-value="{"1":2,"2":"Versatile Framework"}" style="border-color: rgb(204, 204, 204) transparent rgb(204, 204, 204) rgb(204, 204, 204); border-image: initial; border-style: solid; border-width: 1px; overflow: visible; padding: 2px 0px; vertical-align: bottom;"><div style="left: 3px; overflow: hidden; position: relative; white-space: nowrap; width: 138px;"><div style="float: left;">Versatile Framework</div></div></td></tr><tr style="height: 21px;"><td data-sheets-value="{"1":2,"2":"Water"}" style="border-color: rgb(204, 204, 204) transparent rgb(204, 204, 204) rgb(204, 204, 204); border-image: initial; border-style: solid; border-width: 1px; overflow: visible; padding: 2px 0px; vertical-align: bottom;"><div style="left: 3px; overflow: hidden; position: relative; white-space: nowrap; width: 42px;"><div style="float: left;">Water</div></div></td></tr><tr style="height: 21px;"><td data-sheets-value="{"1":2,"2":"Wire"}" style="border-color: rgb(204, 204, 204) transparent rgb(204, 204, 204) rgb(204, 204, 204); border-image: initial; border-style: solid; border-width: 1px; overflow: visible; padding: 2px 0px; vertical-align: bottom;"><div style="left: 3px; overflow: hidden; position: relative; white-space: nowrap; width: 42px;"><div style="float: left;">Wire</div></div></td></tr><tr style="height: 21px;"><td data-sheets-value="{"1":2,"2":"Wood"}" style="border-color: rgb(204, 204, 204) transparent rgb(204, 204, 204) rgb(204, 204, 204); border-image: initial; border-style: solid; border-width: 1px; overflow: visible; padding: 2px 0px; vertical-align: bottom;"><div style="left: 3px; overflow: hidden; position: relative; white-space: nowrap; width: 42px;"><div style="float: left;">Wood</div></div></td></tr><tr style="height: 21px;"><td data-sheets-value="{"1":2,"2":"Yellow Power Slug"}" style="border-color: rgb(204, 204, 204) transparent rgb(204, 204, 204) rgb(204, 204, 204); border-image: initial; border-style: solid; border-width: 1px; overflow: visible; padding: 2px 0px; vertical-align: bottom;"><div style="left: 3px; overflow: hidden; position: relative; white-space: nowrap; width: 114px;"><div style="float: left;">Yellow Power Slug</div></div></td></tr></tbody></table>Adminhttp://www.blogger.com/profile/09960815938346726074noreply@blogger.com0tag:blogger.com,1999:blog-3718585668604204638.post-27398547413118654662021-08-28T09:00:00.001-07:002021-08-28T09:00:00.195-07:00All Items In Satisfactory (Update 4)<p> 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.</p><p><br /></p><p><br /></p><p>Limestone</p><p>Iron Ore</p><p>Copper Ore</p><p>Caterium Ore</p><p>Coal</p><p>Raw Quartz</p><p>Sulfur</p><p>Bauxite</p><p>S.A.M. Ore</p><p>Uranium</p><p>Water</p><p>Crude Oil</p><p>Heavy Oil Residue</p><p>Fuel</p><p>Liquid Biofuel</p><p>Turbofuel</p><p>Alumina Solution</p><p>Sulfuric Acid</p><p>Nitric Acid</p><p>Nitrogen Gas</p><p>Concrete</p><p>Iron Ingot</p><p>Copper Ingot</p><p>Caterium Ingot</p><p>Steel Ingot</p><p>Aluminum Ingot</p><p>Quartz Crystal</p><p>Polymer Resin</p><p>Petroleum Coke</p><p>Aluminum Scrap</p><p>Copper Powder</p><p>Aluminum Casing</p><p>Empty Fluid Tank</p><p>Silica</p><p>Black Powder</p><p>Wire</p><p>Cable</p><p>Iron Rod</p><p>Screw</p><p>Iron Plate</p><p>Reinforced Iron Plate</p><p>Copper Sheet</p><p>Alclad Aluminum Sheet</p><p>Plastic</p><p>Rubber</p><p>Packaged Water</p><p>Packaged Alumina Solution</p><p>Packaged Sulfuric Acid</p><p>Packaged Nitric Acid</p><p>Packaged Nitrogen Gas</p><p>Steel Pipe</p><p>Steel Beam</p><p>Encased Industrial Beam</p><p>Green Power Slug</p><p>Yellow Power Slug</p><p>Purple Power Slug</p><p>Flower Petals</p><p>Crystal Oscillator</p><p>Empty Canister</p><p>Fabric</p><p>Modular Frame</p><p>Heavy Modular Frame</p><p>Pressure Conversion Cube</p><p>Fused Modular Frame</p><p>Rotor</p><p>Stator</p><p>Motor</p><p>Quickwire</p><p>Circuit Board</p><p>Computer</p><p>AI Limiter</p><p>High-Speed Connector</p><p>Supercomputer</p><p>Battery</p><p>Heat Sink</p><p>Radio Control Unit</p><p>Turbo Motor</p><p>Electromagnetic Control Rod</p><p>Encased Uranium Cell</p><p>Non-fissile Uranium</p><p>Plutonium Pellet</p><p>Encased Plutonium Cell</p><p>Cooling System</p><p>Quantum Computer</p><p>Superposition Oscillator</p><p>Beacon</p><p>Compacted Coal</p><p>Leaves</p><p>Mycelia</p><p>Wood</p><p>Biomass</p><p>Packaged Oil</p><p>Packaged Heavy Oil Residue</p><p>Solid Biofuel</p><p>Packaged Fuel</p><p>Packaged Liquid Biofuel</p><p>Packaged Turbofuel</p><p>Uranium Fuel Rod</p><p>Plutonium Fuel Rod</p><p>Nobelisk</p><p>Gas Filter</p><p>Color Cartridge</p><p>Rifle Cartridge</p><p>Spiked Rebar</p><p>Iodine Infused Filter</p><p>Power Shard</p><p>FICSIT Coupon</p><p>Smart Plating</p><p>Versatile Framework</p><p>Automated Wiring</p><p>Modular Engine</p><p>Adaptive Control Unit</p><p>Assembly Director System</p><p>Magnetic Field Generator</p><p>Thermal Propulsion Rocket</p><p>Nuclear Pasta</p><p>Uranium Waste</p><p>Plutonium Waste</p><p><br /></p>Adminhttp://www.blogger.com/profile/09960815938346726074noreply@blogger.com0tag:blogger.com,1999:blog-3718585668604204638.post-47926112112754881972021-07-02T06:00:00.002-07:002021-07-02T06:00:00.242-07:00Getting logs related to a specific user login in Ubuntu 20.04<p>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.</p><p>sudo journalctl | grep <<username>></p><p><br /></p><p><br /></p><p>From here:</p><p><a href="https://serverfault.com/questions/130482/how-to-check-sshd-log">https://serverfault.com/questions/130482/how-to-check-sshd-log</a></p><p><br /></p><p>All messages about sshd:</p><p>journalctl -t sshd</p><p>or</p><p>journalctl -u ssh </p><p><br /></p><p>Messages about sshd from the last boot:</p><p>journalctl -t sshd -b0</p><p><br /></p><p>Messages about sshd from the last boot in the reverse order:</p><p>journalctl -t sshd -b0 -r</p>Adminhttp://www.blogger.com/profile/09960815938346726074noreply@blogger.com0tag:blogger.com,1999:blog-3718585668604204638.post-31241591603577066612021-06-21T06:00:00.005-07:002021-06-21T06:00:00.204-07:00Linux Log LocationsLinux log locations<div><br /></div><div>. . . because I never remember<br /><br /><br />/var/log/messages : General log messages<br />/var/log/boot : System boot log<br />/var/log/debug : Debugging log messages<br />/var/log/auth.log : User login and authentication logs<br />/var/log/daemon.log : Running services such as squid, ntpd and others log message to this file<br />/var/log/dmesg : Linux kernel ring buffer log<br />/var/log/dpkg.log : All binary package log includes package installation and other information<br />/var/log/faillog : User failed login log file<br />/var/log/kern.log : Kernel log file<br />/var/log/lpr.log : Printer log file<br />/var/log/mail.* : All mail server message log files<br />/var/log/mysql.* : MySQL server log file<br />/var/log/user.log : All userlevel logs<br />/var/log/xorg.0.log : X.org log file<br />/var/log/apache2/* : Apache web server log files directory<br />/var/log/lighttpd/* : Lighttpd web server log files directory<br />/var/log/fsck/* : fsck command log<br />/var/log/apport.log : Application crash report / log file<div><br /></div><div><br /></div><div>Copied from</div><div>https://ubuntuforums.org/showthread.php?t=1568706</div><div><br /></div></div>Adminhttp://www.blogger.com/profile/09960815938346726074noreply@blogger.com0tag:blogger.com,1999:blog-3718585668604204638.post-118164356001273242021-05-14T06:00:00.002-07:002021-05-14T06:00:00.196-07:00The trust relationship between this workstation and the primary domain failed (in server core)<p> I got the error </p>
<table align="center" border="1"><tbody><tr><td>
The trust relationship between this workstation and the primary domain failed </td></tr></tbody></table>
<p>in server core after restoring from a snapshot in VirtualBox.</p><p>On my remote management machine, I tried to connect to the machine using Computer Management, which threw this not-quite-helpful error message.</p>
<table align="center" border="1"><tbody><tr><td>
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.<br /><br />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:<br /><br />COM+ Network Access (DCOM-in)<br />All rules in the Remote Event Log Management group<br /><br />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.
</td></tr></tbody></table><p></p>
<p><br /></p><p>As originally posted <a href="https://interactivewebs.com/server-tips/the-trust-relationship-between-this-workstation-and-the-primary-domain-failed-hyper-v-server/#:~:text=Contact%20Us-,The%20trust%20relationship%20between%20this%20workstation%20and,domain%20failed%20Hyper%2DV%20Server&text=The%20cause%20of%20this%20is,user%20name%20and%20password%20storage.&text=To%20do%20so%2C%20open%20the,and%20select%20the%20Computers%20container." target="_blank">on this page</a>, here's the steps to resolve.</p><br />1. Log into the server in question using the non domain admin account.<br /><br />2. Open the Power Shell and run the command:<br /><br />$credential = Get-Credential<br /><br />3. Then run the command: <br /><br />Reset-ComputerMachinePassword -Server ClosestDomainControllerNameHere<br /><br /><br />Adminhttp://www.blogger.com/profile/09960815938346726074noreply@blogger.com0tag:blogger.com,1999:blog-3718585668604204638.post-59017228019550559422021-02-18T06:00:00.002-08:002021-02-18T06:00:03.440-08:00Revised Script: Indexing and looking for a cursor in an update statement<p>I ran a QC script over the results of yesterday's cursor counts table, and realized I had made a logical error.</p><p><br /></p><p>Here's the QC scripts:</p>
<table border="1"><tbody><tr><td><pre>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
</pre></td></tr></tbody></table>
<p><br /></p><p><br /></p><p><br /></p><p>And here's the revised creation script:</p>
<table border="1"><tbody><tr><td><pre>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
</pre></td></tr></tbody></table>
<p><br /></p><p> </p><p><br /></p><p><br /></p>Adminhttp://www.blogger.com/profile/09960815938346726074noreply@blogger.com0tag:blogger.com,1999:blog-3718585668604204638.post-7457870716647604182021-02-17T06:00:00.003-08:002021-02-17T06:00:05.547-08:00Indexing and looking for a cursor in an update statement<p> From this page:</p><p><br /></p><p>http://www.artfulsoftware.com/infotree/qrytip.php?id=531&m=0</p><p><br /></p><p>I wanted to see if, in SQL Server, this same mySQL query </p><p></p><ol style="text-align: left;"><li>Could be reproduced</li><li>Could be sped up with an index</li><li>Would show up as a cursor in the estimated execution plan for the update statement </li></ol><p></p><p><br /></p><h4 style="text-align: left;">1. Reproduction</h4><p>So, yes, this is a fairly simple script to reproduce.</p><p><br /></p><p><br /></p>
<table border="1"><tbody><tr><td><pre>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
</pre></td></tr></tbody></table>
<p><br /></p><p>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.</p><p>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.</p><p><br /></p><h4 style="text-align: left;">2. Indexing</h4><p><br /></p><p>Yes, the statement can be sped up with an index.</p><p><br /></p><p>Here's the properties of the script, before index application:</p><p><br /></p><p></p><div class="separator" style="clear: both; text-align: center;"><a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEhkQ2eNVZT2oTNEpwiH2Z2svSDzi0wGdIBGBnfdYVBb-r-K_jBEmyV5y3C3vCorMw_a16uH8ezCMTprvC65cOVSHkMXmkv792xwJZRkef5GTkkBQYpRh7qxpO_stvI2ncZOSCMrlex-eAWC/" style="margin-left: 1em; margin-right: 1em;"><img alt="" data-original-height="759" data-original-width="1028" height="236" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEhkQ2eNVZT2oTNEpwiH2Z2svSDzi0wGdIBGBnfdYVBb-r-K_jBEmyV5y3C3vCorMw_a16uH8ezCMTprvC65cOVSHkMXmkv792xwJZRkef5GTkkBQYpRh7qxpO_stvI2ncZOSCMrlex-eAWC/" width="320" /></a></div><br /><p></p><p><br /></p><p>Here's after applying the index:</p><p><br /></p><p></p><div class="separator" style="clear: both; text-align: center;"><a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEg9r7FE1l-YTSAEXA3mK1TZdMk5Qu-XNL2yCec7C9yIZJC44O-KJtOV9kRLUN8IY2NzcE5q5wks3r5oW7eHeY3dUBTYYVw8IsEQGmNpc5UnfQv1N1uG53mxiSKL2F9k9pXRhQKuZgdGMzOb/" style="margin-left: 1em; margin-right: 1em;"><img alt="" data-original-height="777" data-original-width="1028" height="240" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEg9r7FE1l-YTSAEXA3mK1TZdMk5Qu-XNL2yCec7C9yIZJC44O-KJtOV9kRLUN8IY2NzcE5q5wks3r5oW7eHeY3dUBTYYVw8IsEQGmNpc5UnfQv1N1uG53mxiSKL2F9k9pXRhQKuZgdGMzOb/" width="318" /></a></div><br /><p></p><p><br /></p><p>It's a third of the cost. Win!</p><p><br /></p><h4 style="text-align: left;">3. Cursor</h4><p><br /></p><p>There are loops - which is expected - but SQL Server doesn't dissolve into an explicit cursor to handle the update.</p><p></p><div class="separator" style="clear: both; text-align: center;"><a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEiXVvJ5N0O_vRrBqcLgsnquUPk3tdPgyFOtDTMICcuv2O2bndEgLCkqqxNyXcy_4upNsLvUNcq0-mi_B_TiZFwCperqc0t53tFFIA-Ypfrf6H_ePuZIMaXNjlJf1Zs6AT5zL9ERTe7AjSxb/" style="margin-left: 1em; margin-right: 1em;"><img alt="" data-original-height="339" data-original-width="1386" height="78" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEiXVvJ5N0O_vRrBqcLgsnquUPk3tdPgyFOtDTMICcuv2O2bndEgLCkqqxNyXcy_4upNsLvUNcq0-mi_B_TiZFwCperqc0t53tFFIA-Ypfrf6H_ePuZIMaXNjlJf1Zs6AT5zL9ERTe7AjSxb/" width="320" /></a></div><br /><br /><p></p><p><br /></p>Adminhttp://www.blogger.com/profile/09960815938346726074noreply@blogger.com0tag:blogger.com,1999:blog-3718585668604204638.post-40137077940475212172021-02-05T06:00:00.011-08:002021-02-06T22:17:52.827-08:00Installing SQL Server Configuration Manager when missing for remote management<p>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.</p><p><br /></p><p><br /></p><p></p><div class="separator" style="clear: both; text-align: center;"><a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEiPz9s-McD5WDlosbjPlGIxTbLZhasvzR9H_QpBVRSh88b3fl3GkR77-9lfExQLX_6R2LA_Ra42zgPdtgwGQXxiAH61c4RCf_xV4rauKX_8sfrzVRxpJJJFeXIHVPCfWNzftDJ7nowMpcWQ/" style="margin-left: 1em; margin-right: 1em;"><img alt="" data-original-height="612" data-original-width="809" height="240" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEiPz9s-McD5WDlosbjPlGIxTbLZhasvzR9H_QpBVRSh88b3fl3GkR77-9lfExQLX_6R2LA_Ra42zgPdtgwGQXxiAH61c4RCf_xV4rauKX_8sfrzVRxpJJJFeXIHVPCfWNzftDJ7nowMpcWQ/" width="317" /></a></div><br /><div class="separator" style="clear: both; text-align: center;"><a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEgT9fu0zLHu9mKGx4FA2G7h9PR7XxdsbRouhxsTkyRk50ogM5MzOooG0aZIZtFPTvKBlHqmsG8ahZTG4KORW74hqIaLKeHFt2QkkC_DVJXripUjpfWSyu8hI485SK3gmZ4amVTrsrSyxumv/" style="margin-left: 1em; margin-right: 1em;"><img alt="" data-original-height="713" data-original-width="989" height="231" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEgT9fu0zLHu9mKGx4FA2G7h9PR7XxdsbRouhxsTkyRk50ogM5MzOooG0aZIZtFPTvKBlHqmsG8ahZTG4KORW74hqIaLKeHFt2QkkC_DVJXripUjpfWSyu8hI485SK3gmZ4amVTrsrSyxumv/" width="320" /></a></div><br /><br /><p></p>Adminhttp://www.blogger.com/profile/09960815938346726074noreply@blogger.com0tag:blogger.com,1999:blog-3718585668604204638.post-82472829806315521952021-02-04T06:00:00.036-08:002021-02-04T06:00:01.747-08:00There is insufficient system memory in resource pool 'default' to run this query<p>So while running a really generic restore to the SQL Server cluster instance sql1:</p>
<table border="1"><tbody><tr><td>
<p><span style="font-family: courier;">USE [master]</span></p><p><span style="font-family: courier;">RESTORE DATABASE [enron] <br /></span><span style="font-family: courier;">FROM DISK = N'\\ServerE\iso\enron.bak' <br />WITH FILE = 1, <br />MOVE N'enron_Data' TO N'C:\Data\enron_Data.mdf', <br />MOVE N'enron_Log' TO N'C:\Data\enron_Log.ldf', <br />NOUNLOAD, REPLACE, STATS = 5</span></p> <p><span style="font-family: courier;">GO</span></p>
</td></tr></tbody></table>
<p><br /></p><p>The error, while descriptive, was interesting because it was "terse" :)</p>
<table border="1"><tbody><tr><td>
<p><span style="font-family: courier;">Msg 3224, Level 16, State 2, Line 2</span></p><p><span style="font-family: courier;">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.</span></p><p><span style="font-family: courier;">Msg 3013, Level 16, State 1, Line 2</span></p><p><span style="font-family: courier;">RESTORE DATABASE is terminating abnormally.</span></p><p><span style="font-family: courier;">Msg 701, Level 17, State 123, Line 2</span></p><p><span style="font-family: courier;">There is insufficient system memory in resource pool 'default' to run this query.</span></p><p><span style="font-family: courier;"><br /></span></p><p><span style="font-family: courier;">Completion time: 2021-02-04T03:18:26.1654581-08:00</span></p>
</td></tr></tbody></table>
<div><br /></div><div><br /></div><div>Turns out, the RAM for the server was still set at it's installation default of 128 MB.</div><div><br /></div><div><div class="separator" style="clear: both; text-align: center;"><a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEhT4UmjTwcgODAteo63XOBvXkoWnCB668vMPsbSSflJwaEkHSAqA1e3jiThn72zkbIyesBmbaFtEOJH_Iztugcup860DVEDLplkeN8YxVlkX9D8xQDvwBd9rJkfemfrQDptfEAyAp13TCCt/" style="margin-left: 1em; margin-right: 1em;"><img alt="" data-original-height="669" data-original-width="709" height="240" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEhT4UmjTwcgODAteo63XOBvXkoWnCB668vMPsbSSflJwaEkHSAqA1e3jiThn72zkbIyesBmbaFtEOJH_Iztugcup860DVEDLplkeN8YxVlkX9D8xQDvwBd9rJkfemfrQDptfEAyAp13TCCt/" width="254" /></a></div><br /><br /></div><div><br /></div><div>Once that was increased to 1024 MB, the problem magically went away. </div><div><br /></div><div><br /></div><div><div class="separator" style="clear: both; text-align: center;"><a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEhTTz1SMuuR2xfQbtGTNfxLYouRIAMMf3BkrV-dWxxAEz48ZJU7rNteGCzR7IG-_1wW3qLSLfBWG8jSSmR1eSzGVU3sFS9sUlfk5RuhSPjZM5OH4-hkPFAwaSrXAGNhylC8XKWVa0hrVSj2/" style="margin-left: 1em; margin-right: 1em;"><img alt="" data-original-height="667" data-original-width="706" height="240" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEhTTz1SMuuR2xfQbtGTNfxLYouRIAMMf3BkrV-dWxxAEz48ZJU7rNteGCzR7IG-_1wW3qLSLfBWG8jSSmR1eSzGVU3sFS9sUlfk5RuhSPjZM5OH4-hkPFAwaSrXAGNhylC8XKWVa0hrVSj2/" width="254" /></a></div><br /><br /></div><div><br /></div>Adminhttp://www.blogger.com/profile/09960815938346726074noreply@blogger.com0tag:blogger.com,1999:blog-3718585668604204638.post-70451576646663430672021-02-02T06:00:00.004-08:002021-02-04T04:04:18.391-08:00SSMS Error - An exception occurred while executing a Transact-SQL statement or batch.<div dir="ltr"><div><div class="gmail_signature" data-smartmail="gmail_signature" dir="ltr">I really don't like the errors like this. :(</div><div class="gmail_signature" data-smartmail="gmail_signature" dir="ltr"><br /></div><div class="gmail_signature" data-smartmail="gmail_signature" dir="ltr">I'm going to increase the RAM of the servers in the cluster and see if that helps.</div><div class="gmail_signature" data-smartmail="gmail_signature" dir="ltr"><br /></div><div class="gmail_signature" data-smartmail="gmail_signature" dir="ltr">TITLE: Microsoft SQL Server Management Studio<br />------------------------------<br /><br />Failed to retrieve data for this request. (Microsoft.SqlServer.Management.Sdk.Sfc)<br /><br />For help, click: <a href="https://go.microsoft.com/fwlink?ProdName=Microsoft%20SQL%20Server&LinkId=20476">https://go.microsoft.com/fwlink?ProdName=Microsoft%20SQL%20Server&LinkId=20476</a><br /><br />------------------------------<br />ADDITIONAL INFORMATION:<br /><br />An exception occurred while executing a Transact-SQL statement or batch. (Microsoft.SqlServer.ConnectionInfo)<br /><br />------------------------------<br /><br />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.<br /> (Microsoft SQL Server, Error: 802)<br /><br />For help, click: <a href="http://go.microsoft.com/fwlink?ProdName=Microsoft%20SQL%20Server&ProdVer=15.00.2000&EvtSrc=MSSQLServer&EvtID=802&LinkId=20476">http://go.microsoft.com/fwlink?ProdName=Microsoft%20SQL%20Server&ProdVer=15.00.2000&EvtSrc=MSSQLServer&EvtID=802&LinkId=20476</a><br /><br />------------------------------<br />BUTTONS:<br /><br />OK<br />------------------------------<br /></div></div></div> Adminhttp://www.blogger.com/profile/09960815938346726074noreply@blogger.com0tag:blogger.com,1999:blog-3718585668604204638.post-67867619584113526872021-02-01T06:00:00.012-08:002021-02-04T14:41:30.814-08:00Can't see SQL Server Configuration Manager in Computer Management<p> 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.</p><p><br /></p><p>https://docs.microsoft.com/en-us/sql/database-engine/install-windows/configure-sql-server-on-a-server-core-installation?view=sql-server-ver15</p><p><br /></p><p>Except, as you can see from the screenshot, "SQL Server Configuration Manager" isn't anywhere in there.</p><p><br /></p><p></p><div class="separator" style="clear: both; text-align: center;"><a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEh29jATSECqxKgF8JmlFlQmO2eHzPW2__bPv5bYgmVg7ieTrSo0kJ8hBpgiQ74giwzgJPTq2hBGSlHxCMKxIDRlh9ukPlB5_4gfGncgZQhutItWZDRk0qjblK2bft4IdTpoSq0E7gDcZJ1L/" style="margin-left: 1em; margin-right: 1em;"><img alt="" data-original-height="698" data-original-width="891" height="240" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEh29jATSECqxKgF8JmlFlQmO2eHzPW2__bPv5bYgmVg7ieTrSo0kJ8hBpgiQ74giwzgJPTq2hBGSlHxCMKxIDRlh9ukPlB5_4gfGncgZQhutItWZDRk0qjblK2bft4IdTpoSq0E7gDcZJ1L/" width="306" /></a></div><br /><br /><p></p><p><br /></p><p>The server is Windows Server Core 2019. MMC is a no-go.</p><p>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".</p><p></p><div class="separator" style="clear: both; text-align: center;"><a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEjJ04Kw9HmDYS9QnAF94Xyi9dUWY02QolVa2F4y-0eRFpRio4YRSTGTnSQro08oGA0jzFqYny7wKGURy19MI79FGwMBLXVelk1acdZmgx5wUu6fncleP84NEGKflsBH9qK0JpYxi0Le0ASE/" style="margin-left: 1em; margin-right: 1em;"><img alt="" data-original-height="517" data-original-width="991" height="167" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEjJ04Kw9HmDYS9QnAF94Xyi9dUWY02QolVa2F4y-0eRFpRio4YRSTGTnSQro08oGA0jzFqYny7wKGURy19MI79FGwMBLXVelk1acdZmgx5wUu6fncleP84NEGKflsBH9qK0JpYxi0Le0ASE/" width="320" /></a></div><br /><br /><p></p><p>OK, this is Server Core, that's not really all that shocking.</p><p>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.</p><p><br /></p><p></p><div class="separator" style="clear: both; text-align: center;"><a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEh1mVXJ2nLbHlF1D-4njb0tQTM1z-zTeCMdCQJsmQF7ET6aPbn6XlHPonuiRq5OPCql-deLc9tE_divntxrPI4D2taOjuaMPA3JI-RbBS-slaOribf7W8EASgsrDJpFcZkh6F63JBCfmTrY/" style="margin-left: 1em; margin-right: 1em;"><img alt="" data-original-height="226" data-original-width="568" height="127" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEh1mVXJ2nLbHlF1D-4njb0tQTM1z-zTeCMdCQJsmQF7ET6aPbn6XlHPonuiRq5OPCql-deLc9tE_divntxrPI4D2taOjuaMPA3JI-RbBS-slaOribf7W8EASgsrDJpFcZkh6F63JBCfmTrY/" width="320" /></a></div><br /><br /><p></p><p><br /></p><p>So I'm going to have to figure out how to install the configuration manager without installing SQL Server itself.</p><p><br /></p>Adminhttp://www.blogger.com/profile/09960815938346726074noreply@blogger.com0tag:blogger.com,1999:blog-3718585668604204638.post-81618628204505304102021-01-22T06:00:00.013-08:002021-01-22T06:00:06.518-08:00pushing and popping in Windows Server Core<p>This is yet another "daggone it, how DID I forget that????"</p><p>I would like to share this URL:</p><p>https://superuser.com/questions/282963/browse-an-unc-path-using-windows-cmd-without-mapping-it-to-a-network-drive</p><div><br /></div>Whose answer was:<br /><br />If you use <a href="https://www.blogger.com/#">pushd</a> and <a href="https://www.blogger.com/#">popd</a> instead of cd you won't get that UNC error.<br /><br />pushd <UNC path> will create a temporary virtual drive and get into it.<br />popd will delete the temporary drive and get you back to the path you were when you entered pushd.Adminhttp://www.blogger.com/profile/09960815938346726074noreply@blogger.com0tag:blogger.com,1999:blog-3718585668604204638.post-49806024204087267742021-01-19T06:00:00.011-08:002021-01-19T06:00:03.458-08:00New checklist for standing up servers in the VirtualBox UCS domain<p>New checklist for standing up servers in the VirtualBox UCS domain</p><p>It's dev! Don't disable your firewalls in production! Don't run with scissors, either, kids.</p><p><br /></p><p> 1.</p><p>Set-DnsClientServerAddress -InterfaceAlias Ethernet -ServerAddresses 192.168.x.x</p><p>Rename-Computer "Servername" -restart</p><p>2.</p><p>Add-Computer –domainname "mydomain" -restart</p><p>3.</p><p>sconfig, enable remote desktop</p><p>shut down</p><p>set 1st network adapter to bridged instead of NAT</p><p>enable bidrectional clipboard</p><p>enable 2nd network adapter</p><p>4.</p><p>log in via RDP and then</p><p><span style="white-space: pre;"> </span>In Command Prompt as Adminsitrator</p><p><span style="white-space: pre;"> </span>sc config vds start=auto</p><p><span style="white-space: pre;"> </span>net start vds</p><p><span style="white-space: pre;"> </span>In powershell as administrator</p><p><span style="white-space: pre;"> </span>Set-NetFirewallProfile -Profile Domain,Public,Private -Enabled False</p><p><span style="white-space: pre;"> </span>enable-psremoting</p><p><span style="white-space: pre;"> </span>Install-WindowsFeature -Name Failover-Clustering -IncludeManagementTools -Restart</p><div><br /></div>Adminhttp://www.blogger.com/profile/09960815938346726074noreply@blogger.com0tag:blogger.com,1999:blog-3718585668604204638.post-6182562879343334432021-01-18T06:00:00.014-08:002021-01-18T06:00:05.663-08:00MLK Day: Groovelectric<p>This seems like an appropriate time to post this:</p><p><br /></p><p><span style="background-color: white; color: #3f4447; font-family: "Helvetica Neue", Helvetica, Arial, sans-serif; font-size: 14px;"><a href="https://www.groovelectric.com/mixes.html#mixes_content18">MLK I have a dream - Groovelectric style</a></span></p><p><span style="background-color: white; color: #3f4447; font-family: "Helvetica Neue", Helvetica, Arial, sans-serif; font-size: 14px;"><br /></span></p><p>It's originally from</p><p><span style="background-color: white; color: #3f4447; font-family: "Helvetica Neue", Helvetica, Arial, sans-serif; font-size: 14px;">http://www.groovelectric.com</span></p><p><br /></p>Adminhttp://www.blogger.com/profile/09960815938346726074noreply@blogger.com0tag:blogger.com,1999:blog-3718585668604204638.post-2564084370191723742021-01-15T06:00:00.012-08:002021-01-15T06:00:02.394-08:00Install the PowerShell A/D module<p> From this page:</p><p><a href="https://4sysops.com/wiki/how-to-install-the-powershell-active-directory-module/#windows-8-windows-81-windows-10">How to install the PowerShell Active Directory module</a></p><p><br /></p><span style="color: #333333; font-family: "Open Sans"; font-size: 16px; text-align: justify;">Enable </span><span style="box-sizing: border-box; color: #333333; font-family: "Open Sans"; font-size: 16px; font-weight: 700; text-align: justify;">Active Directory module for Windows PowerShell</span><span style="color: #333333; font-family: "Open Sans"; font-size: 16px; text-align: justify;"> </span><span style="color: #333333; font-family: "Open Sans"; font-size: 16px; text-align: justify;">in</span><span style="color: #333333; font-family: "Open Sans"; font-size: 16px; text-align: justify;"> </span><span style="box-sizing: border-box; color: #333333; font-family: "Open Sans"; font-size: 16px; font-weight: 700; text-align: justify;">Remote Server Administration Tools > Role Administration Tools > AD DS and AD LDS Tools</span><span style="color: #333333; font-family: "Open Sans"; font-size: 16px; text-align: justify;">.</span><div><span style="color: #333333; font-family: "Open Sans"; font-size: 16px; text-align: justify;"><br /></span></div><div><span style="color: #333333; font-family: "Open Sans"; font-size: 16px; text-align: justify;"><br /></span></div>Adminhttp://www.blogger.com/profile/09960815938346726074noreply@blogger.com0tag:blogger.com,1999:blog-3718585668604204638.post-90185778183192363092021-01-14T06:00:00.007-08:002021-01-14T06:00:09.718-08:00How do I know if a Windows feature is installed?<p> 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.</p><p><br /></p><p> get-windowsfeature "*fs*"</p><p><br /></p><p><br /></p><p><br /></p><p></p><div class="separator" style="clear: both; text-align: center;"><a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEgJQalPHDTRqfuza8Dq6iw_kmDQ055ls0oSRnwjpL9hv2UTKooZnPcZHAtEZ2yK4RqAXiOG2yWvPhQrSZlV2dLCoHK2r1McfECiGyz48CUlpNpu_2TXgMX2VpvjSZd2jIy6d9gzq_zKGTlf/" style="margin-left: 1em; margin-right: 1em;"><img alt="" data-original-height="334" data-original-width="785" height="136" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEgJQalPHDTRqfuza8Dq6iw_kmDQ055ls0oSRnwjpL9hv2UTKooZnPcZHAtEZ2yK4RqAXiOG2yWvPhQrSZlV2dLCoHK2r1McfECiGyz48CUlpNpu_2TXgMX2VpvjSZd2jIy6d9gzq_zKGTlf/" width="320" /></a></div><br /><br /><p></p>Adminhttp://www.blogger.com/profile/09960815938346726074noreply@blogger.com0tag:blogger.com,1999:blog-3718585668604204638.post-12720117800358048522021-01-13T06:00:00.011-08:002021-01-13T06:00:02.068-08:00Set the friendly name of a physical disk<div>I need to set the FriendlyName of a PhysicalDisk in PowerShell, but the uniqueID isn't shown.</div><div><br /></div><div>Use this:</div><div><br /></div> Get-PhysicalDisk | Select-Object SerialNumber,UniqueID<div><br /></div><div><br /></div>Adminhttp://www.blogger.com/profile/09960815938346726074noreply@blogger.com0tag:blogger.com,1999:blog-3718585668604204638.post-1648340452311565372021-01-12T06:00:00.021-08:002021-01-12T06:00:01.650-08:00Ubuntu: Error pop ups when connecting via xrdp<p>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:</p><p><br /></p><p><a href="http://c-nergy.be/blog/?p=14051" rel="nofollow" target="_blank">xRDP – Infamous “Authentication required to refresh system repositories” popup on Ubuntu 19.04 – The correct fix !!</a></p><p><br /></p><p>and</p><p><br /></p><p><a href="http://c-nergy.be/blog/?p=12043" rel="nofollow" target="_blank">xRDP – How to Fix the Infamous system crash popups in Ubuntu 18.04 (and previous versions)</a><br /></p><p><br /></p><p><br /></p><p><br /></p>Adminhttp://www.blogger.com/profile/09960815938346726074noreply@blogger.com0tag:blogger.com,1999:blog-3718585668604204638.post-45708039777809930472021-01-11T06:00:00.097-08:002021-01-11T06:00:06.545-08:00Ubuntu: Errors when installing VirtualBox <p>I want to install VirtualBox on my Ubuntu 20.04 LTS host, so I run:</p><p><br /></p>
<p>sudo apt install virtualbox virtualbox-ext-pack virtualbox-guest-additions-iso</p>
<p><br /></p><p>which gives me THIS ugly mess</p><p><br /></p>
<div><pre>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.
<br />
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.
<br />
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.
<br />
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)
<br />
<br />
</pre></div>
<p>So now, I'm going with Plan B.</p><p><br /></p><p></p><ul style="text-align: left;"><li>sudo apt-get install software–properties–common</li><li>wget –q https://www.virtualbox.org/download/oracle_vbox_2016.asc -O- | sudo apt-key add -</li><li>wget -q https://www.virtualbox.org/download/oracle_vbox.asc -O- | sudo apt-key add -</li><li>sudo add-apt-repository "deb http://download.virtualbox.org/virtualbox/debian focal contrib"</li><li>sudo apt update</li><li>sudo apt install virtualbox-6.1</li></ul><p></p><p><br /></p><p><br /></p><p><br /></p><p>However, I *still* get the same error.</p><p><br /></p><div>
<pre>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)
</pre>
</div><p><br /></p><p><br /></p><p><br /></p><p>The difference is, this time VirtualBox starts.</p><p><br /></p><p>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.</p><p><br /></p>Adminhttp://www.blogger.com/profile/09960815938346726074noreply@blogger.com0tag:blogger.com,1999:blog-3718585668604204638.post-76058113137586403012021-01-08T06:00:00.030-08:002021-01-08T06:00:02.422-08:00Ubuntu: Install xrdp<p> 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.</p><p>Since I never remember the steps to reinstall xrdp, I'm sharing them here, so I remember next time:</p><p><br /></p><p style="text-align: center;"><br /></p><div align="center"><table border="1"><tbody><tr><td><pre>sudo apt install xrdp
sudo systemctl status xrdp
sudo adduser xrdp ssl-cert
sudo systemctl restart xrdp
sudo systemctl status xrdp
</pre></td></tr></tbody></table></div>Adminhttp://www.blogger.com/profile/09960815938346726074noreply@blogger.com0