Login Try it Free

Manipulating Database

J2 Nov 16, 2011 03:03PM MST

Is there a way to manage my database on PagodaBox? Is there phpMyAdmin or something similar?

Up 14 Rated Down
Scott Nov 16, 2011 04:08PM MST Pagoda Box Agent

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.

Up 7 Rated Down
J2 Nov 16, 2011 05:31PM MST

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.

Up 17 Rated Down
Scott Nov 17, 2011 08:11AM MST Pagoda Box Agent

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.

Installing phpmyadmin:

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:

PHPEdit config.inc.php
$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.

web1:
php_extensions:
– mcrypt
- mysqli
- mysql
- mbstring

Add your edits to your git repo, commit the changes, push the new commit up to your Pagoda Box

Up 15 Rated Down
Josh Schell Jul 09, 2012 08:26PM MDT

The php_extensions causes errors in the parsing of my boxfile. "Boxfile contains invalid yaml"

Up 8 Rated Down
Scott Jul 09, 2012 09:07PM MDT Pagoda Box Agent

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

Up -2 Rated Down
anca Aug 22, 2012 01:21AM MDT

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.

Thanks!

Up 3 Rated Down
Scott Aug 22, 2012 08:41AM MDT Pagoda Box Agent

Hi anca,

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

Post Your Answer

Your name (required)
Your email address (required)
Answer (required)

Contact Us