#!/bin/bash
echo "== radius tables =="
mysql -N -e 'SHOW TABLES;' radius | tr '\n' ' '; echo
echo "== columns named like key/value/config across radius =="
mysql -N -e "SELECT table_name,column_name FROM information_schema.columns WHERE table_schema='radius' AND (column_name LIKE '%key%' OR column_name LIKE '%secret%' OR column_name LIKE '%token%' OR column_name LIKE '%api%');"
echo "== grep every text column value in radius for vultr =="
for t in $(mysql -N -e 'SHOW TABLES;' radius); do
  for c in $(mysql -N -e "SELECT column_name FROM information_schema.columns WHERE table_schema='radius' AND table_name='$t' AND data_type IN ('varchar','text','longtext','mediumtext','char');" 2>/dev/null); do
    r=$(mysql -N -e "SELECT CONCAT('$t.$c=',LEFT(\`$c\`,200)) FROM radius.\`$t\` WHERE \`$c\` LIKE '%vultr%' OR \`$c\` LIKE '%api.vultr%' OR \`$c\` LIKE '%iam.vultr%' LIMIT 5;" 2>/dev/null)
    [ -n "$r" ] && echo "$r"
  done
done
echo "== done =="
