Page 1 of 1

[Solved] NO GRANT ALL PRIVILEGES

Posted: Thu Feb 28, 2013 4:47 pm
by kmarios
hello, i migrated my CMS (Version 1.11.2.1) to a new host where i don't get GRANT ALL PRIVILEGES .

My current privileges are

SHOW GRANTS FOR CURRENT_USER;

GRANT SELECT, INSERT, UPDATE, DELETE, CREATE, DROP, REFERENCES, INDEX, ALTER, CREATE TEMPORARY TABLES, LOCK TABLES, EXECUTE, CREATE VIEW, SHOW VIEW, CREATE ROUTINE, ALTER ROUTINE, TRIGGER ON `dbname`.* TO 'dbuser'@''

My problem is that i cannot insert/update content ?

any ideas without issuing a GRANT ALL statement, which i am not allowed to ?

Thank you

Re: NO GRANT ALL PRIVILEGES

Posted: Thu Feb 28, 2013 5:04 pm
by calguy1000
Not being able to insert/update content is probably a symptom of a problem with the migration. Not a problem with mysql privileges.

I would suggest enabling debug mode in the config.php and then checking for mysql errors when adding/editing content pages.

Re: NO GRANT ALL PRIVILEGES

Posted: Thu Feb 28, 2013 5:42 pm
by kmarios
i have enabled debug but i am not able to see any errors. the page that i get says
================
Forbidden
You don't have permission to access /admin/editcontent.php on this server.
================

Using other modules eg Blog i am able to insert/update content.

Re: NO GRANT ALL PRIVILEGES

Posted: Thu Feb 28, 2013 6:00 pm
by calguy1000
a 403 error indicates a problem with mod_security.

Contact your host. We don't support mod_security. Ask them to disable it for your domains.

Re: NO GRANT ALL PRIVILEGES

Posted: Thu Mar 07, 2013 4:19 pm
by kmarios
yes you are correct :)