Sunday, April 20, 2025

Reset WordPress Admin Password via MySQL Command Line


mysql -umyUserName -paVeryStrongPassword

show databases;
 
use myWordpressDB;

SELECT ID, user_login, user_pass FROM wp_users;

UPDATE wp_users SET user_pass=MD5('YourNewStrongPassword') WHERE ID = 1;

SELECT ID, user_login, user_pass FROM wp_users;

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

 

How to create a user in ubuntu with password giving all permissions ?

 o create a new user in Ubuntu with a password and grant them all permissions (including administrative privileges), follow these steps:

1. Create a New User

Run the following command, replacing username with your desired username:


sudo adduser username
  • You will be prompted to enter a password and some optional details.

2. Add User to the Sudo Group

To grant full administrative permissions, add the user to the sudo group:


sudo usermod -aG sudo username
  • This allows the user to execute commands as root using sudo.

3. Verify the User’s Permissions

Switch to the new user:


su - username

Then check if the user can run sudo commands:


sudo whoami

If it returns root, the user has full administrative access.

4. (Optional) Grant Passwordless Sudo Access

If you want the user to execute sudo commands without entering a password:


echo "username ALL=(ALL) NOPASSWD:ALL" | sudo tee /etc/sudoers.d/username

Now the user has full administrative privileges. 

Thursday, February 13, 2025

How to install Install and Configure Alfresco Community Edition

System requirements:

Based on these assumptions, the following options are recommended:
  1. 2 servers with the following specifications:
    • 4 CPUs
    • 32 GB RAM per server
    • Tomcat Java options:
      • Xms512M
      • Xmx 20 G
      • XX:MaxPermSize=256m
      • XX:-DisableExplicitGC
    • web.xml
      • maxThreads=2 50
    • 30 GB HDD space
    • Servers must be load-balanced the load-balancer must have:
      • Session affinity: enabled
      • Web server probe: recommended
  2. 4 servers with the following specifications
    • 4 CPUs
    • 16 GB RAM per server
    • Tomcat Java Options:
      • Xms512M
      • Xmx1 0 G
      • XX:MaxPermSize=256m
      • XX:-DisableExplicitGC
    • web.xml
      • maxThreads= 125
    • 30 GB HDD space
    • Servers must be load-balanced the load-balancer must have:
      • Session affinity: enabled
      • Web server probe : recommended
We can follow the following instructions:
Part 01 : https://medium.com/p/6ddd06416711

Part 03 : https://medium.com/p/bcde44232f59

Friday, January 10, 2025

Command to install direct admin on ubuntu 22.04

 sudo apt update

sudo apt upgrade

sudo apt install wget gcc g++ make flex bison openssl libssl-dev

cd /usr/local/src

wget https://www.directadmin.com/setup.sh

chmod +x setup.sh

sudo ./setup.sh

sudo ufw enable

sudo ufw allow 2222

sudo ufw allow 80

https://YOUR_SERVER_IP:2222

Reset WordPress Admin Password via MySQL Command Line

mysql -umyUserName -paVeryStrongPassword show databases;   use myWordpressDB; SELECT ID, user_login, user_pass FROM wp_users; UPDATE wp_user...