Failed to get DB handle: SQLSTATE[HY000] [2002] Connection timed out

Collapse
X
 
  • Time
  • Show
Clear All
new posts
  • aagcrc
    New Member
    • Jul 2018
    • 10
    • 4.2.x

    Failed to get DB handle: SQLSTATE[HY000] [2002] Connection timed out

    Failed to get DB handle: SQLSTATE[HY000] [2002] Connection timed out trying to see the posts of the threats.

    We are moving to a new webhosting provider.

    We have restored the DB in multiple ways with no errors

    All the site content is visible (categories and threats, under admincp, we can see all the users, avatars, images, which they are Stored in the DB)

    But when we enter to a post give us the error message.

    We are currently running vBulletin version 4.2.0 Patch Level 3.
    I want to make the upgrade to VB5 but would like to fix the issue before.

    CURRENT SERVER:

    Server Type Linux CENTOS 6.10 x86_64 standard
    Cpanel WHM 56.0 (build 52)
    Web Server Apache v2.2.29 (cgi-fcgi)
    PHP 5.4.42
    MySQL Version 5.5.52-cll


    NEW SERVER:

    Server Type LinuxCENTOS 6.10 kvm
    Cpanel/WHM v70.0.51
    Web Server Apache v2.4.33 (cgi-fcgi)
    PHP 5.4.45
    MySQL Version 5.6.39

    PHP CONFIG:

    PHP Max Post Size 24.00 MB
    PHP Maximum Upload Size 20.00 MB
    PHP Memory Limit 384.00 MB

    Any suggestion of troubleshooting available for this, would be really appreciate it.
  • Mark.B
    vBulletin Support
    • Feb 2004
    • 24286
    • 6.0.X

    #2
    vBulletin 4.2.0 is only compatible with php versions up to 5.3.

    Your new server should not be running php 5.4 either, this too is no longer supported.

    As a bare minimum the new server should run php 5.6. You shoud then upgrade vBulletin to 4.2.5.
    MARK.B
    vBulletin Support
    ------------
    My Unofficial vBulletin 6.0.0 Demo: https://www.talknewsuk.com
    My Unofficial vBulletin Cloud Demo: https://www.adminammo.com

    Comment

    • aagcrc
      New Member
      • Jul 2018
      • 10
      • 4.2.x

      #3
      Ok thank you, quick, question, when you do the upgrade, does it alter the DB, any change to the DB?
      The question is because I have this new server, I will test the upgrade, when I'm ready to move it to live, do I have to execute the upgrade again with the updated DB?

      Thank you Mark.B

      Comment

      • Mark.B
        vBulletin Support
        • Feb 2004
        • 24286
        • 6.0.X

        #4
        Every upgrade will change the database to some degree. 4.2.0 to 4.2.5 makes some fairly big changes, particularly around the navbar manager and various other things.

        You can run the upgrade on a test copy first, but you cannot then import the live database onto that. You will need to run the upgrade again on the live database.

        Always have full backups at all times.
        MARK.B
        vBulletin Support
        ------------
        My Unofficial vBulletin 6.0.0 Demo: https://www.talknewsuk.com
        My Unofficial vBulletin Cloud Demo: https://www.adminammo.com

        Comment

        • aagcrc
          New Member
          • Jul 2018
          • 10
          • 4.2.x

          #5
          The server had already PHP 5.6, it was just a matter of applying it and I also just finished upgrading the vBulletin Forum to version 4.2.5.
          But unfortunatelly I still have the issue. http://foro.eog.com

          Comment

          • aagcrc
            New Member
            • Jul 2018
            • 10
            • 4.2.x

            #6
            I'm still not successful to fix this issue, I tested in couple more server with same issue... Any more ideas?

            Comment

            widgetinstance 262 (Related Topics) skipped due to lack of content & hide_module_if_empty option.
            Working...