| 本文大部分内容系参考: http://confluence.atlassian.com/display/JIRAEXT/Integration+of+Jira+User+Management+with+Apache
mod_auth_mysql是一个apache的模块,用于保护某个目录或者一些资源.此模块可以使用保存在mysql数据库里的用户和密码以及组设置来校验用户的权限.
原文是针对mod_auth_mysql 2.8.1所做的补丁,由于3.0.0版本做了很多改动,所以只好改了一些地方,才顺利能用.
如果不打补丁,mod_auth_mysql 的安装其实非常简单:
1.从http://modauthmysql.sourceforge.net下载相应版本2.使用apache自带的apxs进行编译 正常情况下: apxs -c -lmysqlclient -lm -lz mod_auth_mysql.c 如果找不到mysql的头文件,试试(注意路径改为自己的正确路径) apxs -c -L/usr/lib/mysql -I/usr/include/mysql -lmysqlclient -lm -lz mod_auth_mysql.c 3.把模块安装到apache目录下
Apache 1.x: apxs -i mod_auth_mysql.so Apache 2.x: apxs -i mod_auth_mysql.la
4.修改httpd.conf配置文件,加上一行 LoadModule mysql_auth_module modules/mod_auth_mysql.so 5.按照需要配置 这个就要按照自己的情况配置了
6.重启apache mod_auth_mysql默认支持的密码加密方式包括:
none: 不加密 crypt: crypt() 方式加密 scrambled: MySQL PASSWORD 加密 md5: MD5 加密 aes: Advanced Encryption Standard (AES) 加密 sha1: Secure Hash Algorihm (SHA1) 加密
假设我们有subversion,一个论坛,或者其他一些需要利用apache认证的资源,那么我们就可以统一利用论坛的用户来做认证,这
样可以统一用户管理,用户修改信息也非常方便,否则修改密码就是一个大问题,还得提供额外的程序来进行修改密码,几个系统的用户统一问题也很头疼.
我的初衷就是让subversion使用别的系统的用户,整合用户.
只要原有的用户密码方式是以上几种,就很方便的整合,当然你也可以自己开发一些加密方式. :)
Atlassian公司的Jira和Confluence都是非常优秀的WEB软件,它们采用的加密方式都是SHA512,而mod_auth_mysql是不支持的,为了利用他们的用户,所以需要打补丁.也就是原文里面的目的.
针对3.0.0版本的SHA512补丁如下:
--- mod_auth_mysql-3.0.0\ori_mod_auth_mysql.c Thu Jun 23 00:17:46 2005+++ mod_auth_mysql-3.0.0\mod_auth_mysql.c Sun Dec 11 19:51:42 2005@@ -271,6 +270,269 @@ #include <my_aes.h> #endif ++#ifdef _SHA512+/*+ * SHA-512 code by Jean-Luc Cooke <jlcooke@certainkey.com>+ *+ * Copyright (c) Jean-Luc Cooke <jlcooke@certainkey.com>+ * Copyright (c) Andrew McDonald <andrew@mcdonald.org.uk>+ * Copyright (c) 2003 Kyle McMartin <kyle@debian.org>+ */++#define SHA512_DIGEST_SIZE 64++#define H0 0x6a09e667f3bcc908ULL+#define H1 0xbb67ae8584caa73bULL+#define H2 0x3c6ef372fe94f82bULL+#define H3 0xa54ff53a5f1d36f1ULL+#define H4 0x510e527fade682d1ULL+#define H5 0x9b05688c2b3e6c1fULL+#define H6 0x1f83d9abfb41bd6bULL+#define H7 0x5be0cd19137e2179ULL++#define e0(x) (ROR(x,28) ^ ROR(x,34) ^ ROR(x,39))+#define e1(x) (ROR(x,14) ^ ROR(x,18) ^ ROR(x,41))+#define s0(x) (ROR(x, 1) ^ ROR(x, 8) ^ (x >> 7))+#define s1(x) (ROR(x,19) ^ ROR(x,61) ^ (x >> 6))++typedef struct sha512_ctx {+ uint64_t state[8];+ uint32_t count[4];+ uint8_t buf[128];+} sha512_ctx;++static inline uint64_t CH(uint64_t x, uint64_t y, uint64_t z) {+ return ((x & y) ^ (~x & z));+}++static inline uint64_t MAJ(uint64_t x, uint64_t y, uint64_t z) {+ return ((x & y) ^ (x & z) ^ (y & z));+}++static inline uint64_t ROR(uint64_t x, uint64_t y) {+ return (x >> y) | (x << (64 - y));+}++static inline void LOA(int I, uint64_t *W, const uint8_t *input) {+ uint64_t t1 = input[(8*I) ] & 0xff;+ t1 <<= 8;+ t1 |= input[(8*I)+1] & 0xff;+ t1 <<= 8;+ t1 |= input[(8*I)+2] & 0xff;+ t1 <<= 8;+ t1 |= input[(8*I)+3] & 0xff;+ t1 <<= 8;+ t1 |= input[(8*I)+4] & 0xff;+ t1 <<= 8;+ t1 |= input[(8*I)+5] & 0xff;+ t1 <<= 8;+ t1 |= input[(8*I)+6] & 0xff;+ t1 <<= 8;+ t1 |= input[(8*I)+7] & 0xff;+ W[I] = t1;+}++static inline void MIX(int I, uint64_t *W) {+ W[I] = s1(W[I-2]) + W[I-7] + s0(W[I-15]) + W[I-16];+}++static const uint64_t sha512_K[80] = {+ 0x428a2f98d728ae22ULL, 0x7137449123ef65cdULL, 0xb5c0fbcfec4d3b2fULL,+ 0xe9b5dba58189dbbcULL, 0x3956c25bf348b538ULL, 0x59f111f1b605d019ULL,+ 0x923f82a4af194f9bULL, 0xab1c5ed5da6d8118ULL, 0xd807aa98a3030242ULL,+ 0x12835b0145706fbeULL, 0x243185be4ee4b28cULL, 0x550c7dc3d5ffb4e2ULL,+ 0x72be5d74f27b896fULL, 0x80deb1fe3b1696b1ULL, 0x9bdc06a725c71235ULL,+ 0xc19bf174cf692694ULL, 0xe49b69c19ef14ad2ULL, 0xefbe4786384f25e3ULL,+ 0x0fc19dc68b8cd5b5ULL, 0x240ca1cc77ac9c65ULL, 0x2de92c6f592b0275ULL,+ 0x4a7484aa6ea6e483ULL, 0x5cb0a9dcbd41fbd4ULL, 0x76f988da831153b5ULL,+ 0x983e5152ee66dfabULL, 0xa831c66d2db43210ULL, 0xb00327c898fb213fULL,+ 0xbf597fc7beef0ee4ULL, 0xc6e00bf33da88fc2ULL, 0xd5a79147930aa725ULL,+ 0x06ca6351e003826fULL, 0x142929670a0e6e70ULL, 0x27b70a8546d22ffcULL,+ 0x2e1b21385c26c926ULL, 0x4d2c6dfc5ac42aedULL, 0x53380d139d95b3dfULL,+ 0x650a73548baf63deULL, 0x766a0abb3c77b2a8ULL, 0x81c2c92e47edaee6ULL,+ 0x92722c851482353bULL, 0xa2bfe8a14cf10364ULL, 0xa81a664bbc423001ULL,+ 0xc24b8b70d0f89791ULL, 0xc76c51a30654be30ULL, 0xd192e819d6ef5218ULL,+ 0xd69906245565a910ULL, 0xf40e35855771202aULL, 0x106aa07032bbd1b8ULL,+ 0x19a4c116b8d2d0c8ULL, 0x1e376c085141ab53ULL, 0x2748774cdf8eeb99ULL,+ 0x34b0bcb5e19b48a8ULL, 0x391c0cb3c5c95a63ULL, 0x4ed8aa4ae3418acbULL,+ 0x5b9cca4f7763e373ULL, 0x682e6ff3d6b2b8a3ULL, 0x748f82ee5defb2fcULL,+ 0x78a5636f43172f60ULL, 0x84c87814a1f0ab72ULL, 0x8cc702081a6439ecULL,+ 0x90befffa23631e28ULL, 0xa4506cebde82bde9ULL, 0xbef9a3f7b2c67915ULL,+ 0xc67178f2e372532bULL, 0xca273eceea26619cULL, 0xd186b8c721c0c207ULL,+ 0xeada7dd6cde0eb1eULL, 0xf57d4f7fee6ed178ULL, 0x06f067aa72176fbaULL,+ 0x0a637dc5a2c898a6ULL, 0x113f9804bef90daeULL, 0x1b710b35131c471bULL,+ 0x28db77f523047d84ULL, 0x32caab7b40c72493ULL, 0x3c9ebe0a15c9bebcULL,+ 0x431d67c49c100d4cULL, 0x4cc5d4becb3e42b6ULL, 0x597f299cfc657e2aULL,+ 0x5fcb6fab3ad6faecULL, 0x6c44198c4a475817ULL,+};+++static void _transform(uint64_t *state, const uint8_t *input) {+ uint64_t a, b, c, d, e, f, g, h, t1, t2;+ uint64_t W[80];+ int i;++ /* load the input */+ for (i = 0; i < 16; i++) LOA(i, W, input);+ for (i = 16; i < 80; i++) MIX(i, W);++ /* load the state into our registers */+ a=state[0]; b=state[1]; c=state[2]; d=state[3];+ e=state[4]; f=state[5]; g=state[6]; h=state[7];++ /* now iterate */+ for (i=0; i<80; i+=8) {+ t1 = h + e1(e) + CH(e,f,g) + sha512_K[i ] + W[i ];+ t2 = e0(a) + MAJ(a,b,c); d+=t1; h=t1+t2;+ t1 = g + e1(d) + CH(d,e,f) + sha512_K[i+1] + W[i+1];+ t2 = e0(h) + MAJ(h,a,b); c+=t1; g=t1+t2;+ t1 = f + e1(c) + CH(c,d,e) + sha512_K[i+2] + W[i+2];+ t2 = e0(g) + MAJ(g,h,a); b+=t1; f=t1+t2;+ t1 = e + e1(b) + CH(b,c,d) + sha512_K[i+3] + W[i+3];+ t2 = e0(f) + MAJ(f,g,h); a+=t1; e=t1+t2;+ t1 = d + e1(a) + CH(a,b,c) + sha512_K[i+4] + W[i+4];+ t2 = e0(e) + MAJ(e,f,g); h+=t1; d=t1+t2;+ t1 = c + e1(h) + CH(h,a,b) + sha512_K[i+5] + W[i+5];+ t2 = e0(d) + MAJ(d,e,f); g+=t1; c=t1+t2;+ t1 = b + e1(g) + CH(g,h,a) + sha512_K[i+6] + W[i+6];+ t2 = e0(c) + MAJ(c,d,e); f+=t1; b=t1+t2;+ t1 = a + e1(f) + CH(f,g,h) + sha512_K[i+7] + W[i+7];+ t2 = e0(b) + MAJ(b,c,d); e+=t1; a=t1+t2;+ }++ state[0] += a; state[1] += b; state[2] += c; state[3] += d;+ state[4] += e; state[5] += f; state[6] += g; state[7] += h;++ /* erase our data */+ a = b = c = d = e = f = g = h = t1 = t2 = 0;+ memset(W, 0, 80 * sizeof(uint64_t));+}++static void sha512_init(void *ctx) {+ struct sha512_ctx *sctx = ctx;+ sctx->state[0] = H0;+ sctx->state[1] = H1;+ sctx->state[2] = H2;+ sctx->state[3] = H3;+ sctx->state[4] = H4;+ sctx->state[5] = H5;+ sctx->state[6] = H6;+ sctx->state[7] = H7;+ sctx->count[0] = sctx->count[1] = sctx->count[2] = sctx->count[3] = 0;+ memset(sctx->buf, 0, sizeof(sctx->buf));+}++static void sha512_update(void *ctx, const uint8_t *data, unsigned int len) {+ struct sha512_ctx *sctx = ctx;+ unsigned int i, index, part_len;++ /* Compute number of bytes mod 128 */+ index = (unsigned int)((sctx->count[0] >> 3) & 0x7F);++ /* Update number of bits */+ if ((sctx->count[0] += (len << 3)) < (len << 3)) {+ if ((sctx->count[1] += 1) < 1)+ if ((sctx->count[2] += 1) < 1)+ sctx->count[3]++;+ sctx->count[1] += (len >> 29);+ }++ part_len = 128 - index;++ /* Transform as many times as possible. */+ if (len >= part_len) {+ memcpy(&sctx->buf[index], data, part_len);+ _transform(sctx->state, sctx->buf);++ for (i = part_len; i + 127 < len; i+=128)+ _transform(sctx->state, &data[i]);++ index = 0;+ } else {+ i = 0;+ }++ /* Buffer remaining input */+ memcpy(&sctx->buf[index], &data[i], len - i);+}++static void sha512_final(void *ctx, uint8_t *hash) {+ struct sha512_ctx *sctx = ctx;+ const static uint8_t padding[128] = { 0x80, };++ uint32_t t;+ uint64_t t2;+ uint8_t bits[128];+ unsigned int index, pad_len;+ int i, j;++ index = pad_len = t = i = j = 0;+ t2 = 0;++ /* Save number of bits */+ t = sctx->count[0];+ bits[15] = t; t>>=8;+ bits[14] = t; t>>=8;+ bits[13] = t; t>>=8;+ bits[12] = t;+ t = sctx->count[1];+ bits[11] = t; t>>=8;+ bits[10] = t; t>>=8;+ bits[9 ] = t; t>>=8;+ bits[8 ] = t;+ t = sctx->count[2];+ bits[7 ] = t; t>>=8;+ bits[6 ] = t; t>>=8;+ bits[5 ] = t; t>>=8;+ bits[4 ] = t;+ t = sctx->count[3];+ bits[3 ] = t; t>>=8;+ bits[2 ] = t; t>>=8;+ bits[1 ] = t; t>>=8;+ bits[0 ] = t;++ /* Pad out to 112 mod 128. */+ index = (sctx->count[0] >> 3) & 0x7f;+ pad_len = (index < 112) ? (112 - index) : ((128+112) - index);+ sha512_update(sctx, padding, pad_len);++ /* Append length (before padding) */+ sha512_update(sctx, bits, 16);++ /* Store state in digest */+ for (i = j = 0; i < 8; i++, j += 8) {+ t2 = sctx->state[i];+ hash[j+7] = (char)t2 & 0xff; t2>>=8;+ hash[j+6] = (char)t2 & 0xff; t2>>=8;+ hash[j+5] = (char)t2 & 0xff; t2>>=8;+ hash[j+4] = (char)t2 & 0xff; t2>>=8;+ hash[j+3] = (char)t2 & 0xff; t2>>=8;+ hash[j+2] = (char)t2 & 0xff; t2>>=8;+ hash[j+1] = (char)t2 & 0xff; t2>>=8;+ hash[j ] = (char)t2 & 0xff;+ }++ /* Zeroize sensitive information. */+ memset(sctx, 0, sizeof(struct sha512_ctx));+}++static int sha512_hash(uint8_t *orig, int origlen, uint8_t *hash, int hashlen) {+ sha512_ctx context;++ if (hash == NULL) return -1;+ if (hashlen < SHA512_DIGEST_SIZE) return -1;++ sha512_init(&context);+ sha512_update(&context, orig, origlen);+ sha512_final(&context, hash);+ return(SHA512_DIGEST_SIZE);+}++#endif //_SHA512+++ #ifndef SCRAMBLED_PASSWORD_CHAR_LENGTH /* Ensure it is defined for older MySQL releases */ #define SCRAMBLED_PASSWORD_CHAR_LENGTH 32 /* Big enough for the old method of scrambling */ #endif@@ -287,6 +549,10 @@ #if _AES static short pw_aes(POOL * pool, const char * real_pw, const char * sent_pw, const char * salt); #endif+#ifdef _SHA512+static short pw_sha512(POOL * pool, const char * real_pw, const char * sent_pw, const char * salt);+#endif+ static short pw_sha1(POOL * pool, const char * real_pw, const char * sent_pw, const char * salt); static short pw_plain(POOL * pool, const char * real_pw, const char * sent_pw, const char * salt); @@ -318,6 +584,10 @@ #if _AES {"aes", SALT_REQUIRED, pw_aes}, #endif+#ifdef _SHA512+ {"sha512",NO_SALT,pw_sha512},+#endif+ {"sha1", NO_SALT, pw_sha1}}; typedef struct { /* User formatting patterns */ char pattern; /* Pattern to match */@@ -836,6 +1106,35 @@ return enc_len > 0 && memcmp(real_pw, encrypted_sent_pw, enc_len) == 0; } #endif++#ifdef _SHA512+/* checks sha512 passwords */+static short pw_sha512(POOL * pool, const char * real_pw, const char * sent_pw, const char * salt) {+ int res;+ short enc_len = 0;+ char *scrambled_sent_pw, *buffer=PCALLOC(pool, 128);+ + res = sha512_hash((uint8_t *)sent_pw, strlen(sent_pw), buffer, 128);+ if (res != SHA512_DIGEST_SIZE) + {+ /*+ LOG_ERROR(APLOG_NOERRNO|APLOG_ERR, 0, r, "auth_mysql: "+ "Internal error: SHA512 invalid digest size");+ */ + return (res == SHA512_DIGEST_SIZE );+ } + else + {+ enc_len = apr_base64_encode_len(SHA512_DIGEST_SIZE);+ scrambled_sent_pw = PCALLOC(pool, enc_len);+ enc_len = apr_base64_encode(scrambled_sent_pw, buffer, SHA512_DIGEST_SIZE);+ return (enc_len > 0 && memcmp(real_pw, scrambled_sent_pw, enc_len) == 0) ;+ }+ +}+#endif++ /* checks SHA1 passwords */ static short pw_sha1(POOL * pool, const char * real_pw, const char * sent_pw, const char * salt) {
注意打上补丁之后,apxs的编译参数要加上 -D_SHA512 ,否则是没有开启SHA512的.
编译安装好后,在配置里使用的加密方式为sha512.
下面的配置是我的subversion使用confluence用户库的例子(jira的例子在原文中有,参考修改即可)
<Location /svn> DAV svn SVNParentPath /svn
# our access control policy AuthzSVNAccessFile /config/svnaccess
# try anonymous access first, resort to real # authentication if necessary. Satisfy Any Require valid-user
# how to authenticate a user AuthType Basic AuthName "Subversion repository" AuthMySQLEnable on
# For TCP/IP AuthMySQLHost localhost AuthMySQLPort 3306 AuthMySQLUser confluence AuthMySQLPassword password AuthMySQLDB confluence AuthMySQLUserTable os_user AuthMySQLGroupTable os_user,os_group,os_user_group AuthMySQLGroupCondition "os_user.id=os_user_group.user_id and os_group.id=os_user_group.group_id " AuthMySQLNameField username AuthMySqlGroupField groupname AuthMySQLPasswordField passwd AuthMySQLPwEncryption sha512 AuthMySQLAuthoritative On </Location>
|
