Instalar PowerDNS server y PowerDNS Admin

#	Sigo este tutorial
#		https://www.howtoforge.com/how-to-install-powerdns-admin-on-ubuntu-20-04/

apt-get install software-properties-common gnupg2 -y
apt-key adv --fetch-keys 'https://mariadb.org/mariadb_release_signing_key.asc'
add-apt-repository 'deb [arch=amd64,arm64,ppc64el] http://mirrors.ukfast.co.uk/sites/mariadb/repo/10.5/ubuntu focal main'
apt-get install mariadb-server -y
mysql
create database pdns;
grant all on pdns.* to pdnsadmin@localhost identified by 'ponetuclave';
flush privileges;
exit;
systemctl disable --now systemd-resolved
rm -rf /etc/resolv.conf
echo "nameserver 8.8.8.8" > /etc/resolv.conf
apt-get install pdns-server pdns-backend-mysql -y
mysql -u pdnsadmin -p pdns < /usr/share/pdns-backend-mysql/schema/schema.mysql.sql
EnLaput4v1daVasaSufrinTantOCOMOlaMam4.
nano /etc/powerdns/pdns.d/pdns.local.gmysql.conf

# MySQL Configuration
#
# Launch gmysql backend
launch+=gmysql

# gmysql parameters
gmysql-host=127.0.0.1
gmysql-port=3306
gmysql-dbname=pdns
gmysql-user=pdnsadmin
gmysql-password=ponetuclave
gmysql-dnssec=yes
# gmysql-socket=

chmod 640 /etc/powerdns/pdns.d/pdns.local.gmysql.conf
systemctl stop pdns
pdns_server --daemon=no --guardian=no --loglevel=9
systemctl start pdns
ss -alnp4 | grep pdns
apt-get install nginx python3-dev libsasl2-dev libldap2-dev libssl-dev libxml2-dev libxslt1-dev libxmlsec1-dev libffi-dev pkg-config apt-transport-https virtualenv build-essential libmariadb-dev git python3-flask -y
curl -sL https://deb.nodesource.com/setup_14.x | bash -
apt-get install nodejs -y

curl -sS https://dl.yarnpkg.com/debian/pubkey.gpg | apt-key add -
echo "deb https://dl.yarnpkg.com/debian/ stable main" | tee /etc/apt/sources.list.d/yarn.list
apt-get update -y
apt-get install yarn -y
git clone https://github.com/ngoduykhanh/PowerDNS-Admin.git /var/www/html/pdns
cd /var/www/html/pdns/
virtualenv -p python3 flask
source ./flask/bin/activate
pip install -r requirements.txt
deactivate
nano /var/www/html/pdns/powerdnsadmin/default_config.py
SALT = 'yoursecretekey'
SECRET_KEY = 'yoursecretekey'
BIND_ADDRESS = '0.0.0.0'
PORT = 9191
HSTS_ENABLED = False
OFFLINE_MODE = False

SQLA_DB_USER = 'pdnsadmin'
SQLA_DB_PASSWORD = 'ponetuclave'
SQLA_DB_HOST = '127.0.0.1'
SQLA_DB_NAME = 'pdns'
SQLALCHEMY_TRACK_MODIFICATIONS = True

cd /var/www/html/pdns/
source ./flask/bin/activate
export FLASK_APP=powerdnsadmin/__init__.py
flask db upgrade
yarn install --pure-lockfile
flask assets build
deactivate

vi /etc/powerdns/pdns.conf
api=yes
api-key=tukey

systemctl restart pdns
nano /etc/nginx/conf.d/pdns-admin.conf

server {
  listen	*:80;
  server_name               ipequipoodominio;

  index                     index.html index.htm index.php;
  root                      /var/www/html/pdns;
  access_log                /var/log/nginx/pdnsadmin_access.log combined;
  error_log                 /var/log/nginx/pdnsadmin_error.log;

  client_max_body_size              10m;
  client_body_buffer_size           128k;
  proxy_redirect                    off;
  proxy_connect_timeout             90;
  proxy_send_timeout                90;
  proxy_read_timeout                90;
  proxy_buffers                     32 4k;
  proxy_buffer_size                 8k;
  proxy_set_header                  Host $host;
  proxy_set_header                  X-Real-IP $remote_addr;
  proxy_set_header                  X-Forwarded-For $proxy_add_x_forwarded_for;
  proxy_headers_hash_bucket_size    64;

  location ~ ^/static/  {
    include  /etc/nginx/mime.types;
    root /var/www/html/pdns/powerdnsadmin;

    location ~*  \.(jpg|jpeg|png|gif)$ {
      expires 365d;
    }

    location ~* ^.+.(css|js)$ {
      expires 7d;
    }
  }

  location / {
    proxy_pass            http://unix:/run/pdnsadmin/socket;
    proxy_read_timeout    120;
    proxy_connect_timeout 120;
    proxy_redirect        off;
  }

}

nginx -t
chown -R www-data:www-data /var/www/html/pdns
systemctl restart nginx
nano /etc/systemd/system/pdnsadmin.service

[Unit]
Description=PowerDNS-Admin
Requires=pdnsadmin.socket
After=network.target

[Service]
PIDFile=/run/pdnsadmin/pid
User=pdns
Group=pdns
WorkingDirectory=/var/www/html/pdns
ExecStart=/var/www/html/pdns/flask/bin/gunicorn --pid /run/pdnsadmin/pid --bind unix:/run/pdnsadmin/socket 'powerdnsadmin:create_app()'
ExecReload=/bin/kill -s HUP $MAINPID
ExecStop=/bin/kill -s TERM $MAINPID
PrivateTmp=true

[Install]
WantedBy=multi-user.target

nano /etc/systemd/system/pdnsadmin.socket

[Unit]
Description=PowerDNS-Admin socket

[Socket]
ListenStream=/run/pdnsadmin/socket

[Install]
WantedBy=sockets.target

echo "d /run/pdnsadmin 0755 pdns pdns -" >> /etc/tmpfiles.d/pdnsadmin.conf
mkdir /run/pdnsadmin/
chown -R pdns: /run/pdnsadmin/
chown -R pdns: /var/www/html/pdns/powerdnsadmin/
systemctl daemon-reload
systemctl enable --now pdnsadmin.service pdnsadmin.socket
systemctl status pdnsadmin.service pdnsadmin.socket

Instalar Moodle en Ubuntu 2004

# Me guió en base a esto de acá abajo

https://docs.moodle.org/39/en/Step-by-step_Installation_Guide_for_Ubuntu

sudo apt install apache2 mysql-client mysql-server php libapache2-mod-php git graphviz aspell ghostscript clamav php7.4-pspell php7.4-curl php7.4-gd php7.4-intl php7.4-mysql php7.4-xml php7.4-xmlrpc php7.4-ldap php7.4-zip php7.4-soap php7.4-mbstring
sudo service apache2 restart
cd /opt
sudo git clone git://git.moodle.org/moodle.git
cd moodle
sudo git branch -a
sudo git branch –track MOODLE_39_STABLE origin/MOODLE_39_STABLE
sudo git checkout MOODLE_39_STABLE
sudo cp -R /opt/moodle /var/www/html/
sudo mkdir /var/moodledata
sudo chown -R www-data /var/moodledata
sudo chmod -R 777 /var/moodledata
sudo chmod -R 0755 /var/www/html/moodle
sudo vi /etc/mysql/mysql.conf.d/mysqld.cnf
default_storage_engine = innodb
innodb_file_per_table = 1

sudo service mysql restart
sudo mysql -u root -p
CREATE DATABASE moodle DEFAULT CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci;
create user ‘moodledude’@’localhost’ IDENTIFIED BY ‘passwordformoodledude’;
GRANT SELECT,INSERT,UPDATE,DELETE,CREATE,CREATE TEMPORARY TABLES,DROP,INDEX,ALTER ON moodle.* TO ‘moodledude’@’localhost’;
quit;
sudo chmod -R 777 /var/www/html/moodle

sudo crontab -u www-data -e
*/1 * * * * /var/www/html/moodle/admin/cli/cron.php > /dev/null

Un dato muy importante, el que me jodió la vida al menos una semana entera de tantos intentos fallidos. En la parte de la instalación gráfica hay una tercer pantalla que tarda muchísimo en cargarse, es en donde te muestra lo que va instalándose. Concejo consiganse algo copado para tomar y esperar. Yo tuve muchos problemas por que anteriormente cuando había instalado versiones anteriores de moodle eso cargaba a los ponchazos, era bien rápido. Pero en estas ultimas versiones es muy lerdo y tarda muchísimo en correr todo lo que corre. Al punto tal que tuve el mismo problema en muchas situaciones diferentes. Hasta que de puro tuje logre descubrir que tardaba y nada, había que esperar. No intenten mandar f5 ni nada por que se rompe la instalación. Es esperar a que cargue y dejarlo ahí hasta que llegue al final.