I am getting the following error when trying to clone an existing site. I have cloned over a dozen sites in the past and have not had this issue before.

Database import failed: ERROR 1044 (42000) at line 1265: Access denied for user 'rockrivernameles'@'localhost' to database 'oaksnamelessnetw'

rockrivernameles is the new user account created for the clone. I am not sure why that account needs access to the original DB since the database was already dumped.

I should note that I am cloning a site that is running CiviCRM.

Any help or direction would be great appreciated.

Thanks!

Comments

sleewok created an issue. See original summary.

sleewok’s picture

sleewok CreditAttribution: sleewok commented
Issue summary: View changes
helmo’s picture

helmo CreditAttribution: helmo as a volunteer and at Initfour websolutions for Aegir Cooperative commented

Sorry for the late response ... we haven't found time investigate yet. I'll ask around.

bgm’s picture

bgm CreditAttribution: bgm at Coop SymbioTIC commented

It's probably caused by the mysql triggers that are added by CiviCRM.

- Can you dump the database and look for "DEFINER"?
- What version of MySQL/MariaDB?

Normally they get automatically removed, but maybe your version of mysql is generating an unsupported syntax.

I'm on MariaDB 10.2 + CiviCRM (& multilingual, which has a lot of views/triggers), and no issues there.

Shwele’s picture

Shwele CreditAttribution: Shwele commented

Tested on aegir hostmaster-7.x-3.151 , cloning process worked.

Using CiviCRM with apache, mysql and php.

BGM as per our agreement you can close this topic as cloning process is working as intended.

bgm’s picture

bgm CreditAttribution: bgm at Coop SymbioTIC commented
Status: Active » Closed (works as designed)

Thanks for the feedback.