Oline IT:Blog
Innovation Technology
Thursday, June 26, 2025
Restrict Access to PHPMyAdmin with DirectAdmin
Wednesday, June 18, 2025
How not to fill filtered out cells when dragging down from another sheet
Steps:
-
Apply your filter in Sheet1.
-
Select the range where you want to paste the formula (e.g.,
A2:A100
) but only visible cells will be selected.-
Select the range.
-
Press
F5
orCtrl+G
→ Click Special… → Choose Visible cells only → OK.
-
-
Type your formula (e.g.):
=INDEX(Sheet2!A:A, ROW()-1) -
Press
Ctrl+Enter
(instead of just Enter).
Saturday, May 3, 2025
Resetting the DirectAdmin Password via SSH:
Resetting the Password via SSH:
- Access the server as root: Use an SSH program like PuTTY to connect to your server as the root user.
- Reset the password: Execute the command
passwd <username>
(replace<username>
with your DirectAdmin username, oftenadmin
or your server username). - Follow the prompts: You'll be prompted to enter a new password twice.
- Verify the change: Once successful, you'll see a message confirming the password change.
- Restart DirectAdmin (optional): You may need to restart the DirectAdmin service using the command
service directadmin restart
.
Sunday, April 20, 2025
Reset WordPress Admin Password via MySQL Command Line
mysql -umyUserName -paVeryStrongPassword
use myWordpressDB;
Wednesday, March 19, 2025
Excel VBA Macro: Save Range (as PDF) and Send as Attachment in Email
Sub save_pdf_and_attach_in_email()
Dim OutApp As Object
Dim OutMail As Object
Dim ws As Worksheet
Dim pdf_range As Range
Dim pdf_path As String
Set OutApp = CreateObject("Outlook.Application")
Set OutMail = OutApp.CreateItem(0)
Set ws = ThisWorkbook.Sheets("Sheet 1")
Set pdf_range = ws.Range("A1:C11")
pdf_path = "C:\Users\greggowaffles\Documents\Youtube Videos\Test\Stats\" & _
"Population Data.pdf"
'align range in pdf
ws.PageSetup.CenterHorizontally = True
pdf_range.ExportAsFixedFormat Type:=xlTypePDF, _
Filename:=pdf_path, OpenAfterPublish:=False
'create email
On Error Resume Next
With OutMail
.to = "team@abc.com"
.CC = ""
.BCC = ""
.Subject = "Country Population Data " & Format(Date, "mm-dd-yyyy")
.Display
.HTMLBody = "<BODY style = 'font-size:12pt; font-family:Calibri'>" & _
"Hi Team,<p>Please see attached pdf file.<p>Thanks,<br>Greg" & .HTMLBody
.Attachments.Add pdf_path
End With
On Error GoTo 0
Set OutApp = Nothing
Set OutMail = Nothing
'Kill pdf_path
End Sub
Monday, February 24, 2025
How to inatall docker on Ubuntu using apt repository
# Add Docker's official GPG key:
sudo apt-get update
sudo apt-get install ca-certificates curl
sudo install -m 0755 -d /etc/apt/keyrings
sudo curl -fsSL https://download.docker.com/linux/ubuntu/gpg -o /etc/apt/keyrings/docker.asc
sudo chmod a+r /etc/apt/keyrings/docker.asc
# Add the repository to Apt sources:
echo \
"deb [arch=$(dpkg --print-architecture) signed-by=/etc/apt/keyrings/docker.asc] https://download.docker.com/linux/ubuntu \
$(. /etc/os-release && echo "${UBUNTU_CODENAME:-$VERSION_CODENAME}") stable" | \
sudo tee /etc/apt/sources.list.d/docker.list > /dev/null
sudo apt-get update
Install Latest version:
sudo apt-get install docker-ce docker-ce-cli containerd.io docker-buildx-plugin docker-compose-plugin
sudo docker run hello-world
Thursday, February 20, 2025
Reset Ubuntu with factory reset & and reinstall
Try configuring unconfigured packages:
sudo dpkg --configure -a
Update the contents of the repositories
sudo apt-get update
Try to fix missing dependencies:
sudo apt-get -f install
Update all packages with new versions available:
sudo apt-get full-upgrade
Reinstall Ubuntu desktop:
sudo apt-get install --reinstall ubuntu-desktop
Remove unnecessary packages:
sudo apt-get autoremove
Delete downloaded packages already installed:
sudo apt-get clean
Reboot the system to see if the issue was resolved:
sudo reboot
Restrict Access to PHPMyAdmin with DirectAdmin
cd /usr/local/directadmin/ ./directadmin set one_click_pma_login 1 restart cd custombuild ./build update ./build set phpmyadmin_public no ./...
-
Put the following code in a TXT file and save as "file.cmd" then run the cmd file as administrator. @echo off title Activate Micr...
-
We can install PowerMTA on the server. rpm -ivh /home/PowerMTA-4.0r6.x86_64.rpm You will see the output like this Preparing... #############...
-
# $Id: config 2015-03-24 16:00:00 Jack $ # Sample PowerMTA configuration file # PowerMTA Multiple Virtual PMTA config file sample # # E-mai...