MAAS: Difference between revisions

From Chorke Wiki
Jump to navigation Jump to search
Line 3: Line 3:


==PostgreSQL==
==PostgreSQL==
===Install===
----
<source lang="bash">
<source lang="bash">
sudo apt install postgresql postgresql-contrib
sudo apt install postgresql postgresql-contrib
Line 19: Line 21:
DDL
DDL
EOF
EOF
</source>
===Schema===
----
<source lang="bash">
MAAS_DBUSER='academia_maas'
MAAS_DBNAME='academia_maas'
MAAS_DBPASS='sadaqah!'
</source>
</source>


Line 29: Line 39:
<source lang="bash">
<source lang="bash">
sudo -i -u postgres bash << EOF
sudo -i -u postgres bash << EOF
createdb -O ${MAAS_DBUSER:-academia_maas} ${MAAS_DBNAME:-academia_maas}
createdb --owner ${MAAS_DBUSER:-academia_maas} ${MAAS_DBNAME:-academia_maas}
EOF
EOF
</source>
</source>

Revision as of 01:39, 17 March 2023

sudo snap install maas --channel=3.3/stable
sudo snap install maas

PostgreSQL

Install


sudo apt install postgresql postgresql-contrib
sudo systemctl enable postgresql
sudo systemctl status postgresql
sudo systemctl start  postgresql
sudo systemctl daemon-reload
sudo -i -u postgres bash << EOF
createuser ${USER}
createdb   ${USER}
cat << DDL | psql
ALTER USER ${USER} WITH SUPERUSER;
DDL
EOF

Schema


MAAS_DBUSER='academia_maas'
MAAS_DBNAME='academia_maas'
MAAS_DBPASS='sadaqah!'
sudo -i -u postgres psql << DDL
CREATE USER ${MAAS_DBUSER:-academia_maas} WITH ENCRYPTED PASSWORD '${MAAS_DBPASS:-sadaqah}'
DDL
sudo -i -u postgres bash << EOF
createdb --owner ${MAAS_DBUSER:-academia_maas} ${MAAS_DBNAME:-academia_maas}
EOF
cat << EOF | sudo tee -a /etc/postgresql/14/main/pg_hba.conf >/dev/null
host    ${MAAS_DBNAME:-academia_maas}     ${MAAS_DBUSER:-academia_maas}     0/0                     md5
EOF

Knowledge

install:
sudo snap install maas --channel=3.3
upgrade:
sudo snap refresh maas --channel=3.3
sudo snap install maas-test-db
sudo maas-test-db.psql

sudo maas init --help

References