By VladoTesanovic on

Hi i have problem with my site: www.peggy-jahorina.ba

Look error message at the bottom of the page:

Warning: INSERT command denied to user 'peggy1'@'hosting3.teol.net' for table 'watchdog' query: INSERT INTO watchdog (uid, type, message, variables, severity, link, location, referer, hostname, timestamp) VALUES (0, 'php', '%message in %file on line %line.', 'a:4:{s:6:\"%error\";s:12:\"user warning\";s:8:\"%message\";s:298:\"INSERT command denied to user 'peggy1'@'hosting3.teol.net' for table 'sessions'\nquery: INSERT INTO sessions (sid, uid, cache, hostname, session, timestamp) VALUES ('aba955c2ed321e64bcb647ec54483a71', 0, 0, '94.250.13.147', '', 1224343019)\";s:5:\"%file\";s:49:\"/home/web/docs/domains/peggi/includes/session.inc\";s:5:\"%line\";i:73;}', 3, '', 'http://www.peggy-jahorina.ba/', 'http://www.peggy-jahorina.ba/admin', '94.2 in /home/web/docs/domains/peggi/includes/database.mysql.inc on line 128

How can i resolv it?

Comments

VladoTesanovic’s picture

VladoTesanovic commented

I think my mysql database is full, but i can't contact hosting provider today.

WorldFallz’s picture

WorldFallz commented

Yeah-- i was gonna suggest that-- another option to look at is make sure the user for the db still has the appropriate permissions.

===
"Give a man a fish and you feed him for a day. Teach a man to fish and you feed him for a lifetime." - Lao Tzu
"God helps those who help themselves." - Ben Franklin
"Search is your best friend." - Worldfallz

xuan’s picture

xuan commented

Hello!

I have the same problem. http://drupal.org/node/335315

Have you solved?

I have the same problem and need help.

Thank you.

mpaler’s picture

mpaler commented

did you resolve this problem?

Civicsolar
http://www.civicsolar.com

isaacbowman.com’s picture

isaacbowman.com commented

I had the same issue; I couldn't login and the error same as above. I have a hosted service on the site with issues so I logged into mysql and cleared out some of the cache and watchdog tables.

NOTE: this was not immediately fixed. I tied several times to login after clearing the tables but only got in about 10-15min later. I am guessing that the hosted service had a delay of some sort.

JohnOSnewcastle’s picture

JohnOSnewcastle commented

I've emptied cache and watchdog and still having the same problem.

Warning: INSERT command denied to user 'dbo240347556'@'212.227.114.137' 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:559:\"INSERT command denied to user 'dbo240347556'@'212.227.114.137' 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:13:\\"Administrator\\";}', 5, '', 'http://www.meatlicence.org.uk/?q=blog&destination=blog', 'http://www.meatlicence in /homepages/7/d204933261/htdocs/meatlicense/includes/database.mysql.inc on line 128

Warning: INSERT command denied to user 'dbo240347556'@'212.227.114.137' 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:153:\"Cannot modify header information - headers already sent by (output started at /homepages/7/d204933261/htdocs/meatlicense/includes/database.mysql.inc:128)\";s:5:\"%file\";s:63:\"/homepages/7/d204933261/htdocs/meatlicense/includes/session.inc\";s:5:\"%line\";i:101;}', 3, '', 'http://www.meatlicence.org.uk/?q=blog&destination=blog', 'http://www.meatlicence.org.uk/', '128.240.229.65', 1261167253) in /homepages/7/d204933261/htdocs/meatlicense/includes/database.mysql.inc on line 128

Warning: INSERT command denied to user 'dbo240347556'@'212.227.114.137' 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:63:\"/homepages/7/d204933261/htdocs/meatlicense/includes/session.inc\";s:5:\"%line\";i:104;}', 3, '', 'http://www.meatlicence.org.uk/?q=blog&destination=blog', 'http://www.meatlicence.org.uk/', '128.240.229.65', 1261167253) in /homepages/7/d204933261/htdocs/meatlicense/includes/database.mysql.inc on line 128

Warning: INSERT command denied to user 'dbo240347556'@'212.227.114.137' 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:1023:\"INSERT command denied to user 'dbo240347556'@'212.227.114.137' for table 'sessions'\nquery: INSERT INTO sessions (sid, uid, cache, hostname, session, timestamp) VALUES ('390bfec79f2a6217a3adc5acd872440d', 1, 0, '128.240.229.65', 'messages|a:1:{s:5:\\"error\\";a:3:{i:0;s:659:\\"user warning: INSERT command denied to user 'dbo240347556'@'212.227.114.137' for table 'watchdog'\\nquery: INSERT INT in /homepages/7/d204933261/htdocs/meatlicense/includes/database.mysql.inc on line 128

Warning: INSERT command denied to user 'dbo240347556'@'212.227.114.137' 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:153:\"Cannot modify header information - headers already sent by (output started at /homepages/7/d204933261/htdocs/meatlicense/includes/database.mysql.inc:128)\";s:5:\"%file\";s:62:\"/homepages/7/d204933261/htdocs/meatlicense/includes/common.inc\";s:5:\"%line\";i:319;}', 3, '', 'http://www.meatlicence.org.uk/?q=blog&destination=blog', 'http://www.meatlicence.org.uk/', '128.240.229.65', 1261167253) in /homepages/7/d204933261/htdocs/meatlicense/includes/database.mysql.inc on line 128

My database is hosted by 1&1 and the maximum storage space is 100MB per database - my database has grown to 151.85 MB and I have no idea why...

I have tried: http://drupal.org/node/335315

GRANT ALL PRIVILEGES ON *.* TO 'dbo240347556'@'212.227.114.137' IDENTIFIED BY 'EnterThePasswordForDBO239605Here';

But

MySQL said:

#1054 - Access denied for user 'dbo240347556' @ '%' (using password: YES)

Don't really know what to try now - PLEASE HELP!

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