mysql:2707
From: tateyan <tateyan <tateyan@xxxxxxxxxx>>
Date: Fri, 17 Nov 2000 02:42:03 +0900
Subject: [mysql 02707] ¥¢¥«¥¦¥ó¥È´ÉÍý
¤¿¤Æ¤ä¤ó¤Ç¤¹ ÌÌÇò¤¤¥Ä¡¼¥ë¡¡¸«¤Ã¤±¤Æ»È¤¨¤¿¤ó¤Ç¡¡¤´Êó¹ð¤Ç¤· Freshmeat-J ¤Ç¸«¤Ä¤±¤¿¤Î¤Ç¤¹¤¬ nss-mysql 0.22 http://sourceforge.net/projects/nss-mysql/ Ä̾/etc/passwd /etc/shadow /etc/groups ¥Õ¥¡¥¤¥ë¤Ç¹Ô¤Ã¤Æ¤¤¤ë ¤â¤Î¤ò¡¡MySQL ¤Ç¤ä¤Ã¤Á¤ã¤ª¡¡¤Ã¤Æ¤À¤±¤Ç¤¹¤¬¡¡(^^¡¶ ¤Á¤ç¤Ã¤È¤Î»þ´Ö¤Ç»È¤¨¤ë¤è¤¦¤Ë¤Ê¤ê¤Þ¤·¤¿ µ¤¤ò¤Ä¤±¤ëÅÀ¤È¤·¤Æ¤Ï¡¡¥µ¥ó¥×¥ë¥Ñ¥¹¥ï¡¼¥É¤Ï MD5 ¤Ç¤¹¤¬ »ä¤ÏLinux ¤ò»È¤Ã¤¤¤ë¤ó¤Ç crypt ¤Î¥Ñ¥¹¥ï¡¼¥É¤Ç»È¤Ã¤Æ¤ß¤Þ¤·¤¿ ¤¢¤È¥µ¥ó¥×¥ë¤Î¥Ç¡¼¥¿¥Ù¡¼¥¹Ì¾¤¬ nss-mysql ¤Ë¤Ê¤Ã¤Æ¤¿¤Î¤Ç¤¹¤¬ - ¤¬¤¢¤ë¤¿¤á¤«¥Ç¡¼¥¿¥Ù¡¼¥¹¤ÏºîÀ®¤Ç¤¤Þ¤»¤ó¤Ç¤·¤¿ nssmysql ¤ËÊѹ¹¤·¤Þ¤·¤¿ ./configure --enable-group --enable-shadow \ --enable-default_home=/home --enable-default_group=2001 ¤È¤·¤¿¤¢¤È¡¡»ä¤Î¾ì¹ç¡¡/usr/local/lib/mysql ¤Ë libmysqlclient.a¡¡¤¬¤¢¤ë¤¿¤á¡¡Makefile¤Î22¹ÔÌÜ -lmysqlclient¤ÎÁ°¤Ë-L/usr/local/lib/mysql ¤òÄɲä·¤Þ¤·¤¿ $(SHARED_OBJECT): $(OBJECTS) gcc $(CFLAGS) -shared -o $(SHARED_OBJECT) -Wl,-soname,$(SHARED_OBJECT) \ $(OBJECTS) -L/usr/local/lib/mysql -lmysqlclient -lc ¤Ç¥¤¥ó¥¹¥È¡¼¥ë /etc/nsswitch.conf¡¡¤òINSTALL ¤Ë¤¢¤ë¤è¤¦¤Ë passwd: files mysql group: files mysql shadow: files mysql ¤½¤·¤Æ /etc/nss-mysql-root.conf¤È/etc/nss-mysql.conf ¤ò¼«Ê¬¤Î´Ä¶¤Ë¹ç¤ï¤»¤¿¤é¡¡¤Á¤ã¤ó¤È¥í¥°¥¤¥ó¤Ç¤¤ë¤è¤¦¤Ë¤Ê¤ê¤Þ¤·¤¿¡¡(^,^) /etc/nsswitch.conf¡¡¤ò¤¤¤¸¤ë¤Î¤Ï¤Á¤ç¤¤¤Èͦµ¤¤¬Íפê¤Þ¤·¤¿¤±¤É... ¡ô¥í¥°¥¤¥ó¤Ç¤¤Ê¤¯¤Ê¤Ã¤¿¤³¤È¤¢¤ë¤ó¤À¤â¤Î¤© ¤¢¤È¡¡¥µ¥ó¥×¥ë¤Ç¤¢¤Ã¤¿table groups¤â¡¡¼ã´³¡¡status ¤òÄɲä·¤Þ¤·¤¿ ¤½¤ì¤Ç¡¡·ë¶É¥Æ¡¼¥Ö¥ë¤Ï¡¡°Ê²¼¤Î¤è¤¦¤Ë¤Ê¤ê¤Þ¤·¤¿ status ¹àÌܤϡ¡'A'¤È¤¤¤¦Ê¸»ú¡Ê¥¢¥¯¥Æ¥£¥Ö¡Ë¤Ë¤Ê¤Ã¤Æ¤¤¤Ê¤±¤ì¤Ð͸ú ¤Ë¤Ê¤ê¤Þ¤»¤ó¤Ç¤·¤¿ CREATE TABLE user ( user_id int(11) NOT NULL auto_increment, user_name text NOT NULL, realname varchar(32) NOT NULL, shell varchar(20) DEFAULT '/bin/bash' NOT NULL, password varchar(40) NOT NULL, status char(1) DEFAULT 'N' NOT NULL, uid int(11) DEFAULT '0' NOT NULL, PRIMARY KEY (user_id) ); CREATE TABLE groups ( group_id int(11) NOT NULL auto_increment, group_name varchar(30), status char(1) DEFAULT 'N' NOT NULL, PRIMARY KEY (group_id) ); CREATE TABLE user_group ( user_id int(11) DEFAULT '0' NOT NULL, group_id int(11) DEFAULT '0' NOT NULL ); ¤Ê¤ó¤«¤Ë¡¡±þÍѤǤ¤½¤¦¤Ç¤¹¤Í¡¡¡³(¡¢¦¡®)/¤Ø¤Ø¤Ã ¤¢¤È¤Ï¡¡postfix ¤ÎMysql¤Î¥¨¥¤¥ê¥¢¥¹¤¬¤¦¤Þ¤¯»È¤¨¤ë¤è¤¦¤Ë¤Ê¤ì¤Ð ´°àú¤À¤Ê¤¡ ¥á¡¼¥ë¥µ¡¼¥Ð¤Ë postfix¡¡¤Ï·ë¹½¤è¤¤¤Ç¤¹¤è ¤Ê¤Ë¤è¤ê¡¡MySQL ¤òmysql map type¡¡¤È¤·¤Æ»È¤¨¤ë¤È¤¤¤¦¤³¤È¤Ç¤¹ ¹«¤Ç¤Ï¡¡PostgreSQL¤Î¡¡»ÙÉô¤¬¤Ç¤¤Ä¤Ä¤¢¤ë¤ó¤Ç¤¹¤Í¤§ Ë̳¤Æ»»ÙÉô¤â¤Þ¤â¤Ê¤¯¤Ç¤¤ë¤è¤¦¤Ç¤¹ ¤Á¤ç¤Ã¤È¡¡¤¦¤é¤ä¤Þ¤·¤¤¤Ç¤¹^^; ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~ ×Ä×Äк ¤¿¤Æ¤ä¤ó¤Ã¤¹ d¢¢/¢¢-£â <tateyan@xxxxxxxxxx> ¡³"¡¼"Ш
-> 2707 2000-11-17 02:42 [tateyan <tateyan@xxx] ¥¢¥«¥¦¥ó¥È´ÉÍý 2710 2000-11-18 21:12 ¨²[Tatsuo Hiramatsu <ta] 2711 2000-11-19 00:32 ¨¨²[¤È¤ß¤¿¤Þ¤µ¤Ò¤í <tomm] 2712 2000-11-19 00:50 ¨¨±[inano <inano@xxxxxxx] 2721 2000-11-19 19:25 ¨¡¡¨±[Tatsuo Hiramatsu <ta] Ê¡²¬»ÙÉô¡© 2726 2000-11-21 14:29 ¨¡¡¡¡¨²[Tatsuo Hiramatsu <ta] 2727 2000-11-21 15:37 ¨¡¡¡¡¨±[Tatsuo Hiramatsu <ta] 2730 2000-11-24 11:53 ¨¡¡¡¡¡¡¨±[Michiaki Mitachi <mi] 2731 2000-11-24 14:14 ¨¡¡¡¡¡¡¡¡¨±[Tatsuo Hiramatsu <ta] 2732 2000-11-24 20:55 ¨¡¡¡¡¡¡¡¡¡¡¨±[inano <inano@xxxxxxx] 2734 2000-11-25 19:14 ¨¡¡¡¡¡¡¡¡¡¡¡¡¨±[Tatsuo Hiramatsu <ta] @ 4168 2001-08-13 20:06 ¨±[Yasuhide OMORI / Âç¿] nss-mysql ¤Ë¤è¤ëǧ¾Ú (Re: ¥¢¥«¥¦¥ó¥È´ÉÍý) 4169 2001-08-13 22:40 ¡¡¨±[tateyan <tateyan@xxx] 4170 2001-08-13 23:04 ¡¡¡¡¨±[tateyan <tateyan@xxx] 4176 2001-08-16 11:32 ¡¡¡¡¡¡¨±[Yasuhide OMORI / Âç¿] 4178 2001-08-16 20:17 ¡¡¡¡¡¡¡¡¨²[¤È¤ß¤¿¤Þ¤µ¤Ò¤í <tomm] 4181 2001-08-17 08:52 ¡¡¡¡¡¡¡¡¨¨±[Yasuhide OMORI / Âç¿] 4180 2001-08-17 00:59 ¡¡¡¡¡¡¡¡¨±[tateyan <tateyan@xxx] 4182 2001-08-17 09:11 ¡¡¡¡¡¡¡¡¡¡¨±[Yasuhide OMORI / Âç¿] 4183 2001-08-17 12:46 ¡¡¡¡¡¡¡¡¡¡¡¡¨±[Seiji Tateyama <tate] 4184 2001-08-17 23:04 ¡¡¡¡¡¡¡¡¡¡¡¡¡¡¨±[tateyan <tateyan@xxx]