Contents

#!/bin/bash --login
source /etc/profile.d/globals.sh

if [[ $PWN_ROOT == '' ]]; then
  if [[ ! -d '/pwn' ]]; then
    pwn_root=$(pwd)
  else
    pwn_root='/pwn'
  fi
else
  pwn_root="${PWN_ROOT}"
fi

pwn_provider=`echo $PWN_PROVIDER`

pdb='pwn'

$screen_cmd "${apt} install -y postgresql ${assess_update_errors}"
grok_error

if [[ $pwn_provider == 'docker' ]]; then
  $screen_cmd "/etc/init.d/postgresql start ${assess_update_errors}"
  grok_error
else
  $screen_cmd "sudo systemctl enable postgresql ${assess_update_errors}"
  grok_error
  $screen_cmd "sudo systemctl restart postgresql ${assess_update_errors}"
  grok_error
fi


$screen_cmd "sudo -iu postgres createdb ${pdb} ${assess_update_errors}"
grok_error

function create_table() {
  current_table="${1}"
  pwn_table_def=$(cat <<EOF
    create table ${current_table} (
      id SERIAL PRIMARY KEY,
      row_result varchar(33000) NOT NULL
    );
EOF
  )
  echo $pwn_table_def | sudo -iu postgres psql -X -d $pdb
  grok_error
}

create_table 'sast'
create_table 'fuzz_net_app_proto'

Version data entries

829 entries across 829 versions & 1 rubygems

Version	Path
pwn-0.5.252	packer/provisioners/postgresql.sh
pwn-0.5.251	packer/provisioners/postgresql.sh
pwn-0.5.250	packer/provisioners/postgresql.sh
pwn-0.5.249	packer/provisioners/postgresql.sh
pwn-0.5.248	packer/provisioners/postgresql.sh
pwn-0.5.247	packer/provisioners/postgresql.sh
pwn-0.5.246	packer/provisioners/postgresql.sh
pwn-0.5.245	packer/provisioners/postgresql.sh
pwn-0.5.244	packer/provisioners/postgresql.sh
pwn-0.5.243	packer/provisioners/postgresql.sh
pwn-0.5.242	packer/provisioners/postgresql.sh
pwn-0.5.241	packer/provisioners/postgresql.sh
pwn-0.5.240	packer/provisioners/postgresql.sh
pwn-0.5.239	packer/provisioners/postgresql.sh
pwn-0.5.238	packer/provisioners/postgresql.sh
pwn-0.5.237	packer/provisioners/postgresql.sh
pwn-0.5.236	packer/provisioners/postgresql.sh
pwn-0.5.235	packer/provisioners/postgresql.sh
pwn-0.5.234	packer/provisioners/postgresql.sh
pwn-0.5.233	packer/provisioners/postgresql.sh