- discuss - lists.mariadb.org

[Maria-discuss] incomplete provide of symlinks with 10.2.7
by Reindl Harald 13 Jul '17

13 Jul '17

Fedora just started to work on MariaDB 10.2 packaging they create compat symlinks for a sane transition and i try to backport that to my F25 builds with change as less as possible on my existing "mariadb.spec" 10.2.7 seems to do the same now (Fedora last night was still on 10.2.6) well, "libmysqlclient.so.18" is missing in your upstream compat links while "libmysqlclient.so" and "libmysqlclient_r.so" gave an error "ln: failed to create symbolic link 'libmysqlclient.so': File exists" within rpmbuild https://koji.fedoraproject.org/koji/buildinfo?buildID=918138 ___________________________________________ pushd %{buildroot}%{_libdir}/mysql/ ln -s libmariadb.so libmysqlclient.so ln -s libmariadb.so libmysqlclient.so.18 ln -s libmariadb.so libmysqlclient_r.so popd ___________________________________________ + pushd /home/builduser/rpmbuild/BUILDROOT/mariadb-10.2.7-3.fc25.20170713.rh.x86_64/usr/lib64/mysql/ ~/rpmbuild/BUILDROOT/mariadb-10.2.7-3.fc25.20170713.rh.x86_64/usr/lib64/mysql ~/rpmbuild/BUILD/mariadb-10.2.7 + ln -s libmariadb.so libmysqlclient.so.18 + popd ~/rpmbuild/BUILD/

2 2

[Maria-discuss] MariaDB 10.2.7 now available
by Daniel Bartholomew 12 Jul '17

12 Jul '17

The MariaDB project is pleased to announce the immediate availability of MariaDB 10.2.7. This is a stable (GA) release. See the Release Notes and Changelogs for details. - - Links - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - MariaDB 10.2.7 - Release Notes: https://mariadb.com/kb/en/mdb-1027-rn/ - Changelog: https://mariadb.com/kb/en/mdb-1027-cl/ - Downloads: https://downloads.mariadb.org/mariadb/10.2.7 About MariaDB 10.2: - https://mariadb.com/kb/en/what-is-mariadb-102/ APT and YUM Repository Configuration Generator: - https://downloads.mariadb.org/mariadb/repositories/ - - MariaDB Webinars - - - - - - - - - - - - - - - - - - - - - - - - - There are several upcoming MariaDB-focused webinars and many previously held ones available to watch on an on-demand basis at: - https://mariadb.com/news-events/webinars - - MariaDB Books - - - - - - - - - - - - - - - - - - - - - - - - - - There is an ever-growing library of MariaDB books available to help you get the most out of MariaDB. See the MariaDB Books page for details and links: - https://mariadb.com/kb/en/mariadb/books/ - - User Feedback plugin - - - - - - - - - - - - - - - - - - - - - - - MariaDB includes a User Feedback plugin. This plugin is disabled by default. If enabled, it submits basic, completely anonymous MariaDB usage information. This information is used by the developers to track trends in MariaDB usage to better guide development efforts. If you would like to help make MariaDB better, please add "feedback=ON" to your my.cnf or my.ini file! See http://mariadb.com/kb/en/user-feedback-plugin for more information. - - Quality - - - - - - - - - - - - - - - - - - - - - - - - - - - - - The project always strives for quality, but in reality, nothing is perfect. Please take time to report any issues you encounter at: - http://mariadb.org/jira - - Support MariaDB - - - - - - - - - - - - - - - - - - - - - - - - - If you would like to contribute to the MariaDB Foundation, please see the "contributing" and "donations" pages. We also have merchandise available in a cafepress store. All proceeds go to support the MariaDB Foundation. - https://mariadb.com/kb/en/contributing - https://mariadb.org/donate/ We hope you enjoy MariaDB! -- MariaDB Website - http://mariadb.org Twitter - http://twitter.com/mariadbfdn - http://twitter.com/mariadb Google+ - http://google.com/+mariadb Facebook - http://fb.com/MariaDB.dbms Knowledge Base - http://mariadb.com/kb

1 0

[Maria-discuss] Galera cluster for databases replication over three servers
by Martin LEUSCH 11 Jul '17

11 Jul '17

Hi, I'm setting up a new mail infrastructure withe 3 servers running Debian Jessie, data can be read or write from these 3 servers at any time. I chosed Galera with with MariaDB 10.2 to share databases between servers for services like AMAVIS, dovecot, ... I had a lot of errors in my logs (almost each time a service access to a DB), for example: Jul 11 07:00:01 mail mysqld[1302]: 2017-07-11 7:00:01 140256990783232 [Warning] Aborted connection 14812 to db: 'sogo' user: 'sogo' host: 'localhost' (Got an error reading communication packets) Jul 11 10:15:17 mailfilter mysqld[3714]: 2017-07-11 10:15:17 139644624377600 [Warning] Aborted connection 399 to db: 'amavisd' user: 'amavisd' host: 'localhost' (Got timeout reading communication packets) I wonder if in this case Galera is a good choice for databases replication and if there is a way to avoid this kind of errors. Thanks -- Martin LEUSCH <martin.leusch(a)imrcom.fr>

1 0

[Maria-discuss] TRIGGERing on new users
by Curtis Brown 07 Jul '17

07 Jul '17

I apologize in advance if this is the wrong venue; please point me in a more correct direction if that's the case. I want to perform some extra database functions when a new user is created in our MariaDB installation. What I am learning though is that I can't CREATE TRIGGERs against system tables like the user table in the mysql database. I am using MariaDB v10.1.24 in an Ubuntu 16.04.2 environment Have others run across a similar situation? Are there techniques to work around this? One thought I had was to enable general query log and either monitor the file output or TRIGGER on the general_log table. Are there any better suggestions? Thanks in advance. -- Curtis Brown, unix system administrator For general PC questions, Academic Computing and Networking Services call: 970-491-7276 Colorado State University email: help(a)colostate.edu curtis.brown(a)colostate.edu http://lib.colostate.edu/helpdesk/

2 4

[Maria-discuss] Broken MariaDB client ARGGG!!!
by Jon Foster 06 Jul '17

06 Jul '17

I'm constantly astounded at the extreme cavalier attitude that MySQL/MariaDB has had towards backwards compatibility for the nearly two decades I've worked with it. Its like you hate the developers that use your stuff. What's up with this?!?! I decided I better install the latest updates to my Deb7 64bit MariaDB install. WTF! Now all of my PHP apps are griping about: ---- symbol client_errors, version libmysqlclient_18 not defined in file libmysqlclient.so.18 ... ---- And it was working so well ten minutes ago. 10.2 even did away with the previous gripes from v10.1. :-/ But with the update to 10.2.6+maria~wheezy of the client libraries from your Debian repositories my clients' sites are down. Please fix. I'll find someway to install older functional code again. - Jon -- Sent from my Debian Linux workstation -- http://www.debian.org/intro/about Jon Foster JF Possibilities, Inc. jon(a)jfpossibilities.com 541-410-2760 Making computers work for you!

5 6

[Maria-discuss] How to deal with text pasted from Word?
by David Karr 06 Jul '17

06 Jul '17

I've inherited a small webapp that is using MariaDB for persistence. Some of the forms have textarea fields for extended text to be entered. Someone reported an issue saving a form with some text that they had pasted from an email. The message started with this: ------------------ Caused by: org.mariadb.jdbc.internal.util.dao.QueryException: Incorrect string value: '\xC2\x95\x09Onb...' for column 'ssimpact' at row 1 ---------------- I found where "Onb" is in the text, and right before it is a "bullet" character. So, this appeared to be a Unicode conversion issue. I tried pasting the same text after it had been passed to me, and it didn't fail. I'm pretty sure it didn't fail because that process of "passing it around" filtered the text to be all valid characters. The person who reported the problem said that when she just resubmitted it, it didn't fail. That might also point to a "cleansing" process that resulted in the submitted characters being legal. What are some reasonable strategies for getting this to work a little better?

1 1

[Maria-discuss] legacy InnoDB compressed tables using row_format=compressed
by Lukas Lehner 05 Jul '17

05 Jul '17

Hey Quote from https://mariadb.com/kb/en/mariadb/compression/ This approach differs significantly from legacy InnoDB compressed tables using row_format=compressed, where both uncompressed and compressed pages can be in the buffer pool. Any details why this is legacy? Should not be used? With a search engine I found a very old blog posting "InnoDB compression woes" from Percona. row_format=compressed is attractive when you pay your DBaaS per GB (storage based usage). Any insides? Lukas

2 1

[Maria-discuss] Best place to report RocksDB issues?
by jocelyn fournier 05 Jul '17

05 Jul '17

Hi all, Mark, What's the best place to report RocksDB issues? MariaDB/Percona JIRA, https://github.com/facebook/rocksdb/issues , any other places? Thanks! Jocelyn

2 1

[Maria-discuss] MariaDB 10.1.25 now available
by Daniel Bartholomew 04 Jul '17

04 Jul '17

The MariaDB project is pleased to announce the immediate availability of MariaDB 10.1.25, MariaDB Connector/J 2.0.3, and MariaDB Connector/J 1.6.2. See the Release Notes and Changelogs for details. - - Links - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - MariaDB 10.1.25 - Release Notes: https://mariadb.com/kb/en/mdb-10125-rn/ - Changelog: https://mariadb.com/kb/en/mdb-10125-cl/ - Downloads: https://downloads.mariadb.org/mariadb/10.1.25 About MariaDB 10.1: - https://mariadb.com/kb/en/what-is-mariadb-101/ APT and YUM Repository Configuration Generator: - https://downloads.mariadb.org/mariadb/repositories/ MariaDB Connector/J 2.0.3 - Release Notes: https://mariadb.com/kb/en/mcj-203-rn/ - Changelog: https://mariadb.com/kb/en/mcj-203-cl/ - Downloads: https://downloads.mariadb.org/connector-java/2.0.3/ About MariaDB Connector/J: - https://mariadb.com/kb/en/about-mariadb-connector-j/ MariaDB Connector/J 1.6.2 - Release Notes: https://mariadb.com/kb/en/mcj-162-rn/ - Changelog: https://mariadb.com/kb/en/mcj-162-cl/ - Downloads: https://downloads.mariadb.org/connector-java/1.6.2/ About MariaDB Connector/J: - https://mariadb.com/kb/en/about-mariadb-connector-j/ - - MariaDB Webinars - - - - - - - - - - - - - - - - - - - - - - - - - There are several upcoming MariaDB-focused webinars and many previously held ones available to watch on an on-demand basis at: - https://mariadb.com/news-events/webinars - - MariaDB Books - - - - - - - - - - - - - - - - - - - - - - - - - - There is an ever-growing library of MariaDB books available to help you get the most out of MariaDB. See the MariaDB Books page for details and links: - https://mariadb.com/kb/en/mariadb/books/ - - User Feedback plugin - - - - - - - - - - - - - - - - - - - - - - - MariaDB includes a User Feedback plugin. This plugin is disabled by default. If enabled, it submits basic, completely anonymous MariaDB usage information. This information is used by the developers to track trends in MariaDB usage to better guide development efforts. If you would like to help make MariaDB better, please add "feedback=ON" to your my.cnf or my.ini file! See http://mariadb.com/kb/en/user-feedback-plugin for more information. - - Quality - - - - - - - - - - - - - - - - - - - - - - - - - - - - - The project always strives for quality, but in reality, nothing is perfect. Please take time to report any issues you encounter at: - http://mariadb.org/jira - - Support MariaDB - - - - - - - - - - - - - - - - - - - - - - - - - If you would like to contribute to the MariaDB Foundation, please see the "contributing" and "donations" pages. We also have merchandise available in a cafepress store. All proceeds go to support the MariaDB Foundation. - https://mariadb.com/kb/en/contributing - https://mariadb.org/donate/ We hope you enjoy MariaDB! -- MariaDB Website - http://mariadb.org Twitter - http://twitter.com/mariadbfdn - http://twitter.com/mariadb Google+ - http://google.com/+mariadb Facebook - http://fb.com/MariaDB.dbms Knowledge Base - http://mariadb.com/kb

1 0

[Maria-discuss] [MariaDB 10.2.6] [PHP 7.1.6] error: /usr/bin/ld: cannot find -lmysqlclient | wrong mysql library version or lib not found
by Guillermo Cespedes 04 Jul '17

04 Jul '17

Hi, I am compiling MariaDB 10.2.6 and PHP 7.1.6 I'm trying it on Debian 8.8 32x and x64 on DigitalOcean See the script: https://gist.github.com/dertin/8de14e458dd4f0d3acb5f0deff120951 <https://gist.github.com/dertin/8de14e458dd4f0d3acb5f0deff120951> But I have problems compiling PHP with MariaDB / MySQLi. Should I check something at the Mariadb installation? # grep 'mysql’ config.log $ ./configure --prefix=/usr/local/php7 --enable-huge-code-pages --with-config-file-scan-dir=/usr/local/php7/etc/conf.d --without-pear --enable-bcmath --with-bz2 --enable-calendar --enable-intl --enable-exif --enable-dba --enable-ftp --with-gettext --with-gd --with-jpeg-dir --enable-mbstring --with-mcrypt --with-mhash --enable-mysqlnd --with-mysql-sock=/var/run/mysqld/mysqld.sock --with-mysqli=/usr/local/mysql/bin/mariadb_config --with-pdo-mysql=/usr/local/mysql --with-openssl --enable-pcntl --with-pspell --enable-shmop --enable-soap --enable-sockets --enable-sysvmsg --enable-sysvsem --enable-sysvshm --enable-wddx --with-zlib --enable-zip --with-readline --with-curl --enable-simplexml --enable-xmlreader --enable-xmlwriter --enable-fpm --with-fpm-user=www-data --with-fpm-group=www-data ... configure:52615: result: /var/run/mysqld/mysqld.sock configure:52749: checking for mysql_set_server_option in -lmysqlclient configure:52774: cc -o conftest -I/usr/include -g -O2 -fvisibility=hidden -Wl,-rpath,/usr/local/mysql/lib/ -L/usr/local/mysql/lib/ -L/usr/lib -Wl,-rpath,/usr/local/lib -L/usr/local/lib -Wl,-rpath,/usr/lib/x86_64-linux-gnu -L/usr/lib/x86_64-linux-gnu -lmariadb -ldl -lm -lssl -lcrypto conftest.c -lmysqlclient -lmcrypt -lltdl -lstdc++ -lpng -lz -ljpeg -lcurl -lbz2 -lz -lrt -lm -ldl -lnsl -lxml2 -lz -lm -ldl -lssl -lcrypto -lcurl -lxml2 -lz -lm -ldl -lssl -lcrypto -licui18n -licuuc -licudata -licuio >&5 /usr/bin/ld: cannot find -lmysqlclient | char mysql_set_server_option (); | return mysql_set_server_option (); configure:53081: error: wrong mysql library version or lib not found. Check config.log for more information. ac_cv_lib_mysqlclient___mysql_set_server_option=no Tested with: --with-mysqli=/usr/local/mysql/bin/mysql_config --with-mysqli=/usr/local/mysql/bin/mariadb_config related to: https://lists.launchpad.net/maria-discuss/msg04668.html What do you think? Guillermo Céspedes Full Stack Developer

2 2