none
phpMyAdmin, MySQL 5 and WebsitePanel RRS feed

  • Question

  • All,

    Does anyone have any step by step guides for integrating phpMyAdmin into WebsitePanel for managing MySQL databases?

    I have my websitepanel setup along with MySQL 5 and have a base install of phpMyAdmin accessable locally from http://localhost/phpMyAdmin.  I get the login box and can login with MySQL root but none of the hosted accounts.  I can't seem to get the 'Browse Database' link in websitepanel to work and am prompted with a 404 not found IIS error nor does the default phpMyAdmin login page allow anything other than route.

    I am led to believe that it can be configured so that when you click 'Browse Database' under MySQL 5 in WebsitePanel then it should automatically authenticate and open phpMyAdmin.  For info my MySQL config in WebsitePanel is set to this:

    Database browser login:  http://localhost/phpmyadmin.[webdomain]/index.php?Server=[server]&Username=[user]&Password=[password]

    Database browser login method:  GET

    Appreciate any help that can be offered on this.

    Thanks,

    Friday, June 15, 2012 3:02 PM

Answers

  • Hello,

    First things first: phpmyadmin is just a website.. so it will have to be accesable from the outside world if you want to provide it to your customers.

    If your domain is added to WSP.. just go to your account.. create a subdomain + site.. push phpmyadmin on there.. check out the config file. (rename it if needed.. read the default phpmyadmin setup guide).

    Once phpmyadmin is setup correctly (stand-alone.. not with WSP) it's time to configure WSP with it.

    Just go to Configuration --> Servers --> Select your mysql service.

    Fill in your user information etc if you haven't setup mysql yet (this is for creating db's and usernames).

    If thats setup then just scroll down to the bottom:

    Database Browser Logon URL: fill in your FULL path (external path) in my example:  https://mysql.key4ce.com (in most common cases this would be http://mysql.domainname.com)

    Database Browser Logon Method: POST

    Database Browser Logon Parameters:

    pma_username=[USER]
    pma_password=[PASSWORD]

    my config screenshot:

    Once thats filled in.. go to your Customers hosting space --> mysql databases

    then it should look like this:

    Regards,

    Marco


    Key4ce - IT professionals: www.key4ce.eu


    Friday, June 15, 2012 3:37 PM
    Moderator

All replies

  • Hello,

    First things first: phpmyadmin is just a website.. so it will have to be accesable from the outside world if you want to provide it to your customers.

    If your domain is added to WSP.. just go to your account.. create a subdomain + site.. push phpmyadmin on there.. check out the config file. (rename it if needed.. read the default phpmyadmin setup guide).

    Once phpmyadmin is setup correctly (stand-alone.. not with WSP) it's time to configure WSP with it.

    Just go to Configuration --> Servers --> Select your mysql service.

    Fill in your user information etc if you haven't setup mysql yet (this is for creating db's and usernames).

    If thats setup then just scroll down to the bottom:

    Database Browser Logon URL: fill in your FULL path (external path) in my example:  https://mysql.key4ce.com (in most common cases this would be http://mysql.domainname.com)

    Database Browser Logon Method: POST

    Database Browser Logon Parameters:

    pma_username=[USER]
    pma_password=[PASSWORD]

    my config screenshot:

    Once thats filled in.. go to your Customers hosting space --> mysql databases

    then it should look like this:

    Regards,

    Marco


    Key4ce - IT professionals: www.key4ce.eu


    Friday, June 15, 2012 3:37 PM
    Moderator
  • Worked perfectly.

    Thanks.

    Saturday, June 16, 2012 10:29 AM
  • as we have multiple servers we have a dropdown list of servers on our phpmyadmin login page, do you know how to pass this value ?

    I have tried using

    server=[value]

    where value= the number of the server in the drop down, but doesn't work.


    Snake

    Monday, January 6, 2014 2:53 PM
  • Well, we use Multiple sql servers but isolated it on the address it self.

    So for each SQL Cluster we use a different fqdn name --> configure phpmyadmin for that cluster --> set the url in wsp mysql service.

    for phpmyadmin it self you can configure multiple servers as shown in this example:

    http://wiki.phpmyadmin.net/pma/Multiserver

    in the WSP Post values you can set pma_server value (i think, i am not 100% sure on the value but i tought it was pma_server) so it uses the correct server configuration.

    Regards,

    Marco


    Key4ce - IT professionals: www.key4ce.eu

    Monday, January 6, 2014 3:04 PM
    Moderator
  • our phpmyadmin is already configured for multi server (thus the question) and works fine in that respect, it is only the WSP link not working.

    I used to have a separate phpmyadmin instance for each server as you do, but it just makes more phpmyadmin instances to update, so switched to 1 instance with a server selector.

    In the form, the dropdown list is just called "server" not "pma_server", although I tried pma_server as well, no dice.

    out of interest what clustering method are you using, I presume you are using the FREE edition of MySQL ?


    Snake

    Monday, January 6, 2014 3:13 PM
  • hmm odd.

    pma_server is listed as an object in some phpmyadmin documentations.

    but your right in the form it's listed as server.

    In that case i wouldn't know why it doesn't work. i'm assuming you already verified the values listed in the selection box?.

    As far as mysql clusters: We chose for the Failover cluster method (easy to do with windows and linux no paid licenses needed).

    We did try master/master and some other loadbalancing techniques but found it to run out of sync to quickly to be trust worthy.


    Key4ce - IT professionals: www.key4ce.eu

    Monday, January 6, 2014 3:21 PM
    Moderator