DNS "TXT" record limitation

Hello,

I currently have a pool of 42 servers joined to a multi server setup. Everything works perfectly except when i try to add a TXT record. For e.g, i want to add a TXT record for dkim.

root@alpha:~# amavisd-new showkeys
; key#1, domain connect.testdomain.com, /var/dkim/master.key.pem
dkim._domainkey.connect.testdomain.com. 3600 TXT (
"v=DKIM1; p="
"MIIBIjANBgkqhkiG9w0BAQEFAAOCAQ8AMIIBCgKCAQEArwObL2j6vB2W+BgQIqwP"
"dh10Ftcx1b57dPzMx1r1ZefMy5LRYYodryYf6BRBmvgKGn5psnnYCTId8GPsRNMy"
"IAMykmg/sNSMP08Uk5f1ypciDPqRNkN92Xa3iO2ET7iB/fZJlSzcBJhdpz7+aAUv"
"MM6WanPqfffJCx488hRi7SoSxhkVB7azPTLY/r1BK/3+fUZXmn765fwvFijz3WgA"
"0P6hY/RpTPZyl/u7p3yDIBtZot5gv0yMOq4+lI6RLwodqNWk0Nqv122WfK27cv/U"
"bm81S4opS0xrcDW87KPwPWy1RwWR3HaeNjMTrAo8l5fRmSDf12VJ22GfQ2Quc3Vx"
"rwIDAQAB")

root@alpha:~#

The interface would accept only the following for a TXT record as maximum character, maybe a limitation...

v=DKIM1; p=MIIBIjANBgkqhkiG9w0BAQEFAAOCAQ8AMIIBCgKCAQEArwObL2j6vB2W+BgQIqwPdh10Ftcx1b57dPzMx1r1ZefMy5LRYYodryYf6BRBmvgKGn5psnnYCTId8GPsRNMyIAMykmg/sNSMP08Uk5f1ypciDPqRNkN92Xa3iO2ET7iB/fZJlSzcBJhdpz7+aAUvMM6WanPqfffJCx488hRi7SoSxhkVB7azPTLY/r1BK/3+fUZXmn76

 

Error

SQL query:

ALTER TABLE `dns_rr` CHANGE `data` `data` TEXT CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL

MySQL said: Documentation
#1170 - BLOB/TEXT column 'data' used in key specification without a key length

 

SHOW INDEX FROM dns_rr;

dns_rr 0 PRIMARY 1 id A 21 NULL NULL BTREE
dns_rr 0 rr 1 zone A NULL NULL NULL BTREE
dns_rr 0 rr 2 name A NULL NULL NULL BTREE
dns_rr 0 rr 3 type A NULL NULL NULL YES BTREE
dns_rr 0 rr 4 data A NULL NULL NULL BTREE
dns_rr 1 data 1 data A NULL NULL NULL BTREE

 

All right, I'll do that.

On a side note, I've just tried the following:

http://blog.schaal-24.de/?p=2223&lang=en

But it's spitting an error..



Do you have an idea what might be causing this ?

 

Everything working fine now!

Can we close this thread.