You are not logged in.

Pages: 1

#1 2018-01-22 16:24:53

ody
Member
From: Manchester, UK
Registered: 2002-08-12
Posts: 216
Website

MariaDB 10.2 Branch PKGBUILD

I've updated the PKGBUILD for the 10.2 branch. Main changes are pulling LZ4 source into Groonga and name changes from libmysql to libmariadb.  Might be of use to others but obviously NOT official.

# $Id$
# Maintainer: Bartłomiej Piotrowski <bpiotrowski@archlinux.org>
# Maintainer: Christian Hesse <mail@eworm.de>

pkgbase=mariadb
pkgname=('libmariadbclient' 'mariadb-clients' 'mytop' 'mariadb')
pkgver=10.2.12
pkgrel=1
arch=('x86_64')
license=('GPL')
lz4version=1.7.5
url='http://mariadb.org/'
makedepends=('cmake' 'zlib' 'libaio' 'libxml2' 'openssl' 'jemalloc'
             'lz4' 'boost' 'libevent' 'systemd')
validpgpkeys=('199369E5404BD5FC7D2FE43BCBCB082A1BB943DB') # MariaDB Package Signing Key <package-signing-key@mariadb.org>
source=("https://ftp.heanet.ie/mirrors/mariadb/mariadb-$pkgver/source/mariadb-$pkgver.tar.gz"
https://github.com/lz4/lz4/archive/v$lz4version.tar.gz)
sha256sums=('2ab22d7fbacfabc30fe18f71a8afb173250074502d889457e3cde2e203d341ec'
0190cacd63022ccb86f44fa5041dc6c3804407ad61550ca21c382827319e7e7e)

prepare() {
  cd $pkgbase-$pkgver/

  # Changes to the upstream unit files:
  #  * remove the alias from unit files, we install symlinks in package function
  #  * enable PrivateTmp for a little bit more security
  sed -i -e '/^Alias/d' \
    -e '/^PrivateTmp/c PrivateTmp=true' \
    support-files/mariadb{,@}.service.in

  # openssl 1.1.0
  #patch -Np1 < "${srcdir}"/0001-openssl-1-1-0.patch

  # revert to fix the build
  # mroonga after-merge CMakeLists.txt fixes
  #patch -Np1 -R < "${srcdir}"/0002-mroonga-after-merge-CMakeLists.txt-fixes.patch

  # let's create the datadir from tmpfiles
  echo 'd @MYSQL_DATADIR@ 0700 @MYSQLD_USER@ @MYSQLD_USER@ -' >> support-files/tmpfiles.conf.in
}

build() {
  mkdir build
  cd build

  tar -xvf ../../v$lz4version.tar.gz -C ../$pkgbase-$pkgver/storage/mroonga/vendor/groonga/vendor/

  cmake ../$pkgbase-$pkgver \
    -DCMAKE_AR=/usr/bin/gcc-ar \
    -DCMAKE_RANLIB=/usr/bin/gcc-ranlib \
    -DBUILD_CONFIG=mysql_release \
    -DCMAKE_INSTALL_PREFIX=/usr \
    -DMYSQL_DATADIR=/var/lib/mysql \
    -DMYSQL_UNIX_ADDR=/run/mysqld/mysqld.sock \
    -DDEFAULT_CHARSET=utf8mb4 \
    -DDEFAULT_COLLATION=utf8mb4_unicode_ci \
    -DENABLED_LOCAL_INFILE=ON \
    -DINSTALL_DOCDIR=share/doc/mariadb \
    -DINSTALL_DOCREADMEDIR=share/doc/mariadb \
    -DINSTALL_MANDIR=share/man \
    -DINSTALL_PLUGINDIR=lib/mysql/plugin \
    -DINSTALL_SCRIPTDIR=bin \
    -DINSTALL_SYSCONFDIR=/etc/mysql \
    -DINSTALL_SYSCONF2DIR=/etc/mysql \
    -DINSTALL_INCLUDEDIR=include/mysql \
    -DINSTALL_SUPPORTFILESDIR=share/mysql \
    -DINSTALL_MYSQLSHAREDIR=share/mysql \
    -DINSTALL_SHAREDIR=share/mysql \
    -DINSTALL_SYSTEMD_SYSUSERSDIR=/usr/lib/sysusers.d/ \
    -DINSTALL_SYSTEMD_TMPFILESDIR=/usr/lib/tmpfiles.d/ \
    -DINSTALL_SYSTEMD_UNITDIR=/usr/lib/systemd/system/ \
    -DWITH_SYSTEMD=yes \
    -DWITH_READLINE=ON \
    -DWITH_ZLIB=system \
    -DWITH_SSL=system \
    -DWITH_PCRE=bundled \
    -DWITH_LIBWRAP=OFF \
    -DWITH_JEMALLOC=ON \
    -DWITH_EXTRA_CHARSETS=complex \
    -DWITH_EMBEDDED_SERVER=ON \
    -DWITH_ARCHIVE_STORAGE_ENGINE=1 \
    -DWITH_BLACKHOLE_STORAGE_ENGINE=1 \
    -DWITH_INNOBASE_STORAGE_ENGINE=1 \
    -DWITH_PARTITION_STORAGE_ENGINE=1 \
    -DWITH_TOKUDB_STORAGE_ENGINE=1 \
    -DWITHOUT_EXAMPLE_STORAGE_ENGINE=1 \
    -DWITHOUT_FEDERATED_STORAGE_ENGINE=1 \
    -DWITHOUT_PBXT_STORAGE_ENGINE=1 \
    -DCMAKE_EXE_LINKER_FLAGS='-ljemalloc' \
    -DCMAKE_C_FLAGS="-fPIC $CFLAGS -fno-strict-aliasing -DBIG_JOINS=1 -fomit-frame-pointer -fno-delete-null-pointer-checks" \
    -DCMAKE_CXX_FLAGS="-fPIC $CXXFLAGS -fno-strict-aliasing -DBIG_JOINS=1 -felide-constructors -fno-rtti -fno-delete-null-pointer-checks" \
    -DWITH_MYSQLD_LDFLAGS="-pie ${LDFLAGS},-z,now" \
    -DGRN_WITH_BUNDLED_LZ4=ON

  make
}

package_libmariadbclient() {
  pkgdesc='MariaDB client libraries'
  depends=('openssl' 'libaio' 'zlib' 'lz4' 'lzo' 'xz')
  conflicts=('libmysqlclient')

  cd build

#  for dir in libmysql libmysqld libservices include; do
  for dir in libmariadb libmysqld libservices include; do
    make -C $dir DESTDIR="$pkgdir" install
  done

  # these are provided by mariadb
  rm "$pkgdir"/usr/lib/mysql/plugin/{auth_gssapi_client.so,dialog.so,mysql_clear_password.so,sha256_password.so}

  install -D -m0755 scripts/mysql_config "$pkgdir"/usr/bin/mysql_config
  install -D -m0644 "$srcdir"/$pkgbase-$pkgver/man/mysql_config.1 "$pkgdir"/usr/share/man/man1/mysql_config.1

  install -D -m0644 support-files/mariadb.pc "$pkgdir"/usr/share/pkgconfig/mariadb.pc
  install -D -m0644 "$srcdir"/$pkgbase-$pkgver/support-files/mysql.m4 "$pkgdir"/usr/share/aclocal/mysql.m4

  # remove static libraries
  rm "$pkgdir"/usr/lib/*.a
}

package_mariadb-clients() {
  pkgdesc='MariaDB client tools'
  depends=("libmariadbclient=${pkgver}" 'zlib' 'openssl' 'jemalloc')
  conflicts=('mysql-clients')
  provides=("mysql-clients=$pkgver")

  cd build

  make -C client DESTDIR="$pkgdir" install

  # install man pages
  for man in mysql mysql_plugin mysql_upgrade mysqladmin mysqlbinlog mysqlcheck mysqldump mysqlimport mysqlshow mysqlslap mysqltest; do
    install -D -m0644 "$srcdir"/$pkgbase-$pkgver/man/$man.1 "$pkgdir"/usr/share/man/man1/$man.1
  done
}

package_mytop() {
  pkgdesc='Top clone for MariaDB'
  depends=('perl' 'perl-dbd-mysql' 'perl-term-readkey')

  cd build

  install -Dm0755 scripts/mytop "$pkgdir"/usr/bin/mytop
}

package_mariadb() {
  pkgdesc='Fast SQL database server, drop-in replacement for MySQL'
  backup=('etc/mysql/my.cnf'
          'etc/mysql/wsrep.cnf')
  install=mariadb.install
  depends=("mariadb-clients=${pkgver}" 'inetutils' 'libaio' 'libxml2' 'jemalloc'
           'lz4' 'boost-libs' 'lzo' 'libevent' 'libsystemd')
  optdepends=('galera: for MariaDB cluster with Galera WSREP'
              'perl-dbd-mysql: for mysqlhotcopy, mysql_convert_table_format and mysql_setpermission')
  conflicts=('mysql')
  provides=("mysql=$pkgver")
  options=('emptydirs')

  cd build

  make DESTDIR="$pkgdir" install

  cd "$pkgdir"

  # We specified INSTALL_SYSCONFDIR and INSTALL_SYSCONF2DIR to have proper paths
  # in binaries and support file. But we want our own files...
  # TOOD: Change to upstream file layout with version 10.2.x?
  rm -r etc/
  install -Dm0644 usr/share/mysql/my-medium.cnf etc/mysql/my.cnf
  install -Dm0644 usr/share/mysql/wsrep.cnf etc/mysql/wsrep.cnf

  mv usr/lib/sysusers.d/{sysusers,mariadb}.conf
  mv usr/lib/tmpfiles.d/{tmpfiles,mariadb}.conf

  ln -s mariadb.service usr/lib/systemd/system/mysqld.service
  ln -s mariadb@.service usr/lib/systemd/system/mysqld@.service

  # move to proper licenses directories
  install -d usr/share/licenses/mariadb
  mv usr/share/doc/mariadb/COPYING* usr/share/licenses/mariadb/

  # already installed to real systemd unit directory
  rm -r usr/share/mysql/systemd/

  # left over from sysvinit
  rm usr/bin/rcmysql

  # provided by libmariadbclient
  rm usr/bin/mariadb_config
  rm usr/lib/libmysql*
  rm usr/lib/libmariadb*
  rm usr/bin/mysql_config
  rm usr/share/man/man1/mysql_config.1
  rm -r usr/include/
  rm -r usr/share/mysql/{aclocal,pkgconfig}

  # provided by mariadb-clients
  rm usr/bin/{mysql,mysql_plugin,mysql_upgrade,mysqladmin,mysqlbinlog,mysqlcheck,mysqldump,mysqlimport,mysqlshow,mysqlslap,mysqltest}
  rm usr/share/man/man1/{mysql,mysql_plugin,mysql_upgrade,mysqladmin,mysqlbinlog,mysqlcheck,mysqldump,mysqlimport,mysqlshow,mysqlslap,mysqltest}.1

  # provided by mytop
  rm usr/bin/mytop

  # not needed
  rm -r usr/{data,mysql-test,sql-bench}
  rm usr/share/man/man1/mysql-test-run.pl.1
}

Offline

#2 2018-01-22 17:03:17

Slithery
Administrator
From: Norfolk, UK
Registered: 2013-12-01
Posts: 5,776

Re: MariaDB 10.2 Branch PKGBUILD

Just for reference, this is why the Arch devs haven't released 10.2 yet...

https://lists.archlinux.org/pipermail/a … 44255.html

No, it didn't "fix" anything. It just shifted the brokeness one space to the right. - jasonwryan
Closing -- for deletion; Banning -- for muppetry. - jasonwryan

aur - dotfiles

Offline

#3 2018-01-22 17:15:33

ody
Member
From: Manchester, UK
Registered: 2002-08-12
Posts: 216
Website

Re: MariaDB 10.2 Branch PKGBUILD

I did see that, slithery.  I wanted to give the new JSON functions a go on a testing box so wasn't to bothered about things being broken.  However it seems to have slotted in without issue .. for the PHP PDO MySQL driver at least... maybe the issues Christian has seen have been resolved in the later release of 10.2.12.  However, I wouldn't try this out on a live server just yet smile

Offline

#4 2018-01-23 20:41:02

korvinko
Member
Registered: 2018-01-23
Posts: 1

Re: MariaDB 10.2 Branch PKGBUILD

Sadly that I found it topic after create self PKGBUILD. Maybe for someone it will ease use from github repo.

https://github.com/johndoejdg/mariadb-10.2-archlinux

Last edited by korvinko (2018-01-23 20:48:42)

Offline

#5 2018-01-31 11:20:44

ody
Member
From: Manchester, UK
Registered: 2002-08-12
Posts: 216
Website

Re: MariaDB 10.2 Branch PKGBUILD

Be aware, with the this new version of MariaDB it appears to now be throwing an error when queries attempt to cast values, for example;

MariaDB [tmp]> select version();
+---------------------+
| version()           |
+---------------------+
| 10.2.12-MariaDB-log |
+---------------------+
1 row in set (0.00 sec)

MariaDB [tmp]> create table tmp (id int);
Query OK, 0 rows affected (0.05 sec)

MariaDB [tmp]> insert into tmp(id) values('');
ERROR 1366 (22007): Incorrect integer value: '' for column 'id' at row 1
MariaDB [tmp]>

vs

MariaDB [tmp]> select version();
+-----------------+
| version()       |
+-----------------+
| 10.1.30-MariaDB |
+-----------------+
1 row in set (0.00 sec)

MariaDB [tmp]> create table tmp( id int );
Query OK, 0 rows affected (0.00 sec)

MariaDB [tmp]> insert into tmp(id) values('');
Query OK, 1 row affected, 1 warning (0.00 sec)

MariaDB [tmp]>

I don't know when this became the default in the 10.2 branch (or if I've not picked up a my.cnf change) but it's going to cause some major headaches big_smile

Offline

#6 2018-01-31 11:39:27

progandy
Member
Registered: 2012-05-17
Posts: 5,193

Re: MariaDB 10.2 Branch PKGBUILD

ody wrote:

I don't know when this became the default in the 10.2 branch (or if I've not picked up a my.cnf change) but it's going to cause some major headaches big_smile

That should be version 10.2.4: https://mariadb.com/kb/en/library/sql-mode/#strict-mode

Last edited by progandy (2018-01-31 11:39:50)

| alias CUTF='LANG=en_XX.UTF-8@POSIX ' |

Online

#7 2018-01-31 12:56:41

ody
Member
From: Manchester, UK
Registered: 2002-08-12
Posts: 216
Website

Re: MariaDB 10.2 Branch PKGBUILD

Thanks progandy! I figured out putting;

sql_mode=MYSQL40

into my.cnf reverts to the old expected behaviour.

Offline

#8 2018-06-02 06:36:10

blacksoil
Member
Registered: 2018-06-02
Posts: 1

Re: MariaDB 10.2 Branch PKGBUILD

korvinko wrote:

Sadly that I found it topic after create self PKGBUILD. Maybe for someone it will ease use from github repo.

https://github.com/johndoejdg/mariadb-10.2-archlinux

Hi,
I just wanna say thanks a lot for this! I'm new to Arch Linux (coming from years of Ubuntu) and had a trouble where my code wouldn't run because of it dependent on MySQL 5.6 feature. This package solves the problem because MariaDB 10.2 is based on MySQL 5.7.

Again, thanks a bunch for your effort! smile

Last edited by blacksoil (2018-06-02 06:37:35)

Offline

Pages: 1

Board footer

Powered by FluxBB