Announcement

Collapse
No announcement yet.

Plesk control panel ERROR: PleskMainDBException

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

  • Plesk control panel ERROR: PleskMainDBException

    If Plesk control panel giving the following error message.
    ERROR: PleskMainDBException
    DB query failed: Unknown error
    0: common_func.php3:171
    db_query(string \'set names utf8\')
    1: common_func.php3:626
    reconnect()
    2: common_func.php3:591
    db_connect()
    3: auth.php3:90

    This seems that sql and mysql services are stopped on the server to start this service,
    Login to the server > open plesk service monitor and restart the plesk SQL server.
    Last edited by Aidan B; 06-05-2013, 01:36.

  • #2
    Re: Plesk control panel ERROR: PleskMainDBException

    Hello Aidan,

    Thanks, I followed the exact instructions and double triple checked that SQL and MySQL services are running fine on the server.

    I also tried a server reboot but I am still facing the issue and getting the above error message, any thoughts ?

    Regards,
    Andy

    Comment


    • #3
      Re: Plesk control panel ERROR: PleskMainDBException

      Hi Andy,

      If there is problem with plesk database, you may faced this issue

      You can follow the below steps :

      1) Check if Please mysql services is started or not.

      If not then strat it.

      2) Check if you can connect to mysql service using telnet on port 8306.

      If it fails to connect then you will need to check windows firewall
      and open port 8306 in firewall also check if my.ini file has correct
      listening port setting for the mysql services.

      3) If there is no issue with the plesk mysql services and its listening to
      the requests then there might be issue with the mysql login or password issue
      as a result plesk is unable to connect to psa database .

      You will need to reset plesk mysql server admin password.

      Run cmd
      Type cd %plesk_bin%
      This will open plesk bin directory.
      Then run plesksrvclient.exe
      Popup box will appear.
      Enter new plesk password and tick check box of “Change plesk mysql password” and click on

      Try to access the Plesk now.
      "It Takes 20 Years To Build A Reputation And Five Minutes To Ruin It. If You Think About That, You'll Do Things Differently. "

      Comment


      • #4
        Re: Plesk control panel ERROR: PleskMainDBException

        Hello,

        I followed the steps provided and the issue has been resolved.

        Many Thanks !!!


        Regards
        Andy

        Comment


        • #5
          Re: Plesk control panel ERROR: PleskMainDBException

          Originally posted by PMagic View Post
          Hi Andy,

          If there is problem with plesk database, you may faced this issue

          You can follow the below steps :

          1) Check if Please mysql services is started or not.

          If not then strat it.

          2) Check if you can connect to mysql service using telnet on port 8306.

          If it fails to connect then you will need to check windows firewall
          and open port 8306 in firewall also check if my.ini file has correct
          listening port setting for the mysql services.

          3) If there is no issue with the plesk mysql services and its listening to
          the requests then there might be issue with the mysql login or password issue
          as a result plesk is unable to connect to psa database .

          You will need to reset plesk mysql server admin password.

          Run cmd
          Type cd %plesk_bin%
          This will open plesk bin directory.
          Then run plesksrvclient.exe
          Popup box will appear.
          Enter new plesk password and tick check box of “Change plesk mysql password” and click on

          Try to access the Plesk now.
          Hello,

          I have same problem. I done your quote and this article: kb.parallels.com/de/115602/?show_at=enParallels: Fehleranzeige auf Parallels Panel Login-Seite: „DB query failed: Unknown error“ Plesk login page displays error: "DB query failed: Unknown error
          but the problem doesn't solve yet.
          the password plesk is same as Plesk db admin password.
          sometimes the login page load and sometimes I see the error.
          I think its related to db connection ...
          what do you suggest. my plesk version is 9.5.4

          I'm looking forward to your reply ASAP.

          thanks and regards,

          Comment


          • #6
            Re: Plesk control panel ERROR: PleskMainDBException

            Originally posted by f.etemadian View Post
            Hello,

            I have same problem. I done your quote and this article: kb.parallels.com/de/115602/?show_at=enParallels: Fehleranzeige auf Parallels Panel Login-Seite: „DB query failed: Unknown error“ Plesk login page displays error: "DB query failed: Unknown error
            but the problem doesn't solve yet.
            the password plesk is same as Plesk db admin password.
            sometimes the login page load and sometimes I see the error.
            I think its related to db connection ...
            what do you suggest. my plesk version is 9.5.4

            I'm looking forward to your reply ASAP.

            thanks and regards,
            I am not able to locate your account with the email address registered on the forum and the issue that you have raised can be caused by multiple reasons and hence it is very difficult to provide a definite solution without actually looking at the server logs.

            I suggest you to kindly open a support ticket or you can contact us via live chat.
            Reeve.Slater
            System Administrator

            Comment


            • #7
              Re: Plesk control panel ERROR: PleskMainDBException

              Originally posted by f.etemadian View Post
              Hello,

              I have same problem. I done your quote and this article: kb.parallels.com/de/115602/?show_at=enParallels: Fehleranzeige auf Parallels Panel Login-Seite: „DB query failed: Unknown error“ Plesk login page displays error: "DB query failed: Unknown error
              but the problem doesn't solve yet.
              the password plesk is same as Plesk db admin password.
              sometimes the login page load and sometimes I see the error.
              I think its related to db connection ...
              what do you suggest. my plesk version is 9.5.4

              I'm looking forward to your reply ASAP.

              thanks and regards,
              Hi,

              Yes, this problem is definitely related to Plesk control panel not communicating with it's DB. Did you try running the Plesk Reconfigurator tool? I'd also recommend you login to to the server & reset the Plesk-SQL's (which runs on port 8306) "admin" login password. It'd help solve this issue, if not kindly update us with your server details & we'll assist you with sorting this out..
              Rock _a.k.a._ Jack Daniel

              Follow eUKhost on Twitter || Join eUKhost Community on Facebook

              Comment


              • #8
                Re: Plesk control panel ERROR: PleskMainDBException

                thanks for your informative post....i hope it'll be very initiative for every of your reader

                Comment

                Working...
                X