#1  
Old 28th June 2011, 08:36
pjanzen pjanzen is offline
Junior Member
 
Join Date: Jun 2011
Posts: 6
Thanks: 0
Thanked 0 Times in 0 Posts
Default ISPconfig 3 mulitserver setup.

Hi All,

I am currently testing ISPConfig 3 and it looks promising however in a multi server setup I noticed that you have to change the config.inc.php to point both database connections to dbispconfig (default name). I initialy setup the second server on it own database (dbispconfig_ns1) but that will cause all bind related update stay in the jobqueue, once I pointed the database and the master database setup to the master only things started working as expected.

Hope this helps others too.

Paul

<quote>
*** snip ***

//** Database
$conf['db_type'] = 'mysql';
$conf['db_host'] = 'xxx.xxx.xxx';
$conf['db_database'] = 'dbispconfig'; //** this was dbispconfig_ns1
$conf['db_user'] = 'ispconfig';
$conf['db_password'] = 'xxxxxxx';
$conf['db_charset'] = 'utf8'; // same charset as html-charset - (HTML --> MYSQL: "utf-8" --> "utf8", "iso-8859-1" --> "latin1")

*** more snip ****

//** Database settings for the master DB. This setting is only used in multiserver setups
$conf['dbmaster_type'] = 'mysql';
$conf['dbmaster_host'] = 'xxx.xxx.xxx.xxx';
$conf['dbmaster_database'] = 'dbispconfig';
$conf['dbmaster_user'] = 'ispconfig';
$conf['dbmaster_password'] = 'xxxxxxx';

*** more snip ****
</quote>
Reply With Quote
Sponsored Links
  #2  
Old 28th June 2011, 11:02
till till is offline
Super Moderator
 
Join Date: Apr 2005
Location: Lüneburg, Germany
Posts: 35,504
Thanks: 813
Thanked 5,265 Times in 4,129 Posts
Default

The ispconfig databases should have different names, so your problem is not related to the use of two different databases.

1) Which tutorial did you use to install the servers?
2) Which ISPConfig version did you install?
3) Did you really enter the hostname of the mysql database servers as the tutorial instrucated por did you use an IP address (which will cause the setup to fail)?
__________________
Till Brehm
--
Get ISPConfig support and the ISPConfig 3 manual from ispconfig.org.
Reply With Quote
  #3  
Old 28th June 2011, 11:12
pjanzen pjanzen is offline
Junior Member
 
Join Date: Jun 2011
Posts: 6
Thanks: 0
Thanked 0 Times in 0 Posts
Default

Hi Till,

I mainly used this tut http://www.howtoforge.com/installing...ispconfig-3-p3 but when you get to:
MySQL database to create [dbispconfig]: <-- dbispconfig
and continue you get a error that says that there are already tables there. thats where I put dbispconfig_ns1 to get around this problem.

ISP version is 3.0.3.3

I do have fat fingers sometimes but yeah I am pretty sure or it would expect the error "Cannot connect to host: ...."

It is not I need help, I just posted this to help and inform other that might run into the same problem.

Paul
Reply With Quote
  #4  
Old 28th June 2011, 12:31
till till is offline
Super Moderator
 
Join Date: Apr 2005
Location: Lüneburg, Germany
Posts: 35,504
Thanks: 813
Thanked 5,265 Times in 4,129 Posts
Default

I guess you installed the system wrong by using a central database for all nodes which is not supported by ISPConfig as it introduces a single point of failure.

It is required that every node has its own sql server. The sql server is used to synchronize the configuration. So you have to enter "localhost" as mysql server name like the guide tells you and install mysql on all nodes of that multiserver setup and then reinstall the slave node.
__________________
Till Brehm
--
Get ISPConfig support and the ISPConfig 3 manual from ispconfig.org.
Reply With Quote
  #5  
Old 28th June 2011, 14:50
pjanzen pjanzen is offline
Junior Member
 
Join Date: Jun 2011
Posts: 6
Thanks: 0
Thanked 0 Times in 0 Posts
 
Default

I'll have test with your suggestion

Thnx
Reply With Quote
Reply

Bookmarks

Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off

Forum Jump

Similar Threads
Thread Thread Starter Forum Replies Last Post
Version 1.3 of the ISPConfig 3 Manual is finally available! falko General 44 2nd December 2011 12:04
use jawstats / mawstats with ispconfig e100 Tips/Tricks/Mods 3 19th December 2010 11:33
64bit ISPConfig / Perfect Setup CentOS 5 wpwood3 General 5 3rd December 2007 02:11
ISPConfig recommended setup for 2 identical servers clanx Installation/Configuration 4 2nd November 2007 10:11
ISPConfig 2.3.2-dev released till General 9 4th June 2007 10:46


All times are GMT +2. The time now is 10:02.


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