Forums / Installing on a Linux/Unix Server / problem with db_cache

problem with db_cache

Locked

Started by redbox on 30 Jun 2006, 9:20 PM · Views: 1,772

Results 1 to 5 of 5
This thread is locked. New replies are disabled.
30 Jun 2006, 9:20 PM
#1
redbox avatar

redbox

New Zenner

Join Date:
Jun 2006
Posts:
5
Plugin Contributions:
0

problem with db_cache

I installed Zen Cart yesterday and all seemed fine. I just visited my site for the first time today and received this error:

1142 SELECT command denied to user: 'site_admin@localhost' for table 'db_cache'
in:
[select * from db_cache where cache_entry_name = 'zc_d6616cb5f4c2cb55d422ea67feb723b0']

I then edited the configuration file to change SQL_CACHE_METHOD from 'database' to 'none' hoping that would help, but then I received this message:

1142 SELECT command denied to user: 'site_admin@localhost' for table 'configuration'
in:
[select configuration_key as cfgkey, configuration_value as cfgvalue from configuration]

Does anyone know what I should do to fix this?

Thanks :)

30 Jun 2006, 9:29 PM
#2
drbyte avatar

drbyte

Sensei

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

Re: problem with db_cache

Your database security settings in your hosting control panel aren't set properly.

You need to grant "ALL" or "DBA" privileges to the "site_admin@localhost" or "site_admin" user, using your hosting control panel's database-security menus.

.
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.

30 Jun 2006, 9:39 PM
#3
redbox avatar

redbox

New Zenner

Join Date:
Jun 2006
Posts:
5
Plugin Contributions:
0

Re: problem with db_cache

Thanks for the reply. I have to do it from SSH and this is the command I used (but with the correct info of course) and I just did it again for good measure, but no luck.

grant all on database_name.* to database_user@localhost identified by 'password';

Everything worked fine last night, I set up several categories and products.

30 Jun 2006, 10:15 PM
#4
redbox avatar

redbox

New Zenner

Join Date:
Jun 2006
Posts:
5
Plugin Contributions:
0

Re: problem with db_cache

All's fine now :) I deleted db_cache and recreated it and everything is working.

Loving zen so far :)

7 Jul 2006, 5:27 PM
#5
drbyte avatar

drbyte

Sensei

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

Re: problem with db_cache

As an addendum, alternate syntax could be:> GRANT USAGE ON . TO 'username'@'localhost' IDENTIFIED BY PASSWORD 'blah';

GRANT ALL PRIVILEGES ON databasename.* TO 'username'@'localhost';

.
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.