Categories
Uncategorized

ssh to reset dell idrac ip address and other variables

I was working on something with an IP conflict, and then locked myself out of routing via the VPN, so the quickest way to do a fix, was to change the IP of my idrac via command line. Apparently, you can do almost everything through command line.

First step is to get onto your idrac, replacing root and IP with your own information. Note, default username and password is root – calvin. If you have a newer idrac, I think starting around idrac8, there is a tab on the server that has the default idrac username and password:

  • ssh root@192.168.0.120
  • racadm
  • racadm getniccfg

You should now have a print out of your current configuration for your NIC. To change it, you just do the following:

  • racadm config -g cfgLanNetworking -o cfgNicIpAddress  192.168.0.140
  • racadm set iDRAC.IPv4.Address  192.168.0.140

Give it a few seconds, and it should kick you out, and now have the new IP address.

If you want a full subset of the documentation go here: http://ftp.dell.com/Manuals/all-products/esuprt_electronics/esuprt_software/esuprt_remote_ent_sys_mgmt/integrated-dell-remote-access-cntrllr-7-v1.30.30_User%27s%20Guide_en-us.pdf

Otherwise here is a snippet:

% Get all iDRAC settings in a file

racadm get -f config.txt

If you like you can change the contents of config.txt and apply it back to iDRAC
racadm set -f config.txt

% Set password for root user
racadm set iDRAC.Users.2.Password PASSWORD"

% List all ssh keys for root user
racadm sshpkauth -i 2 -v -k all

% Add ssh key to root user
racadm sshpkauth -i 2 -k 1 "CONTENTS OF PUBLIC KEY"

% Delete ssh key for root user
racadm sshpkauth -i 2 -d -k 1

% Get iDRAC IP config

racadm getniccfg
racadm get iDRAC.NIC

% set iDRAC IP

Using config command:
racadm config -g cfgLanNetworking -o cfgNicEnable 1
racadm config -g cfgLanNetworking -o cfgNicIpAddress x.x.x.x
racadm config -g cfgLanNetworking -o cfgNicNetmask 255.255.255.0
racadm config -g cfgLanNetworking -o cfgNicGateway x.x.x.x
racadm config -g cfgLanNetworking -o cfgNicUseDHCP 0
racadm config -g cfgLanNetworking -o cfgDNSServersFromDHCP 0
racadm config -g cfgLanNetworking -o cfgDNSServer1 y.y.y.y
racadm config -g cfgLanNetworking -o cfgDNSServer2 y.y.y.y
• Using set command:
racadm set iDRAC.Nic.Enable 1
racadm set iDRAC.IPv4.Address x.x.x.x
racadm set iDRAC.IPv4.Netmask 255.255.255.0
racadm set iDRAC.IPv4.Gateway x.x.x.x
racadm set iDRAC.IPv4.DHCPEnable 0
racadm set iDRAC.IPv4.DNSFromDHCP 0
racadm set iDRAC.IPv4.DNS1 y.y.y.y
racadm set iDRAC.IPv4.DNS2 y.y.y.y

% Set iDRAC DNS Name
racadm set iDRAC.NIC.DNSRacName iDRACNAME

% Set iDRAC domain name
racadm set iDRAC.NIC.DNSDomainName DOMAIN.NAME

% Set iDRAC DNS Server

racadm config -g cfgLanNetworking -o cfgDNSServer1 x.x.x.x
racadm config -g cfgLanNetworking -o cfgDNSServer2 y.y.y.y

% Set Front LCD to hostname
racadm set System.LCD.Configuration 16

% Reset iDRAC to factory defaults
racadm racresetcfg

% Reset/Reboot iDRAC

racadm racreset OPTIONS

Options : soft, hard, cold
or
racadm serveraction powercycle

% Get Serial number (service tag)
racadm getsvctag

% Get current system information
racadm getsysinfo

% Configure one-time-boot to PXE

racadm set BIOS.OneTimeBoot.OneTimeBootMode OneTimeBootSeq
racadm set BIOS.OneTimeBoot.OneTimeBootSeqDev NIC.Integrated.1-1-1

% Configure persistent Boot Device

racadm config -g cfgServerInfo -o cfgServerBootOnce 0
racadm config -g cfgServerInfo -i cfgServerFirstBootDevice HDD

% Check boot order list
racadm get BIOS.BiosBootSettings.bootseq

% Disable HyperThreading
racadm set BIOS.ProcSettings.LogicalProc Disabled

% Disable OS to iDRAC pass-thru for iDRAC service module (automatically create a pseudo NIC in OS)
racadm set iDRAC.OS-BMC.AdminState Disabled

% Change SNMP public community string
racadm set iDRAC.SNMP.AgentCommunity NEW STRING

% Disable ASR
racadm config -g cfgRacTuning -o cfgRacTuneAsrEnable 0

% Configure Serial redirection

racadm config -g cfgSerial -o cfgSerialConsoleEnable 1
racadm config -g cfgSerial -o cfgSerialBaudRate 115200
racadm config -g cfgSerial -o cfgSerialCom2RedirEnable 1
racadm config -g cfgSerial -o cfgSerialTelnetEnable 0
racadm config -g cfgSerial -o cfgSerialSshEnable 1

to access console via ssh console com2

% Disable Serial On Lan
racadm config -g cfgImpiSol -o cfgIpmiSolEnable 0

% Change Power Profile
racadm set BIOS.SysProfileSettings PerfPerWattOptimizedOs

% Set AC Power Recovery

racadm set BIOS.SysSecurity.AcPwdRcvry Last
racadm set BIOS.SysSecurity.AcPwdRcvryDelay Immediate

% Get RAID physical Disk information

racadm raid get pdisks
racadm raid get pdisks -o (all information)
racadm raid get pdisks -o -p state,size (specific information)

% Get RAID Virtual Disk Information
Racadm raid get vdisks

Categories
Uncategorized

Issues adding passwords on MySQL 10 or newer

I was trying to create a password for a new user on a new install of webmin. I was trying out the latest everything, latest MySQL (MariaDB 10), PHP 7.3, Kernel 5.0.2.12 running on Centos 7. But for some reason, when adding a new SQL user, I kept getting: failed :

Password hash should be a 41-digit hexadecimal number

What I had to do was enter the hash of the password into the new user script. To get the hash, all you have to do it go to command line, enter:

mysql -u root -h localhost -p

Then enter your passwords, and enter your password you want to kick back the hash on:

SELECT PASSWORD(‘mypass’);

Which will kick out:

6C8989366EAF75BB670AD8EA7A7FC1176A95CEF4

Poof, now you can enter that as your password via your gui, or as an SQL command:

If you would like to read more about it, check here:

https://dev.mysql.com/doc/refman/5.6/en/password-hashing.html

Categories
Uncategorized

Need a replacement for speed test by ookla?

I’ve been using fast.com, powered by Netflix and it’s been working great. I was getting annoyed with ooklas somewhat intrusive ad tactics and was looking for something a little better. Fast.com works great and has a great little application door Android as well.

Categories
Uncategorized

microsoft surface pro 6 battery bar stuck at 100%

You would think this is a good thing, but no, haha. It’s nice to know what your battery is actually at. While the tablet was logged in, I did this key combo, and that resolved it:

hold volume + and power button for 15 seconds and that should fix it.

Categories
Uncategorized

Having issues with pfsense booting or crashing on ESX 6.5?

I had just installed a fresh copy of pfsense on my HP GEN8 Microserver, and noticed it would not like booting up, sometimes. So I ended up removing the USB SATA controller, and that resolved it. Why? I am not sure…I remember reading that someone else had a similar issue before as well.

Categories
Uncategorized

capital one 360 free $25 with new checking or savings account

I had signed up for capital one 360, and noticed with a referral you get $25, and I get $20 if you use this link to open a new checking or savings account with capital one! Seems like a win win.

I signed up with them because they have a no monthly fee checking account, and so far have had good customer service. You can also use capital one branches which is a thumbsup if I need to get a large chunk of cash.

https://r.capitalone360.com/yD5jv2SHKr

Categories
Uncategorized

AT LOTTO 8 – July 2016

NOTE: This is not endorsed by Anandtech, they have no legal obligations in this if I decide to screw you all over or something.

BUY IN = $10

In the past some have put in more money, but let it be known, if we win, we will still all get an equal share. But we will all thank you greatly for the extra contribution, and I will let it be known who was nice enough to bump it up (if you so wish, or I can keep it anonymous). If you want to add a buy in for a spouse/SO make sure to fill the form out TWICE with unique info so I can contact you each individually.

DEADLINE: Friday July 8, 2016
230PM Pacific
330PM Mountain
430PM Central
530PM Eastern

EXAMPLE WINNING SCENARIO:

We win $250,000, 50 people bought in, we split $250,000 – tax cut / 50. We will be doing a lump payout, and we will use some of the funds to have a lawyer do the divvy process, to try and levvy as much tax saving as we can. I am thinking I take the tax cut (Minnesota), and say we’re an anonymous group of friends who won. I will then divide it up how you like … I can mail a check, cash, MO, etc, will let the lawyer make the decision for us. We have options, but like I said, let’s not worry about it until we win 🙂

or split it pretax and you collect yourself and pay your taxes. If I recall someone said that was an option.

STEP 1 :

send $10 via venmo (preferred), google wallet, or Amazon Gift card, IF YOU SEND AS CC, ADD 3%:

Venmo address: done
Google wallet: done
Amazon GC: much prefer venmo, but this option is still possible: done

If you have heatware, I could also do a MO/cash/check, but email me first for my address.

STEP 2 :
Fill this quick form out :
http://goo.gl/forms/nfOEU5FReUgxZ7Am1

This way I can keep track of everyone two fold, and then send a quick email once I get the actual tickets and we can split up the data entry work as we did last time. I will also update this blog post.

TIME TO WIN!

giphy

UPDATE: 7-6-2016 2P CST
buy in is live, tell your friends

UPDATE: 7-7-2016 8A CST
34 buys in so far!

update: 7-8-2016 8A CST
59 buyins so far!

update: 7-8-2016 11:30A CST
64 buyins and climbing, sent a final reminder email out.

update: 7-8-2016 2:30P CST
We’re at roughly 77 now.

update 7-8-2016 4:30P CST
All done, RossMan will go grab the tickets.
total tally was: 88 buyins!

Update 8-8-2016 6:16P CST
Kaaash
IMG_20160708_153858

update 7-8-2016 10:14P CST
Sooooooo we got the numbers. Funny story, RossMan/7-11 might have screwed up, or really did us a solid, and the last 4 tickets are 10 draws a ticket. It’s an honest mistake, so make sure you make fun of him :). Not everyone is used to getting almost $900 in tickets.

But to business, can you guys enter the numbers as we used to here:

https://docs.google.com/spreadsheets/d/10ArDIDyj9HZf8ejGYotpgHjcg9l2YN1nPbiCEQIR-94/edit?usp=sharing

MegaMillions AT Lotto 8

update 7-8-2016 10:40P CST
just did the tally, we are not millionaires, but we had fun, and we can now make fun of RossMan forever!

update 7-17-2016 9:A CST
Looks like the pot was won Friday, so we shall see who draws it!

Categories
Uncategorized

AT LOTTO 7

NOTE: This is not endorsed by Anandtech, they have no legal obligations in this if I decide to screw you all over or something.

RULES :
BUY IN = $10

In the past some have put in more money, but let it be known, if we win, we will still all get an equal share. But we will all thank you greatly for the extra contribution, and I will let it be known who was nice enough to bump it up (if you so wish, or I can keep it anonymous).

DEADLINE: Today Wed Jan 13, 2016
10AM Pacific
11AM Mountain
12PM Central
1PM Eastern

EXAMPLE WINNING SCENARIO:

We win $250,000, 50 people bought in, we split $250,000 – tax cut / 50. We will be doing a lump payout, and we will use some of the funds to have a lawyer do the divvy process, to try and levvy as much tax saving as we can. I am thinking I take the tax cut (Minnesota), and say we’re an anonymous group of friends who won. I will then divide it up how you like … I can mail a check, cash, MO, etc, will let the lawyer make the decision for us. We have options, but like I said, let’s not worry about it until we win 🙂

or split it pretax and you collect yourself and pay your taxes. If I recall someone said that was an option.

STEP 1 :

send $10 via venmo (preferred), google wallet, or Amazon Gift card, IF YOU SEND AS CC, ADD 3%:

Venmo address: done
Google wallet: done
Amazon GC: I already got a lot of GC, would rather have more cash to pull out come Wed, unless someone can really only send Amazon GC then you can use done

If you have heatware, I could also do a MO/cash/check, but email me first for my address.

STEP 2 :
Fill this quick form out :
https://docs.google.com/forms/d/1tMYxfSyH7OOcZm2Qk52XpGFhUpJX6-krFMWn1jBNZ6I/viewform?usp=send_form

This way I can keep track of everyone two fold, and then send a quick email once I get the actual tickets and we can split up the data entry work as we did last time. I will also update this blog post.

UPDATE : 1-11-2016 2P CST
We are at about $300, or 30 people so far. I was also told the post will probably get removed, so spread the word via email, or PM…if anyone wants to hit me up via email, or PM they can.

UPDATE: 1-11-2016 3:06P CST
33 Users, or $330
My favorite comment so far:
“When we win and we are on vacation somewhere, I will rub some sun block on your back.”

update 1-12-2016 8A CST
We are at 57 users so far!

update 1-12-2016 11:55A
65 peeps so far.
quality jokes: “When we win I’ll finally get to do my LOTR remake with an all guinea pig cast.”

update 1-13-2016 8:47A
We are at 81 people, I will probably have to stop accepting around noon CST so I can go to the bank at lunch and find time this evening to grab all the tickets!

update 1-13-2016 12P
Final tally – 87, or $870 worth of tickets.
Closed up! I am going to grab the tickets shortly, will scan and post later tonight so we can start data entering.
I will also send a follow up email to everyone now, if you do not receive it by 1230P – 1P shoot me an email/pm so I can make sure I have your email.
This will be the PB entry form link + area to chat:
https://docs.google.com/spreadsheets/d/1boUuQLr4Rc9U4l6Bwg6F6hjdWXGvNKv3cq6u7C7T26Y/edit?usp=sharing

update 1-13-2016 12:15P
SnipeMasterJ13 snuck in at the last second, 88. I feel better with an even amount of people!

update 1-13-2016 1:15P
a little tease before I get home to scan them all
IMG_20160113_124254

update 1-13-2016 6:45P
I uploaded pictures. I got a new camera, which seemed to take high enough quality it all showed up in 4 pictures:
http://langeeks.net/etc/ATLotto7/

This should make it MUCH easier. In the top left of the ticket is a number, just go to the left of this document:
https://docs.google.com/spreadsheets/d/1boUuQLr4Rc9U4l6Bwg6F6hjdWXGvNKv3cq6u7C7T26Y/edit?usp=sharing

And enter them in the 10 corresponding lines! I’ll dump it in my excel document that will calculate what we win so it does the math. The google Doc removes the math.

If anyone else wants to see, here’s the template I was given back in 2012 when we started courtesy of Ryan P.

update 1-13-2016 10:22P
We got $44! So far looks like a winner was in Cali.

Categories
Uncategorized

Hide Windows 7 desktop icons through registry and a command or bat file

If you want to hide certain desktop icons via a bat file, you can use this. Just read the REM line to see which 4 registry adds will change a specific icon. I needed this to roll out to a couple hundred computers, versus logging on to them and disabling them individually.

REM hide Computer icon on the desktop
REG ADD "HKEY_CURRENT_USER\Software\Microsoft\Windows\CurrentVersion\Explorer\HideDesktopIcons\NewStartPanel" /v "{20D04FE0-3AEA-1069-A2D8-08002B30309D}" /t REG_DWORD /d 1 /f
REG ADD "HKEY_CURRENT_USER\Software\Microsoft\Windows\CurrentVersion\Explorer\HideDesktopIcons\ClassicStartMenu" /v "{20D04FE0-3AEA-1069-A2D8-08002B30309D}" /t REG_DWORD /d 1 /f
REG ADD "HKEY_CURRENT_USER\Software\Microsoft\Windows\CurrentVersion\Explorer\HideDesktopIcons\NewStartPanel" /v "{20D04FE0-3AEA-1069-A2D8-08002B30309D}" /t REG_DWORD /d 1 /f
REG ADD "HKEY_CURRENT_USER\Software\Microsoft\Windows\CurrentVersion\Explorer\HideDesktopIcons\ClassicStartMenu" /v "{20D04FE0-3AEA-1069-A2D8-08002B30309D}" /t REG_DWORD /d 1 /f
REM hide Control Panel icon on the desktop
REG ADD "HKEY_CURRENT_USER\Software\Microsoft\Windows\CurrentVersion\Explorer\HideDesktopIcons\NewStartPanel" /v "{5399E694-6CE5-4D6C-8FCE-1D8870FDCBA0}" /t REG_DWORD /d 1 /f
REG ADD "HKEY_CURRENT_USER\Software\Microsoft\Windows\CurrentVersion\Explorer\HideDesktopIcons\ClassicStartMenu" /v "{5399E694-6CE5-4D6C-8FCE-1D8870FDCBA0}" /t REG_DWORD /d 1 /f
REG ADD "HKEY_CURRENT_USER\Software\Microsoft\Windows\CurrentVersion\Explorer\HideDesktopIcons\NewStartPanel" /v "{5399E694-6CE5-4D6C-8FCE-1D8870FDCBA0}" /t REG_DWORD /d 1 /f
REG ADD "HKEY_CURRENT_USER\Software\Microsoft\Windows\CurrentVersion\Explorer\HideDesktopIcons\ClassicStartMenu" /v "{5399E694-6CE5-4D6C-8FCE-1D8870FDCBA0}" /t REG_DWORD /d 1 /f
REM hide User's Files icon on the desktop
REG ADD "HKEY_CURRENT_USER\Software\Microsoft\Windows\CurrentVersion\Explorer\HideDesktopIcons\NewStartPanel" /v "{59031a47-3f72-44a7-89c5-5595fe6b30ee}" /t REG_DWORD /d 1 /f
REG ADD "HKEY_CURRENT_USER\Software\Microsoft\Windows\CurrentVersion\Explorer\HideDesktopIcons\ClassicStartMenu" /v "{59031a47-3f72-44a7-89c5-5595fe6b30ee}" /t REG_DWORD /d 1 /f
REG ADD "HKEY_CURRENT_USER\Software\Microsoft\Windows\CurrentVersion\Explorer\HideDesktopIcons\NewStartPanel" /v "{59031a47-3f72-44a7-89c5-5595fe6b30ee}" /t REG_DWORD /d 1 /f
REG ADD "HKEY_CURRENT_USER\Software\Microsoft\Windows\CurrentVersion\Explorer\HideDesktopIcons\ClassicStartMenu" /v "{59031a47-3f72-44a7-89c5-5595fe6b30ee}" /t REG_DWORD /d 1 /f
REM hide Network icon on the desktop
REG ADD "HKEY_CURRENT_USER\Software\Microsoft\Windows\CurrentVersion\Explorer\HideDesktopIcons\NewStartPanel" /v "{F02C1A0D-BE21-4350-88B0-7367FC96EF3C}" /t REG_DWORD /d 1 /f
REG ADD "HKEY_CURRENT_USER\Software\Microsoft\Windows\CurrentVersion\Explorer\HideDesktopIcons\ClassicStartMenu" /v "{F02C1A0D-BE21-4350-88B0-7367FC96EF3C}" /t REG_DWORD /d 1 /f
REG ADD "HKEY_CURRENT_USER\Software\Microsoft\Windows\CurrentVersion\Explorer\HideDesktopIcons\NewStartPanel" /v "{F02C1A0D-BE21-4350-88B0-7367FC96EF3C}" /t REG_DWORD /d 1 /f
REG ADD "HKEY_CURRENT_USER\Software\Microsoft\Windows\CurrentVersion\Explorer\HideDesktopIcons\ClassicStartMenu" /v "{F02C1A0D-BE21-4350-88B0-7367FC96EF3C}" /t REG_DWORD /d 1 /f
REM hide recycle bin from desktop
REG ADD "HKEY_CURRENT_USER\Software\Microsoft\Windows\CurrentVersion\Explorer\HideDesktopIcons\NewStartPanel" /v "{645FF040-5081-101B-9F08-00AA002F954E}" /t REG_DWORD /d 1 /f
REG ADD "HKEY_CURRENT_USER\Software\Microsoft\Windows\CurrentVersion\Explorer\HideDesktopIcons\ClassicStartMenu" /v "{645FF040-5081-101B-9F08-00AA002F954E}" /t REG_DWORD /d 1 /f
REG ADD "HKEY_CURRENT_USER\Software\Microsoft\Windows\CurrentVersion\Explorer\HideDesktopIcons\NewStartPanel" /v "{645FF040-5081-101B-9F08-00AA002F954E}" /t REG_DWORD /d 1 /f
REG ADD "HKEY_CURRENT_USER\Software\Microsoft\Windows\CurrentVersion\Explorer\HideDesktopIcons\ClassicStartMenu" /v "{645FF040-5081-101B-9F08-00AA002F954E}" /t REG_DWORD /d 1 /f
REM hide libraries icon from the desktop
REG ADD "HKEY_CURRENT_USER\Software\Microsoft\Windows\CurrentVersion\Explorer\HideDesktopIcons\NewStartPanel" /v "{031E4825-7B94-4DC3-B131-E946B44C8DD5}" /t REG_DWORD /d 1 /f
REG ADD "HKEY_CURRENT_USER\Software\Microsoft\Windows\CurrentVersion\Explorer\HideDesktopIcons\ClassicStartMenu" /v "{031E4825-7B94-4DC3-B131-E946B44C8DD5}" /t REG_DWORD /d 1 /f
REG ADD "HKEY_CURRENT_USER\Software\Microsoft\Windows\CurrentVersion\Explorer\HideDesktopIcons\NewStartPanel" /v "{031E4825-7B94-4DC3-B131-E946B44C8DD5}" /t REG_DWORD /d 1 /f
REG ADD "HKEY_CURRENT_USER\Software\Microsoft\Windows\CurrentVersion\Explorer\HideDesktopIcons\ClassicStartMenu" /v "{031E4825-7B94-4DC3-B131-E946B44C8DD5}" /t REG_DWORD /d 1 /f

Categories
Uncategorized

power shell script unmounting system reserved

I need a powershell way to remove the system reserved drive letter, as there is no reason for our users to actually use that, and access it. In powershell drop this code in:

$target = (Get-Volume -FileSystemLabel “System Reserved”).DriveLetter+ “:”
$volume = Get-WmiObject Win32_Volume -Filter “DriveLetter=’$target'”

if ($null -ne $volume)
{
$volume.DriveLetter = $null
$volume.Put()
}

Save it, make sure it’s a ps1 file and execute, it will remove the Drive Letter, and unmount it.