By RobVaughan on
user error: Access denied for user: 'drup@64.202.189.%' to database 'drup'
query: LOCK TABLES sequences WRITE in /home/content/r/e/a/realparadox/html/drup/includes/database.mysql.inc on line 66.I get these errors every time I try and make any configuration change in the administration panel. Also anytime a user registers on the site. Any ideas on what is going wrong? I gave the database.mysql.inc write permissions and execute permissions, and still nothing. The information does go through though it seems, but it still spews errors to screen.
Comments
Your dbase user needs admin
Your dbase user needs admin privs in order to use the LOCK TABLES command.
If you cannot have this permission then you may comment out the lines in includes/database.mysql.inc - but beware, if your site has a lot of traffic - from posts, or if you're running a statistic module which is doing lots of dbase INSERT/UPDATE you will face death with your site.
Happened to me. :-/ and I learnt the lesson...
--
www.bargainspy.co.uk | More Drupal modules
--
Ixis (UK): Drupal support, Drupal hosting.
I'm going through
I'm going through godaddy.com's hosting so I don't think I have admin privaledges...
If I do comment out the section in database.mysql.inc will a module like checkout help in keeping the site from dying? Right now I'm just looking into using drupal for a game development site for the developers of the game so traffic won't be too extreme.
It will be interesting to
It will be interesting to see what feedback you get from GoDaddy. I have had similar problems ( http://drupal.org/node/37510 ).
I've been visiting the MySQL forums hoping someone actually with the MySQL development community can tell me if there are any disadvantages (performance, security, stability, etc) to GoDaddy if they do grant "LOCK TABLES". So far, now feedback.
I've tried the e-mail route so I may next pick up the phone and see if I get anywhere. Maybe we need to start organizing a "give me LOCK TABLES" campaign with GoDaddy?
Currently I've remarked out the lines that (UN)LOCK the tables. This has not been a problem with 4.6.3, but my site is not that busy. I checked the CSV and had some issues with commenting out the lines. I haven't had time to download the latest CSV to see if it was just an "off" night for me to try the development version.
GoDaddy.com issues.
KnowProSE.com is presently offline because MySQL errors cropped up and slammed the CPU on their server, or so they claim. They demanded that I remove 'offending code' (Drupal), and gave me a dump of some insertion of data into the EVENTs table.
I have a strong feeling that the database blew up because of the lack of LOCK and UNLOCK. The Events table isn't an addon, it's STABLE and works quite well with LOCK and UNLOCK.
Meanwhile, my site has been down for going on 3 days, and they won't allow me to login to my database. About 10,000 nodes. Geez.
KnowProSE.com
Gone virtual to get the LOCK
Sorry about the turn of events. If you have a copy of the database error logs, it would be interesting to see a sampling. The developers have all along said that while removing the LOCK/UNLOCK works at the beginning...as your site grows in nodes and activity more issues will develop. Of couse, at this point we're only guessing that it is due to the lack of LOCK/UNLOCK.
I've recently decided to move my sites to a virtual private server (also known as virtual dedicated server). That way, I have full administrative control to what is allowed or not allowed in such things as the database. The price for the server was around $35 per month. Currently a virtual dedicated server is more than I need, but I have a number of projects that I have been wanting to start and this seemed a good time. I'll also have a chance to see how offending or unoffending the code can be. I also think PostGreSQL might be a better database than MySQL to support Drupal so I want to make some comparisions.
-Bryan