#1  
Old 8th July 2013, 11:12
keshwarsingh keshwarsingh is offline
Member
 
Join Date: Apr 2013
Posts: 31
Thanks: 2
Thanked 1 Time in 1 Post
Exclamation 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="
"MIIBIjANBgkqhkiG9w0BAQEFAAOCAQ8AMIIBCgKCAQEArwObL 2j6vB2W+BgQIqwP"
"dh10Ftcx1b57dPzMx1r1ZefMy5LRYYodryYf6BRBmvgKGn5ps nnYCTId8GPsRNMy"
"IAMykmg/sNSMP08Uk5f1ypciDPqRNkN92Xa3iO2ET7iB/fZJlSzcBJhdpz7+aAUv"
"MM6WanPqfffJCx488hRi7SoSxhkVB7azPTLY/r1BK/3+fUZXmn765fwvFijz3WgA"
"0P6hY/RpTPZyl/u7p3yDIBtZot5gv0yMOq4+lI6RLwodqNWk0Nqv122WfK27cv/U"
"bm81S4opS0xrcDW87KPwPWy1RwWR3HaeNjMTrAo8l5fRmSDf1 2VJ22GfQ2Quc3Vx"
"rwIDAQAB")

root@alpha:~#

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

v=DKIM1; p=MIIBIjANBgkqhkiG9w0BAQEFAAOCAQ8AMIIBCgKCAQEArwOb L2j6vB2W+BgQIqwPdh10Ftcx1b57dPzMx1r1ZefMy5LRYYodry Yf6BRBmvgKGn5psnnYCTId8GPsRNMyIAMykmg/sNSMP08Uk5f1ypciDPqRNkN92Xa3iO2ET7iB/fZJlSzcBJhdpz7+aAUvMM6WanPqfffJCx488hRi7SoSxhkVB7a zPTLY/r1BK/3+fUZXmn76
Sponsored Links
  #2  
Old 8th July 2013, 11:43
till till is offline
Super Moderator
 
Join Date: Apr 2005
Location: Lüneburg, Germany
Posts: 35,975
Thanks: 825
Thanked 5,368 Times in 4,215 Posts
Default

The max length for TXT records is 255 chars at the moment as the data column of the dns_rr table is varchar 255. If you change that to e.g. type text in mysql on master and dns slave servers, you should be able to enter up to 64k char length.
__________________
Till Brehm
--
Get ISPConfig support and the ISPConfig 3 manual from ispconfig.org.
  #3  
Old 8th July 2013, 17:46
keshwarsingh keshwarsingh is offline
Member
 
Join Date: Apr 2013
Posts: 31
Thanks: 2
Thanked 1 Time in 1 Post
Default

Quote:
Originally Posted by till View Post
The max length for TXT records is 255 chars at the moment as the data column of the dns_rr table is varchar 255. If you change that to e.g. type text in mysql on master and dns slave servers, you should be able to enter up to 64k char length.
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
  #4  
Old 8th July 2013, 17:50
till till is offline
Super Moderator
 
Join Date: Apr 2005
Location: Lüneburg, Germany
Posts: 35,975
Thanks: 825
Thanked 5,368 Times in 4,215 Posts
Default

Then you will have to remove the index on that table.
__________________
Till Brehm
--
Get ISPConfig support and the ISPConfig 3 manual from ispconfig.org.
  #5  
Old 8th July 2013, 17:54
keshwarsingh keshwarsingh is offline
Member
 
Join Date: Apr 2013
Posts: 31
Thanks: 2
Thanked 1 Time in 1 Post
Default

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

Last edited by keshwarsingh; 8th July 2013 at 18:08.
  #6  
Old 8th July 2013, 18:48
till till is offline
Super Moderator
 
Join Date: Apr 2005
Location: Lüneburg, Germany
Posts: 35,975
Thanks: 825
Thanked 5,368 Times in 4,215 Posts
Default

Remove the ones that contain the data column:

dns_rr 0 rr 4 data A NULL NULL NULL BTREE
dns_rr 1 data 1 data A NULL NULL NULL BTREE
__________________
Till Brehm
--
Get ISPConfig support and the ISPConfig 3 manual from ispconfig.org.
  #7  
Old 8th July 2013, 18:56
keshwarsingh keshwarsingh is offline
Member
 
Join Date: Apr 2013
Posts: 31
Thanks: 2
Thanked 1 Time in 1 Post
Default

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 ?
  #8  
Old 8th July 2013, 19:05
till till is offline
Super Moderator
 
Join Date: Apr 2005
Location: Lüneburg, Germany
Posts: 35,975
Thanks: 825
Thanked 5,368 Times in 4,215 Posts
Default

Most likely he developed the plugin for svn and not stable version and now his plugins uses internal functions that are not present in ISPConfig stable yet.
__________________
Till Brehm
--
Get ISPConfig support and the ISPConfig 3 manual from ispconfig.org.
  #9  
Old 11th July 2013, 17:43
keshwarsingh keshwarsingh is offline
Member
 
Join Date: Apr 2013
Posts: 31
Thanks: 2
Thanked 1 Time in 1 Post
 
Default

Everything working fine now!

Can we close this thread.
Closed Thread

Bookmarks

Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off

Forum Jump

Similar Threads
Thread Thread Starter Forum Replies Last Post
Postfix delivery problem erebus Installation/Configuration 8 29th July 2014 20:17
E-mail server receive and send spams Mole Installation/Configuration 12 19th April 2010 11:03
Squid Proxy Caching on Linux obzerver Installation/Configuration 4 13th August 2008 19:51
Google Apps dayjahone General 19 29th March 2008 17:25
Unable send receive emails vassilis3 Installation/Configuration 15 19th May 2007 14:34


All times are GMT +2. The time now is 15:37.


Powered by vBulletin® Version 3.8.7
Copyright ©2000 - 2014, vBulletin Solutions, Inc.