Unable to find Protobuf include directory during install mysql-connector over pip

Question

I pulled mysql-connector-python code and when I run python ./setup.py build I get the following error:

Unable to find Protobuf include directory. 

pip install Protobuf was useless

How can I solve this problem?

Answer 1

I found that this error occurs since version 2.2.3. You can avoid this issue using version 2.1.6.

pip install mysql-connector==2.1.6

try above.

Answer 2

As of 2.2.3, Connector/Python uses a C++ extension that interfaces with a MySQL server with the X plugin enabled, using Protobuf as data interchange format.

So, you need to set up where Protobuf is installed on your system (the library, include and protoc binary paths).

Requirements

• A C/C++ compiler, such as gcc
• Protobuf C++ (version >= 2.6.0)
• Python development files

Installation

You have two options when using pip + pypi:

1) Set environment variables for MYSQLXPB_PROTOBUF_INCLUDE_DIR, MYSQLXPB_PROTOBUF_LIB_DIR and MYSQLXPB_PROTOC.

2) Add --install-option to set these options when using pip:

shell> python install mysql-connector --install-option='--with-protobuf-include-dir=<path>' --install-option='--with-protobuf-lib-dir=<path>' --install-option='--with-protoc=<path>' 

Important: Keep in mind that 2.2.3 is a development release.