You are here
LAPP
![](https://www.turnkeylinux.org/files/images/icons/lapp.jpg)
Web Stack (PostgreSQL)
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 and Perl.
Run from browser
V 18.0
V 17.1
GitHub
This appliance includes all the standard features in TurnKey Core, and on top of that:
- SSL support out of the box.
- PHP, Python and Perl support for Apache2 and PostgreSQL.
- Adminer administration frontend for PostgreSQL (listening on port 12322 - uses SSL).
- Webmin modules for configuring Apache2, PHP and PostgreSQL.
- PostgreSQL listening on localhost (security)
- PostgreSQL password encryption enabled by default (security).
- The postgres user is trusted when connecting over local unix sockets (convenience).
A separate appliance is available for the LAMP stack (featuring MySQL instead of PostgreSQL).
Usage details & Logging in for Administration
No default passwords: For security reasons there are no default passwords. All passwords are set at system initialization time.
Ignore SSL browser warning: browsers don't like self-signed SSL certificates, but this is the only kind that can be generated automatically. If you have a domain configured, then via Confconsole Advanced menu, you can generate free Let's Encypt SSL/TLS certificates.
Web - point your browser at either:
- http://12.34.56.789/ - not encrypted so no browser warning
- https://12.34.56.789/ - encrypted with self-signed SSL certificate
Note: some appliances auto direct http to https.
Web - point your browser at either:
- http://12.34.56.789/ - not encrypted so no browser warning
- https://12.34.56.789/ - encrypted with self-signed SSL certificate
Note: some appliances auto direct http to https.
Username for database administration:
Login as PostgreSQL username postgres at
- https://12.34.56.789:12322/ - Adminer database management web app
- PostgreSQL command line tool:
$ psql -U postgres -h localhost Password for user postgres: Type "help" for help. postgres=#
Username for OS system administration:
Login as root except on AWS marketplace which uses username admin.
- Point your browser to:
- https://12.34.56.789:12321/ - System control panel
- https://12.34.56.789:12320/ - Web based command line terminal
- Login with SSH client:
ssh root@12.34.56.789
Special case for AWS marketplace:
ssh admin@12.34.56.789
* Replace 12.34.56.789 with a valid IP or hostname.