Is there a way to manage my database on PagodaBox? Is there phpMyAdmin or something similar?
The best way to manage your database is through the Pagoda Box Database Tunnel. It allows you to connect to your live database using your db manager of choice. There’s more info in this guide: http://help.pagodabox.com/customer/portal/articles/175427. Using phpmyadmin is a possibility, but we don’t recommend it.
Hmm. I was hoping Pagodabox had something web-based. I knew about the tunnel, which I could almost see being pointless. It's just nice to be able to <app>.pagodabox.com/<db_manager>, as opposed to opening the terminal, calling the command, and firing up one of the (mostly crappy) desktop database tools.
Below are instructions for installing phpmyadmin. Again, we don’t recommend going this route because we cannot guarantee the security of phpmyadmin.
The tunnel is a universal tool that will work for all hosted services on Pagoda Box. This means that as we roll out things like MongoDB, Memcache, etc., the tunnel is what will be used to connect directly to all of those services.
Download phpMyAdmin, uncompress it and place it in the root of your application. Rename the directory something more friendly like phpmyadmin instead of phpMyAdmin-x.×.×.x-language
Rename config.sample.inc.php to config.inc.php and make the following changes:
$cfg[‘Servers’][$i][‘connect_type’] = ‘tcp’;
$cfg[‘Servers’][$i][‘host’] = ‘tunnel.pagodabox.com’;
$cfg[‘Servers’][$i][‘port’] = ‘<port provided in app dashboard>’;
Add the following php extensions needed to run phpMyAdmin into your app’s Boxfile. If you have questions about the Boxfile, check out Understanding the Boxfile Guide.
Add your edits to your git repo, commit the changes, push the new commit up to your Pagoda Box
The php_extensions causes errors in the parsing of my boxfile. "Boxfile contains invalid yaml"
Josh: Try pasting your Boxfile contents into a yaml validator like http://yamllint.com/ and it should help you identify the invalid yaml. If you copied the yaml from this post, it’s very likely the spacing is off as it doesn’t copy/paste well.
It may also help to reference the Boxfile guide http://help.pagodabox.com/customer/portal/articles/175475-understanding-the-boxfile
Jed:I am using Ubuntu 11.10 and I want to use phpmyadmin on pagodabox. I followed the steps written by you (downloading phpmyadmin, renaming and editing config.inc.php, adding to my git repo), but I cannot login into phpmyadmin because after i enter the username and the password i get this error '#2003 Cannot log in to the MySQL server'. I want to mention that i inserted the username and password that i am using on my local phpmyadmin, because i also have phpmyadmin configured on localhost and it works.
I dont't know what the problem is, but please tell me if I should change some configuration for my local phpmyadmin, or maybe, for the downloaded phpmyadmin.
It sounds like it’s just a matter of your config/db creds, but it’s hard to say where the problem is without taking a look. If you can submit a private ticket with your app name, I can take a look. http://help.pagodabox.com/customer/portal/emails/new