cpanel on front and back end

taydu

Member
Oct 4, 2007
9
0
51
how can i get cpanel to work with front and back-end server config?

front-end: apache, php,
back-end: mysql

front and back are connect via private lan with private NIC.

is there a tutorial for this, please help

thanks
 

cPanelDavidG

Technical Product Specialist
Nov 29, 2006
11,212
13
313
Houston, TX
cPanel Access Level
Root Administrator
how can i get cpanel to work with front and back-end server config?

front-end: apache, php,
back-end: mysql

front and back are connect via private lan with private NIC.

is there a tutorial for this, please help

thanks
Are you simply attempting to setup a remote MySQL server for use by the cPanel/WHM server or are you having a specific set of scripts on the cPanel/WHM server connect to a remote MySQL server?
 

taydu

Member
Oct 4, 2007
9
0
51
setup remote mysql server to use with cpanel/whm. on a LAMP server everything include Cpanel is install on 1 box, now i want to use a seperate server for mysql, and want to know how to set it up so cpanel will work with the external mysql server.
 

cPanelDavidG

Technical Product Specialist
Nov 29, 2006
11,212
13
313
Houston, TX
cPanel Access Level
Root Administrator
setup remote mysql server to use with cpanel/whm. on a LAMP server everything include Cpanel is install on 1 box, now i want to use a seperate server for mysql, and want to know how to set it up so cpanel will work with the external mysql server.
Actually, that's fairly easy as long as you follow the instructions provided in the WHM interface.

Go to WHM -> SQL Services -> Setup Remote MySQL Server. At the bottom of that page you will see some notes:

* You must be able to connect via ssh from this server's IP address for this to work properly.
* MySQL and Perl must already be installed on the remote server.
As long as those conditions are met, simply fill out the form, click Setup and follow any on-screen instructions to set this up.
 

taydu

Member
Oct 4, 2007
9
0
51
First of all both servers will reside on the same private lan communication between web and database server will only be on private lan for speed and bw. So do i need SSH ?

form fresh the web server will have apache, php and cpanel installed (no mysql) the db server have mysql install up and running.

Now all i do is go into WHM -> SQL Services -> Setup Remote MySQL Server follow instruction on screen and that's it ? I will have a complete LAMP setup ?
 

cPanelDavidG

Technical Product Specialist
Nov 29, 2006
11,212
13
313
Houston, TX
cPanel Access Level
Root Administrator
First of all both servers will reside on the same private lan communication between web and database server will only be on private lan for speed and bw. So do i need SSH ?
SSH is simply the means by which this process is done, it has nothing to do with the proximity of the servers therefore, yes, the cPanel/WHM server will need to be able to SSH to the MySQL server. How you set that up is essentially up to you.

form fresh the web server will have apache, php and cpanel installed (no mysql) the db server have mysql install up and running.

Now all i do is go into WHM -> SQL Services -> Setup Remote MySQL Server follow instruction on screen and that's it ? I will have a complete LAMP setup ?
The Apache and PHP will be on the cPanel/WHM server and the MySQL server being on the remote server would result in a complete LAMP setup.