Wordpress with Postgres Vagrant recipe

provision.sh

set -e -x

apt update

apt install -y apache2 \
    php \
    php-cli \
    php-mysqlnd \
    php-pgsql \
    postgresql-common \
    wget \
    curl \
    zip \
    unzip \
    git

/usr/share/postgresql-common/pgdg/apt.postgresql.org.sh

apt install -y postgresql-16

su - postgres <<EOF
 psql -c "create user wp_dba password 'wp_dba_pass'"
 psql -c "create database wp_db owner wp_dba"
EOF

wget https://wordpress.org/latest.zip

unzip latest.zip

cp -a wordpress /var/www/html

git clone https://github.com/PostgreSQL-For-Wordpress/postgresql-for-wordpress.git

cp -a postgresql-for-wordpress/pg4wp /var/www/html/wordpress/wp-content

cp postgresql-for-wordpress/pg4wp/db.php /var/www/html/wordpress/wp-content

cd /var/www/html/wordpress

cp wp-config-sample.php wp-config.php

sed -i -e 's/database_name_here/wp_db/' \
    -e 's/password_here/wp_dba_pass/' \
    -e 's/username_here/wp_dba/' \
    wp-config.php

chown -R www-data:www-data /var/www/html/wordpress

# run the wordpress install unattended,
# should be able to login right after this

 curl "http://localhost/wordpress/wp-admin/install.php?step=2" \
  --data-urlencode "weblog_title=Test Site"\
  --data-urlencode "user_name=wp_admin" \
  --data-urlencode "[email protected]" \
  --data-urlencode "admin_password=wp_admin_pw" \
  --data-urlencode "admin_password2=wp_admin_pw" \
  --data-urlencode "pw_weak=1"  

 

Vagrantfile

ENV['VAGRANT_DEFAULT_PROVIDER'] = 'qemu'

# -*- mode: ruby -*-
# vi: set ft=ruby :

# All Vagrant configuration is done below. The "2" in Vagrant.configure
# configures the configuration version (we support older styles for
# backwards compatibility). Please don't change it unless you know what
# you're doing.
Vagrant.configure("2") do |config|
  # The most common configuration options are documented and commented below.
  # For a complete reference, please see the online documentation at
  # https://docs.vagrantup.com.

  # Every Vagrant development environment requires a box. You can search for
  # boxes at https://vagrantcloud.com/search.
  config.vm.box = "perk/ubuntu-2204-arm64"

  config.vm.network "forwarded_port", guest:80, host: 80

  config.vm.provision :shell, path: "provision.sh"
  
  # Disable automatic box update checking. If you disable this, then
  # boxes will only be checked for updates when the user runs
  # `vagrant box outdated`. This is not recommended.
  # config.vm.box_check_update = false

  # Create a forwarded port mapping which allows access to a specific port
  # within the machine from a port on the host machine. In the example below,
  # accessing "localhost:8080" will access port 80 on the guest machine.
  # NOTE: This will enable public access to the opened port
  # config.vm.network "forwarded_port", guest: 80, host: 8080

  # Create a forwarded port mapping which allows access to a specific port
  # within the machine from a port on the host machine and only allow access
  # via 127.0.0.1 to disable public access
  # config.vm.network "forwarded_port", guest: 80, host: 8080, host_ip: "127.0.0.1"

  # Create a private network, which allows host-only access to the machine
  # using a specific IP.
  # config.vm.network "private_network", ip: "192.168.33.10"

  # Create a public network, which generally matched to bridged network.
  # Bridged networks make the machine appear as another physical device on
  # your network.
  # config.vm.network "public_network"

  # Share an additional folder to the guest VM. The first argument is
  # the path on the host to the actual folder. The second argument is
  # the path on the guest to mount the folder. And the optional third
  # argument is a set of non-required options.
  # config.vm.synced_folder "../data", "/vagrant_data"

  # Disable the default share of the current code directory. Doing this
  # provides improved isolation between the vagrant box and your host
  # by making sure your Vagrantfile isn't accessible to the vagrant box.
  # If you use this you may want to enable additional shared subfolders as
  # shown above.
  # config.vm.synced_folder ".", "/vagrant", disabled: true

  # Provider-specific configuration so you can fine-tune various
  # backing providers for Vagrant. These expose provider-specific options.
  # Example for VirtualBox:
  #
  # config.vm.provider "virtualbox" do |vb|
  #   # Display the VirtualBox GUI when booting the machine
  #   vb.gui = true
  #
  #   # Customize the amount of memory on the VM:
  #   vb.memory = "1024"
  # end
  #
  # View the documentation for the provider you are using for more
  # information on available options.

  # Enable provisioning with a shell script. Additional provisioners such as
  # Ansible, Chef, Docker, Puppet and Salt are also available. Please see the
  # documentation for more information about their specific syntax and use.
  # config.vm.provision "shell", inline: <<-SHELL
  #   apt-get update
  #   apt-get install -y apache2
  # SHELL
end