Results 1 to 9 of 9
  1. #1
    Join Date
    Aug 2013
    Location
    Montenegro
    Posts
    65
    Plugin Contributions
    0

    red flag ZC website can't connect to database

    Hi,

    I changed db user and password in cPanel and therefore I updated includes/config.php and admim/includes/config.php files in order to reflect these changes. But something still goes wrong because I can't open my web page because of a database connectivity problem.

    Does anyone have an idea what is the issue here?

    Thank you!

  2. #2
    Join Date
    Nov 2005
    Location
    los angeles
    Posts
    1,468
    Plugin Contributions
    2

    Default Re: ZC website can't connect to database

    Quote Originally Posted by Laki View Post
    Hi,

    I changed db user and password in cPanel and therefore I updated includes/config.php and admim/includes/config.php files in order to reflect these changes. But something still goes wrong because I can't open my web page because of a database connectivity problem.

    Does anyone have an idea what is the issue here?

    Thank you!
    yes. you (or cpanel) did something incorrectly.

    there should be an option from cpanel for phpmyadmin or something similar. you should see if you can connect to the database using the phpmyadmin and your credentials. once you have verified that connection, you can then populate the configure files with the exact same credentials.

    connecting to the db is almost always a user problem with the credentials. it could be that cpanel did not give enough rights to the new user for the ZC db. but it is not a ZC problem.

    good luck.
    practice #socialdistancing NOW! #staythefawayfromme
    email is hard....
    help out with the green....

  3. #3
    Join Date
    Aug 2013
    Location
    Montenegro
    Posts
    65
    Plugin Contributions
    0

    Default Re: ZC website can't connect to database

    1. I created db user and password that was added to a database.
    2. In the next step, I populated config files with information: db user, password, database name (database name remained the same so nothing was to change in this line).

  4. #4
    Join Date
    Sep 2009
    Location
    Stuart, FL
    Posts
    9,419
    Plugin Contributions
    72

    Default Re: ZC website can't connect to database

    Remember, too, that the storefront /includes/configure.php file gets marked as read-only when the site's accessed. Make sure that the changes you've made are actually present in that file.

    Are you editing directly via your cPanel's File Manager or uploading those changes via FTP?

  5. #5
    Join Date
    Aug 2013
    Location
    Montenegro
    Posts
    65
    Plugin Contributions
    0

    Default Re: ZC website can't connect to database

    @lat9

    I edited config file through cPanel File Manager.
    Storefront /includes/configure.php file is marked as read-only (444).

  6. #6
    Join Date
    Jan 2004
    Location
    N of San Antonio TX
    Posts
    7,355
    Plugin Contributions
    8

    Default Re: ZC website can't connect to database

    Quote Originally Posted by Laki View Post
    I edited config file through cPanel File Manager.
    Storefront /includes/configure.php file is marked as read-only (444).
    As lat9 was pointing out, you can edit all day long and, until the file is changed to at least 644, the edit will not complete.

    In the file manager, go to the includes/configure.php and right-click on the file. Select Change Permissions and set them to 644.

    Older versions of cpanel will not complete this action until you click reload. Newer cpanels do it without the reload. Just make sure the file is set to 644 before the edit and return it to 444 after the edit.
    Did you read the posting tips?!?
    Responsive Color Changes for 155-156c demo here.
    Zen Cart PCI Compatible Hosting

  7. #7
    Join Date
    Aug 2013
    Location
    Montenegro
    Posts
    65
    Plugin Contributions
    0

    Default Re: ZC website can't connect to database

    I did it - changed permission to 644, edited config file through File Manager and returned permission to 444, but I see again "There seems to be a problem connecting to our database".

  8. #8
    Join Date
    Jan 2004
    Location
    N of San Antonio TX
    Posts
    7,355
    Plugin Contributions
    8

    Default Re: ZC website can't connect to database

    IF you have properly edited the two configure.php files, then carlwhat's statement is the thing to check
    connecting to the db is almost always a user problem with the credentials. it could be that cpanel did not give enough rights to the new user for the ZC db. but it is not a ZC problem.
    Did you read the posting tips?!?
    Responsive Color Changes for 155-156c demo here.
    Zen Cart PCI Compatible Hosting

  9. #9
    Join Date
    Aug 2013
    Location
    Montenegro
    Posts
    65
    Plugin Contributions
    0

    Default Re: ZC website can't connect to database

    I'll check again but I'm sure that the db user has full permissions, and the credentials were carefully copied to the config files.
    Thanks for your time.

 

 

Similar Threads

  1. v155 Can't connect to database
    By HeleneWallis in forum Installing on a Linux/Unix Server
    Replies: 20
    Last Post: 30 Oct 2017, 04:03 AM
  2. Can't connect to my database.
    By misty16 in forum General Questions
    Replies: 32
    Last Post: 13 Oct 2010, 05:10 PM
  3. Replies: 0
    Last Post: 7 Apr 2008, 04:54 AM
  4. Can't connect to database during installation
    By isaacr25 in forum Installing on a Linux/Unix Server
    Replies: 14
    Last Post: 29 Sep 2007, 06:34 AM

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  
disjunctive-egg
Zen-Cart, Internet Selling Services, Klamath Falls, OR