magento moved from shared hosting to VPS

Discussion in 'Content Management' started by lew1s666, May 20, 2015.

0
  1. #1
    site is working on localhost and shared hosting but on VPS with digital ocean and ISPconfig getting error.

    getting error and report log is a:5:{i:0;s:78:"SQLSTATE[HY000] [2003] Can't connect to MySQL server on 'mysql1.myhost.ie' .

    the website is with VPS and local.xml host is <host><![CDATA[localhost]]></host> . if i delete local.xml the issue is same. cache and session folder is empty
     
    lew1s666, May 20, 2015 IP
  2. Nigel Lew

    Nigel Lew Notable Member

    Messages:
    4,642
    Likes Received:
    406
    Best Answers:
    21
    Trophy Points:
    295
    #2
    mysql1.myhost.ie if that is what you have set for the db in the xml file try "localhost" instead.

    Magento is tricky stuff. I would probably have to crawl in there to fix that. Its hard to flesh it out otherwise.

    Hope that helps,
    Nigel
     
    Nigel Lew, May 20, 2015 IP
  3. lew1s666

    lew1s666 Member

    Messages:
    101
    Likes Received:
    1
    Best Answers:
    0
    Trophy Points:
    30
    #3
    as you

    as you can see in my local.xml is <host><![CDATA[localhost]]></host> . Thats localhost so dont understand what is pointing to mysql1.myhost.ie
     
    lew1s666, May 21, 2015 IP
  4. webhost.uk.net

    webhost.uk.net Well-Known Member

    Messages:
    296
    Likes Received:
    9
    Best Answers:
    0
    Trophy Points:
    128
    #4
    Have you tried using server IP instead of localhost .. can be due to hostname not resolving to correct IP address.
     
    webhost.uk.net, May 21, 2015 IP
  5. lew1s666

    lew1s666 Member

    Messages:
    101
    Likes Received:
    1
    Best Answers:
    0
    Trophy Points:
    30
    #5
    SOLVED! there was another files in app/etc. like old-local.xml so magento was using from cache this file instead of local.xml. i deleted all files and leave just local.xml
     
    lew1s666, May 21, 2015 IP