Differences

This shows you the differences between two versions of the page.

--- os:linux:powerdns_apache_postgresql_debian [2021-10-18 19:03] – venv upgrade Manuel Frei
+++ os:linux:powerdns_apache_postgresql_debian [2024-02-05 20:54] (current) – postgres is no longer a valid option, use postgresql instead Manuel Frei
@@ Line 46: / Line 46: @@
 </code>
-Create the user u_powerdns and the database db_powerdns. Change the example password with your own generated one (eg. [[https://strongpasswordgenerator.com/]]).
+Create the user u_powerdns and the database db_powerdns. Change the example password with your own generated one (eg. [[https://pwgen.ch/]]).
 <code sql>
 CREATE USER u_powerdns WITH PASSWORD 'iC0iB9kQ5hR4oG5uW2nD2nV0gK6vN2eSoM2eI8kT0gA9rF2pS3wW7mO4sJ4aT5tN';
@@ Line 84: / Line 84: @@
 </code>
-Replace the database password with the one you generated before. [[https://strongpasswordgenerator.com/|Generate]] your own API key (used for PowerDNS-Admin). Change the other settings according to your needs.
+Replace the database password with the one you generated before. [[https://pwgen.ch/|Generate]] your own API key (used for PowerDNS-Admin). Change the other settings according to your needs.
 <code ini pdns.conf>
 # https://doc.powerdns.com/authoritative/settings.html
@@ Line 157: / Line 157: @@
 <code>
-curl -sL https://deb.nodesource.com/setup_14.x | bash -
+curl -fsSL https://deb.nodesource.com/setup_20.x | bash - &&\
 apt install -y nodejs
 </code>
@@ Line 187: / Line 187: @@
 This requirements are expected by this python libraries:
   * python-ldap: build-essential python3-dev libldap2-dev libsasl2-dev slapd ldap-utils tox lcov valgrind
-  * mysqlclient: libmariadbclient-dev:
+  * SQLAlchemy: mysqlclient, libmariadbclient-dev
 Create the config file  /opt/python/powerdns-admin/app/configs/config.py.
@@ Line 231: / Line 232: @@
 ### DATABASE CONFIG
-SQLA_DB_DRIVER = "postgres" # mysql, postgres
+SQLA_DB_DRIVER = "postgresql" # mysql, postgresql
 SQLA_DB_USER = "u_powerdnsadmin"
 SQLA_DB_PASSWORD = ''
@@ Line 441: / Line 442: @@
     ProxyPass "/favicon.ico" "!"
     ProxyPass "/.well-known/" "!"
-    ProxyPass "/" "unix:/run/uwsgi_powerdns-admin/service.sock|uwsgi://localhost/powerdns-admin/"
+    ProxyPass "/" "unix:/run/uwsgi_powerdns-admin/service.sock|uwsgi://powerdns-admin/"
     ErrorLog ${APACHE_LOG_DIR}/pdnsadmin.example.com-error.log
@@ Line 489: / Line 490: @@
 Upgrade your venv.
 <code>
-python3 -m venv --upgrade --upgrade-deps /opt/python/powerdns-admin/
+python3 -m venv --upgrade --upgrade-deps /opt/python/powerdns-admin/venv/
 </code>