HowtoForge Forums | HowtoForge - Linux Howtos and Tutorials

HowtoForge Forums | HowtoForge - Linux Howtos and Tutorials (http://www.howtoforge.com/forums/index.php)
-   ISPConfig 3 Priority Support (http://www.howtoforge.com/forums/forumdisplay.php?f=35)
-   -   multi-server: phpmyadmin through Control panel (http://www.howtoforge.com/forums/showthread.php?t=62306)

r_c_sekar 21st June 2013 07:06

multi-server: phpmyadmin through Control panel
 
I have this multi-server setup. and i have two DB server and they are all setup alright and works great.

Let us say i have db1.server.com and db2.server.com. db1 server is also the server for control panel. When a client creates a Database in db2.server.com, how does the client browse to db2.server.com/phpmyadmin through the control panel link ? It seems that it always goes to db1.server.com/phpmyadmin.

till 21st June 2013 10:17

You can us ethe variable [SERVERNAME] inside the path settings for phpmyadmin under System > Interface config to let the system switch the user to the correct server automatically.

r_c_sekar 21st June 2013 12:06

Ok, i did something like https://[SERVERNAME]/phpmyadmin and seems to work. But the server name has to be set with external domain name for each server that is being managed in the panel.

And when i created user from the main control panel, let us say i have webserver in db1.server.com. But i also created a DB user and DB on db2.server.com.

This statement has to be manually entered to enable the user to login to DB on db2.server.com from db1.server.com.

GRANT ALL PRIVILEGES ON `database-name` . * TO 'db-user'@'xx.xx.xx.xx';

This can be automated, because the panel knows the servers such as web, db and mail to a particular client.

till 21st June 2013 12:15

ISPConfig creates automatically the permissions for the users so that you can accessthe database from the web server were the website is located and from localhost. If you want to access the website from additional IP addresses, then you can configure the additional IP addresses in the settings of the database.


All times are GMT +2. The time now is 22:53.

Powered by vBulletin® Version 3.8.7
Copyright ©2000 - 2014, vBulletin Solutions, Inc.