dns_rr table´s timestamp row does not get updated on row update via SOAP API

Discussion in 'Installation/Configuration' started by stonegate, Dec 9, 2021.

  1. stonegate

    stonegate New Member

    Hello there,

    i hope someone can help with that very specific problem.

    I am using ISPConfig3´s DNS System with the SOAP Api.
    When updating the dns_rr -> data row via the linux mysql client or phpmyadmin, the row "timestamp" gets a new current timestamp. This is perfectly fine and correct.

    However, when i update the dns_rr -> data row via the ISPConfig3 SOAP Api, the data row gets written with the new value (IP Adress) but the timestamp is not concerned at all. It should be written on each SQL update. So i wonder what ISPConfig 3 is doing and why the timestamp is not updated anymore. It worked a while ago but i think it broke one day.

    Here is a screenshot of the tables structure:

    upload_2021-12-9_17-55-58.png

    The structure settings for "stamp" are correct.

    Here is a screenshot from the timestamps.. they havent been updated for years :-o (i unfortunately just noticed)...

    upload_2021-12-9_18-0-26.png

    In the file /usr/local/ispconfig/interface/web/dns/dns_edit_base.php i found:

    This looks very correct to me. However for some reason the timestamp isnt written. As mentioned above, when i update the row with phpmyadmin or mysql it updates the timestamp perfectly. So i am a bit out of ideas why its not working, but its crucial for me to see when a dns_rr data record has been changed for the last time.

    I am very happy if someone has an idea :) Thank you in advance and have a nice christmastime :)

    Stoney
     

Share This Page