Reggie Goldman

Remove the plugin

[mysql] use mysql;
[mysql] update user set plugin=” where User=’root’;
[mysql] flush privileges;
[mysql] \q

https://stackoverflow.com/questions/36864206/sqlstatehy000-1698-access-denied-for-user-rootlocalhost

Run smartctl –scan to print all devices attached including the device id and RAID type:

# smartctl –scan
/dev/sda -d scsi # /dev/sda, SCSI device
/dev/bus/0 -d megaraid,0 # /dev/bus/0 [megaraid_disk_00], SCSI device
/dev/bus/0 -d megaraid,1 # /dev/bus/0 [megaraid_disk_01], SCSI device
/dev/bus/0 -d megaraid,2 # /dev/bus/0 [megaraid_disk_02], SCSI device

https://serverfault.com/questions/620019/smartctl-megaraid-how-to-find-the-right-device-node-for-an-adapter

https://unix.stackexchange.com/questions/485463/smartctl-megaraid-n-how-to-find-the-right-value-for-n

Powershell:

$a = New-Object -ComObject shell.application

$a.NameSpace( “N:\” ).self.name = “LABEL”

get-mailbox | select -expand alias > alias.txt

$content = get-content C:\users\user\desktop\alias.txt

foreach ($user in $content) {

New-MailboxExportRequest -Mailbox $user -FilePath \\fileserver\export\$user.pst }

Setup script:

#!/bin/bash

echo ‘[Unit]
Description=/etc/rc.local
ConditionPathExists=/etc/rc.local

[Service]
Type=forking
ExecStart=/etc/rc.local start
TimeoutSec=0
StandardOutput=tty
RemainAfterExit=yes
SysVStartPriority=99

[Install]
WantedBy=multi-user.target’ > /etc/systemd/system/rc-local.service

echo ‘#!/bin/sh -e
#
# rc.local
#
# This script is executed at the end of each multiuser runlevel.
# Make sure that the script will “exit 0” on success or any other
# value on error.
#
# In order to enable or disable this script just change the execution
# bits.
#
# By default this script does nothing.

exit 0’ > /etc/rc.local

chmod +x /etc/rc.local
systemctl enable rc-local

https://www.adminsehow.com/2019/10/how-to-add-rc-local-in-debian-9-10/
https://www.troublenow.org/752/debian-10-add-rc-local/

Check/disable .htaccess for redirects, etc

Useful for Supermicro BIOS updates etc

Download FDOEMCD.zip, copy files to CDROOT, use makeiso.bat

FDOEMCD

https://support.siliconmechanics.com/portal/en/kb/articles/creating-freedos-bootable-iso

.htaccess:
AuthName "Dialog prompt"
AuthType Basic
AuthUserFile /home/username/example.com/.htpasswd
Require valid-user

Auth File:
htpasswd -c /home/username/example.com/.htpasswd user1

At the bottom of sshd_config:

Port 5000
Match User root, LocalPort 5000
DenyUsers root

https://serverfault.com/questions/247291/forced-per-user-ssh-port

RewriteEngine on
RewriteCond %{REQUEST_URI} !/maintenance.php$
RewriteRule $ /maintenance.php [R=302,L]