Bots on Centos 8 with mysql-Python

[KenyonIT]

Hi Everyone,

I have previously been able to run bots with MySQL on Centos 6/7 using the mysql-Python connector, however I have been unsuccessful in getting this to work on Centos 8.

Just wondering if anyone here has been successful in this space? Or if there is an updated mysql connector that will work?

Cheers, John

[Eppye Bots]

I haven using that setup.

kind regards, Henk-Jan Ebbers

--
You received this message because you are subscribed to the Google Groups "Bots Open Source EDI Translator" group.
To unsubscribe from this group and stop receiving emails from it, send an email to botsmail+u...@googlegroups.com.
To view this discussion on the web visit https://groups.google.com/d/msgid/botsmail/f4f84b61-f09e-4470-9298-1a14086d1bden%40googlegroups.com.

[KenyonIT]

This is not an issue with BOTS but I thought I would post my workaround here for historical purpose in case it helps someone else...

When attempting to install the  MySQL-python 1.2.5 module on Centos 8, I got an error: "fatal error: my_config.h: No such file or directory". The missing my_config.h file is normally created upon installing mysql-devel, however upstream MySQL deprecated my_config.h in version 8.0.2, so it is no longer included into official builds. To address this issue, applications should use mysql.h header for building instead... but as the MySQL-python module hasn't had an update since 2014, I decided to work around the issue by manually creating the /usr/include/my_config.h file using the source found here: https://dev.mysql.com/doc/dev/mysql-server/8.0.21/my__config_8h_source.html

Also... after I managed to get MySQL-python installed, I got the following error after login via the BOTS web interface: "SSL routines:ssl_choose_client_version:unsupported protocol". On Centos 8 you can use the following command to relax your encryption settings and provide better compatibility: update-crypto-policies --set LEGACY

More information can be found here: https://access.redhat.com/documentation/en-us/red_hat_enterprise_linux/8/html/security_hardening/using-the-system-wide-cryptographic-policies_security-hardening

[Eppye Bots]

thank you!

kind regards, Henk-Jan Ebbers

To view this discussion on the web visit https://groups.google.com/d/msgid/botsmail/295ebb81-3e7c-48e7-9bdb-78b7ba09fff7n%40googlegroups.com.