Ansible Installing Python Mysql Connector

Question

I'm using Ansible to automate the tasks to backup a mysql database and when running the mysql_db tasks I'm getting this message: msg: the python mysqldb module is required

So, after to many attempts to install python-mysqldb using Ansible tasks I've tried to install it manually executing the command sudo apt-get install python-mysqldb and I got the following error message:

Reading package lists... Done
Building dependency tree
Reading state information... Done
E: Unable to locate package python-mysqldb

I'm using Ubuntu 13.04 64bits

What am I doing wrong?

What's the way to install python-mysqldb using apt-get?

Answer 1

Ubuntu 13.04 has been end-of-lifed for about 10 months. As the link says, "No more package updates will be accepted to 13.04". You should use Ubuntu 12.04 or Ubuntu 14.04, which are LTS (long-term support) versions.

Still, for this specific problem, as @phantom said, use pip.

- pip: name=MySQL-python

(note the capitalization)