Re: MySQL LDAP Authentication Plugin - Full example with source code

2012-08-20 Thread Ignacio Ocampo
Hi Rick, The plugin does not need to access to /etc/passwd or /etc/shadow. It uses an LDAP Server to authenticate the user through "ldap_simple_bind_s" function. Best regards. On Mon, Aug 20, 2012 at 7:24 PM, Rick James wrote: > Does that depend on mysql running as "root" in order to see /etc

RE: MySQL LDAP Authentication Plugin - Full example with source code

2012-08-20 Thread Rick James
Does that depend on mysql running as "root" in order to see /etc/shadow (or whatever)? If so, that is too big a security hole to do. > -Original Message- > From: Ignacio Ocampo [mailto:naf...@gmail.com] > Sent: Sunday, August 12, 2012 3:54 PM > To: mysql > Subject: MySQL LDAP Authenticat

RE: Best design for a table using variant data

2012-08-20 Thread Rick James
Even if you get past those issues, you will get to other nasty problems... Ugly JOINs, terrible performance, huge disk footprint, etc. Split the attributes into two groups: * The ones you _really_ need to search on. * The rest. Build columns for the first group; use the appropriate datatypes. Th

RE: Machine Learning

2012-08-20 Thread Martin Gainty
When I hear 'AI' I always imagine theres a HAL 9001 behind the scenes that is running the show constantly admonishing its creator to "take another stress pill" Sounds like a fun project Keep us apprised, Martin Gainty __ Verzicht und Vertraulichkei

Re: Machine Learning

2012-08-20 Thread Garot Conklin
Ya the idea is not anything new, but must be apparently quit difficult or not a priority as I have yet to find it already implemented anywhere... Far be it from me to not make some attempt here anyway... I am creating a fully automated framework from which a distributed infrastructure can be ma

RE: Machine Learning

2012-08-20 Thread webmaster
Hi Garot, You'll have to elaborate some more ... I understand you may want to protect the idea as well, so if you can narrow it down to some technical specifics then it'll help. What is the objective of this system, for instance ? Thanks, Justin From: Martin Gainty [mailto:mgai...@

Re: Machine Learning

2012-08-20 Thread Garot Conklin
MG>which trends or patterns will you be modelling?  ALL (interesting answer if you allow yourself to consider that there really are no restrictions aside from those we would impose here) MG>which indexes are you considering: Unique index, primary index or foreign index?Primary for speed however

RE: Machine Learning

2012-08-20 Thread Martin Gainty
From: garotconk...@yahoo.com Subject: Re: Machine Learning To: webmas...@lisol.co.uk; mgai...@hotmail.com; mysql@lists.mysql.com My initial thought was to propagate the db with everything and allow the algorithm to then begin to determin trends/patterns MG>which trends or patterns will you be m

RE: Hi, how did u do de-emphasis of sql statements?

2012-08-20 Thread Rick James
Let me change your example slightly... select * from table where name>’A’ versus select * from table where name>’Z’ Now, let's assume you have an INDEX starting with `name` and names are distributed in the typical way. The will be perhaps 1% of the names satisfying >'Z', but 95% satisfying >'A'.

Re: Machine Learning

2012-08-20 Thread Garot Conklin
My initial thought was to propagate the db with everything and allow the algorithm to then begin to determin trends/patterns and begin either an indexing methodology, additional table/db creation process or both to further optimize the calls being made and build in some internal levels of redund

Re: update doesn't

2012-08-20 Thread william drescher
On 8/20/2012 10:09 AM, Mogens Melander wrote: On Sun, August 19, 2012 18:19, william drescher wrote: On 8/17/2012 12:13 PM, Rik Wasmus wrote: I get 1 row affected, but the status does not change when I look at the row. If I set it to 'X' it does change. To make it even more wacky, if I (usin

Re: update doesn't

2012-08-20 Thread Mogens Melander
On Sun, August 19, 2012 18:19, william drescher wrote: > On 8/17/2012 12:13 PM, Rik Wasmus wrote: >>> I get 1 row affected, but the status does not change when I look >>> at the row. >>> >>> If I set it to 'X' it does change. >>> >>> To make it even more wacky, if I (using phpMyAdmin) change it to

ANN: Database Workbench 4.3.1, the multi-DBMS IDE now available!

2012-08-20 Thread Martijn Tonies
ort. For more information, see http://www.upscene.com/go/?go=news&id=20120820 The FREE Lite Editions will follow later. Changes include: - NEW: Stored Procedure & Trigger debugger for MySQL - NEW: incremental data search in SQL, Table & View Editor - FIXED: Oracle Debugger fixes - FIX

RE: Machine Learning

2012-08-20 Thread webmaster
Hi Garot, This sounds an interesting idea. Are you looking to store all known commands and their options or are you looking for a 'formula' for calling any unix command ? The reason for my question is that, at the end of the day, a unix command is just a program that is run in the operating syst