By hectorplus on

I am getting this error almost everywhere:

Warning: Access denied for user: 'yeyiebc@%' to database 'userdb_55734_2' query: LOCK TABLES cache WRITE in /.../.../.../.../drupal/includes/database.mysql.inc on line 120

And this too:

* warning: Cannot modify header information - headers already sent by (output started at /.../.../.../.../drupal/includes/database.mysql.inc:120) in /.../.../.../.../drupal/includes/common.inc on line 139.
* user warning: Access denied for user: 'yeyiebc@%' to database 'userdb_55734_2' query: LOCK TABLES variable WRITE in /.../.../.../.../drupal/includes/database.mysql.inc on line 120.

I have read in the forum that this is a hosting issue. Can anyone confirm? I thought it was some kind of read write privileges so i turned on the 777 on this file: the /.../.../.../.../drupal/includes/database.mysql.inc:120, i am still getting the error.

I am getting lots of warnings and writes and locks, in the databse.mysql.inc and common.inc files.

Is this a hosting provider issue? Thanks in advance!

⋅ Categories: Drupal 4.7.x

Comments

paddy_deburca’s picture

paddy_deburca commented

You need to ask your hosting provider if it is possible to have LOCK TABLE permission. When Drupal can't lock the sequence tables, Drupal can't guarantee unique ID for nodes. So on a high traffic site with multiple content authors, a Drupal installation without LOCK TABLE support could result in corruption of some nodes.

Paddy.

http://deburca.org, and http://amadain.net

Paddy.

http://deburca.org

tidalx3’s picture

tidalx3 commented

We are talking about the privileges of the database user(username), not the files.
During installation, there is a note requiring you to 'grant all privileges' to your database user of your database.
Doing that should allow the database user lock tables privilege and prevent the error.

usually you need to be login in as admin for your sql server to do grant those privileges.

Most use ssh. But sometimes depending on your hosting control panel, you can easily use the panel to login as the sql admin and grant privileges to the database user.

Ask your hosting provider about that.

-tidalx

hectorplus’s picture

hectorplus commented

I have solved this issue now, i had to contact my hosting provider, they were happy to help me out.

Tecito.com
Comunidad Latina en Canada.

marvinf’s picture

marvinf commented

I'm having the same problem. My host is godaddy; I've just sent them an email asking for global LOCK TABLES privileges. I'm a total newb to Drupal and I'm not what I would consider technically skilled when it comes to web administering. Most of my work is done via cut and paste style skills. I could be considered very skilled at using a search engine to help me find what I'm looking for. But, I lack any coding skills beyond very basic html. I am curious if godaddy is a good hosting solution for someone like myself that just wants a dependable, cheap, personal web page that may include space for my game friends. I'd like to see what hosts people are using for their hosting solutions and how their hosts have handled certain issues; ones similar to mine.

Update

Godaddy responded as such follows:

Our support staff has responded to your request, details of which are described below:


Discussion Notes

Support Staff Response

Dear Marvin,

Thank you for contacting customer support. I am very sorry as we are not able to grant any extra privileges. We are also not able to provide any troubleshoointg or service support for 3rd party software. For further assistance you may wish to search the internet via something such as www.googel.com or you can also search "help.godaddy.com". Once again I am sorry for any trouble that this has caused you.

Thank you,

Godaddy Rep.

Customer Inquiry

Name: Marvin

Email: (Bleep)

Phone #: (Bleep)

Domain: www.marvinf.com

Customer #: (Bleep)

Last 4 of CC#: (Bleep)

Reseller Id: 1

Reseller: GoDaddy.com

Product:

Question:

In uploading and configuring Drupal (my CMS) I've encountered the following error: "user warning: Access denied for user: 'user@%' to database 'user' query: LOCK TABLES cache WRITE in /home/content/u/s/e/user/html/includes/database.mysql.inc on line 120." This error is caused because I do not have global lock-table privileges for my database/name user/user. Can I please have godaddy grant me the privileges; or would you please explain to me how I am supposed to set privileges myself?

Gratefully,

Marvin Fowler


________________________________


If you need further assistance with this matter, please reply to this email or contact customer service at (480) 505-8877 and reference [Incident ID: Bleep].

Thanks,

GoDaddy.com

© 2006 GoDaddy.com. All rights reserved.

heine’s picture

heine commented

You can forget using Drupal on Godaddy shared hosting, indeed because you do not have LOCK table privileges. Consider moving hosts or switch to another CMS (depending on your needs Wordpress may cut it).
--
When your problem is solved, please post a follow-up to the thread you started.

marvinf’s picture

marvinf commented

Forget it

Heine - May 15, 2006 - 06:29

You can forget using Drupal on Godaddy shared hosting, indeed because you do not have LOCK table privileges. Consider moving hosts or switch to another CMS (depending on your needs Wordpress may cut it).

--

When your problem is solved, please post a follow-up to the thread you started.

That is a shame. I'll check out the suggested CMS, I'm only goofing around with my website; it's just a hobby. I'd like to offer my gaming team mates somewhere for our clan site. I'm so broke right now that it's not practical for me to go with another hosting solution. I've only had my godaddy hosting package for a few days now; I wonder if they offer a money back guaruntee. The response time on the email was super fast; I suppose considering the hour they're not real busy.
Thanks,
MarvinF

paddy_deburca’s picture

paddy_deburca commented

I, too, have a hst that has not given me LOCK TABLES privilege. I also have lo traffic websites and am willing to take the risk of possible data corruption by removing the LOCK TABLES code from drupal.

http://drupal.org/node/40774 shows the code that I used - it seems that it is also used by someone else.

Paddy.

http://deburca.org, and http://amadain.net

Paddy.

http://deburca.org

anner’s picture

anner commented

It may have been how you asked. You say you asked for global table locking permissions. I wouldn't have granted you that either. You may want to as for all permissions for YOUR db. Since it is your db for your site, you should be able to have these permissions for that specific db. If not, I'd move hosts, since this will be a necessary capability for most cms tools.

heine’s picture

heine commented

Godaddy is a recurring provider with regard to LOCK tables on this forum. They never grant this permission on their (cheaper?) shared accounts.

--
When your problem is solved, please post a follow-up to the thread you started.

marvinf’s picture

marvinf commented

In response to godaddy's refusal I sent the following email:
<Begin to godaddy>
I do not have global lock-table privileges for my database/name user/name. I have been informed by a godaddy representative that you guys do not "grant any extra privileges". Would you please tell me why godaddy refuses to grant me these privileges?

I do reviews from time to time and I'm hoping to resolve this problem in order to help me correlate my otherwise satisfied opinion of godaddy's services. I hope to, at least, receive an explanation of why godaddy does not offer these privileges which bring me more security. I can bypass global lock-table privileges at the expense of security.</End to godaddy>


Anner; I asked for "global lock-table privelges for my database/name". What did I say wrong? I am a total newb, I'm not being argumentative. I'm just asking. When I replied to godaddy's reply I did accuse them of refusing me the service but only because I intend on reviewing their service as I've interpretted it and I want them to be aware of that. If I'm misinterpretting it and you see my ignorance then please enlighten me. I do see how my response email could be misconstrued because I was not as clear what privileges I wanted.
Thanks,
MarvinF

hectorplus’s picture

hectorplus commented

You need global lock table permission. they should help you out even if you did not explain yourself clearly, a good hosting provider should help you clafify your question.

I am with ehosting.ca, i am not afiliated with them, i have been using their service for about 5 years now, i have several clients in a shared hosting, they are pretty good. And they are cheap.

When i asked them to set the required permissions for my tables, they did so, and when i asked them for MySQL 4.x, they answered my requests. So far so good!


tecito.com


Comunidad Latina en Canada, regístrate ya! Join the growing latin community in Canada.

marvinf’s picture

marvinf commented

First before I post the email response I recieved I would like to thank you guys for your feedback. I'm currently trying another cms called php-fusion. I've not had the same problem with it but I'm not so sure that's a good thing considering the reply I've recieved from godaddy:
Our support staff has responded to your request, details of which are described below:

Discussion Notes
Support Staff Response
Dear Marvin,

Thank you for contacting Customer Support.

We do not allow the LOCK command on our MySQL servers as the command can strain the integrity of our servers and network. I apologize for any inconvenience this may cause.

Thank you,
godaddy rep.

Customer Inquiry
Name: Marvin
Email: (bleep)
Phone #: (bleep)
Domain: www.marvinf.com
Customer #: (bleep)
Last 4 of CC#: (bleep)

Reseller Id: 1
Reseller: GoDaddy.com

Product:

Question:
I do not have global lock-table privileges for my database/name user/user. I have been informed by a godaddy representative that you guys do not "grant any extra privileges". Would you please tell me why godaddy refuses to grant me these privileges?

I do reviews from time to time and I'm hoping to resolve this problem in order to help me correlate my otherwise satisfied opinion of godaddy's services. I hope to, at least, receive an explanation of why godaddy does not offer these privileges which bring me more security. I can bypass global lock-table privileges at the expense of security.

anner’s picture

anner commented

No it's right...I thought you just asked for global lock-table privileges...on all. I personally don't see how allowing you to lock your own database affects them or their other services in any way, but I suppose that's their choice.

Zdenda’s picture

Zdenda commented

I was getting this error after I truncate my CACHE table. After a while everything was O.K. So if someone reads this, has this problem and just truncate his cache table ... don't worry :)

promatow’s picture

promatow commented

Hi all,
I've just end up doing tests on GoDaddy free test service. Drupal was doing so fine, that I decided to move to paid version (good for me - only paid for 2 months :)).

Everytink is FINE on free/tests hosting platform !!!!
Described problem occures only on PAID ones. So don't take seriously demo version (another $MS???)...

Br,
Patryk.

ben finklea’s picture

ben finklea commented

SpryDev Online Marketing

I'm hosting a customer's site with StartLogic. Apparently a lot of customers are trying to use drupal these days and they set up a procedure just for drupal users to grant LOCK TABLE. Just call the tech support number, tell them you're using drupal and you need LOCK TABLE access and they'll do it for you.

Don't look for any other solution until you've tried to contact your host!

For all you that are panning GoDaddy or your own host won't do it...switch. And tell your old host why. Mention drupal. It won't help you but eventually they'll get the message and it may help someone down the road. Besides, hosts are a dime a dozen! Just pick a different one and go. You're not married to your host!

--Ben Finklea, CEO
Volacci

TheVeech’s picture

TheVeech commented

Access is in the process of being granted. Spry* was right: try asking before you make any drastic decisions to switch hosts on this basis.

walrex’s picture

walrex commented

I just installed successful (druapl 4.7.3 with database.4.0.mysql) & (drupal 5.0 cvs -head) its working fine now on godaddy. I followed the instruction on from this comment http://drupal.org/node/72477#comment-149619 . i think they allow to have lock table in the database now but i am not sure of it.
but still haven't tested everything module . i think also the search module Search doesn't work because needs to Create Temporaly Table which they don't allow in the database but i haven't tested it moudle yet. Iam try to make clean url work but its not wokring the drupal is installed in a folder. i haven't set a subdomain. I'll see how its goes

Kozmick’s picture

Kozmick commented

Thought you might find this response from GD 'interesting' on 11-06-06

Level of service:

Economy Shared: 25 max Mysql DB
50 Mysql table simultaneous users OK, then front end error message to webuser.

Deluxe Shared ( my level):
100 simultaneous users...*according to them*, no problem with 'locking tables'
then front end error message to webuser.

Premium Shared:
150 simultaneous
then front end error message to webuser.

Virtual Dedicated/Dedicated Server:

"Theoretically unlimited" database open/users

Mick

lutchrd’s picture

lutchrd commented

I'm not sure I understand the content of the post or the relevance to the problem about LOCKING TABLES (by Kozmick). Is it that Godaddy are now allowing locking tables? What has locking tables to do with Deluxe or Premium shared hosting accounts?