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

[Stefano]

OP has been already told to explain the whole plot.. but, ATM, he didn't..

[janet]

Foa

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

Still guessing what you want, the way to do that is to create an alias in/for the ibay that points at the installed location on phpmyadmin.
An alias is typically created by the installation process of the rpm which is the reason you can access phpmyadmin using the Primary ibay location as the url.
You could probably copy & duplicate the alias that has already been created for the Primary ibay.
You can create aliases manually using custom templates & so on.

[Stefano]

can we wait for OP to give us all the info instead of giving him some kind of "solution"?

thank you

P.S: don't get me wrong, but what we write here could be used by other users and we don't want people to break their server

[janet]

Stefano

Come on, now there are rules of how people are supposed to answer questions, or not !
We can wait for more info as requested, but we can also a directly answer specific questions as they are identified.
I think people should be free to answer as they please & not be directed to answer one way or another or not at all.

[Stefano]

I guess my english is failing since some days..

Janet..
I'm just asking everybody to wait for OP explanations about what he's trying to achieve and why..
as I already said, it sounds to me like a classic X Y problem.. we're giving him (maybe) some solutions for the wrong problem

[janet]

Stefano

I still think that you should not be directing people regarding what they do, or not do.
It's a free world !

[Stefano]

ok, you win

[TerryF]

Bad day at the races?, Stefano isn't trying to be the question and answer nazi, just being logical

I am puzzled as to what the OP wants to do, it seems he has a perfectly fine and working install of PhpMyAdmin.

What does he want?

[Foa]

I am reading all the postings, and I feel no good that I can't make me understod.
And I also understand You people with a lot of know how that need better explanation from my side.
Now I have put my self in a situation that I do not feel right to make more questions, to make more problem for people that do not understand.
My fault, sorry.

[ReetP]

I am reading all the postings, and I feel no good that I can't make me understod.
And I also understand You people with a lot of know how that need better explanation from my side.
Now I have put my self in a situation that I do not feel right to make more questions, to make more problem for people that do not understand.
My fault, sorry.

Foa,

Please just post what you are trying to achieve and we will try and help you.

B. Rgds
John

[Stefano]

Foa:

we are here to help you, and, believe me, your english is good enough.

that said, we need to know:
- what are you aiming to? in other words, what do you want?
- why do you want it? it may appera as not relevant, but believe me, sometimes people ask for solutions to problems that are not technical, but human
and often, the solution you (generally speaking, I'm not referring to you)  think may work is just a complication.

no long or short story, explain us the whole story

thank you

[Foa]

Foa,

Please just post what you are trying to achieve and we will try and help you.

B. Rgds
John

All is ok..
DanB gived me the answer that made me to understand why I got a problem!
He wrote:

   
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.

[Stefano]

All is ok..
DanB gived me the answer that made me to understand why I got a problem!
He wrote:

you haven't a problem at all.. you have a need, we need to know which is it to help you, that's all

[Foa]

you haven't a problem at all.. you have a need, we need to know which is it to help you, that's all

Ok

[zatnikatel]

totally with Stefano we are here to help you but what you want to do in detail helps us out a lot and we can fix your problem quick
we are a helpful here and only want to sort out you problems 

[zatnikatel]

totally agree with Stefano we are here to help you
but we want in detail what the problem is to help you and get the problem fixed quick
we are a helpful here and only want to sort out what you are not sure yourself