_mysql.c:1915:41: error: ‘MYSQL’ has no member named ‘reconnect’ (centos 7 python 2/3 mariadb 10.x compilation)

[kseltar]

• OS: centos 7.(5/x)
  *devenvs: MariaDB 10.x + python 2.x/3.x

• default output:
  _mysql.c: En la función ‘_mysql_ConnectionObject_ping’:
  _mysql.c:1915:41: error: ‘MYSQL’ no tiene un miembro llamado ‘reconnect’
  if ( reconnect != -1 ) self->connection.reconnect = reconnect;
  ^
  error: command 'gcc' failed with exit status 1

• how to fix

sed '/st_mysql_options options;/a unsigned int reconnect;' /usr/include/mysql/mysql.h -i.bkp

source: DefectDojo/django-DefectDojo#407

[Arti3DPlayer]

the same

did:
yum install mariadb-devel python-devel
yum install MariaDB-devel MariaDB-shared

then:

pip install MySQL-python

    building '_mysql' extension
    creating build/temp.linux-x86_64-2.7
    gcc -pthread -fno-strict-aliasing -O2 -g -pipe -Wall -Wp,-D_FORTIFY_SOURCE=2 -fexceptions -fstack-protector-strong --param=ssp-buffer-size=4 -grecord-gcc-switches -m64 -mtune=generic -D_GNU_SOURCE -fPIC -fwrapv -DNDEBUG -O2 -g -pipe -Wall -Wp,-D_FORTIFY_SOURCE=2 -fexceptions -fstack-protector-strong --param=ssp-buffer-size=4 -grecord-gcc-switches -m64 -mtune=generic -D_GNU_SOURCE -fPIC -fwrapv -fPIC -Dversion_info=(1,2,5,'final',1) -D__version__=1.2.5 -I/usr/include/mysql -I/usr/include/mysql/mysql -I/usr/include/python2.7 -c _mysql.c -o build/temp.linux-x86_64-2.7/_mysql.o
    In file included from _mysql.c:44:0:
    /usr/include/mysql/my_config.h:3:2: warning: #warning This file should not be included by clients, include only <mysql.h> [-Wcpp]
     #warning This file should not be included by clients, include only <mysql.h>
      ^
    _mysql.c: In function '_mysql_ConnectionObject_ping':
    _mysql.c:2005:41: error: 'MYSQL' has no member named 'reconnect'
      if ( reconnect != -1 ) self->connection.reconnect = reconnect;
                                             ^
    error: command 'gcc' failed with exit status 1