Wednesday, December 14, 2022

Install homebrew mac m1 monterey to run xforce keygen

/bin/bash -c "$(curl -fsSL https://raw.githubusercontent.com/Homebrew/install/HEAD/install.sh)"

commands: 
brew --version 
brew install upx 
upx --version 
sudo upx -d {drag keygen from desktop to terminal}

Run these three commands in your terminal to add Homebrew to your PATH:

    echo '# Set PATH, MANPATH, etc., for Homebrew.' >> /Users/architectfaishalbhuiya/.zprofile

    echo 'eval "$(/opt/homebrew/bin/brew shellenv)"' >> /Users/architectfaishalbhuiya/.zprofile

    eval "$(/opt/homebrew/bin/brew shellenv)"


see:
https://brew.sh/

MacPro M1 Monterey Xforce Keygen not opening


Instructions:

Copy xf-adesk19 to your Desktop


Open terminal  (Command+Space and type Terminal and press enter/return key)


Paste the following code in terminal:


Code Block 

ruby -e "$(curl -fsSL https://raw.githubusercontent.com/Homebrew/install/master/install)" < /dev/null 2> /dev/null

Wait for the command to finish. After completion run the following code:


Code Block 

brew install upx

Now run this command:


Code Block 

sudo upx -d ~/Desktop/xf-adesk19.app/Contents/MacOS/x-force

Close the terminal and open the xf-adesk19 on your Desktop.


Done!




Install rosetta 2 on Mac M1 2021 Pro

softwareupdate -install-rosetta -agree-to-license

or
softwareupdate --install-rosetta

Monday, December 5, 2022

Update columns values with column of another table based on condition in SQL command


UPDATE table1 SET price=(SELECT price FROM table2 WHERE table1.id=table2.id);

or,
UPDATE table1 SET table1.price=(SELECT table2.price FROM table2 WHERE table2.id=table1.id AND table2.item=table1.item);

or,
UPDATE event INNER JOIN cualumni ON event.user_id = cualumni.eid SET event.user_id = cualumni.id;


Or,

UPDATE table1 INNER JOIN table2 ON table1.id = table2.id SET table1.Price = table2.price

Sunday, December 4, 2022

Convert a putty .ppk key to an Amazon .pem file on Mac

$ brew install putty

$ puttygen key.ppk -O private-openssh -o key.pem

Or,

$ openssl x509 -in certificatename.cer -outform PEM -out certificatename.pem

Migrate Linux server to AWS EC2

Visit: AWS Replication Agent installation 
https://us-west-2.console.aws.amazon.com/mgn/home?region=us-west-2#/sourceServers/addServers

wget -O ./aws-replication-installer-init.py https://aws-application-migration-service-us-west-2.s3.us-west-2.amazonaws.com/latest/linux/aws-replication-installer-init.py


sudo python3 aws-replication-installer-init.py --region us-west-2

Saturday, December 3, 2022

Reinstall MySQL in virtualmin



sudo apt purge mysql-server mysql-client mysql-common
sudo apt autoremove
sudo mv -iv /var/lib/mysql /var/tmp/mysql-backup
sudo rm -rf /var/lib/mysql*

Then goto webmin dashboard>Server>MySQL Database Server>Install


Office 2021 Activation using command

  @echo off title Activate Microsoft Office 2021 (ALL versions) for FREE - office.com&cls&echo =====================================...