TurnKey Linux Virtual Appliance Library

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.

Stable version: 14.1 (changelog)

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 without paying a commercial Certificate Authority.

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

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

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.