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

Do you like HowtoForge? Please consider supporting us by becoming a subscriber.
Reply
 
Thread Tools Display Modes
  #11  
Old 22nd December 2011, 05:03
chume chume is offline
Member
 
Join Date: Sep 2010
Posts: 33
Thanks: 4
Thanked 1 Time in 1 Post
Default

Could the configuration below affect upgrading a slave server?
During upgrade, the root and password of the master server are required.
So what happens if remote access to the master server mysql root is disabled?

Quote:
Normally, root should only be allowed to connect from 'localhost'. This
ensures that someone cannot guess at the root password from the network.

Disallow root login remotely? [Y/n] <-- ENTER
... Success!
Reply With Quote
Sponsored Links
  #12  
Old 22nd December 2011, 10:24
till till is online now
Super Moderator
 
Join Date: Apr 2005
Location: Lüneburg, Germany
Posts: 36,782
Thanks: 840
Thanked 5,610 Times in 4,421 Posts
Default

Quote:
So what happens if remote access to the master server mysql root is disabled?
The update will fail and the slave server might not be able to communicate with the master as it could not update the permissions of its ispcsrv user..

Quote:
Normally, root should only be allowed to connect from 'localhost'. This
ensures that someone cannot guess at the root password from the network.

Disallow root login remotely? [Y/n] <-- ENTER
... Success!
The multiserver setup guide instructed you to create new root user records that are only accessible from the slave, the above settings is for a global wirldcard root access and not the records from the ispconfig multiserver setup.
__________________
Till Brehm
--
Get ISPConfig support and the ISPConfig 3 manual from ispconfig.org.
Reply With Quote
  #13  
Old 22nd December 2011, 10:25
till till is online now
Super Moderator
 
Join Date: Apr 2005
Location: Lüneburg, Germany
Posts: 36,782
Thanks: 840
Thanked 5,610 Times in 4,421 Posts
Default

Quote:
I will just attempt to reorder the TABLE columns in the slave server and see if it will resolve the problem.
Please dont do that. The field order does not matter in a mysql database.
__________________
Till Brehm
--
Get ISPConfig support and the ISPConfig 3 manual from ispconfig.org.
Reply With Quote
  #14  
Old 22nd December 2011, 10:26
till till is online now
Super Moderator
 
Join Date: Apr 2005
Location: Lüneburg, Germany
Posts: 36,782
Thanks: 840
Thanked 5,610 Times in 4,421 Posts
Default

Quote:
Originally Posted by chume View Post
Thank you again Till for responding.

Below is the first line of the error log:
The error indicates that the slave server has not been updated to ispconfig 3.0.4 or 3.0.4.1 yet.
__________________
Till Brehm
--
Get ISPConfig support and the ISPConfig 3 manual from ispconfig.org.
Reply With Quote
  #15  
Old 22nd December 2011, 15:38
chume chume is offline
Member
 
Join Date: Sep 2010
Posts: 33
Thanks: 4
Thanked 1 Time in 1 Post
Default

Good morning Till:

Quote:
The multiserver setup guide instructed you to create new root user records that are only accessible from the slave, the above settings is for a global wirldcard root access and not the records from the ispconfig multiserver setup.
I did not recall creating a new root record during master server setup.
How can I create this new root record now?

Thank you.
Reply With Quote
  #16  
Old 22nd December 2011, 15:51
till till is online now
Super Moderator
 
Join Date: Apr 2005
Location: Lüneburg, Germany
Posts: 36,782
Thanks: 840
Thanked 5,610 Times in 4,421 Posts
Default

Plese see multiserver tutorials:

http://www.howtoforge.com/multiserve...th-ispconfig-3
__________________
Till Brehm
--
Get ISPConfig support and the ISPConfig 3 manual from ispconfig.org.
Reply With Quote
  #17  
Old 22nd December 2011, 16:30
chume chume is offline
Member
 
Join Date: Sep 2010
Posts: 33
Thanks: 4
Thanked 1 Time in 1 Post
Default

Thank you Till for all your efforts and contribution to this wonderful software.

I have a root user setup in the master server but I still get the error below:

Quote:
Unable to read server configuration from database.
What else can I do to resolve this issue.
Reply With Quote
  #18  
Old 22nd December 2011, 17:19
till till is online now
Super Moderator
 
Join Date: Apr 2005
Location: Lüneburg, Germany
Posts: 36,782
Thanks: 840
Thanked 5,610 Times in 4,421 Posts
Default

Is the root password for the local mysql server correct in the file /usr/local/ispconfig/server/lib/mysql_clientdb.conf on the slave?
__________________
Till Brehm
--
Get ISPConfig support and the ISPConfig 3 manual from ispconfig.org.
Reply With Quote
  #19  
Old 22nd December 2011, 17:36
chume chume is offline
Member
 
Join Date: Sep 2010
Posts: 33
Thanks: 4
Thanked 1 Time in 1 Post
Default

As always I thank you Till.

I decided to run /usr/local/ispconfig/server/server.sh command and got the error below:
Quote:
which: no tw_cli in (/usr/kerberos/sbin:/usr/kerberos/bin:/sbin:/usr/sbin:/bin:/usr/bin:/usr/local/sbin:/usr/local/bin:/usr/X11R6/bin)
/usr/bin/fail2ban-client
/sbin/iptables
iptables v1.3.5: Unknown arg `-S'
Try `iptables -h' or 'iptables --help' for more information.
/sbin/ip6tables
ip6tables v1.3.5: Unknown arg `-S'
Try `ip6tables -h' or 'ip6tables --help' for more information.
finished.
Reply With Quote
  #20  
Old 22nd December 2011, 17:39
till till is online now
Super Moderator
 
Join Date: Apr 2005
Location: Lüneburg, Germany
Posts: 36,782
Thanks: 840
Thanked 5,610 Times in 4,421 Posts
 
Default

Thats ok and not a problem. seems just as if the iptables command on your system does not support the -S switch. But thats uncritical.
__________________
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:
chume (22nd December 2011)
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
local ip:8080 just downloads a file called download or index.php dr_patso Installation/Configuration 5 20th September 2011 21:54
Debian 5 Ajax error + network interface always shutting down ev0css Installation/Configuration 3 5th June 2010 13:58
Problems with Postfix Mysql Courier PatrickAdrichem Installation/Configuration 3 13th April 2007 16:44
Email - Ueb-Miau mazhar Installation/Configuration 5 21st December 2005 11:01
The Perfect Setup Suse 9.3 - Postfix problems new_bee05 HOWTO-Related Questions 20 25th November 2005 03:30


All times are GMT +2. The time now is 17:41.


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