How to install phpmyadmin on Redmine VM?

I have installed the Redmine VM.  Using this VM I was able to save MANY hours to setup a Ruby on Rails application, configure a server, install VC software etc. which is why I chose the Redmine package.  However, I only would like to have (1) one VM, so I decided to do the following:

http://code.podzone.org (https://code.podzone.org ) goes to redmine application, and http://webdev.podzone.org (https://webdev.podzone.org)... basically anything NOT the redmine application is a PHP vhost. Yes, I've installed PHP on the redmine bundle.  I am only interested in PHP, MySQL, Version Control, and Phpmyadmin.  So far I've got everything except the phpmyadmin part done.

There isn't really a problem per se, as I can always manually install phpmyadmin and create a new alias for it, however, is there any "Turnkey" specific way of doing this?

I'll wait for a response before I proceed.  So far I'm manually managing SQL in mysql cli.  Thank you very much.

Sincerely,

Very nice!  I had not noticed the security group was a link on the server-dashboard. It is great to have more control in one tool.  If you are concerned about security, you can easily remove the rule and only add it back in when you need the access. Thanks

Thanks for posting detailed info, I'm sure this will help others.

Just a quick note regarding point 15 (modifying the security group). You can do this via the Hub, just click the security group in the server-dashboard, and add the rule you want. See the cloud tour, point 3 for details.

I couldn't live without phpMyAdmin so I tested this procedure first on VirtualBox and then on my Amazon EC2 Turnkey Linux Redmine instance.

1. As always, start any new installation or alteration with a backup
2. I use backup/restore through Turnkey Hub => https://hub.turnkeylinux.org/
3. Establish a root SSH session using Putty (or your own SSH client)
4. Enter =>  apt-get install phpmyadmin
5. The package installer creates a symbolic link in /etc/apache2/conf.d/phpmyadmin.conf that points to ../../phpmyadmin/apache.conf
6. Now configure a virtualhost and port for phpMyAdmin
7. Add an Apache virtual host "phpmyadmin" under /etc/apache2/sites-available/
8. Use Webmin to create the virtual host or vi a file named "phpmyadmin"
9. Refer to the Apache documentation for details
10. Change /etc/apache2/ports.conf, adding entries for port 12322
11. Add symbolic link to phpMyAdmin in /etc/apache2/sites-enabled
12. => ln -s ../sites-available/phpmyadmin
13. => lrwxrwxrwx 1 root root 29 Apr 10 15:51 phpmyadmin -> ../sites-available/phpmyadmin
14. Restart apache => /etc/init.d/apache2 restart
15. Enable port security in Amazon AWS Console => http://aws.amazon.com/ec2/
16. Select EC2 => Navigation panel => Networking & Security section => Security Groups
17. Select the "turnkey-redmine-a9a4" EC2 Security Group
18. Select the "Inbound" tab in the lower "Security Group" panel
19. Leave "Custom TCP rule" selected in the "Create a new rule" selection box
20. Enter 12322 in the "Port range:" box
21. Select the "+ Add Rule" button
22. Click "Apply Rule Changes"

Access phpMyAdmin at https://[your site or IP]:12322/phpmyadmin

It was actually easier than I thought!

Glad you got it working.

As @Jeremy mentioned, MySQL is bound to localhost on all appliances except when needed to be remotely accessible (ie. TKL MySQL). For future reference, see /docs/database-remote-access.

Thanks Jeremy.  I compared the configurations and found I had to change the Redmine appliance to listen on the IP address (rather than localhost) and also create a user account with proper permissions.  I got it up and running.

And there aren't any firewalls or other network issues blocking your way, then it's probably just MySQL config. The MySQL appliance it is preconfigured to listen on port 3306 for incoming requests from all hosts (see the appliance page here). I'm not sure but I'd assume that in the Redmine appliance it's probably bound to localhost. IIRC the MySQL config file can be found /etc/mysql/mysql.cnf

It sounds like you have the MySQL appliance running already so it may be worth consulting the MySQL conf file on that for details.

I am trying to make a connection to MySQL running on the Redmine VM, but I can't seem to get to it using Excel or the MySQL Workbench.  Unfortunately webmin won't cut it.   

I am using the root account and root password.  I am also using port 3306.  I did the same from the MySQL appliance and everything worked properly.  Anyone have any ideas?