WEB Database error connecting... sometimes

Discussion in 'OT Technology' started by hurleyint1386, Sep 21, 2008.

  1. hurleyint1386

    hurleyint1386 Someone has sand in their vagina

    Joined:
    Jan 6, 2005
    Messages:
    3,687
    Likes Received:
    0
    Location:
    Rochester, NY
    So I went to a site I hadn't touched in a while, and I got an error that it couldn't connect to the database. I tried refreshing a few times and it wouldn't work. So I SFTP to the site and check things out to see if permissions got changed or if the included file was missing or something. Everything was there. I did a refresh on the page and everything worked fine. I didn't touch anything, I just changed directories to see if everything was where it should be, hit refresh, and it worked. Anyone have any weird issues like this? :noes:
     
  2. intrktevo

    intrktevo New Member

    Joined:
    Oct 18, 2004
    Messages:
    5,781
    Likes Received:
    0
    Location:
    UCF
    make sure the login/password/host haven't been changed by your host
     
  3. hurleyint1386

    hurleyint1386 Someone has sand in their vagina

    Joined:
    Jan 6, 2005
    Messages:
    3,687
    Likes Received:
    0
    Location:
    Rochester, NY
    Like I said, I didn't change anything, and it started working again when I logged into the server with the same username and password I've ever used.
     
  4. maxxpower

    maxxpower OG Lauren Crew - Observer OT Supporter

    Joined:
    May 27, 2007
    Messages:
    26,348
    Likes Received:
    0
    shared hosting? probably a busy sql server
     
  5. Half-Time

    Half-Time OT Supporter

    Joined:
    Mar 21, 2007
    Messages:
    6,460
    Likes Received:
    0
    Location:
    Houston
    have your host rebuild the sql sockets on the server
     
  6. hurleyint1386

    hurleyint1386 Someone has sand in their vagina

    Joined:
    Jan 6, 2005
    Messages:
    3,687
    Likes Received:
    0
    Location:
    Rochester, NY
    What exactly will this do? If I asked them to do that, they'll probably want to know why.
     
  7. fortinet

    fortinet OT Supporter

    Joined:
    Sep 22, 2008
    Messages:
    251
    Likes Received:
    0
    Location:
    Glendora, CA
    That will basically make sure that the web server has a way of connecting to the SQL server. Since you were having problems where the web server wasn't connecting to the database, it'd be basically a "refresh connection" fix to try out.
     
  8. Half-Time

    Half-Time OT Supporter

    Joined:
    Mar 21, 2007
    Messages:
    6,460
    Likes Received:
    0
    Location:
    Houston
    Yea, it's nothing bad. Just tell them that sometimes sql wouldn't connect, and would error out, and sometimes it won't. If they are decent admins, that would be one of the first things to do.
     

Share This Page