分享
 
 
 

mod_auth_mysql的SHA512支持/Subversion共享用户库

王朝mysql·作者佚名  2008-05-18
窄屏简体版  字體: |||超大  

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>

 
 
 
免责声明:本文为网络用户发布,其观点仅代表作者个人观点,与本站无关,本站仅提供信息存储服务。文中陈述内容未经本站证实,其真实性、完整性、及时性本站不作任何保证或承诺,请读者仅作参考,并请自行核实相关内容。
2023年上半年GDP全球前十五强
 百态   2023-10-24
美众议院议长启动对拜登的弹劾调查
 百态   2023-09-13
上海、济南、武汉等多地出现不明坠落物
 探索   2023-09-06
印度或要将国名改为“巴拉特”
 百态   2023-09-06
男子为女友送行,买票不登机被捕
 百态   2023-08-20
手机地震预警功能怎么开?
 干货   2023-08-06
女子4年卖2套房花700多万做美容:不但没变美脸,面部还出现变形
 百态   2023-08-04
住户一楼被水淹 还冲来8头猪
 百态   2023-07-31
女子体内爬出大量瓜子状活虫
 百态   2023-07-25
地球连续35年收到神秘规律性信号,网友:不要回答!
 探索   2023-07-21
全球镓价格本周大涨27%
 探索   2023-07-09
钱都流向了那些不缺钱的人,苦都留给了能吃苦的人
 探索   2023-07-02
倩女手游刀客魅者强控制(强混乱强眩晕强睡眠)和对应控制抗性的关系
 百态   2020-08-20
美国5月9日最新疫情:美国确诊人数突破131万
 百态   2020-05-09
荷兰政府宣布将集体辞职
 干货   2020-04-30
倩女幽魂手游师徒任务情义春秋猜成语答案逍遥观:鹏程万里
 干货   2019-11-12
倩女幽魂手游师徒任务情义春秋猜成语答案神机营:射石饮羽
 干货   2019-11-12
倩女幽魂手游师徒任务情义春秋猜成语答案昆仑山:拔刀相助
 干货   2019-11-12
倩女幽魂手游师徒任务情义春秋猜成语答案天工阁:鬼斧神工
 干货   2019-11-12
倩女幽魂手游师徒任务情义春秋猜成语答案丝路古道:单枪匹马
 干货   2019-11-12
倩女幽魂手游师徒任务情义春秋猜成语答案镇郊荒野:与虎谋皮
 干货   2019-11-12
倩女幽魂手游师徒任务情义春秋猜成语答案镇郊荒野:李代桃僵
 干货   2019-11-12
倩女幽魂手游师徒任务情义春秋猜成语答案镇郊荒野:指鹿为马
 干货   2019-11-12
倩女幽魂手游师徒任务情义春秋猜成语答案金陵:小鸟依人
 干货   2019-11-12
倩女幽魂手游师徒任务情义春秋猜成语答案金陵:千金买邻
 干货   2019-11-12
 
推荐阅读
 
 
 
>>返回首頁<<
 
靜靜地坐在廢墟上,四周的荒凉一望無際,忽然覺得,淒涼也很美
© 2005- 王朝網路 版權所有