GCP Marketplace

  2. Home
  4. Docs
  6. GCP Marketplace
  8. GCP LEPP 8.0 on Ubuntu 20.04

GCP LEPP 8.0 on Ubuntu 20.04

This AMI is a LEPP Web Server with phpMyAdmin installed on Ubuntu 20.04. Package include Linux, Apache2, MySQL, and phpMyAdmin.

This AMI supports following versions.

  • PHP 8.0
  • Nginx 1.22
  • PostgreSQL 14

Web Server

We prepared SSL/TLS so you can access to top page using http:// or https://.

Web Server

We prepared SSL/TLS so you can access to top page using http:// or https://.

DB Server Password

We recommend using minimum machine type e2-standard-8 for this LAMP server. For more machine types please refer to GCP General purpose machines documentation.

Please follow these steps to rest the MySQL root password.

Troubleshooting MySQL Root Password

If the root user’s password isn’t showing up in the console, you can reset it by following these steps:

Step 1: Switch to Root User

Open your terminal and execute the following command to become the root user:

$ sudo su -

Step 2: View debian-sys-maint User and Password

Execute this command to display the Debian System Maintenance (debian-sys-maint) user and its password:

# cat /etc/mysql/debian.cnf
# Automatically generated for Debian scripts. DO NOT TOUCH!
[client]
host     = localhost
user     = debian-sys-maint
password = **************
socket   = /var/run/mysqld/mysqld.sock
[mysql_upgrade]
host     = localhost
user     = debian-sys-maint
password = **************
socket   = /var/run/mysqld/mysqld.sock

Note down the debian-sys-maint user’s password for use in the next step.

Step 3: Connect to the Local MySQL Server

Use the debian-sys-maint credentials to connect to your MySQL server:

# mysql -u debian-sys-maint -p
Enter password:
Welcome to the MySQL monitor.  Commands end with ; or \g.
Your MySQL connection id is 12
Server version: 8.0.32-0ubuntu0.22.04.2 (Ubuntu)
Copyright (c) 2000, 2023, Oracle and/or its affiliates.
Oracle is a registered trademark of Oracle Corporation and/or its
affiliates. Other names may be trademarks of their respective
owners.
Type 'help;' or '\h' for help. Type '\c' to clear the current input statement.
mysql>

Note down the debian-sys-maint user’s password for use in the next step.

Step 4: Reset Root User Password

Inside the MySQL interface, execute the following command to reset the root user password. Replace 'yourpassword' with your desired password.

mysql> ALTER USER 'root'@'localhost' IDENTIFIED BY 'yourpassword';
mysql> exit

Step 5: Verify Root User Login

Finally, validate that you can log in with the new root user password:

# mysql -u root -p
Enter password:
Welcome to the MySQL monitor.  Commands end with ; or \g.
Your MySQL connection id is 14
Server version: 8.0.32-0ubuntu0.22.04.2 (Ubuntu)
Copyright (c) 2000, 2023, Oracle and/or its affiliates.
Oracle is a registered trademark of Oracle Corporation and/or its
affiliates. Other names may be trademarks of their respective
owners.
Type 'help;' or '\h' for help. Type '\c' to clear the current input statement.
mysql>

External IP address

Note the external IP from VM instance console

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 (14.3)
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 (14.3)
Type "help" for help.

postgres=# SELECT version();
                                                  version                                                  
-----------------------------------------------------------------------------------------------------------
 PostgreSQL 14.3 on x86_64-koji-linux-gnu, compiled by gcc (GCC) 7.3.1 20180712 (Red Hat 7.3.1-15), 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

Reference

Tags ,

How can we help?