Someone's picture

Hello,

Thank you very much for your efforts and services regarding this software bundle. It is excellent.

How would one go about installing phpmyadmin for the Redmine package?  Please don't ask me why I'd like that, as the "why" is really just a silly question.

Please advise. Thank you very much.

Sincerely,

Forum: 
Someone's picture

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,

Bob Barge's picture

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!

Linux Hobbyist + Technology Professional = Geek

Alon Swartz's picture

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.

Bob Barge's picture

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

Linux Hobbyist + Technology Professional = Geek

sbscherer's picture

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?

Jeremy Davis's picture

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.

sbscherer's picture

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.

Jeremy Davis's picture

Glad you got it working.

Alon Swartz's picture

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.

Add new comment