ERPNext Foundation ERPNext Cloud User Manual Blog Discuss Frappé* Donate

ERPNext Installation in RDS AURORA MySQL


#1

I managed to install successfully ERPNext in RDS Aurora MySQL. I had to configure the Parameter Groups to fit the requirements of the ERPNext database. Also I had to modify some sql statements that Frappe use to create some tables because RDS Aurora doesn’t support large primary keys when COMPRESSED format is used in table creation. Also RDS doesn’t support GRANT ALL PERMISSION, so I had to change the statement that gives permission to the user. I made some modifications in frappe to allow the SSL connection whit RDS because Amazon only provides a bundle certificate, I changed the mysql connection string to only use this certificate and it works correctly. I was thinking in make a pull request to Frappe but I’m not sure if I can do it to master.


#2

Can you share your script. Thanks