Hi all,
I've been working with Ansible as I try to set up a specific configuration
for Open EdX (the open source MOOC) to work with MySQL hosted by Amazon's
RDS service.
At one point in the Open EdX ansible plays, it tries to create an "admin"
user and assign "CREATE USER" privileges to it
mysql_user:
name: "admin"
password: "some password for admin user"
priv: "*.*:CREATE USER"
login_host: "some RDS Mysql host url"
login_user: "some root user"
login_password: "some root password"
However, when this play runs, Ansible fails with the following message:
failed: [localhost] => {"failed": true}
msg: (1045, "Access denied for user 'root'@'%' (using password: YES)")
FATAL: all hosts have already failed -- aborting
I then read that when using Ansible with RDS, you can't use the *.*
selection mechanism, but rather have to use %.* ... and I've used that
successfully in another part of the Ansible script to assign ALL privileges.
But when I update this play to have priv: "%.*:CREATE USER" I then get the
error
failed: [localhost] => {"failed": true}
msg: (1221, 'Incorrect usage of DB GRANT and GLOBAL PRIVILEGES')
FATAL: all hosts have already failed -- aborting
Any thoughts on assigning CREATE USER privileges to a user in RDS via
Ansible?
Thanks.
Daniel
--
You received this message because you are subscribed to the Google Groups
"Ansible Project" group.
To unsubscribe from this group and stop receiving emails from it, send an email
to [email protected].
To post to this group, send email to [email protected].
To view this discussion on the web visit
https://groups.google.com/d/msgid/ansible-project/2b2f7bee-4756-4c6d-97e0-2b7aab6cb52c%40googlegroups.com.
For more options, visit https://groups.google.com/d/optout.
