os:linux:powerdns_apache_postgresql_debian
Differences
This shows you the differences between two versions of the page.
Both sides previous revisionPrevious revisionNext revision | Previous revision | ||
os:linux:powerdns_apache_postgresql_debian [2021-10-28 13:27] – [Python Upgrade Notes] 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: | ||
</ | </ | ||
- | 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> | <code sql> | ||
CREATE USER u_powerdns WITH PASSWORD ' | CREATE USER u_powerdns WITH PASSWORD ' | ||
Line 84: | Line 84: | ||
</ | </ | ||
- | Replace the database password with the one you generated before. [[https://strongpasswordgenerator.com/ | + | Replace the database password with the one you generated before. [[https://pwgen.ch/ |
<code ini pdns.conf> | <code ini pdns.conf> | ||
# https:// | # https:// | ||
Line 157: | Line 157: | ||
< | < | ||
- | curl -sL https:// | + | curl -fsSL https:// |
apt install -y nodejs | apt install -y nodejs | ||
</ | </ | ||
Line 187: | Line 187: | ||
This requirements are expected by this python libraries: | This requirements are expected by this python libraries: | ||
* python-ldap: | * python-ldap: | ||
- | * mysqlclient: libmariadbclient-dev: | + | * SQLAlchemy: |
Create the config file / | Create the config file / | ||
Line 231: | Line 232: | ||
### DATABASE CONFIG | ### DATABASE CONFIG | ||
- | SQLA_DB_DRIVER = "postgres" # mysql, | + | SQLA_DB_DRIVER = "postgresql" # mysql, |
SQLA_DB_USER = " | SQLA_DB_USER = " | ||
SQLA_DB_PASSWORD = '' | SQLA_DB_PASSWORD = '' | ||
Line 441: | Line 442: | ||
ProxyPass "/ | ProxyPass "/ | ||
ProxyPass "/ | ProxyPass "/ | ||
- | ProxyPass "/" | + | ProxyPass "/" |
ErrorLog ${APACHE_LOG_DIR}/ | ErrorLog ${APACHE_LOG_DIR}/ |
os/linux/powerdns_apache_postgresql_debian.1635420475.txt.gz · Last modified: 2021-10-28 13:27 by Manuel Frei