Topic: mysqladmin ok in Primary Ibay, but not in other Ibays!

[Foa]

I can use mysqladmin in Primary Ibay, but not in other Ibays!
Is it possible to get it working from other Ibays?
Or is it a bug?

[stephdl]

are you talking about phpMyAdmin -> https://www.phpmyadmin.net/

normally it is reachable with the sme IP or from every domain of your sme with the folder /phpmyadmin at the end
example :

https://yourdomain.com_OR_yourSmeIP/phpmyadmin


of course if you don't use sme as a gateway server, you need to point  all your domains to the SME server in your router. It is out of the box with a 'server and gateway' installation.

[Foa]

Thanks stephdl!
You are correct, I do not understand where I got "mysqladmin" from...
It is phpmyadmin that I can use, but only in the Primary Ibay

I installed sme9 as server-only
https://192.168.1.100/phpmyadmin/         and it works fine

https://192.168.1.100/tame_nu/phpmyadmin        I got this error: The requested URL /tame_nu/phpmyadmin was not found on this server

https://192.168.1.100/tame_se/phpmyadmin        I got this error: The requested URL /tame_nu/phpmyadmin was not found on this server

tame-nu is one Ibay and tame_se is Another Ibay

[DanB35]

Have you installed phpmyadmin multiple times, in multiple locations?  If so, why?  If not, why would you be trying to access it at multiple locations?

[zatnikatel]

yes phpmyadmin will show all the databases you have for all the wordpress's you have installed you don't have to add a directory in front my phpmyadmin as it has been said just type https://your ip of the server/phpmyadmin
as i have a few databases install and doing it just like has been said it will show all the databases installed

[Foa]

Have you installed phpmyadmin multiple times, in multiple locations?  If so, why?  If not, why would you be trying to access it at multiple locations?

No, I did follow the instruction of sme9 to install  it once!
And I have not created any directory called "phpmyadmin"

When I wrote in my posting "https://192.168.1.100/phpmyadmin/  " that is what i wrote in Firefox
So what I understand Primary Ibay will reply with ok to enter the database.
But https://192.168.1.100/tame_nu/phpmyadmin/  will give an error that the directory do not exist

So in Primary Ibay or any other Ibay like "tame_nu" is no directory, but still Primary Ibay is the only that respond when Firefox connecting

[Foa]

yes phpmyadmin will show all the databases you have for all the wordpress's you have installed you don't have to add a directory in front my phpmyadmin as it has been said just type https://your ip of the server/phpmyadmin
as i have a few databases install and doing it just like has been said it will show all the databases installed

Yes that is right.. that is tha way it works for me too.
And I have not added any directory named "phpmyadmin"
But why do it works only https://your ip of the server/phpmyadmin (what understand that is Ibay Primary, am I right?)

[DanB35]

But why do it works only https://your ip of the server/phpmyadmin (what understand that is Ibay Primary, am I right?)

Because that's the way it's installed.  It isn't actually in the primary ibay, or any ibay; it's in /usr/share/phpmyadmin.  But why would you expect, or want, it to appear as a subdirectory of every ibay?  It doesn't, it isn't intended to, and I can't see any reason it should.

[Stefano]

But why would you expect, or want, it to appear as a subdirectory of every ibay?  It doesn't, it isn't intended to, and I can't see any reason it should.

I agree with Dan

@Foa: could you please explain what are you trying to achieve (i.e. the problem) and not your solution?
sounds like a X Y problem case..

[Foa]

Because that's the way it's installed.  It isn't actually in the primary ibay, or any ibay; it's in /usr/share/phpmyadmin.  But why would you expect, or want, it to appear as a subdirectory of every ibay?  It doesn't, it isn't intended to, and I can't see any reason it should.

Thank You very very much fot the answer that is not what I have seen on other places, and not in the utser manual.
Now when I know I will live with it.

Or..... Is it possible to as root alter /usr/share/phpmyadmin so it will work in any Ibay?

Your question why I expect or want, is ok. But it is a long story to answer.

[Daniel B.]

Or..... Is it possible to as root alter /usr/share/phpmyadmin so it will work in any Ibay?

Your question why I expect or want, is ok. But it is a long story to answer.

Long or short story is not issue. It's just that it makes no sens. phpMyAdmin manage mysql databases, which are completely unrelated to ibays.

[DanB35]

Thank You very very much fot the answer that is not what I have seen on other places, and not in the utser manual.

What have you seen on other places?  I dare say you've never seen a web server that takes content placed at one URL, and makes it available at other random URLs, without being explicitly told to--and that's what you're asking for here.

You shouldn't expect anything about phpmyadmin to be in the user manual, because it isn't part of the base SME Server distribution.  It's a contrib, packaged by a third party for use with SME Server, and documented on its own wiki page (https://wiki.contribs.org/PHPMyAdmin).  I guess that page could mention that it's available at https://yourserver/phpmyadmin (which the wiki already says), and not at https://yourserver/$RANDOMIBAY/phpmyadmin (which it doesn't).  It could also mention that the contrib is not known to have caused the death of any small kittens, which would make about as much sense.  There's simply no reason to expect that a web app that's located at one URL will be accessible at any other URL.

If you have more than one domain set up for your your SME server, phpmyadmin is accessible at all domains--https://www.firstdomain.tld/phpmyadmin, https://www.seconddomain.tld/phpmyadmin, etc.  But it isn't going to be accessible under any subdirectory unless you put it there.  Or, if you want different users to have access to different databases, enable multiuser access for phpmyadmin (it's described on the wiki page), and have the users log in with a user/password suitable for the database(s) you want them to have access to.  But you haven't said what you're trying to accomplish, I'm not sure if either of these will help you.

[zatnikatel]

i agree with Dan phpmyadmin is not meant to work that way it is a single program that is not connected to a directory/ibay standalone program is what it is for working with mysql and i set it up on mandrive Linux centos etc and it works the same way as has been said it will work with different domains but not a directory/ibay

[janet]

Foa

Or..... Is it possible to as root alter /usr/share/phpmyadmin so it will work in any Ibay?
Your question why I expect or want, is ok. But it is a long story to answer.

Your understanding about phpmyadmin & server setup eg aliases, appears to be limited.

There are a lot of very clever & experienced people here, but if you cannot or choose not to explain your requirements, then it is VERY difficult for people to guess what you are doing & therefore difficult to advise you accordingly.

phpmyadmin has been around for a long time, there are no issues using it or setting it up on sme server, you can use the contrib rpm or you can even install in manually to an ibay or wherever you want. Consider security implications carefully.
If installing manually you would follow the generic instructions on phpmyadmin site & be prepared to configure various settings manually also.

So even though you think it is a long story, you need to tell us as succinctly as possible what you are really trying to achieve, if you want accurate answers & advice.

[ReetP]

I wonder if the user does not realise you need one install of phpmyadmin to manage ALL databases.

Also I wonder if the user thinks they are wanting to give a per ibay access per client/user

E.g user A has an ibay A and he wants to give the user access to manage a db for that user.

In which case he needs one install and then multiple users to phpmyadmin, each with access to only their own db.

Clearly the user needs to explain what he is trying to achieve before we can help further.

B. Rgds
John