LAPP Stack for PI: Difference between revisions
Jump to navigation
Jump to search
m (Protected "LAPP Stack for PI" ([Edit=Allow only administrators] (indefinite) [Move=Allow only administrators] (indefinite))) |
|
(No difference)
| |
Revision as of 12:49, 18 December 2020
The LAPP stack is an open source web platform that can be used to run dynamic web sites and servers. It is considered by many to be a powerful alternative to the more popular LAMP stack and includes Linux, Apache, PostgreSQL (instead of MySQL) and PHP, Python or Perl.
Install
Apache
sudo su
apt install apache2/stable
CKI_A2_SERVER_NAME_FIND='#ServerName www.example.com';\
CKI_A2_SERVER_NAME_FILL='ServerName web.bgd.chorke.org';\
CKI_A2_SERVER_ADMN_FIND='ServerAdmin webmaster@localhost';\
CKI_A2_SERVER_ADMN_FILL='ServerAdmin [email protected]';\
CKI_A2_DFAULT_SITE_CONF='/etc/apache2/sites-enabled/000-default.conf';\
sed -i "s|$CKI_A2_SERVER_NAME_FIND|$CKI_A2_SERVER_NAME_FILL|" "$CKI_A2_DFAULT_SITE_CONF";\
sed -i "s|$CKI_A2_SERVER_ADMN_FIND|$CKI_A2_SERVER_ADMN_FILL|" "$CKI_A2_DFAULT_SITE_CONF";\
systemctl reload apache2;\
apachectl -t
PHP
apt install php7.3-fpm/stable libapache2-mod-php7.3/stable
a2enmod proxy_fcgi setenvif
a2enconf php7.3-fpm
a2enmod php7.3
systemctl restart apache2
Postgres
apt install postgresql-11/stable
apt install phppgadmin/stable
sed -i "s/NOT pp.proisagg/pp.prokind='f'/g" /usr/share/phppgadmin/classes/database/Postgres.php
sed -i "s/NOT p.proisagg/p.prokind='f'/g" /usr/share/phppgadmin/classes/database/Postgres.php
systemctl restart apache2
CREATE DATABASE chorke_boot_dev;
CREATE USER chorke_boot_dev WITH ENCRYPTED PASSWORD 'chorke_boot_dev';
GRANT ALL PRIVILEGES ON DATABASE chorke_boot_dev TO chorke_boot_dev;
Remote
nano /etc/apache2/conf-enabled/phppgadmin.conf
AllowOverride All
Require all granted
#Require local
nano /etc/postgresql/11/main/postgresql.conf
listen_addresses = '*' # what IP address(es) to listen on;
# comma-separated list of addresses;
# defaults to 'localhost'; use '*' for all
# (change requires restart)
nano /etc/postgresql/11/main/pg_hba.conf
# IPv4 local connections:
host all all 127.0.0.1/32 md5
host all all 10.19.83.1/24 md5
systemctl restart postgresql
update-rc.d postgresql disable
apt install nmap/stable
nmap -p 5432 localhost
nmap -p 5432 10.19.83.5