- discuss - lists.mariadb.org

[Maria-discuss] New Question: Licensing of Mariadb connector/C
by AskMonty KB 30 Apr '15

30 Apr '15

Hello, A new question has been asked in "MariaDB Connector/C" by kmrsankar. Please answer it at http://mariadb.com/kb/en/licensing-of-mariadb-connectorc/ as the person asking the question may not be subscribed to the mailing list. -------------------------------- hi, I have downloaded the source and binary of Maria DB Connector/C library. I see that one of the files mysql_async.h has a GPL license in it. But as such the whole library was declared as LGPL. Is this single GPL license header contaminates this library ? Thanks, Muthu -------------------------------- To view or answer this question please visit: http://mariadb.com/kb/en/licensing-of-mariadb-connectorc/

1 0

[Maria-discuss] Calculating memory consumption for MariaDB in Munin plugin
by Anna Jonna Armannsdottir 30 Apr '15

30 Apr '15

Hello, I am new to this list and the issue I am presenting here might surely be answered on the development list, but I do not want to impose this issue on the developers, I just hope some of them listen here. There seems to be general aggreement on the calculation of memory consumption for MariaDB and MySQL. There is however an insignificant dispute but very important dispute over the role of tmp_table_size . https://mariadb.com/kb/en/mariadb/server-system-variables/#tmp_table_size The dispute is whether tmp_table_size is a session variable or a kind of global variable. Thus MariaDB memory consumption is calculated as: max_connections * (sum of session variables) + (global variables) Thus if tmp_table_size is considered to be a session variable, it will be multiplied by max_connections . In my config the settings are: max-connections = 1000 tmp-table-size = 32M max-heap-table-size = 32M In my case this means that MariaDB could consume 1000 + 32M + 1000 + (sum of sess.var.) + (global variables) . This point of view was put forward in a discussion on mysql.com: QUOTE: > I disagree with how the previous comment handles the tmp_table_size > value. They treat it as a single allocation on the global scope when > for memory consumption purposes it is more in line with a per thread > buffer. > > A single connection/query can use a single or multiple temporary > tables in the duration of its processing. The connections do not use a > single temporary table "area" reserved just for that purpose. > > If you are going to use a formula for memory consumption, the > tmp_table-size should be located with the other per thread buffers - > not in the single allocation listing. https://dev.mysql.com/doc/refman/5.0/en/memory-use.html I honestly do not believe, this the case. On this discussion list we have examples that have tmp_table_size = 256 MB and max-connections = 1000 . 256 Gigabytes!!! https://lists.launchpad.net/maria-discuss/msg02376.html On the other hand we have sites like: http://www.mysqlcalculator.com/ This site calculates memory consumption in a way I find more agreeable, by not multiplying tmp_table_size by max_connections. This is an issue in a Munin monitoring plugin that reports mysql connection memory. The calculation code is from lines 1941 to 1949. https://github.com/munin-monitoring/munin/blob/devel/plugins/node.d/mysql_ $data->{'mysql_connection_memory'} = $data->{'read_buffer_size'} + $data->{'read_rnd_buffer_size'} + $data->{'sort_buffer_size'} + $data->{'join_buffer_size'} + $data->{'binlog_cache_size'} + $data->{'thread_stack'} + ( $tmp_table_size >= $max_heap_table_size ? $tmp_table_size : $max_heap_table_size ) + ( $data->{'tokudb_read_buf_size'} || 0 ); # wsrep_thread_count was separated from max_connections for mariadb-5.5.38 https://mariadb.atlassian.net/browse/MDEV-6206 $data->{'mysql_connection_memory'} *= $data->{'max_connections'} + ( $data->{'wsrep_thread_count'} || 0 ); I ask for your opinion and support for correcting this issue, so that we may get correct reports in Munin. -- Anna Jonna Armannsdottir <annaj(a)hi.is> University of Iceland Computing Services -- Anna Jonna Armannsdottir <annajonna(a)gmail.com>

2 1

[Maria-discuss] Simple Password Check plugin Backported to 5.5
by Adam Scott 30 Apr '15

30 Apr '15

It's taken some time, but I have backported the simple_password_check plugin and the password api to MariaDB 5.5 The mysql-test is succeeding on all but the test of the strict_password_validation variable. My question is, should a pure backport include support for strict_password_validation variable ( https://mariadb.com/kb/en/mariadb/server-system-variables/#strict_password_…) ? I suspect yes, but wanted to ask to start a further discussion: namely if I submit this patch will it be included in future MariaDB 5.5 releases? It will help customer enforce password complexity beneficial for security auditing. Let me know and I'll submit patch or submit via recommended method. Thank you, Adam Scott p.s. I sent this message on Apr 27 as a reply to the mailing lists for a thread started back in January, but I haven't seen my reply show up in the public archive. Colin suggested I let you know when I have backported the plugin.

1 0

[Maria-discuss] user map auth plugin
by Felipe Gasper 29 Apr '15

29 Apr '15

So, I recently wrote an auth plugin with the intent of implementing a simple user map, authenticated against the hashed password that would be retrieved via the normal password entry scheme. I got far too far along before realizing that this scheme basically requires that either the client use a plugin to communicate with the server auth plugin, or I use the old MySQL auth plugin. ...or is there some way to re-initialize secure MySQL auth from the server auth plugin?? It would really shoot my intents in the gut if every client that wants to log in with user mapping needs to be 5.5+ and to have a plugin...:-( -FG Sent from my android device.

2 1

[Maria-discuss] Moderator: please REMOVE ME
by grantksupport＠operamail.com 29 Apr '15

29 Apr '15

I deleted my launchpad account. Still getting emails from this ML. Can't re-subscribe to launchpad to unsubscribe from the ML. Catch22 ... Could a kindly Moderator please REMOVE ME? Thx.

2 1

[Maria-discuss] UNSUBSCRIBE
by grantksupport＠operamail.com 29 Apr '15

29 Apr '15

2 1

[Maria-discuss] New Question: How to specify the options when using cmake?
by AskMonty KB 29 Apr '15

29 Apr '15

Hello, A new question has been asked in "General FAQ" by fjjiaboming. Please answer it at http://mariadb.com/kb/en/how-to-specify-the-options-when-using-cmake/ as the person asking the question may not be subscribed to the mailing list. -------------------------------- http://www.linuxfromscratch.org/blfs/view/7.7/server/mariadb.html I build MariaDB 10.0.17 with cmake-3 , libevent-2 , python-2 ... Dependencies all are in dir /opt/.. But , how can I specify the modules dir for MariaDB ? `` cmake-3... -DCMAKE_BUILD_TYPE=Release -DCMAKE_INSTALL_PREFIX=/opt/mariadb-10.0.17 -DINSTALL_DOCDIR=share/doc/mariadb-10.0.17 -DINSTALL_DOCREADMEDIR=share/doc/mariadb-10.0.17 -DINSTALL_MANDIR=share/man -DINSTALL_MYSQLSHAREDIR=share/mysql -DINSTALL_MYSQLTESTDIR=share/mysql/test -DINSTALL_PLUGINDIR=lib/mysql/plugin -DINSTALL_SBINDIR=sbin -DINSTALL_SCRIPTDIR=bin -DINSTALL_SQLBENCHDIR=share/mysql/bench -DINSTALL_SUPPORTFILESDIR=share/mysql -DMYSQL_DATADIR=/srv/mysql -DMYSQL_UNIX_ADDR=/srv/mysql/mysqld.sock -DWITH_EXTRA_CHARSETS=complex -DWITH_EMBEDDED_SERVER=ON -DTOKUDB_OK=0 .. `` I try to add -DWITH_LIBEVENT=/opt/libevent-2.0.22-stable -DWITH_BOOST=/opt/boost_1_58_0 ... I got some messages to tip me the options are invalid . -------------------------------- To view or answer this question please visit: http://mariadb.com/kb/en/how-to-specify-the-options-when-using-cmake/

1 0

[Maria-discuss] MariaDB finally in Debian officially (Fwd: Debian 8 "Jessie" released)
by Otto Kekäläinen 27 Apr '15

27 Apr '15

Hello! Debian 8 "Jessie" has been released to today. It is the first official Debian release that ships with MariaDB (it has MariaDB 10.0.16 and MySQL 5.5.42). MariaDB client for C (the LGPL version) is also included. Release notes[1] state that in Debian 9 only one MySQL variant will be shipped. Hopefully the decision will tip towards MariaDB. The MariaDB "request for packaging" issue[2] was opened in bugs.debian.org in 2010. I started doing MariaDB packaging for Debian in 2013. The path here has been long and I am glad that this milestone is finally reached. [1] https://www.debian.org/releases/jessie/amd64/release-notes/ch-whats-new.en.… [2] https://bugs.debian.org/cgi-bin/bugreport.cgi?bug=565308 ---------- Forwarded message ---------- From: Paul Wise <pabs(a)debian.org> Date: 2015-04-26 5:28 GMT+03:00 Subject: Debian 8 "Jessie" released To: debian-announce(a)lists.debian.org ------------------------------------------------------------------------ The Debian Project https://www.debian.org/ Debian 8 "Jessie" released press(a)debian.org April 25th, 2015 https://www.debian.org/News/2015/20150426 ------------------------------------------------------------------------ After almost 24 months of constant development the Debian project is proud to present its new stable version 8 (code name "Jessie"), which will be supported for the next 5 years thanks to the combined work of the Debian Security team [1] and of the Debian Long Term Support [2] team. 1: http://security-team.debian.org/ 2: https://wiki.debian.org/LTS "Jessie" ships with a new default init system, systemd. The systemd suite provides many exciting features such as faster boot times, cgroups for services, and the possibility of isolating part of the services. The sysvinit init system is still available in "Jessie". The UEFI ("Unified Extensible Firmware Interface") support introduced in "Wheezy" has also been greatly improved in Jessie. This includes workarounds for many known firmware bugs, support for UEFI on 32-bit systems, and support for 64-bit kernels with 32-bit UEFI firmware (with the latter being included only on our amd64/i386 "multi-arch" installation media). Since the previous release, members of the Debian project have also made important improvements to our supporting services. One of these is a browsable view of all source code shipped in Debian [3] currently available at sources.debian.net [4]. Of course, with over 20,000 source packages, it can be quite daunting to locate the right file. Therefore, we are also very pleased to present Debian Code Search [5], available at codesearch.debian.net [6]. Both services are complemented by a completely rewritten and more reponsive package tracking system [7]. 3: https://www.debian.org/News/weekly/2013/14/#sources 4: https://sources.debian.net 5: https://www.debian.org/News/weekly/2014/17/#DCS 6: https://codesearch.debian.net/ 7: https://tracker.debian.org/ This release includes numerous updated software packages, such as: * Apache 2.4.10 * Asterisk 11.13.1 * GIMP 2.8.14 * an updated version of the GNOME desktop environment 3.14 * GNU Compiler Collection 4.9.2 * Icedove 31.6.0 (an unbranded version of Mozilla Thunderbird) * Iceweasel 31.6.0esr (an unbranded version of Mozilla Firefox) * KDE Plasma Workspaces and KDE Applications 4.11.13 * LibreOffice 4.3.3 * Linux 3.16.7-ctk9 * MariaDB 10.0.16 and MySQL 5.5.42 * Nagios 3.5.1 * OpenJDK 7u75 * Perl 5.20.2 * PHP 5.6.7 * PostgreSQL 9.4.1 * Python 2.7.9 and 3.4.2 * Samba 4.1.17 * Tomcat 7.0.56 and 8.0.14 * Xen Hypervisor 4.4.1 * the Xfce 4.10 desktop environment * more than 43,000 other ready-to-use software packages, built from nearly 20,100 source packages. With this broad selection of packages and its traditional wide architecture support, Debian once again stays true to its goal of being the universal operating system. It is suitable for many different use cases: from desktop systems to netbooks; from development servers to cluster systems; and for database, web, or storage servers. At the same time, additional quality assurance efforts like automatic installation and upgrade tests for all packages in Debian's archive ensure that "Jessie" fulfills the high expectations that users have of a stable Debian release. A total of ten architectures are supported: 32-bit PC / Intel IA-32 (i386), 64-bit PC / Intel EM64T / x86-64 (amd64), Motorola/IBM PowerPC (powerpc for older hardware and ppc64el for the new 64-bit (little- endian)), MIPS (mips (big-endian) and mipsel (little-endian)), IBM S/390 (64-bit s390x) and for ARM, armel and armhf for old and new 32-bit hardware, plus arm64 for the new 64-bit "AArch64" architecture. Want to give it a try? ---------------------- If you simply want to try Debian 8 "Jessie" without having to install it, you can use a special image, known as a live image, available for CDs, USB sticks, and netboot setups. Initially, these images are provided for the amd64 and i386 architectures only. It is also possible to use these live images to install Debian. More information is available from the Debian Live homepage [8]. 8: http://live.debian.net/ If, instead, you want to install it to your computer's permanent storage, you can choose from a range of installation media, such as Blu- ray Discs, DVDs, CDs, and USB sticks, or from the network. Several desktop environments — GNOME, KDE Plasma Desktop and Applications, Xfce, and LXDE — may be installed through CD images; the desired one may be chosen from the boot menus of the CDs/DVDs. In addition, multi- architecture CDs and DVDs are available which support installation of multiple architectures from a single disc. Or you can always create bootable USB installation media (see the Installation Guide [9] for more details). For cloud users Debian also offers pre-built OpenStack images [10], ready to use. 9: https://www.debian.org/releases/jessie/installmanual 10: http://cdimage.debian.org/cdimage/openstack/current/ The installation images may be downloaded right now via bittorrent [11] (the recommended method), jigdo [12], or HTTP [13]; see Debian on CDs [14] for further information. "Jessie" will soon be available on physical DVD, CD-ROM, and Blu-ray Discs from numerous vendors [15] too. 11: https://www.debian.org/CD/torrent-cd/ 12: https://www.debian.org/CD/jigdo-cd/#which 13: https://www.debian.org/CD/http-ftp/ 14: https://www.debian.org/CD/ 15: https://www.debian.org/CD/vendors Upgrading Debian ---------------- Upgrades to Debian 8 from the previous release, Debian 7 (codenamed "Wheezy"), are automatically handled by the apt-get package management tool for most configurations. As always, Debian systems may be upgraded painlessly, in place, without any forced downtime, but it is strongly recommended to read the release notes [16] as well as the installation guide [17] for possible issues, and for detailed instructions on installing and upgrading. The release notes will be further improved and translated to additional languages in the weeks after the release. 16: https://www.debian.org/releases/jessie/releasenotes 17: https://www.debian.org/releases/jessie/installmanual About Debian ------------ Debian is a free operating system, developed by thousands of volunteers from all over the world who collaborate via the Internet. The Debian project's key strengths are its volunteer base, its dedication to the Debian Social Contract and Free Software, and its commitment to provide the best operating system possible. Debian 8 is another important step in that direction. Contact Information ------------------- For further information, please visit the Debian web pages at https://www.debian.org/ or send mail to <press(a)debian.org>. -- To UNSUBSCRIBE, email to debian-announce-REQUEST(a)lists.debian.org with a subject of "unsubscribe". Trouble? Contact listmaster(a)lists.debian.org Archive: https://lists.debian.org/20150426022805.GA7860@chianamo -- Check out our blog at http://seravo.fi/blog and follow @ottokekalainen

3 5

[Maria-discuss] Proxy users in MariaDB?
by Felipe Gasper 24 Apr '15

24 Apr '15

Hello, Is it possible to emulate user roles via PROXY in MariaDB? Basically, I want to log in as “temp_w3gj6d6” but have the system treat that user as “frank”, including setting of DEFINERs and the like. I see that there is a PAM plugin in MariaDB .. has anyone used that plugin to achieve this effect? Thank you! -Felipe Gasper Houston, TX

3 9

[Maria-discuss] New Question: Executing: gpg --ignore-time-conflict
by AskMonty KB 23 Apr '15

23 Apr '15

Hello, A new question has been asked in "MariaDB Community" by zakaria. Please answer it at http://mariadb.com/kb/en/executing-gpg-ignore-time-conflict/ as the person asking the question may not be subscribed to the mailing list. -------------------------------- HI, I want to install mariadb in ubuntu server 12.04, but i get this error Executing: gpg --ignore-time-conflict --no-options --no-default-keyring --secret-keyring .... gpg: requesting key 1BB943DB from hkp server keyserver.ubuntu.com gpg: key 1BB943DB: "MariaDB Package Signing Key <package-signing-key(a)mariadb.org>" imported gpg: no ultimately trusted keys found gpg: Total number processed: 1 gpg: imported: 1 when I use this following command : apt-key adv --recv-keys --keyserver hkp://keyserver.ubuntu.com:80 0xcbcb082a1bb943db I tried to create a file with full key : 1993 69E5 404B D5FC 7D2F E43B CBCB 082A 1BB9 43DB but i got gpg:no valid openPGP data found. kind regards -------------------------------- To view or answer this question please visit: http://mariadb.com/kb/en/executing-gpg-ignore-time-conflict/

1 0