tsuru / mysqlapi

MySQL service API for tsuru PaaS.
BSD 3-Clause "New" or "Revised" License
14 stars 18 forks source link

Failed to bind the instance: mysqlapi #41

Open drpdishant opened 5 years ago

drpdishant commented 5 years ago

Configured mysql server, mysqlapi application, and mysqlapi service properly Able to create a new db instance using tsuru service-instance-create mysqlapi instance_name But whenever I try to bind the instance with an existign app it throws this error. Error: Failed to bind the instance "mysqlapi/tsuru_wp" to the app "wordpress": invalid response: Using GRANT statement to modify existing user's properties other than privileges is deprecated and will be removed in future release. Use ALTER USER statement for this operation. (code: 500) ("tsuru_wp" is up)

I believe that it is because we are trying to create user using grant command in file (mysqlapi/models.py) ( line 87) which would create user and grant specified permissions on a database directly. But the tsuru error shows it is deprecated.

However, when I execute same command on mysql server's prompt, it shows warning but also creates user and grants privileges. I am trying to resolve , but don't know how, please help. I want to execute create user first and then grant upon execution of bind command.