Announcement

Collapse
No announcement yet.

Error Code: MER-DBA-MYS-00001

Collapse
X
 
  • Filter
  • Time
  • Show
Clear All
new posts

    Error Code: MER-DBA-MYS-00001

    A friend of mine has a Miva Merchant site on another host that got the following error, which the host says resulted from an IP address in another country slamming the site so they blocked the IP address last week. It is now happening again. Is there more that they can do to stop this error from happening?

    Note: I changed the host name to a generic since they said didn't want it or their domain shown

    Fatal Error

    Miva Merchant has encountered a fatal error and is unable to continue. The following information may assist you in determining the cause of the error:

    Error Code: MER-DBA-MYS-00001
    Description: Unable to connect to database: Host 'site-name.net' is blocked because of many connection errors; unblock with 'mysqladmin flush-host
    Other Information:

    Feel free to move this thread if needed. Put it in the v.9, since they just upgraded.

    Jamie
    Jamie Donaldson
    JSDVS Web Design / Development
    Web Design | Web Development | E-commerce Design & Integration

    #2
    Re: Error Code: MER-DBA-MYS-00001

    Originally posted by jsdva View Post
    A friend of mine has a Miva Merchant site on another host that got the following error, which the host says resulted from an IP address in another country slamming the site so they blocked the IP address last week. It is now happening again. Is there more that they can do to stop this error from happening?

    Note: I changed the host name to a generic since they said didn't want it or their domain shown

    Fatal Error

    Miva Merchant has encountered a fatal error and is unable to continue. The following information may assist you in determining the cause of the error:

    Error Code: MER-DBA-MYS-00001
    Description: Unable to connect to database: Host 'site-name.net' is blocked because of many connection errors; unblock with 'mysqladmin flush-host
    Other Information:

    Feel free to move this thread if needed. Put it in the v.9, since they just upgraded.

    Jamie

    Hello Jamie,

    If the host only blocked the one single IP and not the IP range then this is bound to happen over and over again, the culprit just changes their IP address once they realize it's being denied. Do you know how the IP was blocked, i.e. via .htaccess, vhosts.conf or the servers IP tables? If the IP address is coming from a country that they do not do business in and wouldn't mind blocking the entire country they can block the country in the sites vhost.conf / vhost_ssl.conf . If the site is on a linux server you can block countries that are known to hammer sites with junk traffic. For example this URL below has a few different countries IP ranges that you can add to the sites vhosts configuration file.


    http://www.wizcrafts.net/chinese-blocklist.html



    If it's coming from the US or a country that they do not want to block then the host should looking into blocking the range of IPs rather than single IP addresses. They can use this site below to get the range of IPs that the culprit is coming from.

    https://www.ultratools.com/tools/netMask

    Regards
    Rafael Buelna
    Miva Support Engineer
    800.608.MIVA (24/7 Support)
    http://www.miva.com
    http://www.miva.com/support

    Comment


      #3
      Re: Error Code: MER-DBA-MYS-00001

      Thank you so much Rafael! That is comprehensive and informative. I'll send this to them and have them act on it, since I don't know how exactly they are blocking them. I know they said the host was stymied, so maybe this can shed some light.

      Your reply is greatly appreciated!

      Jamie
      Jamie Donaldson
      JSDVS Web Design / Development
      Web Design | Web Development | E-commerce Design & Integration

      Comment

      Working...
      X