[Á°][¼¡][ÈÖ¹æ½ç°ìÍ÷][¥¹¥ì¥Ã¥É°ìÍ÷]

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]