Discussion in 'Installation/Configuration' started by ledufakademy, Aug 30, 2020.
For a multi server setup. ?
only on the web server where we have installed the panel (ispconfig) ?
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
thank you th0m. i will do that
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.
sounds great, i must remember all those cool tips !
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 ....
phpmyadmin can connect to any server that you configure in its config file.
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.
my installation are separate : one web1 then one db1 ... web2 then db2 ... etc
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 ...
it's not very clear hwo to setup the panel with multi server setup ...
with this setup i got : this url and , https://admin.domain.com:8080/sites/db1.domain.com/phpmyadmin
404 Not Found
I have edit on web1 (where is panel) :
(and comment out , phpmyadmin section)
Note : My panel is at , https://admin.domain.com:8080/ (on the web server web1)
I see, seems like a bug. I'll look into it.
Never edit this vhosts directly, as they will be overwritten.
There is no bug, he just used a wrong setting as phpmyadmin URL. It has to be:
hello Till, yes but this open :
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)
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
i'm going mad with this phpmyadmin setup !!!!
mysqli_real_connect(): (HY000/1045): Access denied for user 'c2duf_db1'@'localhost' (using password: YES)
Are you trying to log in to the correct server?
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 ?
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)
Separate names with a comma.