[Pdns-users] Storing binary data in PDNS

Christian Rößner c at roessner-network-solutions.com
Fri Mar 27 20:18:11 UTC 2015


Hello,

this is my first post to this list. I tried to find an answer by searching all over in Google and Yahoo, but I could not find a solution for my problem.

I am running PDNS auth-server 3.4.2 on Gentoo Linux with a MariaDB SQL backend (drop-in replacement for MySQL). That works very well for nearly thousand domains.

I have several DNSSEC enabled domains and I want to insert a records like this:

MariaDB [pdns]> insert into records (domain_id, name, type, content, ttl) values (21603, "1053463d383dc1e87f06fff34b3c6a2d340d91e184d46d70144ffa5a._encr._smimecert.roessner.co", "TYPE65514“, "\\# 1303 010000003082050F308203F7A003020102021069CCB1DF3BD4256F7F869BBBB9100BC4300D06092A864886F70D01010B0500308197310B3009060355040613024742311B30190603550408131247726561746572204D616E636865737465723110300E0603550407130753616C666F7264311A3018060355040A1311434F4D4F444F204341204C696D69746564313D303B06035504031334434F4D4F444F2052534120436C69656E742041757468656E7469636174696F6E20616E642053656375726520456D61696C204341301E170D3134313231303030303030305A170D3135313231303233353935395A301E311C301A06092A864886F70D010901160D6340726F6573736E65722E636F30820122300D06092A864886F70D01010105000382010F003082010A0282010100BAE3DAF1760CE1073CCC742FA4E91422CCFD4C3CCB40EE98FFDE1F012E7357E8EEF4D119056F5ACEA799C8F4D4211AC1A27A580CE8C092F88A6456A48DB234DFC31C5C07B760BE20110006ADE9FD173AACA244DCC616468286C963BBF7CB7A28A073DBA05AB71D9711ECFA36C2696C2B8BC248608DF580161C82B579E5513918245AA17F3D6798E75828E8C1EBF0E0482B048925E451FD515524BD60234519ED3F341451FA206AB75B55B3386951E81B8021912E3439B8CA33BBCE34003DE79C3CB47F8276B682849F1AB9EB61A7BCAECC49A1000C58672C42CAD2622C4503185B56ACEF2E61777C326C918D3284D15C73C893AB0A2ED93A2BE6CD578FCC4A530203010001A38201CD308201C9301F0603551D2304183016801482AF6C8CF8C5FE96617CE81F3D2B71485EC48BC0301D0603551D0E04160414AA5D6DE47CD6A999E2EDC4FBA22AE542A437528D300E0603551D0F0101FF0404030205A0300C0603551D130101FF04023000301D0603551D250416301406082B0601050507030406082B0601050507030230460603551D20043F303D303B060C2B06010401B2310102010305302B302906082B06010505070201161D68747470733A2F2F7365637572652E636F6D6F646F2E6E65742F435053305A0603551D1F04533051304FA04DA04B8649687474703A2F2F63726C2E636F6D6F646F63612E636F6D2F434F4D4F444F525341436C69656E7441757468656E7469636174696F6E616E64536563757265456D61696C43412E63726C30818B06082B06010505070101047F307D305506082B060105050730028649687474703A2F2F6372742E636F6D6F646F63612E636F6D2F434F4D4F444F525341436C69656E7441757468656E7469636174696F6E616E64536563757265456D61696C43412E637274302406082B060105050730018618687474703A2F2F6F6373702E636F6D6F646F63612E636F6D30180603551D110411300F810D6340726F6573736E65722E636F300D06092A864886F70D01010B0500038201010055E6C263771F1893AFFEF0BC3C20269402ED300DA5C6961507AA1A04565E2187D814D0ED3422A9B1E2F3B85AFFB37BB3671805093A612AD268343D3F9B585A3E54F9428B2B4670AE991A04A68BAB30C8EB230E72A39B92702E6A16C564BF46E88827CEB1C202AE408D75A9987696B8144D3ACA1E5C44AE0CC8888DFB7D1CDCFF7F494848801C1095B8D6C39B6ADA143C39E600EE2805A59FFB7027362A764405FDEEDEB25026F7DE79A2D1D68C8CC60DA8ECCA3F3549D304774E0AC6C5D20BC1D245D79BA590FE7F2BC4918447C88766B3AE09726EE317C4F2CA639BCD4F13992DEEA2009B0405B575E234B78523387B7CF011F55D335E750286D83E30C2A0DB", 3600);

After doing so, I enter : pdnssec rectify-zone roessner.co
Followed by : pdnssec check-zone roessner.co

Which leads to a warning:

[Warning] Parsed and original record content are not equal: 1053463d383dc1e87f06fff34b3c6a2d340d91e184d46d70144ffa5a._encr._smimecert.roessner.co IN TYPE65514 '\# 1303 010000003082050F308203F7A003020102021069CCB1DF3BD4256F7F869BBBB9100BC4300D06092A864886F70D01010B0500308197310B3009060355040613024742311B30190603550408131247726561746572204D616E636865737465723110300E0603550407130753616C666F7264311A3018060355040A1311434F4D4F444F204341204C696D69746564313D303B06035504031334434F4D4F444F2052534120436C69656E742041757468656E7469636174696F6E20616E642053656375726520456D61696C204341301E170D3134313231303030303030305A170D3135313231303233353935395A301E311C301A06092A864886F70D010901160D6340726F6573736E65722E636F30820122300D06092A864886F70D01010105000382010F003082010A0282010100BAE3DAF1760CE1073CCC742FA4E91422CCFD4C3CCB40EE98FFDE1F012E7357E8EEF4D119056F5ACEA799C8F4D4211AC1A27A580CE8C092F88A6456A48DB234DFC31C5C07B760BE20110006ADE9FD173AACA244DCC616468286C963BBF7CB7A28A073DBA05AB71D9711ECFA36C2696C2B8BC248608DF580161C82B579E5513918245AA17F3D6798E75828E8C1EBF0E0482B048925E451FD515524BD60234519ED3F341451FA206AB75B55B3386951E81B8021912E3439B8CA33BBCE34003DE79C3CB47F8276B682849F1AB9EB61A7BCAECC49A1000C58672C42CAD2622C4503185B56ACEF2E61777C326C918D3284D15C73C893AB0A2ED93A2BE6CD578FCC4A530203010001A38201CD308201C9301F0603551D2304183016801482AF6C8CF8C5FE96617CE81F3D2B71485EC48BC0301D0603551D0E04160414AA5D6DE47CD6A999E2EDC4FBA22AE542A437528D300E0603551D0F0101FF0404030205A0300C0603551D130101FF04023000301D0603551D250416301406082B0601050507030406082B0601050507030230460603551D20043F303D303B060C2B06010401B2310102010305302B302906082B06010505070201161D68747470733A2F2F7365637572652E636F6D6F646F2E6E65742F435053305A0603551D1F04533051304FA04DA04B8649687474703A2F2F63726C2E636F6D6F646F63612E636F6D2F434F4D4F444F525341436C69656E7441757468656E7469636174696F6E616E64536563757265456D61696C43412E63726C30818B06082B06010505070101047F307D305506082B060105050730028649687474703A2F2F6372742E636F6D6F646F63612E636F6D2F434F4D4F444F525341436C69656E7441757468656E7469636174696F6E616E64536563757265456D61696C43412E637274302406082B060105050730018618687474703A2F2F6F6373702E636F6D6F646F63612E636F6D30180603551D110411300F810D6340726F6573736E65722E636F300D06092A864886F70D01010B0500038201010055E6C263771F1893AFFEF0BC3C20269402ED300DA5C6961507AA1A04565E2187D814D0ED3422A9B1E2F3B85AFFB37BB3671805093A612AD268343D3F9B585A3E54F9428B2B4670AE991A04A68BAB30C8EB230E72A39B92702E6A16C564BF46E88827CEB1C202AE408D75A9987696B8144D3ACA1E5C44AE0CC8888DFB7D1CDCFF7F494848801C1095B8D6C39B6ADA143C39E600EE2805A59FFB7027362A764405FDEEDEB25026F7DE79A2D1D68C8CC60DA8ECCA3F3549D304774E0AC6C5D20BC1D245D79BA590FE7F2BC4918447C88766B3AE09726EE317C4F2CA639BCD4F13992DEEA2009B0405B575E234B78523387B7CF011F55D335E750286D83E30C2A0DB' (Content parsed as '\# 2614 5c232031333033203031303030303030333038323035304633303832303346374130303330323031303230323130363943434231444633424434323536463746383639424242423931303042433433303044303630393241383634383836463730443031303130423035303033303831393733313042333030393036303335353034303631333032343734323331314233303139303630333535303430383133313234373732363536313734363537323230344436313645363336383635373337343635373233313130333030453036303335353034303731333037353336313643363636463732363433313141333031383036303335353034304131333131343334463444344634343446323034333431323034433639364436393734363536343331334433303342303630333535303430333133333434333446344434463434344632303532353334313230343336433639363536453734323034313735373436383635364537343639363336313734363936463645323036313645363432303533363536333735373236353230343536443631363936433230343334313330314531373044333133343331333233313330333033303330333033303330354131373044333133353331333233313330333233333335333933353339354133303145333131433330314130363039324138363438383646373044303130393031313630443633343037323646363537333733364536353732324536333646333038323031323233303044303630393241383634383836463730443031303130313035303030333832303130463030333038323031304130323832303130313030424145334441463137363043453130373343434337343246413445393134323243434644344333434342343045453938464644453146303132453733353745384545463444313139303536463541434541373939433846344434323131414331413237413538304345384330393246383841363435364134384442323334444643333143354330374237363042453230313130303036414445394644313733414143413234344443433631363436383238364339363342424637434237413238413037334442413035414237314439373131454346413336433236393643324238424332343836303844463538303136314338324235373945353531333931383234354141313746334436373938453735383238453843314542463045303438324230343839323545343531464435313535323442443630323334353139454433463334313435314641323036414237354235354233333836393531453831423830323139313245333433394238434133334242434533343030334445373943334342343746383237364236383238343946314142394542363141374243414543433439413130303043353836373243343243414432363232433435303331383542353641434546324536313737374333323643393138443332383444313543373343383933414230413245443933413242453643443537384643433441353330323033303130303031413338323031434433303832303143393330314630363033353531443233303431383330313638303134383241463643384346384335464539363631374345383146334432423731343835454334384243303330314430363033353531443045303431363034313441413544364445343743443641393939453245444334464241323241453534324134333735323844333030453036303335353144304630313031464630343034303330323035413033303043303630333535314431333031303146463034303233303030333031443036303335353144323530343136333031343036303832423036303130353035303730333034303630383242303630313035303530373033303233303436303630333535314432303034334633303344333033423036304332423036303130343031423233313031303230313033303533303242333032393036303832423036303130353035303730323031313631443638373437343730373333413246324637333635363337353732363532453633364636443646363436463245364536353734324634333530353333303541303630333535314431463034353333303531333034464130344441303442383634393638373437343730334132463246363337323643324536333646364436463634364636333631324536333646364432463433344634443446343434463532353334313433364336393635364537343431373537343638363536453734363936333631373436393646364536313645363435333635363337353732363534353644363136393643343334313245363337323643333038313842303630383242303630313035303530373031303130343746333037443330353530363038324230363031303530353037333030323836343936383734373437303341324632463633373237343245363336463644364636343646363336313245363336463644324634333446344434463434344635323533343134333643363936353645373434313735373436383635364537343639363336313734363936463645363136453634353336353633373537323635343536443631363936433433343132453633373237343330323430363038324230363031303530353037333030313836313836383734373437303341324632463646363337333730324536333646364436463634364636333631324536333646364433303138303630333535314431313034313133303046383130443633343037323646363537333733364536353732324536333646333030443036303932413836343838364637304430313031304230353030303338323031303130303535453643323633373731463138393341464645463042433343323032363934303245443330304441354336393631353037414131413034353635453231383744383134443045443334323241394231453246334238354146464233374242333637313830353039334136313241443236383334334433463942353835413345353446393432384232423436373041453939314130344136384241423330433845423233304537324133394239323730324536413136433536344246343645383838323743454231433230324145343038443735413939383736393642383134344433414341314535433434414530434338383838444642374431434443464637463439343834383830314331303935423844364333394236414441313433433339453630304545323830354135394646423730323733363241373634343035464445454445423235303236463744453739413244314436384338434336304441384543434133463335343944333034373734453041433643354432304243314432343544373942413539304645374632424334393138343437433838373636423341453039373236454533313743344632434136333942434434463133393932444545413230303942303430354235373545323334423738353233333837423743463031314635354433333545373530323836443833453330433241304442')
Checked 12 records of 'roessner.co', 0 errors, 1 warnings.

I have absolutely no idea how to get this inserted correctly.

Does somebody have any idea how to achieve this? Is adding a TYPE65XYZ-RR possible? What is the exact syntax?

Many thanks in advance

Christian
--
Bachelor of Science Informatik
Erlenwiese 14, 36304 Alsfeld
T: +49 6631 78823400, F: +49 6631 78823409, M: +49 171 9905345
USt-IdNr.: DE225643613, http://www.roessner-network-solutions.com

--
Bachelor of Science Informatik
Erlenwiese 14, 36304 Alsfeld
T: +49 6631 78823400, F: +49 6631 78823409, M: +49 171 9905345
USt-IdNr.: DE225643613, http://www.roessner-network-solutions.com





More information about the Pdns-users mailing list