1. Please take a little time for this simple survey! Thank you for participating!
    Dismiss Notice
  2. Dear Pleskians, please read this carefully! New attachments and other rules Thank you!
    Dismiss Notice
  3. Dear Pleskians, I really hope that you will share your opinion in this Special topic for chatter about Plesk in the Clouds. Thank you!
    Dismiss Notice

Mail not hosted locally, MX records ignored

Discussion in 'Plesk 10.x for Linux Issues, Fixes, How-To' started by VyReN LLC, Feb 8, 2012.

  1. VyReN LLC

    VyReN LLC Guest

    0
     
    Mail not hosted locally, MX records ignored [SOLVED]

    PRODUCT, VERSION, OPERATING SYSTEM, ARCHITECTURE
    Parallels Plesk Panel v10.2.0_build1011110331.11 os_CentOS 5 64 bit

    PROBLEM DESCRIPTION AND STEPS TO REPRODUCE
    We have a domain where we only host the website, not the e-mail services. E-Mail services for this domain are turned off. The MX record has been updated with the proper IP address for mail to be delivered to. In Plesk 9 this was enough to have mail routed correctly. Mail generated externally is delivered as expected.

    ACTUAL RESULT
    When mail is sent from a form on this domain or via SMTP on this server, the mail attempts to deliver to the local machine (and bounces since the accounts don't exist here).

    EXPECTED RESULT
    All E-Mails for this domain that are created locally should "redirect" to the proper outside server.

    ANY ADDITIONAL INFORMATION
    This account was freshly created on the new Plesk 10.2 server hosted with GoDaddy. We haven't upgraded past 10.2 due to GoDaddy's internal update repo. It is possible to bypass and use the Parallels upgrade repo, but was advised against it (by GoDaddy, but they suck so we may do it anyway).
     
    Last edited by a moderator: Feb 9, 2012
  2. IgorG

    IgorG Forums Analyst Staff Member

    49
    24%
    Joined:
    Oct 27, 2009
    Messages:
    24,576
    Likes Received:
    1,244
    Location:
    Novosibirsk, Russia
    First of all make sure that you have correct DNS records in zone of this domain. After that run following command:
     
  3. Frater

    Frater Regular Pleskian

    18
     
    Joined:
    Oct 17, 2011
    Messages:
    173
    Likes Received:
    3
    To prevent this situation I would like to know which key in which table holds the value of "mail_service"

    I would like to execute a mysql command on my server that shows all the domains with "mail_service" turned on and not having e-mail accounts configured at all.

    The domains found deserve some investigation.
    These may have turned "mail_service" on when in fact it shouldn't.


    Could you please tell me what command to use, or at least the name of the key?


    This command gives me domains that does have addresses configured:
    What I want can probably be done with 1 efficient mysql-command...
    I just copied a command from here (http://pleskhacker.com/) and added a bit of generic bash.
     
  4. VyReN LLC

    VyReN LLC Guest

    0
     
    IgorG - Thanks for the fast reply, that fixed the issue!

    Frater - I believe, if I'm looking at the database correctly, the Table of DomainServices is what you are looking for. The domain we applied this setting to now has a status (column) of "16" under type "mail". The others have a status of "0". Did you know you can view the Plesk database in phpMyAdmin? Tools & Utilities->Databases->Click the little icon all the way to the right in the line for MySQL. Then select the "psa" database. But I think logic should tell you to be very careful, and you always need to run the appropriate command line function/program for plesk to reconfigure based on the database. I'm no pro here and have broken Plesk at least a dozen times mucking directly in the database. Don't do it unless you HAVE to. IMHO. :) I've found searching these forums or just asking the right question (See the OP) gets you an answer that doesn't involve mucking with the database.

    On a side note... Been working with clients using Plesk for about 5 years now. From before the Parallel's buyout. And I've noticed something VERY different the last year. These forums are effective. IgorG is actually working very hard to reply and communicate on these forums. Two years ago if I posted this question I would have been lucky to get a response at all, much less within 24 hours. For what it is worth, I'm very pleased with the increased communication here on the forum. Before it was a lot of user on user bugfixing and hacking. Now we actually get real responses and have a path to submit bugs/issues to the dev team. +1 for Parallels (And IgorG, whomever you may be!)
     
  5. IgorG

    IgorG Forums Analyst Staff Member

    49
    24%
    Joined:
    Oct 27, 2009
    Messages:
    24,576
    Likes Received:
    1,244
    Location:
    Novosibirsk, Russia
    VyReN, LLC,
    Thank you very much for your kind words and for cooperation! :)
     
  6. burnleyvic

    burnleyvic Regular Pleskian

    17
    85%
    Joined:
    Nov 9, 2011
    Messages:
    174
    Likes Received:
    1
    VyReN, LLC, iirc that status can take 4 possible values: 0 or 16 when the domain is active, also 2 or 18 when the domain is suspended. Found that a while ago when I was working on building an automated command line tool for migrating clients across Plesk servers. That's why if you (or someone else for that matter) think of using that status for whatever purpose, bear in mind that it can take 4 values, not 2. This being said, I double your suggestion: don't fiddle with the database unless it's really necessary and you know what you're doing :)
    Also, a sidenote about Plesk tech support responsiveness: it's usually down to the reporter providing useful information. The approach "after upgrading all my websites are displaying 404, now what?" doesn't work. The better the report, the bigger the changes to get someone @Parallels to look into it.
     
  7. IgorG

    IgorG Forums Analyst Staff Member

    49
    24%
    Joined:
    Oct 27, 2009
    Messages:
    24,576
    Likes Received:
    1,244
    Location:
    Novosibirsk, Russia
    Quite right note. It would be nice if everyone followed this rule :)
     
  8. Frater

    Frater Regular Pleskian

    18
     
    Joined:
    Oct 17, 2011
    Messages:
    173
    Likes Received:
    3
    I had no intention at all to change any data in the 'psa' database.
    I just want to query it and see all the domains that has mail enabled and no e-mail addresses configured.

    I want to use this list for peace of mind.
    I can then investigate these domains using the Plesk Panel and check if the setting make sense.
    Changes will only be done using the Plesk Panel.

    I just want to prevent the situation of the OP.

    Anyone knows already knows enough now how such a SQL-command would look like?
     
    Last edited: Feb 10, 2012
Loading...