{"id":829,"date":"2008-06-01T01:48:32","date_gmt":"2008-06-01T06:48:32","guid":{"rendered":"http:\/\/www.bytebot.net\/blog\/?p=829"},"modified":"2008-06-01T01:50:34","modified_gmt":"2008-06-01T06:50:34","slug":"mod_auth_mysql-patched-to-work-with-phpass","status":"publish","type":"post","link":"http:\/\/www.bytebot.net\/blog\/archives\/2008\/06\/01\/mod_auth_mysql-patched-to-work-with-phpass","title":{"rendered":"mod_auth_mysql patched to work with phpass"},"content":{"rendered":"<p>Do you use <a href=\"http:\/\/modauthmysql.sourceforge.net\/\"><tt>mod_auth_mysql<\/tt><\/a>, the Apache module that allows authentication of users to happen through a MySQL database?<\/p>\n<p>If so, the nice folk at Automattic (makers of fine blogging software like <a href=\"http:\/\/wordpress.org\/\">WordPress<\/a>) have <a href=\"http:\/\/barry.wordpress.com\/2008\/05\/19\/mod_auth_mysql-and-phpass\/\">released a patched version<\/a> that works with <a href=\"http:\/\/www.openwall.com\/phpass\/\">phpass<\/a>.<\/p>\n<p>With this, you can now have single sign on (SSO), with authentication against a WordPress blog (or bbPress forum). Note that WordPress (in 2.5 and later), doesn&#8217;t use MD5 hashes to store passwords any longer; instead they are salted and hashed with the phpass library. The Automattic folk use this to provide SSO for Trac and Subversion.<\/p>\n<p>Read <a href=\"http:\/\/barry.wordpress.com\/2008\/05\/19\/mod_auth_mysql-and-phpass\/\">Barry&#8217;s announcement<\/a>, and grab the <a href=\"http:\/\/barry.files.wordpress.com\/2008\/05\/mod_auth_mysql-300-phpass.tgz\">patched mod_auth_mysql<\/a>.<\/p>\n<div class=\"sharedaddy sd-sharing-enabled\"><div class=\"robots-nocontent sd-block sd-social sd-social-icon-text sd-sharing\"><h3 class=\"sd-title\">Share this:<\/h3><div class=\"sd-content\"><ul><li class=\"share-email\"><a rel=\"nofollow noopener noreferrer\" data-shared=\"\" class=\"share-email sd-button share-icon\" href=\"mailto:?subject=%5BShared%20Post%5D%20mod_auth_mysql%20patched%20to%20work%20with%20phpass&body=http%3A%2F%2Fwww.bytebot.net%2Fblog%2Farchives%2F2008%2F06%2F01%2Fmod_auth_mysql-patched-to-work-with-phpass&share=email\" target=\"_blank\" title=\"Click to email a link to a friend\" data-email-share-error-title=\"Do you have email set up?\" data-email-share-error-text=\"If you&#039;re having problems sharing via email, you might not have email set up for your browser. You may need to create a new email yourself.\" data-email-share-nonce=\"2c168d40fb\" data-email-share-track-url=\"http:\/\/www.bytebot.net\/blog\/archives\/2008\/06\/01\/mod_auth_mysql-patched-to-work-with-phpass?share=email\"><span>Email<\/span><\/a><\/li><li class=\"share-facebook\"><a rel=\"nofollow noopener noreferrer\" data-shared=\"sharing-facebook-829\" class=\"share-facebook sd-button share-icon\" href=\"http:\/\/www.bytebot.net\/blog\/archives\/2008\/06\/01\/mod_auth_mysql-patched-to-work-with-phpass?share=facebook\" target=\"_blank\" title=\"Click to share on Facebook\" ><span>Facebook<\/span><\/a><\/li><li class=\"share-linkedin\"><a rel=\"nofollow noopener noreferrer\" data-shared=\"sharing-linkedin-829\" class=\"share-linkedin sd-button share-icon\" href=\"http:\/\/www.bytebot.net\/blog\/archives\/2008\/06\/01\/mod_auth_mysql-patched-to-work-with-phpass?share=linkedin\" target=\"_blank\" title=\"Click to share on LinkedIn\" ><span>LinkedIn<\/span><\/a><\/li><li class=\"share-twitter\"><a rel=\"nofollow noopener noreferrer\" data-shared=\"sharing-twitter-829\" class=\"share-twitter sd-button share-icon\" href=\"http:\/\/www.bytebot.net\/blog\/archives\/2008\/06\/01\/mod_auth_mysql-patched-to-work-with-phpass?share=twitter\" target=\"_blank\" title=\"Click to share on Twitter\" ><span>Twitter<\/span><\/a><\/li><li class=\"share-end\"><\/li><\/ul><\/div><\/div><\/div>","protected":false},"excerpt":{"rendered":"<p>Do you use mod_auth_mysql, the Apache module that allows authentication of users to happen through a MySQL database? If so, the nice folk at Automattic (makers of fine blogging software like WordPress) have released a patched version that works with phpass. With this, you can now have single sign on (SSO), with authentication against a [&hellip;]<\/p>\n<div class=\"sharedaddy sd-sharing-enabled\"><div class=\"robots-nocontent sd-block sd-social sd-social-icon-text sd-sharing\"><h3 class=\"sd-title\">Share this:<\/h3><div class=\"sd-content\"><ul><li class=\"share-email\"><a rel=\"nofollow noopener noreferrer\" data-shared=\"\" class=\"share-email sd-button share-icon\" href=\"mailto:?subject=%5BShared%20Post%5D%20mod_auth_mysql%20patched%20to%20work%20with%20phpass&body=http%3A%2F%2Fwww.bytebot.net%2Fblog%2Farchives%2F2008%2F06%2F01%2Fmod_auth_mysql-patched-to-work-with-phpass&share=email\" target=\"_blank\" title=\"Click to email a link to a friend\" data-email-share-error-title=\"Do you have email set up?\" data-email-share-error-text=\"If you&#039;re having problems sharing via email, you might not have email set up for your browser. You may need to create a new email yourself.\" data-email-share-nonce=\"2c168d40fb\" data-email-share-track-url=\"http:\/\/www.bytebot.net\/blog\/archives\/2008\/06\/01\/mod_auth_mysql-patched-to-work-with-phpass?share=email\"><span>Email<\/span><\/a><\/li><li class=\"share-facebook\"><a rel=\"nofollow noopener noreferrer\" data-shared=\"sharing-facebook-829\" class=\"share-facebook sd-button share-icon\" href=\"http:\/\/www.bytebot.net\/blog\/archives\/2008\/06\/01\/mod_auth_mysql-patched-to-work-with-phpass?share=facebook\" target=\"_blank\" title=\"Click to share on Facebook\" ><span>Facebook<\/span><\/a><\/li><li class=\"share-linkedin\"><a rel=\"nofollow noopener noreferrer\" data-shared=\"sharing-linkedin-829\" class=\"share-linkedin sd-button share-icon\" href=\"http:\/\/www.bytebot.net\/blog\/archives\/2008\/06\/01\/mod_auth_mysql-patched-to-work-with-phpass?share=linkedin\" target=\"_blank\" title=\"Click to share on LinkedIn\" ><span>LinkedIn<\/span><\/a><\/li><li class=\"share-twitter\"><a rel=\"nofollow noopener noreferrer\" data-shared=\"sharing-twitter-829\" class=\"share-twitter sd-button share-icon\" href=\"http:\/\/www.bytebot.net\/blog\/archives\/2008\/06\/01\/mod_auth_mysql-patched-to-work-with-phpass?share=twitter\" target=\"_blank\" title=\"Click to share on Twitter\" ><span>Twitter<\/span><\/a><\/li><li class=\"share-end\"><\/li><\/ul><\/div><\/div><\/div>","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"jetpack_post_was_ever_published":false,"jetpack_publicize_message":"","jetpack_is_tweetstorm":false,"jetpack_publicize_feature_enabled":true,"jetpack_social_options":[]},"categories":[23],"tags":[69,183,181,1775,182,52],"jetpack_publicize_connections":[],"jetpack_featured_media_url":"","jetpack_shortlink":"https:\/\/wp.me\/p4vJD-dn","jetpack_sharing_enabled":true,"jetpack-related-posts":[{"id":1481,"url":"http:\/\/www.bytebot.net\/blog\/archives\/2009\/05\/05\/barry-abrahamson-talks-about-wordpresscom-technicals","url_meta":{"origin":829,"position":0},"title":"Barry Abrahamson, talks about WordPress.com technicals","date":"5\/5\/2009","format":false,"excerpt":"While at the MySQL Conference, I caught up with Barry Abrahamson, the systems wrangler\/de-facto DBA behind Wordpress.com (and all other Automattic properties). Watch the video. You probably already know that Wordpress itself is built on top of MySQL. And despite everything you might have heard about our (MySQL\/Sun's) new founders,\u2026","rel":"","context":"In &quot;MySQL&quot;","img":{"alt_text":"","src":"","width":0,"height":0},"classes":[]},{"id":531,"url":"http:\/\/www.bytebot.net\/blog\/archives\/2007\/04\/24\/dotorg-wordpress-eventum-visits","url_meta":{"origin":829,"position":1},"title":"DotOrg: WordPress, Eventum visits","date":"24\/4\/2007","format":false,"excerpt":"I spoke to Matt and Barry today, and it was great to see them at the DotOrg Pavilion at the MySQL Expo, since the last time we caught up was at WordCamp 2006. Since WordCamp, Wordpress.com is now spanning something like 900,000+ registered users! That number used to be over\u2026","rel":"","context":"In &quot;MySQL&quot;","img":{"alt_text":"","src":"","width":0,"height":0},"classes":[]},{"id":2832,"url":"http:\/\/www.bytebot.net\/blog\/archives\/2013\/11\/30\/groonga-fulltext-search-library-for-cloud-web","url_meta":{"origin":829,"position":2},"title":"groonga &#8211; fulltext search library for cloud &#038; web","date":"30\/11\/2013","format":false,"excerpt":"This is an incomplete fragment from 2011. Figure its worth publishing this now, considering MariaDB is likely to get groonga in the near future. The groonga team have released MariaDB 10.0.6 binaries as well. This is all part of the mroonga\u00a0project. These were my quick notes from the groonga talk\u2026","rel":"","context":"In &quot;MariaDB&quot;","img":{"alt_text":"","src":"","width":0,"height":0},"classes":[]},{"id":777,"url":"http:\/\/www.bytebot.net\/blog\/archives\/2008\/04\/13\/gong-a-thong-at-lugradio-live-usa","url_meta":{"origin":829,"position":3},"title":"Gong-A-Thong at LugRadio Live USA","date":"13\/4\/2008","format":false,"excerpt":"The very brave soul, was Aaron Bockover, from the Banshee media player fame (via the LugRadio Live USA 2008 weblog). There were a few interesting highlights from these gong-a-thong sessions... Zumastor Dan Kegel spoke about the Zumastor Linux Storage Project. Want snapshots and remote replication in your Linux filesystem? This\u2026","rel":"","context":"In &quot;MySQL&quot;","img":{"alt_text":"","src":"","width":0,"height":0},"classes":[]},{"id":684,"url":"http:\/\/www.bytebot.net\/blog\/archives\/2007\/12\/18\/wordcamp-melbourne-making-money-with-wordpress-bbpress-caching-wordpress-sandbox","url_meta":{"origin":829,"position":4},"title":"WordCamp Melbourne: making money with WordPress, bbPress, caching, WordPress Sandbox","date":"18\/12\/2007","format":false,"excerpt":"On November 17 2007, I went to the inaugural WordCamp Melbourne. It was a truly interesting event - crowded, filled to the brim, and held at the pretty amazing Watermark Bar, in Docklands. It was a really warm day, and the only complaint would be that Watermark put is in\u2026","rel":"","context":"In &quot;General&quot;","img":{"alt_text":"","src":"","width":0,"height":0},"classes":[]},{"id":705,"url":"http:\/\/www.bytebot.net\/blog\/archives\/2008\/01\/28\/mysql-miniconf-starts","url_meta":{"origin":829,"position":5},"title":"MySQL Miniconf Starts!","date":"28\/1\/2008","format":false,"excerpt":"Arjen and Stewart are on stage, and there's an introduction session going on now. We're now, introducing the ex-MySQLers (Arjen), and MySQLers (Stewart, Giuseppe, me). Trent has just walked in, so that makes all the MySQLers that are around at linux.conf.au.Highlights of some of the attendees:A user from LG, who\u2026","rel":"","context":"In &quot;MySQL&quot;","img":{"alt_text":"","src":"","width":0,"height":0},"classes":[]}],"amp_enabled":true,"_links":{"self":[{"href":"http:\/\/www.bytebot.net\/blog\/wp-json\/wp\/v2\/posts\/829"}],"collection":[{"href":"http:\/\/www.bytebot.net\/blog\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"http:\/\/www.bytebot.net\/blog\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"http:\/\/www.bytebot.net\/blog\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"http:\/\/www.bytebot.net\/blog\/wp-json\/wp\/v2\/comments?post=829"}],"version-history":[{"count":0,"href":"http:\/\/www.bytebot.net\/blog\/wp-json\/wp\/v2\/posts\/829\/revisions"}],"wp:attachment":[{"href":"http:\/\/www.bytebot.net\/blog\/wp-json\/wp\/v2\/media?parent=829"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"http:\/\/www.bytebot.net\/blog\/wp-json\/wp\/v2\/categories?post=829"},{"taxonomy":"post_tag","embeddable":true,"href":"http:\/\/www.bytebot.net\/blog\/wp-json\/wp\/v2\/tags?post=829"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}