Amazon Linux 2023 LAPP Stack with PHP 8.2 by Classmethod
This AMI is a LAPP Server installed on Amazon Linux 2023
This AMI supports following versions.
- PHP 8.2
- Apache 2.4
- PostgreSQL 15
Web Server
We prepared SSL/TLS so you can access to top page using http:// or https://.
DB Server
You can find the password from EC2 management console System Log.
- Go to Amazon EC2 console at https://console.aws.amazon.com/ec2/.
- Chose your Instance and Click Actions → Instance Settings → Get System log
Get System log
You can also SSH into your instance and find the login credential using the following command.
[ec2-user@ip-172-31-77-125 ~]$ cat credentials
////////////////////credentials info////////////////////
--- PostgreSQL
----- User : postgres
----- Password : aVpwwo9pdiK1lewp
////////////////////////////////////////////////////////Login PostgreSQL SHELL
$ sudo -i -u postgres psql -U postgres
psql (15.0)
Type "help" for help.
postgres=#
postgres=# SHOW data_directory;
data_directory
---------------------
/var/lib/pgsql/data
(1 row)or
$ psql -h localhost -U postgres
Password for user postgres:
psql (15.0)
Type "help" for help.
postgres=# SELECT version();
version
--------------------------------------------------------------------------------------------------------------
PostgreSQL 15.0 on x86_64-amazon-linux-gnu, compiled by gcc (GCC) 11.3.1 20221121 (Red Hat 11.3.1-4), 64-bit
(1 row)Option pgAdmin 4
You can access to PostgreSQL using pgAdmin 4 with ssh tunnel.
Dashboard
Click Add New Server
General
Type Your DB Server Name
SSH Tunnel
Click SSH Tunnel Tab
- Use SSH tunneling: On
- Tunnel host: your server ip address
- Tunnel port: 22
- Authentication: Identity file
- Identity file: *****.pem
Connection
Click Connection Tab
- Host name/address: localhost
- Port: 5432
- Maintenance database: postgres
- Username: postgres
- Password: *******
Click Save
Let’s use pgAdmin
