Differences

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

--- os:linux:powerdns_apache_postgresql_debian [2021-02-07 16:08] – [Setup PowerDNS-Admin from GitHub] 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 332: / Line 333: @@
 procname-prefix-spaced = %n
 venv = /opt/python/%n/venv/
-buffer-size = 65535
+buffer-size = 8192
 ;disable-logging = true
 ;log-4xx = true
@@ 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 477: / Line 478: @@
     * PDNS API KEY: aF3kD4eJ0hB1uI1jV8vR2yC0eK8lP9mO
     * PDNS VERSION: 4.3.1
+==== Python Upgrade Notes  ====
+If you upgrade Python, for example while you upgrade Debian 10 to Debian 11, you have to update the virtual environment.
+If you forget this, you can't start the systemd unit an may see an error like this:
+<code>
+Oct 18 18:49:14 ns1.example.com uwsgi[731953]: /usr/local/bin/uwsgi: error while loading shared libraries: libpython3.7m.so.1.0: cannot open shared object file: No such file or directory
+</code>
+Upgrade your venv.
+<code>
+python3 -m venv --upgrade --upgrade-deps /opt/python/powerdns-admin/venv/
+</code>
+And start the Systemd unit again.
+<code>
+systemctl start uwsgi@powerdns-admin.service
+</code>
 ===== Appendix =====