TurnKey Linux Virtual Appliance Library

How to install phpmyadmin on Redmine VM?

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,

Current Redmine Modifications.

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,

"We have a point to work to, to make our nation huge, make our home stretch around the world, increase our army too. We must take over the world, make it our own. The Earth we must control, so you can&amp

How to install phpmyadmin in redmin

hi every one, i have the same probleme, i cant access phpmyadmin from port number 12322 ...

there is any ideas please ?

Jeremy's picture

You will need to create a virtual host in Apache2

It's not a strong point of mine but if you have a look at the vhosts that Basil created in the LAMP patch he made for Lucid you should get some ideas. If you work it out please post back. If you get stuck let me know and if I have time I'll have a look for you.

phpMyAdmin Install Procedure for VM or Amazon EC2 Instance

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

You can modify security groups in the Hub

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.

Use the Hub!

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

MySQL Port Redmine

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's picture

Assuming that it's running on your LAN

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.

Thanks Jeremy.  I compared

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's picture

Good work! :)

Glad you got it working.

Alon Swartz's picture

Glad you're all sorted

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.

Post new comment

The content of this field is kept private and will not be shown publicly. If you have a Gravatar account, used to display your avatar.
  • Web page addresses and e-mail addresses turn into links automatically.
  • Allowed HTML tags: <a> <p> <span> <div> <h1> <h2> <h3> <h4> <h5> <h6> <img> <map> <area> <hr> <br> <br /> <ul> <ol> <li> <dl> <dt> <dd> <table> <tr> <td> <em> <b> <u> <i> <strong> <font> <del> <ins> <sub> <sup> <quote> <blockquote> <pre> <address> <code> <cite> <strike> <caption>

More information about formatting options

Leave this field empty. It's part of a security mechanism.
(Dear spammers: moderators are notified of all new posts. Spam is deleted immediately)