On Mon, Mar 01, 2010 at 03:29:50PM +0000, Chris Sarginson wrote: > Hi guys, > > I'm trying to use the authoratitive server with a MySQL backend to do > multipart TXT records - on the advice of someone in IRC I just tried > inserting multiple records, however doing this is resulting in the record > being displayed as 2 seperate records: > > dig @81.201.128.133 app-2._domainkey.test.sargy.co.uk TXT
Chris, try inserting the content in the database as one record, with content between quotes. I think it will split automatically. If it does not, split the data yourself. So, to store your record, try: update records where name='app-2._domainkey.test.sargy.co.uk' and type='txt' set content='"t=y\; k=rsa\; p=MIIBIjANBgkqhkiG9w0BAQEFAAOCAQ8AMIIBCgKCAQEAo0DJzHgxkky69xI95gYIfbSa5gFHYCrUVbleLcbCmTqf55Flw6tQtXBM2D+k2T7MQRuAztj3cSvjXPB/nj4OWLiPFVYmvIc3cUVmuNaKo8Iiq1UY5Wp0TXnhhhMQHqeBZCrQZwoMMo4LI8ZgGnnTieUymPqlzy1I3kVEo/T0w01wC4AwQwoIPYMv3IQ5pOhhnFede" "mP145OQVx9h+cICLfLX3kCBCrnLZKYYFsgE2xKDuNImvHjPCok0/EV1euF3ZZBj3Tl3n7f9BUhaAKFlrWdzfrizEp3doDusWZ8yRb+Bcb7ug21WRELyFR7LmXp7CGFVCEjtoXLNHQ8kQXTygQIDAQAB\;"' You may have to remove the \ before ;. Also make sure your content field has enough capacity to store all this data. I did not test the sql above, but this is the idea. Good luck! > > app-2._domainkey.test.sargy.co.uk. 86400 IN TXT "t=y\; k=rsa\; > p=MIIBIjANBgkqhkiG9w0BAQEFAAOCAQ8AMIIBCgKCAQEAo0DJzHgxkky69xI95gYIfbSa5gFHYCrUVbleLcbCmTqf55Flw6tQtXBM2D+k2T7MQRuAztj3cSvjXPB/nj4OWLiPFVYmvIc3cUVmuNaKo8Iiq1UY5Wp0TXnhhhMQHqeBZCrQZwoMMo4LI8ZgGnnTieUymPqlzy1I3kVEo/T0w01wC4AwQwoIPYMv3IQ5pOhhnFede" > app-2._domainkey.test.sargy.co.uk. 86400 IN TXT > "mP145OQVx9h+cICLfLX3kCBCrnLZKYYFsgE2xKDuNImvHjPCok0/EV1euF3ZZBj3Tl3n7f9BUhaAKFlrWdzfrizEp3doDusWZ8yRb+Bcb7ug21WRELyFR7LmXp7CGFVCEjtoXLNHQ8kQXTygQIDAQAB\;" > > When selecting in MySQL: > > mysql> select * from records where name="app-2._domainkey.test.sargy.co.uk"\G > *************************** 1. row *************************** > id: 448463 > domain_id: 15724 > name: app-2._domainkey.test.sargy.co.uk > type: TXT > content: t=y; k=rsa; > p=MIIBIjANBgkqhkiG9w0BAQEFAAOCAQ8AMIIBCgKCAQEAo0DJzHgxkky69xI95gYIfbSa5gFHYCrUVbleLcbCmTqf55Flw6tQtXBM2D+k2T7MQRuAztj3cSvjXPB/nj4OWLiPFVYmvIc3cUVmuNaKo8Iiq1UY5Wp0TXnhhhMQHqeBZCrQZwoMMo4LI8ZgGnnTieUymPqlzy1I3kVEo/T0w01wC4AwQwoIPYMv3IQ5pOhhnFede > ttl: 86400 > prio: 0 > change_date: 1267456927 > *************************** 2. row *************************** > id: 448472 > domain_id: 15724 > name: app-2._domainkey.test.sargy.co.uk > type: TXT > content: > mP145OQVx9h+cICLfLX3kCBCrnLZKYYFsgE2xKDuNImvHjPCok0/EV1euF3ZZBj3Tl3n7f9BUhaAKFlrWdzfrizEp3doDusWZ8yRb+Bcb7ug21WRELyFR7LmXp7CGFVCEjtoXLNHQ8kQXTygQIDAQAB; > ttl: 86400 > prio: 0 > change_date: 1267456927 > 2 rows in set (0.00 sec) > > Can someone please point me in the right direction? > > pdns_server --version > Version: 2.9.23-pre, compiled on Jan 19 2010, 10:47:55 with gcc version 4.1.2 > 20080704 (Red Hat 4.1.2-46) > > Chris > _______________________________________________ > Pdns-users mailing list > Pdns-users@mailman.powerdns.com > http://mailman.powerdns.com/mailman/listinfo/pdns-users > _______________________________________________ Pdns-users mailing list Pdns-users@mailman.powerdns.com http://mailman.powerdns.com/mailman/listinfo/pdns-users
