hosting upgraded from shared to VPS, database connection error

Discussion in 'Installation' started by pinoyinvesting, Jan 15, 2016.

  1. pinoyinvesting

    pinoyinvesting New Member

    Joined:
    Oct 12, 2014
    Messages:
    4
    hello, i recently requested for an upgrade of my web hosting from shared to VPS, but after it, i accessed my amember links and has database connection error:

    Script Error
    Error establishing a database connection. Please contact site webmaster if this error does not disappear long time

    Could you help me how to correct this?
    Appreciate any help.

    Thanks!
  2. thehpmc

    thehpmc Member

    Joined:
    Aug 24, 2006
    Messages:
    901
    Could be you need to create user for database on new hosting but it might also help if you posted contents of error log.
  3. caesar

    caesar aMember Pro Developer Staff Member

    Joined:
    Oct 16, 2009
    Messages:
    2,295
    Please check DB user access credentials in file amember/application/configs/config.php
    also please check that on new server pdo and pdo_mysql PHP extensions is enabled.
  4. pinoyinvesting

    pinoyinvesting New Member

    Joined:
    Oct 12, 2014
    Messages:
    4
    Hi I have below in config.php
    what shall i do with the credentials?

    return array(
    'db' => array(
    'mysql' => array(
    'db' => 'XXX_amember',
    'user' => 'YYY_amember',
    'pass' => 'SI]+zG&SrHSaa',
    'host' => 'localhost',
    'prefix' => 'am_',
    'port' => '',
    ),
    ),
    );

    and how can i check if the pdo and pdo_mysql are enabled?
    I'm not really into technical but i can explore if given steps.

    Thanks!
    Last edited: Jan 15, 2016
  5. pinoyinvesting

    pinoyinvesting New Member

    Joined:
    Oct 12, 2014
    Messages:
    4
    i have seen that pdo is not yet enabled. im asking hosting support to do this..
  6. robw

    robw CGI-Central Partner

    Joined:
    Dec 18, 2007
    Messages:
    287
    Now change that database password you posted on a public forum... :eek: :eek: :eek:

    Cheers
    Rob

Share This Page