SSH from Public Instance to Private Instance
ssh -t -o ProxyCommand="ssh -i id_rsa ubuntu@PUBLICIP -W %h:%p" -i id_rsa ubuntu@PRIVATEIP
Create CRT
openssl req -new -newkey rsa:2048 -nodes -keyout domain.co.key -out domain.co.csr
Boot Strap Command for nginx on Ubuntu on OCI
#!/bin/bash
sudo apt update
sudo apt install nginx -y
sudo systemctl start nginx.service
systemctl status nginx
sudo iptables -I INPUT -p tcp --dport 80 -m conntrack --ctstate NEW,ESTABLISHED -j ACCEPT
sudo iptables -I OUTPUT -p tcp --sport 80 -m conntrack --ctstate ESTABLISHED -j ACCEPT
https://ubuntu.com/tutorials/install-and-configure-nginx#4-setting-up-virtual-host
Command to Install docker/compose on Oracle Linux and run potsgres on OCI
#!/bin/bash
sudo dnf config-manager --add-repo=https://download.docker.com/linux/centos/docker-ce.repo
sudo dnf install docker-ce --nobest -y
sudo systemctl enable --now docker
sudo usermod -aG docker root
sudo systemctl disable firewalld
sudo sudo curl -L "https://github.com/docker/compose/releases/download/v2.12.2/docker-compose-$(uname -s)-$(uname -m)" -o /usr/local/bin/docker-compose
sudo sudo mv /usr/local/bin/docker-compose /usr/bin/docker-compose
sudo chmod +x /usr/bin/docker-compose
sudo docker run -d -p 5432:5432 --name postgres -e POSTGRES_PASSWORD=changeme postgres
sudo docker exec -it postgres bash
Command to Install and Configure Apache, PHP 8, MySQL, and WordPress on OCI
#!/bin/bash
sudo iptables -I INPUT 6 -m state --state NEW -p tcp --dport 80 -j ACCEPT
sudo netfilter-persistent save
sudo apt update
sudo apt -y install apache2
sudo systemctl restart apache2
sudo apt -y install php
sudo apt -y install php-mysql php-curl php-gd php-zip
sudo systemctl restart apache2
sudo adduser $USER www-data
sudo chown -R www-data:www-data /var/www/html
sudo chmod -R g+rw /var/www/html
Command to Point the Wordpress server to point to NFS
#!/bin/bash
sudo systemctl stop apache2
sudo mv /var/www /var/www-old
sudo mkdir /var/www
sudo mount -t nfs 20.0.1.94:/wordpress /var/www
sudo systemctl restart apache2
When WP is migrated to new Host, wp-admin still points to the old host. How to fix this.
mysql> show databases;
mysql> use <wordpressdb>;
mysql> desc wp_options;
mysql> select option_name from wp_options;
mysql> select option_name from wp_options where option_name = 'siteurl';
mysql> update wp_options set option_value = 'http://<NEW HOST>' where option_name ='siteurl';
mysql> select * from wp_options where option_name = 'home';
update wp_options set option_value ='http://<NEW HOST' where option_name = 'home';
WP website migrated to HTTPS, images are gone. Add the following lines in wp-config.php
if (isset($_SERVER["HTTP_X_FORWARDED_PROTO"] ) && "https" == $_SERVER["HTTP_X_FORWARDED_PROTO"] ) {
$_SERVER["HTTPS"] = "on";
}
How to import and export the Mysql Dump
`mysqldump --no-tablespaces -h 20.0.1.45 -u wordpress -p wordpress > wpdump.sql
mysql -h 20.0.1.137 -u wordpress -p wordpress < wpdump.sql `
https://docs.oracle.com/en-us/iaas/developer-tutorials/tutorials/wp-on-ubuntu/01-summary.htm
https://www.tecmint.com/fix-error-2003-hy000-cant-connect-to-mysql-server-on-127-0-0-1-111/
https://serverfault.com/questions/139323/how-to-bind-mysql-server-to-more-than-one-ip-address
https://stackoverflow.com/questions/8020297/mysql-my-cnf-file-found-option-without-preceding-group
CREATE USER 'bob'@'10.0.0.0/255.0.0.0' IDENTIFIED BY 'password123';
Top comments (0)