July 2017 - discuss - lists.mariadb.org

[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

[Maria-discuss] I expected the same values for mariadb_config, mysql_config and my_print_defaults --mysqld
by Guillermo Cespedes 04 Jul '17

04 Jul '17

Hi, The values are not correct, they are even different, I expected the same values. See socket and version. # /usr/local/mysql/bin/mariadb_config Copyright 2011-2015 MariaDB Corporation AB Get compiler flags for using the MariaDB Connector/C. Usage: mariadb_config [OPTIONS] --cflags [-I/usr/local/mysql/include/mysql -I/usr/local/mysql/include/mysql/mysql] --include [-I/usr/local/mysql/include/mysql -I/usr/local/mysql/include/mysql/mysql] --libs [-L/usr/local/mysql/lib/ -lmariadb -lpthread -ldl -lm -lssl -lcrypto] --libs_r [-L/usr/local/mysql/lib/ -lmariadb -lpthread -ldl -lm -lssl -lcrypto] --libs_sys [-lpthread -ldl -lm -lssl -lcrypto] --version [10.2.5] --socket [/tmp/mysql.sock] --port [3306] --plugindir [/usr/local/mysql/lib/plugin] --tlsinfo [OpenSSL 1.1.0f] # /usr/local/mysql/bin/mysql_config Usage: /usr/local/mysql/bin/mysql_config [OPTIONS] Options: --cflags [-I/usr/local/mysql/include/mysql -I/usr/local/mysql/include/mysql/.. ] --include [-I/usr/local/mysql/include/mysql -I/usr/local/mysql/include/mysql/..] --libs [-L/usr/local/mysql/lib -lmariadb] --libs_r [-L/usr/local/mysql/lib -lmariadb] --plugindir [/usr/local/mysql/lib/plugin] --socket [/tmp/mysql.sock] --port [0] --version [10.2.6] --libmysqld-libs [-L/usr/local/mysql/lib -lmysqld -lpthread -lz -lm -ldl -lssl -lcrypto -lpcre -lcrypt -llz4 -laio] --variable=VAR VAR is one of: pkgincludedir [/usr/local/mysql/include/mysql] pkglibdir [/usr/local/mysql/lib] plugindir [/usr/local/mysql/lib/plugin] # my_print_defaults --mysqld --port=3306 --socket=/var/run/mysqld/mysqld.sock --skip-external-locking --key_buffer_size=16M --max_allowed_packet=1M --table_open_cache=64 --sort_buffer_size=512K --net_buffer_length=8K --read_buffer_size=256K --read_rnd_buffer_size=512K --myisam_sort_buffer_size=8M --log-bin=mysql-bin --binlog_format=mixed --server-id=1 --user=mysql --pid-file=/var/run/mysqld/mysqld.pid --socket=/var/run/mysqld/mysqld.sock --port=3306 --basedir=/usr/local/mysql --datadir=/usr/local/mysql/data --tmpdir=/tmp --lc-messages-dir=/usr/local/mysql/share --skip-external-locking --bind-address=127.0.0.1 --key_buffer=16M --max_allowed_packet=16M --thread_stack=192K --thread_cache_size=8 --myisam-recover=BACKUP --query_cache_limit=1M --query_cache_size=16M --log_error=/var/log/mysql/error.log --expire_logs_days=10 --max_binlog_size=100M Guillermo Céspedes Full Stack Developer

2 2

Re: [Maria-discuss] Can't open shared library '/usr/lib64/mysql/plugin/auth_socket.so'
by Daniel Black 04 Jul '17

04 Jul '17

On 03/07/17 22:54, Jonathan Gazeley wrote: > On 03/07/17 13:38, Ian Gilfillan wrote: >> On 03/07/2017 14:13, Jonathan Gazeley wrote: >>> >>> It fails to find auth_socket.so, but when I check in yum what >>> provides that file, only MariaDB 5.5 from the CentOS repo has it, but >>> not MariaDB 10.1 from the MariaDB repo. I read in the notes that >>> auth_socket is deprecated and going in 10.2. My config file specifies >>> 'loose-plugin-load=auth_socket'. If I just remove this line, will it >>> work? Will it break wsrep? >>> >> In which notes did you read about auth_socket being deprecated? > > In /etc/my.cnf.d/mariadb-enterprise.cnf: > > # This is to accommodate upgrades to MariaDB 10.2, which does not include > # the Unix socket plugin built into the server. > loose-plugin-load=auth_socket > > Makes it sound like auth_socket is going away - or at least is opt-in in > 10.2. Its built in to the 10.2 server rather than being a separate shared library like <10.2

1 0

[Maria-discuss] Duplication of documentation for binlog annotation and a question on replicate_annotate_row_events not being dynamic
by Jean-Francois B. Gagne 03 Jul '17

03 Jul '17

Hi all, This is a documentation organisation question and a technical question on replicate_annotate_row_events not being dynamic. In [1], we can find the documentation for the options binlog-annotate-row-events and replicate-annotate-row-events, and [2] points to [1]. However, there is a duplication of that documentation in [3] and [4], is there a reason for that (there is a risk of those 2 documentation diverging) ? [1]: https://mariadb.com/kb/en/mariadb/annotate_rows_log_event/ [2]: https://mariadb.com/kb/en/mariadb/mysqld-options/ [3]: https://mariadb.com/kb/en/mariadb/replication-and-binary-log-server-system-… [4]: https://mariadb.com/kb/en/mariadb/replication-and-binary-log-server-system-… And the technical question about replicate_annotate_row_events: this variable is not dynamic, is there a reason for that ? I understand that this variable could/should only be modifiable while the slave is stopped, but not being dynamic is not very DBA/SysAdmin/Operator friendly. Many thanks, Jean-François Gagné

3 2