February 2015 - discuss - lists.mariadb.org

[Maria-discuss] Password Complexity Plugin
by Adam Scott 01 May '15

01 May '15

Hi, I noticed MySQL 5.6 has a validate_password plugin. Since it's open-source, can we add it to MariaDB 5.5. Or is that bad form, a hot potato, etc.? We need the features of this plugin in our environment, and the PAM integration is looking not a good "fit" (though it's working great). (I'm trying to get it to compile in right now, but it's having issues with the includes so far...working on it). Thanks, Adam C. Scott

4 7

[Maria-discuss] Serious problem with latest (10.0.16) Windows installer - destroys services.
by Peter Laursen 02 Mar '15

02 Mar '15

I have MariaDB 5.5, 10.0 and 10.1 installed (as Windows services named 'maria55'. 'maria10' and 'maria10_1' ) and always update them to latest soon after an update is available. Yesterday morning I installed 10.0.16 on top of 10.0.15 using the .msi installer. When I tried to connect to it a few hours later it was not possible. I thought the service might not be running. It wasn't. Actually it did not exist anymore at all! "net start maria10" returned "service does not exist" (and indeed it did not appear in Windows "services management" interface). I copied the /datadir, uninstalle , did a fresh install of 10.0.16d (choosing the option not to upgrade any existing server) and copied the old /datadir back. Now Maria 10.0(.16) works again. But now I see that the 'maria55' service is also gone from the system. Files are intact. I can repeat the exercise I did with 10.0 of course or install service again from commandline. Not a big problem, but very annoying and waste of time. MariaDB 10.1 installaton is not affected. 5 diiferent Oracle/MySQL servers (from 5.0 to 5.7) also are not. I need all those instances for application testing. Questions: * Has somebody else experienced this? * Has somebody replaced @wlad as maintainer of Windows installers? @wlad was the only person who ever was able to write reasonable MySQL/MariaDB installers. So I would regret that. It is perfectly legal on Windows to have multiple MariaDB servers simultaneously running as Windows services. They won't conflict as long as service name, port, basedir and datadir are all different. What happens with one should not affect another. I the installer does not respect this, it is a bug. -- Peter -- Webyog

5 10

[Maria-discuss] warning from binary tarball file installation.
by Peter Boston 28 Feb '15

28 Feb '15

I am installing mariadb-10.0.15 on Fedora 20 from a binary tarball file. After several changes on .my.cnf file, I minimized the installation warning to three. I am using the default my-large.cnf file from the release. How can I eliminate them, particularly the last one: Failed to load slave replication state from table mysql.gtid_slave_pos: 1146: Table 'mysql.gtid_slave_pos' doesn't exist. Thanks, [root@dev2 mysql]# ./scripts/mysql_install_db --defaults-file=~/.my.cnf --user=mysql Installing MariaDB/MySQL system tables in './data' ... 150225 10:37:35 [Note] InnoDB: Using mutexes to ref count buffer pool pages 150225 10:37:35 [Note] InnoDB: The InnoDB memory heap is disabled 150225 10:37:35 [Note] InnoDB: Mutexes and rw_locks use GCC atomic builtins 150225 10:37:35 [Note] InnoDB: Memory barrier is not used 150225 10:37:35 [Note] InnoDB: Compressed tables use zlib 1.2.3 150225 10:37:35 [Note] InnoDB: Using Linux native AIO 150225 10:37:35 [Note] InnoDB: Not using CPU crc32 instructions 150225 10:37:35 [Note] InnoDB: Initializing buffer pool, size = 384.0M 150225 10:37:35 [Note] InnoDB: Completed initialization of buffer pool 150225 10:37:35 [Note] InnoDB: The first specified data file /usr/local/mysql/data/ibdata1 did not exist: a new database to be created! 150225 10:37:35 [Note] InnoDB: Setting file /usr/local/mysql/data/ibdata1 size to 2000 MB 150225 10:37:35 [Note] InnoDB: Database physically writes the file full: wait... InnoDB: Progress in MB: 100 200 300 400 500 600 700 800 900 1000 1100 1200 1300 1400 1500 1600 1700 1800 1900 2000 150225 10:37:42 [Note] InnoDB: Data file /usr/local/mysql/data/ibdata2 did not exist: new to be created 150225 10:37:42 [Note] InnoDB: Setting file /usr/local/mysql/data/ibdata2 size to 10 MB 150225 10:37:42 [Note] InnoDB: Database physically writes the file full: wait... 150225 10:37:42 [Note] InnoDB: Setting log file /usr/local/mysql/data/ib_logfile101 size to 100 MB InnoDB: Progress in MB: 100 150225 10:37:43 [Note] InnoDB: Setting log file /usr/local/mysql/data/ib_logfile1 size to 100 MB InnoDB: Progress in MB: 100 150225 10:37:43 [Note] InnoDB: Renaming log file /usr/local/mysql/data/ib_logfile101 to /usr/local/mysql/data/ib_logfile0 150225 10:37:43 [Warning] InnoDB: New log files created, LSN=45782 150225 10:37:43 [Note] InnoDB: Doublewrite buffer not found: creating new 150225 10:37:43 [Note] InnoDB: Doublewrite buffer created 150225 10:37:43 [Note] InnoDB: 128 rollback segment(s) are active. 150225 10:37:43 [Warning] InnoDB: Creating foreign key constraint system tables. 150225 10:37:43 [Note] InnoDB: Foreign key constraint system tables created 150225 10:37:43 [Note] InnoDB: Creating tablespace and datafile system tables. 150225 10:37:43 [Note] InnoDB: Tablespace and datafile system tables created. 150225 10:37:43 [Note] InnoDB: Waiting for purge to start 150225 10:37:43 [Note] InnoDB: Percona XtraDB (http://www.percona.com) 5.6.21-70.0 started; log sequence number 0 150225 10:37:43 [Warning] Failed to load slave replication state from table mysql.gtid_slave_pos: 1146: Table 'mysql.gtid_slave_pos' doesn't exist 150225 10:37:43 [Note] InnoDB: FTS optimize thread exiting. 150225 10:37:43 [Note] InnoDB: Starting shutdown... 150225 10:37:45 [Note] InnoDB: Shutdown completed; log sequence number 1616698 OK Filling help tables... 150225 10:37:45 [Note] InnoDB: Using mutexes to ref count buffer pool pages 150225 10:37:45 [Note] InnoDB: The InnoDB memory heap is disabled 150225 10:37:45 [Note] InnoDB: Mutexes and rw_locks use GCC atomic builtins 150225 10:37:45 [Note] InnoDB: Memory barrier is not used 150225 10:37:45 [Note] InnoDB: Compressed tables use zlib 1.2.3 150225 10:37:45 [Note] InnoDB: Using Linux native AIO 150225 10:37:45 [Note] InnoDB: Not using CPU crc32 instructions 150225 10:37:45 [Note] InnoDB: Initializing buffer pool, size = 384.0M 150225 10:37:45 [Note] InnoDB: Completed initialization of buffer pool 150225 10:37:45 [Note] InnoDB: Highest supported file format is Barracuda. 150225 10:37:45 [Note] InnoDB: 128 rollback segment(s) are active. 150225 10:37:45 [Note] InnoDB: Waiting for purge to start 150225 10:37:45 [Note] InnoDB: Percona XtraDB (http://www.percona.com) 5.6.21-70.0 started; log sequence number 1616698 150225 10:37:46 [Note] InnoDB: FTS optimize thread exiting. 150225 10:37:46 [Note] InnoDB: Starting shutdown... 150225 10:37:48 [Note] InnoDB: Shutdown completed; log sequence number 1616708 OK

2 1

[Maria-discuss] Default privileges for anon. user.
by dE 26 Feb '15

26 Feb '15

Hi! I've realized that by default MariaDB allow full access to a database for anon. users. $ mysql --user asdfasdf test MariaDB [test]> insert into test (sr) values (1); Query OK, 1 row affected (0.12 sec) I tried to revoke but -- Revoke all on test.test from ''@''; ERROR 1141 (42000): There is no such grant defined for user '' on host '%' Is there anyway to disallow all types of access to anon. users?

2 2

[Maria-discuss] questions from a new user
by Peter Boston 25 Feb '15

25 Feb '15

I am new to use mariadb on linux machine. I am using Fedora 20 and I have downloaded the mariadb 10.0.15 tar.gz file and its instruction. I removed the existing mariadb from my Fedora 20. I have installed the mariadb on my machine by following the official instruction. It seems successful (without error) but I cannot start it as expected. I also have few other basic questions. Some background information here: this database will be accessed by a local application. This local application may be running under a general user account, user1. I installed it in /var/local as a root user. Questions: 1. How to uninstall it completely? I want to try again to see if I did anything wrong before. 2. Because it will be accessed by a local application and the local application will be running by a general user, user1, should I install it with user1? 3. Basically I am confused with these three users: user1, mysql and root. "user1" will be used to run the application and login the machine. "mysql" will be used to connect the mariadb. "root" will be used to install mariadb into /usr/local. Who will start the mariadb? It will be "root", I guess. But if "root" starts the service, "user1" and "mysql" don't have problem to access its resources? 4. If I don't want to install it as root, can I still install it under the /usr/local directory? 5. I renamed the my-large.cnf to .my.cnf and uncomment the InnoDB table section. Is this only change I need to make if I want to use InnoDB? should I disable the myisam? how? 6. where should I put the .my.cnf file? put into the home directory of the user who starts the mariadb or the user who logon the system if they are different? 7. there is a my.cnf file from the Fedora 20 installation, when I start mariadb without the "--defaults-file=~/.my.cnf" option, I will get the following error from the log: [ERROR] mysqld: Can't create/write to file '/var/run/mysqld/mysqld.pid' (Errcode: 2 "No such file or directory") I have to manually create the mysqld folder inside the /var/run folder each time after reboot. how to avoid this? 8. After started with that "old" my.cnf, I try to stop the mariadb but cannot because I cannot find its service name: [user1@dev2 mysql]$ ./bin/mysqladmin -u root -p status Enter password: Uptime: 685 Threads: 1 Questions: 3 Slow queries: 0 Opens: 0 Flush tables: 1 Open tables: 62 Queries per second avg: 0.004 [user1@dev2 mysql]$ sudo systemctl status mariadb.service mariadb.service Loaded: not-found (Reason: No such file or directory) Active: inactive (dead) [user1@dev2 mysql]$ sudo systemctl status mysql.service mysql.service Loaded: not-found (Reason: No such file or directory) Active: inactive (dead) [user1@dev2 mysql]$ sudo systemctl status mysqld.service mysqld.service Loaded: not-found (Reason: No such file or directory) Active: inactive (dead) how stop it? 9. if I start mariadb with the renamed my-large.cnf ([root@dev2 mysql]# ./bin/mysqld_safe --defaults-file=~/.my.cnf --user=mysql), I got the following error: 150225 0:09:28 [ERROR] Can't open the mysql.plugin table. Please run mysql_upgrade to create it. 150225 0:09:28 [Note] Recovering after a crash using mysql-bin 150225 0:09:28 [Note] Starting crash recovery... 150225 0:09:28 [Note] Crash recovery finished. 150225 0:09:28 [Warning] Failed to load slave replication state from table mysql.gtid_slave_pos: 1146: Table 'mysql.gtid_slave_pos' doesn't exist 150225 0:09:28 [ERROR] Can't open and lock privilege tables: Table 'mysql.servers' doesn't exist 150225 0:09:28 [Note] Server socket created on IP: '::'. 150225 0:09:28 [ERROR] Fatal error: Can't open and lock privilege tables: Table 'mysql.user' doesn't exist 150225 00:09:28 mysqld_safe mysqld from pid file /usr/local/mysql/data/dev2.pid ended Then I try do upgrade as suggested above: [root@dev2 mysql]# ./bin/mysql_upgrade Version check failed. Got the following error when calling the 'mysql' command line client ERROR 2002 (HY000): Can't connect to local MySQL server through socket '/tmp/mysql.sock' (2 "No such file or directory") FATAL ERROR: Upgrade failed so I think I need to make the mariadb running first, I use above 7 to make server running and then do upgrade, I got the following errors: [user1@dev2 mariadb-10.0.15-linux-x86_64]$ sudo ./bin/mysql_upgrade [sudo] password for user1: Phase 1/5: Checking mysql database Processing databases mysql mysql.column_stats OK mysql.columns_priv OK mysql.db OK mysql.event OK mysql.func OK mysql.gtid_slave_pos Error : Table 'mysql.gtid_slave_pos' doesn't exist in engine status : Operation failed mysql.help_category OK mysql.help_keyword OK mysql.help_relation OK mysql.help_topic OK mysql.host OK mysql.index_stats OK mysql.innodb_index_stats Error : Table 'mysql.innodb_index_stats' doesn't exist in engine status : Operation failed mysql.innodb_table_stats Error : Table 'mysql.innodb_table_stats' doesn't exist in engine status : Operation failed mysql.plugin OK mysql.proc OK mysql.procs_priv OK mysql.proxies_priv OK mysql.roles_mapping OK mysql.servers OK mysql.table_stats OK mysql.tables_priv OK mysql.time_zone OK mysql.time_zone_leap_second OK mysql.time_zone_name OK mysql.time_zone_transition OK mysql.time_zone_transition_type OK mysql.user OK Repairing tables mysql.gtid_slave_pos Error : Table 'mysql.gtid_slave_pos' doesn't exist in engine status : Operation failed mysql.innodb_index_stats Error : Table 'mysql.innodb_index_stats' doesn't exist in engine status : Operation failed mysql.innodb_table_stats Error : Table 'mysql.innodb_table_stats' doesn't exist in engine status : Operation failed Phase 2/5: Running 'mysql_fix_privilege_tables'... ERROR 1932 (42S02) at line 580: Table 'mysql.innodb_index_stats' doesn't exist in engine ERROR 1932 (42S02) at line 583: Table 'mysql.innodb_table_stats' doesn't exist in engine FATAL ERROR: Upgrade failed why I cannot run mariadb with the my.cnf which comes with this version of mariadb? The old my.cnf doesn't have innoDB section and I cannot enable it. Is this the reason? does the Fedora 20 support mariadb 10.0.15? Thanks, Peter

3 4

[Maria-discuss] New Question: other connectors
by AskMonty KB 24 Feb '15

24 Feb '15

Hello, A new question has been asked in "Client Libraries" by ferreirah. Please answer it at http://mariadb.com/kb/en/other-connectors/ as the person asking the question may not be subscribed to the mailing list. -------------------------------- Hi, Any plans for connectors for the dot net framework? H.F. -------------------------------- To view or answer this question please visit: http://mariadb.com/kb/en/other-connectors/

1 0

[Maria-discuss] SHOW GRANTS: MySQL vs. MariaDB
by Felipe Gasper 24 Feb '15

24 Feb '15

Hi all, We have custom logic in place that “suspends” a MySQL user by: - reversing the password hash - replacing the leading “*” with “-” In other words (pseudo-code): my $hash = SELECT password FROM mysql.user WHERE user = 'theuser'; $hash = $hash.replace(/^\*/,"").reverse(); UPDATE mysql.user SET password = "-$hash" WHERE user = 'theuser'; I have noticed that MySQL’s SHOW GRANTS reports these “suspended” password hashes with the leading dash “fixed” to a leading asterisk. MariaDB 10, though, has SHOW GRANTS report the literal contents of mysql.user. Is this behavior by design in MariaDB 10? Is it behavior that we can depend on moving forward? -FG

2 1

[Maria-discuss] Dependency questions regarding MariaDB 10 on CentOS6.5 with local mirror of repo
by Sophie L 23 Feb '15

23 Feb '15

Hi everybody, I mirrored MariaDB repo,but noticed servers had unmet dependencies when I tried to install. I have this message: Error: Package: MariaDB-client-10.0.16-1.fc20.x86_64 (mariadb) Error: Package: MariaDB-client-10.0.16-1.fc20.x86_64 (mariadb) Requires: libstdc++.so.6(GLIBCXX_3.4.15)(64bit) Error: Package: galera-25.3.5-1.sles12.x86_64 (mariadb) Requires: libssl.so.1.0.0()(64bit) Error: Package: galera-25.3.5-1.sles12.x86_64 (mariadb) Requires: libcrypto.so.1.0.0()(64bit) Error: Package: MariaDB-Galera-server-10.0.16-1.fc20.x86_64 (mariadb) Requires: libstdc++.so.6(GLIBCXX_3.4.15)(64bit) Error: Package: MariaDB-client-10.0.16-1.fc20.x86_64 (mariadb) Requires: libc.so.6(GLIBC_2.17)(64bit) Error: Package: MariaDB-client-10.0.16-1.fc20.x86_64 (mariadb) Requires: libc.so.6(GLIBC_2.14)(64bit) Error: Package: MariaDB-Galera-server-10.0.16-1.fc20.x86_64 (mariadb) Requires: libc.so.6(GLIBC_2.17)(64bit) Error: Package: MariaDB-Galera-server-10.0.16-1.fc20.x86_64 (mariadb) Requires: libc.so.6(GLIBC_2.15)(64bit) Error: Package: MariaDB-Galera-server-10.0.16-1.fc20.x86_64 (mariadb) Requires: libc.so.6(GLIBC_2.14)(64bit) Error: Package: galera-25.3.5-1.sles12.x86_64 (mariadb) Requires: libc.so.6(GLIBC_2.14)(64bit) Error: Package: galera-25.3.5-1.sles12.x86_64 (mariadb) Requires: aaa_base Error: Package: galera-25.3.5-1.sles12.x86_64 (mariadb) Requires: libstdc++.so.6(GLIBCXX_3.4.15)(64bit) My server has libstdc++ 4.4.7. Can MariaDb 10 run with this recent version? My apologies if this is not specific to MariaDB. Maybe it it. Would somebody give me some advice? Kind regards, Sophie. Some details, Linux maria1 2.6.32-431.5.1.el6.x86_64 #1 SMP Wed Feb 12 00:41:43 UTC 2014 x86_64 x86_64 x86_64 GNU/Linux # cat /etc/centos-release CentOS release 6.5 (Final) # locate libstdc++.so.6 /usr/lib64/libstdc++.so.6 /usr/lib64/libstdc++.so.6.0.13 # locate libc.so.6 /lib64/libc.so.6 Installed Packages Name : libstdc++ Arch : x86_64 Version : 4.4.7 Release : 4.el6 Size : 964 k Repo : installed >From repo : anaconda-CentOS-201311291202.x86_64

3 4

[Maria-discuss] Mariadb galera tolerance to network and io latency
by Lyle Franklin 21 Feb '15

21 Feb '15

Recently we observed that when network and IO latency increased significantly (and correspondingly, that bandwidth reduced significantly) all nodes in a 3-node mariadb galera cluster reported the other nodes as partitioned. We understand that by default galera is configured to wait 6 seconds before declaring other nodes partitioned. Is there any additional documentation on the performance on mariadb/galera with respect to network/IO latency and bandwidth? Are there hard limits beyond which a cluster is known to fail, and soft limits which are known to degrade performance? Thanks, Rob and Lyle Cloud Foundry Core Services

1 0

[Maria-discuss] New Question: Replication with 2 different minor version
by AskMonty KB 20 Feb '15

20 Feb '15

Hello, A new question has been asked in "Standard Replication" by micimici. Please answer it at http://mariadb.com/kb/en/replication-with-2-different-minor-version/ as the person asking the question may not be subscribed to the mailing list. -------------------------------- Hallo Support I have a question about replication As source... I have MariaDB 5.5.37 and destination is 5.5.41 Do you know if replication will work with those 2 different versions ? thanks for any info -------------------------------- To view or answer this question please visit: http://mariadb.com/kb/en/replication-with-2-different-minor-version/

1 0