(so other people seem to abuse this alias, so it's my turn ... besides I've added some actual content as well)
Does everyone who uses MySQL, use InnoDB as the storage engine layer? Has anyone ever gotten BDB (BerkleyDB) to work under MySQL, and run an app/benchmarks aggressive enough to know which (InnoDB or BDB) is faster/better? Just idlely curious. Cheers, Brett Shirley On Thu, 16 Jun 2005, Medeiros, Jose wrote: > Hi Rick, > > Point well taken. I also do agree MYSQL is a fine database and a great value. > > Peace, > > Jose Medeiros :-) > www.ntea.net > www.tvnug.org > www.sfntug.org > > ---------------------------------------------------- > > -----Original Message----- > From: [EMAIL PROTECTED] > [mailto:[EMAIL PROTECTED] Behalf Of Rick Kingslan > Sent: Wednesday, June 15, 2005 6:08 PM > To: ActiveDir@mail.activedir.org > Subject: RE: [ActiveDir] Passwords from SQL > > > The reason that it's off the point is because: > > 1) MySQL is the database in which the application is deployed. > 2) Moving it the MSSQL might exceed the realistic 'cost' of the database > 3) It might be just as easy to use OpenLDAP (I'm assuming MySQL on Linux) > and communicate with AD that way > > Make no mistake - I'm no bigot when it comes to using MS software. Quite > the contrary. But, there are times when the simple economics of a solution > scream out that Microsoft is not the right solution. > > Most schools that I work with are this way. Most of them would have to save > a huge chunk of non-salary related expenditures to afford a Standard version > of SQL. Hence, Access is a really popular option, even though getting it to > work in some of the multi-user scenarios sucks - plainly and simply. > > In one school that I work with, the majority of the desktop OSs that they > run are ones that I've donated. One of the servers OSs is as well. > > I'm not saying the you're wrong. Far from it, in fact. But, sometimes the > solution can't meet the available economic resources. > > Rick > > -----Original Message----- > From: [EMAIL PROTECTED] > [mailto:[EMAIL PROTECTED] On Behalf Of Medeiros, Jose > Sent: Wednesday, June 15, 2005 7:04 PM > To: ActiveDir@mail.activedir.org > Subject: RE: [ActiveDir] Passwords from SQL > > Hi Rick , > > Actually how is this off the point? He is looking for a solution that will > allow him to use the same user accounts in AD and authenticate against > MYSQL, right? He wants to save the time and labor of having to manually > update user accounts and passwords since they are maintained by two separate > systems and since there are no built in utilities in AD that allow him to > easily do so with an Open Source Database such as MYSQL. I strongly believe > that by changing to a Microsoft SQL database this allows him to then use > integrated authentication and it would solve his problem ( He may not have > been aware that Microsoft SQL has had this feature since as far back as > version 6.5 ). > > If the school can't even afford 2000.00 for an SQL database, I seriously > doubt that they would have an 8 way server that would easily cost 20,000 or > more. > > But enough said, as far as I am concerned he has two choices and routes he > can take and it is up to him to educate his management at the school > district office that he has such a need and that the solution has a small > cost. I am sure that any educator with common sense would concur that just > because some thing is free it does not always mean it is the best solution > and easiest to maintain for every environment. > > Warmest regards, > > Jose Medeiros > Former CIS instructor > San Jose City College > > ---------------------------------------------------------------------------- > ----------- > > > > -----Original Message----- > From: [EMAIL PROTECTED] > [mailto:[EMAIL PROTECTED] Behalf Of Rick Kingslan > Sent: Wednesday, June 15, 2005 4:37 PM > To: ActiveDir@mail.activedir.org > Subject: RE: [ActiveDir] Passwords from SQL > > > Maybe they need an 8-way, or more than 2GB of RAM for the database that runs > on it. > > Honestly, though - this has gotten way off the point. He's running MySQL, > and doesn't look like he's going to change just because we thought MSSQL is > a better fit. Or not.... > > Rick > > -----Original Message----- > From: [EMAIL PROTECTED] > [mailto:[EMAIL PROTECTED] On Behalf Of Medeiros, Jose > Sent: Wednesday, June 15, 2005 4:07 PM > To: ActiveDir@mail.activedir.org > Subject: RE: [ActiveDir] Passwords from SQL > > Why do you need the Enterprise version, are you running SQL Cluster's for > failover? > > Jose > > > > -----Original Message----- > From: [EMAIL PROTECTED] > [mailto:[EMAIL PROTECTED] Behalf Of Jacob Stabl > Sent: Wednesday, June 15, 2005 12:25 PM > To: ActiveDir@mail.activedir.org > Subject: RE: [ActiveDir] Passwords from SQL > > > Well we purchased the enterprise MSSQL version. Also we have already > purchased exchange here > > > -- > Jake > > -----Original Message----- > From: [EMAIL PROTECTED] > [mailto:[EMAIL PROTECTED] On Behalf Of Medeiros, Jose > Sent: Wednesday, June 15, 2005 3:13 PM > To: ActiveDir@mail.activedir.org > Subject: RE: [ActiveDir] Passwords from SQL > > Hi Jake, > > I know that Exchange is dirt cheap for Educational use, I am sure that SQL > is also much less. Let me check with an educational speacilist at Microsoft > in San Francisco and see what it actually may be. Just doing a serach on > the web for the retail copy comes up with. > > Microsoft SQL Server 2000 Standard (5-Client) Full Version Retail Box > RETAIL Microsoft Part #: 228-00683 Save 18% off RETAIL $1,225.00 Retail > $1,489.00 > > Jose > > -----Original Message----- > From: [EMAIL PROTECTED] > [mailto:[EMAIL PROTECTED] Behalf Of Jacob Stabl > Sent: Wednesday, June 15, 2005 11:28 AM > To: ActiveDir@mail.activedir.org > Subject: RE: [ActiveDir] Passwords from SQL > > > Educational price for MSSQL 2000 or whatever newest version is over $2000 > > > -- > Jake > > -----Original Message----- > From: [EMAIL PROTECTED] > [mailto:[EMAIL PROTECTED] On Behalf Of Joe Pochedley > Sent: Wednesday, June 15, 2005 2:06 PM > To: ActiveDir@mail.activedir.org > Subject: RE: [ActiveDir] Passwords from SQL > > Free to acquire, yes... However, if you spend enough time in implementing, > creating, and supporting some functionality that you would otherwise gain in > the paid solution (password syncing?), have you really "saved" any money? > > It's not a knock against "free" software... I use MySQL here and have used > it for other personal applications as well... Sometimes "free" > isn't always the best solution... Of course there's always the oft repeated > quotes "Acquisition costs are only a fraction of TCO...." > > > Joe Pochedley > A computer terminal is not some clunky old television with a typewriter in > front of it. It is an interface where the mind and body can connect with the > universe and move bits of it about. -Douglas Adams > > -----Original Message----- > From: [EMAIL PROTECTED] > [mailto:[EMAIL PROTECTED] On Behalf Of joe > Sent: Wednesday, June 15, 2005 1:44 PM > To: ActiveDir@mail.activedir.org > Subject: RE: [ActiveDir] Passwords from SQL > > When you have next to nothing for a budget, next to nothing is a lot when > you can get it for free. :o) > > Of course free is a question begging term but for any uses I have used MySQL > for it has performed admirably. > > > > -----Original Message----- > From: [EMAIL PROTECTED] > [mailto:[EMAIL PROTECTED] On Behalf Of Medeiros, Jose > Sent: Wednesday, June 15, 2005 1:28 PM > To: ActiveDir@mail.activedir.org > Subject: RE: [ActiveDir] Passwords from SQL > > I am not sure why, Microsoft sells their products to education institutions > for next to nothing. > > Jose > > -----Original Message----- > From: [EMAIL PROTECTED] > [mailto:[EMAIL PROTECTED] Behalf Of Freddie Coleman III > Sent: Wednesday, June 15, 2005 10:22 AM > To: ActiveDir@mail.activedir.org > Subject: RE: [ActiveDir] Passwords from SQL > > > He's probably using MY SQL instead of MS SQL for monetary reasons. > Money is always an issue in education > > fred > > > > Hi Jacob, > > > > I have a better ID. If you use Microsoft SQL instead of MY SQL then > > you'll have the option of using Integrated Authentication and use the > > > usernames and passwords that your user's log into AD with. > > > > Jose > > > > -----Original Message----- > > From: [EMAIL PROTECTED] > > [mailto:[EMAIL PROTECTED] Behalf Of Jacob Stabl > > Sent: Wednesday, June 15, 2005 8:56 AM > > To: ActiveDir@mail.activedir.org > > Subject: [ActiveDir] Passwords from SQL > > > > > > > > I am running a MySQL server that holds data for a grading program here > > > in the district. Well teachers have the ability to change passwords > > through that software and I was curious if AD could import passwords > > for people on a scheduled increment from that SQL database. Can > > active directory connect to a SQL database to pull other information > > or possibly import users directly from that database?? > > > > -- > > Jacob Stabl > > Network Engineer > > Plain Local School District > > <http://www.plainlocal.org> http://www.plainlocal.org > > Office: 330.492.3500 > > Cell : 330.704.1278 > > IP Phone: 4466 > > > > List info : http://www.activedir.org/List.aspx > List FAQ : http://www.activedir.org/ListFAQ.aspx > List archive: http://www.mail-archive.com/activedir%40mail.activedir.org/ > > List info : http://www.activedir.org/List.aspx > List FAQ : http://www.activedir.org/ListFAQ.aspx > List archive: http://www.mail-archive.com/activedir%40mail.activedir.org/ > > List info : http://www.activedir.org/List.aspx > List FAQ : http://www.activedir.org/ListFAQ.aspx > List archive: http://www.mail-archive.com/activedir%40mail.activedir.org/ > List info : http://www.activedir.org/List.aspx List FAQ : http://www.activedir.org/ListFAQ.aspx List archive: http://www.mail-archive.com/activedir%40mail.activedir.org/
