LAPP

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.

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:

  1. http://12.34.56.789/ - not encrypted so no browser warning
  2. 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:

  1. http://12.34.56.789/ - not encrypted so no browser warning
  2. 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

  1. https://12.34.56.789:12322/ - Adminer database management web app
  2. 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.

  1. Point your browser to:
  2. 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.