Configure ezeelogin on aws RDS

Configure ezeelogin on AWS - RDS  Remote Database

 

1. Setting up the RDS environment

     Login to AWS account > Open the RDS  and proceed to create the RDS MySQL Environment. On the next page that appears, click on Create Database. This will open another page where you can define the necessary details required to set up the MySQL Database.


 

 

2. Creating the MySQL database

 a. Click on the Create Database, a new page opens as follows, where you can define the database creation method and other options. Select Standard Create as the database creation method. Select the Engine Type as MySQL/mariadb and the version (check the software requirements on the article which ezeelogin supports) 

 

 

 

 Select the Engine Type as MySQL/mariadb and the version . Here i have selected MariaDB 10.2, you can select the Ezeelogin supported engine type & version.

 Ezeelogin will support only on MySQL version 5.6,5.7 and MariaDB 10.2 on RDS. Other MySQL , MariaDB version on RDS will not support Ezeelogin.

 

   

 

 

 b. In the next step, Provide a suitable name for the database instance, for example, I’m going to use the database instance as “ezeelogin_db”. Similarly, provide a suitable master username and password for the same. This is the username and the password, that you will be using later to connect to this MySQL instance later. Also, you must keep these credentials safe so that it can be used later again.

 

 

 c. Now,we need to set some other properties which are essential to set up the RDS MySQL Environment. Select the Database Instance Size as “db.t2.micro” and Storage Type as General Purpose SSD. By default, the memory size is allocated to 20GB which is fine for the moment. 

 

 

 

  D. You should  allow connections from the public network to allow and connect to the instance.

 

 

 

  e. we should define the Connectivity settings for the RDS Database instance. Select the default VPC connection that is already available within your login. Since we will be accessing the database instance from outside the AWS Environment, we should enable the Publicly Accessible to Yes. The final step in creating the database is to select the Database Authentication Mode as Password Authentication. Once completed, click on Create Database.

     Once you click on Create Database in the previous step, it might take a while for AWS to create the RDS instance and make it available for use. After a few moments, you will receive a notification that says the database has been created successfully. Click on the DB Identifier for the MySQL Database. A new page will open containing more information about the MySQL database instance. The important thing to note here is the Endpoint which is available. This endpoint information will be used later to connect to the ezeelogin.

 

 

 

3. You can now use the RDS MySQL instance to install ezeelogin

 

Follow jumpserver install article and start Ezeelogin installation 

Follow the prompts and you should give the aws RDS connection connection details on prompt as follows.

 

Using remote database server for Ezeelogin database

Enter the hostname/ip address of the remote database server or use localhost, if you are going to run the database server on the current server. 

  Enter the endpoint that we copied in the previous steps as the hostname and the master username as the username here.

hostname or IP address of MySQL server.

If the MySQL server is running on this system itself, use ’localhost’

 

MySQL server ( localhost ): ezeelogin_db.123456789012.us-east-1.rds.amazonaws.com

     

port or path to unix socket used by the MySQL server.

 

MySQL port/socket ( 3306 ): 3306

 

Enter the username with super user (root) privileges for the database server.

This is usually ’root’, sometimes ’admin’ etc.

MySQL super user ( root ): admin

 

Please enter the password for the database super user.

MySQL super user password: *******

 You can continue with the prompt and complete ezeelogin ezeelogin installation.

Review settings:

Install web panel files in                                  : /var/www/html/ezlogin/

Install web panel system files in                           : /var/www/ezlogin/

URI path to access web panel                                : /ezlogin/

MySQL server                                                : localhost

MySQL port/socket                                           : 3306

MySQL database                                              : ezlogin_jzgzs

MySQL user                                                  : ezlogin_xnyqwd

MySQL password                                              : !T3}3w$czV$6VrWxG)kn{5&3t5

Force HTTPS for web panel?                                  : no

Secure MySQL connection?                                    : no

Admin user                                                  : admin

Admin password                                              : admin

Admin security code                                         : admin

Note these down for future reference. Certain values such as passwords cannot be retrieved after setup.

Accept the above settings? ( /n/x) :

 

 

 

Creating and setting up database... done

Adding ezsh to shells... done

Creating group and users... done

Creating directories... done

Copying files... done

Setting access... done

Setting file modes... done

Setting file owners... done

Setting file groups... done

Setting up config... done

Setting up cron... done

Downloading GeoLiteCity database from www.maxmind.com... done

########################################################

Ezeelogin installed. (Log: /var/log/ezlogin_install.log )

########################################################

###################################################################

 Web panel installed at:

  ’ /var/www/html/ezlogin/ 

  http://yourdomain.com/ezlogin/ ).

###################################################################

Note: Please check the log file to see if any error occurred.

 

TODO NOTES:

Enable web server, MySQL server and cron to startup at boot time.

 

For free assistance, please contact support@ezeelogin.com

 

Thank you for choosing Ezeelogin.

www.ezeelogin.com

 

 After Installation login to AWS RDS database and grant connectivity to Ezeelogin server  hostname/IP on the remote database server.

You can find out the ezeelogin database name, database password from the " Review settings " on installation screen. you can also refer the article to retrieve Ezeelogin database credentials

root@jumpserver:~# mysql -h  ezeelogin_db.123456789012.us-east-1.rds.amazonaws.com  -P 3306 -u mymasteruser -p

mysql> GRANT ALL PRIVILEGES ON ezeelogin_db.* TO ’admin’@’%’ IDENITIFIED BY ’PASSWORD’ WITH GRANT OPTION;

mysql> flush privileges;

 

 

 

 

5 (1)
Article Rating (1 Votes)
Rate this article
    Attached Files
    There are no attachments for this article.
    Related Articles RSS Feed
    The IP field must contain a valid public IP or how to install Ezeelogin on a machine in lan
    Viewed 4355 times since Wed, Jun 14, 2017
    How to secure SSH jump server / SSH bastion host / SSH gateway
    Viewed 7145 times since Thu, Jun 15, 2017
    How to renew/update standalone license ?
    Viewed 1337 times since Thu, Feb 27, 2020
    Installing Jump server or Bastion host on a linux host in Google or AWS instance ?
    Viewed 20817 times since Thu, Sep 21, 2017
    What operating systems and platforms are supported to install jump server?
    Viewed 4438 times since Wed, Jun 14, 2017
    How to install Ezeelogin with a standalone license ?
    Viewed 687 times since Tue, Mar 10, 2020
    Install ezeelogin without internet access on Centos 7
    Viewed 103 times since Wed, Dec 30, 2020
    Enable SSH Key based authentication and Disable Password Authentication in ssh
    Viewed 924 times since Tue, Apr 21, 2020
    Install slave / secondary node for high availability in jump server
    Viewed 5126 times since Wed, Jun 14, 2017