Package Details: mysql57 5.7.44-1

Git Clone URL: https://aur.archlinux.org/mysql57.git (read-only, click to copy)
Package Base: mysql57
Description: Fast SQL database server, community edition, v5.7
Upstream URL: https://www.mysql.com/products/community/
Licenses: GPL
Conflicts: mariadb
Provides: mariadb, mysql
Submitter: muflone
Maintainer: muflone
Last Packager: muflone
Votes: 12
Popularity: 0.000000
First Submitted: 2018-04-29 22:03 (UTC)
Last Updated: 2023-11-15 01:19 (UTC)

Required by (215)

Sources (7)

Latest Comments

1 2 Next › Last »

muflone commented on 2023-07-09 18:38 (UTC)

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)

Asin commented on 2023-06-17 01:52 (UTC) (edited on 2023-06-17 02:13 (UTC) by Asin)

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

DL0 commented on 2023-02-24 18:58 (UTC) (edited on 2023-02-24 19:04 (UTC) by DL0)

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

Keenay commented on 2022-11-15 15:51 (UTC) (edited on 2022-11-15 18:42 (UTC) by Keenay)

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.

danny commented on 2022-11-15 02:41 (UTC)

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...

duongdominhchau commented on 2022-11-07 07:59 (UTC) (edited on 2022-11-07 07:59 (UTC) by duongdominhchau)

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.

synthead commented on 2022-05-17 17:31 (UTC)

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?

muflone commented on 2021-05-30 15:23 (UTC)

@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

aix27249 commented on 2021-05-13 10:26 (UTC)

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