phpMyAdmin access trough URL

Hi,

I installed Sharetribe on Ubuntu as non root user. It is my very first experience with programing server and with Ruby, but I managed to do it all… and now have working instance of self hosted Sharetribe.

To point installation to the right directory I changed directory in apache2.conf to : home/myusername

Now my site opens just fine, and I can access my site using domain name.

But I can’t access phpMyAdmin

when I try to use IP/phpmyadmin IP number changes to domain name and it gives this same page as on

Sharetribe demo:

https://demofordc.sharetribe.com/phpmyadmin

Page not found!
The page you requested cannot be found. Are you sure you spelled the address correctly?

If it was php I would say it is .htaccess file…

But this is Ruby and I am seeing this code very first time in my life :slight_smile: I am fast learner and will soon be the best at it, but for now I need little help.

Can someone tell me how to access phpMyAdmin ?

phpMyAdmin is standard with wordpress deployments, but Rails based projects do not typically deploy this tool. I’d like to suggest a DB management tool, but, as a developer, I usually handle it from the command line for Rails.

The only reason I was asking because for me phpMyAdmin is the easiest tool to manage and read database.

After initial install before domain name is set phpMyAdmin is acessable using http://ipnumber/phpmyadmin

but right after domain name is set it is no longer accessible… and gives this custom Page not found error.

In my case I wanted to find a database field with default language setting, but have no idea how I could do this without more friendly database tool.

I assume that in my case phpMyAdmin was there but it is somehow blocked my Sharetribe script because it gives this custom page… (and it was there before pointing domain to ip)

Now I decided to do it all over again and will reinstall Sharetribe from fresh. Is there a way to allow phpMyAdmin to be accessible while Sharetribe is installed?

I see. While it’s hard for me to specifically say what’s going on, Rails routing must be overriding the routing to the instance of phpmyadmin you have running.

I found this, but I’m afraid I don’t have any more suggestions than what this guy did:
https://www.digitalocean.com/community/questions/how-do-i-configure-phpmyadmin-to-work-with-passenger-rails-and-apache2-on-ubuntu-14-04

Thank you so much for your help. This is actually pointing me somewhere… tried without luck but I must be doing something wrong.

Anyways I kept phpMyAdmin and if I do need to work or make any changes I can shut my website down for few minutes by modifying apache2 enabled-sites :slight_smile:

This gave me enough time to enter my API keys and export database so I can read it instead of a novel before I go to sleep :slight_smile:

I would recommend HeidiSQL over PHPMyAdmin. It is faster and more secure. There are some guides on how to set it up with Rails online that you can look up.

1 Like

One thing that tripped me up the first time I installed phpmyadmin was that when it asks which webserver you are running apache2 is highlighted, but you still have to select it using the space bar or it will not be configured properly.

For now if I need to use phpMyAdmin I just disable domain and this way I can access it. I think I will make Maintenance page in /var/www/htm/ folder to inform users that site is undergoing maintenance and will resume shortly.

+1 for HeidiSQL, great solution. PHP My Admin is also quite unsecure these days.

Thank you for recommendation. Seems like it is good solution to consider.

1 Like

Accessing the url in a specific network might become difficult if the gateway is not properly configured. For more information visit https://netgears.support/netgear-genie-support

I have same problem Please help me. See now