By xuan on

Hello!

Anybody can help me?
I have a big problem on the website of the college (www.colegiocampoamor.es). To identify it can not gain access to administration and gives this error:

Warning: INSERT command denied to user 'dbo239605'@'212.227.114.79' for table 'watchdog' query: INSERT INTO watchdog (uid, type, message, variables, severity, link, location, referer, hostname, timestamp) VALUES (1, 'php', '%message in %file on line %line.', 'a:4:{s:6:\"%error\";s:12:\"user warning\";s:8:\"%message\";s:535:\"INSERT command denied to user 'dbo239605'@'212.227.114.79' for table 'watchdog'\nquery: INSERT INTO watchdog\n (uid, type, message, variables, severity, link, location, referer, hostname, timestamp)\n VALUES\n (1, 'user', 'Session opened for %name.', 'a:1:{s:5:\\"%name\\";s:5:\\"admin\\";}', 5, '', 'http://www.colegiocampoamor.es/?q=user', 'http://www.colegiocampoamor.es/?q=user', &#0 in /homepages/0/d220041639/htdocs/includes/database.mysqli.inc on line 128

Warning: INSERT command denied to user 'dbo239605'@'212.227.114.79' for table 'watchdog' query: INSERT INTO watchdog (uid, type, message, variables, severity, link, location, referer, hostname, timestamp) VALUES (1, 'php', '%message in %file on line %line.', 'a:4:{s:6:\"%error\";s:7:\"warning\";s:8:\"%message\";s:142:\"Cannot modify header information - headers already sent by (output started at /homepages/0/d220041639/htdocs/includes/database.mysqli.inc:128)\";s:5:\"%file\";s:51:\"/homepages/0/d220041639/htdocs/includes/session.inc\";s:5:\"%line\";i:101;}', 3, '', 'http://www.colegiocampoamor.es/?q=user', 'http://www.colegiocampoamor.es/?q=user', '88.151.16.21', 1226920765) in /homepages/0/d220041639/htdocs/includes/database.mysqli.inc on line 128

Warning: INSERT command denied to user 'dbo239605'@'212.227.114.79' for table 'watchdog' query: INSERT INTO watchdog (uid, type, message, variables, severity, link, location, referer, hostname, timestamp) VALUES (1, 'php', '%message in %file on line %line.', 'a:4:{s:6:\"%error\";s:7:\"warning\";s:8:\"%message\";s:154:\"session_regenerate_id() [function.session-regenerate-id]: Cannot regenerate session id - headers already sent\";s:5:\"%file\";s:51:\"/homepages/0/d220041639/htdocs/includes/session.inc\";s:5:\"%line\";i:104;}', 3, '', 'http://www.colegiocampoamor.es/?q=user', 'http://www.colegiocampoamor.es/?q=user', '88.151.16.21', 1226920765) in /homepages/0/d220041639/htdocs/includes/database.mysqli.inc on line 128

Greetings.

⋅ Categories: Drupal 6.x

Comments

gpk’s picture

gpk commented

It looks like the database user dbo239605 doesn't have permission to INSERT into the {watchdog} table, or possibly any table in the database.

Is the $db_url correctly defined in setting.php? Have database permissions been changed?

gpk
----
www.alexoria.co.uk

gpk
----
www.alexoria.co.uk

mpaler’s picture

mpaler commented

did you solve this?

Civicsolar
http://www.civicsolar.com

dan.crouthamel’s picture

dan.crouthamel commented

For me, the problem is that my drupal_cache_page table grew to 150 MB. Now I need to figure out why that is ...

grakhul’s picture

grakhul commented

GRANT ALL PRIVILEGES ON *.* TO 'dbo239605'@'212.227.114.79' IDENTIFIED BY 'EnterThePasswordForDBO239605Here';

Either flush or restart mysql.

by the way 'localhost' much safer than 212.227.114.79

nc.anwar’s picture

nc.anwar commented

I have this problem n i can solve it, only give a owner file for mysql data:

# chown -R mysql.mysql /var/lib/mysql/db_name
# chown -R mysql.mysql /var/lib/mysql/db_name/*

it work for me at Open Suse 11.3

www.jaringankantor.com

Swift Arrow’s picture

Swift Arrow commented

Hi! I had the same problem. Solution was to open my DB in phpmyadmin and EMPTY the watchdog table, and all cache tables. Somehow, those tables contained some 500MB of data (almost 50% of the entire DB), and had gone over the limit.

Hope that works for you.

Solution here: https://drupal.org/node/140206