Results 1 to 4 of 4
  1. #1
    easyliferay is offline new member
    Join Date
    Apr 2007
    Posts
    9

    Default connecting to mySQL DB

    HI, totally new with php and mySQL and I need advice. I have uploaded a pre-built zen website with database and all files but when I try to logon, I am told it cannot connect to the database. I know exactly where the problem lies, but I simply cannot get the it right.

    The two files I need to configure correctly (but which I am having trouble with) are includes/configure.php (1) and admin/includes/configure.php (2).

    includes/configure.php (1) asks
    // add your database and website details to the variables below

    define('DB_SERVER_USERNAME', 'CHANGE');
    // your username that you use to log into your web server
    define('DB_SERVER_PASSWORD', 'CHANGE');
    // your password that you use to log into your web server
    define('DB_DATABASE', 'CHANGE');
    // replace username with your web server username
    define('DIR_FS_CATALOG', '/home/CHANGE/public_html/');

    define('HTTP_SERVER', 'http://www.CHANGE.co.uk');
    define('HTTP_COOKIE_DOMAIN', '.CHANGE.co.uk');
    // do not include the www

    admin/includes/configure.php (2) asks
    // add your database and website details to the variables below

    define('DB_SERVER_USERNAME', 'CHANGE');
    // your username that you use to log into your web server
    define('DB_SERVER_PASSWORD', 'CHANGE');
    // your password that you use to log into your web server
    define('DB_DATABASE', 'CHANGE');
    // replace username with your web server username
    define('DIR_FS_ADMIN', '/home/CHANGE/public_html/admin/'); // replace username with your web server username
    define('DIR_FS_CATALOG', '/home/CHANGE/public_html/');
    define('DIR_FS_DOCUMENT_ROOT', '/home/CHANGE/public_html');
    define('SITE', 'www.CHANGE.co.uk');
    define('WWW', 'http://www.CHANGE.co.uk');
    define('HTTP_SERVER', 'http://www.CHANGE.co.uk');
    define('HTTP_CATALOG_SERVER', 'http://www.CHANGE.co.uk');

    My problem is that no matter how many times I change the these values, something is not going correctly.

    My sites is Index of /, the zen cart is stored at http://eagleanddove.com/shop and according to cpanel, my database is eagleand_ebookstore.

    I need help in knowing what to put into the CHANGE option on all the configure files, as I just can not get it right. This is the first time I have tried this, so I am a beginner with Zencarts.

  2. #2
    Nancy J is offline Junior Member
    Join Date
    Sep 2008
    Posts
    14

    Default

    In define('DIR_FS_CATALOG', '/home/CHANGE/public_html/');

    Replace '/home/CHANGE/public_html/' With '/home/cpanel_username/public_html/shop'

    as zen cart in under "shop" Folder you need to add "shop" after 'public_html'

    IF you still face problem then please contact us on Live chat so that we can fix this problem.

  3. #3
    easyliferay is offline new member
    Join Date
    Apr 2007
    Posts
    9

    Default

    Quote Originally Posted by Nancy J View Post
    In define('DIR_FS_CATALOG', '/home/CHANGE/public_html/');

    Replace '/home/CHANGE/public_html/' With '/home/cpanel_username/public_html/shop'

    as zen cart in under "shop" Folder you need to add "shop" after 'public_html'

    IF you still face problem then please contact us on Live chat so that we can fix this problem.

    OK, will contact you on live chat as I have changed the values you suggested and I am still having problems. Thanks

  4. #4
    Rock's Avatar
    Rock is offline Technical Support (eUKhost.com)
    Join Date
    Oct 2006
    Location
    localhost
    Posts
    3,375

    Default

    You're welcome

    Rock _a.k.a._ Jack
    Windows Hosting || Windows Reseller Hosting
    Cloud Hosting 100% UPTIME! || Powerful Dedicated Servers
    Follow eUKhost on Twitter || Join eUKhost Community on Facebook

    For complaints, grievances or suggestions kindly email our FeedBack Dept.
    Proper action will be taken accordingly & instantaneously!

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •