Plesk: There is incorrect combination of resource records in the zone

Got this error when trying to add a mail CNAME in Plesk DNS:

Error: There is incorrect combination of resource records in the zone

Found RackerHacker’s note about it and it was as he said, trying to add a new CNAME for mail. So I added the ‘test’ hostname instead as a CNAME to the host I wanted to use, then set about updating that in the psa DB.

One commenter suggested using phpmyadmin to make the changes to the dns_recs table in the psa database, but I didn’t have phpmyadmin setup for server wide usage.

So I just logged into mysql from the command line and did this:

mysql> select * from dns_recs;

to get the list of DNS records. Then I found the ID of the record I needed to change and did these 2 commands:

update dns_recs set host='mail.example.org' where id='XX'
update dns_recs set displayHost='mail.example.org' where id='XX'

Change mail.example.org to your domain and ID to the record ID you found and that’s how to set a mail CNAME for a non-local host. Should be a simple task, yes…

4 links for 2009-11-19

  • Tagaroo » Make blogging better!
    Tagaroo is designed to make your WordPress blog better for you, better for your readers and more accessible to search engines. As you’re writing, Tagaroo analyzes the text in your post and suggests intelligent tags for the things and events you’re writing about.

    You can use these tags in your post – but even better – you can use these tags to automatically get great images from Flickr to include in your post.

    (tags: tagging calais semantic opencalais flickr wordpress plugin tag)

links for 2009-11-14

  • BuddyPress Registration Options Plugin | WebDevStudios.com
    A WordPress BuddyPress plugin that allows for new member moderation, if moderation is turned on from the admin settings page, any new members will be blocked from interacting with any buddypress elements (except editing their own profile and uploading their avatar) and will not be listed in any directory until an administrator approves or denies their account. This plugin also creates bp profile field checkbox groups on the /register page from checked off groups or blogs in the admin settings section so any new members can join one or more groups or blogs that you specify at registration. If moderation is turned on admins can create custom display messages and email alert messages for approved or denied accounts.
    (tags: wordpress wpmu buddypress registration)

links for 2009-10-16

  • Newsworthy – Free WordPress Theme | Theme Lab
    Today we have an awesome news theme, originally designed by DemusDesign, which I then ported to WordPress. This theme requires at least WordPress 2.8 to function properly, and includes some standard features such as threaded comments and comment pagination. There are also over 10 widget-ready areas, including a widgetized footer, plus a custom widget for ad management.
    (tags: wordpress theme themes)