September 2016 - discuss - lists.mariadb.org

[Maria-discuss] why stdout? -> [Note] /usr/libexec/mysqld (mysqld 10.0.20-MariaDB) starting as process 115096
by Reindl Harald 05 Jul '20

05 Jul '20

Aug 6 12:24:24 testserver mysqld: 150806 12:24:24 [Note] /usr/libexec/mysqld (mysqld 10.0.20-MariaDB) starting as process 115096 ... why is this now stdout instead mysql logs? on systemd based distributions that spits now to the global syslog and finally on machines restarting 2 instances every hour for backup reasons it annoys until 10.0.19 or 10.0.20 that was not this way

5 13

[Maria-discuss] GRANT PROXY access denied with proxied User
by Fabian Jucker 04 Nov '16

04 Nov '16

Hi, At our enterprise we have a DBA-User proxied with "GRANT PROXY ON 'dba'@'%' TO ''@'%'" and backed by pam module (roughly according to [1]) to login from our ldap-accounts. When logging in via pam into the DBA-Role I'm unable to grant the proxy privileges to other users. Following [2] (MySQL docs, because the MariaDB docs are lacking any further information about this) I already tried to "GRANT PROXY ON 'dba'@'%' TO ''@'%' WITH GRANT OPTION" and "GRANT PROXY ON ''@'' TO 'dba'@'%' WITH GRANT OPTION" (as [2] is ambiguous about if the "proxied_user" or the "proxy_user" should have the "WITH GRANT OPTION"), but neither the first grant nor the second one showed any effect. When I grant the proxy privilege with grant option to a local user, this user is able to grant the proxy privileges to other users. So my question is, if it's not possible to grant proxy privileges while one's logged in with a proxy user? Thanks in advance, Fabian References: [1]: https://mariadb.com/blog/configuring-pam-authentication-and-user-mapping-ma… [2]: https://dev.mysql.com/doc/refman/5.5/en/proxy-users.html

1 1

[Maria-discuss] MariaDB Knowledge base - 500 error
by Karthick Subramanian 21 Oct '16

21 Oct '16

Did anyone facing this 500 error while accessing the Maria DB Knowledge Base. Thank you. Don't know to whom we need to report this, so sending to this mail ID. Sorry if it cause any inconvenient for others. When we click the Support in MariaDb website, getting below error: Database Error: *There seems to be a problem connecting to the database server specified in your configuration file. Please contact your local system administrator for further assistance. *

4 3

[Maria-discuss] eviction in information_schema?
by l vic 20 Oct '16

20 Oct '16

How can i detect eviction of node from the cluster from "information_schema" other than decreasing of WSREP_CLUSTER_SIZE? Thanks,

3 3

[Maria-discuss] Virtual CHECK constraint using Virtual columns
by Peter Laursen 16 Oct '16

16 Oct '16

As described in this Blog http://mablomy.blogspot.dk/2016/04/check-constraint-for-mysql-not-null-on.h…. A very nice hack/trick IMO. However it is not working with MariaDB as VC's cannot be declared NOT NULL. What prevents that? -- Peter -- Webyog

3 7

[Maria-discuss] MariaDB 10.1.18 now available
by Daniel Bartholomew 30 Sep '16

30 Sep '16

The MariaDB project is pleased to announce the immediate availability of MariaDB 10.1.18. This is a stable (GA) release. See the Release Notes and Changelog for details. - - Links - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - MariaDB 10.1.18 - Release Notes: https://mariadb.com/kb/en/mdb-10118-rn/ - Changelog: https://mariadb.com/kb/en/mdb-10118-cl/ - Downloads: https://downloads.mariadb.org/mariadb/10.1.18 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 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/mariadb Google+ - http://google.com/+mariadb Facebook - http://fb.com/MariaDB.dbms Knowledge Base - http://mariadb.com/kb

1 0

[Maria-discuss] Reg Maria DB + .Net Combination
by Karthick Subramanian 30 Sep '16

30 Sep '16

All, Can anyone share your experience or reference on below: 1. Production system with Maria DB and .Net environment 2. Transaction throughput, performance issues 3. Any challenges in terms of connectors etc. Thank you. Regards, Karthick

1 0

[Maria-discuss] Regarding ROLE
by Karthick Subramanian 29 Sep '16

29 Sep '16

All, When I GRANT ROLE to a USER, its throwing error: ERROR 1819 (HY000): Your password does not satisfy the current policy requirements +---------+------+----------------------------------------------------------------+ | Level | Code | Message | +---------+------+----------------------------------------------------------------+ | Warning | 1819 | cracklib: it is WAY too short | | Error | 1819 | Your password does not satisfy the current policy requirements | | Error | 1961 | Cannot grant role 'developer' to: 'apiuser'@'some ip'. | +---------+------+----------------------------------------------------------------+ Can anyone guide me on how to tackle this? Thank you. Regards, Karthick

1 1

[Maria-discuss] MariaDB 10.2.2 Beta now available
by Daniel Bartholomew 27 Sep '16

27 Sep '16

The MariaDB project is pleased to announce the immediate availability of MariaDB 10.2.2 Beta. This is the first beta release in the MariaDB 10.2 series. See the Release Notes and Changelog for details. - - Links - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - MariaDB 10.2.2 Beta - Release Notes: https://mariadb.com/kb/en/mdb-1022-rn/ - Changelog: https://mariadb.com/kb/en/mdb-1022-cl/ - Downloads: https://downloads.mariadb.org/mariadb/10.2.2 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/mariadb Google+ - http://google.com/+mariadb Facebook - http://fb.com/MariaDB.dbms Knowledge Base - http://mariadb.com/kb

1 0

[Maria-discuss] (no subject)
by l vic 24 Sep '16

24 Sep '16

Is there is a good way to remove a node from a galera cluster besides just killing it? / Are there are any implications of killing a node? Thanks,

2 1