Debian 12 ISP - 3.2.11.p1 Hi. I had an internet outage - 5 weeks later new ISP installed new internet. My setup was using a IP range 212.159.153.*, now i have an IP range 88.97.88.* (16 IPS) I have updated on all nodes: Code: /etc/hosts /etc/network/interfaces ufw allow from 88.97.88.*/28 to any port 3306 proto tcp (still need to delete old ufw allow) ufw allow from 88.97.88.*/28 to any port 12345 proto tcp in ISPCONFIG panel, update the IP -> system -> server IP address (update the lot) have edited panel IP, phpmyadmin searching for hostname and updating the IP setting new IP in: Code: dbispconfig -> dns_rr change data from old IP to new IP I have also updated the user accounts as well, from 212.159.153.* to 88.97.88.* I went to tools -> resync and ticked all services it still shows 5468 pending changes and nothing has altered.. do i have to update the mysql also on each machine, what am i missing? thanks dave
You mean the ispcsrv* MySQL users in the master database? If yes, did you use the phpmyadmin user editor? Because the see users are quite complex and their records are spread trough different tables, so just editing mysl.user table does not work here.
Hey till I logged into phpmyadmin, top row shows Server: localhost, then i went to User Accounts and edited the IP entry's "ispcsrv11'@'212.159.153.*', went to Login information and changed "host name", at the bottom i selected last option "delete the old one from the user tables and reload the privileges after" correct procedure so far? or better, what is the correct full procedure for changing the IP of a server or multiserver? thanks dave
Its been a few days and i still have 130 left to process. Code: datalog_status_u_client: 114 datalog_status_u_spamfilter_policy: 14 Update website settings: 2 how and where do i find what is to process and to what server is having this issue? dave
Follow instructions from https://forum.howtoforge.com/threads/please-read-before-posting.58408/ Read all of it. The part about "not writing changes to disk" is important to your case.
