Re: Event feature already working in Server 5.1.37
Hi friends, This isn't rarelly to see...its common on these days. Get this: http://dev.mysql.com/tech-resources/articles/mysql_on_windows.html WB 2010/1/27 Shawn Green shawn.gr...@sun.com Daevid Vincent wrote: -Original Message- From: Dan Nelson [mailto:dnel...@allantgroup.com] Sent: Monday, January 25, 2010 11:42 PM To: Daevid Vincent ...snipped ... People really use Windows for a mySQL server? Weird. ... Yes, they do. Not only is MySQL as cheap as the free version of MS SQL but it doesn't suffer from the hard limits the free version of MS SQL imposes and it works across all of your servers, regardless of platform. MS products are limited to Windows boxes. You cannot assemble a new Linux box and get MS-anything to run on it natively. With C, C++, .NET, JAVA, and ODBC connection options available, it's very easy to make a connection to MySQL from practically any MS development language. Some connectors will even integrate themselves into Visual Studio. Windows, as foreign as it may seem, is actually a very viable MySQL development platform. I encourage you to try it out and let us know what you think. -- Shawn Green, MySQL Senior Support Engineer Sun Microsystems, Inc. Office: Blountville, TN -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/mysql?unsub=wagnerbianch...@gmail.com
Re: Need an extra pair of eyes
John, The use of is a logical and, the normal SQL keyword would be AND. As in: WHERE `productid` = 173846 AND `variantid` = 73130 AND `type` = 's' With regards, Martijn Tonies Upscene Productions http://www.upscene.com Download Database Workbench for Oracle, MS SQL Server, Sybase SQL Anywhere, MySQL, InterBase, NexusDB and Firebird! Database questions? Check the forum: http://www.databasedevelopmentforum.com I have a query that is giving me fits, but I can't find where there error is. I know its one of those things that I'll slap myself in the forehead for not seeing, but after a half an hour, it's all a blur. ;) If someone can spot it, I'd be most grateful. REPLACE INTO product_dimensions SET `productid` = '173846', `variantid` = '73130', `type` = 's', `height` = '3.7500', `width` = '3.5000', `depth` = '5.3300' WHERE `productid` = 173846 `variantid` = 73130 `type` = 's' I've also tried it this way REPLACE INTO product_dimensions ( `productid`, `variantid`, `type`, `height`, `width`, `depth` ) VALUES ( '173846', '73130', 's', '3.7500', '3.5000', '5.3300' ) WHERE `productid` = 173846 `variantid` = 73130 `type` = 's' And the error for both is the same: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'WHERE `productid` = 173846 `variantid` = 73130 `type` = 's'' at line 1 -- John C. Nichel IV System Administrator KegWorks http://www.kegworks.com 716.362.9212 x16 j...@kegworks.com -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/mysql?unsub=m.ton...@upscene.com -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/mysql?unsub=arch...@jab.org
Re: Event feature already working in Server 5.1.37
On Tue, Jan 26, 2010 at 10:43 PM, Daevid Vincent dae...@daevid.com wrote: 12+ notebooks, netbooks, desktops, etc. But for any LAMP dev work, I either have a dedicated Linux box setup or a Virtual Machine. Well... It wouldn't be *Linux*-Apache-Mysql-PHP otherwise, would it :-) -- Bier met grenadyn Is als mosterd by den wyn Sy die't drinkt, is eene kwezel Hy die't drinkt, is ras een ezel
Re: Record old passwords ?
Hi Tompkins, Check the below URL, looks like useful for your project. 20) set_password('username','hostname','oldpassword','newpassword'); (version 0.1.1) (version 0.1.4 added oldpassword) -- Changes password for any user (if current user is root), otherwise changes own password if current user is not root. can change the password up to 11times in 1 day and stores the last 5 passwords which were not changed for at least 24hrs. Does not permit the new password to be the same as any of the old passwords. Resets update count if more than 24hrs passed from last first update of the day. Password must be longer than '10 characters (configurable amount through sec_config.password_length)'. Complexity requirements are set on sec_config: 1. password_length_check 2. password_dictionary_check 3. password_lowercase_check 4. password_uppercase_check 5. password_number_check 6. password_special_character_check 7. password_username_check Root user doesn't need to abide to the above password restrictions when creating a new user since the latter will have to change the password and set one of his own. In order for a user to change one's old password, the user needs to supply the old password apart from the new one as well. For more details, check the below link http://code.google.com/p/securich/wiki/Documentation Thanks, Suresh Kuna MySQL DBA On Fri, Jan 22, 2010 at 11:52 PM, Tompkins Neil neil.tompk...@googlemail.com wrote: Hi Thanks for all the responses. In the end I opted for a separate UserPasswords table, which records all old passwords. When a user changes their password, this table is checked. NB All passwords are stored in SHA256. Thanks again for your advice. Regards Neil On Wed, Jan 20, 2010 at 12:08 PM, Jørn Dahl-Stamnes sq...@dahl-stamnes.netwrote: On Wednesday 20 January 2010 01:10, Daevid Vincent wrote: -Original Message- From: John Meyer [mailto:john.l.me...@gmail.com] Sent: Monday, January 18, 2010 5:04 PM To: co...@obviouslymalicious.com; mysql@lists.mysql.com Subject: Re: Record old passwords ? Although, on an OT, forcing people to not use a password that they have recently used is a bad idea. What they eventually do is go with something like hometown01 hometown02, etc. Or worse, they start writing down their passwords which is a whole other security problem. Amen to that. At my work, they require a password change every month, but they store the last 6 passwords you used, so I do exactly what you say -- I have a logbook and store the same 6 passwords in it and just cycle them. Other tricks I do, is use a pattern on the keyboard and just shift it. None of this is secure, and I totally know it (although I'm not picking secret or something as my PW, it's random letters/numbers/symbols). But I hate the policy and I'm kind of a rebel like that. ;-p Several years ago I worked at a place where users had to change their windows password every N month and they kept a long history log of used password. My solution to this was to write a program that asked me for my current password and how many previous used password the system remembered. The program worked like this: for (n = 0; no_of_stored_password n; n++) { set_password(random_generated_password); do_a_short_sleep(); } set_password(original_password); ... and the problem was solved :) -- Jørn Dahl-Stamnes homepage: http://www.dahl-stamnes.net/dahls/ -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/mysql?unsub=neil.tompk...@googlemail.com -- Thanks Suresh Kuna MySQL DBA
Re: Event feature already working in Server 5.1.37
Johan De Meersman wrote: On Tue, Jan 26, 2010 at 10:43 PM, Daevid Vincent dae...@daevid.com wrote: 12+ notebooks, netbooks, desktops, etc. But for any LAMP dev work, I either have a dedicated Linux box setup or a Virtual Machine. Well... It wouldn't be *Linux*-Apache-Mysql-PHP otherwise, would it :-) It would have to change to WIMP. It's not the best for marketing but we can't win them all. Windows - IIS - MySQL - PHP ;-) Some other production alternatives include: WIMA - Win, IIS, MySQL, ASP WAMP - Win, Apache, MySQL, PHP WWSHM - Win, Windows Scripting Host, MySQL WTM - Win, Tomcat, MySQL ... Are there other stacks on MS that you have heard of or are using? -- Shawn Green, MySQL Senior Support Engineer Sun Microsystems, Inc. Office: Blountville, TN -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/mysql?unsub=arch...@jab.org
RE: Event feature already working in Server 5.1.37
-Original Message- From: shawn.gr...@sun.com [mailto:shawn.gr...@sun.com] Sent: Wednesday, January 27, 2010 12:21 AM To: Daevid Vincent Cc: 'Dan Nelson'; mysql@lists.mysql.com Subject: Re: Event feature already working in Server 5.1.37 Daevid Vincent wrote: -Original Message- From: Dan Nelson [mailto:dnel...@allantgroup.com] Sent: Monday, January 25, 2010 11:42 PM To: Daevid Vincent ...snipped ... People really use Windows for a mySQL server? Weird. ... Yes, they do. Not only is MySQL as cheap as the free version of MS SQL but it doesn't suffer from the hard limits the free version of MS SQL imposes and it works across all of your servers, regardless of platform. MS products are limited to Windows boxes. You cannot assemble a new Linux box and get MS-anything to run on it natively. [JS] I second this. Instead of using a LAMP development environment, I went with WAMP -- even though our production environment was LAMP. It was a lot easier than setting up LAMP in a virtual machine. When we shut down our LAMP site for cost reasons, I moved it to a WAMP environment that I bought off the shelf for $800. For that money I got 8GB of RAM, four cores, and a RAID controller. Another $90 for a second drive, and I've got mirroring going. Granted, it's a low-traffic site used for internal administration; but I think this box could handle a lot more traffic than it does. It seems to be loafing all of the time. It's a home/SOHO/gamer system, so it probably isn't as physically robust as a server grade machine at twice the price; but if it dies, I can be up and running on a newer, bigger, cheaper machine in little more than the time it takes me to run to the nearest big-box store. Regards, Jerry Schwartz The Infoshop by Global Information Incorporated 195 Farmington Ave. Farmington, CT 06032 860.674.8796 / FAX: 860.674.8341 www.the-infoshop.com -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/mysql?unsub=arch...@jab.org
Re: Event feature already working in Server 5.1.37
In the last episode (Jan 27), Shawn Green said: It would have to change to WIMP. It's not the best for marketing but we can't win them all. Windows - IIS - MySQL - PHP ;-) Some other production alternatives include: WIMA - Win, IIS, MySQL, ASP WAMP - Win, Apache, MySQL, PHP WWSHM - Win, Windows Scripting Host, MySQL WTM - Win, Tomcat, MySQL ... Are there other stacks on MS that you have heard of or are using? WWJD - Windows, Websphere, Java, Derby? :) -- Dan Nelson dnel...@allantgroup.com -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/mysql?unsub=arch...@jab.org
Re: Event feature already working in Server 5.1.37
On Wed, Jan 27, 2010 at 5:52 PM, Jerry Schwartz jschwa...@the-infoshop.comwrote: [JS] I second this. Instead of using a LAMP development environment, I went with WAMP -- even though our production environment was LAMP. Generally a bad idea - you keep running into annoying minor differences between the systems. File paths, for example :-) It was a lot easier than setting up LAMP in a virtual machine. I'll set up up in under an hour, if you want :-) When we shut down our LAMP site for cost reasons, I moved it to a WAMP environment that I bought off the Wait. You shut down machines for cost reasons, and then go buy new ones ? shelf for $800. For that money I got 8GB of RAM, four cores, and a RAID controller. Another $90 for a second drive, and I've got mirroring going. Granted, it's a low-traffic site used for internal administration; but I think this box could handle a lot more traffic than it does. It seems to be loafing all of the time. Oh, probably. Webserving isn't all that hard of a job, if the site is reasonably well-designed. If you're implying that the LAMP setup you had earlier didn't perform quite as well, though, I'll go out on a leg and say that it probably wasn't managed very well. It's a home/SOHO/gamer system, so it probably isn't as physically robust as a server grade machine at twice the price; but if it dies, I can be up and running on a newer, bigger, cheaper machine in little more than the time it takes me to run to the nearest big-box store. True. Me and my server grade machine, however, will not have had that downtime, because I'll have been notified that a redundant component has failed, and will have replaced it while the machine was running. It's ultimately a matter of how much your uptime is worth to you, and keep in mind that on a saturday evening you may not even find a new machine until monday morning, and then you still have to start installing everything, not to mention find the latest backups of your data. Me, I'll go for the expensive server ones for my professional needs, thanks :-) -- Bier met grenadyn Is als mosterd by den wyn Sy die't drinkt, is eene kwezel Hy die't drinkt, is ras een ezel
Re: Event feature already working in Server 5.1.37
On Wed, Jan 27, 2010 at 6:10 PM, Dan Nelson dnel...@allantgroup.com wrote: WWJD - Windows, Websphere, Java, Derby? :) You are an evil, *evil* little man. I just spilled juice all over my keyboard. -- Bier met grenadyn Is als mosterd by den wyn Sy die't drinkt, is eene kwezel Hy die't drinkt, is ras een ezel
FW: Oracle Finalizes Acquisition of Sun
To ensure delivery directly to your inbox please add repl...@oracle-mail.com to your address book today. Oracle Corporation http://www.oracle.com/dm/global_images/oracle_white2.gif http://www.oracle.com/dm/10h2corp/o_sun_redbox_clr.gif We are pleased to announce that Oracle has completed its acquisition of Sun Microsystems and Sun is now a wholly owned subsidiary of Oracle. With this news, we want to reiterate our commitment to deliver complete, open and integrated systems that help our customers improve the performance, reliability and security of their IT infrastructure. We would also like to thank the many customers that have supported us throughout the acquisition process. There is no doubt that this combination transforms the IT industry. With the addition of servers, storage, SPARC processors, the Solaris operating system, Java, and the MySQL database to Oracle's portfolio of database, middleware, and business and industry applications, we plan to engineer and deliver open and integrated systems - from applications to disk - where all the pieces fit and work together out of the box. Performance levels will be unmatched. Oracle's software already runs faster on Sun SPARC/Solaris than on any other server or operating system. With Sun as a part of Oracle, each layer of the stack will be engineered to further improve performance, reliability and manageability so that IT will be more predictable, more supportable, and more secure. Customers will benefit as their system performance goes up and their system integration and management costs go down. In addition, our open standards-based technology will give customers choice. Customers can purchase our fully integrated systems, or easily integrate our best-of-breed technologies with their existing environments. Our open technology also enables customers to take full advantage of third party innovations. Oracle also plans to extend its partner specialization program to include Sun technologies to better enable partners to deliver differentiated and value-added solutions to customers. As always, our primary goal is 100% customer satisfaction. We are dedicated to delivering without interruption the quality of support and service that you have come to expect from Oracle and Sun, and more. Oracle plans to enhance Sun customer support by improving support access, offering better interoperability support between Oracle and Sun products and delivering services in more local languages. Support procedures for your existing Sun and Oracle products are unchanged, so for now you should continue to use the same channels you've been using. Customers can continue to purchase products from Sun in the same way they did prior to the acquisition. We will communicate any changes to this through regular channels. We are very excited about this combination and look forward to delivering to you increased innovation through accelerated investment in Sun's hardware and software technologies such as SPARC, Solaris, Java, and MySQL. If you weren't able to join the live event on January 27 where we, along with Larry Ellison and other executives from Oracle and Sun outlined how this powerful combination will transform the IT industry, you are welcome to view the replay that can be accessed at http://www.oracle.com/us/sun/index.htm?msgid=8480102eid=4676080696lid=1 oracle.com/sun. Sincerely, Charles Phillips President Safra Catz President This document is for informational purposes only and may not be incorporated into a contract or agreement. SOFTWARE. HARDWARE. COMPLETE. http://www.oracle.com/dm/design/softhardcompl_line.png Copyright C 2010, Oracle. All rights reserved. http://www.oracle.com/us/corporate/contact/index.htm?msgid=8480102eid=467 6080696lid=1 Contact Us | http://www.oracle.com/html/copyright.html?msgid=8480102eid=4676080696lid =1 Legal Notices and Terms of Use | http://www.oracle.com/html/privacy.html?msgid=8480102eid=4676080696lid=1 Privacy Statement Oracle Corporation - Worldwide Headquarters, 500 Oracle Parkway, OPL - E-mail Services, Redwood Shores, CA 94065, United States