Forums / General Questions / Cannot connect to database anymore

Cannot connect to database anymore

Locked

Started by travel124 on 24 Jul 2009, 2:10 PM · Views: 2,265

Results 1 to 20 of 28
This thread is locked. New replies are disabled.
24 Jul 2009, 2:10 PM
#1
travel124 avatar

travel124

Zen Follower

Join Date:
Mar 2006
Location:
White Pigeon, MI
Posts:
160
Plugin Contributions:
0

Cannot connect to database anymore

I am using version v1.3.8a. Earlier this week I edited the config file and since then I have not been able to connect to my database.

I had a backup of my mu config files, I uploaded those and my site would not work.

I have access to my Cpanel and know what my user and ID pass is and still cannot connect. I also updated my my dateabase but still cannot connect for some strange reason.

I have read and read the forums to try to figure out what is wrong. I tried a fresh install to connect with the same data base, it pulls some of my previouse store items but not my all of catagories. I am lost at this point.

I called my host yesterday and they said they could not help me.

Thanks for any help.

24 Jul 2009, 4:21 PM
#2
stevesh avatar

stevesh

Black Belt

Join Date:
Feb 2005
Location:
Lansing, Michigan USA
Posts:
19,793
Plugin Contributions:
2

Re: Cannot connect to database anymore

travel124:

I tried a fresh install to connect with the same data base, it pulls some of my previouse store items but not my all of catagories. I am lost at this point.

Does this mean that the fresh installation is connecting with the database? A link to your site might let us see something you're missing.

3 Aug 2009, 3:00 PM
#3
travel124 avatar

travel124

Zen Follower

Join Date:
Mar 2006
Location:
White Pigeon, MI
Posts:
160
Plugin Contributions:
0

Re: Cannot connect to database anymore

I am fine now and back up. I was able to connect to the newer database. I somehow lost all my info from all my old data base. What bugs me is my parent directory keeps showing in public view and I cant figure out why it is doing that and how to change it from showing.

Do I have my zen files where they are supposed to be?

public_html/shoppe

I renamed my zencart store to /shoppe and named my admin to my sons name and added numbers for security.

Thanks!

:)

3 Aug 2009, 3:04 PM
#4
stevesh avatar

stevesh

Black Belt

Join Date:
Feb 2005
Location:
Lansing, Michigan USA
Posts:
19,793
Plugin Contributions:
2

Re: Cannot connect to database anymore

If you mean that when someone goes to the root of your site, they see Index of ..., that means there's no index file in the root directory. I'm not sure why you moved your store to a subdirectory, but if that's where you want it, you'll need to create an index.html page for the root. Maybe an image of some sort that links to /shoppe.

3 Aug 2009, 3:32 PM
#5
travel124 avatar

travel124

Zen Follower

Join Date:
Mar 2006
Location:
White Pigeon, MI
Posts:
160
Plugin Contributions:
0

Re: Cannot connect to database anymore

Ok, so all i need to do is bump all my files just below the public_html folder.

I will then have to edit the config files. That is how I lost my first data base files.

3 Aug 2009, 3:47 PM
#6
kdb04d avatar

kdb04d

New Zenner

Join Date:
Feb 2009
Posts:
35
Plugin Contributions:
0

Re: Cannot connect to database anymore

are u sure ur config files weren't just unable to overide because u didnt change the permissions its happened to me before

3 Aug 2009, 4:06 PM
#7
travel124 avatar

travel124

Zen Follower

Join Date:
Mar 2006
Location:
White Pigeon, MI
Posts:
160
Plugin Contributions:
0

Re: Cannot connect to database anymore

I don't remember what I did now. I just bumped up the files and edited the config files and f'd up the site again...lol

3 Aug 2009, 4:19 PM
#8
travel124 avatar

travel124

Zen Follower

Join Date:
Mar 2006
Location:
White Pigeon, MI
Posts:
160
Plugin Contributions:
0

Re: Cannot connect to database anymore

ok i posted the includes config file. I am getting a 500 page error. I added >>>>>> is this correct???? where i edited in the config file.

I can login to the admin side fine.

Thanks again for your help. :)

<?php /** * @package Configuration Settings circa 1.3.8 * @copyright Copyright 2003-2007 Zen Cart Development Team * @copyright Portions Copyright 2003 osCommerce * @license <http://www.zen-cart.com/license/2_0.txt> GNU Public License V2.0 */ /*************** NOTE: This file is similar, but DIFFERENT from the "admin" version of configure.php. ***********/ /*************** The 2 files should be kept separate and not used to overwrite each other. ***********/ // Define the webserver and path parameters // HTTP_SERVER is your Main webserver: eg, <http://www.yourdomain.com> // HTTPS_SERVER is your Secure webserver: eg, <https://www.yourdomain.com> define('HTTP_SERVER', 'http://www.mysite.com'); >>>>>> is this correct???? define('HTTPS_SERVER', 'https://www.mysite.com'); >>>>>> is this correct???? // Use secure webserver for checkout procedure? define('ENABLE_SSL', 'true'); // NOTE: be sure to leave the trailing '/' at the end of these lines if you make changes! // * DIR_WS_* = Webserver directories (virtual/URL) // these paths are relative to top of your webspace ... (ie: under the public_html or httpdocs folder) define('DIR_WS_CATALOG', '/public_html/'); >>>>>> is this correct???? define('DIR_WS_HTTPS_CATALOG', '/public_html/'); >>>>>> is this correct???? define('DIR_WS_IMAGES', 'images/'); define('DIR_WS_INCLUDES', 'includes/'); define('DIR_WS_FUNCTIONS', DIR_WS_INCLUDES . 'functions/'); define('DIR_WS_CLASSES', DIR_WS_INCLUDES . 'classes/'); define('DIR_WS_MODULES', DIR_WS_INCLUDES . 'modules/'); define('DIR_WS_LANGUAGES', DIR_WS_INCLUDES . 'languages/'); define('DIR_WS_DOWNLOAD_PUBLIC', DIR_WS_CATALOG . 'pub/'); define('DIR_WS_TEMPLATES', DIR_WS_INCLUDES . 'templates/'); define('DIR_WS_PHPBB', '/'); // * DIR_FS_* = Filesystem directories (local/physical) //the following path is a COMPLETE path to your Zen Cart files. eg: /var/www/vhost/accountname/public_html/ define('DIR_FS_CATALOG', '/home/######/public_html/'); >>>>>> is this correct???? define('DIR_FS_DOWNLOAD', DIR_FS_CATALOG . 'download/'); define('DIR_FS_DOWNLOAD_PUBLIC', DIR_FS_CATALOG . 'pub/'); define('DIR_WS_UPLOADS', DIR_WS_IMAGES . 'uploads/'); define('DIR_FS_UPLOADS', DIR_FS_CATALOG . DIR_WS_UPLOADS); define('DIR_FS_EMAIL_TEMPLATES', DIR_FS_CATALOG . 'email/'); // define our database connection define('DB_TYPE', 'mysql'); define('DB_PREFIX', 'zen_'); define('DB_SERVER', 'localhost'); define('DB_SERVER_USERNAME', '#####'); define('DB_SERVER_PASSWORD', '####'); define('DB_DATABASE', '######'); define('USE_PCONNECT', 'false'); // use persistent connections? define('STORE_SESSIONS', 'db'); // use 'db' for best support, or '' for file-based storage // The next 2 "defines" are for SQL cache support. // For SQL_CACHE_METHOD, you can select from: none, database, or file // If you choose "file", then you need to set the DIR_FS_SQL_CACHE to a directory where your apache // or webserver user has write privileges (chmod 666 or 777). We recommend using the "cache" folder inside the Zen Cart folder // ie: /path/to/your/webspace/public_html/zen/cache -- leave no trailing slash define('SQL_CACHE_METHOD', 'database'); define('DIR_FS_SQL_CACHE', '/home/######/public_html/cache'); >>>>>> is this correct???? // EOF
3 Aug 2009, 5:05 PM
#9
stevesh avatar

stevesh

Black Belt

Join Date:
Feb 2005
Location:
Lansing, Michigan USA
Posts:
19,793
Plugin Contributions:
2

Re: Cannot connect to database anymore

Everything looks right except:

define('DIR_WS_CATALOG', '/public_html/'); >>>>>> is this correct????
define('DIR_WS_HTTPS_CATALOG', '/public_html/'); >>>>>> is this correct????

shiould be

define('DIR_WS_CATALOG', '/');
define('DIR_WS_HTTPS_CATALOG', '/');

3 Aug 2009, 5:27 PM
#10
travel124 avatar

travel124

Zen Follower

Join Date:
Mar 2006
Location:
White Pigeon, MI
Posts:
160
Plugin Contributions:
0

Re: Cannot connect to database anymore

ok I have changed those and I am still getting the same error. tx

http://www.lorigiles.com/

3 Aug 2009, 7:29 PM
#11
travel124 avatar

travel124

Zen Follower

Join Date:
Mar 2006
Location:
White Pigeon, MI
Posts:
160
Plugin Contributions:
0

Re: Cannot connect to database anymore

I have been trying to figure what is wrong. I am getting this error in both the admin and public view now.

Forbidden
You don't have permission to access /#####/index.php on this server.

Additionally, a 404 Not Found error was encountered while trying to use an ErrorDocument to handle the request.
Apache/1.3.41 Server at lorigiles.com Port 80

3 Aug 2009, 7:45 PM
#12
drbyte avatar

drbyte

Sensei

Join Date:
Jan 2004
Posts:
63,515
Plugin Contributions:
176

Re: Cannot connect to database anymore

What error details are showing in your webserver's apache errorlog?
What is your hosting company saying when you ask them about it?

.
Zen Cart - putting the dream of business ownership within reach of anyone!
Donate to: DrByte directly or to the Zen Cart team as a whole

Remember: Any code suggestions you see here are merely suggestions. You assume full responsibility for your use of any such suggestions, including any impact ANY alterations you make to your site may have on your PCI compliance.
Furthermore, any advice you see here about PCI matters is merely an opinion, and should not be relied upon as "official". Official PCI information should be obtained from the PCI Security Council directly or from one of their authorized Assessors.

3 Aug 2009, 7:45 PM
#13
travel124 avatar

travel124

Zen Follower

Join Date:
Mar 2006
Location:
White Pigeon, MI
Posts:
160
Plugin Contributions:
0

Re: Cannot connect to database anymore

ok so now I am at least getting a page. The fresh install page.

http://www.---lorigiles---com/index.php

Shouldn't I have a folder that points to say a store? My catalog?

3 Aug 2009, 7:58 PM
#14
travel124 avatar

travel124

Zen Follower

Join Date:
Mar 2006
Location:
White Pigeon, MI
Posts:
160
Plugin Contributions:
0

Re: Cannot connect to database anymore

error log,

I have asked my host. They told me they cannot help with Zencart issues.

[Mon Aug 3 12:56:37 2009] [error] Access to file /home/#####/.htaccess denied by server: not a regular file

3 Aug 2009, 8:00 PM
#15
drbyte avatar

drbyte

Sensei

Join Date:
Jan 2004
Posts:
63,515
Plugin Contributions:
176

Re: Cannot connect to database anymore

travel124:

[Mon Aug 3 12:56:37 2009] [error] Access to file /home/#####/.htaccess denied by server: not a regular file
Okay, that could easily appear if you were trying to access your .htaccess file from your browser.

But, if you're getting 404 or 403 or 500 errors, those should also be showing up in the logs.

.
Zen Cart - putting the dream of business ownership within reach of anyone!
Donate to: DrByte directly or to the Zen Cart team as a whole

Remember: Any code suggestions you see here are merely suggestions. You assume full responsibility for your use of any such suggestions, including any impact ANY alterations you make to your site may have on your PCI compliance.
Furthermore, any advice you see here about PCI matters is merely an opinion, and should not be relied upon as "official". Official PCI information should be obtained from the PCI Security Council directly or from one of their authorized Assessors.

3 Aug 2009, 8:02 PM
#16
travel124 avatar

travel124

Zen Follower

Join Date:
Mar 2006
Location:
White Pigeon, MI
Posts:
160
Plugin Contributions:
0

Re: Cannot connect to database anymore

I saw that and deleted it, it did not belong there. I am getting the Zencart Fresh install for some reason. My whole store is gone!

3 Aug 2009, 8:04 PM
#17
drbyte avatar

drbyte

Sensei

Join Date:
Jan 2004
Posts:
63,515
Plugin Contributions:
176

Re: Cannot connect to database anymore

The fresh-install screens only appear if the contents of the configure.php files are bad, missing, or have content that points to invalid paths. Or if the permissions you've set on the files are too low/restrictive.

.
Zen Cart - putting the dream of business ownership within reach of anyone!
Donate to: DrByte directly or to the Zen Cart team as a whole

Remember: Any code suggestions you see here are merely suggestions. You assume full responsibility for your use of any such suggestions, including any impact ANY alterations you make to your site may have on your PCI compliance.
Furthermore, any advice you see here about PCI matters is merely an opinion, and should not be relied upon as "official". Official PCI information should be obtained from the PCI Security Council directly or from one of their authorized Assessors.

3 Aug 2009, 8:06 PM
#18
travel124 avatar

travel124

Zen Follower

Join Date:
Mar 2006
Location:
White Pigeon, MI
Posts:
160
Plugin Contributions:
0

Re: Cannot connect to database anymore

did you see my original post?

I had my files under public/shoppe and everything worked fine except my directory was showing. I posted as why my directory was showing and the fella said I needed to move my files up under the public folder. So I did. I doing so I had to edit my config files and everything has gone haywire since...lol

I have months of work stored away in my database.

3 Aug 2009, 8:10 PM
#19
drbyte avatar

drbyte

Sensei

Join Date:
Jan 2004
Posts:
63,515
Plugin Contributions:
176

Re: Cannot connect to database anymore

Yes, I read the entire dialog, a few times.

Is there anything in the FAQ on the topic of moving from one folder to another that you might have missed? https://www.zen-cart.com/tutorials/index.php?article=122

.
Zen Cart - putting the dream of business ownership within reach of anyone!
Donate to: DrByte directly or to the Zen Cart team as a whole

Remember: Any code suggestions you see here are merely suggestions. You assume full responsibility for your use of any such suggestions, including any impact ANY alterations you make to your site may have on your PCI compliance.
Furthermore, any advice you see here about PCI matters is merely an opinion, and should not be relied upon as "official". Official PCI information should be obtained from the PCI Security Council directly or from one of their authorized Assessors.

3 Aug 2009, 8:11 PM
#20
travel124 avatar

travel124

Zen Follower

Join Date:
Mar 2006
Location:
White Pigeon, MI
Posts:
160
Plugin Contributions:
0

Re: Cannot connect to database anymore

I did not read that I just moved them from shoppe/public_html

Moved them up one folder.