How can I use phpPgAdmin or phpMyAdmin?

yoonserk

How can I use phpPgAdmin or phpMyAdmin? Should I install it?

sean

We’ve selected Adminer as our web-based DB admin tool.

You can access it at https://opalN.opalstacked.com/adminer/ replacing opalN with your Opalstack server name.

abunur

sean how do we login here? I tried using the just my username, and also my username@opal12.opalstack.com. I tried resetting the password for this shell user. I don't know what I am supposed to put in the field "database". Everything was denied. I am trying to disable a WP plugin that is bringing down all my sites including the WP admin.

bici

Adminer , like oplastack, is a great minimalist approach

anjanesh

Is there a way to install a single instance of phpMyAdmin that can be used to connect to all/any of the databases in our control panel ? Say at, http://username.opalstacked.com/phpMyAdmin
Or do we have to install separate phpMyAdmins for each app ?

sean

anjanesh Our per-server Adminer install at https://opalN.opalstacked.com/adminer/ (or https://vpsN.opalstacked.com/adminer/ if you are on VPS) can be used with any of your MariaDB and PostgreSQL databases.

If you want to install your own phpMyAdmin instead of using the Adminer software that we provide then something like this should get you started:

Create an Apache+PHP-FPM app (I'll call it "pma") and attach it whatever site and URI you want (I'll use "domain.com/pma").

Download and extract phpMyAdmin into the app directory, eg:

cd ~/apps/pma
wget https://files.phpmyadmin.net/phpMyAdmin/5.0.1/phpMyAdmin-5.0.1-all-languages.zip
unzip phpMyAdmin-5.0.1-all-languages.zip
rm -rf phpMyAdmin-5.0.1-all-languages*

Visit domain.com/pma/setup to complete the installation.
Secure the installation when you've finished setting it up.

This single installation will allow you to log in to any of your MariaDB databases (unless you configure it otherwise).

anjanesh

sean Thanks

yoonserk

@sean Would you add instruction for phpPgAdmin too?

sean

yoonserk the installation steps for phpPgAdmin are nearly identical to those for phpMyAdmin:

Create a PHP app and attach it to the site in the panel.

Download the software and extract it into the app directory:

cd ~/apps/appname
wget https://github.com/phppgadmin/phppgadmin/releases/download/REL_5-6-0/phpPgAdmin-5.6.0.tar.bz2
tar jxf phpPgAdmin-5.6.0.tar.bz2 --strip 1
rm phpPgAdmin-5.6.0.tar.bz2

Complete the installation. In this case a couple of lines of config need to be tweaked by running the following commands:

# this forces TCP connections
sed -i -e "s/conf\['servers'\]\[0\]\['host'\] = ''/conf\['servers'\]\[0\]\['host'\] = 'localhost'/" conf/config.inc.php
# this restricts the DB list to only the DBs that you own:
sed -i -e "s/conf\['owned_only'\] = false/conf\['owned_only'\] = true/" conf/config.inc.php

At that point you should be able to log in to your PostgreSQL databases via the site you created in step 1.

deatul

I am trying to install phpmyadmin but after I setup the installation, phpmyadmin is giving 500 error
Do I need to install phpmyadmin package separately?

sean

deatul you shouldn't need to install anything else.

Please check your logs (under /home/SHELLUSER/logs) for possible clues and feel free to email support if you'd like us to take a look at your setup.

peter

abunur Since you're using WordPress, you can easily find the correct database login credentials by looking at the wp-config.php file in your WordPress app's root directory.