[Libreoffice-bugs] [Bug 135202] LO 6.4.6.1 and 7.0.1 fail with error 1045 when accessing MySQL database using native connector

[bugzilla-daemon at bugs.documentfoundation.org]

https://bugs.documentfoundation.org/show_bug.cgi?id=135202

Julien Nabet <serval2412 at yahoo.fr> changed:

           What    |Removed                     |Added
----------------------------------------------------------------------------
                 CC|                            |michael.stahl at cib.de

--- Comment #43 from Julien Nabet <serval2412 at yahoo.fr> ---
Michael: digging into Mariadb sources, I found this in
plugins/auth/CMakeLists.txt
     69   # SHA256 caching plugin for MySQL 8.0 connection
     70   REGISTER_PLUGIN(TARGET caching_sha2_password
     71                 TYPE MARIADB_CLIENT_PLUGIN_AUTH
     72                 CONFIGURATIONS DYNAMIC STATIC OFF
     73                 DEFAULT DYNAMIC
     74                 SOURCES ${CC_SOURCE_DIR}/plugins/auth/caching_sha2_pw.c
     75                         ${CRYPT_SOURCE}
     76                 LIBRARIES ${CRYPT_LIBS})

then searching about CRYPT_SOURCE, I find in the same file:
      7 IF(WIN32)
      8   SET(CRYPT_SOURCE ${CC_SOURCE_DIR}/libmariadb/secure/win_crypt.c)
      9   SET(CRYPT_LIBS crypt32)
     10 ELSEIF(WITH_SSL STREQUAL "OPENSSL")
     11   SET(CRYPT_SOURCE ${CC_SOURCE_DIR}/libmariadb/secure/openssl_crypt.c)
     12   SET(CRYPT_LIBS ${SSL_LIBRARIES})
     13 ELSEIF(WITH_SSL STREQUAL "GNUTLS")
     14   SET(CRYPT_SOURCE ${CC_SOURCE_DIR}/libmariadb/secure/gnutls_crypt.c)
     15   IF (NOT SSL_LIBRARIES MATCHES "^.*\\.a$")
     16     SET(CRYPT_LIBS ${SSL_LIBRARIES})
     17   ENDIF()
     18 ELSE()
     19   UNSET(CRYPTO_PLUGIN)
     20 ENDIF()

My last patch for this bugtracker contained:
add of "UnpackedTarball/mariadb-connector-c/plugins/auth/caching_sha2_pw" in 
external/mariadb-connector-c/StaticLibrary_mariadb-connector-c.mk

but should we do this:
- add UnpackedTarball/mariadb-connector-c/libmariadb/secure/openssl_crypt in
external/mariadb-connector-c/StaticLibrary_mariadb-connector-c.mk
- add "#define WIN32 1" in external/mariadb-connector-c/configs/wnt_ma_config.h
- add "#define HAVE_OPENSSL 1" in
external/mariadb-connector-c/configs/linux_my_config.h and mac_my_config.h
?
since sha2 needs cryptographic libs.
At least it builds locally (pc Debian x86-64 with master sources updated today,
but can't really test since I use MariaDB not MySQL)

MariaDB proposes gnutls but it seems we use more often openssl

-- 
You are receiving this mail because:
You are the assignee for the bug.
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <https://lists.freedesktop.org/archives/libreoffice-bugs/attachments/20201104/6f4a4e1f/attachment.htm>