Arch Linux User Repository

I think I've fixed using a temp openssl 1.1 workaround. It seems to work fine, also after the build (tested in clean chroot + installed in my unclean system with no workarounds)

I downloaded the OpenSSL 1.1 sources. Configured it with --prefix=/opt/openssl, then installed.

Thereafter in the PKGBUILD changed -DWITH_SSL=system to -DWITH_SSL=/opt/openssl and ran makepkg.

Now it works.

You may use the following command to install openssl-1.1

wget https://www.openssl.org/source/old/1.1.1/openssl-1.1.1s.tar.gz
tar -zxvf openssl-1.1.1s.tar.gz
cd openssl-1.1.1s
./config --prefix=/opt/openssl
make && make install

Using Keensay's solution I was able to create the package and install mysql57. However, I had encoding problems importing FCC databases in the FCC's TVStudy program. The solution was to edit the PKGBUILD to change -DDEFAULT_CHARSET=utf8 to -DDEFAULT_CHARSET=latin1 and -DDEFAULT_COLLATION=utf8_general_ci to -DDEFAULT_COLLATION=latin1_swedish_ci.

These match the default configurations shown at https://dev.mysql.com/doc/refman/5.7/en/source-configuration-options.html

I downloaded the OpenSSL 1.1 sources. Configured it with --prefix=/opt/openssl, then installed.

Thereafter in the PKGBUILD changed -DWITH_SSL=system to -DWITH_SSL=/opt/openssl and ran makepkg.

Now it works.

I am using manjaro,

I install yay -S core/openssl-1.1 and add

    -DOPENSSL_INCLUDE_DIR=/usr/include/openssl-1.1 \
    -DOPENSSL_LIBRARY=/usr/lib/libssl.so.1.1 \

to PKGBUILD

and then occur new error.

[ 23%] Built target protobuf
/usr/bin/ld: ../archive_output_directory/libmysys_ssl.a(my_aes_openssl.cc.o): in function `my_aes_encrypt':
/home/danny/.cache/yay/mysql57/src/mysql-5.7.38/mysys_ssl/my_aes_openssl.cc:149: undefined reference to `EVP_CIPHER_iv_length'
/usr/bin/ld: ../archive_output_directory/libmysys_ssl.a(my_aes_openssl.cc.o): in function `my_aes_decrypt':
/home/danny/.cache/yay/mysql57/src/mysql-5.7.38/mysys_ssl/my_aes_openssl.cc:203: undefined reference to `EVP_CIPHER_iv_length'
/usr/bin/ld: ../archive_output_directory/libmysys_ssl.a(my_aes_openssl.cc.o): in function `my_aes_get_size':
/home/danny/.cache/yay/mysql57/src/mysql-5.7.38/mysys_ssl/my_aes_openssl.cc:242: undefined reference to `EVP_CIPHER_block_size'
/usr/bin/ld: ../archive_output_directory/libmysys_ssl.a(my_aes_openssl.cc.o): in function `my_aes_needs_iv':
/home/danny/.cache/yay/mysql57/src/mysql-5.7.38/mysys_ssl/my_aes_openssl.cc:265: undefined reference to `EVP_CIPHER_iv_length'
/usr/bin/ld: ../archive_output_directory/libmysys_ssl.a(my_aes_openssl.cc.o): in function `my_aes_encrypt':
/home/danny/.cache/yay/mysql57/src/mysql-5.7.38/mysys_ssl/my_aes_openssl.cc:149: undefined reference to `EVP_CIPHER_iv_length'
/usr/bin/ld: ../archive_output_directory/libmysys_ssl.a(my_aes_openssl.cc.o): in function `my_aes_decrypt':
/home/danny/.cache/yay/mysql57/src/mysql-5.7.38/mysys_ssl/my_aes_openssl.cc:203: undefined reference to `EVP_CIPHER_iv_length'
/usr/bin/ld: ../archive_output_directory/libmysys_ssl.a(my_aes_openssl.cc.o): in function `my_aes_get_size':
/home/danny/.cache/yay/mysql57/src/mysql-5.7.38/mysys_ssl/my_aes_openssl.cc:242: undefined reference to `EVP_CIPHER_block_size'
/usr/bin/ld: ../archive_output_directory/libmysys_ssl.a(my_aes_openssl.cc.o): in function `my_aes_needs_iv':
/home/danny/.cache/yay/mysql57/src/mysql-5.7.38/mysys_ssl/my_aes_openssl.cc:265: undefined reference to `EVP_CIPHER_iv_length'
collect2: error: ld returned 1 exit status
make[2]: *** [extra/CMakeFiles/resolveip.dir/build.make:107: extra/resolveip] Error 1
make[1]: *** [CMakeFiles/Makefile2:5466: extra/CMakeFiles/resolveip.dir/all] Error 2
make[1]: *** Waiting for unfinished jobs....
collect2: error: ld returned 1 exit status
make[2]: *** [extra/CMakeFiles/my_print_defaults.dir/build.make:107: extra/my_print_defaults] Error 1
make[1]: *** [CMakeFiles/Makefile2:5409: extra/CMakeFiles/my_print_defaults.dir/all] Error 2
[ 23%] Linking CXX executable mysql_tzinfo_to_sql
[ 23%] Linking CXX executable resolve_stack_dump
[ 23%] Linking CXX executable comp_err
[ 23%] Built target mysql_tzinfo_to_sql
/usr/bin/ld: ../archive_output_directory/libmysys_ssl.a(my_aes_openssl.cc.o): in function `my_aes_encrypt':
/home/danny/.cache/yay/mysql57/src/mysql-5.7.38/mysys_ssl/my_aes_openssl.cc:149: undefined reference to `EVP_CIPHER_iv_length'
/usr/bin/ld: ../archive_output_directory/libmysys_ssl.a(my_aes_openssl.cc.o): in function `my_aes_decrypt':
/home/danny/.cache/yay/mysql57/src/mysql-5.7.38/mysys_ssl/my_aes_openssl.cc:203: undefined reference to `EVP_CIPHER_iv_length'
/usr/bin/ld: ../archive_output_directory/libmysys_ssl.a(my_aes_openssl.cc.o): in function `my_aes_get_size':
/home/danny/.cache/yay/mysql57/src/mysql-5.7.38/mysys_ssl/my_aes_openssl.cc:242: undefined reference to `EVP_CIPHER_block_size'
/usr/bin/ld: ../archive_output_directory/libmysys_ssl.a(my_aes_openssl.cc.o): in function `my_aes_needs_iv':
/home/danny/.cache/yay/mysql57/src/mysql-5.7.38/mysys_ssl/my_aes_openssl.cc:265: undefined reference to `EVP_CIPHER_iv_length'
collect2: error: ld returned 1 exit status
/usr/bin/ld: make[2]: *** [extra/CMakeFiles/resolve_stack_dump.dir/build.make:107: extra/resolve_stack_dump] Error 1
make[1]: *** [CMakeFiles/Makefile2:5603: extra/CMakeFiles/resolve_stack_dump.dir/all] Error 2
../archive_output_directory/libmysys_ssl.a(my_aes_openssl.cc.o): in function `my_aes_encrypt':
/home/danny/.cache/yay/mysql57/src/mysql-5.7.38/mysys_ssl/my_aes_openssl.cc:149: undefined reference to `EVP_CIPHER_iv_length'
/usr/bin/ld: ../archive_output_directory/libmysys_ssl.a(my_aes_openssl.cc.o): in function `my_aes_decrypt':
/home/danny/.cache/yay/mysql57/src/mysql-5.7.38/mysys_ssl/my_aes_openssl.cc:203: undefined reference to `EVP_CIPHER_iv_length'
/usr/bin/ld: ../archive_output_directory/libmysys_ssl.a(my_aes_openssl.cc.o): in function `my_aes_get_size':
/home/danny/.cache/yay/mysql57/src/mysql-5.7.38/mysys_ssl/my_aes_openssl.cc:242: undefined reference to `EVP_CIPHER_block_size'
/usr/bin/ld: ../archive_output_directory/libmysys_ssl.a(my_aes_openssl.cc.o): in function `my_aes_needs_iv':
/home/danny/.cache/yay/mysql57/src/mysql-5.7.38/mysys_ssl/my_aes_openssl.cc:265: undefined reference to `EVP_CIPHER_iv_length'
collect2: error: ld returned 1 exit status
make[2]: *** [extra/CMakeFiles/comp_err.dir/build.make:107: extra/comp_err] Error 1
make[1]: *** [CMakeFiles/Makefile2:5355: extra/CMakeFiles/comp_err.dir/all] Error 2
[ 23%] Linking CXX executable mysql_ssl_rsa_setup
/usr/bin/ld: ../archive_output_directory/libmysys_ssl.a(my_aes_openssl.cc.o): in function `my_aes_encrypt':
/home/danny/.cache/yay/mysql57/src/mysql-5.7.38/mysys_ssl/my_aes_openssl.cc:149: undefined reference to `EVP_CIPHER_iv_length'
/usr/bin/ld: ../archive_output_directory/libmysys_ssl.a(my_aes_openssl.cc.o): in function `my_aes_decrypt':
/home/danny/.cache/yay/mysql57/src/mysql-5.7.38/mysys_ssl/my_aes_openssl.cc:203: undefined reference to `EVP_CIPHER_iv_length'
/usr/bin/ld: ../archive_output_directory/libmysys_ssl.a(my_aes_openssl.cc.o): in function `my_aes_get_size':
/home/danny/.cache/yay/mysql57/src/mysql-5.7.38/mysys_ssl/my_aes_openssl.cc:242: undefined reference to `EVP_CIPHER_block_size'
/usr/bin/ld: ../archive_output_directory/libmysys_ssl.a(my_aes_openssl.cc.o): in function `my_aes_needs_iv':
/home/danny/.cache/yay/mysql57/src/mysql-5.7.38/mysys_ssl/my_aes_openssl.cc:265: undefined reference to `EVP_CIPHER_iv_length'
collect2: error: ld returned 1 exit status
make[2]: *** [client/CMakeFiles/mysql_ssl_rsa_setup.dir/build.make:139: client/mysql_ssl_rsa_setup] Error 1
make[1]: *** [CMakeFiles/Makefile2:6034: client/CMakeFiles/mysql_ssl_rsa_setup.dir/all] Error 2
[ 23%] Linking CXX static library ../../archive_output_directory/libprotoclib.a
[ 23%] Built target protoclib
make: *** [Makefile:166: all] Error 2
==> ERROR: A failure occurred in build().
    Aborting...

With the release of OpenSSL 3, this package failed to compile. We can't just point WITH_SSL to a specific directory because there is no such directory in openssl-1.1. MySQL #includes <openssl/something> but Arch has the version inside include path (/usr/include/openssl-1.1), so we may need to patch all the #include directives, or find some other workaround to make this compiles again.

You know, after many years of using this package, it would be kinda nice if we stuffed everything in /opt. This is somewhat of a big change, cause people would need to add /opt/mysql/usr/include or something to build against it, but at least then it could live alongside mariadb without having package conflicts.

What do you think?

@aix27249 I won't to do that. mysql doesn't provide anything related to mariadb. Even if they have something in common they are not the same software and there's no reason to fake mysql will provide mariadb libraries

Some packages now depends on mariadb-libs, which provides libmariadbclient, and conflicts with libmysqlclient57. To fix this, please add mariadb-libs to provides() section of libmysqlclient57:

diff --git a/PKGBUILD b/PKGBUILD
index 5781cb7..3da1629 100644
--- a/PKGBUILD
+++ b/PKGBUILD
@@ -81,7 +81,7 @@ package_libmysqlclient57(){
   pkgdesc="MySQL client libraries, v5.7"
   depends=('libsasl' 'zlib')
   conflicts=('libmariadbclient')
-  provides=("libmariadbclient=${pkgver}" "libmysqlclient=${pkgver}")
+  provides=("libmariadbclient=${pkgver}" "libmysqlclient=${pkgver}" "mariadb-libs=${pkgver}")

   cd build
   for dir in include libmysql libmysqld libservices