• Visitors can check out the Forum FAQ by clicking this link. You have to register before you can post: click the REGISTER link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. View our Forum Privacy Policy.
  • Want to receive the latest contracting news and advice straight to your inbox? Sign up to the ContractorUK newsletter here. Every sign up will also be entered into a draw to WIN £100 Amazon vouchers!

Hosting upgrade causes port/server connect failures

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

    Hosting upgrade causes port/server connect failures

    Wonderful. My hosters have been "improving" things again and now the callback routine from Worldpay is not working so we/customers are not getting email details of the order and neither are they being stored in the database.

    Without going into coding details I am using the freeware phpgmailer script to send emails via gmail. This was fine before but now generates:

    Warning: fsockopen() [function.fsockopen]: unable to connect to ssl://smtp.gmail.com:465 (Connection timed out)

    Even more oddly, this simple line:

    $con = mysql_connect("localhost","mydatabase","mypassword ");

    Now generates this error:

    Warning: mysql_real_escape_string() [function.mysql-real-escape-string]: Can't connect to local MySQL server through socket '/var/lib/mysql/mysql.sock' (2) in etc

    Anyone got any clues why an upgrade to the hosting package should cause these problems? Some permissions not set or what? Cheers for any ideas.
    bloggoth

    If everything isn't black and white, I say, 'Why the hell not?'
    John Wayne (My guru, not to be confused with my beloved prophet Jeremy Clarkson)

    #2
    Have they moved the database off to another server?

    With my hosting provider you don't connect to a database on 'localhost' but to some other server, which in turn works out exactly which physical server the database is sitting on.
    Behold the warranty -- the bold print giveth and the fine print taketh away.

    Comment


      #3
      Cheers. May be the problem but hard to find anything out. Hosting support is pathetic, either they are total dimwits or they don't comprehend English.
      bloggoth

      If everything isn't black and white, I say, 'Why the hell not?'
      John Wayne (My guru, not to be confused with my beloved prophet Jeremy Clarkson)

      Comment


        #4
        Sorted - ish.

        It seems they have firewalled using gmail, so have to revert to their crap mailer which can take 2 days to arrive with headers full of errors. mysql "localhost" doesn't work anymore and have to specify it explicitly.

        Can't wait to take my hosting elsewhere before they "improve" something else. Plonkers.
        bloggoth

        If everything isn't black and white, I say, 'Why the hell not?'
        John Wayne (My guru, not to be confused with my beloved prophet Jeremy Clarkson)

        Comment


          #5
          Which provider is this?

          Comment


            #6
            Close enough from the names on the tickets. Anyway, signed up for hostpapa. Good reviews and, from quality of support info so far, looks excellent.
            bloggoth

            If everything isn't black and white, I say, 'Why the hell not?'
            John Wayne (My guru, not to be confused with my beloved prophet Jeremy Clarkson)

            Comment

            Working...
            X