Author Topic: DB Error: insufficient permissions [solved] (Read 16543 times)

sdragnev · May 10, 2013, 09:55:22 am

I'm using 4.3.2 and I'm getting a "DB Error: insufficient permissions" error when trying to create any record in CiviCRM. So far tested creating a new contact and new event.
The event does end up being created, the contact does not.

The civicrm db is called dev_civicrm, the user is dev_civicrm as well.
Here's the grants that mysql has:

Code: [Select]

mysql> show grants for dev_civicrm@localhost;
+--------------------------------------------------------------------------------------------------------------------+
| Grants for dev_civicrm@localhost                                                                                   |
+--------------------------------------------------------------------------------------------------------------------+
| GRANT USAGE ON *.* TO 'dev_civicrm'@'localhost' IDENTIFIED BY PASSWORD '*yadayada' |
| GRANT ALL PRIVILEGES ON `dev_civicrm`.* TO 'dev_civicrm'@'localhost'                                               |
+--------------------------------------------------------------------------------------------------------------------+

I've cleared drupal and civicrm caches (civicrm/clearcache).

Suggestions?
It's something silly but I can't figure out what.

sdragnev · May 10, 2013, 11:45:49 am

Figured it out.
The db was a dump from another user/db and everything was fine but there were database triggers that used the old username so it was trying to write to the db using that.

osxxso · August 30, 2013, 03:21:02 am

Could you reply with details on how to this fix the trigger issue? Thanks in advance.

sdragnev · August 30, 2013, 05:42:59 am

In my case, I opened the database dump and searched and replaced the old database name with the new name I'm importing into.

You're having the same issue only if you're importing into a database with a different name than the old one.
If that's not the case, the problem is elsewhere (most likely not enough permissions for the db user).

JohnFF · August 30, 2013, 06:29:30 am

The other issue that I've had with mysqldump was when I had some, but not all, of the permissions. The one I was missing was "Show View"

Chris Burgess · October 11, 2014, 09:14:41 pm

Quick instructions: http://forum.civicrm.org/index.php/topic,34456.0.html

CiviCRM Community Forums (archive)

News:

Author Topic: DB Error: insufficient permissions [solved] (Read 16543 times)

sdragnev

DB Error: insufficient permissions [solved]

sdragnev

Re: DB Error: insufficient permissions

osxxso

Re: DB Error: insufficient permissions [solved]

sdragnev

Re: DB Error: insufficient permissions [solved]

JohnFF

Re: DB Error: insufficient permissions [solved]

Chris Burgess

Re: DB Error: insufficient permissions [solved]