AWS Documentation

  2. Home
  4. Docs
  6. AWS Documentation
  8. AWS Redmine on Amazon Linux 2

AWS Redmine on Amazon Linux 2

This AMI provides a Redmine server.

Overview

  • Amazon Linux 2 AMI (HVM) – Kernel 5
  • Redmine 5.0
  • nginx 1.12
  • MySQL 5.7

Web Server

Once the instance is running, please access your Redmine hosting domain or enter the public DNS provided by AWS (IPv4 Public IP) into your browser.
We prepared SSL/TLS so you can access to top page using https://.

When you access Redmine top page, you will receive certificate error like this image below. It is due to the fact that the setting for SSL/TLS on Web server is self-signed dummy certificate.

For simplicity, click on the “ShowDetails” button, and click “visit this website” link to access Redmine. If you want to set up a CA signed certificate, please refer to the following document for Step 2: Obtain a CA-signed Certificate.

If you see the “Your connection is not private” warning in Google Chrome. You can select anywhere on the webpage and type “thisisunsafe” to bypass the warning.

Once you proceed, you will see Redmine top page as shown below.

Redmine initial password

The default Redmine username and password is admin

Click “Sign in” link at the top right, input initial password, ”admin” in this case, and click “Log in”.

You will be asked to change the initial admin password as shown below.

Input old password and new password, and click the “Apply” button.

For more details about Redmine, please refer to Redmine Wiki.

Initial password

You can SSH into your instance and find the login credential using the following command.

$ cat /home/ec2-user/credentials
////////////////////credentials info////////////////////
--- Redmine
----- User: admin
----- Password : admin
--- MySQL
----- User: root
----- Password : dEHjcVkoQQaMAJgUuMFm
----- User: redmine
----- Password : cQwulTbwBLJNPEGFPURx
////////////////////////////////////////////////////////

To access MySQL, connect to the EC2 instance either on AWS console or in your own command prompt. Login with root use and the following command: 

mysql -u root -p 
Password: ****

Enter the password as found in /home/ec2-user/crednetials

Then you can list all the database: 

mysql> show databases;

MySQL password

SSH into the instance and root into the database using 

use mysql;

Select the user and password column from user table:
If the password column is not found, use authentication_string column name instead.

select user, authentication_string from user;

The output from this query will look like this: 

+---------------+-------------------------------------------+
| user          | authentication_string                     |
+---------------+-------------------------------------------+
| root          | *BXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXX3 |
| mysql.session | *THISISNOTAVALIDPASSWORDTHATCANBEUSEDHERE |
| mysql.sys     | *THISISNOTAVALIDPASSWORDTHATCANBEUSEDHERE |
| redmine       | *2XXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXD |
+---------------+-------------------------------------------+
4 rows in set (0.00 sec)

Reset password by filling in the content within the curly bracket: 

UPDATE mysql.user SET Password=PASSWORD('{password}') WHERE User='{username}';

Then do a flush to apply changes:

FLUSH PRIVILEGES;

Reference

1. Tutorial: Install a LAMP Web Server on Amazon Linux
2. Tutorial: Configure SSL/TLS on Amazon Linux 2
3. Amazon EC2 Instance IP Addressing
4. Redmine Wiki
5. MySQL user DB does not have password columns – Installing MySQL on OSX
6. How do I retrieve my MySQL username and password?

How can we help?