• Hi, Pleskians! We are running a UX testing of our upcoming product intended for server management and monitoring.
    We would like to invite you to have a call with us and have some fun checking our prototype. The agenda is pretty simple - we bring new design and some scenarios that you need to walk through and succeed. We will be watching and taking insights for further development of the design.
    If you would like to participate, please use this link to book a meeting. We will sent the link to the clickable prototype at the meeting.
  • (Plesk for Windows):
    MySQL Connector/ODBC 3.51, 5.1, and 5.3 are no longer shipped with Plesk because they have reached end of life. MariaDB Connector/ODBC 64-bit 3.2.4 is now used instead.
  • The Horde webmail has been deprecated. Its complete removal is scheduled for April 2025. For details and recommended actions, see the Feature and Deprecation Plan.

Question Update specific nameserver for all domains

Hangover2

Regular Pleskian
Server operating system version
Debian 11
Plesk version and microupdate number
18.0.61 #6
Hello,

we want to update one nameserver entry for all domains hosted on a Plesk server (it's a slave NS entry).

The zone records template will be updated accordingly for new domains created, but we do not want to apply it for all existing domains because some zones were manually changed and we are afraid, that maybe other entries get lost or overridden when enforcing a full sync.

What is the best way to exchange one old nameserver entry with a new on in the DNS for all existing domains?

Our plan was to execute the following command directly in the database:

SQL:
UPDATE `dns_recs` SET `val` = "my-new.nameserver.com", `displayVal` = "my-new.nameserver.com" WHERE `type` = "NS" AND `val` = "my-old.nameserver.com";

After this we would call /usr/local/psa/admin/sbin/dnsmng --update domain-with-new-nameserver.com for all affected domains.

Is there a faster or better way to handle this use case or did we miss sth.? Thanks in advance for any answer.
 
I am always a bit hesitant to make any modification directly in the PSA database. Personally I'd probably use the REST API, which probably isn't faster than running a SQL query. But I assume you run a script to handle to updates for you anyway?
 
Back
Top