Grouper Users - Open Discussion List

[Satya Mohapatra <>]

Hi Chris, 

Thanks for the pointer. It turned out that it was a simple problem with 
database dump. I did it correctly and now I can migrate the database without 
any problem.
 

---
Satya Mohapatra | ସତ୍ୟ ମହାପାତ୍ର |  सत्य महापात्र |  ستیا موہپترا


> On Oct 8, 2019, at 10:13 AM, Hyzer, Chris <> wrote:
> 
> It should work I think... you import without foreign keys enabled, then 
> enable them.   if one doesn’t enable, look at which one it is, and see in 
> table why it wont enable, see if that foreign key was enabled in the 
> previous database, and report back why the data is messed up 😊
> 
> -----Original Message-----
> From:  
> <> On Behalf Of Satya Mohapatra
> Sent: Tuesday, October 08, 2019 10:00 AM
> To: grouper-users <>
> Subject: [grouper-users] foreign key constraint error with grouper database 
> migration between identical grouper version
> 
> Hi, 
> 
> I have a problem with grouper database migration from one system to 
> another.  I am trying to move the backend grouper database from system A 
> —to—> B with identical grouper version and patch applied.  
> 
> While importing the database dumped from system A to system B, I am seeing 
> "Cannot add foreign key constraint” error. I gather it has to do with the 
> different versions of innodb. 
> 
> Is there a way to take care of it via grouper API without really going to 
> the database and fixing those entries ?
> 
> 
> ---------------------------------------------------------------------------
> System [A]
> 
> Grouper version 2.3, at API patch 110. 
> Tomcat version 8. 
> 
> 
> # java -version
> java version "1.7.0_231"
> OpenJDK Runtime Environment (IcedTea 2.6.19) (7u231-2.6.19-1~deb8u2)
> 
> 
> # mysql --version
> mysql  Ver 14.14 Distrib 5.5.62, for debian-linux-gnu (x86_64) using 
> readline 6.3
> 
> 
> mysql> SHOW GLOBAL VARIABLES LIKE 'innodb_ver%';
> +----------------+--------+
> | Variable_name  | Value  |
> +----------------+--------+
> | innodb_version | 5.5.62 |
> +----------------+--------+
> 
> ---------------------------------------------------------------------------
> 
> System  [B]
> 
> Grouper version 2.3, at API patch 110. 
> Tomcat version 9. 
> 
> # java -version
> openjdk version "1.8.0_232-ea"
> 
> # mysql --version
> mysql  Ver 14.14 Distrib 5.7.26, for Linux (x86_64) using  EditLine wrapper
> 
> 
> l> SHOW GLOBAL VARIABLES LIKE 'innodb_ver%’;
> +----------------+--------+
> | Variable_name  | Value  |
> +----------------+--------+
> | innodb_version | 5.7.26 |
> +----------------+--------+
> 
> 
> 
> Thanks,
> ---
> Satya Mohapatra | ସତ୍ୟ ମହାପାତ୍ର |  सत्य महापात्र |  ستیا موہپترا
> 
>

Attachment: smime.p7s
Description: S/MIME cryptographic signature