ERROR 1265 (01000): Data truncated for column 'dnssec_wanted' at row 1

Discussion in 'General' started by maumar, Jan 3, 2021.

  1. maumar

    maumar Member HowtoForge Supporter

    When I try to insert a new zone using a template, I get always this error.
    I get the insert grabbing it by mysql.log e trying tio exec it into mysql:

    INSERT INTO `dns_soa` (`sys_userid`,`sys_groupid`,`sys_perm_user`,`sys_perm_group`,`sys_perm_other`,`server_id`,`origin`,`ns`,`mbox`,`serial`,`refresh`,`retry`,`expire`,`minimum`,`ttl`,`active`,`xfer`,`also_notify
    `,`update_acl`,`dnssec_wanted`,`dnssec_algo`) VALUES ('1',2,'riud','riud','',1,'acb.it.','ns1.onlinesolutions.it.','dns.onlinesolutions.it.','2021010301','86400','7200','3600000','172800','86400','Y','',NULL,NULL,'','ECDSAP256SHA256');
    ERROR 1265 (01000): Data truncated for column 'dnssec_wanted' at row 1

    What is wrong with template?
    this is a syslog line output I inserted in your source at line 340 circa

    Jan 3 09:34:19 cp02 /var/www/ispconfig/dns/dns_wizard.php[3612]: Line: 341tpl_content : [ZONE]\x0d
    Jan 3 09:34:19 cp02 /var/www/ispconfig/dns/dns_wizard.php[3612]: origin=acb.it.\x0d
    Jan 3 09:34:19 cp02 /var/www/ispconfig/dns/dns_wizard.php[3612]: ns=ns1.onlinesolutions.it.\x0d
    Jan 3 09:34:19 cp02 /var/www/ispconfig/dns/dns_wizard.php[3612]: mbox=dns.onlinesolutions.it.\x0d
    Jan 3 09:34:19 cp02 /var/www/ispconfig/dns/dns_wizard.php[3612]: refresh=86400\x0d
    Jan 3 09:34:19 cp02 /var/www/ispconfig/dns/dns_wizard.php[3612]: retry=7200\x0d
    Jan 3 09:34:19 cp02 /var/www/ispconfig/dns/dns_wizard.php[3612]: expire=3600000\x0d
    Jan 3 09:34:19 cp02 /var/www/ispconfig/dns/dns_wizard.php[3612]: minimum=172800\x0d
    Jan 3 09:34:19 cp02 /var/www/ispconfig/dns/dns_wizard.php[3612]: ttl=86400\x0d
    Jan 3 09:34:19 cp02 /var/www/ispconfig/dns/dns_wizard.php[3612]: \x0d
    Jan 3 09:34:19 cp02 /var/www/ispconfig/dns/dns_wizard.php[3612]: [DNS_RECORDS]\x0d
    Jan 3 09:34:19 cp02 /var/www/ispconfig/dns/dns_wizard.php[3612]: A|acb.it.|88.198.112.29|0|3600\x0d
    Jan 3 09:34:19 cp02 /var/www/ispconfig/dns/dns_wizard.php[3612]: A|www|88.198.112.29|0|3600\x0d
    Jan 3 09:34:19 cp02 /var/www/ispconfig/dns/dns_wizard.php[3612]: A|mail|88.198.112.29|0|3600\x0d
    Jan 3 09:34:19 cp02 /var/www/ispconfig/dns/dns_wizard.php[3612]: A|webmail|88.198.112.29|0|3600\x0d
    Jan 3 09:34:19 cp02 /var/www/ispconfig/dns/dns_wizard.php[3612]: A|smtp|88.198.112.29|0|3600\x0d
    Jan 3 09:34:19 cp02 /var/www/ispconfig/dns/dns_wizard.php[3612]: A|ftp|88.198.112.29|0|86400\x0d
    Jan 3 09:34:19 cp02 /var/www/ispconfig/dns/dns_wizard.php[3612]: NS|acb.it.|ns1.onlinesolutions.it.|0|3600\x0d
    Jan 3 09:34:19 cp02 /var/www/ispconfig/dns/dns_wizard.php[3612]: NS|acb.it.|ns2.onlinesolutions.it.|0|3600\x0d
    Jan 3 09:34:19 cp02 /var/www/ispconfig/dns/dns_wizard.php[3612]: MX|acb.it.|mail.acb.it.|20|3600

    many thnx
    Maurizio
     
  2. Th0m

    Th0m ISPConfig Developer Staff Member ISPConfig Developer

    Add
    Code:
    dnssec_wanted=n
    to your template under the [ZONE] lines. It will be fixed in 3.2.2.
     

Share This Page