Categories
General Computing

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
General Computing

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
Computer Hardware Windows 10

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
Gaming General Computing Video Cards

nvidia color settings resetting after reboot

I am using the nvidia settings to manage some color settings, and as of a recentish anniversary update for windows 10, it kept resetting every reboot. Luckily someone at Tom’sHardware found the resolution, which I am shamelessly posting here with source:

This issue is caused by the WindowsColorSystem scheduled task running at user logon. The NVIDIA driver hooks the user’s logon and then applies the settings, however, the Microsoft scheduled task that initializes the Windows Color System runs just after and loads the default color profile for the monitor (timing issue). Since I prefer to use the driver manufacturers’ control panels to manage my color settings, I disable the “Task Scheduler Library\Microsoft\Windows\WindowsColorSystem\Calibration Loader” task.

Categories
Computer Hardware Gaming

ncase m1 v5 and i9 9900k work great

I just built my new rig, and the temps are solid. When running a stock blend test, I am getting about 70-75C. I could use more fans, I am only running the two on the cooler, and 1 120mm case fan.

ncase m1 v5
nvidia 1080 gtx FE
ADATA SX8200 PCIE NVME GEN3X4 m.2 2280 960GB ASX8200NP-960GT-C
ADATA XPG GAMMIX D10 16GB (2x8GB) DDR4 3200 (PC4 21300) AX4U320038G16-DB10
ASRock Z390 PHANTOM GAMING-ITX/AC LGA 1151
Intel i9 9900k
be quiet! dark rock TF air cooler
Corsair SF600

The only issue I had was some slight fitment with the be quiet cooler. I made zero alterations, but you can see it’s definitly a little tight with the Ram, as it’s pushing it a smidge. Not enough to worry me though. If I had lower profile sticks, it’d be fine.

Categories
Plex

Using plex locally while on openVPN

Do you have a windows server running openvpn, and your plex server at home? If you ever wanted the ability to have plex work local, vice over the internet and back in while you are at home, it’s pretty simple. This will work on any client side openvpn config file. You just need to add this one route in the config file:

route plex.tv 255.255.255.0 192.168.1.1

replace 192.168.1.1 with whatever your router IP address is, boom, problem solved. There used to be a few other domains you have to route, and some IP addresses you had to keep track of, but now plex made it easy, just plex.tv works. I had the issue where anytime I had openvpn running and connected on this server, my tablet connected on the same subnet would try to route traffic for my plex application over the internet. When I went to play a video it would say “you are not direct connected, do you want to play this file still”? This resolved it, and running a tcpdump on my firewall, I see the traffic is not leaving, huzzah!

Categories
Dell Servers

Dell idrac6 enterprise update – getting Dell iDRAC undefined” and “The webpage cannot be found” errors

I kept getting these errors when I would log into my older idrac 6 cards. You can fixing it by putting IE11 into compatability mode, but I also found it easier to update the idrac to the latest 2.91 version. These were the errors I was getting:

I updated one as far back as 1.43 to this version, no middle version required. Enjoy! I pulled these files right off of dells website. The only file you need to upload is the firming.d6. It was taken out of the ESM_Firmware_MXKG2_WN32_2.91_A00.EXE.

Dell iDRAC Monolithic Release 2.91
http://vivithemage.com/extra/Dell-11G/firmimg.d6

If you want to use the virutal console, you will probably have to switch from native to JAVA, as native was not working for me in my old firefox version, or IE11, even with compatibility enabled.

Categories
Dell Servers

No update is available error in Dell 11G and older servers workaround

I had this issue updating my older R410, R610, and R710 servers the other day. You can still update idrac 6 via idrac, but they have since decomissioned ftp.dell.com as the repo for the lifecycle controller for some lame reason, see:
“Due to LC memory limitations only in 11G servers, Dell Engineering had to remove all 11G firmware and BIOS Dell Update Packages (DUPs) from the LC Catalog. The change was necessary due to the LC Catalog’s growing size, as it also added BIOS and firmware versions for 12G, 13G, and 14G servers being introduced.”

Luckily they made a work around that can be found here:
https://www.dell.com/support/article/us/en/04/sln310452/lifecycle-controller-lc-firmware-update-error-no-update-is-available-on-any-11g-server?lang=en
If that no longer works, here is a snippet of it:

Lifecycle Controller (LC) Firmware Update error “No update is available” on any 11G server

No update is available. Make sure that the Windows(R) catalog and Dell(TM) Update Packages for Windows(R) are used.

This is working as designed as of March 2018. Due to LC memory limitations only in 11G servers, Dell Engineering had to remove all 11G firmware and BIOS Dell Update Packages (DUPs) from the LC Catalog. The change was necessary due to the LC Catalog’s growing size, as it also added BIOS and firmware versions for 12G, 13G, and 14G servers being introduced.

Note that LC Firmware Update continues to work normally with all 12G – 14G servers. Catalog-based tools that can update 11G firmware such as OpenManage Essentials (OME) or System Center Updates Publisher (SCUP) will also still identify and push applicable 11G updates, since they can push and run DUPs “in-band” on the target host’s operating system, which has no memory limitations like LC.

To ensure the BIOS and firmware for your 11G servers are kept up-to-date, the suggested workaround is to use Dell Repository Manager (DRM) (I also got a copy of DRMInstaller_3.0.1.423.exe just in case that take it down, which you can get here: http://vivithemage.com/extra/Dell-11G/) to select the applicable 11G server models and then export a smaller custom Catalog that 11G LC can process. DRM can either:

Export both the custom Catalog.xml catalog and various DUP packages to an ISO image or directory intended to be stored on a file share that LC can access.
Export just the custom Catalog.xml file, which by default still points LC Update online to ftp.dell.com, making it unecessary to download all applicable DUPs to a local site.
Follow the steps below to export the custom Catalog in DRM:

In the main DRM homepage, click the “Add Repository” button.
Give the repository a name and choose the newest dated “Enterprise Server Catalog” in the “Base Catalog” menu.
Select the “Manual” tab and then click the “Custom” button under “Select Systems,” then click “Choose Systems.”
Only select “PowerEdge” in the “Line of Business” menu, and then click on each applicable 11G server model to move it into the “Selected Systems” list.
Click “Save” to return.
Click the “Custom” button under “Operating Systems,” then the “Choose” button.
Under the “Operating Systems” menu, choose only “Windows-32” and no other OSs.
IMPORTANT: A custom LC catalog can only list either Windows 32-bit or 64-bit DUPs, not both. All applicable 11G firmware and BIOS updates are still in the Windows 32-bit format, unlike newer server models. Do not choose Linux as 11G cannot process the Linux DUP format.
Click “Windows Server 2008 X64” to add to the “Selected Operating Systems” list, then click “Save.”
Under the “Components” section, simply choose “All component types” then click “Add.”
Once the new repository is added to the main DRM homepage, check its box and click the “Export” button.
There are several export formats available. Choosing “SUU ISO” exports the Catalog to an image file that LC Update can load via local or iDRAC virtual media. Otherwise, if you intend to mount the custom catalog in LC from a remote file share, choose the “Share” tab and then click “Browse” to specify a local directory path to save the Catalog.xml file and (optionally) all of the downloaded DUPs.
If the target hosts are intended to each connect online directly to ftp.dell.com, then check “Export only catalog.” Otherwise all Windows 32-bit DUPs applicable to the selected 11G server models will also be downloaded to the same local directory. This could make the directory large in size depending on how many DUPs are applicable.
Copy the directory containing the Catalog.xml file (and possible DUPs) to the intended file share server.
Once booted into LC Firmware Update, choose the appropriate file share protocol (FTP, CIFS, etc.) to connect to the remote file share containing Catalog.xml.

Quick Tips content is self-published by the Dell Support Professionals who resolve issues daily. In order to achieve a speedy publication, Quick Tips may represent only partial solutions or work-arounds that are still in development or pending further proof of successfully resolving an issue. As such Quick Tips have not been reviewed, validated or approved by Dell and should be used with appropriate caution. Dell shall not be liable for any loss, including but not limited to loss of data, loss of profit or loss of revenue, which customers may incur by following any procedure or advice set out in the Quick Tips.

Categories
CentOS 7 Operating Systems

How to enable ip forwarding on CentOS 7

I wanted to enable IP masquerading/forwarding on CentOS 7.5, but for some reason, the typical method was not working. My clients could connect, but no traffic was passing beyond the VPS, and on to the internet. I was pretty sure it was my firewall masquerade rule was acting up, but no. It ended up being the kernel routing that you typically set in /etc/sysctl.conf as

net.ipv4.ip_forward = 1 I also tried net.ipv4.conf.default.forwarding = 1

I ended up needing to use the new method, which was actually in the top comment section of the sysctl.conf file. Which refernces using /usr/lib/sysctl.d/50-default.conf
add this line to the bottom of that file: net.ipv4.ip_forward = 1

Reboot, problem solved, started routing traffic outside of the VM.

Categories
Computer Hardware HP VMWare ESXi

HP GEN8 Microserver Raid 5 transform times with 4x8TB WD RED’s

I opted to drop a 4th 8TB WD RED in my raid 5 array on my HP Microserver Gen8. It has a P222 raid card in it running the latest, as of today firmware: 8.32. I had the server running for about 2 years in it’s current configuration, with no issues, but I wanted a little more disk. If I had more slots, I would have opted for a raid 10, but I wanted smaller footprint, so this is what I am working with.

So far the transform has been about 36 hours, and running:

/opt/smartstorageadmin/ssacli/bin/ssacli ctrl slot=1 ld 1 show

in ESX 6.7, I am at 40%, oooofta. I imagine rebuilds with these large disks would be just as painful. Good news though, Unrecoverable Media Errors is 0.

MAKE SURE YOU HAVE BACKUPS, AND THAT YOU TEST SAID BACKUPS!!
MAKE SURE YOU HAVE BACKUPS, AND THAT YOU TEST SAID BACKUPS!!

Also make backups before you toy around with your raid, I have backups if this goes south, but always have backups.

Did I mention, HAVE BACKUPS AND TEST SAID BACKUPS!!