Go Back   HowtoForge Forums | HowtoForge - Linux Howtos and Tutorials > ISPConfig 3 > ISPConfig 3 Priority Support

Do you like HowtoForge? Please consider supporting us by becoming a subscriber.
Reply
 
Thread Tools Display Modes
  #1  
Old 5th July 2013, 12:46
abintipl abintipl is offline
Senior Member
 
Join Date: Nov 2010
Posts: 145
Thanks: 29
Thanked 5 Times in 5 Posts
Default Adding more servers to Multi server set up

Hi,

I have latest Ispconfig on Debian 6 with OpenVz Multi Server set-up & it's running fine.

My Initial set up is One one Dedicated server with six vps & are used as under;

NS - 2
Web - 3
DB - one

Since I have extra VPS and trying to add more vps to the existing set-up by adding oneMail as well as 3 more web servers.

I have followed same Instructions but when during the set up of Mail or web servers I get an ERROR

Unable to connect

I am giving correct root password

Please advice

Further, do I need to stop any services before adding more servers

Thanks & regards,

Abin
Reply With Quote
Sponsored Links
  #2  
Old 5th July 2013, 13:18
till till is online now
Super Moderator
 
Join Date: Apr 2005
Location: Lüneburg, Germany
Posts: 35,434
Thanks: 813
Thanked 5,209 Times in 4,085 Posts
Default

Quote:
I have followed same Instructions but when during the set up of Mail or web servers I get an ERROR

Unable to connect

I am giving correct root password
This means that mysql on the master is not reachable from this server. Possible reasons are:

- no new root user for IP and hostname of the slave was added in the master
- mysql not restarted or flush privileges not executed after adding the user
- Firewall problems


Quote:
Further, do I need to stop any services before adding more servers
No.
__________________
Till Brehm
--
Get ISPConfig support and the ISPConfig 3 manual from ispconfig.org.
Reply With Quote
  #3  
Old 5th July 2013, 14:28
abintipl abintipl is offline
Senior Member
 
Join Date: Nov 2010
Posts: 145
Thanks: 29
Thanked 5 Times in 5 Posts
Default Adding more servers to Multi server set up

Dear Sir,

Thank you so much for your prompt reply.

After restarting mysql, I could able to connect.

While the installation was in progress, by mistake had to stop the installation when I was on below step

>> Initial configuration

Operating System: Debian 6.0 (Squeeze/Sid) or compatible

Shall this server join an existing ISPConfig multiserver setup (y,n) [n]: y

MySQL master server hostname []: webmain.mydomain.com

MySQL master server root username [root]:

MySQL master server root password []: Server Password

MySQL master server database name [dbispconfig]:

ERROR: Stopped: Database already contains some tables.

If I run Update then get this Error

>> Update

Operating System: Debian 6.0 (Squeeze/Sid) or compatible

PHP Warning: include_once(/usr/local/ispconfig/server/lib/config.inc.php): failed to open stream: No such file or directory in /tmp/ispconfig3_install/install/ update.php on line 75
PHP Warning: include_once(): Failed opening '/usr/local/ispconfig/server/lib/config.inc.php' for inclusion (include_path='.:/usr/share/php:/usr/share/pear') in
/tmp/ispconfig3_install/install/update.php on line 75
PHP Notice: Undefined variable: conf in /tmp/ispconfig3_install/install/update.php on line 76

My Question is

Which table/record I should remove from Main Server(webmain)DB of "dbispconfig" to solve

ERROR: Stopped: Database already contains some tables.

How to so I run & complete mail server set up

Thanks & regards,

Abin
Reply With Quote
  #4  
Old 5th July 2013, 17:30
till till is online now
Super Moderator
 
Join Date: Apr 2005
Location: Lüneburg, Germany
Posts: 35,434
Thanks: 813
Thanked 5,209 Times in 4,085 Posts
Default

The error is not about the master server, the error means that there is already a local ispconfig installation and database. Run the uninstall.php script on the new slave server to remove ispconfig and the use the install.php script to install it again.
__________________
Till Brehm
--
Get ISPConfig support and the ISPConfig 3 manual from ispconfig.org.
Reply With Quote
  #5  
Old 5th July 2013, 18:39
abintipl abintipl is offline
Senior Member
 
Join Date: Nov 2010
Posts: 145
Thanks: 29
Thanked 5 Times in 5 Posts
Default Adding more servers to Multi server set up

Sir,

Thank you for your reply.

If I run php -q uninstall.php

Output is as under;

>> Uninstall

PHP Warning: require(/usr/local/ispconfig/server/lib/config.inc.php): failed to
open stream: No such file or directory in /tmp/ispconfig3_install/install/unins
tall.php on line 50
PHP Fatal error: require(): Failed opening required '/usr/local/ispconfig/serve
r/lib/config.inc.php' (include_path='.:/usr/share/php:/usr/share/pear') in /tmp/
ispconfig3_install/install/uninstall.php on line 50
root@mail:/tmp/ispconfig3_install/install#

If I run php -q install.php then the output;

..............

Shall this server join an existing ISPConfig multiserver setup (y,n) [n]: y

MySQL master server hostname []: webpanel.mydomian.com

MySQL master server root username [root]:

MySQL master server root password []: Password

MySQL master server database name [dbispconfig]:

ERROR: Stopped: Database already contains some tables.

Thank you in advance for your help.

Regards,

Abin
Reply With Quote
  #6  
Old 5th July 2013, 18:44
till till is online now
Super Moderator
 
Join Date: Apr 2005
Location: Lüneburg, Germany
Posts: 35,434
Thanks: 813
Thanked 5,209 Times in 4,085 Posts
Default

Ok, the unistaller does not work as the installer was interrupted after creating the db but before he could write the config file. Please delete the dbispconfig database on the slave server, with phpmyadmin or the mysql commandline tool. As alternative you can do this (as it is a myisam table) as quick and dirty method:

/etc/init.d/mysql stop
rm -rf /var/lib/mysql/dbispconfig
/etc/init.d/mysql start

and then try the install again.
__________________
Till Brehm
--
Get ISPConfig support and the ISPConfig 3 manual from ispconfig.org.
Reply With Quote
The Following User Says Thank You to till For This Useful Post:
abintipl (5th July 2013)
  #7  
Old 5th July 2013, 19:10
abintipl abintipl is offline
Senior Member
 
Join Date: Nov 2010
Posts: 145
Thanks: 29
Thanked 5 Times in 5 Posts
 
Default Adding more servers to Multi server set up

Thank you so much!

It worked for me to complete my Mail server( slave) installation

When I checked my Master Server, I could see earlier Mail server Record for which installation got interrupted under System>Server

I deleted this old record from Main Server

Thank you so much for your help

warm regards,

Abin
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
ISPConfig 3 system installation script Mark_NL Tips/Tricks/Mods 12 7th March 2014 06:30
ERROR: unable to bind listening socket for address '127.0.0.1:8999': Address already kvess1967 HOWTO-Related Questions 1 8th March 2013 14:49
Local mail server - final touch Alexhor Installation/Configuration 4 12th April 2012 22:33
Centos5.4/ISPConfig 3--Virtual site not working MichaelCaditz Installation/Configuration 25 25th March 2011 11:37
amavis & ispconfig 3 yalex2000 Installation/Configuration 20 18th February 2010 17:02


All times are GMT +2. The time now is 12:55.


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