Concerning phpMyAdmin : do you install it on all web server or just one ?

Discussion in 'Installation/Configuration' started by ledufakademy, Aug 30, 2020.

  1. ledufakademy

    ledufakademy Member

    For a multi server setup. ?
    only on the web server where we have installed the panel (ispconfig) ?
     
  2. Th0m

    Th0m ISPConfig Developer ISPConfig Developer

    On every node, and have them connect to localhost. Website owners on web1 would login at web1.example.com, owners on web2 on web2.example.com, etc
     
    ledufakademy likes this.
  3. ledufakademy

    ledufakademy Member

    thank you th0m. i will do that
     
    Th0m likes this.
  4. Th0m

    Th0m ISPConfig Developer ISPConfig Developer

    By the way, if you go to Main config -> Sites -> phpMyAdmin URL, and set [SERVERNAME]/phpmyadmin, users can go to their login page from the database list by clicking on the icon on the right of the item.
     
    ledufakademy likes this.
  5. ledufakademy

    ledufakademy Member

    sounds great, i must remember all those cool tips !
    ;-)
     
    Th0m likes this.
  6. ledufakademy

    ledufakademy Member

    hum no so easy : because i have a multi server setup : ours databases are NOT on web server , where phpmyadmin is located ...
    but on ... database servers ....
     
  7. till

    till Super Moderator Staff Member ISPConfig Developer

    phpmyadmin can connect to any server that you configure in its config file.
     
  8. Th0m

    Th0m ISPConfig Developer ISPConfig Developer

    See https://tecadmin.net/add-multiple-hosts-in-phpmyadmin/ for a guide on how to do this.

    Though I prefer using separate installations for my clients because some get confused easily.
     
    ledufakademy likes this.
  9. ledufakademy

    ledufakademy Member

    my installation are separate : one web1 then one db1 ... web2 then db2 ... etc
     
  10. ledufakademy

    ledufakademy Member

    please could you explain how can i do that ?
    must a create web site in webgui of ispconfig ... this is dark ... for me.

    i remove [Servername], now , i when i click on link ... ispconfig send me to phpmyadmin ... but on phpmyadmin of web server 1 or 2 or 3 ... i don't know.
    BUt if i test with a db user ... c1db1 ... : link , https://admin.domain.com:8080/sites/database_phpmyadmin.php?id=2
    then can't connect with :
    mysqli_real_connect(): (HY000/1045): Access denied for user 'c1db1'@'localhost' (using password: YES)

    this'is not'simple ...
     
    Last edited: Sep 2, 2020
  11. ledufakademy

    ledufakademy Member

    it's not very clear hwo to setup the panel with multi server setup ...
     
  12. ledufakademy

    ledufakademy Member

    with this setup i got : this url and , https://admin.domain.com:8080/sites/db1.domain.com/phpmyadmin
    404 Not Found
    nginx/1.14.2

    I have edit on web1 (where is panel) :

    nano /etc/nginx/sites-available/ispconfig.vhost
    (and comment out , phpmyadmin section)

    Note : My panel is at , https://admin.domain.com:8080/ (on the web server web1)
     
  13. Th0m

    Th0m ISPConfig Developer ISPConfig Developer

    I see, seems like a bug. I'll look into it.

    Never edit this vhosts directly, as they will be overwritten.
     
  14. till

    till Super Moderator Staff Member ISPConfig Developer

    ledufakademy and Th0m like this.
  15. ledufakademy

    ledufakademy Member

    hello Till, yes but this open :
    https://[SERVERNAME]/phpmyadmin
    So [SERVERNAME] must be declared as web sites too ?
    Must i publish a dns record too ?
    And phpmyadmin site is not define in nginx ? (we have 3 web server web1, 2 and 3)

    weird thing ... phpadmin for every client ... on their own databases (so db server)
     
    Last edited: Sep 2, 2020
  16. Th0m

    Th0m ISPConfig Developer ISPConfig Developer

    No.

    You should already have a record for that servername, so if the servername is db1.example.com, that record should exist.

    Install PHPMyAdmin on every DB server like you did in the perfect server config.


    Or don't set it up like this but go like we suggested in #7 and #8
     
  17. ledufakademy

    ledufakademy Member

    i'm going mad with this phpmyadmin setup !!!!
    mysqli_real_connect(): (HY000/1045): Access denied for user 'c2duf_db1'@'localhost' (using password: YES)
     
  18. Th0m

    Th0m ISPConfig Developer ISPConfig Developer

    Are you trying to log in to the correct server?
     
  19. ledufakademy

    ledufakademy Member

    hum, "install phpmyadmin on every db server" ?????
    So db server become a .... web server ?
    So for the multi server setup what the aim to have dedicated db and web server, if we mix evrything evrywhere ?
    ...
     
  20. ledufakademy

    ledufakademy Member

    i thing my issue is here :
    web1:~# nano /usr/share/phpmyadmin/config.inc.php
    ... phpmyadmin is trying to bind on localhost (which is a webserver .. .with nginx) , i dont want that !!
    (and php myadmin is only installed on web server , server with let'e encrypt)
     

Share This Page