Re: [Maria-discuss] Getting PAM auth to work with JDBC

2015-07-15 Thread Adam Scott
I have. Not much time to reply, but one major thing I had to do form my notes: 4. modify my.cnf and add line with: pam_use_cleartext_plugun requires restart For Old Workbench to work with this, set the environment variable LIB_MYSQL_CLEARTEXT_PLUGIN=1 For recet Workbench, in the

Re: [Maria-discuss] Password Complexity Plugin

2015-05-01 Thread Adam Scott
es 4) Debug yacc 5) run mysql-test Thank again, Adam On Thu, Apr 30, 2015 at 2:38 AM, Sergei Golubchik wrote: > Hi, Adam! > > On Apr 27, Adam Scott wrote: > > It's taken some time, but I have backported the simple_password_check > > plugin and the password api to

[Maria-discuss] Simple Password Check plugin Backported to 5.5

2015-04-29 Thread Adam Scott
exity 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

Re: [Maria-discuss] Password Complexity Plugin

2015-04-27 Thread Adam Scott
ation variable ( https://mariadb.com/kb/en/mariadb/server-system-variables/#strict_password_validation) ? 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? Thank you, Adam Scott On Thu, Jan 22, 2015 at

Re: [Maria-discuss] Enabling feedback pluging for MariaDB 10.1.4

2015-03-09 Thread Adam Scott
Maybe make it an option when installing? On Mon, Mar 9, 2015 at 1:05 PM, Justin Swanhart wrote: > Hi, > > I agree with Kristian. Given the way it works, the statistics are really > meaningless and I feel you shouldn't drive important choices based on bad > statistics. I personally would sug

Re: [Maria-discuss] The future of Dynamic Columns

2015-01-28 Thread Adam Scott
Just wanted to add, any application that wants to store forms data without having to create a new table every time you create a new form could benefit from dynamic columns. In the database design world, any design that is of the EAV (Entity-Attribute-Value) style would benefit from dynamic columns

Re: [Maria-discuss] Password Complexity Plugin

2015-01-22 Thread Adam Scott
nt id. I'll see if I can't grab the code and get it to compile for 5.5 unless that's in the works maybe? Thanks for getting back to me with the good details. Keep up the good work! Thanks Adam C. Scott On Thu, Jan 22, 2015 at 9:16 AM, Colin Charles wrote: > Hi! > > On 23 J

[Maria-discuss] Password Complexity Plugin

2015-01-22 Thread Adam Scott
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 t

Re: [Maria-discuss] InnoDB selected projects

2014-04-11 Thread Adam Scott
Second link is the same as the first one: MDEV-5834 On Wed, Mar 12, 2014 at 5:59 AM, Jan Lindström wrote: > Hi all, > > After careful weighting and selection process, I have selected following > two projects as a starting point to improve InnoDB > > (1) InnoDB file space defragmentation >

Re: [Maria-discuss] New Question: Maximum number of columns

2014-01-30 Thread Adam Scott
I believe it's the same as in MySQL. It does depend on the engine your table is using. By default it is probably InnoDB. For the full details about the limits: http://www.mysqlperformanceblog.com/2013/04/08/understanding-the-maximum-number-of-columns-in-a-mysql-table/ On Thu, Jan 30, 2014 at

Re: [Maria-discuss] Maria DB 10.0 Roles Usage

2013-11-13 Thread Adam Scott
eclare they want to use a particular role. > > Federico > > > Il Mercoledì 13 Novembre 2013 18:37, Adam Scott > ha scritto: > Roles are supported according to ( > https://blog.mariadb.org/mariadb-10-0-beta-launched-an-important-milestone/ > ) > > So the fol

[Maria-discuss] Maria DB 10.0 Roles Usage

2013-11-13 Thread Adam Scott
Roles are supported according to ( https://blog.mariadb.org/mariadb-10-0-beta-launched-an-important-milestone/) So the following commands worked: create role read_only;grant select on example.* to read_only;grant usage on example.* to read_only; grant select on example.* to app_report@'localhost'