Project

General

Profile

Bug #275

Problems Migrating ISPConfig Master Node

Added by Daniel Curtis over 10 years ago. Updated about 9 years ago.

Status:
Closed
Priority:
Normal
Assignee:
Category:
Automated Server Management
Target version:
-
Start date:
12/26/2013
Due date:
% Done:

100%

Estimated time:
0.50 h
Spent time:

Description

I encountered a problem after moving the ISPConfig master database to the new administration server. I tried to make a change to one of the websites managed by ISPConfig, however I noticed that the operation did not complete and was shown in the Monitor -> Jon Queue as not being completed either. I remember that I had not updated that ISPConfig nodes to the new master server. So I logged into one of the nodes as root and ran:

/usr/local/ispconfig/server/scripts/update_from_tgz.sh

This downloaded that lastest stable version of ISPConfig and began an update process:
  • Shall the script create a ISPConfig backup in /var/backup/ now? (yes,no) [yes]: [Enter]
  • MySQL master server hostname [oldmaster.example.com]: newmaster.example.com_[Enter]_
  • MySQL master server root username [root]: [Enter]
  • MySQL master server root password []: SuperSecretPassword_[Enter]_
  • MySQL master server database name [dbispconfig]: [Enter]
  • Reconfigure Permissions in master database? (yes,no) [no]: yes_[Enter]_
  • Reconfigure Services? (yes,no) [yes]: [Enter]
  • ISPConfig Port [8080]: [Enter]
  • Create new ISPConfig SSL certificate (yes,no) [no]: [Enter]
  • Reconfigure Crontab? (yes,no) [yes]: [Enter]

When I went to reconfigure the permissions in the master permissions I got a permission denied for the user provided. I had figured I set the wrong permissions on the master database, so I logged into the administration server and logged into the MySQL server as root:

mysql -u root -p

Once in the MySQL console, I revoked the previous permissions and set the correct permissions:

REVOKE ALL PRIVILEGES ON `dbispconfig`.* FROM 'root'@'web.example.com';
GRANT ALL PRIVILEGES ON `dbispconfig`.* TO 'root'@'web.example.com' WITH GRANT OPTION;

Once the correct permissions were set, I ran the update script on the ISPConfig client node just like before:

/usr/local/ispconfig/server/scripts/update_from_tgz.sh

This time, when I went to reconfigure permission in the master database the update finished correctly.

#1

Updated by Daniel Curtis about 9 years ago

  • Project changed from 57 to GNU/Linux Administration
  • Subject changed from Problems Migrating ISPConfig Master Node to Administration Server to Problems Migrating ISPConfig Master Node
  • Category set to Automated Server Management

Also available in: Atom PDF