Installing INSIGHTS: Database Migrate Error

Site Operators Site Operations Help
2

That’s a pretty old guide, and doesn’t use python3, so you might run into many issues there. I don’t know if there’s an updated guide for production deployments, but you can get some clues from the analytics devstack: Getting Started on Analytics

Alternatively, you can consult OpenCraft’s AWS analytics deployments doc, but we haven’t updated it for Juniper/python3 yet either.

You’re correct, that’s the error that’s blocking that step.

So you’ve created the migrate user on your database… have you granted it permissions?

GRANT ALL PRIVILEGES ON `reports`.* TO 'migrate'@'%';
GRANT ALL PRIVILEGES ON `dashboard`.* TO 'migrate'@'%';
GRANT ALL PRIVILEGES ON `analytics-api`.* TO 'migrate'@'%';
FLUSH PRIVILEGES;